Base.sql - master - Yashka/TZ

Base.sql
542 строки27 KB
Yashka
upload files
21 май 2025, 14:48
21 май 2025, 14:4894f99fa
create database MasterPol67
go
USE [MasterPol67]
GO
/****** Object:  Table [dbo].[City]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[City](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[RegionID] [int] NOT NULL,
 CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Discount]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Discount](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[SizeInPercent] [int] NOT NULL,
 CONSTRAINT [PK_Discount] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DiscountPartner]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DiscountPartner](
	[DiscountID] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Date] [date] NOT NULL,
 CONSTRAINT [PK_DiscountPartner] PRIMARY KEY CLUSTERED 
(
	[DiscountID] ASC,
	[PartnerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Material]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Material](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[DefectRate] [decimal](6, 4) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MeasureProductType]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MeasureMaterialType](
	[MeasureID] [int] NOT NULL,
	[MaterialTypeID] [int] NOT NULL,
 CONSTRAINT [PK_MeasureProductType] PRIMARY KEY CLUSTERED 
(
	[MeasureID] ASC,
	[MaterialTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MeasureUnit]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MeasureUnit](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[ShortMeasure] [varchar](5) NOT NULL,
 CONSTRAINT [PK_MeasureUnit] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Package]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Package](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[HeightMeters] [decimal](8, 2) NOT NULL,
	[WidthMaters] [decimal](8, 2) NOT NULL,
	[LengthMeters] [decimal](8, 2) NOT NULL,
	[WeightKg] [decimal](8, 2) NOT NULL,
 CONSTRAINT [PK_Package] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Partner]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Partner](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[PartnerTypeID] [int] NOT NULL,
	[DirectorSNP] [varchar](100) NOT NULL,
	[Email] [varchar](50) NOT NULL,
	[PhoneNumber] [varchar](12) NOT NULL,
	[INN] [varchar](12) NOT NULL,
	[StreetID] [int] NULL,
 CONSTRAINT [PK_Partner] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PartnerProduct]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PartnerProduct](
	[ProductID] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[ProductAmount] [int] NOT NULL,
	[SaleDate] [datetime] NOT NULL,
 CONSTRAINT [PK_PartnerProduct] PRIMARY KEY CLUSTERED 
(
	[ProductID] ASC,
	[PartnerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PartnerRating]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PartnerRating](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[NewRating] [int] NOT NULL,
	[PartnerID] [int] NOT NULL,
	[Date] [date] NOT NULL,
 CONSTRAINT [PK_PartnerRating] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PartnerType]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PartnerType](
	[TypeID] [int] IDENTITY(1,1) NOT NULL,
	[TypeName] [varchar](50) NOT NULL,
 CONSTRAINT [PK_PartnerType] PRIMARY KEY CLUSTERED 
(
	[TypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Product]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TypeID] [int] NOT NULL,
	[Name] [varchar](100) NOT NULL,
	[Article] [varchar](20) NOT NULL,
	[Weight] [decimal](8, 2) NULL,
	[PackageID] [int] 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProductMaterial]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductMaterial](
	[ProductID] [int] NOT NULL,
	[MaterialID] [int] NOT 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProductMinCostHistory]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductMinCostHistory](
	[ProductID] [int] NOT NULL,
	[MinCost] [decimal](8, 2) NOT NULL,
	[Date] [date] NOT NULL,
 CONSTRAINT [PK_ProductMinCostHistory_1] PRIMARY KEY CLUSTERED 
(
	[ProductID] ASC,
	[MinCost] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProductType]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductType](
	[TypeID] [int] IDENTITY(1,1) NOT NULL,
	[TypeName] [varchar](50) NOT NULL,
	[TypeCoefficient] [decimal](8, 2) NOT NULL,
 CONSTRAINT [PK_ProductType] PRIMARY KEY CLUSTERED 
(
	[TypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Region]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
 CONSTRAINT [PK_Region] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Street]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Street](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[House] [int] NOT NULL,
 CONSTRAINT [PK_Street] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[StreetCity]    Script Date: 20.05.2025 15:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StreetCity](
	[CityID] [int] NOT NULL,
	[StreetID] [int] NOT NULL,
 CONSTRAINT [PK_StreetCity] PRIMARY KEY CLUSTERED 
(
	[CityID] ASC,
	[StreetID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[City] ON 

INSERT [dbo].[City] ([ID], [Name], [RegionID]) VALUES (1, N'����', 1)
INSERT [dbo].[City] ([ID], [Name], [RegionID]) VALUES (2, N'������������', 2)
INSERT [dbo].[City] ([ID], [Name], [RegionID]) VALUES (3, N'��������', 3)
INSERT [dbo].[City] ([ID], [Name], [RegionID]) VALUES (4, N'������', 4)
INSERT [dbo].[City] ([ID], [Name], [RegionID]) VALUES (5, N'������ �����', 5)
SET IDENTITY_INSERT [dbo].[City] OFF
GO
SET IDENTITY_INSERT [dbo].[Discount] ON 

INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (1, 0)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (2, 5)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (3, 10)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (4, 15)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (5, 10)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (6, 5)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (7, 0)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (8, 10)
INSERT [dbo].[Discount] ([ID], [SizeInPercent]) VALUES (9, 15)
SET IDENTITY_INSERT [dbo].[Discount] OFF
GO
INSERT [dbo].[DiscountPartner] ([DiscountID], [PartnerID], [Date]) VALUES (5, 6, CAST(N'2025-05-19' AS Date))
INSERT [dbo].[DiscountPartner] ([DiscountID], [PartnerID], [Date]) VALUES (6, 7, CAST(N'2025-05-20' AS Date))
INSERT [dbo].[DiscountPartner] ([DiscountID], [PartnerID], [Date]) VALUES (7, 8, CAST(N'2025-05-20' AS Date))
INSERT [dbo].[DiscountPartner] ([DiscountID], [PartnerID], [Date]) VALUES (8, 9, CAST(N'2025-05-19' AS Date))
INSERT [dbo].[DiscountPartner] ([DiscountID], [PartnerID], [Date]) VALUES (9, 10, CAST(N'2025-05-19' AS Date))
GO
SET IDENTITY_INSERT [dbo].[Material] ON 

INSERT [dbo].[Material] ([ID], [Name], [DefectRate]) VALUES (1, N'��� ��������� 1', CAST(0.0010 AS Decimal(6, 4)))
INSERT [dbo].[Material] ([ID], [Name], [DefectRate]) VALUES (2, N'��� ��������� 2', CAST(0.0095 AS Decimal(6, 4)))
INSERT [dbo].[Material] ([ID], [Name], [DefectRate]) VALUES (3, N'��� ��������� 3', CAST(0.0028 AS Decimal(6, 4)))
INSERT [dbo].[Material] ([ID], [Name], [DefectRate]) VALUES (4, N'��� ��������� 4', CAST(0.0055 AS Decimal(6, 4)))
INSERT [dbo].[Material] ([ID], [Name], [DefectRate])VALUES (5, N'��� ��������� 5', CAST(0.0034 AS Decimal(6, 4)))
SET IDENTITY_INSERT [dbo].[Material] OFF
GO
INSERT [dbo].[MeasureMaterialType] ([MeasureID], [MaterialTypeID]) VALUES (1, 1)
INSERT [dbo].[MeasureMaterialType] ([MeasureID], [MaterialTypeID]) VALUES (2, 2)
INSERT [dbo].[MeasureMaterialType] ([MeasureID], [MaterialTypeID]) VALUES (2, 3)
INSERT [dbo].[MeasureMaterialType] ([MeasureID], [MaterialTypeID]) VALUES (3, 4)
GO
SET IDENTITY_INSERT [dbo].[MeasureUnit] ON 

INSERT [dbo].[MeasureUnit] ([ID], [Name], [ShortMeasure]) VALUES (1, N'�����', N'�')
INSERT [dbo].[MeasureUnit] ([ID], [Name], [ShortMeasure]) VALUES (2, N'��������', N'���.�')
INSERT [dbo].[MeasureUnit] ([ID], [Name], [ShortMeasure]) VALUES (3, N'���������� ����', N'��.�')
INSERT [dbo].[MeasureUnit] ([ID], [Name], [ShortMeasure]) VALUES (5, N'�����', N'��')
SET IDENTITY_INSERT [dbo].[MeasureUnit] OFF
GO
SET IDENTITY_INSERT [dbo].[Package] ON 

INSERT [dbo].[Package] ([ID], [HeightMeters], [WidthMaters], [LengthMeters], [WeightKg]) VALUES (1, CAST(0.50 AS Decimal(8, 2)), CAST(0.25 AS Decimal(8, 2)), CAST(0.03 AS Decimal(8, 2)), CAST(10.00 AS Decimal(8, 2)))
INSERT [dbo].[Package] ([ID], [HeightMeters], [WidthMaters], [LengthMeters], [WeightKg]) VALUES (2, CAST(0.45 AS Decimal(8, 2)), CAST(0.13 AS Decimal(8, 2)), CAST(0.02 AS Decimal(8, 2)), CAST(11.20 AS Decimal(8, 2)))
INSERT [dbo].[Package] ([ID], [HeightMeters], [WidthMaters], [LengthMeters], [WeightKg]) VALUES (3, CAST(0.34 AS Decimal(8, 2)), CAST(0.10 AS Decimal(8, 2)), CAST(0.15 AS Decimal(8, 2)), CAST(15.50 AS Decimal(8, 2)))
SET IDENTITY_INSERT [dbo].[Package] OFF
GO
SET IDENTITY_INSERT [dbo].[Partner] ON 

INSERT [dbo].[Partner] ([ID], [Name], [PartnerTypeID], [DirectorSNP], [Email], [PhoneNumber], [INN], [StreetID]) VALUES (6, N'���� ���������', 1, N'������� ���������� ��������', N'aleksandraivanova@ml.ru', N'4931234567', N'2222455179', 1)
INSERT [dbo].[Partner] ([ID], [Name], [PartnerTypeID], [DirectorSNP], [Email], [PhoneNumber], [INN], [StreetID]) VALUES (7, N'������ 29', 2, N'������ ������� ��������', N'vppetrov@vl.ru', N'9871235678', N'3333888520', 2)
INSERT [dbo].[Partner] ([ID], [Name], [PartnerTypeID], [DirectorSNP], [Email], [PhoneNumber], [INN], [StreetID]) VALUES (8, N'�����������', 3, N'�������� ������ ����������', N'ansolovev@st.ru', N'812223320', N'4440391035', 3)
INSERT [dbo].[Partner] ([ID], [Name], [PartnerTypeID], [DirectorSNP], [Email], [PhoneNumber], [INN], [StreetID]) VALUES (9, N'������ � �������', 4, N'��������� ��������� ����������', N'ekaterina.vorobeva@ml.ru', N'4442223311', N'1111520857', 4)
INSERT [dbo].[Partner] ([ID], [Name], [PartnerTypeID], [DirectorSNP], [Email], [PhoneNumber], [INN], [StreetID]) VALUES (10, N'���������', 1, N'�������� ������ ���������', N'stepanov@stepan.ru', N'9128883333', N'5552431140', 5)
SET IDENTITY_INSERT [dbo].[Partner] OFF
GO
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (1, 6, 15500, CAST(N'2023-03-23T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (1, 7, 7550, CAST(N'2024-07-01T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (1, 8, 7250, CAST(N'2023-01-22T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (1, 10, 35000, CAST(N'2024-04-15T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (3, 6, 12350, CAST(N'2023-12-18T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (3, 7, 1000, CAST(N'2024-06-07T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (3, 9, 37200, CAST(N'2024-03-12T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (3, 10, 50000, CAST(N'2023-09-19T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (4, 6, 37400, CAST(N'2024-06-07T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (4, 9, 59050, CAST(N'2023-03-20T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (4, 10, 670000, CAST(N'2023-11-10T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (5, 7, 1250, CAST(N'2023-05-17T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (5, 9, 4500, CAST(N'2024-05-14T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (6, 7, 35000, CAST(N'2022-12-02T00:00:00.000' AS DateTime))
INSERT [dbo].[PartnerProduct] ([ProductID], [PartnerID], [ProductAmount], [SaleDate]) VALUES (6, 8, 2500, CAST(N'2024-07-05T00:00:00.000' AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[PartnerRating] ON 

INSERT [dbo].[PartnerRating] ([ID], [NewRating], [PartnerID], [Date]) VALUES (6, 7, 6, CAST(N'2022-05-13' AS Date))
INSERT [dbo].[PartnerRating] ([ID], [NewRating], [PartnerID], [Date]) VALUES (7, 7, 7, CAST(N'2024-08-07' AS Date))
INSERT [dbo].[PartnerRating] ([ID], [NewRating], [PartnerID], [Date]) VALUES (8, 7, 8, CAST(N'2020-11-28' AS Date))
INSERT [dbo].[PartnerRating] ([ID], [NewRating], [PartnerID], [Date]) VALUES (9, 5, 9, CAST(N'2025-05-13' AS Date))
INSERT [dbo].[PartnerRating] ([ID], [NewRating], [PartnerID], [Date]) VALUES (10, 10, 10, CAST(N'2024-01-01' AS Date))
SET IDENTITY_INSERT [dbo].[PartnerRating] OFF
GO
SET IDENTITY_INSERT [dbo].[PartnerType] ON 

INSERT [dbo].[PartnerType] ([TypeID], [TypeName]) VALUES (1, N'���')
INSERT [dbo].[PartnerType] ([TypeID], [TypeName]) VALUES (2, N'���')
INSERT [dbo].[PartnerType] ([TypeID], [TypeName]) VALUES (3, N'���')
INSERT [dbo].[PartnerType] ([TypeID], [TypeName]) VALUES (4, N'���')
SET IDENTITY_INSERT [dbo].[PartnerType] OFF
GO
SET IDENTITY_INSERT [dbo].[Product] ON 

INSERT [dbo].[Product] ([ID], [TypeID], [Name], [Article], [Weight], [PackageID]) VALUES (1, 3, N'��������� ����� ����� ������ ������������ 14 ��', N'8758385', CAST(20.00 AS Decimal(8, 2)), 1)
INSERT [dbo].[Product] ([ID], [TypeID], [Name], [Article], [Weight], [PackageID]) VALUES (3, 1, N'������� ��� �������-����� 33 ����� 12 ��', N'7750282', CAST(10.20 AS Decimal(8, 2)), 1)
INSERT [dbo].[Product] ([ID], [TypeID], [Name], [Article], [Weight], [PackageID]) VALUES (4, 1, N'������� ��� ����� 32 ����� 8 �� � ������', N'7028748', CAST(9.20 AS Decimal(8, 2)), 2)
INSERT [dbo].[Product] ([ID], [TypeID], [Name], [Article], [Weight], [PackageID]) VALUES (5, 4, N'��������� ��������� ������� �������� 32 ����� 4 ��', N'5012543', CAST(8.34 AS Decimal(8, 2)), 3)
INSERT [dbo].[Product] ([ID], [TypeID], [Name], [Article], [Weight], [PackageID]) VALUES (6, 3, N'���������� ����� ��� ����������� ���� ������������ 12 ��', N'8858958', CAST(9.02 AS Decimal(8, 2)), 3)
SET IDENTITY_INSERT [dbo].[Product] OFF
GO
INSERT [dbo].[ProductMaterial] ([ProductID], [MaterialID]) VALUES (1, 1)
INSERT [dbo].[ProductMaterial] ([ProductID], [MaterialID]) VALUES (3, 2)
INSERT [dbo].[ProductMaterial] ([ProductID], [MaterialID]) VALUES (4, 3)
INSERT [dbo].[ProductMaterial] ([ProductID], [MaterialID]) VALUES (5, 3)
INSERT [dbo].[ProductMaterial] ([ProductID], [MaterialID]) VALUES (6, 4)
INSERT [dbo].[ProductMaterial] ([ProductID], [MaterialID]) VALUES (6, 5)
GO
INSERT [dbo].[ProductMinCostHistory] ([ProductID], [MinCost], [Date]) VALUES (1, CAST(12500.00 AS Decimal(8, 2)), CAST(N'2021-01-14' AS Date))
INSERT [dbo].[ProductMinCostHistory] ([ProductID], [MinCost], [Date]) VALUES (1, CAST(13500.00 AS Decimal(8, 2)), CAST(N'2022-05-13' AS Date))
INSERT [dbo].[ProductMinCostHistory] ([ProductID], [MinCost], [Date]) VALUES (3, CAST(25000.00 AS Decimal(8, 2)), CAST(N'2024-05-14' AS Date))
INSERT [dbo].[ProductMinCostHistory] ([ProductID], [MinCost], [Date]) VALUES (4, CAST(34000.00 AS Decimal(8, 2)), CAST(N'2023-08-09' AS Date))
INSERT [dbo].[ProductMinCostHistory] ([ProductID], [MinCost], [Date]) VALUES (5, CAST(50000.00 AS Decimal(8, 2)), CAST(N'2024-02-01' AS Date))
INSERT [dbo].[ProductMinCostHistory] ([ProductID], [MinCost], [Date]) VALUES (6, CAST(12500.00 AS Decimal(8, 2)), CAST(N'2022-05-05' AS Date))
GO
SET IDENTITY_INSERT [dbo].[ProductType] ON 

INSERT [dbo].[ProductType] ([TypeID], [TypeName], [TypeCoefficient]) VALUES (1, N'�������', CAST(2.35 AS Decimal(8, 2)))
INSERT [dbo].[ProductType] ([TypeID], [TypeName], [TypeCoefficient]) VALUES (2, N'��������� �����', CAST(5.15 AS Decimal(8, 2)))
INSERT [dbo].[ProductType] ([TypeID], [TypeName], [TypeCoefficient]) VALUES (3, N'��������� �����', CAST(4.34 AS Decimal(8, 2)))
INSERT [dbo].[ProductType] ([TypeID], [TypeName], [TypeCoefficient]) VALUES (4, N'��������� ��������', CAST(1.50 AS Decimal(8, 2)))
SET IDENTITY_INSERT [dbo].[ProductType] OFF
GO
SET IDENTITY_INSERT [dbo].[Region] ON 

INSERT [dbo].[Region] ([ID], [Name]) VALUES (1, N'����������� �������')
INSERT [dbo].[Region] ([ID], [Name]) VALUES (2, N'������������� �������')
INSERT [dbo].[Region] ([ID], [Name]) VALUES (3, N'������������� �������')
INSERT [dbo].[Region] ([ID], [Name]) VALUES (4, N'���������� �������')
INSERT [dbo].[Region] ([ID], [Name]) VALUES (5, N'������������ �������')
SET IDENTITY_INSERT [dbo].[Region] OFF
GO
SET IDENTITY_INSERT [dbo].[Street] ON 

INSERT [dbo].[Street] ([ID], [Name], [House]) VALUES (1, N'������', 15)
INSERT [dbo].[Street] ([ID], [Name], [House]) VALUES (2, N'����������', 18)
INSERT [dbo].[Street] ([ID], [Name], [House]) VALUES (3, N'��������', 21)
INSERT [dbo].[Street] ([ID], [Name], [House]) VALUES (4, N'�������', 51)
INSERT [dbo].[Street] ([ID], [Name], [House]) VALUES (5, N'�������', 122)
SET IDENTITY_INSERT [dbo].[Street] OFF
GO
INSERT [dbo].[StreetCity] ([CityID], [StreetID]) VALUES (1, 1)
INSERT [dbo].[StreetCity] ([CityID], [StreetID]) VALUES (2, 2)
INSERT [dbo].[StreetCity] ([CityID], [StreetID]) VALUES (3, 3)
INSERT [dbo].[StreetCity] ([CityID], [StreetID]) VALUES (4, 4)
INSERT [dbo].[StreetCity] ([CityID], [StreetID]) VALUES (5, 5)
GO
ALTER TABLE [dbo].[City]  WITH CHECK ADD  CONSTRAINT [FK_City_Region] FOREIGN KEY([RegionID])
REFERENCES [dbo].[Region] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[City] CHECK CONSTRAINT [FK_City_Region]
GO
ALTER TABLE [dbo].[DiscountPartner]  WITH CHECK ADD  CONSTRAINT [FK_DiscountPartner_Discount] FOREIGN KEY([DiscountID])
REFERENCES [dbo].[Discount] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[DiscountPartner] CHECK CONSTRAINT [FK_DiscountPartner_Discount]
GO
ALTER TABLE [dbo].[DiscountPartner]  WITH CHECK ADD  CONSTRAINT [FK_DiscountPartner_Partner] FOREIGN KEY([PartnerID])
REFERENCES [dbo].[Partner] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[DiscountPartner] CHECK CONSTRAINT [FK_DiscountPartner_Partner]
GO
ALTER TABLE [dbo].[MeasureMaterialType]  WITH CHECK ADD  CONSTRAINT [FK_MeasureMaterialType_MeasureUnit] FOREIGN KEY([MeasureID])
REFERENCES [dbo].[MeasureUnit] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[MeasureMaterialType] CHECK CONSTRAINT [FK_MeasureMaterialType_MeasureUnit]
GO
ALTER TABLE [dbo].[MeasureMaterialType]  WITH CHECK ADD  CONSTRAINT [FK_MeasureMaterialType_ProductType] FOREIGN KEY([MaterialTypeID])
REFERENCES [dbo].[Material] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[MeasureMaterialType] CHECK CONSTRAINT [FK_MeasureMaterialType_ProductType]
GO
ALTER TABLE [dbo].[Partner]  WITH CHECK ADD  CONSTRAINT [FK_Partner_PartnerType] FOREIGN KEY([PartnerTypeID])
REFERENCES [dbo].[PartnerType] ([TypeID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Partner] CHECK CONSTRAINT [FK_Partner_PartnerType]
GO
ALTER TABLE [dbo].[Partner]  WITH CHECK ADD  CONSTRAINT [FK_Partner_Street] FOREIGN KEY([StreetID])
REFERENCES [dbo].[Street] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Partner] CHECK CONSTRAINT [FK_Partner_Street]
GO
ALTER TABLE [dbo].[PartnerProduct]  WITH CHECK ADD  CONSTRAINT [FK_PartnerProduct_Partner] FOREIGN KEY([PartnerID])
REFERENCES [dbo].[Partner] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PartnerProduct] CHECK CONSTRAINT [FK_PartnerProduct_Partner]
GO
ALTER TABLE [dbo].[PartnerProduct]  WITH CHECK ADD  CONSTRAINT [FK_PartnerProduct_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PartnerProduct] CHECK CONSTRAINT [FK_PartnerProduct_Product]
GO
ALTER TABLE [dbo].[PartnerRating]  WITH CHECK ADD  CONSTRAINT [FK_PartnerRating_Partner] FOREIGN KEY([PartnerID])
REFERENCES [dbo].[Partner] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PartnerRating] CHECK CONSTRAINT [FK_PartnerRating_Partner]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Package] FOREIGN KEY([PackageID])
REFERENCES [dbo].[Package] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Package]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_ProductType] FOREIGN KEY([TypeID])
REFERENCES [dbo].[ProductType] ([TypeID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_ProductType]
GO
ALTER TABLE [dbo].[ProductMaterial]  WITH CHECK ADD  CONSTRAINT [FK_ProductMaterial_Material] FOREIGN KEY([MaterialID])
REFERENCES [dbo].[Material] ([ID])
ON UPDATE CASCADE
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])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ProductMaterial] CHECK CONSTRAINT [FK_ProductMaterial_Product]
GO
ALTER TABLE [dbo].[ProductMinCostHistory]  WITH CHECK ADD  CONSTRAINT [FK_ProductMinCostHistory_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ProductMinCostHistory] CHECK CONSTRAINT [FK_ProductMinCostHistory_Product]
GO
ALTER TABLE [dbo].[StreetCity]  WITH CHECK ADD  CONSTRAINT [FK_StreetCity_City] FOREIGN KEY([CityID])
REFERENCES [dbo].[City] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StreetCity] CHECK CONSTRAINT [FK_StreetCity_City]
GO
ALTER TABLE [dbo].[StreetCity]  WITH CHECK ADD  CONSTRAINT [FK_StreetCity_Street] FOREIGN KEY([StreetID])
REFERENCES [dbo].[Street] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StreetCity] CHECK CONSTRAINT [FK_StreetCity_Street]
GO