Pastetool #482

URL: , Paste another 

CREATE TABLE [cross_sell] (
[CrossRefID] int  NOT NULL,
[xProductID] nvarchar (100) NULL,
[xLinktoProductId] nvarchar (100) NULL,
[ShowOrder] int  NULL,
[ProductID] int  NULL,
[LinktoProductID] int  NULL
)


CREATE TABLE [DBColumns] (
[DisplayOrder] tinyint (2) NULL,
[TableName] nvarchar (30) NULL,
[ColumnName] nvarchar (30) NULL,
[Label] nvarchar (30) NULL,
[IsKey] bit (2) NOT NULL,
[ValueFormatSQL] nvarchar (255) NULL,
[ControlType] char (2) NULL,
[ValueRangeSQL] nvarchar (255) NULL,
[ValueValidSQL] nvarchar (255) NULL,
[ValueErrMsg] nvarchar (100) NULL,
[IsSearchable] bit (2) NOT NULL,
[ShowList] bit (2) NOT NULL,
[ShowAddEdit] bit (2) NOT NULL
)


CREATE TABLE [DBTables] (
[TableName] nvarchar (30) NOT NULL,
[DisplayName] nvarchar (30) NULL,
[DisplayOrder] tinyint (2) NULL,
[IsDisplayed] bit (2) NOT NULL,
[OrderByColumns] nvarchar (50) NULL,
[InsertCheckSQL] nvarchar (255) NULL,
[InsertErrMsg] nvarchar (255) NULL,
[UpdateCheckSQL] nvarchar (255) NULL,
[UpdateErrMsg] nvarchar (255) NULL,
[DeleteCheckSQL] nvarchar (255) NULL,
[DeleteErrMsg] nvarchar (255) NULL,
[Addable] bit (2) NOT NULL,
[Editable] bit (2) NOT NULL
)


CREATE TABLE [tbCategory] (
[ID] int  NOT NULL,
[Category] nvarchar (100) NULL,
[Image] nvarchar (50) NULL,
[Description] nvarchar (1000) NULL,
[MetaTitle] nvarchar (1000) NULL,
[MetaKeywords] nvarchar (1000) NULL,
[MetaDescription] nvarchar (1000) NULL,
[Discount] int  NULL,
[StartDate] datetime (16) NULL,
[ExpireDate] datetime (16) NULL,
[DisplayOrder] int  NULL,
[Wholesale] bit (2) NULL
)


CREATE TABLE [tbCustomers] (
[CustomerID] int  NOT NULL,
[BillFirstName] nvarchar (50) NULL,
[BillLastName] nvarchar (50) NULL,
[BillCompany] nvarchar (100) NULL,
[BillAddress] nvarchar (100) NULL,
[BillAddress2] nvarchar (100) NULL,
[BillCity] nvarchar (50) NULL,
[BillState] nvarchar (50) NULL,
[BillZipCode] nvarchar (50) NULL,
[BillCountry] nvarchar (50) NULL,
[BillPhone] nvarchar (20) NULL,
[BillFax] nvarchar (20) NULL,
[BillEmail] nvarchar (50) NULL,
[SameAsShipping] bit (2) NULL,
[ShipFirstName] nvarchar (50) NULL,
[ShipLastName] nvarchar (50) NULL,
[ShipCompany] nvarchar (100) NULL,
[ShipAddress] nvarchar (100) NULL,
[ShipAddress2] nvarchar (100) NULL,
[ShipCity] nvarchar (50) NULL,
[ShipState] nvarchar (50) NULL,
[ShipZipCode] nvarchar (50) NULL,
[ShipCountry] nvarchar (50) NULL,
[ShipPhone] nvarchar (20) NULL,
[ShipFax] nvarchar (20) NULL,
[ShipEmail] nvarchar (50) NULL,
[Email] nvarchar (50) NULL,
[Password] nvarchar (30) NULL,
[PassHint] nvarchar (30) NULL,
[AccountCreated] datetime (16) NULL,
[Comments] nvarchar (2000) NULL,
[PaymentMethod] nvarchar (20) NULL,
[NameOnCard] nvarchar (50) NULL,
[CardNumber] nvarchar (16) NULL,
[CardExpireDate] nvarchar (10) NULL,
[CVVNO] nvarchar (10) NULL,
[Wholesaler] bit (2) NULL,
[MailingList] bit (2) NULL,
[AboutUs] nvarchar (100) NULL
)


