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 CountryTable {
027
028 public static final String TABLE_NAME = "Country";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"countryId", Types.BIGINT},
033 {"name", Types.VARCHAR},
034 {"a2", Types.VARCHAR},
035 {"a3", Types.VARCHAR},
036 {"number_", Types.VARCHAR},
037 {"idd_", Types.VARCHAR},
038 {"zipRequired", Types.BOOLEAN},
039 {"active_", Types.BOOLEAN}
040 };
041
042 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
043
044 static {
045 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
046
047 TABLE_COLUMNS_MAP.put("countryId", Types.BIGINT);
048
049 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
050
051 TABLE_COLUMNS_MAP.put("a2", Types.VARCHAR);
052
053 TABLE_COLUMNS_MAP.put("a3", Types.VARCHAR);
054
055 TABLE_COLUMNS_MAP.put("number_", Types.VARCHAR);
056
057 TABLE_COLUMNS_MAP.put("idd_", Types.VARCHAR);
058
059 TABLE_COLUMNS_MAP.put("zipRequired", Types.BOOLEAN);
060
061 TABLE_COLUMNS_MAP.put("active_", Types.BOOLEAN);
062
063 }
064 public static final String TABLE_SQL_CREATE = "create table Country (mvccVersion LONG default 0,countryId LONG not null primary key,name VARCHAR(75) null,a2 VARCHAR(75) null,a3 VARCHAR(75) null,number_ VARCHAR(75) null,idd_ VARCHAR(75) null,zipRequired BOOLEAN,active_ BOOLEAN)";
065
066 public static final String TABLE_SQL_DROP = "drop table Country";
067
068 public static final String[] TABLE_SQL_ADD_INDEXES = {
069 "create unique index IX_717B97E1 on Country (a2[$COLUMN_LENGTH:75$])",
070 "create unique index IX_717B9BA2 on Country (a3[$COLUMN_LENGTH:75$])",
071 "create index IX_25D734CD on Country (active_)",
072 "create unique index IX_19DA007B on Country (name[$COLUMN_LENGTH:75$])"
073 };
074
075 }