001
014
015 package com.liferay.portal.upgrade.v7_0_0.util;
016
017 import java.sql.Types;
018
019
023 public class CalEventTable {
024
025 public static final String TABLE_NAME = "CalEvent";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", Types.VARCHAR},
029 {"eventId", Types.BIGINT},
030 {"groupId", Types.BIGINT},
031 {"companyId", Types.BIGINT},
032 {"userId", Types.BIGINT},
033 {"userName", Types.VARCHAR},
034 {"createDate", Types.TIMESTAMP},
035 {"modifiedDate", Types.TIMESTAMP},
036 {"title", Types.VARCHAR},
037 {"description", Types.CLOB},
038 {"location", Types.VARCHAR},
039 {"startDate", Types.TIMESTAMP},
040 {"endDate", Types.TIMESTAMP},
041 {"durationHour", Types.INTEGER},
042 {"durationMinute", Types.INTEGER},
043 {"allDay", Types.BOOLEAN},
044 {"timeZoneSensitive", Types.BOOLEAN},
045 {"type_", Types.VARCHAR},
046 {"repeating", Types.BOOLEAN},
047 {"recurrence", Types.CLOB},
048 {"remindBy", Types.INTEGER},
049 {"firstReminder", Types.INTEGER},
050 {"secondReminder", Types.INTEGER}
051 };
052
053 public static final String TABLE_SQL_CREATE = "create table CalEvent (uuid_ VARCHAR(75) null,eventId LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,title VARCHAR(75) null,description TEXT null,location STRING null,startDate DATE null,endDate DATE null,durationHour INTEGER,durationMinute INTEGER,allDay BOOLEAN,timeZoneSensitive BOOLEAN,type_ VARCHAR(75) null,repeating BOOLEAN,recurrence TEXT null,remindBy INTEGER,firstReminder INTEGER,secondReminder INTEGER)";
054
055 public static final String TABLE_SQL_DROP = "drop table CalEvent";
056
057 public static final String[] TABLE_SQL_ADD_INDEXES = {
058 "create index IX_D6FD9496 on CalEvent (companyId)",
059 "create index IX_4FDDD2BF on CalEvent (groupId, repeating)",
060 "create index IX_FD93CBFA on CalEvent (groupId, type_, repeating)",
061 "create index IX_F6006202 on CalEvent (remindBy)",
062 "create index IX_299639C6 on CalEvent (uuid_, companyId)",
063 "create unique index IX_5CCE79C8 on CalEvent (uuid_, groupId)"
064 };
065
066 }