001    /**
002     * Copyright (c) 2000-2013 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
013     */
014    
015    package com.liferay.portal.upgrade.v6_0_0.util;
016    
017    import java.sql.Types;
018    
019    /**
020     * @author        Brian Wing Shun Chan
021     * @generated
022     */
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    }