USE [sunrios]
GO
/****** Object:  Table [dbo].[Achat_Product]    Script Date: 06/10/2010 14:50:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Achat_Product](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [ProductId] [VARCHAR](35) NOT NULL,
    [MarchandId] [INT] NOT NULL,
    [Name] [VARCHAR](300) NOT NULL,
    [PrimaryCategory] [VARCHAR](500) NOT NULL CONSTRAINT [DF_Achat_Product_PrimaryCategory]  DEFAULT (''),
    [SecondaryCategory] [VARCHAR](MAX) NOT NULL CONSTRAINT [DF_Achat_Product_SecondaryCategory]  DEFAULT (''),
    [Description] [VARCHAR](MAX) NOT NULL CONSTRAINT [DF_Achat_Product_Description]  DEFAULT (''),
    [Manufacturer] [VARCHAR](300) NOT NULL CONSTRAINT [DF_Achat_Product_Manufacturer]  DEFAULT (''),
    [ManufacturerPartNb] [VARCHAR](50) NOT NULL CONSTRAINT [DF_Achat_Product_ManufacturerPartNb]  DEFAULT (''),
    [UPC] [VARCHAR](15) NOT NULL CONSTRAINT [DF_Achat_Product_UPC]  DEFAULT (''),
    [Currency] [VARCHAR](3) NOT NULL CONSTRAINT [DF_Achat_Product_Currency]  DEFAULT ('USD'),
    [ImageUrl] [VARCHAR](2000) NOT NULL CONSTRAINT [DF_Achat_Product_ImageUrl]  DEFAULT (''),
    [Url] [VARCHAR](2000) NOT NULL CONSTRAINT [DF_Achat_Product_Url]  DEFAULT (''),
    [Pixel] [VARCHAR](350) NOT NULL CONSTRAINT [DF_Achat_Product_Pixel]  DEFAULT (''),
    [Price] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_Price]  DEFAULT ((0)),
    [PriceSale] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_PriceSale]  DEFAULT ((0)),
    [PriceAverage] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_PriceAverage]  DEFAULT ((0)),
    [PriceMin] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_PriceMin]  DEFAULT ((0)),
    [PriceMax] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_PriceMax]  DEFAULT ((0)),
    [PriceTendency] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_PriceTendency]  DEFAULT ((0)),
    [LastUpdate] [smalldatetime] NOT NULL CONSTRAINT [DF_Achat_Product_LastUpdate]  DEFAULT (getdate()),
 CONSTRAINT [PK_Achat_Product] PRIMARY KEY CLUSTERED
(
    [ProductId] ASC,
    [MarchandId] 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
GO
/****** Object:  Table [dbo].[Achat_Product_Price_History]    Script Date: 06/10/2010 14:50:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Achat_Product_Price_History](
    [ProductId] [VARCHAR](35) NOT NULL,
    [MarchandId] [INT] NOT NULL,
    [LastUpdate] [smalldatetime] NOT NULL CONSTRAINT [DF_Achat_Product_Price_History_LastUpdate]  DEFAULT (getdate()),
    [Price] [FLOAT] NOT NULL CONSTRAINT [DF_Achat_Product_Price_History_Price]  DEFAULT ((0)),
 CONSTRAINT [PK_achat_product_price_history] PRIMARY KEY CLUSTERED
(
    [ProductId] ASC,
    [MarchandId] ASC,
    [LastUpdate] 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
GO
ALTER TABLE [dbo].[Achat_Product]  WITH CHECK ADD  CONSTRAINT [FK_Achat_Product_Achat_Marchand] FOREIGN KEY([MarchandId])
REFERENCES [dbo].[Achat_Marchand] ([Id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Achat_Product] CHECK CONSTRAINT [FK_Achat_Product_Achat_Marchand]
GO
ALTER TABLE [dbo].[Achat_Product_Price_History]  WITH CHECK ADD  CONSTRAINT [FK_Achat_Product_Price_History_Achat_Product] FOREIGN KEY([ProductId], [MarchandId])
REFERENCES [dbo].[Achat_Product] ([ProductId], [MarchandId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Achat_Product_Price_History] CHECK CONSTRAINT [FK_Achat_Product_Price_History_Achat_Product]