CREATE TABLE [tbDiscount] (
[ID] int  NOT NULL,
[Vender] nvarchar (100) NOT NULL,
[Category] nvarchar (100) NOT NULL,
[Discount] int  NULL,
[StartDate] datetime (16) NULL,
[ExpireDate] datetime (16) NULL
)


CREATE TABLE [tbGiftCertificate] (
[GiftID] int  NOT NULL,
[CertificateCode] nvarchar (30) NOT NULL,
[GiftValue] money (8) NULL,
[ValueLeft] money (8) NULL,
[ValueUsed] money (8) NULL,
[PurchaseDate] datetime (16) NULL,
[ExpireDate] datetime (16) NULL,
[SenderID] int  NULL,
[SenderOrderID] int  NULL,
[RecipientID] nvarchar (100) NULL,
[RecipientOrderID] nvarchar (200) NULL,
[SenderName] nvarchar (100) NULL,
[SenderEmail] nvarchar (100) NULL,
[RecipientName] nvarchar (100) NULL,
[RecipientEmail] nvarchar (100) NULL,
[RecipientAddress] nvarchar (100) NULL,
[RecipientCity] nvarchar (100) NULL,
[RecipientState] nvarchar (100) NULL,
[RecipientZip] nvarchar (50) NULL,
[RecipMethod] nvarchar (10) NULL,
[MessagetoRecipient] nvarchar (1000) NULL
)


CREATE TABLE [tblCCCharges] (
[cc_charge_id] int  NOT NULL,
[order_id] int  NOT NULL,
[type] nvarchar (50) NULL,
[admin_username] nvarchar (50) NULL,
[cc_response_code] int  NULL,
[cc_response_subcode] int  NULL,
[cc_reason_code] int  NULL,
[cc_reason_text] nvarchar (255) NULL,
[cc_approval_code] nvarchar (50) NULL,
[cc_avs_result_code] nvarchar (50) NULL,
[cc_transaction_id] nvarchar (50) NULL,
[cc_amount_charged] money (8) NULL,
[cc_charge_time] datetime (16) NULL,
[cc_void_response_code] int  NULL,
[cc_void_response_subcode] int  NULL,
[cc_void_reason_code] int  NULL,
[cc_void_reason_text] nvarchar (255) NULL,
[cc_void_approval_code] nvarchar (50) NULL,
[cc_void_time] datetime (16) NULL,
[void_admin_username] nvarchar (50) NULL,
[cc_credit_amount] money (8) NOT NULL,
[comments] nvarchar (2000) NULL,
[parent_cc_charge_id] int  NULL,
[timestamp] datetime (16) NOT NULL,
[delete_flag] tinyint (1) NOT NULL
)


CREATE TABLE [tbMessages] (
[ID] int  NOT NULL,
[PageName] nvarchar (50) NULL,
[Wholesale] bit (2) NULL,
[Title] nvarchar (255) NULL,
[Description] nvarchar (7000) NULL
)


CREATE TABLE [tbOptions] (
[OptionID] int  NOT NULL,
[ItemID] nvarchar (100) NULL,
[OptionName] nvarchar (200) NULL,
[Color] nvarchar (200) NULL,
[OptionValue] nvarchar (1000) NULL,
[Weight] float (8) NULL
)


