001
014
015 package com.liferay.portal.upgrade.v7_0_0.util;
016
017 import java.sql.Types;
018
019 import java.util.HashMap;
020 import java.util.Map;
021
022
026 public class ListTypeTable {
027
028 public static final String TABLE_NAME = "ListType";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"listTypeId", Types.BIGINT},
033 {"name", Types.VARCHAR},
034 {"type_", Types.VARCHAR}
035 };
036
037 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
038
039 static {
040 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
041
042 TABLE_COLUMNS_MAP.put("listTypeId", Types.BIGINT);
043
044 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
045
046 TABLE_COLUMNS_MAP.put("type_", Types.VARCHAR);
047
048 }
049 public static final String TABLE_SQL_CREATE = "create table ListType (mvccVersion LONG default 0,listTypeId LONG not null primary key,name VARCHAR(75) null,type_ VARCHAR(75) null)";
050
051 public static final String TABLE_SQL_DROP = "drop table ListType";
052
053 public static final String[] TABLE_SQL_ADD_INDEXES = {
054 "create index IX_77729718 on ListType (name[$COLUMN_LENGTH:75$], type_[$COLUMN_LENGTH:75$])",
055 "create index IX_2932DD37 on ListType (type_[$COLUMN_LENGTH:75$])"
056 };
057
058 }