1
14
15 package com.liferay.portal.upgrade.v4_3_0.util;
16
17 import java.sql.Types;
18
19
25 public class ShoppingOrderItemTable {
26
27 public static String TABLE_NAME = "ShoppingOrderItem";
28
29 public static Object[][] TABLE_COLUMNS = {
30 {"orderItemId", new Integer(Types.BIGINT)},
31 {"orderId", new Integer(Types.BIGINT)},
32 {"itemId", new Integer(Types.VARCHAR)},
33 {"sku", new Integer(Types.VARCHAR)},
34 {"name", new Integer(Types.VARCHAR)},
35 {"description", new Integer(Types.VARCHAR)},
36 {"properties", new Integer(Types.VARCHAR)},
37 {"price", new Integer(Types.DOUBLE)},
38 {"quantity", new Integer(Types.INTEGER)},
39 {"shippedDate", new Integer(Types.TIMESTAMP)}
40 };
41
42 public static String TABLE_SQL_CREATE = "create table ShoppingOrderItem (orderItemId LONG not null primary key,orderId LONG,itemId VARCHAR(75) null,sku VARCHAR(75) null,name VARCHAR(200) null,description STRING null,properties STRING null,price DOUBLE,quantity INTEGER,shippedDate DATE null)";
43
44 public static String TABLE_SQL_DROP = "drop table ShoppingOrderItem";
45
46 }