CREATE TABLE [tbOrder] (
[OrderID] int  NOT NULL,
[CustomerID] int  NULL,
[ItemSubtotal] money (8) NOT NULL,
[ShipCost] money (8) NULL,
[Tax] money (8) NULL,
[Discount] money (8) NULL,
[OrderTotal] money (8) NOT NULL,
[GiftCard] money (8) NULL,
[RemainPayment] money (8) NULL,
[RefundMoney] money (8) NULL,
[DiscountCode] nvarchar (20) NULL,
[GiftCardCode] nvarchar (30) NULL,
[PaymentMethod] nvarchar (20) NOT NULL,
[NameOnCard] nvarchar (50) NULL,
[CardNumber] nvarchar (16) NULL,
[CardExpireDate] nvarchar (10) NULL,
[CVVNO] nvarchar (10) NULL,
[GiftWraping] bit (2) NULL,
[GiftMessage] nvarchar (250) NULL,
[ShipMethod] nvarchar (50) NULL,
[OrderDate] datetime (16) NULL,
[OrderStatus] nvarchar (20) NULL,
[AuthCode] char (6) NULL,
[TransactionID] nvarchar (10) NULL,
[AuthMsg] nvarchar (255) NULL,
[ShippingDate] nvarchar (250) NULL,
[TrackingNo] nvarchar (50) NULL,
[BillFirstName] nvarchar (50) NULL,
[BillLastName] nvarchar (50) NULL,
[BillCompany] nvarchar (100) NULL,
[BillAddress] nvarchar (100) NULL,
[BillAddress2] nvarchar (100) NULL,
[BillCity] nvarchar (50) NULL,
[BillState] nvarchar (50) NULL,
[BillZipCode] nvarchar (50) NULL,
[BillCountry] nvarchar (50) NULL,
[BillPhone] nvarchar (20) NULL,
[BillFax] nvarchar (20) NULL,
[BillEmail] nvarchar (50) NULL,
[SameAsShipping] bit (2) NULL,
[ShipFirstName] nvarchar (50) NULL,
[ShipLastName] nvarchar (50) NULL,
[ShipCompany] nvarchar (100) NULL,
[ShipAddress] nvarchar (100) NULL,
[ShipAddress2] nvarchar (100) NULL,
[ShipCity] nvarchar (50) NULL,
[ShipState] nvarchar (50) NULL,
[ShipZipCode] nvarchar (50) NULL,
[ShipCountry] nvarchar (50) NULL,
[ShipPhone] nvarchar (20) NULL,
[ShipFax] nvarchar (20) NULL,
[ShipEmail] nvarchar (50) NULL,
[RefererURL] nvarchar (255) NULL,
[ReferIP] nvarchar (255) NULL,
[Comments] nvarchar (2000) NULL,
[Notes] nvarchar (2000) NULL,
[ShipNotes] nvarchar (1000) NULL,
[Wholesaler] bit (2) NULL
)


CREATE TABLE [tbOrderDetail] (
[DetailID] int  NOT NULL,
[OrderID] int  NOT NULL,
[ProductID] int  NULL,
[ItemName] nvarchar (255) NULL,
[ItemNo] nvarchar (50) NULL,
[opItemNo] nvarchar (50) NULL,
[UnitPrice] money (8) NULL,
[Quantity] int  NULL,
[Color] nvarchar (500) NULL,
[Option1] nvarchar (500) NULL,
[Option2] nvarchar (500) NULL,
[ItemOption] nvarchar (500) NULL,
[SubOption] nvarchar (500) NULL,
[SubOption1] nvarchar (500) NULL,
[Notes] nvarchar (1000) NULL,
[CertificateCode] nvarchar (30) NULL,
[Shipped] bit (2) NULL,
[orderdate] datetime (16) NULL
)


CREATE TABLE [tbOrderStatus] (
[ID] int  NOT NULL,
[OrderStatus] nvarchar (20) NULL
)


CREATE TABLE [tbPages] (
[ID] int  NOT NULL,
[pagename] nvarchar (100) NULL,
[pagedata] text (2147483647) NULL,
[active] bit (2) NULL,
[directlink] nvarchar (100) NULL
)


CREATE TABLE [tbPaymethod] (
[ID] int  NOT NULL,
[Name] nvarchar (20) NULL
)


