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 CalEventTable {
027
028 public static final String TABLE_NAME = "CalEvent";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"uuid_", Types.VARCHAR},
032 {"eventId", Types.BIGINT},
033 {"groupId", Types.BIGINT},
034 {"companyId", Types.BIGINT},
035 {"userId", Types.BIGINT},
036 {"userName", Types.VARCHAR},
037 {"createDate", Types.TIMESTAMP},
038 {"modifiedDate", Types.TIMESTAMP},
039 {"title", Types.VARCHAR},
040 {"description", Types.CLOB},
041 {"location", Types.VARCHAR},
042 {"startDate", Types.TIMESTAMP},
043 {"endDate", Types.TIMESTAMP},
044 {"durationHour", Types.INTEGER},
045 {"durationMinute", Types.INTEGER},
046 {"allDay", Types.BOOLEAN},
047 {"timeZoneSensitive", Types.BOOLEAN},
048 {"type_", Types.VARCHAR},
049 {"repeating", Types.BOOLEAN},
050 {"recurrence", Types.CLOB},
051 {"remindBy", Types.INTEGER},
052 {"firstReminder", Types.INTEGER},
053 {"secondReminder", Types.INTEGER}
054 };
055
056 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
057
058 static {
059 TABLE_COLUMNS_MAP.put("uuid_", Types.VARCHAR);
060
061 TABLE_COLUMNS_MAP.put("eventId", Types.BIGINT);
062
063 TABLE_COLUMNS_MAP.put("groupId", Types.BIGINT);
064
065 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
066
067 TABLE_COLUMNS_MAP.put("userId", Types.BIGINT);
068
069 TABLE_COLUMNS_MAP.put("userName", Types.VARCHAR);
070
071 TABLE_COLUMNS_MAP.put("createDate", Types.TIMESTAMP);
072
073 TABLE_COLUMNS_MAP.put("modifiedDate", Types.TIMESTAMP);
074
075 TABLE_COLUMNS_MAP.put("title", Types.VARCHAR);
076
077 TABLE_COLUMNS_MAP.put("description", Types.CLOB);
078
079 TABLE_COLUMNS_MAP.put("location", Types.VARCHAR);
080
081 TABLE_COLUMNS_MAP.put("startDate", Types.TIMESTAMP);
082
083 TABLE_COLUMNS_MAP.put("endDate", Types.TIMESTAMP);
084
085 TABLE_COLUMNS_MAP.put("durationHour", Types.INTEGER);
086
087 TABLE_COLUMNS_MAP.put("durationMinute", Types.INTEGER);
088
089 TABLE_COLUMNS_MAP.put("allDay", Types.BOOLEAN);
090
091 TABLE_COLUMNS_MAP.put("timeZoneSensitive", Types.BOOLEAN);
092
093 TABLE_COLUMNS_MAP.put("type_", Types.VARCHAR);
094
095 TABLE_COLUMNS_MAP.put("repeating", Types.BOOLEAN);
096
097 TABLE_COLUMNS_MAP.put("recurrence", Types.CLOB);
098
099 TABLE_COLUMNS_MAP.put("remindBy", Types.INTEGER);
100
101 TABLE_COLUMNS_MAP.put("firstReminder", Types.INTEGER);
102
103 TABLE_COLUMNS_MAP.put("secondReminder", Types.INTEGER);
104
105 }
106 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)";
107
108 public static final String TABLE_SQL_DROP = "drop table CalEvent";
109
110 public static final String[] TABLE_SQL_ADD_INDEXES = {
111 "create index IX_D6FD9496 on CalEvent (companyId)",
112 "create index IX_4FDDD2BF on CalEvent (groupId, repeating)",
113 "create index IX_FD93CBFA on CalEvent (groupId, type_[$COLUMN_LENGTH:75$], repeating)",
114 "create index IX_F6006202 on CalEvent (remindBy)",
115 "create index IX_299639C6 on CalEvent (uuid_[$COLUMN_LENGTH:75$], companyId)",
116 "create unique index IX_5CCE79C8 on CalEvent (uuid_[$COLUMN_LENGTH:75$], groupId)"
117 };
118
119 }