001
014
015 package com.liferay.portal.upgrade.v5_2_5.util;
016
017 import java.sql.Types;
018
019
023 public class SocialRelationTable {
024
025 public static final String TABLE_NAME = "SocialRelation";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", Types.VARCHAR},
029 {"relationId", Types.BIGINT},
030 {"companyId", Types.BIGINT},
031 {"createDate", Types.BIGINT},
032 {"userId1", Types.BIGINT},
033 {"userId2", Types.BIGINT},
034 {"type_", Types.INTEGER}
035 };
036
037 public static final String TABLE_SQL_CREATE = "create table SocialRelation (uuid_ VARCHAR(75) null,relationId LONG not null primary key,companyId LONG,createDate LONG,userId1 LONG,userId2 LONG,type_ INTEGER)";
038
039 public static final String TABLE_SQL_DROP = "drop table SocialRelation";
040
041 public static final String[] TABLE_SQL_ADD_INDEXES = {
042 "create index IX_61171E99 on SocialRelation (companyId)",
043 "create index IX_95135D1C on SocialRelation (companyId, type_)",
044 "create index IX_C31A64C6 on SocialRelation (type_)",
045 "create index IX_5A40CDCC on SocialRelation (userId1)",
046 "create index IX_4B52BE89 on SocialRelation (userId1, type_)",
047 "create unique index IX_12A92145 on SocialRelation (userId1, userId2, type_)",
048 "create index IX_5A40D18D on SocialRelation (userId2)",
049 "create index IX_3F9C2FA8 on SocialRelation (userId2, type_)",
050 "create index IX_F0CA24A5 on SocialRelation (uuid_)"
051 };
052
053 }