CREATE TABLE [tbProducts] (
[ProductID] int  NOT NULL,
[ID] int  NULL,
[ItemID] nvarchar (100) NULL,
[Category] nvarchar (255) NULL,
[SubCategory] nvarchar (255) NULL,
[SubSubCategory] nvarchar (500) NULL,
[SubSubSub] nvarchar (255) NULL,
[Vender] nvarchar (100) NULL,
[ItemName] nvarchar (255) NULL,
[Color] nvarchar (1000) NULL,
[ItemOption] nvarchar (1000) NULL,
[RelateItem] nvarchar (255) NULL,
[Description] nvarchar (2000) NULL,
[Description2] nvarchar (2000) NULL,
[Features] text (2147483647) NULL,
[ListPrice] money (8) NULL,
[RetailPrice] char (6) NULL,
[RetailPrice1] char (6) NULL,
[RetailQty1] int  NULL,
[SortRetailPrice] money (8) NULL,
[SortWholesalePrice] money (8) NULL,
[DiscountRate] int  NULL,
[NewSortRetailPrice] money (8) NULL,
[NewSortWholesalePrice] money (8) NULL,
[WholesalePrice] char (6) NULL,
[WholesalePrice1] char (6) NULL,
[WholesaleQty1] int  NULL,
[WholesalePrice2] char (6) NULL,
[WholesaleQty2] int  NULL,
[minOrder_Retail] nvarchar (255) NULL,
[minOrder_Wholesale] nvarchar (255) NULL,
[Weight] float (8) NULL,
[Image_Small] nvarchar (100) NULL,
[Image_Large] nvarchar (100) NULL,
[Image_Extra] nvarchar (100) NULL,
[Image_XL] nvarchar (100) NULL,
[Image_Knobs] nvarchar (100) NULL,
[IsDisplay] bit (2) NULL,
[Wholesale] bit (2) NULL,
[ListPriceNote] bit (2) NULL,
[DisplayOrder] int  NULL
)


CREATE TABLE [tbProducts_old] (
[ProductID] int  NOT NULL,
[ID] int  NULL,
[ItemID] nvarchar (100) NULL,
[Category] nvarchar (255) NULL,
[Category_new] nvarchar (255) NULL,
[SubCategory] nvarchar (255) NULL,
[SubCategory_new] nvarchar (255) NULL,
[SubSubCategory] nvarchar (500) NULL,
[SubSubCategory_new] nvarchar (500) NULL,
[SubSubSub] nvarchar (255) NULL,
[Vender] nvarchar (100) NULL,
[ItemName] nvarchar (100) NULL,
[Color] nvarchar (500) NULL,
[ItemOption] nvarchar (500) NULL,
[RelateItem] nvarchar (500) NULL,
[Description] nvarchar (2000) NULL,
[Description2] nvarchar (2000) NULL,
[Features] text (2147483647) NULL,
[ListPrice] money (8) NULL,
[RetailPrice] char (6) NULL,
[RetailPrice1] char (6) NULL,
[RetailQty1] int  NULL,
[WholesalePrice] char (6) NULL,
[WholesalePrice1] char (6) NULL,
[WholesaleQty1] int  NULL,
[WholesalePrice2] char (6) NULL,
[WholesaleQty2] int  NULL,
[minOrder_Retail] nvarchar (255) NULL,
[minOrder_Wholesale] nvarchar (255) NULL,
[Weight] float (8) NULL,
[Image_Small] nvarchar (50) NULL,
[Image_Large] nvarchar (50) NULL,
[Image_Extra] nvarchar (255) NULL,
[Image_XL] nvarchar (50) NULL,
[IsDisplay] bit (2) NULL,
[Wholesale] bit (2) NULL,
[DisplayOrder] int  NULL
)


CREATE TABLE [tbShipMethods] (
[ID] int  NOT NULL,
[ShipMethod] nvarchar (50) NULL,
[ShipCode] nvarchar (20) NULL,
[DeliveryTime] nvarchar (50) NULL,
[ShipType] nvarchar (20) NULL,
[DisplayOrder] int  NULL
)


CREATE TABLE [tbSpecial] (
[SpecialID] int  NOT NULL,
[ItemID] nvarchar (100) NOT NULL,
[DisplayOrder] int  NULL
)


