SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Attribute]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Attribute](
	[AttributeId] [int] NOT NULL,
	[AttributeName] [varchar]( 64 ) NOT NULL,
 CONSTRAINT [PK_Attribute] PRIMARY KEY CLUSTERED 
(
	[AttributeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Tovar]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Tovar](
	[TovarId] [int] IDENTITY( 1 , 1 ) NOT NULL,
	[TovarName] [varchar]( 64 ) NULL,
	[DateCreate] [datetime] NULL,
	[Price] [money] NULL,
 CONSTRAINT [PK_Tovar] PRIMARY KEY CLUSTERED 
(
	[TovarId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TovarAttribute]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TovarAttribute](
	[TovarId] [int] NOT NULL,
	[AttributeId] [int] NOT NULL,
 CONSTRAINT [PK_TovarAttribute] PRIMARY KEY CLUSTERED 
(
	[TovarId] ASC,
	[AttributeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TovarAttribute_Attribute]') AND parent_object_id = OBJECT_ID(N'[dbo].[TovarAttribute]'))
ALTER TABLE [dbo].[TovarAttribute]  WITH CHECK ADD  CONSTRAINT [FK_TovarAttribute_Attribute] FOREIGN KEY([AttributeId])
REFERENCES [dbo].[Attribute] ([AttributeId])
GO
ALTER TABLE [dbo].[TovarAttribute] CHECK CONSTRAINT [FK_TovarAttribute_Attribute]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TovarAttribute_Tovar]') AND parent_object_id = OBJECT_ID(N'[dbo].[TovarAttribute]'))
ALTER TABLE [dbo].[TovarAttribute]  WITH CHECK ADD  CONSTRAINT [FK_TovarAttribute_Tovar] FOREIGN KEY([TovarId])
REFERENCES [dbo].[Tovar] ([TovarId])
GO
ALTER TABLE [dbo].[TovarAttribute] CHECK CONSTRAINT [FK_TovarAttribute_Tovar]