1
14
15 package com.liferay.portal.upgrade.v6_0_0.util;
16
17 import java.sql.Types;
18
19
25 public class LayoutTable {
26
27 public static final String TABLE_NAME = "Layout";
28
29 public static final Object[][] TABLE_COLUMNS = {
30 {"plid", new Integer(Types.BIGINT)},
31 {"groupId", new Integer(Types.BIGINT)},
32 {"companyId", new Integer(Types.BIGINT)},
33 {"privateLayout", new Integer(Types.BOOLEAN)},
34 {"layoutId", new Integer(Types.BIGINT)},
35 {"parentLayoutId", new Integer(Types.BIGINT)},
36 {"name", new Integer(Types.VARCHAR)},
37 {"title", new Integer(Types.VARCHAR)},
38 {"description", new Integer(Types.VARCHAR)},
39 {"type_", new Integer(Types.VARCHAR)},
40 {"typeSettings", new Integer(Types.CLOB)},
41 {"hidden_", new Integer(Types.BOOLEAN)},
42 {"friendlyURL", new Integer(Types.VARCHAR)},
43 {"iconImage", new Integer(Types.BOOLEAN)},
44 {"iconImageId", new Integer(Types.BIGINT)},
45 {"themeId", new Integer(Types.VARCHAR)},
46 {"colorSchemeId", new Integer(Types.VARCHAR)},
47 {"wapThemeId", new Integer(Types.VARCHAR)},
48 {"wapColorSchemeId", new Integer(Types.VARCHAR)},
49 {"css", new Integer(Types.VARCHAR)},
50 {"priority", new Integer(Types.INTEGER)},
51 {"layoutPrototypeId", new Integer(Types.BIGINT)},
52 {"dlFolderId", new Integer(Types.BIGINT)}
53 };
54
55 public static final String TABLE_SQL_CREATE = "create table Layout (plid LONG not null primary key,groupId LONG,companyId LONG,privateLayout BOOLEAN,layoutId LONG,parentLayoutId LONG,name STRING null,title STRING null,description 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 STRING null,priority INTEGER,layoutPrototypeId LONG,dlFolderId LONG)";
56
57 public static final String TABLE_SQL_DROP = "drop table Layout";
58
59 }