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 CompanyTable {
027
028 public static final String TABLE_NAME = "Company";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"companyId", Types.BIGINT},
033 {"accountId", Types.BIGINT},
034 {"webId", Types.VARCHAR},
035 {"key_", Types.CLOB},
036 {"mx", Types.VARCHAR},
037 {"homeURL", Types.VARCHAR},
038 {"logoId", Types.BIGINT},
039 {"system", Types.BOOLEAN},
040 {"maxUsers", Types.INTEGER},
041 {"active_", Types.BOOLEAN}
042 };
043
044 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
045
046 static {
047 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
048
049 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
050
051 TABLE_COLUMNS_MAP.put("accountId", Types.BIGINT);
052
053 TABLE_COLUMNS_MAP.put("webId", Types.VARCHAR);
054
055 TABLE_COLUMNS_MAP.put("key_", Types.CLOB);
056
057 TABLE_COLUMNS_MAP.put("mx", Types.VARCHAR);
058
059 TABLE_COLUMNS_MAP.put("homeURL", Types.VARCHAR);
060
061 TABLE_COLUMNS_MAP.put("logoId", Types.BIGINT);
062
063 TABLE_COLUMNS_MAP.put("system", Types.BOOLEAN);
064
065 TABLE_COLUMNS_MAP.put("maxUsers", Types.INTEGER);
066
067 TABLE_COLUMNS_MAP.put("active_", Types.BOOLEAN);
068
069 }
070 public static final String TABLE_SQL_CREATE = "create table Company (mvccVersion LONG default 0 not null,companyId LONG not null primary key,accountId LONG,webId VARCHAR(75) null,key_ TEXT null,mx VARCHAR(75) null,homeURL STRING null,logoId LONG,system BOOLEAN,maxUsers INTEGER,active_ BOOLEAN)";
071
072 public static final String TABLE_SQL_DROP = "drop table Company";
073
074 public static final String[] TABLE_SQL_ADD_INDEXES = {
075 "create index IX_38EFE3FD on Company (logoId)",
076 "create index IX_12566EC2 on Company (mx[$COLUMN_LENGTH:75$])",
077 "create index IX_35E3E7C6 on Company (system)",
078 "create unique index IX_EC00543C on Company (webId[$COLUMN_LENGTH:75$])"
079 };
080
081 }