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 PhoneTable {
027
028 public static final String TABLE_NAME = "Phone";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"uuid_", Types.VARCHAR},
033 {"phoneId", Types.BIGINT},
034 {"companyId", Types.BIGINT},
035 {"userId", Types.BIGINT},
036 {"userName", Types.VARCHAR},
037 {"createDate", Types.TIMESTAMP},
038 {"modifiedDate", Types.TIMESTAMP},
039 {"classNameId", Types.BIGINT},
040 {"classPK", Types.BIGINT},
041 {"number_", Types.VARCHAR},
042 {"extension", Types.VARCHAR},
043 {"typeId", Types.BIGINT},
044 {"primary_", Types.BOOLEAN}
045 };
046
047 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
048
049 static {
050 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
051
052 TABLE_COLUMNS_MAP.put("uuid_", Types.VARCHAR);
053
054 TABLE_COLUMNS_MAP.put("phoneId", Types.BIGINT);
055
056 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
057
058 TABLE_COLUMNS_MAP.put("userId", Types.BIGINT);
059
060 TABLE_COLUMNS_MAP.put("userName", Types.VARCHAR);
061
062 TABLE_COLUMNS_MAP.put("createDate", Types.TIMESTAMP);
063
064 TABLE_COLUMNS_MAP.put("modifiedDate", Types.TIMESTAMP);
065
066 TABLE_COLUMNS_MAP.put("classNameId", Types.BIGINT);
067
068 TABLE_COLUMNS_MAP.put("classPK", Types.BIGINT);
069
070 TABLE_COLUMNS_MAP.put("number_", Types.VARCHAR);
071
072 TABLE_COLUMNS_MAP.put("extension", Types.VARCHAR);
073
074 TABLE_COLUMNS_MAP.put("typeId", Types.BIGINT);
075
076 TABLE_COLUMNS_MAP.put("primary_", Types.BOOLEAN);
077
078 }
079 public static final String TABLE_SQL_CREATE = "create table Phone (mvccVersion LONG default 0,uuid_ VARCHAR(75) null,phoneId LONG not null primary key,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,classNameId LONG,classPK LONG,number_ VARCHAR(75) null,extension VARCHAR(75) null,typeId LONG,primary_ BOOLEAN)";
080
081 public static final String TABLE_SQL_DROP = "drop table Phone";
082
083 public static final String[] TABLE_SQL_ADD_INDEXES = {
084 "create index IX_812CE07A on Phone (companyId, classNameId, classPK, primary_)",
085 "create index IX_F202B9CE on Phone (userId)",
086 "create index IX_B271FA88 on Phone (uuid_[$COLUMN_LENGTH:75$], companyId)"
087 };
088
089 }