001
014
015 package com.liferay.portal.upgrade.v5_2_3.util;
016
017 import java.sql.Types;
018
019
023 public class ResourceTable {
024
025 public static final String TABLE_NAME = "Resource_";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"resourceId", Types.BIGINT},
029 {"codeId", Types.BIGINT},
030 {"primKey", Types.VARCHAR}
031 };
032
033 public static final String TABLE_SQL_CREATE = "create table Resource_ (resourceId LONG not null primary key,codeId LONG,primKey VARCHAR(255) null)";
034
035 public static final String TABLE_SQL_DROP = "drop table Resource_";
036
037 public static final String[] TABLE_SQL_ADD_INDEXES = {
038 "create index IX_2578FBD3 on Resource_ (codeId)",
039 "create unique index IX_67DE7856 on Resource_ (codeId, primKey)"
040 };
041
042 }