001
014
015 package com.liferay.portal.upgrade.v6_2_0.util;
016
017 import java.sql.Types;
018
019
023 public class LayoutSetTable {
024
025 public static final String TABLE_NAME = "LayoutSet";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"layoutSetId", Types.BIGINT},
029 {"groupId", Types.BIGINT},
030 {"companyId", Types.BIGINT},
031 {"createDate", Types.TIMESTAMP},
032 {"modifiedDate", Types.TIMESTAMP},
033 {"privateLayout", Types.BOOLEAN},
034 {"logo", Types.BOOLEAN},
035 {"logoId", Types.BIGINT},
036 {"themeId", Types.VARCHAR},
037 {"colorSchemeId", Types.VARCHAR},
038 {"wapThemeId", Types.VARCHAR},
039 {"wapColorSchemeId", Types.VARCHAR},
040 {"css", Types.CLOB},
041 {"pageCount", Types.INTEGER},
042 {"settings_", Types.CLOB},
043 {"layoutSetPrototypeUuid", Types.VARCHAR},
044 {"layoutSetPrototypeLinkEnabled", Types.BOOLEAN}
045 };
046
047 public static final String TABLE_SQL_CREATE = "create table LayoutSet (layoutSetId LONG not null primary key,groupId LONG,companyId LONG,createDate DATE null,modifiedDate DATE null,privateLayout BOOLEAN,logo BOOLEAN,logoId LONG,themeId VARCHAR(75) null,colorSchemeId VARCHAR(75) null,wapThemeId VARCHAR(75) null,wapColorSchemeId VARCHAR(75) null,css TEXT null,pageCount INTEGER,settings_ TEXT null,layoutSetPrototypeUuid VARCHAR(75) null,layoutSetPrototypeLinkEnabled BOOLEAN)";
048
049 public static final String TABLE_SQL_DROP = "drop table LayoutSet";
050
051 public static final String[] TABLE_SQL_ADD_INDEXES = {
052 "create index IX_A40B8BEC on LayoutSet (groupId)",
053 "create unique index IX_48550691 on LayoutSet (groupId, privateLayout)",
054 "create index IX_72BBA8B7 on LayoutSet (layoutSetPrototypeUuid)"
055 };
056
057 }