1
14
15 package com.liferay.portal.upgrade.v5_2_8.util;
16
17 import java.sql.Types;
18
19
25 public class JournalTemplateTable {
26
27 public static final String TABLE_NAME = "JournalTemplate";
28
29 public static final Object[][] TABLE_COLUMNS = {
30 {"uuid_", new Integer(Types.VARCHAR)},
31 {"id_", new Integer(Types.BIGINT)},
32 {"groupId", new Integer(Types.BIGINT)},
33 {"companyId", new Integer(Types.BIGINT)},
34 {"userId", new Integer(Types.BIGINT)},
35 {"userName", new Integer(Types.VARCHAR)},
36 {"createDate", new Integer(Types.TIMESTAMP)},
37 {"modifiedDate", new Integer(Types.TIMESTAMP)},
38 {"templateId", new Integer(Types.VARCHAR)},
39 {"structureId", new Integer(Types.VARCHAR)},
40 {"name", new Integer(Types.VARCHAR)},
41 {"description", new Integer(Types.VARCHAR)},
42 {"xsl", new Integer(Types.CLOB)},
43 {"langType", new Integer(Types.VARCHAR)},
44 {"cacheable", new Integer(Types.BOOLEAN)},
45 {"smallImage", new Integer(Types.BOOLEAN)},
46 {"smallImageId", new Integer(Types.BIGINT)},
47 {"smallImageURL", new Integer(Types.VARCHAR)}
48 };
49
50 public static final String TABLE_SQL_CREATE = "create table JournalTemplate (uuid_ VARCHAR(75) null,id_ LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,templateId VARCHAR(75) null,structureId VARCHAR(75) null,name VARCHAR(75) null,description STRING null,xsl TEXT null,langType VARCHAR(75) null,cacheable BOOLEAN,smallImage BOOLEAN,smallImageId LONG,smallImageURL STRING null)";
51
52 public static final String TABLE_SQL_DROP = "drop table JournalTemplate";
53
54 }