GO
/****** Object:  Table [dbo].[Car]    Script Date: 4/07/2013 14:46:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Car](
	[ID] [uniqueidentifier] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModificationDate] [datetime] NOT NULL,
	[Published] [bit] NOT NULL,
	[DealerID] [uniqueidentifier] NOT NULL,
	[OrderID] [int] NOT NULL,
	[Model] [uniqueidentifier] NOT NULL,
	[ModelSpecification] [uniqueidentifier] NOT NULL,
	[Km] [float] NOT NULL,
	[Price] [float] NOT NULL,
	[Advantage] [float] NOT NULL,
	[CustomPicture] [uniqueidentifier] NULL,
	[Color] [uniqueidentifier] NOT NULL,
	[Finishes] [uniqueidentifier] NOT NULL,
	[Options] [uniqueidentifier] NOT NULL,
	[Pollution] [uniqueidentifier] NULL,
	[Transmission] [int] NOT NULL,
	[Fuel] [int] NOT NULL,
	[Type] [int] NOT NULL,
	[AvailableDate] [date] NULL,
	[ListPrice] [float] NOT NULL,
	[ContactUrl] [text] NULL,
	[ContactType] [int] NULL,
 CONSTRAINT [PK_Cars] 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] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[CarTranslation]    Script Date: 4/07/2013 14:46:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CarTranslation](
	[ItemID] [uniqueidentifier] NOT NULL,
	[FieldID] [uniqueidentifier] NOT NULL,
	[ISO] [char](2) NOT NULL,
	[Term] [text] NOT NULL,
 CONSTRAINT [PK_CarTranslation] PRIMARY KEY CLUSTERED 
(
	[ItemID] ASC,
	[FieldID] ASC,
	[ISO] 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
GO
ALTER TABLE [dbo].[Car] ADD  CONSTRAINT [DF_Cars_CreationDate]  DEFAULT (getdate()) FOR [CreationDate]
GO
ALTER TABLE [dbo].[Car] ADD  CONSTRAINT [DF_Cars_ModificationDate]  DEFAULT (getdate()) FOR [ModificationDate]
GO
ALTER TABLE [dbo].[Car] ADD  CONSTRAINT [DF_Cars_Deleted]  DEFAULT ((0)) FOR [Published]
GO
ALTER TABLE [dbo].[CarTranslation]  WITH CHECK ADD  CONSTRAINT [FK_CarTranslation_Cars] FOREIGN KEY([ItemID])
REFERENCES [dbo].[Car] ([ID])
GO
ALTER TABLE [dbo].[CarTranslation] CHECK CONSTRAINT [FK_CarTranslation_Cars]
GO