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 OrganizationTable {
027
028 public static final String TABLE_NAME = "Organization_";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"uuid_", Types.VARCHAR},
033 {"organizationId", Types.BIGINT},
034 {"companyId", Types.BIGINT},
035 {"userId", Types.BIGINT},
036 {"userName", Types.VARCHAR},
037 {"createDate", Types.TIMESTAMP},
038 {"modifiedDate", Types.TIMESTAMP},
039 {"parentOrganizationId", Types.BIGINT},
040 {"treePath", Types.VARCHAR},
041 {"name", Types.VARCHAR},
042 {"type_", Types.VARCHAR},
043 {"recursable", Types.BOOLEAN},
044 {"regionId", Types.BIGINT},
045 {"countryId", Types.BIGINT},
046 {"statusId", Types.BIGINT},
047 {"comments", Types.VARCHAR},
048 {"logoId", Types.BIGINT}
049 };
050
051 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
052
053 static {
054 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
055
056 TABLE_COLUMNS_MAP.put("uuid_", Types.VARCHAR);
057
058 TABLE_COLUMNS_MAP.put("organizationId", Types.BIGINT);
059
060 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
061
062 TABLE_COLUMNS_MAP.put("userId", Types.BIGINT);
063
064 TABLE_COLUMNS_MAP.put("userName", Types.VARCHAR);
065
066 TABLE_COLUMNS_MAP.put("createDate", Types.TIMESTAMP);
067
068 TABLE_COLUMNS_MAP.put("modifiedDate", Types.TIMESTAMP);
069
070 TABLE_COLUMNS_MAP.put("parentOrganizationId", Types.BIGINT);
071
072 TABLE_COLUMNS_MAP.put("treePath", Types.VARCHAR);
073
074 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
075
076 TABLE_COLUMNS_MAP.put("type_", Types.VARCHAR);
077
078 TABLE_COLUMNS_MAP.put("recursable", Types.BOOLEAN);
079
080 TABLE_COLUMNS_MAP.put("regionId", Types.BIGINT);
081
082 TABLE_COLUMNS_MAP.put("countryId", Types.BIGINT);
083
084 TABLE_COLUMNS_MAP.put("statusId", Types.BIGINT);
085
086 TABLE_COLUMNS_MAP.put("comments", Types.VARCHAR);
087
088 TABLE_COLUMNS_MAP.put("logoId", Types.BIGINT);
089
090 }
091 public static final String TABLE_SQL_CREATE = "create table Organization_ (mvccVersion LONG default 0,uuid_ VARCHAR(75) null,organizationId LONG not null primary key,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,parentOrganizationId LONG,treePath STRING null,name VARCHAR(100) null,type_ VARCHAR(75) null,recursable BOOLEAN,regionId LONG,countryId LONG,statusId LONG,comments STRING null,logoId LONG)";
092
093 public static final String TABLE_SQL_DROP = "drop table Organization_";
094
095 public static final String[] TABLE_SQL_ADD_INDEXES = {
096 "create unique index IX_E301BDF5 on Organization_ (companyId, name[$COLUMN_LENGTH:100$])",
097 "create index IX_418E4522 on Organization_ (companyId, parentOrganizationId)",
098 "create index IX_A9D85BA6 on Organization_ (uuid_[$COLUMN_LENGTH:75$], companyId)"
099 };
100
101 }