001
014
015 package com.liferay.portal.upgrade.v6_0_12_to_6_1_0.util;
016
017 import java.sql.Types;
018
019
023 public class ResourceBlockPermissionTable {
024
025 public static final String TABLE_NAME = "ResourceBlockPermission";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"resourceBlockPermissionId", Types.BIGINT},
029 {"resourceBlockId", Types.BIGINT},
030 {"roleId", Types.BIGINT},
031 {"actionIds", Types.BIGINT}
032 };
033
034 public static final String TABLE_SQL_CREATE = "create table ResourceBlockPermission (resourceBlockPermissionId LONG not null primary key,resourceBlockId LONG,roleId LONG,actionIds LONG)";
035
036 public static final String TABLE_SQL_DROP = "drop table ResourceBlockPermission";
037
038 public static final String[] TABLE_SQL_ADD_INDEXES = {
039 "create index IX_4AB3756 on ResourceBlockPermission (resourceBlockId)",
040 "create unique index IX_D63D20BB on ResourceBlockPermission (resourceBlockId, roleId)"
041 };
042
043 }