SchemaScript/ScriptCreateDBAndData.sql

USE [master]
GO
/****** Object:  Database [DemoExamBD1]    Script Date: 23.10.2020 9:44:57 ******/
CREATE DATABASE [DemoExamBD1]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'DemoExamBD1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\DemoExamBD1.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'DemoExamBD1_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\DemoExamBD1_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [DemoExamBD1] SET COMPATIBILITY_LEVEL = 140
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [DemoExamBD1].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [DemoExamBD1] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [DemoExamBD1] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [DemoExamBD1] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [DemoExamBD1] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [DemoExamBD1] SET ARITHABORT OFF 
GO
ALTER DATABASE [DemoExamBD1] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [DemoExamBD1] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [DemoExamBD1] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [DemoExamBD1] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [DemoExamBD1] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [DemoExamBD1] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [DemoExamBD1] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [DemoExamBD1] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [DemoExamBD1] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [DemoExamBD1] SET  DISABLE_BROKER 
GO
ALTER DATABASE [DemoExamBD1] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [DemoExamBD1] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [DemoExamBD1] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [DemoExamBD1] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [DemoExamBD1] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [DemoExamBD1] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [DemoExamBD1] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [DemoExamBD1] SET RECOVERY FULL 
GO
ALTER DATABASE [DemoExamBD1] SET  MULTI_USER 
GO
ALTER DATABASE [DemoExamBD1] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [DemoExamBD1] SET DB_CHAINING OFF 
GO
ALTER DATABASE [DemoExamBD1] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [DemoExamBD1] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [DemoExamBD1] SET DELAYED_DURABILITY = DISABLED 
GO
EXEC sys.sp_db_vardecimal_storage_format N'DemoExamBD1', N'ON'
GO
ALTER DATABASE [DemoExamBD1] SET QUERY_STORE = OFF
GO
USE [DemoExamBD1]
GO
/****** Object:  Table [dbo].[CategoryProduct]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CategoryProduct](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[CategoryProduct] [nvarchar](25) NOT NULL,
 CONSTRAINT [PK_CategoryProduct] 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].[CategorySpecial]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CategorySpecial](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Category] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_CategorySpecial] 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].[ClientRecordService]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClientRecordService](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Serviceid] [int] NOT NULL,
	[Clientid] [int] NOT NULL,
	[DateTimeStart] [datetime] NOT NULL,
	[Comment] [nvarchar](200) NULL,
 CONSTRAINT [PK_ClientRecordService] 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].[Clients]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Clients](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Peoplid] [int] NOT NULL,
	[FirstVisit] [datetime] NOT NULL,
	[Image] [image] NULL,
	[PhoneNumber] [nvarchar](15) NOT NULL,
	[Email] [nvarchar](60) NOT NULL,
	[ClientStatusid] [int] NOT NULL,
 CONSTRAINT [PK_Clients] 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].[ClientStatus]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClientStatus](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ClientStatus] [nvarchar](25) NOT NULL,
 CONSTRAINT [PK_ClientStatus] 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].[Employe]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employe](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[PaperSeriesNumber] [nvarchar](50) NOT NULL,
	[SubUnitCode] [nvarchar](50) NOT NULL,
	[PayRatio] [float] NOT NULL,
	[Peoplid] [int] NOT NULL,
	[CategorySpecialid] [int] NOT NULL,
 CONSTRAINT [PK_Employe] 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].[Gender]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Gender](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Gender] [nvarchar](25) NOT NULL,
	[GenderShort] [nvarchar](25) NOT NULL,
 CONSTRAINT [PK_Gender] 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].[Manufacturer]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Manufacturer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](70) NOT NULL,
	[DateWorkStart] [date] NULL,
 CONSTRAINT [PK_Manufacturer] 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].[PayHistory]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PayHistory](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Clientid] [int] NOT NULL,
	[Productid] [int] NOT NULL,
	[Amount] [int] NOT NULL,
	[DateTimeSale] [datetime] NULL,
 CONSTRAINT [PK_PayHistory] 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].[People]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[People](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](20) NOT NULL,
	[LastName] [nvarchar](20) NOT NULL,
	[MiddleName] [nvarchar](20) NOT NULL,
	[Birthday] [date] NOT NULL,
	[Genderid] [int] NOT NULL,
 CONSTRAINT [PK_People] 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: 23.10.2020 9:44:57 ******/
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,
	[CategoryProductid] [int] NOT NULL,
	[Price] [money] NOT NULL,
	[Description] [nvarchar](200) NULL,
	[Weight] [float] NOT NULL,
	[Sizeid] [int] NOT NULL,
	[Manufacturerid] [int] NOT NULL,
	[MainPhotoProduct] [image] NULL,
	[AdditionalPhotoProduct] [image] NULL,
	[Status] [bit] 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
