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 ResourceActionTable {
027
028 public static final String TABLE_NAME = "ResourceAction";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"resourceActionId", Types.BIGINT},
033 {"name", Types.VARCHAR},
034 {"actionId", Types.VARCHAR},
035 {"bitwiseValue", Types.BIGINT}
036 };
037
038 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
039
040 static {
041 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
042
043 TABLE_COLUMNS_MAP.put("resourceActionId", Types.BIGINT);
044
045 TABLE_COLUMNS_MAP.put("name", Types.VARCHAR);
046
047 TABLE_COLUMNS_MAP.put("actionId", Types.VARCHAR);
048
049 TABLE_COLUMNS_MAP.put("bitwiseValue", Types.BIGINT);
050
051 }
052 public static final String TABLE_SQL_CREATE = "create table ResourceAction (mvccVersion LONG default 0,resourceActionId LONG not null primary key,name VARCHAR(255) null,actionId VARCHAR(75) null,bitwiseValue LONG)";
053
054 public static final String TABLE_SQL_DROP = "drop table ResourceAction";
055
056 public static final String[] TABLE_SQL_ADD_INDEXES = {
057 "create unique index IX_EDB9986E on ResourceAction (name[$COLUMN_LENGTH:255$], actionId[$COLUMN_LENGTH:75$])"
058 };
059
060 }