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