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 ExpandoValueTable {
027
028 public static final String TABLE_NAME = "ExpandoValue";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"valueId", Types.BIGINT},
032 {"companyId", Types.BIGINT},
033 {"tableId", Types.BIGINT},
034 {"columnId", Types.BIGINT},
035 {"rowId_", Types.BIGINT},
036 {"classNameId", Types.BIGINT},
037 {"classPK", Types.BIGINT},
038 {"data_", Types.CLOB}
039 };
040
041 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
042
043 static {
044 TABLE_COLUMNS_MAP.put("valueId", Types.BIGINT);
045
046 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
047
048 TABLE_COLUMNS_MAP.put("tableId", Types.BIGINT);
049
050 TABLE_COLUMNS_MAP.put("columnId", Types.BIGINT);
051
052 TABLE_COLUMNS_MAP.put("rowId_", Types.BIGINT);
053
054 TABLE_COLUMNS_MAP.put("classNameId", Types.BIGINT);
055
056 TABLE_COLUMNS_MAP.put("classPK", Types.BIGINT);
057
058 TABLE_COLUMNS_MAP.put("data_", Types.CLOB);
059
060 }
061 public static final String TABLE_SQL_CREATE = "create table ExpandoValue (valueId LONG not null primary key,companyId LONG,tableId LONG,columnId LONG,rowId_ LONG,classNameId LONG,classPK LONG,data_ TEXT null)";
062
063 public static final String TABLE_SQL_DROP = "drop table ExpandoValue";
064
065 public static final String[] TABLE_SQL_ADD_INDEXES = {
066 "create index IX_B29FEF17 on ExpandoValue (classNameId, classPK)",
067 "create unique index IX_9DDD21E5 on ExpandoValue (columnId, rowId_)",
068 "create index IX_9112A7A0 on ExpandoValue (rowId_)",
069 "create index IX_1BD3F4C on ExpandoValue (tableId, classPK)",
070 "create unique index IX_D27B03E7 on ExpandoValue (tableId, columnId, classPK)",
071 "create index IX_B71E92D5 on ExpandoValue (tableId, rowId_)"
072 };
073
074 }