001
014
015 package com.liferay.portal.upgrade.v4_3_0.util;
016
017 import java.sql.Types;
018
019
023 public class PortletPreferencesTable {
024
025 public static String TABLE_NAME = "PortletPreferences";
026
027 public static Object[][] TABLE_COLUMNS = {
028 {"portletPreferencesId", new Integer(Types.BIGINT)},
029 {"ownerId", new Integer(Types.BIGINT)},
030 {"ownerType", new Integer(Types.INTEGER)},
031 {"plid", new Integer(Types.BIGINT)},
032 {"portletId", new Integer(Types.VARCHAR)},
033 {"preferences", new Integer(Types.CLOB)}
034 };
035
036 public static String TABLE_SQL_CREATE = "create table PortletPreferences (portletPreferencesId LONG not null primary key,ownerId LONG,ownerType INTEGER,plid LONG,portletId VARCHAR(200) null,preferences TEXT null)";
037
038 public static String TABLE_SQL_DROP = "drop table PortletPreferences";
039
040 }