001
014
015 package com.liferay.portal.upgrade.v5_2_8_to_6_0_5.util;
016
017 import java.sql.Types;
018
019
023 public class DLFileEntryTable {
024
025 public static final String TABLE_NAME = "DLFileEntry";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", new Integer(Types.VARCHAR)},
029 {"fileEntryId", new Integer(Types.BIGINT)},
030 {"groupId", new Integer(Types.BIGINT)},
031 {"companyId", new Integer(Types.BIGINT)},
032 {"userId", new Integer(Types.BIGINT)},
033 {"userName", new Integer(Types.VARCHAR)},
034 {"versionUserId", new Integer(Types.BIGINT)},
035 {"versionUserName", new Integer(Types.VARCHAR)},
036 {"createDate", new Integer(Types.TIMESTAMP)},
037 {"modifiedDate", new Integer(Types.TIMESTAMP)},
038 {"folderId", new Integer(Types.BIGINT)},
039 {"name", new Integer(Types.VARCHAR)},
040 {"extension", new Integer(Types.VARCHAR)},
041 {"title", new Integer(Types.VARCHAR)},
042 {"description", new Integer(Types.VARCHAR)},
043 {"extraSettings", new Integer(Types.CLOB)},
044 {"version", new Integer(Types.VARCHAR)},
045 {"size_", new Integer(Types.BIGINT)},
046 {"readCount", new Integer(Types.INTEGER)}
047 };
048
049 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,extension VARCHAR(75) null,title VARCHAR(255) null,description STRING null,extraSettings TEXT null,version VARCHAR(75) null,size_ LONG,readCount INTEGER)";
050
051 public static final String TABLE_SQL_DROP = "drop table DLFileEntry";
052
053 }