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 PortalPreferencesTable {
027
028 public static final String TABLE_NAME = "PortalPreferences";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"portalPreferencesId", Types.BIGINT},
033 {"ownerId", Types.BIGINT},
034 {"ownerType", Types.INTEGER},
035 {"preferences", Types.CLOB}
036 };
037
038 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
039
040 static {
041 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
042
043 TABLE_COLUMNS_MAP.put("portalPreferencesId", Types.BIGINT);
044
045 TABLE_COLUMNS_MAP.put("ownerId", Types.BIGINT);
046
047 TABLE_COLUMNS_MAP.put("ownerType", Types.INTEGER);
048
049 TABLE_COLUMNS_MAP.put("preferences", Types.CLOB);
050
051 }
052 public static final String TABLE_SQL_CREATE = "create table PortalPreferences (mvccVersion LONG default 0,portalPreferencesId LONG not null primary key,ownerId LONG,ownerType INTEGER,preferences TEXT null)";
053
054 public static final String TABLE_SQL_DROP = "drop table PortalPreferences";
055
056 public static final String[] TABLE_SQL_ADD_INDEXES = {
057 "create index IX_D1F795F1 on PortalPreferences (ownerId, ownerType)"
058 };
059
060 }