001
014
015 package com.liferay.portal.upgrade.v6_0_0.util;
016
017 import java.sql.Types;
018
019
023 public class ShoppingItemTable {
024
025 public static final String TABLE_NAME = "ShoppingItem";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"itemId", Types.BIGINT},
029 {"groupId", Types.BIGINT},
030 {"companyId", Types.BIGINT},
031 {"userId", Types.BIGINT},
032 {"userName", Types.VARCHAR},
033 {"createDate", Types.TIMESTAMP},
034 {"modifiedDate", Types.TIMESTAMP},
035 {"categoryId", Types.BIGINT},
036 {"sku", Types.VARCHAR},
037 {"name", Types.VARCHAR},
038 {"description", Types.VARCHAR},
039 {"properties", Types.VARCHAR},
040 {"fields_", Types.BOOLEAN},
041 {"fieldsQuantities", Types.VARCHAR},
042 {"minQuantity", Types.INTEGER},
043 {"maxQuantity", Types.INTEGER},
044 {"price", Types.DOUBLE},
045 {"discount", Types.DOUBLE},
046 {"taxable", Types.BOOLEAN},
047 {"shipping", Types.DOUBLE},
048 {"useShippingFormula", Types.BOOLEAN},
049 {"requiresShipping", Types.BOOLEAN},
050 {"stockQuantity", Types.INTEGER},
051 {"featured_", Types.BOOLEAN},
052 {"sale_", Types.BOOLEAN},
053 {"smallImage", Types.BOOLEAN},
054 {"smallImageId", Types.BIGINT},
055 {"smallImageURL", Types.VARCHAR},
056 {"mediumImage", Types.BOOLEAN},
057 {"mediumImageId", Types.BIGINT},
058 {"mediumImageURL", Types.VARCHAR},
059 {"largeImage", Types.BOOLEAN},
060 {"largeImageId", Types.BIGINT},
061 {"largeImageURL", Types.VARCHAR}
062 };
063
064 public static final String TABLE_SQL_CREATE = "create table ShoppingItem (itemId LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,categoryId LONG,sku VARCHAR(75) null,name VARCHAR(200) null,description STRING null,properties STRING null,fields_ BOOLEAN,fieldsQuantities STRING null,minQuantity INTEGER,maxQuantity INTEGER,price DOUBLE,discount DOUBLE,taxable BOOLEAN,shipping DOUBLE,useShippingFormula BOOLEAN,requiresShipping BOOLEAN,stockQuantity INTEGER,featured_ BOOLEAN,sale_ BOOLEAN,smallImage BOOLEAN,smallImageId LONG,smallImageURL STRING null,mediumImage BOOLEAN,mediumImageId LONG,mediumImageURL STRING null,largeImage BOOLEAN,largeImageId LONG,largeImageURL STRING null)";
065
066 public static final String TABLE_SQL_DROP = "drop table ShoppingItem";
067
068 public static final String[] TABLE_SQL_ADD_INDEXES = {
069 "create unique index IX_1C717CA6 on ShoppingItem (companyId, sku)",
070 "create index IX_FEFE7D76 on ShoppingItem (groupId, categoryId)",
071 "create index IX_903DC750 on ShoppingItem (largeImageId)",
072 "create index IX_D217AB30 on ShoppingItem (mediumImageId)",
073 "create index IX_FF203304 on ShoppingItem (smallImageId)"
074 };
075
076 }