Cut/SrezPy/DatabaseScript.sql

USE [master]
GO
/****** Object:  Database [sneiasckin]    Script Date: 26.02.2021 15:38:47 ******/
CREATE DATABASE [sneiasckin]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'sneiasckin', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\sneiasckin.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'sneiasckin_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\sneiasckin_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [sneiasckin] SET COMPATIBILITY_LEVEL = 130
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [sneiasckin].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [sneiasckin] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [sneiasckin] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [sneiasckin] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [sneiasckin] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [sneiasckin] SET ARITHABORT OFF 
GO
ALTER DATABASE [sneiasckin] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [sneiasckin] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [sneiasckin] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [sneiasckin] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [sneiasckin] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [sneiasckin] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [sneiasckin] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [sneiasckin] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [sneiasckin] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [sneiasckin] SET  ENABLE_BROKER 
GO
ALTER DATABASE [sneiasckin] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [sneiasckin] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [sneiasckin] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [sneiasckin] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [sneiasckin] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [sneiasckin] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [sneiasckin] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [sneiasckin] SET RECOVERY FULL 
GO
ALTER DATABASE [sneiasckin] SET  MULTI_USER 
GO
ALTER DATABASE [sneiasckin] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [sneiasckin] SET DB_CHAINING OFF 
GO
ALTER DATABASE [sneiasckin] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [sneiasckin] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [sneiasckin] SET DELAYED_DURABILITY = DISABLED 
GO
EXEC sys.sp_db_vardecimal_storage_format N'sneiasckin', N'ON'
GO
ALTER DATABASE [sneiasckin] SET QUERY_STORE = OFF
GO
USE [sneiasckin]
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
USE [sneiasckin]
GO
/****** Object:  Table [dbo].[Orders]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Orders](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IdTypePay] [int] NULL,
	[IdUser] [int] NULL,
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
/****** Object:  Table [dbo].[OrdersProduct]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrdersProduct](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IdOrder] [int] NULL,
	[IdProduct] [int] NULL,
	[CountProduct] [int] NULL,
	[Price] [decimal](18, 2) NULL,
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
/****** Object:  Table [dbo].[Privileges]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Privileges](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
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
/****** Object:  Table [dbo].[Product]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Weight] [int] NOT NULL,
	[Fasovka] [int] NOT NULL,
	[Price] [decimal](18, 2) NULL,
	[Amount] [decimal](18, 2) NULL,
	[ShtrihCode] [nvarchar](50) NULL,
 CONSTRAINT [PK__Product__3214EC07784E0BED] 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
/****** Object:  Table [dbo].[SessionUser]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SessionUser](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[DateStart] [datetime] NULL,
	[DateFinish] [datetime] NULL,
	[IdUser] [int] NULL,
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
/****** Object:  Table [dbo].[TypePay]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TypePay](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
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
/****** Object:  Table [dbo].[Users]    Script Date: 26.02.2021 15:38:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[Id] [int] IDENTITY(10000,1) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[MiddleName] [nvarchar](50) NOT NULL,
	[IdPrivileges] [int] NULL,
 CONSTRAINT [PK_Users] 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 IDENTITY_INSERT [dbo].[Privileges] ON 

INSERT [dbo].[Privileges] ([Id], [Name]) VALUES (1, N'Кассир')
SET IDENTITY_INSERT [dbo].[Privileges] OFF
GO
SET IDENTITY_INSERT [dbo].[Product] ON 

INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (1, N'Абрикос протертый с сахаром "ВитаФрут" 800гр*6шт, шт', 800, 6, CAST(61.56 AS Decimal(18, 2)), CAST(369.36 AS Decimal(18, 2)), N'142301240')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (2, N'Аджика ВЕРЕС острая 530гр*12 , шт', 530, 12, CAST(76.84 AS Decimal(18, 2)), CAST(922.08 AS Decimal(18, 2)), N'367649930')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (3, N'Аджика кавказская 0,25*12 ст/б.(Егорьевск), шт', 250, 12, CAST(21.60 AS Decimal(18, 2)), CAST(259.20 AS Decimal(18, 2)), N'348898471')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (4, N'Аджика по-грузински 0,280* 20 ст/б. Натрулли Зеленная крышка, шт', 280, 20, CAST(37.80 AS Decimal(18, 2)), CAST(756.00 AS Decimal(18, 2)), N'1144262198')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (5, N'Ананасы "БАРКО"(кольца) 580мл*24, шт', 580, 24, CAST(59.40 AS Decimal(18, 2)), CAST(1425.60 AS Decimal(18, 2)), N'196944118')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (6, N'Ананасы "БАРКО"(кольца) 850мл*24, шт', 850, 24, CAST(81.00 AS Decimal(18, 2)), CAST(1944.00 AS Decimal(18, 2)), N'520800632')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (7, N'Ананасы "БАРКО"(кусочки) 580мл*24, шт', 580, 24, CAST(48.60 AS Decimal(18, 2)), CAST(1166.40 AS Decimal(18, 2)), N'1185493584')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (8, N'Ананасы "БАРКО"(кусочки) 850мл*24, шт', 850, 24, CAST(77.76 AS Decimal(18, 2)), CAST(1866.24 AS Decimal(18, 2)), N'666200152')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (9, N'Ананасы "М.Р.S"(кольца) 3кг*6шт, шт', 3000, 6, CAST(345.60 AS Decimal(18, 2)), CAST(2073.60 AS Decimal(18, 2)), N'1063693978')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (10, N'Ананасы REAN (куски) 580мл (565гр) * 24шт ж/б , шт', 580, 24, CAST(75.60 AS Decimal(18, 2)), CAST(1814.40 AS Decimal(18, 2)), N'207225825')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (11, N'Ассорти Кормилица грибное 580 мл * 12, шт', 580, 12, CAST(114.48 AS Decimal(18, 2)), CAST(1373.76 AS Decimal(18, 2)), N'659230505')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (12, N'Ассорти мар.Мелень(кабчки,черри,огурцы) 900 гр*6 шт , шт', 900, 6, CAST(113.40 AS Decimal(18, 2)), CAST(680.40 AS Decimal(18, 2)), N'1039047658')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (13, N'Ассорти мар.Мелень(патис,черри,огурцы) 900 гр*6 шт , шт', 900, 6, CAST(110.16 AS Decimal(18, 2)), CAST(660.96 AS Decimal(18, 2)), N'73251235')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (14, N'Базилик Цикория 10г*45 , шт', 10000, 45, CAST(17.28 AS Decimal(18, 2)), CAST(777.60 AS Decimal(18, 2)), N'414264428')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (15, N'Баклажаны жаренные с овощами ВЕРЕС 0,500*12, шт', 500, 12, CAST(90.72 AS Decimal(18, 2)), CAST(1088.64 AS Decimal(18, 2)), N'819454544')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (16, N'Баклажаны Мелень по-Краснодарски с овощами 520гр * 6, шт', 520, 6, CAST(78.84 AS Decimal(18, 2)), CAST(473.04 AS Decimal(18, 2)), N'1245828045')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (17, N'Баклажаны Мелень по-Украински в аджике 510гр*6, шт', 510, 6, CAST(78.84 AS Decimal(18, 2)), CAST(473.04 AS Decimal(18, 2)), N'722034718')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (18, N'Балтимор Адмирал 320гр *12, шт', 320, 12, CAST(63.72 AS Decimal(18, 2)), CAST(764.64 AS Decimal(18, 2)), N'751365242')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (19, N'Балтимор Адмирал 530 гр * 8, шт', 530, 8, CAST(99.36 AS Decimal(18, 2)), CAST(794.88 AS Decimal(18, 2)), N'511221663')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (20, N'Балтимор Татарский 530 гр * 8 шт, шт', 530, 8, CAST(99.36 AS Decimal(18, 2)), CAST(794.88 AS Decimal(18, 2)), N'380743957')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (21, N'Балтимор Томатный 530 гр * 8 шт стекло, шт', 530, 8, CAST(99.36 AS Decimal(18, 2)), CAST(794.88 AS Decimal(18, 2)), N'126132889')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (22, N'Балтимор Цыганский 530 гр * 8 шт, шт', 530, 8, CAST(99.36 AS Decimal(18, 2)), CAST(794.88 AS Decimal(18, 2)), N'411374780')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (23, N'Баранина туш. Любимый Дом 0,340*45 выш/сорт , шт', 340, 45, CAST(110.05 AS Decimal(18, 2)), CAST(4952.25 AS Decimal(18, 2)), N'66578392')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (24, N'Баранина туш. Русский изыск (ГОСТ,ключ) 325г*36 , шт', 325, 36, CAST(170.59 AS Decimal(18, 2)), CAST(6141.24 AS Decimal(18, 2)), N'512267206')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (25, N'Биг Ланч Лапша бп ВЕДРО тушеная курица/лук 90г*24, шт', 90, 24, CAST(27.00 AS Decimal(18, 2)), CAST(648.00 AS Decimal(18, 2)), N'830110149')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (26, N'Бондюэль горошек зел. 0,212*12, шт', 212, 12, CAST(39.96 AS Decimal(18, 2)), CAST(479.52 AS Decimal(18, 2)), N'280194059')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (27, N'Бондюэль горошек зел. 420мл/400гр*12, шт', 400, 12, CAST(61.02 AS Decimal(18, 2)), CAST(732.24 AS Decimal(18, 2)), N'859254495')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (28, N'Бондюэль кукуруза 0,212л*12 , шт', 212, 12, CAST(41.04 AS Decimal(18, 2)), CAST(492.48 AS Decimal(18, 2)), N'56424740')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (29, N'Бондюэль фасоль белая 425мл./400гр*12, шт', 400, 12, CAST(54.00 AS Decimal(18, 2)), CAST(648.00 AS Decimal(18, 2)), N'1198477467')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (30, N'БОРЩ с капустой Рязанский продукт (500 гр * 12 шт), шт', 500, 12, CAST(25.92 AS Decimal(18, 2)), CAST(311.04 AS Decimal(18, 2)), N'233835028')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (31, N'Бульон домашний Ролтон куриный100г.* 24, шт', 100, 24, CAST(26.14 AS Decimal(18, 2)), CAST(627.36 AS Decimal(18, 2)), N'528234283')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (32, N'Бульон домашний Ролтон мясной 100г*24, шт', 100, 24, CAST(26.14 AS Decimal(18, 2)), CAST(627.36 AS Decimal(18, 2)), N'790195463')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (33, N'Ванилин 1,5г*100, шт', 1500, 100, CAST(3.24 AS Decimal(18, 2)), CAST(324.00 AS Decimal(18, 2)), N'14718723')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (34, N'Ванилин Велица 1,5гр*500шт, шт', 1500, 500, CAST(1.08 AS Decimal(18, 2)), CAST(540.00 AS Decimal(18, 2)), N'640156230')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (35, N'Ванильный сахар 32гр*120, шт', 32, 120, CAST(14.58 AS Decimal(18, 2)), CAST(1749.60 AS Decimal(18, 2)), N'511216589')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (36, N'ВБП Роллтон ассорти 60г*100, шт', 60, 100, CAST(11.47 AS Decimal(18, 2)), CAST(1147.00 AS Decimal(18, 2)), N'700221133')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (37, N'ВБП Роллтон говяжья 60г*42, шт', 60, 42, CAST(11.47 AS Decimal(18, 2)), CAST(481.74 AS Decimal(18, 2)), N'259695130')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (38, N'ВБП Роллтон куриная 60г*42, шт', 60, 42, CAST(11.47 AS Decimal(18, 2)), CAST(481.74 AS Decimal(18, 2)), N'1065167800')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (39, N'Ветчина 325гр*6 СОВОК (НДС 18%), шт', 325, 6, CAST(124.20 AS Decimal(18, 2)), CAST(745.20 AS Decimal(18, 2)), N'405046699')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (40, N'Ветчина Русский изыскь 0,325*18 ключ, шт', 325, 18, CAST(120.45 AS Decimal(18, 2)), CAST(2168.10 AS Decimal(18, 2)), N'714657530')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (41, N'Ветчина Русский изыскь 0,325*36 ключ, шт', 325, 36, CAST(127.44 AS Decimal(18, 2)), CAST(4587.84 AS Decimal(18, 2)), N'22413467')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (42, N'ГВОЗДИКА целая 10г.* 50 АльтаСпайс, шт', 10, 50, CAST(19.98 AS Decimal(18, 2)), CAST(999.00 AS Decimal(18, 2)), N'9514252')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (43, N'Геркулес 0,420*12 (NEW) Русский продукт кувшин б\п, шт', 420, 12, CAST(43.20 AS Decimal(18, 2)), CAST(518.40 AS Decimal(18, 2)), N'1023403272')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (44, N'Геркулес 0,500*12 (NEW) Русский продукт, шт', 500, 12, CAST(43.20 AS Decimal(18, 2)), CAST(518.40 AS Decimal(18, 2)), N'135543096')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (45, N'Геркулес 0,500*12 МПК (Быстр.) Русский продукт Монастырский, шт', 500, 12, CAST(43.20 AS Decimal(18, 2)), CAST(518.40 AS Decimal(18, 2)), N'378974632')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (46, N'Геркулес 400гр*14 Прод-Сервис, шт', 400, 14, CAST(14.04 AS Decimal(18, 2)), CAST(196.56 AS Decimal(18, 2)), N'291408017')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (47, N'Геркулес Агростандарт (400гр *20 шт), шт', 400, 20, CAST(16.74 AS Decimal(18, 2)), CAST(334.80 AS Decimal(18, 2)), N'781239919')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (48, N'Геркулес ЗАО ТД "Надежда" (500 гр* 18 шт), шт', 500, 18, CAST(18.90 AS Decimal(18, 2)), CAST(340.20 AS Decimal(18, 2)), N'574783453')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (49, N'Геркулес Экстра 1кг*10 шт (г.ОРЁЛ) ГОСТ 21149-93, шт', 1000, 10, CAST(48.60 AS Decimal(18, 2)), CAST(486.00 AS Decimal(18, 2)), N'718274329')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (50, N'Говядина туш. Береза ГОСТ 0,338*45, шт', 338, 45, CAST(129.60 AS Decimal(18, 2)), CAST(5832.00 AS Decimal(18, 2)), N'641865719')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (51, N'Говядина туш. Гродно 0,338*10 ключ, шт', 338, 10, CAST(129.60 AS Decimal(18, 2)), CAST(1296.00 AS Decimal(18, 2)), N'53699965')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (52, N'Говядина туш. КТК Калининград (Барко) в/с 0,325 гр*36 шт, шт', 325, 36, CAST(75.60 AS Decimal(18, 2)), CAST(2721.60 AS Decimal(18, 2)), N'39400933')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (53, N'Говядина туш. КТК Калининград в/с (Барко) 0,525 гр*24 шт, шт', 525, 24, CAST(124.20 AS Decimal(18, 2)), CAST(2980.80 AS Decimal(18, 2)), N'551206701')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (54, N'Говядина туш. Любимый дом ГОСТ высш/сорт 338 гр * 24 шт, шт', 338, 24, CAST(99.36 AS Decimal(18, 2)), CAST(2384.64 AS Decimal(18, 2)), N'537736928')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (55, N'Говядина туш. ОВА Богатырская ТУ 525гр*12 Балтпроммясо, шт', 525, 12, CAST(90.72 AS Decimal(18, 2)), CAST(1088.64 AS Decimal(18, 2)), N'698312019')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (56, N'Говядина туш. ОВА Богатырская ТУ 325гр*36 Балтпроммясо, шт', 325, 36, CAST(68.04 AS Decimal(18, 2)), CAST(2449.44 AS Decimal(18, 2)), N'709848478')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (57, N'Говядина туш. ОВА в/с 325гр*36шт Дейма Калининград, шт', 325, 36, CAST(88.94 AS Decimal(18, 2)), CAST(3201.84 AS Decimal(18, 2)), N'472759046')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (58, N'Говядина туш. Русский изыскь 325гр*36 ключ, шт', 325, 36, CAST(127.44 AS Decimal(18, 2)), CAST(4587.84 AS Decimal(18, 2)), N'392150274')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (59, N'Говядина туш. РУСЬ 500г*20шт (стекло) 1с ГОСТ, Фортуна, шт', 500, 20, CAST(69.12 AS Decimal(18, 2)), CAST(1382.40 AS Decimal(18, 2)), N'811077266')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (60, N'Говядина туш. Скопинск ГОСТ в/с 325 гр * 18, шт', 325, 18, CAST(91.80 AS Decimal(18, 2)), CAST(1652.40 AS Decimal(18, 2)), N'867635110')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (61, N'Говядина туш. Слонимский МК 338гр*45 в/с ж/б , шт', 338, 45, CAST(118.80 AS Decimal(18, 2)), CAST(5346.00 AS Decimal(18, 2)), N'1285068413')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (62, N'Говядина туш. Смоленская Балтпроммясо 325 гр * 36 шт, шт', 325, 36, CAST(43.20 AS Decimal(18, 2)), CAST(1555.20 AS Decimal(18, 2)), N'336481252')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (63, N'Говядина туш. Советск в/с ключ 0,338*10, шт', 338, 10, CAST(136.08 AS Decimal(18, 2)), CAST(1360.80 AS Decimal(18, 2)), N'335756751')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (64, N'Говядина туш. СОВОК в/с 325гр/6шт ключ, шт', 325, 6, CAST(137.16 AS Decimal(18, 2)), CAST(822.96 AS Decimal(18, 2)), N'927939672')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (65, N'Говядина туш. Сто рецептов 325гр*36шт (в/с ГОСТ Р 54033-2010), шт', 325, 36, CAST(66.55 AS Decimal(18, 2)), CAST(2395.80 AS Decimal(18, 2)), N'55935518')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (66, N'Голубика протертая с сахаром "ВитаФрут" 800гр*6шт, шт', 800, 6, CAST(61.56 AS Decimal(18, 2)), CAST(369.36 AS Decimal(18, 2)), N'643801031')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (67, N'Голубцы мясорастительные "Экстра" 0,54* 12, шт', 540, 12, CAST(58.32 AS Decimal(18, 2)), CAST(699.84 AS Decimal(18, 2)), N'1126127007')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (68, N'Горбуша нат. Янтарное ключ 0,245*24шт, шт', 245, 24, CAST(92.88 AS Decimal(18, 2)), CAST(2229.12 AS Decimal(18, 2)), N'346855744')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (69, N'Горбуша натур.245*48 Дальневосточная № 6, шт', 245, 48, CAST(74.52 AS Decimal(18, 2)), CAST(3576.96 AS Decimal(18, 2)), N'481189929')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (70, N'Горбуша натуральная Комп. Сакура 245г*48, шт', 245, 48, CAST(70.20 AS Decimal(18, 2)), CAST(3369.60 AS Decimal(18, 2)), N'81396145')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (71, N'Горох колотый 0,900гр/12 (Надежда), шт', 900, 12, CAST(34.56 AS Decimal(18, 2)), CAST(414.72 AS Decimal(18, 2)), N'846297096')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (72, N'Горох колотый 0.900 кг * 20 Агростандарт, шт', 900, 20, CAST(24.30 AS Decimal(18, 2)), CAST(486.00 AS Decimal(18, 2)), N'49489354')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (73, N'Горох колотый 900гр*14 Прод-Сервис, шт', 900, 14, CAST(24.30 AS Decimal(18, 2)), CAST(340.20 AS Decimal(18, 2)), N'557074791')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (74, N'Горох Мистраль Желтый Айдахо 500 гр*12, шт', 500, 12, CAST(58.55 AS Decimal(18, 2)), CAST(702.60 AS Decimal(18, 2)), N'1062807301')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (75, N'Горох Мистраль Желтый колотый 900 гр*12, шт', 900, 12, CAST(61.15 AS Decimal(18, 2)), CAST(733.80 AS Decimal(18, 2)), N'1212806910')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (76, N'Горох Мистраль шлиф. зеленый колотый ОРЕГОН 500*12, шт', 500, 12, CAST(84.24 AS Decimal(18, 2)), CAST(1010.88 AS Decimal(18, 2)), N'824730136')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (77, N'Горошек зеленый "Кубаночка" ж/б 400гр*12, шт', 400, 12, CAST(38.88 AS Decimal(18, 2)), CAST(466.56 AS Decimal(18, 2)), N'1184595684')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (78, N'Горошек зеленый Агрофуд мозговых сортов ж/б 400гр * 12, шт', 400, 12, CAST(28.08 AS Decimal(18, 2)), CAST(336.96 AS Decimal(18, 2)), N'615778920')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (79, N'Горошек зеленый Овощной край 400 гр *12 шт , шт', 400, 12, CAST(28.08 AS Decimal(18, 2)), CAST(336.96 AS Decimal(18, 2)), N'284390794')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (80, N'Горошек зеленый Русское Село 425мл*12 ж/б, шт', 425, 12, CAST(28.08 AS Decimal(18, 2)), CAST(336.96 AS Decimal(18, 2)), N'669493663')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (81, N'Горошек зеленый Южный Привоз в/с 400 гр * 12 шт ж/б, шт', 400, 12, CAST(28.08 AS Decimal(18, 2)), CAST(336.96 AS Decimal(18, 2)), N'75097307')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (82, N'Горчица Егорьевская Столовая 250гр*12, шт', 250, 12, CAST(21.60 AS Decimal(18, 2)), CAST(259.20 AS Decimal(18, 2)), N'87594697')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (83, N'Горчица МЖК 100г*48(туба) , шт', 100, 48, CAST(17.82 AS Decimal(18, 2)), CAST(855.36 AS Decimal(18, 2)), N'518884306')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (84, N'Горчица столичная "Русская" туба 100гр/48, шт', 100, 48, CAST(17.28 AS Decimal(18, 2)), CAST(829.44 AS Decimal(18, 2)), N'823473553')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (85, N'Горчичный порошок Велица 400гр*12шт, шт', 400, 12, CAST(32.40 AS Decimal(18, 2)), CAST(388.80 AS Decimal(18, 2)), N'1282478745')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (86, N'ГОРЧИЧНЫЙ порошок Поволжья 400г.*12шт, шт', 400, 12, CAST(34.56 AS Decimal(18, 2)), CAST(414.72 AS Decimal(18, 2)), N'1280432597')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (87, N'Гречка 0,9кг*20 шт Агростандарт, шт', 900, 20, CAST(30.24 AS Decimal(18, 2)), CAST(604.80 AS Decimal(18, 2)), N'534360113')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (88, N'Гречка 5кг*1шт Прод-Сервис , шт', 5000, 1, CAST(162.00 AS Decimal(18, 2)), CAST(162.00 AS Decimal(18, 2)), N'597424038')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (89, N'Гречка 900гр*14 Прод-Сервис, шт', 900, 14, CAST(37.80 AS Decimal(18, 2)), CAST(529.20 AS Decimal(18, 2)), N'927928642')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (90, N'Гречка ЗАО ТД "Надежда" (900 гр*12 шт), шт', 900, 12, CAST(35.10 AS Decimal(18, 2)), CAST(421.20 AS Decimal(18, 2)), N'698807402')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (91, N'Гречка Зеленая крупа Мистраль 450г*12, шт', 450, 12, CAST(71.82 AS Decimal(18, 2)), CAST(861.84 AS Decimal(18, 2)), N'357730985')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (92, N'Гречка Мистраль 0,9 кг*12, шт', 900, 12, CAST(70.20 AS Decimal(18, 2)), CAST(842.40 AS Decimal(18, 2)), N'690206140')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (93, N'Гречневый продел Чудо Зернышко 700гр*10, шт', 700, 10, CAST(30.24 AS Decimal(18, 2)), CAST(302.40 AS Decimal(18, 2)), N'752796645')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (94, N'Грибы марин. ассорти Владимирские Мелень 540гр*6шт , шт', 540, 6, CAST(196.56 AS Decimal(18, 2)), CAST(1179.36 AS Decimal(18, 2)), N'442327282')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (95, N'Грибы сушеные Ассорти 50гр*20шт ТМ "Экопродукт" пакет, шт', 50, 20, CAST(120.96 AS Decimal(18, 2)), CAST(2419.20 AS Decimal(18, 2)), N'944813799')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (96, N'Грузди Кормилица 580 гр * 12, шт', 500, 12, CAST(106.38 AS Decimal(18, 2)), CAST(1276.56 AS Decimal(18, 2)), N'378575600')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (97, N'ДРОЖЖИ "Воронежские" 0,500г.*20, шт', 500, 20, CAST(102.60 AS Decimal(18, 2)), CAST(2052.00 AS Decimal(18, 2)), N'1276138603')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (98, N'ДРОЖЖИ САФ-Инстант 0,500г.*20, шт', 500, 20, CAST(172.80 AS Decimal(18, 2)), CAST(3456.00 AS Decimal(18, 2)), N'15856338')
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (99, N'ДРОЖЖИ САФ-ИНТСТАНТ 125гр*36шт, шт', 125, 36, CAST(44.28 AS Decimal(18, 2)), CAST(1594.08 AS Decimal(18, 2)), N'688866976')
GO
INSERT [dbo].[Product] ([Id], [Name], [Weight], [Fasovka], [Price], [Amount], [ShtrihCode]) VALUES (100, N'ДРОЖЖИ САФ-МОМЕНТ 11г.*18*60, шт', 11, 18, CAST(10.26 AS Decimal(18, 2)), CAST(184.68 AS Decimal(18, 2)), N'858184945')
SET IDENTITY_INSERT [dbo].[Product] OFF
GO
SET IDENTITY_INSERT [dbo].[SessionUser] ON 

INSERT [dbo].[SessionUser] ([Id], [DateStart], [DateFinish], [IdUser]) VALUES (25, CAST(N'2021-02-26T13:31:56.000' AS DateTime), CAST(N'2021-02-26T13:32:01.000' AS DateTime), 13438)
SET IDENTITY_INSERT [dbo].[SessionUser] OFF
GO
SET IDENTITY_INSERT [dbo].[TypePay] ON 

INSERT [dbo].[TypePay] ([Id], [Name]) VALUES (1, N'Наличный')
INSERT [dbo].[TypePay] ([Id], [Name]) VALUES (2, N'Безналичный')
SET IDENTITY_INSERT [dbo].[TypePay] OFF
GO
SET IDENTITY_INSERT [dbo].[Users] ON 

INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (13438, N'Швардыгула', N'Герман', N'Якубович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (15225, N'Голумбовский', N'Феликс', N'Георгиевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (15368, N'Рыбьяков', N'Фока', N'Родионович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (16236, N'Муханова', N'Зоя', N'Никитевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (16579, N'Янчурова', N'Евгения', N'Марковна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (16958, N'Козарь', N'Римма', N'Олеговна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (17013, N'Шатохин', N'Мирон', N'Самуилович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (20517, N'Бухаров', N'Пахом', N'Никитевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (21374, N'Яснеев', N'Леонид', N'Карлович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (21596, N'Субботин', N'Денис', N'Евграфович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (22431, N'Логвинов', N'Лев', N'Маркович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (24700, N'Корбылев', N'Потап', N'Андронович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (25307, N'Насонова', N'Ариадна', N'Святославовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (25729, N'Чекмарёва', N'Людмила', N'Никитевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (25807, N'Касьянов', N'Глеб', N'Евграфович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (27373, N'Паршин', N'Осип', N'Никитевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (28187, N'Лобана', N'Владислава', N'Тимофеевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (29569, N'Старостина', N'Фаина', N'Потаповна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (29605, N'Угличинин', N'Владлен', N'Андроникович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (31322, N'Борева', N'Влада', N'Анатолиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (34658, N'Осинов', N'Виссарион', N'Аникитевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (35461, N'Радостина', N'Валерия', N'Феликсовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (35598, N'Гайдукова', N'Каролина', N'Степановна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (35692, N'Ядрышников', N'Алексей', N'Карлович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (35805, N'Рамазана', N'Христина', N'Михеевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (35978, N'Устимович', N'Эммануил', N'Никонович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (37014, N'Гибазова', N'Елизавета', N'Захаровна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (37313, N'Цуцкова', N'Розалия', N'Мефодиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (38004, N'Колобков', N'Афанасий', N'Платонович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (38203, N'Рыжанов', N'Семен', N'Игнатиевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (39050, N'Соловьева', N'Ефросиния', N'Яновна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (40618, N'Габулов', N'Константин', N'Леонидович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (43368, N'Крупина', N'Владлена', N'Станиславовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (43410, N'Лазуткина', N'Людмила', N'Николаевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (43692, N'Оболенская', N'Татьяна', N'Георгиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (46945, N'Дюженков', N'Вадим', N'Григориевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (47084, N'Бушмелев', N'Якуб', N'Вадимович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (48153, N'Лебедева', N'Дина', N'Афанасиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (48538, N'Афанасьева', N'Ева', N'Феликсовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (50530, N'Макушева', N'Нина', N'Елисеевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (50858, N'Корепанов', N'Степан', N'Геннадиевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (51041, N'Чаадаева', N'Валерия', N'Михеевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (51185, N'Путинцева', N'Лариса', N'Федоровна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (51579, N'Александрова', N'Евдокия', N'Андрияновна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (52776, N'Епанчин', N'Рубен', N'Макарович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (53045, N'Бушмелева', N'Елена', N'Николаевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (53147, N'Пончиков', N'Артур', N'Евграфович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (53818, N'Чеботова', N'Анна', N'Мефодиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (55513, N'Истомин', N'Кондратий', N'Андреевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (55950, N'Плеханов', N'Аркадий', N'Вадимович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (57727, N'Капшуков', N'Иосиф', N'Левович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (58009, N'Ануфриева', N'Евгения', N'Игнатиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (59031, N'Ягешева', N'Людмила', N'Мефодиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (59548, N'Курдин', N'Мефодий', N'Эдуардович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (59663, N'Борхеса', N'Таисия', N'Иосифовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (60847, N'Умаметев', N'Елизар', N'Феликсович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (61305, N'Курчин', N'Вениамин', N'Феоктистович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (61322, N'Дроздов', N'Никита', N'Денисович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (61453, N'Серых', N'Ипполит', N'Куприянович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (62152, N'Кариев', N'Феофан', N'Ираклиевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (63491, N'Куксюк', N'Модест', N'Маркович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (66978, N'Татауров', N'Фока', N'Олегович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (68417, N'Ипатьева', N'Елизавета', N'Тимуровна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (68516, N'Лешев', N'Сократ', N'Гордеевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (68743, N'Карамзин', N'Афанасий', N'Матвеевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (69214, N'Манякин', N'Феофан', N'Андреевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (69326, N'Горностаева', N'Арина', N'Ростиславовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (71132, N'Яндуткина', N'Лариса', N'Александровна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (71304, N'Добронравова', N'Владлена', N'Павеловна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (71521, N'Ягодич', N'Наум', N'Игнатиевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (71699, N'Быстрова', N'Роза', N'Павеловна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (71765, N'Гуляев', N'Лукьян', N'Артемиевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (74678, N'Усенко', N'Виталий', N'Ульянович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (74843, N'Летавин', N'Мстислав', N'Фомевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (74986, N'Юшаков', N'Емельян', N'Фомевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (75705, N'Уманова', N'Стела', N'Василиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (76159, N'Щепетинников', N'Афанасий', N'Даниилович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (76816, N'Абоймова', N'Дарья', N'Игнатиевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (77992, N'Анреп', N'Модест', N'Михаилович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (78682, N'Кабанова', N'Римма', N'Семеновна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (80283, N'Дёшин', N'Аскольд', N'Ерофеевич', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (82212, N'Юферев', N'Нестор', N'Трофимович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (82242, N'Ёлкина', N'Берта', N'Алексеевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (85939, N'Янкиловича', N'Александра', N'Ипполитовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (88083, N'Винокуров', N'Филипп', N'Серафимович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (89157, N'Малиновский', N'Павел', N'Ипатович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (89327, N'Абумайлов', N'Вячеслав', N'Феликсович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (89772, N'Пищальникова', N'Оксана', N'Михеевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (89795, N'Куанышбаева', N'Виктория', N'Никитевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (90626, N'Кризько', N'Фаина', N'Тихоновна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (93706, N'Захарьина', N'Агния', N'Ильевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (94112, N'Рыбакова', N'Дарья', N'Филипповна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (94715, N'Кашарина', N'Эмилия', N'Данииловна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (96332, N'Бершова', N'Алиса', N'Ильевна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (96492, N'Дарбинян', N'Владимир', N'Михаилович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (97412, N'Шурупин', N'Юлиан', N'Тарасович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (97724, N'Шикалов', N'Яков', N'Иванович', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (97895, N'Ахметова', N'Яна', N'Родионовна', 1)
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (98170, N'Нагибина', N'Мария', N'Игоревна', 1)
GO
INSERT [dbo].[Users] ([Id], [LastName], [FirstName], [MiddleName], [IdPrivileges]) VALUES (99789, N'Кошечкина', N'Мирослава', N'Ивановна', 1)
SET IDENTITY_INSERT [dbo].[Users] OFF
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Name__59FA5E80]  DEFAULT ('-') FOR [Name]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Weight__5AEE82B9]  DEFAULT ((0)) FOR [Weight]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Fasovka__5BE2A6F2]  DEFAULT ((0)) FOR [Fasovka]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Price__5CD6CB2B]  DEFAULT ((0.0)) FOR [Price]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__Amount__5DCAEF64]  DEFAULT ((0.0)) FOR [Amount]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF__Product__ShtrihC__5EBF139D]  DEFAULT ((0)) FOR [ShtrihCode]
GO
ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [DF__Users__LastName__4AB81AF0]  DEFAULT ('-') FOR [LastName]
GO
ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [DF__Users__FirstName__4BAC3F29]  DEFAULT ('-') FOR [FirstName]
GO
ALTER TABLE [dbo].[Users] ADD  CONSTRAINT [DF__Users__MiddleNam__4CA06362]  DEFAULT ('-') FOR [MiddleName]
GO
ALTER TABLE [dbo].[Orders]  WITH CHECK ADD  CONSTRAINT [FK_Orders_TypePay] FOREIGN KEY([IdTypePay])
REFERENCES [dbo].[TypePay] ([Id])
GO
ALTER TABLE [dbo].[Orders] CHECK CONSTRAINT [FK_Orders_TypePay]
GO
ALTER TABLE [dbo].[Orders]  WITH CHECK ADD  CONSTRAINT [FK_Orders_Users] FOREIGN KEY([IdUser])
REFERENCES [dbo].[Users] ([Id])
GO
ALTER TABLE [dbo].[Orders] CHECK CONSTRAINT [FK_Orders_Users]
GO
ALTER TABLE [dbo].[OrdersProduct]  WITH CHECK ADD FOREIGN KEY([IdProduct])
REFERENCES [dbo].[Product] ([Id])
GO
ALTER TABLE [dbo].[OrdersProduct]  WITH CHECK ADD  CONSTRAINT [FK_OrdersProduct_Orders] FOREIGN KEY([IdOrder])
REFERENCES [dbo].[Orders] ([Id])
GO
ALTER TABLE [dbo].[OrdersProduct] CHECK CONSTRAINT [FK_OrdersProduct_Orders]
GO
ALTER TABLE [dbo].[OrdersProduct]  WITH CHECK ADD  CONSTRAINT [FK_OrdersProduct_Product] FOREIGN KEY([IdProduct])
REFERENCES [dbo].[Product] ([Id])
GO
ALTER TABLE [dbo].[OrdersProduct] CHECK CONSTRAINT [FK_OrdersProduct_Product]
GO
ALTER TABLE [dbo].[SessionUser]  WITH CHECK ADD  CONSTRAINT [FK_SessionUser_Users] FOREIGN KEY([IdUser])
REFERENCES [dbo].[Users] ([Id])
GO
ALTER TABLE [dbo].[SessionUser] CHECK CONSTRAINT [FK_SessionUser_Users]
GO
ALTER TABLE [dbo].[Users]  WITH CHECK ADD  CONSTRAINT [FK_Users_Privileges] FOREIGN KEY([IdPrivileges])
REFERENCES [dbo].[Privileges] ([Id])
GO
ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Privileges]
GO
USE [master]
GO
ALTER DATABASE [sneiasckin] SET  READ_WRITE 
GO