CREATE TABLE [tbSubCategory] (
[ID] int  NOT NULL,
[Category] nvarchar (100) NULL,
[SubCategory] nvarchar (100) NULL,
[Image] nvarchar (50) NULL,
[Description] nvarchar (1000) NULL,
[MetaTitle] nvarchar (1000) NULL,
[MetaKeywords] nvarchar (1000) NULL,
[MetaDescription] nvarchar (1000) NULL,
[OptionName] nvarchar (200) NULL,
[OptionValue] nvarchar (500) NULL,
[OptionName1] nvarchar (200) NULL,
[OptionValue1] nvarchar (500) NULL,
[DisplayOrder] int  NULL,
[Wholesale] bit (2) NULL
)


CREATE TABLE [tbSubSubCategory] (
[ID] int  NOT NULL,
[Category] nvarchar (100) NULL,
[SubCategory] nvarchar (100) NULL,
[SubSubCategory] nvarchar (100) NULL,
[Image] nvarchar (50) NULL,
[Description] nvarchar (1000) NULL,
[MetaTitle] nvarchar (1000) NULL,
[MetaKeywords] nvarchar (1000) NULL,
[MetaDescription] nvarchar (1000) NULL,
[DisplayOrder] int  NULL,
[Wholesale] bit (2) NULL
)


CREATE TABLE [tbSubSubSub] (
[ID] int  NOT NULL,
[Category] nvarchar (100) NULL,
[SubCategory] nvarchar (100) NULL,
[SubSubCategory] nvarchar (100) NULL,
[SubSubSub] nvarchar (100) NULL,
[Image] nvarchar (50) NULL,
[Description] nvarchar (1000) NULL,
[MetaTitle] nvarchar (1000) NULL,
[MetaKeywords] nvarchar (1000) NULL,
[MetaDescription] nvarchar (1000) NULL,
[DisplayOrder] int  NULL,
[Wholesale] bit (2) NULL
)


CREATE TABLE [tbVender] (
[VenderID] int  NOT NULL,
[Vender] nvarchar (100) NULL,
[PriceA] int  NULL,
[PriceB] int  NULL,
[PriceC] int  NULL,
[PriceD] int  NULL,
[PriceE] int  NULL,
[PriceF] int  NULL,
[PriceG] int  NULL,
[PriceH] int  NULL,
[Discount] int  NULL,
[StartDate] datetime (16) NULL,
[ExpireDate] datetime (16) NULL,
[ListPriceNote] bit (2) NULL,
[Image] nvarchar (50) NULL,
[Description] nvarchar (4000) NULL,
[MetaKeywords] nvarchar (1000) NULL,
[MetaTitle] nvarchar (1000) NULL,
[MetaDescription] nvarchar (1000) NULL,
[DisplayOrder] int  NULL
)


CREATE TABLE [tbWholesaler] (
[ID] int  NOT NULL,
[UserName] nvarchar (50) NOT NULL,
[PassWord] nvarchar (50) NOT NULL,
[Email] nvarchar (50) NULL,
[Phone] nvarchar (50) NULL,
[Fax] nvarchar (50) NULL,
[Title] nvarchar (10) NULL,
[FirstName] nvarchar (50) NULL,
[MiddleName] nvarchar (50) NULL,
[LastName] nvarchar (50) NULL,
[Company] nvarchar (100) NULL,
[YearsinBusiness] nvarchar (50) NULL,
[Address] nvarchar (100) NULL,
[City] nvarchar (50) NULL,
[State] nvarchar (50) NULL,
[ZipCode] nvarchar (50) NULL,
[BusinessType] nvarchar (50) NULL,
[ResalerNumber] nvarchar (50) NULL,
[Activated] bit (2) NULL,
[AccountCreated] datetime (16) NULL
)


CREATE TABLE [tbWishList] (
[WishListID] int  NOT NULL,
[CustomerID] int  NOT NULL,
[ItemID] nvarchar (100) NOT NULL,
[AddTime] datetime (16) NULL
)

Download code


This code was pasted on March 10, 2010




Protected with advance Anti-SPAM techniques :)
Coded and designed by Fedmich
Follow us on Twitter