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 BackgroundTaskTable {
027
028 public static final String TABLE_NAME = "BackgroundTask";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"backgroundTaskId", 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 {"name", Types.VARCHAR},
040 {"servletContextNames", Types.VARCHAR},
041 {"taskExecutorClassName", Types.VARCHAR},
042 {"taskContextMap", Types.CLOB},
043 {"completed", Types.BOOLEAN},
044 {"completionDate", Types.TIMESTAMP},
045 {"status", Types.INTEGER},
046 {"statusMessage", Types.CLOB}
047 };
048
049 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
050
051 static {
052 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
053
054 TABLE_COLUMNS_MAP.put("backgroundTaskId", Types.BIGINT);
055
056 TABLE_COLUMNS_MAP.put("groupId", Types.BIGINT);
057
058 TABLE_COLUMNS_MAP.put("companyId", Types.BIGINT);
059
060 TABLE_COLUMNS_MAP.put("userId", Types.BIGINT);
061
062 TABLE_COLUMNS_MAP.put("userName", Types.VARCHAR);
063
064 TABLE_COLUMNS_MAP.put("createDate", Types.TIMESTAMP);
065
066 TABLE_COLUMNS_MAP.put("modifiedDate", Types.TIMESTAMP);
067
068 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
069
070 TABLE_COLUMNS_MAP.put("servletContextNames", Types.VARCHAR);
071
072 TABLE_COLUMNS_MAP.put("taskExecutorClassName", Types.VARCHAR);
073
074 TABLE_COLUMNS_MAP.put("taskContextMap", Types.CLOB);
075
076 TABLE_COLUMNS_MAP.put("completed", Types.BOOLEAN);
077
078 TABLE_COLUMNS_MAP.put("completionDate", Types.TIMESTAMP);
079
080 TABLE_COLUMNS_MAP.put("status", Types.INTEGER);
081
082 TABLE_COLUMNS_MAP.put("statusMessage", Types.CLOB);
083
084 }
085 public static final String TABLE_SQL_CREATE = "create table BackgroundTask (mvccVersion LONG default 0,backgroundTaskId LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,name VARCHAR(255) null,servletContextNames VARCHAR(255) null,taskExecutorClassName VARCHAR(200) null,taskContextMap TEXT null,completed BOOLEAN,completionDate DATE null,status INTEGER,statusMessage TEXT null)";
086
087 public static final String TABLE_SQL_DROP = "drop table BackgroundTask";
088
089 public static final String[] TABLE_SQL_ADD_INDEXES = {
090 "create index IX_C5A6C78F on BackgroundTask (companyId)",
091 "create index IX_579C63B0 on BackgroundTask (groupId, name, taskExecutorClassName, completed)",
092 "create index IX_C71C3B7 on BackgroundTask (groupId, status)",
093 "create index IX_7A9FF471 on BackgroundTask (groupId, taskExecutorClassName, completed)",
094 "create index IX_7E757D70 on BackgroundTask (groupId, taskExecutorClassName, status)",
095 "create index IX_75638CDF on BackgroundTask (status)",
096 "create index IX_2FCFE748 on BackgroundTask (taskExecutorClassName, status)"
097 };
098
099 }