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 ServiceComponentTable {
027
028 public static final String TABLE_NAME = "ServiceComponent";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"serviceComponentId", Types.BIGINT},
033 {"buildNamespace", Types.VARCHAR},
034 {"buildNumber", Types.BIGINT},
035 {"buildDate", Types.BIGINT},
036 {"data_", Types.CLOB}
037 };
038
039 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
040
041 static {
042 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
043
044 TABLE_COLUMNS_MAP.put("serviceComponentId", Types.BIGINT);
045
046 TABLE_COLUMNS_MAP.put("buildNamespace", Types.VARCHAR);
047
048 TABLE_COLUMNS_MAP.put("buildNumber", Types.BIGINT);
049
050 TABLE_COLUMNS_MAP.put("buildDate", Types.BIGINT);
051
052 TABLE_COLUMNS_MAP.put("data_", Types.CLOB);
053
054 }
055 public static final String TABLE_SQL_CREATE = "create table ServiceComponent (mvccVersion LONG default 0,serviceComponentId LONG not null primary key,buildNamespace VARCHAR(75) null,buildNumber LONG,buildDate LONG,data_ TEXT null)";
056
057 public static final String TABLE_SQL_DROP = "drop table ServiceComponent";
058
059 public static final String[] TABLE_SQL_ADD_INDEXES = {
060 "create unique index IX_4F0315B8 on ServiceComponent (buildNamespace[$COLUMN_LENGTH:75$], buildNumber)"
061 };
062
063 }