USE [S4LadIcks12]
GO

/****** Object:  Table [dbo].[tblMain]    Script Date: 19.04.2014 13:17:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tblMain](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ProductCode] [nvarchar](255) NULL,
	[Product] [nvarchar](255) NOT NULL,
	[ProductDescription] [nvarchar](255) NOT NULL,
	[ProductGroup] [nvarchar](255) NOT NULL,
	[ProductFamily] [nvarchar](255) NOT NULL,
	[ProductType] [nvarchar](255) NOT NULL,
	[ProductKind] [nvarchar](255) NOT NULL,
	[Price] [money] NULL,
	[Unit] [nvarchar](255) NOT NULL,
	[AddTime] [datetime] NULL,
	[PriceUSD] [float] NULL,
	[Sort] [float] NULL,
	[QuantityPerUp] [int] NULL,
	[LastBuyPriceUSD] [float] NULL,
	[PriceOut1] [float] NULL,
	[PriceOut2] [float] NULL,
	[DiscOt] [int] NULL,
	[OptOT] [int] NULL,
	[QuantityPerUnit] [int] NULL,
	[DeletePr] [bit] NOT NULL,
	[PriceOut1USD] [float] NULL,
	[PriceOut2USD] [float] NULL,
 CONSTRAINT [PK_tblMain] PRIMARY KEY CLUSTERED 
(
	[ID] 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

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [Product]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [ProductDescription]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [ProductGroup]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [ProductFamily]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [ProductType]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [ProductKind]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ('') FOR [Unit]
GO

ALTER TABLE [dbo].[tblMain] ADD  DEFAULT ((0)) FOR [DeletePr]
GO