USE [DistributorFeeds] GO /****** Object: Table [dbo].[Volusion_Product_Attributes] Script Date: 02/01/2016 20:32:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Volusion_Product_Attributes]( [productcode] [varchar](50) NOT NULL, [PTR_Thermal_DTTT] [varchar](100) NULL, [PTR_Thermal_Print_Width] [varchar](25) NULL, [PTR_Thermal_DPI] [varchar](25) NULL, [PTR_Thermal_Connections] [varchar](100) NULL, [PTR_Thermal_Options] [varchar](100) NULL, CONSTRAINT [VOL_Prod_Attrib] PRIMARY KEY CLUSTERED ( [productcode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF USE [DistributorFeeds] GO /****** Object: Table [dbo].[Volusion_WCL_Categories] Script Date: 02/01/2016 20:33:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Volusion_WCL_Categories]( [categoryid] [int] NOT NULL, [categoryname] [nvarchar](255) NULL, [CategoryDescription] [text] NULL, [CategoryDescriptionShort] [text] NULL, [AlternateURL] [varchar](255) NULL, [parentid] [int] NULL, [Display_Rows] [int] NULL, [Default_SortBy] [varchar](15) NULL, CONSTRAINT [WCL_CAT_Key] PRIMARY KEY CLUSTERED ( [categoryid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF USE [DistributorFeeds] GO /****** Object: Table [dbo].[Volusion_WCL_Products] Script Date: 02/01/2016 20:34:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Volusion_WCL_Products]( [productcode] [nvarchar](50) NOT NULL, [categoryids] [nvarchar](25) NULL, [productprice] [varchar](25) NULL, [Vendor_Price] [money] NULL, [warehouses] [varchar](10) NULL, [stockstatus] [varchar](10) NULL, CONSTRAINT [VolusionWCLProdKey] PRIMARY KEY CLUSTERED ( [productcode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF