1
14
15 package com.liferay.portal.upgrade.v4_3_0.util;
16
17 import java.sql.Types;
18
19
25 public class WikiPageTable {
26
27 public static String TABLE_NAME = "WikiPage";
28
29 public static Object[][] TABLE_COLUMNS = {
30 {"pageId", new Integer(Types.BIGINT)},
31 {"resourcePrimKey", new Integer(Types.BIGINT)},
32 {"companyId", new Integer(Types.BIGINT)},
33 {"userId", new Integer(Types.BIGINT)},
34 {"userName", new Integer(Types.VARCHAR)},
35 {"createDate", new Integer(Types.TIMESTAMP)},
36 {"nodeId", new Integer(Types.BIGINT)},
37 {"title", new Integer(Types.VARCHAR)},
38 {"version", new Integer(Types.DOUBLE)},
39 {"content", new Integer(Types.CLOB)},
40 {"format", new Integer(Types.VARCHAR)},
41 {"head", new Integer(Types.BOOLEAN)}
42 };
43
44 public static String TABLE_SQL_CREATE = "create table WikiPage (pageId LONG not null primary key,resourcePrimKey LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,nodeId LONG,title VARCHAR(75) null,version DOUBLE,content TEXT null,format VARCHAR(75) null,head BOOLEAN)";
45
46 public static String TABLE_SQL_DROP = "drop table WikiPage";
47
48 }