SQLize | PHPize | SQLtest

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Agent]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](150) NOT NULL, [AgentTypeID] [int] NOT NULL, [Address] [nvarchar](300) NULL, [INN] [varchar](12) NOT NULL, [KPP] [varchar](9) NULL, [DirectorName] [nvarchar](100) NULL, [Phone] [nvarchar](20) NOT NULL, [Email] [nvarchar](255) NULL, [Logo] [nvarchar](100) NULL, [Priority] [int] NOT NULL, CONSTRAINT [PK_Agent] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AgentPriorityHistory]( [ID] [int] IDENTITY(1,1) NOT NULL, [AgentID] [int] NOT NULL, [ChangeDate] [datetime] NOT NULL, [PriorityValue] [int] NOT NULL, CONSTRAINT [PK_AgentPriorityHistory] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AgentType]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](50) NOT NULL, [Image] [nvarchar](100) NULL, CONSTRAINT [PK_AgentType] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Material]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](100) NOT NULL, [CountInPack] [int] NOT NULL, [Unit] [nvarchar](10) NOT NULL, [CountInStock] [float] NULL, [MinCount] [float] NOT NULL, [Description] [nvarchar](max) NULL, [Cost] [decimal](10, 2) NOT NULL, [Image] [nvarchar](100) NULL, [MaterialTypeID] [int] NOT NULL, CONSTRAINT [PK_Material] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MaterialCountHistory]( [ID] [int] IDENTITY(1,1) NOT NULL, [MaterialID] [int] NOT NULL, [ChangeDate] [datetime] NOT NULL, [CountValue] [float] NOT NULL, CONSTRAINT [PK_MaterialCountHistory] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MaterialSupplier]( [MaterialID] [int] NOT NULL, [SupplierID] [int] NOT NULL, CONSTRAINT [PK_MaterialSupplier] PRIMARY KEY CLUSTERED ( [MaterialID] ASC, [SupplierID] 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_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MaterialType]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](50) NOT NULL, [DefectedPercent] [float] NOT NULL, CONSTRAINT [PK_MaterialType] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](100) NOT NULL, [ProductTypeID] [int] NULL, [ArticleNumber] [nvarchar](10) NOT NULL, [Description] [nvarchar](max) NULL, [Image] [nvarchar](100) NULL, [ProductionPersonCount] [int] NULL, [ProductionWorkshopNumber] [int] NULL, [MinCostForAgent] [decimal](10, 2) NOT NULL, CONSTRAINT [PK_Product] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProductCostHistory]( [ID] [int] IDENTITY(1,1) NOT NULL, [ProductID] [int] NOT NULL, [ChangeDate] [datetime] NOT NULL, [CostValue] [decimal](10, 2) NOT NULL, CONSTRAINT [PK_ProductCostHistory] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProductMaterial]( [ProductID] [int] NOT NULL, [MaterialID] [int] NOT NULL, [Count] [float] NULL, CONSTRAINT [PK_ProductMaterial] PRIMARY KEY CLUSTERED ( [ProductID] ASC, [MaterialID] 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_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProductSale]( [ID] [int] IDENTITY(1,1) NOT NULL, [AgentID] [int] NOT NULL, [ProductID] [int] NOT NULL, [SaleDate] [date] NOT NULL, [ProductCount] [int] NOT NULL, CONSTRAINT [PK_ProductSale] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ProductType]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](50) NOT NULL, [DefectedPercent] [float] NOT NULL, CONSTRAINT [PK_ProductType] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Shop]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](150) NOT NULL, [Address] [nvarchar](300) NULL, [AgentID] [int] NOT NULL, CONSTRAINT [PK_Shop] 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 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Supplier]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](150) NOT NULL, [INN] [varchar](12) NOT NULL, [StartDate] [date] NOT NULL, [QualityRating] [int] NULL, [SupplierType] [nvarchar](20) NULL, CONSTRAINT [PK_Supplier] 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].[Agent] WITH CHECK ADD CONSTRAINT [FK_Agent_AgentType] FOREIGN KEY([AgentTypeID]) REFERENCES [dbo].[AgentType] ([ID]) GO ALTER TABLE [dbo].[Agent] CHECK CONSTRAINT [FK_Agent_AgentType] GO ALTER TABLE [dbo].[AgentPriorityHistory] WITH CHECK ADD CONSTRAINT [FK_AgentPriorityHistory_Agent] FOREIGN KEY([AgentID]) REFERENCES [dbo].[Agent] ([ID]) GO ALTER TABLE [dbo].[AgentPriorityHistory] CHECK CONSTRAINT [FK_AgentPriorityHistory_Agent] GO ALTER TABLE [dbo].[Material] WITH CHECK ADD CONSTRAINT [FK_Material_MaterialType] FOREIGN KEY([MaterialTypeID]) REFERENCES [dbo].[MaterialType] ([ID]) GO ALTER TABLE [dbo].[Material] CHECK CONSTRAINT [FK_Material_MaterialType] GO ALTER TABLE [dbo].[MaterialCountHistory] WITH CHECK ADD CONSTRAINT [FK_MaterialCountHistory_Material] FOREIGN KEY([MaterialID]) REFERENCES [dbo].[Material] ([ID]) GO ALTER TABLE [dbo].[MaterialCountHistory] CHECK CONSTRAINT [FK_MaterialCountHistory_Material] GO ALTER TABLE [dbo].[MaterialSupplier] WITH CHECK ADD CONSTRAINT [FK_MaterialSupplier_Material] FOREIGN KEY([MaterialID]) REFERENCES [dbo].[Material] ([ID]) GO ALTER TABLE [dbo].[MaterialSupplier] CHECK CONSTRAINT [FK_MaterialSupplier_Material] GO ALTER TABLE [dbo].[MaterialSupplier] WITH CHECK ADD CONSTRAINT [FK_MaterialSupplier_Supplier] FOREIGN KEY([SupplierID]) REFERENCES [dbo].[Supplier] ([ID]) GO ALTER TABLE [dbo].[MaterialSupplier] CHECK CONSTRAINT [FK_MaterialSupplier_Supplier] GO ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_ProductType] FOREIGN KEY([ProductTypeID]) REFERENCES [dbo].[ProductType] ([ID]) GO ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_ProductType] GO ALTER TABLE [dbo].[ProductCostHistory] WITH CHECK ADD CONSTRAINT [FK_ProductCostHistory_Product] FOREIGN KEY([ProductID]) REFERENCES [dbo].[Product] ([ID]) GO ALTER TABLE [dbo].[ProductCostHistory] CHECK CONSTRAINT [FK_ProductCostHistory_Product] GO ALTER TABLE [dbo].[ProductMaterial] WITH CHECK ADD CONSTRAINT [FK_ProductMaterial_Material] FOREIGN KEY([MaterialID]) REFERENCES [dbo].[Material] ([ID]) GO ALTER TABLE [dbo].[ProductMaterial] CHECK CONSTRAINT [FK_ProductMaterial_Material] GO ALTER TABLE [dbo].[ProductMaterial] WITH CHECK ADD CONSTRAINT [FK_ProductMaterial_Product] FOREIGN KEY([ProductID]) REFERENCES [dbo].[Product] ([ID]) GO ALTER TABLE [dbo].[ProductMaterial] CHECK CONSTRAINT [FK_ProductMaterial_Product] GO ALTER TABLE [dbo].[ProductSale] WITH CHECK ADD CONSTRAINT [FK_ProductSale_Agent] FOREIGN KEY([AgentID]) REFERENCES [dbo].[Agent] ([ID]) GO ALTER TABLE [dbo].[ProductSale] CHECK CONSTRAINT [FK_ProductSale_Agent] GO ALTER TABLE [dbo].[ProductSale] WITH CHECK ADD CONSTRAINT [FK_ProductSale_Product] FOREIGN KEY([ProductID]) REFERENCES [dbo].[Product] ([ID]) GO ALTER TABLE [dbo].[ProductSale] CHECK CONSTRAINT [FK_ProductSale_Product] GO ALTER TABLE [dbo].[Shop] WITH CHECK ADD CONSTRAINT [FK_Shop_Agent] FOREIGN KEY([AgentID]) REFERENCES [dbo].[Agent] ([ID]) GO ALTER TABLE [dbo].[Shop] CHECK CONSTRAINT [FK_Shop_Agent] GO