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 {"type_", Types.VARCHAR},
048 {"structureId", Types.VARCHAR},
049 {"templateId", Types.VARCHAR},
050 {"layoutUuid", Types.VARCHAR},
051 {"displayDate", Types.TIMESTAMP},
052 {"expirationDate", Types.TIMESTAMP},
053 {"reviewDate", Types.TIMESTAMP},
054 {"indexable", Types.BOOLEAN},
055 {"smallImage", Types.BOOLEAN},
056 {"smallImageId", Types.BIGINT},
057 {"smallImageURL", Types.VARCHAR},
058 {"status", Types.INTEGER},
059 {"statusByUserId", Types.BIGINT},
060 {"statusByUserName", Types.VARCHAR},
061 {"statusDate", Types.TIMESTAMP}
062 };
063
064 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,type_ VARCHAR(75) null,structureId VARCHAR(75) null,templateId 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)";
065
066 public static final String TABLE_SQL_DROP = "drop table JournalArticle";
067
068 public static final String[] TABLE_SQL_ADD_INDEXES = {
069 "create index IX_323DF109 on JournalArticle (companyId, status)",
070 "create index IX_E82F322B on JournalArticle (companyId, version, status)",
071 "create index IX_EA05E9E1 on JournalArticle (displayDate, status)",
072 "create index IX_4D5CD982 on JournalArticle (groupId, articleId, status)",
073 "create unique index IX_85C52EEC on JournalArticle (groupId, articleId, version)",
074 "create index IX_9CE6E0FA on JournalArticle (groupId, classNameId, classPK)",
075 "create index IX_A2534AC2 on JournalArticle (groupId, classNameId, layoutUuid)",
076 "create index IX_91E78C35 on JournalArticle (groupId, classNameId, structureId)",
077 "create index IX_F43B9FF2 on JournalArticle (groupId, classNameId, templateId)",
078 "create index IX_F35391E8 on JournalArticle (groupId, folderId, status)",
079 "create index IX_3C028C1E on JournalArticle (groupId, layoutUuid)",
080 "create index IX_301D024B on JournalArticle (groupId, status)",
081 "create index IX_2E207659 on JournalArticle (groupId, structureId)",
082 "create index IX_8DEAE14E on JournalArticle (groupId, templateId)",
083 "create index IX_D2D249E8 on JournalArticle (groupId, urlTitle, status)",
084 "create index IX_43A0F80F on JournalArticle (groupId, userId, classNameId)",
085 "create index IX_3F1EA19E on JournalArticle (layoutUuid)",
086 "create index IX_451D63EC on JournalArticle (resourcePrimKey, indexable, status)",
087 "create index IX_3E2765FC on JournalArticle (resourcePrimKey, status)",
088 "create index IX_EF9B7028 on JournalArticle (smallImageId)",
089 "create index IX_8E8710D9 on JournalArticle (structureId)",
090 "create index IX_9106F6CE on JournalArticle (templateId)",
091 "create index IX_71520099 on JournalArticle (uuid_, companyId)",
092 "create unique index IX_3463D95B on JournalArticle (uuid_, groupId)"
093 };
094
095 }