1
22
23 package com.liferay.portal.upgrade.v4_3_0.util;
24
25 import java.sql.Types;
26
27
32 public class JournalTemplateTable {
33
34 public static String TABLE_NAME = "JournalTemplate";
35
36 public static Object[][] TABLE_COLUMNS = {
37 {"id_", new Integer(Types.BIGINT)},
38 {"groupId", new Integer(Types.BIGINT)},
39 {"companyId", new Integer(Types.BIGINT)},
40 {"userId", new Integer(Types.BIGINT)},
41 {"userName", new Integer(Types.VARCHAR)},
42 {"createDate", new Integer(Types.TIMESTAMP)},
43 {"modifiedDate", new Integer(Types.TIMESTAMP)},
44 {"templateId", new Integer(Types.VARCHAR)},
45 {"structureId", new Integer(Types.VARCHAR)},
46 {"name", new Integer(Types.VARCHAR)},
47 {"description", new Integer(Types.VARCHAR)},
48 {"xsl", new Integer(Types.CLOB)},
49 {"langType", new Integer(Types.VARCHAR)},
50 {"smallImage", new Integer(Types.BOOLEAN)},
51 {"smallImageId", new Integer(Types.BIGINT)},
52 {"smallImageURL", new Integer(Types.VARCHAR)}
53 };
54
55 public static String TABLE_SQL_CREATE = "create table JournalTemplate (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,smallImage BOOLEAN,smallImageId LONG,smallImageURL VARCHAR(75) null)";
56
57 public static String TABLE_SQL_DROP = "drop table JournalTemplate";
58
59 }