1
14
15 package com.liferay.portal.upgrade.v6_0_0.util;
16
17 import java.sql.Types;
18
19
25 public class DLFileEntryTable {
26
27 public static final String TABLE_NAME = "DLFileEntry";
28
29 public static final Object[][] TABLE_COLUMNS = {
30 {"uuid_", new Integer(Types.VARCHAR)},
31 {"fileEntryId", 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 {"versionUserId", new Integer(Types.BIGINT)},
37 {"versionUserName", new Integer(Types.VARCHAR)},
38 {"createDate", new Integer(Types.TIMESTAMP)},
39 {"modifiedDate", new Integer(Types.TIMESTAMP)},
40 {"folderId", new Integer(Types.BIGINT)},
41 {"name", new Integer(Types.VARCHAR)},
42 {"title", new Integer(Types.VARCHAR)},
43 {"description", new Integer(Types.VARCHAR)},
44 {"version", new Integer(Types.VARCHAR)},
45 {"pendingVersion", new Integer(Types.VARCHAR)},
46 {"size_", new Integer(Types.INTEGER)},
47 {"readCount", new Integer(Types.INTEGER)},
48 {"extraSettings", new Integer(Types.CLOB)}
49 };
50
51 public static final String TABLE_SQL_CREATE = "create table DLFileEntry (uuid_ VARCHAR(75) null,fileEntryId LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,versionUserId LONG,versionUserName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,folderId LONG,name VARCHAR(255) null,title VARCHAR(255) null,description STRING null,version VARCHAR(75) null,pendingVersion VARCHAR(75) null,size_ INTEGER,readCount INTEGER,extraSettings TEXT null)";
52
53 public static final String TABLE_SQL_DROP = "drop table DLFileEntry";
54
55 }