1
14
15 package com.liferay.portal.upgrade.v4_3_0.util;
16
17 import java.sql.Types;
18
19
25 public class ShoppingItemPriceTable {
26
27 public static String TABLE_NAME = "ShoppingItemPrice";
28
29 public static Object[][] TABLE_COLUMNS = {
30 {"itemPriceId", new Integer(Types.BIGINT)},
31 {"itemId", new Integer(Types.BIGINT)},
32 {"minQuantity", new Integer(Types.INTEGER)},
33 {"maxQuantity", new Integer(Types.INTEGER)},
34 {"price", new Integer(Types.DOUBLE)},
35 {"discount", new Integer(Types.DOUBLE)},
36 {"taxable", new Integer(Types.BOOLEAN)},
37 {"shipping", new Integer(Types.DOUBLE)},
38 {"useShippingFormula", new Integer(Types.BOOLEAN)},
39 {"status", new Integer(Types.INTEGER)}
40 };
41
42 public static String TABLE_SQL_CREATE = "create table ShoppingItemPrice (itemPriceId LONG not null primary key,itemId LONG,minQuantity INTEGER,maxQuantity INTEGER,price DOUBLE,discount DOUBLE,taxable BOOLEAN,shipping DOUBLE,useShippingFormula BOOLEAN,status INTEGER)";
43
44 public static String TABLE_SQL_DROP = "drop table ShoppingItemPrice";
45
46 }