001
014
015 package com.liferay.portal.upgrade.v5_0_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 {"privateLayout", Types.BOOLEAN},
032 {"logo", Types.BOOLEAN},
033 {"logoId", Types.BIGINT},
034 {"themeId", Types.VARCHAR},
035 {"colorSchemeId", Types.VARCHAR},
036 {"wapThemeId", Types.VARCHAR},
037 {"wapColorSchemeId", Types.VARCHAR},
038 {"css", Types.VARCHAR},
039 {"pageCount", Types.INTEGER},
040 {"virtualHost", Types.VARCHAR}
041 };
042
043 public static final String TABLE_SQL_CREATE = "create table LayoutSet (layoutSetId LONG not null primary key,groupId LONG,companyId LONG,privateLayout BOOLEAN,logo BOOLEAN,logoId LONG,themeId VARCHAR(75) null,colorSchemeId VARCHAR(75) null,wapThemeId VARCHAR(75) null,wapColorSchemeId VARCHAR(75) null,css STRING null,pageCount INTEGER,virtualHost VARCHAR(75) null)";
044
045 public static final String TABLE_SQL_DROP = "drop table LayoutSet";
046
047 public static final String[] TABLE_SQL_ADD_INDEXES = {
048 "create index IX_A40B8BEC on LayoutSet (groupId)",
049 "create index IX_48550691 on LayoutSet (groupId, privateLayout)",
050 "create index IX_5ABC2905 on LayoutSet (virtualHost)"
051 };
052
053 }