/****** Object:  Table [dbo].[Service]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Service](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameService] [nvarchar](30) NOT NULL,
	[Description] [nvarchar](200) NULL,
	[Price] [money] NOT NULL,
	[Descount] [float] NULL,
	[Diration] [time](7) NOT NULL,
	[MainPhotoService] [image] NULL,
	[AdditionalPhotoService] [image] NULL,
 CONSTRAINT [PK_Service] 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].[Size]    Script Date: 23.10.2020 9:44:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Size](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[SizeX] [float] NOT NULL,
	[SizeY] [float] NOT NULL,
	[SizeZ] [float] NOT NULL,
 CONSTRAINT [PK_Size] 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].[CategoryProduct] ON 

INSERT [dbo].[CategoryProduct] ([id], [CategoryProduct]) VALUES (1, N'Тоник')
INSERT [dbo].[CategoryProduct] ([id], [CategoryProduct]) VALUES (2, N'Крем')
INSERT [dbo].[CategoryProduct] ([id], [CategoryProduct]) VALUES (3, N'Масло')
INSERT [dbo].[CategoryProduct] ([id], [CategoryProduct]) VALUES (5, N'Средства для лица')
INSERT [dbo].[CategoryProduct] ([id], [CategoryProduct]) VALUES (6, N'Маска')
INSERT [dbo].[CategoryProduct] ([id], [CategoryProduct]) VALUES (7, N'Пена')
SET IDENTITY_INSERT [dbo].[CategoryProduct] OFF
SET IDENTITY_INSERT [dbo].[CategorySpecial] ON 

INSERT [dbo].[CategorySpecial] ([id], [Category]) VALUES (1, N'Касир ')
INSERT [dbo].[CategorySpecial] ([id], [Category]) VALUES (2, N'Продавец-консультант')
INSERT [dbo].[CategorySpecial] ([id], [Category]) VALUES (3, N'Консультант ')
INSERT [dbo].[CategorySpecial] ([id], [Category]) VALUES (4, N'Менеджер зала')
INSERT [dbo].[CategorySpecial] ([id], [Category]) VALUES (5, N'Менеджер')
SET IDENTITY_INSERT [dbo].[CategorySpecial] OFF
SET IDENTITY_INSERT [dbo].[ClientRecordService] ON 

INSERT [dbo].[ClientRecordService] ([id], [Serviceid], [Clientid], [DateTimeStart], [Comment]) VALUES (1, 2, 1, CAST(N'2020-02-15T16:00:00.000' AS DateTime), NULL)
INSERT [dbo].[ClientRecordService] ([id], [Serviceid], [Clientid], [DateTimeStart], [Comment]) VALUES (2, 1, 2, CAST(N'2020-02-15T12:00:00.000' AS DateTime), NULL)
INSERT [dbo].[ClientRecordService] ([id], [Serviceid], [Clientid], [DateTimeStart], [Comment]) VALUES (3, 1, 2, CAST(N'2020-03-15T11:30:00.000' AS DateTime), NULL)
INSERT [dbo].[ClientRecordService] ([id], [Serviceid], [Clientid], [DateTimeStart], [Comment]) VALUES (6, 3, 4, CAST(N'2020-04-11T12:20:00.000' AS DateTime), NULL)
INSERT [dbo].[ClientRecordService] ([id], [Serviceid], [Clientid], [DateTimeStart], [Comment]) VALUES (7, 6, 5, CAST(N'2020-03-11T14:20:00.000' AS DateTime), NULL)
SET IDENTITY_INSERT [dbo].[ClientRecordService] OFF
SET IDENTITY_INSERT [dbo].[Clients] ON 

INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (1, 9, CAST(N'2020-01-01T00:00:00.000' AS DateTime), NULL, N'89832334242', N'New@Mail.ru', 1)
INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (2, 10, CAST(N'2018-03-12T00:00:00.000' AS DateTime), NULL, N'89832156123', N'MyMail@Mail.ru', 4)
INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (3, 11, CAST(N'2018-08-15T00:00:00.000' AS DateTime), NULL, N'89832156123', N'BND@Mail.ru', 4)
INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (4, 12, CAST(N'2015-12-12T00:00:00.000' AS DateTime), NULL, N'85172312312', N'CoNt@mail.ru', 2)
INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (5, 13, CAST(N'2020-03-01T00:00:00.000' AS DateTime), NULL, N'81243123351', N'NewSPpr@mail.ru', 1)
INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (6, 14, CAST(N'2015-12-01T00:00:00.000' AS DateTime), NULL, N'81235167123', N'SmA@gmai.com', 3)
INSERT [dbo].[Clients] ([id], [Peoplid], [FirstVisit], [Image], [PhoneNumber], [Email], [ClientStatusid]) VALUES (7, 15, CAST(N'2019-01-20T00:00:00.000' AS DateTime), NULL, N'81231561235', N'Tk2Km@Mail.ru', 4)
SET IDENTITY_INSERT [dbo].[Clients] OFF
SET IDENTITY_INSERT [dbo].[ClientStatus] ON 

INSERT [dbo].[ClientStatus] ([id], [ClientStatus]) VALUES (1, N'Новый')
INSERT [dbo].[ClientStatus] ([id], [ClientStatus]) VALUES (2, N'Активный клиент')
INSERT [dbo].[ClientStatus] ([id], [ClientStatus]) VALUES (3, N'Неактивный клиент')
INSERT [dbo].[ClientStatus] ([id], [ClientStatus]) VALUES (4, N'Клиент')
SET IDENTITY_INSERT [dbo].[ClientStatus] OFF
SET IDENTITY_INSERT [dbo].[Employe] ON 

INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (1, N'6909232456', N'PM-1', 0.95, 1, 1)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (3, N'4821125642', N'PM-1', 0.95, 2, 1)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (4, N'4712126432', N'PM-1', 1, 3, 2)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (5, N'6512578421', N'PM-1', 1, 4, 2)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (6, N'5123566742', N'PM-1', 1, 5, 3)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (7, N'5612412312', N'PM-1', 1.05, 6, 3)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (8, N'1231234561', N'PM-1', 1.25, 7, 4)
INSERT [dbo].[Employe] ([id], [PaperSeriesNumber], [SubUnitCode], [PayRatio], [Peoplid], [CategorySpecialid]) VALUES (9, N'1235612356', N'PM-1', 1.5, 8, 5)
SET IDENTITY_INSERT [dbo].[Employe] OFF
SET IDENTITY_INSERT [dbo].[Gender] ON 

INSERT [dbo].[Gender] ([id], [Gender], [GenderShort]) VALUES (1, N'Мужской', N'М')
INSERT [dbo].[Gender] ([id], [Gender], [GenderShort]) VALUES (2, N'Женский', N'Ж')
SET IDENTITY_INSERT [dbo].[Gender] OFF
SET IDENTITY_INSERT [dbo].[Manufacturer] ON 

INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (1, N'Weleda', CAST(N'2015-04-14' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (2, N'DIONY', CAST(N'2017-12-03' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (3, N'MATSESTA', CAST(N'2018-04-21' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (4, N'AMSARVEDA', CAST(N'2015-12-11' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (5, N'Natura Botanica', CAST(N'2016-05-02' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (6, N'ANDALOU', CAST(N'2015-11-11' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (7, N'Blue Beautifly', CAST(N'2017-01-15' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (8, N'BIOSelect', CAST(N'2016-12-29' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (9, N'Natura Siberica', CAST(N'2018-01-20' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (10, N'Биопин ФАРМА', CAST(N'2016-08-13' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (11, N'Milotto', CAST(N'2016-06-19' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (12, N'Лаборатория натуральной косметики MIXIT', CAST(N'2018-06-12' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (13, N'Малавит', CAST(N'2017-09-18' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (14, N'Agent Netty PRO', CAST(N'2016-03-17' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (15, N'ЕвроТек', CAST(N'2017-10-21' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (16, N'АЙРОН БАРБЕР', CAST(N'2018-04-16' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (17, N'РУСХИМТЕХ', CAST(N'2017-07-03' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (18, N'НИКОЛЬ', CAST(N'2017-02-27' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (19, N'Аравия', CAST(N'2015-06-23' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (20, N'Алтэя', CAST(N'2018-05-14' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (21, N'SHELK Cosmetics', CAST(N'2017-01-19' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (22, N'Русская косметика', CAST(N'2015-07-19' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (23, N'MAGIC HERBS', CAST(N'2016-02-23' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (24, N'Bel Savon', CAST(N'2015-04-20' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (25, N'ИРИДА-НЕВА', CAST(N'2017-05-27' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (26, N'Славяна', CAST(N'2015-03-09' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (27, N'АЛВА', CAST(N'2016-08-18' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (28, N'Альпика', CAST(N'2018-05-31' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (29, N'Жерминаль', CAST(N'2017-04-04' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (30, N'Арт-Визаж', CAST(N'2018-04-15' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (31, N'Валери-Д', CAST(N'2018-06-28' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (32, N'Мастерская Fitoland Organic', CAST(N'2017-07-10' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (33, N'ДОМ ПРИРОДЫ', CAST(N'2015-11-25' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (34, N'Флора', CAST(N'2016-01-18' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (35, N'ЭКО ТАВРИДА', CAST(N'2016-06-27' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (36, N'АлтайЯ', CAST(N'2015-07-04' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (37, N'ANTI AGE', CAST(N'2015-11-01' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (38, N'Колорит', CAST(N'2017-12-22' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (39, N'SATIVA', CAST(N'2017-01-13' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (40, N'Фитокосметик', CAST(N'2016-03-01' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (41, N'Клеона', CAST(N'2017-10-29' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (42, N'Живая косметика Сибири', CAST(N'2015-03-05' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (43, N'SLAVIC HAIR Company', CAST(N'2015-12-20' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (44, N'Green era', CAST(N'2017-07-28' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (45, N'SIBERINA', CAST(N'2015-10-01' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (46, N'Green Mama', CAST(N'2016-11-11' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (47, N'Altanya', CAST(N'2015-03-23' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (48, N'Черный бриллиант', CAST(N'2016-01-07' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (49, N'АромаВятка', CAST(N'2016-10-01' AS Date))
INSERT [dbo].[Manufacturer] ([id], [Name], [DateWorkStart]) VALUES (50, N'VIQQO — производитель инновационной уходовой косметики', CAST(N'2017-10-12' AS Date))
SET IDENTITY_INSERT [dbo].[Manufacturer] OFF
SET IDENTITY_INSERT [dbo].[PayHistory] ON 

INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (1, 2, 45, 2, CAST(N'2019-09-29T08:59:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (2, 3, 22, 1, CAST(N'2019-12-15T19:02:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (3, 4, 98, 2, CAST(N'2019-02-17T11:39:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (4, 5, 37, 3, CAST(N'2019-04-01T08:42:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (5, 6, 89, 2, CAST(N'2019-01-01T15:08:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (6, 7, 43, 3, CAST(N'2019-05-25T08:08:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (7, 2, 5, 3, CAST(N'2019-07-29T13:37:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (8, 3, 44, 2, CAST(N'2019-03-27T12:18:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (9, 2, 77, 3, CAST(N'2019-10-23T18:53:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (10, 2, 88, 3, CAST(N'2019-03-03T08:32:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (11, 2, 87, 2, CAST(N'2019-02-18T14:44:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (12, 2, 97, 1, CAST(N'2019-10-03T19:54:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (13, 2, 23, 1, CAST(N'2019-11-12T18:41:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (14, 2, 81, 1, CAST(N'2019-02-12T17:09:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (15, 3, 94, 3, CAST(N'2019-11-01T15:39:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (16, 2, 91, 2, CAST(N'2019-06-10T11:07:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (17, 5, 8, 3, CAST(N'2019-06-22T12:07:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (18, 3, 15, 2, CAST(N'2019-07-16T11:31:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (19, 3, 87, 1, CAST(N'2019-01-07T11:22:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (20, 3, 59, 2, CAST(N'2019-07-14T10:29:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (21, 3, 68, 2, CAST(N'2019-11-17T17:57:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (22, 4, 33, 3, CAST(N'2019-08-25T18:00:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (23, 3, 87, 3, CAST(N'2019-06-07T10:05:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (24, 3, 77, 3, CAST(N'2019-02-08T16:40:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (25, 7, 13, 2, CAST(N'2019-01-12T15:11:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (26, 4, 99, 1, CAST(N'2019-05-16T10:42:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (27, 4, 59, 1, CAST(N'2019-05-25T15:29:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (28, 4, 103, 3, CAST(N'2019-12-26T19:39:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (29, 4, 47, 1, CAST(N'2019-07-29T13:38:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (30, 2, 29, 2, CAST(N'2019-12-31T16:42:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (31, 4, 26, 3, CAST(N'2019-03-08T10:24:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (32, 4, 46, 2, CAST(N'2019-08-12T09:17:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (33, 4, 24, 3, CAST(N'2019-11-18T08:33:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (34, 4, 83, 2, CAST(N'2019-08-06T13:21:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (35, 4, 67, 2, CAST(N'2019-02-25T16:25:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (36, 4, 36, 1, CAST(N'2019-05-28T09:56:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (37, 4, 42, 1, CAST(N'2019-11-24T13:21:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (38, 5, 87, 2, CAST(N'2019-10-03T11:04:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (39, 5, 71, 2, CAST(N'2019-10-11T13:27:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (40, 5, 34, 1, CAST(N'2019-11-23T16:12:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (41, 5, 59, 1, CAST(N'2019-07-25T18:52:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (42, 5, 13, 2, CAST(N'2019-08-21T10:39:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (43, 5, 98, 2, CAST(N'2019-04-09T12:02:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (44, 5, 100, 3, CAST(N'2019-10-10T11:39:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (45, 4, 87, 2, CAST(N'2019-07-03T16:52:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (46, 6, 79, 2, CAST(N'2019-03-25T09:35:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (47, 6, 51, 3, CAST(N'2019-09-22T16:57:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (48, 6, 70, 1, CAST(N'2019-03-03T18:35:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (49, 4, 77, 3, CAST(N'2019-08-21T17:01:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (50, 6, 95, 3, CAST(N'2019-03-11T17:02:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (51, 6, 84, 1, CAST(N'2019-04-28T08:46:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (52, 6, 42, 2, CAST(N'2019-12-27T16:58:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (53, 4, 17, 3, CAST(N'2019-12-09T11:56:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (54, 7, 90, 1, CAST(N'2019-10-02T17:30:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (55, 4, 84, 3, CAST(N'2019-11-18T17:32:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (56, 7, 31, 2, CAST(N'2019-01-28T17:01:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (57, 7, 24, 3, CAST(N'2019-10-22T12:34:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (58, 7, 33, 2, CAST(N'2019-09-06T12:57:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (59, 7, 85, 2, CAST(N'2019-12-04T13:10:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (60, 7, 20, 2, CAST(N'2019-04-10T13:43:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (61, 7, 50, 1, CAST(N'2019-02-13T16:49:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (62, 7, 93, 1, CAST(N'2019-08-12T09:33:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (63, 4, 50, 1, CAST(N'2019-02-05T10:48:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (64, 1, 79, 1, CAST(N'2019-11-02T16:32:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (65, 4, 27, 3, CAST(N'2019-11-03T13:25:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (66, 1, 16, 1, CAST(N'2019-02-25T18:04:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (67, 1, 7, 1, CAST(N'2019-05-15T15:17:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (68, 1, 35, 3, CAST(N'2019-02-03T08:37:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (69, 1, 18, 3, CAST(N'2019-08-06T14:38:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (70, 1, 93, 1, CAST(N'2019-01-09T10:46:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (71, 1, 83, 2, CAST(N'2019-04-08T08:45:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (72, 4, 14, 2, CAST(N'2019-06-10T15:57:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (73, 4, 87, 2, CAST(N'2019-11-06T10:21:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (74, 2, 51, 3, CAST(N'2019-05-16T16:19:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (75, 2, 86, 2, CAST(N'2019-11-27T17:14:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (76, 2, 39, 3, CAST(N'2019-12-23T09:03:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (77, 2, 59, 1, CAST(N'2019-06-23T14:33:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (78, 2, 11, 2, CAST(N'2019-06-19T15:28:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (79, 2, 92, 2, CAST(N'2019-11-29T15:53:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (80, 2, 73, 1, CAST(N'2019-12-26T08:06:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (81, 4, 21, 3, CAST(N'2019-07-08T15:21:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (82, 4, 54, 2, CAST(N'2019-06-10T19:54:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (83, 3, 92, 1, CAST(N'2019-03-01T12:00:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (84, 3, 30, 3, CAST(N'2019-01-11T12:11:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (85, 3, 14, 3, CAST(N'2019-12-08T16:58:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (86, 3, 20, 3, CAST(N'2019-08-18T17:09:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (87, 3, 18, 1, CAST(N'2019-07-10T17:54:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (88, 3, 51, 2, CAST(N'2019-09-08T11:52:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (89, 3, 101, 2, CAST(N'2019-07-16T09:44:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (90, 3, 27, 3, CAST(N'2019-07-18T14:32:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (91, 4, 56, 3, CAST(N'2019-03-31T14:53:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (92, 5, 62, 1, CAST(N'2019-07-25T16:30:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (93, 5, 64, 1, CAST(N'2019-07-11T16:30:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (94, 5, 39, 2, CAST(N'2019-07-16T13:09:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (95, 5, 7, 1, CAST(N'2019-11-23T12:58:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (96, 5, 44, 2, CAST(N'2019-08-08T18:37:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (97, 5, 26, 3, CAST(N'2019-03-20T18:47:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (98, 5, 101, 3, CAST(N'2019-01-29T19:09:00.000' AS DateTime))
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (99, 6, 64, 2, CAST(N'2019-10-18T18:40:00.000' AS DateTime))
GO
INSERT [dbo].[PayHistory] ([id], [Clientid], [Productid], [Amount], [DateTimeSale]) VALUES (100, 6, 62, 3, CAST(N'2019-07-05T16:03:00.000' AS DateTime))
SET IDENTITY_INSERT [dbo].[PayHistory] OFF
SET IDENTITY_INSERT [dbo].[People] ON 

INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (1, N'Бассетт', N'Николаев', N'Святославович', CAST(N'1985-05-19' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (2, N'Тирони', N'Аверин', N'Филиппович', CAST(N'2002-12-26' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (3, N'Регги', N'Шашкова', N'Станиславовна', CAST(N'1999-09-25' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (4, N'Ревмирия', N'Ушакова', N'Николаевна', CAST(N'1998-03-05' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (5, N'Жигит', N'Нектов', N'Евгеньевич', CAST(N'1979-07-18' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (6, N'Адафья', N'Громова', N'Евгеньевна', CAST(N'1976-06-11' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (7, N'Алгедрина ', N'Ленина', N'Максимовна', CAST(N'1990-02-26' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (8, N'Анера', N'Алиева', N'Дмитриевна', CAST(N'2002-09-20' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (9, N'Ефдосиния', N'Максимова', N'Антоновна', CAST(N'1993-11-03' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (10, N'Тульмира', N'Воробьёва', N'Ивановна', CAST(N'1996-05-11' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (11, N'Тюляк', N'Громов', N'Тимурович', CAST(N'1999-09-02' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (12, N'Марций ', N'Ржевский', N'Альбертович', CAST(N'1992-10-04' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (13, N'Дзермен', N'Шершов', N'Павлович', CAST(N'2002-07-18' AS Date), 1)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (14, N'Анисат', N'Новикова', N'Ефимовна', CAST(N'1977-01-23' AS Date), 2)
INSERT [dbo].[People] ([id], [FirstName], [LastName], [MiddleName], [Birthday], [Genderid]) VALUES (15, N'Изофатов ', N'Хаййан ', N'Вячеславович', CAST(N'1972-12-05' AS Date), 1)
SET IDENTITY_INSERT [dbo].[People] OFF
SET IDENTITY_INSERT [dbo].[Product] ON 

INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (2, N'Ирисовый освежающий увлажняющий крем', 2, 720.0000, N'no descript', 0.2, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (3, N'Сыворотка для кожи вокруг глаз с гиалуроновой кислотой', 5, 690.0000, N'no descript', 0.4, 1, 2, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (4, N'Тоник для лица дневной, Витаминный', 1, 800.0000, N'no descript', 0.3, 2, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (5, N'Массажный крем для лица с увлажняющим и тонизирующим эффектом', 2, 740.0000, N'no descript', 0.5, 4, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (6, N'Маска-пленка отшелушивающая с лифтинг-эффектом', 6, 860.0000, N'no descript', 0.4, 3, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (7, N'Специальный крем для клеточного восстановления', 2, 920.0000, N'no descript', 0.5, 6, 4, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (8, N'Увлажняющий крем', 2, 730.0000, N'no descript', 0.1, 7, 1, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (9, N'Восстанавливающая маска для лица', 6, 630.0000, N'no descript', 0.1, 8, 6, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (10, N'Крем SILK для чувствительной кожи лица натуральный', 2, 740.0000, N'no descript', 0.1, 9, 3, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (11, N'Подарочный набор Сияние', 5, 630.0000, N'no descript', 0.3, 11, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (12, N'Пена для бритья Натуральная, Лимон и Корица', 7, 470.0000, N'no descript', 0.5, 10, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (13, N'Крем питательный тонизирующий ночной', 2, 950.0000, N'no descript', 0.4, 20, 8, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (14, N'Подарочный набор Супер Увлажнение', 5, 830.0000, N'no descript', 0.5, 21, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (15, N'Подарочный набор Глубокое Очищение', 5, 860.0000, N'no descript', 0.3, 12, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (16, N'Тоник ACTIVE для возрастной кожи лица натуральный', 1, 720.0000, N'no descript', 0.5, 13, 3, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (17, N'Эфирное масло мелиссы', 3, 380.0000, N'no descript', 0.4, 14, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (18, N'Увлажняющая эмульсия для лица', 5, 910.0000, N'no descript', 0.5, 15, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (19, N'Масло персиковое', 3, 280.0000, N'no descript', 0.2, 17, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (20, N'Очищающая коллекция Ночной восстанавливающий крем для лица', 2, 570.0000, N'no descript', 0.2, 1, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (21, N'Подарочный набор For HIM, Сильный мужчина', 5, 900.0000, N'no descript', 0.1, 19, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (22, N'Антивозрастная коллекция Освежающий тоник Цветочный', 1, 940.0000, N'no descript', 0.1, 17, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (23, N'Розовый разглаживающий увлажняющий крем', 2, 890.0000, N'no descript', 0.1, 21, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (24, N'Деликатный питательный крем', 2, 890.0000, N'no descript', 0.3, 15, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (25, N'Масло сладкого миндаля', 3, 250.0000, N'no descript', 0.5, 2, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (26, N'Эфирное масло жасмин', 3, 610.0000, N'no descript', 0.4, 5, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (27, N'Натуральная пенка для умывания, с ароматом розового дерева', 7, 750.0000, N'no descript', 0.5, 7, 5, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (28, N'Тоник для лица, для сухой и нормальной кожи', 1, 490.0000, N'no descript', 0.2, 8, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (29, N'Эфирное масло лемонграсс', 3, 380.0000, N'no descript', 0.2, 3, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (30, N'Ирисовый освежающий ночной крем', 2, 840.0000, N'no descript', 0.1, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (31, N'Деликатное очищающее молочко', 5, 680.0000, N'no descript', 0.1, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (32, N'Эфирное масло корицы', 3, 370.0000, N'no descript', 0.1, 2, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (33, N'Очищающий гель для умывания', 5, 720.0000, N'no descript', 0.3, 1, 1, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (34, N'Солнцезащитный лосьон для лица и тела', 5, 830.0000, N'no descript', 0.5, 6, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (35, N'Коллекция Кокосовая, Очищающая пенка для лица с экстрактами кактуса', 5, 540.0000, N'no descript', 0.4, 1, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (36, N'S.O.S. средство против локальных несовершенств кожи', 5, 870.0000, N'no descript', 0.5, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (37, N'Коллекция Сияние, Очищающая крем-пенка Лимон Мейера', 2, 750.0000, N'no descript', 0.3, 20, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (38, N'Подарочный набор Сияние и Красота', 5, 570.0000, N'no descript', 0.5, 1, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (39, N'Маска-пленка для глубокого очищения пор', 6, 920.0000, N'no descript', 0.4, 12, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (40, N'Ирисовый освежающий дневной крем', 2, 740.0000, N'no descript', 0.5, 12, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (41, N'Деликатный увлажняющий крем', 2, 940.0000, N'no descript', 0.3, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (42, N'Ухаживающее масло, против сухости кожи', 3, 410.0000, N'no descript', 0.5, 1, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (43, N'Розовое растительное мыло', 5, 470.0000, N'no descript', 0.4, 16, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (44, N'Гранатовый дневной крем-лифтинг', 2, 800.0000, N'no descript', 0.5, 16, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (45, N'Тонизирующее очищающее средство 2 в 1', 5, 640.0000, N'no descript', 0.2, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (46, N'Сыворотка для лица с гиалуроновой кислотой, для сухой и чувствительной кожи', 5, 590.0000, N'no descript', 0.2, 1, 2, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (47, N'Эфирное масло лимона', 3, 330.0000, N'no descript', 0.1, 18, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (48, N'Эфирное масло розовое дерево', 3, 510.0000, N'no descript', 0.1, 1, 5, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (49, N'Мягкая пенка для умывания', 7, 680.0000, N'no descript', 0.3, 14, 1, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (50, N'Сыворотка для лица с гиалуроновой кислотой, для нормальной кожи', 5, 560.0000, N'no descript', 0.5, 4, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (51, N'Тоник для лица, для жирной и проблемной кожи', 1, 600.0000, N'no descript', 0.4, 5, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (52, N'Пенка для умывания, для сухой и чувствительной кожи', 7, 440.0000, N'no descript', 0.5, 1, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (53, N'Антивозрастной крем для лица с органическими ягодами годжи', 2, 990.0000, N'no descript', 0.3, 1, 7, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (54, N'Эфирное масло эвкалипт', 3, 410.0000, N'no descript', 0.5, 2, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (55, N'Сыворотка PERFECT SERUM депигментирующая натуральная', 5, 710.0000, N'no descript', 0.4, 1, 3, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (56, N'Крем для лица с антиоксидантами органической клюквы', 2, 980.0000, N'no descript', 0.5, 3, 7, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (57, N'Пенка для лица для чувствительной кожи', 5, 630.0000, N'no descript', 0.3, 4, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (58, N'Коллекция Кокосовая, Укрепляющая сыворотка с экстрактами кактуса', 5, 680.0000, N'no descript', 0.5, 3, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (59, N'Крем-маска WOW EFFECT омолаживающая для лица натуральная', 2, 950.0000, N'no descript', 0.4, 1, 3, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (60, N'Подарочный набор For MEN', 5, 840.0000, N'no descript', 0.5, 3, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (61, N'Очищающий гель для нормальной и сухой кожи лица', 5, 720.0000, N'no descript', 0.2, 7, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (62, N'Лифтинг-сыворотка для лица', 5, 930.0000, N'no descript', 0.2, 3, 4, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (63, N'Тоник для ухода за сухой и нормальной кожей', 1, 990.0000, N'no descript', 0.1, 8, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (64, N'Питательный крем для лица', 2, 800.0000, N'no descript', 0.1, 7, 4, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (65, N'Крем против морщин для глаз', 2, 570.0000, N'no descript', 0.3, 4, 8, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (66, N'Лифтинг-сыворотка для лица с гиалуроновой кислотой', 5, 610.0000, N'no descript', 0.5, 2, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (67, N'Деликатное питательное масло для лица', 3, 930.0000, N'no descript', 0.4, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (68, N'Тонизирующая сыворотка для лица', 5, 780.0000, N'no descript', 0.5, 1, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (69, N'Масло праймер для лица (основа под макияж), Выравнивание', 3, 530.0000, N'no descript', 0.3, 6, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (70, N'Сыворотка COUPEROSE укрепляющая сосуды натуральная', 5, 590.0000, N'no descript', 0.5, 6, 3, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (71, N'Органический тонер с экстрактом Розы', 5, 960.0000, N'no descript', 0.4, 7, 7, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (72, N'Пенка для умывания, для жирной и комбинированной кожи', 7, 780.0000, N'no descript', 0.5, 8, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (73, N'Маска для лица увлажняющая и тонизирующая', 6, 860.0000, N'no descript', 0.1, 3, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (74, N'Эфирное масло чайного дерева', 3, 410.0000, N'no descript', 0.1, 5, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (75, N'Очищающий гель для комбинированной и жирной кожи лица', 5, 980.0000, N'no descript', 0.1, 6, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (76, N'Масло после бритья Натуральное, Лимон и Корица', 3, 300.0000, N'no descript', 0.3, 8, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (77, N'Ухаживающее масло для лица, восстанавливает кожу', 3, 420.0000, N'no descript', 0.5, 9, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (78, N'Подарочный набор Мягкое Очищение', 5, 850.0000, N'no descript', 0.4, 5, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (79, N'Гранатовый ночной крем-лифтинг', 2, 560.0000, N'no descript', 0.5, 2, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (80, N'Живительный тоник для лица', 1, 770.0000, N'no descript', 0.2, 4, 1, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (81, N'Универсальный питательный крем SKIN FOOD', 2, 640.0000, N'no descript', 0.2, 5, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (82, N'Органическое 100% аргановое масло', 3, 760.0000, N'no descript', 0.1, 8, 7, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (83, N'Пенка для умывания, для нормальной кожи', 7, 400.0000, N'no descript', 0.1, 15, 2, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (84, N'Крем PERFECT выравнивающий тон лица натуральный', 2, 780.0000, N'no descript', 0.1, 16, 3, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (85, N'Чистящая пена-гель для лица', 7, 550.0000, N'no descript', 0.3, 12, 8, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (86, N'Пенка для умывания Натуральная, Лимон и корица', 7, 280.0000, N'no descript', 0.5, 12, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (87, N'Масло для лица массажное, с эффектом Лифтинга', 3, 500.0000, N'no descript', 0.4, 15, 5, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (88, N'Увлажняющий 24-часовой крем против морщин', 2, 910.0000, N'no descript', 0.5, 16, 8, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (89, N'Подарочный набор Travel, в Командировку, мужской', 5, 880.0000, N'no descript', 0.3, 17, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (90, N'Тоник для ухода за жирной и комбинированной кожей', 1, 800.0000, N'no descript', 0.5, 11, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (91, N'Тонизирующий крем для лица', 2, 800.0000, N'no descript', 0.4, 11, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (92, N'Восстанавливающий крем для лица с органическим шиповником', 2, 960.0000, N'no descript', 0.5, 21, 7, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (93, N'Эфирное масло перечной мяты', 3, 390.0000, N'no descript', 0.5, 12, 5, NULL, NULL, 0)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (94, N'Тоник для лица, Успокаивающий, для всех типов кожи', 1, 410.0000, N'no descript', 0.1, 21, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (95, N'Эфирное масло бергамота', 3, 380.0000, N'no descript', 0.1, 12, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (97, N'Эфирное масло лаванды', 3, 570.0000, N'no descript', 0.1, 21, 5, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (98, N'Гималайская грязевая маска антиоксидантная', 6, 660.0000, N'no descript', 0.3, 1, 4, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (99, N'Гранатовая интенсивная сыворотка-лифтинг', 5, 720.0000, N'no descript', 0.5, 1, 1, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (100, N'Коллекция Кокосовая, Увлажняющий ночной крем с экстрактами кактуса', 2, 700.0000, N'no descript', 0.4, 1, 6, NULL, NULL, 1)
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (101, N'Тоник-пилинг для лица EXFOLIANT на основе фруктовых кислот натуральный', 1, 660.0000, N'no descript', 0.5, 5, 3, NULL, NULL, 1)
GO
INSERT [dbo].[Product] ([id], [Name], [CategoryProductid], [Price], [Description], [Weight], [Sizeid], [Manufacturerid], [MainPhotoProduct], [AdditionalPhotoProduct], [Status]) VALUES (103, N'Гималайская грязевая маска восстанавливающая', 6, 640.0000, N'no descript', 0.1, 12, 4, NULL, NULL, 1)
SET IDENTITY_INSERT [dbo].[Product] OFF
SET IDENTITY_INSERT [dbo].[Service] ON 

INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (1, N'Экспресс маникюр', NULL, 550.0000, 0.1, CAST(N'00:15:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (2, N'Маникюр без покрытия', NULL, 850.0000, 0.2, CAST(N'00:30:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (3, N'Маникюр с покрытием', NULL, 1100.0000, NULL, CAST(N'00:40:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (4, N'Педикюр без покрытия', NULL, 1600.0000, 0.15, CAST(N'00:20:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (5, N'Педикюр с покрытием гель-лак', NULL, 2200.0000, 0.1, CAST(N'00:40:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (6, N'Снятие лака', NULL, 100.0000, 0, CAST(N'00:10:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (7, N'Снятие гель-лака', NULL, 400.0000, NULL, CAST(N'00:15:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (8, N'Реставрация нагтей за 1 ноготь', NULL, 250.0000, 0.2, CAST(N'00:05:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (9, N'Укрепление IBX', NULL, 480.0000, 0.1, CAST(N'00:25:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (10, N'Парафинотерапия', NULL, 500.0000, 0.25, CAST(N'00:15:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (11, N'Экспресс СПА уход', NULL, 540.0000, NULL, CAST(N'00:20:00' AS Time), NULL, NULL)
INSERT [dbo].[Service] ([id], [NameService], [Description], [Price], [Descount], [Diration], [MainPhotoService], [AdditionalPhotoService]) VALUES (12, N'Спа уход от OPI ромашка и мята', NULL, 870.0000, 0.25, CAST(N'00:30:00' AS Time), NULL, NULL)
SET IDENTITY_INSERT [dbo].[Service] OFF
SET IDENTITY_INSERT [dbo].[Size] ON 

INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (1, 40, 50, 120)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (2, 50, 32, 100)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (3, 50, 14, 40)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (4, 40, 40, 20)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (5, 70, 20, 100)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (6, 40, 20, 60)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (7, 20, 20, 20)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (8, 51, 44, 50)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (9, 50, 10, 10)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (10, 50, 40, 44)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (11, 100, 10, 100)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (12, 200, 100, 20)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (13, 20, 40, 60)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (14, 20, 60, 70)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (15, 20, 20, 20)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (16, 40, 70, 80)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (17, 10, 20, 30)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (18, 20, 30, 40)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (19, 30, 40, 50)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (20, 40, 50, 60)
INSERT [dbo].[Size] ([id], [SizeX], [SizeY], [SizeZ]) VALUES (21, 50, 60, 70)
SET IDENTITY_INSERT [dbo].[Size] OFF
ALTER TABLE [dbo].[ClientRecordService]  WITH CHECK ADD  CONSTRAINT [FK_ClientRecordService_Clients] FOREIGN KEY([Clientid])
REFERENCES [dbo].[Clients] ([id])
GO
ALTER TABLE [dbo].[ClientRecordService] CHECK CONSTRAINT [FK_ClientRecordService_Clients]
GO
ALTER TABLE [dbo].[ClientRecordService]  WITH CHECK ADD  CONSTRAINT [FK_ClientRecordService_Service] FOREIGN KEY([Serviceid])
REFERENCES [dbo].[Service] ([id])
GO
ALTER TABLE [dbo].[ClientRecordService] CHECK CONSTRAINT [FK_ClientRecordService_Service]
GO
ALTER TABLE [dbo].[Clients]  WITH CHECK ADD  CONSTRAINT [FK_Clients_ClientStatus] FOREIGN KEY([ClientStatusid])
REFERENCES [dbo].[ClientStatus] ([id])
GO
ALTER TABLE [dbo].[Clients] CHECK CONSTRAINT [FK_Clients_ClientStatus]
GO
ALTER TABLE [dbo].[Clients]  WITH CHECK ADD  CONSTRAINT [FK_Clients_People] FOREIGN KEY([Peoplid])
REFERENCES [dbo].[People] ([id])
GO
ALTER TABLE [dbo].[Clients] CHECK CONSTRAINT [FK_Clients_People]
GO
ALTER TABLE [dbo].[Employe]  WITH CHECK ADD  CONSTRAINT [FK_Employe_CategorySpecial] FOREIGN KEY([CategorySpecialid])
REFERENCES [dbo].[CategorySpecial] ([id])
GO
ALTER TABLE [dbo].[Employe] CHECK CONSTRAINT [FK_Employe_CategorySpecial]
GO
ALTER TABLE [dbo].[Employe]  WITH CHECK ADD  CONSTRAINT [FK_Employe_People] FOREIGN KEY([Peoplid])
REFERENCES [dbo].[People] ([id])
GO
ALTER TABLE [dbo].[Employe] CHECK CONSTRAINT [FK_Employe_People]
GO
ALTER TABLE [dbo].[PayHistory]  WITH CHECK ADD  CONSTRAINT [FK_PayHistory_Clients] FOREIGN KEY([Clientid])
REFERENCES [dbo].[Clients] ([id])
GO
ALTER TABLE [dbo].[PayHistory] CHECK CONSTRAINT [FK_PayHistory_Clients]
GO
ALTER TABLE [dbo].[PayHistory]  WITH CHECK ADD  CONSTRAINT [FK_PayHistory_Product] FOREIGN KEY([Productid])
REFERENCES [dbo].[Product] ([id])
GO
ALTER TABLE [dbo].[PayHistory] CHECK CONSTRAINT [FK_PayHistory_Product]
GO
ALTER TABLE [dbo].[People]  WITH CHECK ADD  CONSTRAINT [FK_People_Gender] FOREIGN KEY([Genderid])
REFERENCES [dbo].[Gender] ([id])
GO
ALTER TABLE [dbo].[People] CHECK CONSTRAINT [FK_People_Gender]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_CategoryProduct] FOREIGN KEY([CategoryProductid])
REFERENCES [dbo].[CategoryProduct] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_CategoryProduct]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Manufacturer] FOREIGN KEY([Manufacturerid])
REFERENCES [dbo].[Manufacturer] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Manufacturer]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Size] FOREIGN KEY([Sizeid])
REFERENCES [dbo].[Size] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Size]
GO
USE [master]
GO
ALTER DATABASE [DemoExamBD1] SET  READ_WRITE 
GO