001
014
015 package com.liferay.portal.upgrade.v4_3_0.util;
016
017 import java.sql.Types;
018
019
023 public class ShoppingItemPriceTable {
024
025 public static String TABLE_NAME = "ShoppingItemPrice";
026
027 public static Object[][] TABLE_COLUMNS = {
028 {"itemPriceId", new Integer(Types.BIGINT)},
029 {"itemId", new Integer(Types.BIGINT)},
030 {"minQuantity", new Integer(Types.INTEGER)},
031 {"maxQuantity", new Integer(Types.INTEGER)},
032 {"price", new Integer(Types.DOUBLE)},
033 {"discount", new Integer(Types.DOUBLE)},
034 {"taxable", new Integer(Types.BOOLEAN)},
035 {"shipping", new Integer(Types.DOUBLE)},
036 {"useShippingFormula", new Integer(Types.BOOLEAN)},
037 {"status", new Integer(Types.INTEGER)}
038 };
039
040 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)";
041
042 public static String TABLE_SQL_DROP = "drop table ShoppingItemPrice";
043
044 }