001
014
015 package com.liferay.portal.upgrade.v5_1_0.util;
016
017 import java.sql.Types;
018
019
023 public class BlogsEntryTable {
024
025 public static final String TABLE_NAME = "BlogsEntry";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"uuid_", Types.VARCHAR},
029 {"entryId", 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 {"title", Types.VARCHAR},
037 {"urlTitle", Types.VARCHAR},
038 {"content", Types.CLOB},
039 {"displayDate", Types.TIMESTAMP},
040 {"draft", Types.BOOLEAN},
041 {"allowTrackbacks", Types.BOOLEAN},
042 {"trackbacks", Types.CLOB}
043 };
044
045 public static final String TABLE_SQL_CREATE = "create table BlogsEntry (uuid_ VARCHAR(75) null,entryId LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,title VARCHAR(150) null,urlTitle VARCHAR(150) null,content TEXT null,displayDate DATE null,draft BOOLEAN,allowTrackbacks BOOLEAN,trackbacks TEXT null)";
046
047 public static final String TABLE_SQL_DROP = "drop table BlogsEntry";
048
049 public static final String[] TABLE_SQL_ADD_INDEXES = {
050 "create index IX_72EF6041 on BlogsEntry (companyId)",
051 "create index IX_3D3D30B0 on BlogsEntry (companyId, draft)",
052 "create index IX_81A50303 on BlogsEntry (groupId)",
053 "create index IX_5FF14FAE on BlogsEntry (groupId, draft)",
054 "create index IX_DB780A20 on BlogsEntry (groupId, urlTitle)",
055 "create index IX_C07CA83D on BlogsEntry (groupId, userId)",
056 "create index IX_BC2A3534 on BlogsEntry (groupId, userId, draft)",
057 "create index IX_69157A4D on BlogsEntry (uuid_)",
058 "create index IX_1B1040FD on BlogsEntry (uuid_, groupId)"
059 };
060
061 }