001
014
015 package com.liferay.portal.upgrade.v6_1_0.util;
016
017 import java.sql.Types;
018
019
023 public class JournalStructureTable {
024
025 public static final String TABLE_NAME = "JournalStructure";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", Types.VARCHAR},
029 {"id_", Types.BIGINT},
030 {"groupId", Types.BIGINT},
031 {"companyId", Types.BIGINT},
032 {"userId", Types.BIGINT},
033 {"userName", Types.VARCHAR},
034 {"createDate", Types.TIMESTAMP},
035 {"modifiedDate", Types.TIMESTAMP},
036 {"structureId", Types.VARCHAR},
037 {"parentStructureId", Types.VARCHAR},
038 {"name", Types.VARCHAR},
039 {"description", Types.VARCHAR},
040 {"xsd", Types.CLOB}
041 };
042
043 public static final String TABLE_SQL_CREATE = "create table JournalStructure (uuid_ VARCHAR(75) null,id_ LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,structureId VARCHAR(75) null,parentStructureId VARCHAR(75) null,name STRING null,description STRING null,xsd TEXT null)";
044
045 public static final String TABLE_SQL_DROP = "drop table JournalStructure";
046
047 public static final String[] TABLE_SQL_ADD_INDEXES = {
048 "create index IX_B97F5608 on JournalStructure (groupId)",
049 "create index IX_CA0BD48C on JournalStructure (groupId, parentStructureId)",
050 "create unique index IX_AB6E9996 on JournalStructure (groupId, structureId)",
051 "create index IX_8831E4FC on JournalStructure (structureId)",
052 "create index IX_6702CA92 on JournalStructure (uuid_)",
053 "create unique index IX_42E86E58 on JournalStructure (uuid_, groupId)"
054 };
055
056 }