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 ReleaseTable {
027
028 public static final String TABLE_NAME = "Release_";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"releaseId", Types.BIGINT},
033 {"createDate", Types.TIMESTAMP},
034 {"modifiedDate", Types.TIMESTAMP},
035 {"servletContextName", Types.VARCHAR},
036 {"schemaVersion", Types.VARCHAR},
037 {"buildNumber", Types.INTEGER},
038 {"buildDate", Types.TIMESTAMP},
039 {"verified", Types.BOOLEAN},
040 {"state_", Types.INTEGER},
041 {"testString", Types.VARCHAR}
042 };
043
044 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
045
046 static {
047 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
048
049 TABLE_COLUMNS_MAP.put("releaseId", Types.BIGINT);
050
051 TABLE_COLUMNS_MAP.put("createDate", Types.TIMESTAMP);
052
053 TABLE_COLUMNS_MAP.put("modifiedDate", Types.TIMESTAMP);
054
055 TABLE_COLUMNS_MAP.put("servletContextName", Types.VARCHAR);
056
057 TABLE_COLUMNS_MAP.put("schemaVersion", Types.VARCHAR);
058
059 TABLE_COLUMNS_MAP.put("buildNumber", Types.INTEGER);
060
061 TABLE_COLUMNS_MAP.put("buildDate", Types.TIMESTAMP);
062
063 TABLE_COLUMNS_MAP.put("verified", Types.BOOLEAN);
064
065 TABLE_COLUMNS_MAP.put("state_", Types.INTEGER);
066
067 TABLE_COLUMNS_MAP.put("testString", Types.VARCHAR);
068
069 }
070 public static final String TABLE_SQL_CREATE = "create table Release_ (mvccVersion LONG default 0,releaseId LONG not null primary key,createDate DATE null,modifiedDate DATE null,servletContextName VARCHAR(75) null,schemaVersion VARCHAR(75) null,buildNumber INTEGER,buildDate DATE null,verified BOOLEAN,state_ INTEGER,testString VARCHAR(1024) null)";
071
072 public static final String TABLE_SQL_DROP = "drop table Release_";
073
074 public static final String[] TABLE_SQL_ADD_INDEXES = {
075 "create unique index IX_8BD6BCA7 on Release_ (servletContextName[$COLUMN_LENGTH:75$])"
076 };
077
078 }