001
014
015 package com.liferay.portal.upgrade.v5_1_5.util;
016
017 import java.sql.Types;
018
019
023 public class ResourceCodeTable {
024
025 public static final String TABLE_NAME = "ResourceCode";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"codeId", Types.BIGINT},
029 {"companyId", Types.BIGINT},
030 {"name", Types.VARCHAR},
031 {"scope", Types.INTEGER}
032 };
033
034 public static final String TABLE_SQL_CREATE = "create table ResourceCode (codeId LONG not null primary key,companyId LONG,name VARCHAR(255) null,scope INTEGER)";
035
036 public static final String TABLE_SQL_DROP = "drop table ResourceCode";
037
038 public static final String[] TABLE_SQL_ADD_INDEXES = {
039 "create index IX_717FDD47 on ResourceCode (companyId)",
040 "create unique index IX_A32C097E on ResourceCode (companyId, name, scope)",
041 "create index IX_AACAFF40 on ResourceCode (name)"
042 };
043
044 }