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 ClassNameTable {
027
028 public static final String TABLE_NAME = "ClassName_";
029
030 public static final Object[][] TABLE_COLUMNS = {
031 {"mvccVersion", Types.BIGINT},
032 {"classNameId", Types.BIGINT},
033 {"value", Types.VARCHAR}
034 };
035
036 public static final Map<String, Integer> TABLE_COLUMNS_MAP = new HashMap<String, Integer>();
037
038 static {
039 TABLE_COLUMNS_MAP.put("mvccVersion", Types.BIGINT);
040
041 TABLE_COLUMNS_MAP.put("classNameId", Types.BIGINT);
042
043 TABLE_COLUMNS_MAP.put("value", Types.VARCHAR);
044
045 }
046 public static final String TABLE_SQL_CREATE = "create table ClassName_ (mvccVersion LONG default 0,classNameId LONG not null primary key,value VARCHAR(200) null)";
047
048 public static final String TABLE_SQL_DROP = "drop table ClassName_";
049
050 public static final String[] TABLE_SQL_ADD_INDEXES = {
051 "create unique index IX_B27A301F on ClassName_ (value[$COLUMN_LENGTH:200$])"
052 };
053
054 }