001
014
015 package com.liferay.portal.upgrade.v7_0_0.util;
016
017 import java.sql.Types;
018
019
023 public class JournalArticleTable {
024
025 public static final String TABLE_NAME = "JournalArticle";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", Types.VARCHAR},
029 {"id_", Types.BIGINT},
030 {"resourcePrimKey", Types.BIGINT},
031 {"groupId", Types.BIGINT},
032 {"companyId", Types.BIGINT},
033 {"userId", Types.BIGINT},
034 {"userName", Types.VARCHAR},
035 {"createDate", Types.TIMESTAMP},
036 {"modifiedDate", Types.TIMESTAMP},
037 {"folderId", Types.BIGINT},
038 {"classNameId", Types.BIGINT},
039 {"classPK", Types.BIGINT},
040 {"treePath", Types.VARCHAR},
041 {"articleId", Types.VARCHAR},
042 {"version", Types.DOUBLE},
043 {"title", Types.VARCHAR},
044 {"urlTitle", Types.VARCHAR},
045 {"description", Types.CLOB},
046 {"content", Types.CLOB},
047 {"DDMStructureKey", Types.VARCHAR},
048 {"DDMTemplateKey", Types.VARCHAR},
049 {"layoutUuid", Types.VARCHAR},
050 {"displayDate", Types.TIMESTAMP},
051 {"expirationDate", Types.TIMESTAMP},
052 {"reviewDate", Types.TIMESTAMP},
053 {"indexable", Types.BOOLEAN},
054 {"smallImage", Types.BOOLEAN},
055 {"smallImageId", Types.BIGINT},
056 {"smallImageURL", Types.VARCHAR},
057 {"status", Types.INTEGER},
058 {"statusByUserId", Types.BIGINT},
059 {"statusByUserName", Types.VARCHAR},
060 {"statusDate", Types.TIMESTAMP}
061 };
062
063 public static final String TABLE_SQL_CREATE = "create table JournalArticle (uuid_ VARCHAR(75) null,id_ LONG not null primary key,resourcePrimKey LONG,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,folderId LONG,classNameId LONG,classPK LONG,treePath STRING null,articleId VARCHAR(75) null,version DOUBLE,title STRING null,urlTitle VARCHAR(150) null,description TEXT null,content TEXT null,DDMStructureKey VARCHAR(75) null,DDMTemplateKey VARCHAR(75) null,layoutUuid VARCHAR(75) null,displayDate DATE null,expirationDate DATE null,reviewDate DATE null,indexable BOOLEAN,smallImage BOOLEAN,smallImageId LONG,smallImageURL STRING null,status INTEGER,statusByUserId LONG,statusByUserName VARCHAR(75) null,statusDate DATE null)";
064
065 public static final String TABLE_SQL_DROP = "drop table JournalArticle";
066
067 public static final String[] TABLE_SQL_ADD_INDEXES = {
068 "create index IX_17806804 on JournalArticle (DDMStructureKey)",
069 "create index IX_75CCA4D1 on JournalArticle (DDMTemplateKey)",
070 "create index IX_C761B675 on JournalArticle (classNameId, DDMTemplateKey)",
071 "create index IX_323DF109 on JournalArticle (companyId, status)",
072 "create index IX_E82F322B on JournalArticle (companyId, version, status)",
073 "create index IX_EA05E9E1 on JournalArticle (displayDate, status)",
074 "create index IX_D8EB0D84 on JournalArticle (groupId, DDMStructureKey)",
075 "create index IX_31B74F51 on JournalArticle (groupId, DDMTemplateKey)",
076 "create index IX_4D5CD982 on JournalArticle (groupId, articleId, status)",
077 "create unique index IX_85C52EEC on JournalArticle (groupId, articleId, version)",
078 "create index IX_353BD560 on JournalArticle (groupId, classNameId, DDMStructureKey)",
079 "create index IX_6E801BF5 on JournalArticle (groupId, classNameId, DDMTemplateKey)",
080 "create index IX_9CE6E0FA on JournalArticle (groupId, classNameId, classPK)",
081 "create index IX_A2534AC2 on JournalArticle (groupId, classNameId, layoutUuid)",
082 "create index IX_F35391E8 on JournalArticle (groupId, folderId, status)",
083 "create index IX_3C028C1E on JournalArticle (groupId, layoutUuid)",
084 "create index IX_301D024B on JournalArticle (groupId, status)",
085 "create index IX_D2D249E8 on JournalArticle (groupId, urlTitle, status)",
086 "create index IX_43A0F80F on JournalArticle (groupId, userId, classNameId)",
087 "create index IX_3F1EA19E on JournalArticle (layoutUuid)",
088 "create index IX_451D63EC on JournalArticle (resourcePrimKey, indexable, status)",
089 "create index IX_3E2765FC on JournalArticle (resourcePrimKey, status)",
090 "create index IX_EF9B7028 on JournalArticle (smallImageId)",
091 "create index IX_71520099 on JournalArticle (uuid_, companyId)",
092 "create unique index IX_3463D95B on JournalArticle (uuid_, groupId)"
093 };
094
095 }