001
014
015 package com.liferay.portal.upgrade.v6_2_0.util;
016
017 import java.sql.Types;
018
019
023 public class LayoutTable {
024
025 public static final String TABLE_NAME = "Layout";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", Types.VARCHAR},
029 {"plid", Types.BIGINT},
030 {"groupId", Types.BIGINT},
031 {"companyId", Types.BIGINT},
032 {"userId", Types.BIGINT},
033 {"userName", Types.VARCHAR},
034 {"createDate", Types.TIMESTAMP},
035 {"modifiedDate", Types.TIMESTAMP},
036 {"privateLayout", Types.BOOLEAN},
037 {"layoutId", Types.BIGINT},
038 {"parentLayoutId", Types.BIGINT},
039 {"name", Types.VARCHAR},
040 {"title", Types.VARCHAR},
041 {"description", Types.VARCHAR},
042 {"keywords", Types.VARCHAR},
043 {"robots", Types.VARCHAR},
044 {"type_", Types.VARCHAR},
045 {"typeSettings", Types.CLOB},
046 {"hidden_", Types.BOOLEAN},
047 {"friendlyURL", Types.VARCHAR},
048 {"iconImage", Types.BOOLEAN},
049 {"iconImageId", Types.BIGINT},
050 {"themeId", Types.VARCHAR},
051 {"colorSchemeId", Types.VARCHAR},
052 {"wapThemeId", Types.VARCHAR},
053 {"wapColorSchemeId", Types.VARCHAR},
054 {"css", Types.CLOB},
055 {"priority", Types.INTEGER},
056 {"layoutPrototypeUuid", Types.VARCHAR},
057 {"layoutPrototypeLinkEnabled", Types.BOOLEAN},
058 {"sourcePrototypeLayoutUuid", Types.VARCHAR}
059 };
060
061 public static final String TABLE_SQL_CREATE = "create table Layout (uuid_ VARCHAR(75) null,plid LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,privateLayout BOOLEAN,layoutId LONG,parentLayoutId LONG,name STRING null,title STRING null,description STRING null,keywords STRING null,robots STRING null,type_ VARCHAR(75) null,typeSettings TEXT null,hidden_ BOOLEAN,friendlyURL VARCHAR(255) null,iconImage BOOLEAN,iconImageId LONG,themeId VARCHAR(75) null,colorSchemeId VARCHAR(75) null,wapThemeId VARCHAR(75) null,wapColorSchemeId VARCHAR(75) null,css TEXT null,priority INTEGER,layoutPrototypeUuid VARCHAR(75) null,layoutPrototypeLinkEnabled BOOLEAN,sourcePrototypeLayoutUuid VARCHAR(75) null)";
062
063 public static final String TABLE_SQL_DROP = "drop table Layout";
064
065 public static final String[] TABLE_SQL_ADD_INDEXES = {
066 "create index IX_C7FBC998 on Layout (companyId)",
067 "create index IX_C099D61A on Layout (groupId)",
068 "create index IX_705F5AA3 on Layout (groupId, privateLayout)",
069 "create unique index IX_BC2C4231 on Layout (groupId, privateLayout, friendlyURL)",
070 "create unique index IX_7162C27C on Layout (groupId, privateLayout, layoutId)",
071 "create index IX_6DE88B06 on Layout (groupId, privateLayout, parentLayoutId)",
072 "create index IX_8CE8C0D9 on Layout (groupId, privateLayout, sourcePrototypeLayoutUuid)",
073 "create index IX_1A1B61D2 on Layout (groupId, privateLayout, type_)",
074 "create index IX_23922F7D on Layout (iconImageId)",
075 "create index IX_B529BFD3 on Layout (layoutPrototypeUuid)",
076 "create index IX_39A18ECC on Layout (sourcePrototypeLayoutUuid)",
077 "create index IX_D0822724 on Layout (uuid_)",
078 "create index IX_2CE4BE84 on Layout (uuid_, companyId)",
079 "create unique index IX_E118C537 on Layout (uuid_, groupId, privateLayout)"
080 };
081
082 }