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 {"lastPublishDate", Types.TIMESTAMP}
050 };
051
052 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
053
054 static {
055 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
056
057 TABLE_COLUMNS_MAP.put("uuid_", Types.VARCHAR);
058
059 TABLE_COLUMNS_MAP.put("organizationId", Types.BIGINT);
060
061 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
062
063 TABLE_COLUMNS_MAP.put("userId", Types.BIGINT);
064
065 TABLE_COLUMNS_MAP.put("userName", Types.VARCHAR);
066
067 TABLE_COLUMNS_MAP.put("createDate", Types.TIMESTAMP);
068
069 TABLE_COLUMNS_MAP.put("modifiedDate", Types.TIMESTAMP);
070
071 TABLE_COLUMNS_MAP.put("parentOrganizationId", Types.BIGINT);
072
073 TABLE_COLUMNS_MAP.put("treePath", Types.VARCHAR);
074
075 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
076
077 TABLE_COLUMNS_MAP.put("type_", Types.VARCHAR);
078
079 TABLE_COLUMNS_MAP.put("recursable", Types.BOOLEAN);
080
081 TABLE_COLUMNS_MAP.put("regionId", Types.BIGINT);
082
083 TABLE_COLUMNS_MAP.put("countryId", Types.BIGINT);
084
085 TABLE_COLUMNS_MAP.put("statusId", Types.BIGINT);
086
087 TABLE_COLUMNS_MAP.put("comments", Types.VARCHAR);
088
089 TABLE_COLUMNS_MAP.put("logoId", Types.BIGINT);
090
091 TABLE_COLUMNS_MAP.put("lastPublishDate", Types.TIMESTAMP);
092
093 }
094 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,lastPublishDate DATE null)";
095
096 public static final String TABLE_SQL_DROP = "drop table Organization_";
097
098 public static final String[] TABLE_SQL_ADD_INDEXES = {
099 "create unique index IX_E301BDF5 on Organization_ (companyId, name)",
100 "create index IX_418E4522 on Organization_ (companyId, parentOrganizationId)",
101 "create index IX_A9D85BA6 on Organization_ (uuid_, companyId)"
102 };
103
104 }