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 GroupTable {
027
028 public static final String TABLE_NAME = "Group_";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"uuid_", Types.VARCHAR},
033 {"groupId", Types.BIGINT},
034 {"companyId", Types.BIGINT},
035 {"creatorUserId", Types.BIGINT},
036 {"classNameId", Types.BIGINT},
037 {"classPK", Types.BIGINT},
038 {"parentGroupId", Types.BIGINT},
039 {"liveGroupId", Types.BIGINT},
040 {"treePath", Types.VARCHAR},
041 {"groupKey", Types.VARCHAR},
042 {"name", Types.VARCHAR},
043 {"description", Types.VARCHAR},
044 {"type_", Types.INTEGER},
045 {"typeSettings", Types.CLOB},
046 {"manualMembership", Types.BOOLEAN},
047 {"membershipRestriction", Types.INTEGER},
048 {"friendlyURL", Types.VARCHAR},
049 {"site", Types.BOOLEAN},
050 {"remoteStagingGroupCount", Types.INTEGER},
051 {"inheritContent", Types.BOOLEAN},
052 {"active_", Types.BOOLEAN}
053 };
054
055 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
056
057 static {
058 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
059
060 TABLE_COLUMNS_MAP.put("uuid_", Types.VARCHAR);
061
062 TABLE_COLUMNS_MAP.put("groupId", Types.BIGINT);
063
064 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
065
066 TABLE_COLUMNS_MAP.put("creatorUserId", Types.BIGINT);
067
068 TABLE_COLUMNS_MAP.put("classNameId", Types.BIGINT);
069
070 TABLE_COLUMNS_MAP.put("classPK", Types.BIGINT);
071
072 TABLE_COLUMNS_MAP.put("parentGroupId", Types.BIGINT);
073
074 TABLE_COLUMNS_MAP.put("liveGroupId", Types.BIGINT);
075
076 TABLE_COLUMNS_MAP.put("treePath", Types.VARCHAR);
077
078 TABLE_COLUMNS_MAP.put("groupKey", Types.VARCHAR);
079
080 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
081
082 TABLE_COLUMNS_MAP.put("description", Types.VARCHAR);
083
084 TABLE_COLUMNS_MAP.put("type_", Types.INTEGER);
085
086 TABLE_COLUMNS_MAP.put("typeSettings", Types.CLOB);
087
088 TABLE_COLUMNS_MAP.put("manualMembership", Types.BOOLEAN);
089
090 TABLE_COLUMNS_MAP.put("membershipRestriction", Types.INTEGER);
091
092 TABLE_COLUMNS_MAP.put("friendlyURL", Types.VARCHAR);
093
094 TABLE_COLUMNS_MAP.put("site", Types.BOOLEAN);
095
096 TABLE_COLUMNS_MAP.put("remoteStagingGroupCount", Types.INTEGER);
097
098 TABLE_COLUMNS_MAP.put("inheritContent", Types.BOOLEAN);
099
100 TABLE_COLUMNS_MAP.put("active_", Types.BOOLEAN);
101
102 }
103 public static final String TABLE_SQL_CREATE = "create table Group_ (mvccVersion LONG default 0 not null,uuid_ VARCHAR(75) null,groupId LONG not null primary key,companyId LONG,creatorUserId LONG,classNameId LONG,classPK LONG,parentGroupId LONG,liveGroupId LONG,treePath STRING null,groupKey VARCHAR(150) null,name STRING null,description STRING null,type_ INTEGER,typeSettings TEXT null,manualMembership BOOLEAN,membershipRestriction INTEGER,friendlyURL VARCHAR(255) null,site BOOLEAN,remoteStagingGroupCount INTEGER,inheritContent BOOLEAN,active_ BOOLEAN)";
104
105 public static final String TABLE_SQL_DROP = "drop table Group_";
106
107 public static final String[] TABLE_SQL_ADD_INDEXES = {
108 "create index IX_BD3CB13A on Group_ (classNameId, groupId, companyId, parentGroupId)",
109 "create index IX_DDC91A87 on Group_ (companyId, active_)",
110 "create unique index IX_D0D5E397 on Group_ (companyId, classNameId, classPK)",
111 "create unique index IX_A729E3A6 on Group_ (companyId, classNameId, liveGroupId, groupKey[$COLUMN_LENGTH:150$])",
112 "create index IX_ABE2D54 on Group_ (companyId, classNameId, parentGroupId)",
113 "create unique index IX_5BDDB872 on Group_ (companyId, friendlyURL[$COLUMN_LENGTH:255$])",
114 "create unique index IX_ACD2B296 on Group_ (companyId, groupKey[$COLUMN_LENGTH:150$])",
115 "create unique index IX_AACD15F0 on Group_ (companyId, liveGroupId, groupKey[$COLUMN_LENGTH:150$])",
116 "create index IX_D4BFF38B on Group_ (companyId, parentGroupId, site, inheritContent)",
117 "create index IX_63A2AABD on Group_ (companyId, site)",
118 "create index IX_16218A38 on Group_ (liveGroupId)",
119 "create index IX_7B590A7A on Group_ (type_, active_)",
120 "create index IX_26CC761A on Group_ (uuid_[$COLUMN_LENGTH:75$], companyId)",
121 "create unique index IX_754FBB1C on Group_ (uuid_[$COLUMN_LENGTH:75$], groupId)"
122 };
123
124 }