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 VirtualHostTable {
027
028 public static final String TABLE_NAME = "VirtualHost";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"virtualHostId", Types.BIGINT},
033 {"companyId", Types.BIGINT},
034 {"layoutSetId", Types.BIGINT},
035 {"hostname", Types.VARCHAR}
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("virtualHostId", Types.BIGINT);
044
045 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
046
047 TABLE_COLUMNS_MAP.put("layoutSetId", Types.BIGINT);
048
049 TABLE_COLUMNS_MAP.put("hostname", Types.VARCHAR);
050
051 }
052 public static final String TABLE_SQL_CREATE = "create table VirtualHost (mvccVersion LONG default 0,virtualHostId LONG not null primary key,companyId LONG,layoutSetId LONG,hostname VARCHAR(75) null)";
053
054 public static final String TABLE_SQL_DROP = "drop table VirtualHost";
055
056 public static final String[] TABLE_SQL_ADD_INDEXES = {
057 "create unique index IX_A083D394 on VirtualHost (companyId, layoutSetId)",
058 "create unique index IX_431A3960 on VirtualHost (hostname[$COLUMN_LENGTH:75$])"
059 };
060
061 }