USE [master]
GO
/****** Object:  Database [SaloonBase]    Script Date: Пт 16.10.20 22:03:08 ******/
CREATE DATABASE [SaloonBase]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'SaloonBase', FILENAME = N'F:\sql\MSSQL14.SQL\MSSQL\DATA\SaloonBase.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'SaloonBase_log', FILENAME = N'F:\sql\MSSQL14.SQL\MSSQL\DATA\SaloonBase_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [SaloonBase] SET COMPATIBILITY_LEVEL = 140
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [SaloonBase].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [SaloonBase] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [SaloonBase] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [SaloonBase] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [SaloonBase] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [SaloonBase] SET ARITHABORT OFF 
GO
ALTER DATABASE [SaloonBase] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [SaloonBase] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [SaloonBase] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [SaloonBase] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [SaloonBase] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [SaloonBase] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [SaloonBase] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [SaloonBase] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [SaloonBase] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [SaloonBase] SET  DISABLE_BROKER 
GO
ALTER DATABASE [SaloonBase] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [SaloonBase] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [SaloonBase] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [SaloonBase] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [SaloonBase] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [SaloonBase] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [SaloonBase] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [SaloonBase] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [SaloonBase] SET  MULTI_USER 
GO
ALTER DATABASE [SaloonBase] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [SaloonBase] SET DB_CHAINING OFF 
GO
ALTER DATABASE [SaloonBase] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [SaloonBase] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [SaloonBase] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [SaloonBase] SET QUERY_STORE = OFF
GO
USE [SaloonBase]
GO
/****** Object:  Table [dbo].[CategoryOfProduct]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CategoryOfProduct](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfCategory] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_CategoryOfProduct] 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: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Clients](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[PhoneNubmer] [nvarchar](50) NOT NULL,
	[Email] [nvarchar](50) NOT NULL,
	[FirstDateOfVisit] [datetime] NOT NULL,
	[FkTag] [int] NOT NULL,
	[FkPerson] [int] NOT NULL,
	[Photo] [image] 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].[Employees]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employees](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[SeriesOfPassport] [int] NOT NULL,
	[NumberOfPassport] [int] NOT NULL,
	[CodeOfDepartament] [int] NOT NULL,
	[CoeffPay] [int] NOT NULL,
	[FkSpecial] [int] NOT NULL,
	[FkPerson] [int] NOT NULL,
 CONSTRAINT [PK_Employees] 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: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Gender](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[GenderName] [nvarchar](50) 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].[HystoryOfPay]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HystoryOfPay](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FkProduct] [int] NOT NULL,
	[FkClient] [int] NOT NULL,
	[DateOfPay] [datetime] NOT NULL,
	[CountProduct] [int] NOT NULL,
 CONSTRAINT [PK_HystoryOfPay] 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].[Person]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Person](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[MiddleName] [nvarchar](50) NULL,
	[BirthDay] [date] NOT NULL,
	[FkGender] [int] NOT NULL,
 CONSTRAINT [PK_Person] 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].[Products]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Products](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FkCategory] [int] NOT NULL,
	[FkSize] [int] NOT NULL,
	[FkStatusOfProduct] [int] NOT NULL,
	[NameOfProducts] [nvarchar](50) NOT NULL,
	[Price] [money] NOT NULL,
	[Property] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](100) NULL,
	[Weight] [int] NOT NULL,
	[Manufacturer] [nvarchar](50) NULL,
	[MainImage] [image] NULL,
	[OtherImage] [image] NULL,
 CONSTRAINT [PK_Products] 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: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Service](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfService] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](100) NULL,
	[Price] [money] NOT NULL,
	[Discount] [int] NOT NULL,
	[DateOfSale] [datetime] NOT NULL,
	[FkEmployee] [int] NOT NULL,
	[MainPhotoOfService] [image] NULL,
	[OtherPhotos] [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: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Size](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[SizeHeight] [int] NOT NULL,
	[SizeLength] [int] NOT NULL,
	[SizeWidth] [int] 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
/****** Object:  Table [dbo].[SpecialCategories]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SpecialCategories](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfSpecialCategory] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_SpecialCategories] 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].[StatusOfProduct]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StatusOfProduct](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[StatusOfProduct] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_StatusOfProduct] 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].[Tags]    Script Date: Пт 16.10.20 22:03:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tags](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfTags] [nvarchar](50) NOT NULL,
	[Color] [nvarchar](50) NULL,
 CONSTRAINT [PK_Tags] 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].[CategoryOfProduct] ON 

INSERT [dbo].[CategoryOfProduct] ([id], [NameOfCategory]) VALUES (1, N'Косметика')
INSERT [dbo].[CategoryOfProduct] ([id], [NameOfCategory]) VALUES (2, N'Парфюмерия')
SET IDENTITY_INSERT [dbo].[CategoryOfProduct] OFF
SET IDENTITY_INSERT [dbo].[Clients] ON 

INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (1, N'89528002476', N' kika@mail.ru', CAST(N'2010-02-23T00:00:00.000' AS DateTime), 1, 7, NULL)
INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (2, N'89538002474', N'duriv@mail.inbox', CAST(N'2010-02-24T00:00:00.000' AS DateTime), 2, 8, NULL)
INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (3, N'89548002473', N'yana@yandex.ru', CAST(N'2010-02-22T00:00:00.000' AS DateTime), 3, 9, NULL)
INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (4, N'89558002477', N'goog@google.com', CAST(N'2010-02-21T00:00:00.000' AS DateTime), 4, 10, NULL)
INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (5, N'89568002477', N'jija@mail.ru', CAST(N'2010-02-20T00:00:00.000' AS DateTime), 5, 11, NULL)
INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (6, N'89578002477', N'keksik24@mail.ru', CAST(N'2010-02-18T00:00:00.000' AS DateTime), 2, 12, NULL)
INSERT [dbo].[Clients] ([id], [PhoneNubmer], [Email], [FirstDateOfVisit], [FkTag], [FkPerson], [Photo]) VALUES (7, N'89588002477', N'lelik@gmail.com', CAST(N'2010-02-17T00:00:00.000' AS DateTime), 4, 13, NULL)
SET IDENTITY_INSERT [dbo].[Clients] OFF
SET IDENTITY_INSERT [dbo].[Employees] ON 

INSERT [dbo].[Employees] ([id], [SeriesOfPassport], [NumberOfPassport], [CodeOfDepartament], [CoeffPay], [FkSpecial], [FkPerson]) VALUES (1, 6915, 613567, 566, 10, 1, 1)
INSERT [dbo].[Employees] ([id], [SeriesOfPassport], [NumberOfPassport], [CodeOfDepartament], [CoeffPay], [FkSpecial], [FkPerson]) VALUES (2, 6916, 423768, 567, 11, 2, 2)
INSERT [dbo].[Employees] ([id], [SeriesOfPassport], [NumberOfPassport], [CodeOfDepartament], [CoeffPay], [FkSpecial], [FkPerson]) VALUES (3, 6917, 663962, 565, 12, 3, 3)
INSERT [dbo].[Employees] ([id], [SeriesOfPassport], [NumberOfPassport], [CodeOfDepartament], [CoeffPay], [FkSpecial], [FkPerson]) VALUES (4, 6918, 398563, 563, 13, 4, 4)
INSERT [dbo].[Employees] ([id], [SeriesOfPassport], [NumberOfPassport], [CodeOfDepartament], [CoeffPay], [FkSpecial], [FkPerson]) VALUES (5, 6917, 634576, 564, 9, 5, 5)
INSERT [dbo].[Employees] ([id], [SeriesOfPassport], [NumberOfPassport], [CodeOfDepartament], [CoeffPay], [FkSpecial], [FkPerson]) VALUES (6, 6912, 513564, 567, 14, 6, 6)
SET IDENTITY_INSERT [dbo].[Employees] OFF
SET IDENTITY_INSERT [dbo].[Gender] ON 

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

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

INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (1, N'Зубенко ', N'Михаил', N'Петрович', CAST(N'1995-02-01' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (2, N'Зубрина', N'Мария', N'', CAST(N'1996-05-03' AS Date), 2)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (3, N'Белкин', N'Даниил', N'Михайлович', CAST(N'1997-07-11' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (4, N'Глебов', N'Александр', N'Николаевич', CAST(N'1994-02-01' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (5, N'Водянкин', N'Кирилл', N'Олегович', CAST(N'1993-11-21' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (6, N'Кудрявцева', N'Екатерина', N'Игоревна', CAST(N'1992-02-13' AS Date), 2)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (7, N'Чичиков', N'Кирилл', N'Андреевич', CAST(N'1999-02-12' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (8, N'Мельникова', N'Елена', N'Андреевна', CAST(N'1965-10-04' AS Date), 2)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (9, N'Ситчиков', N'Адрей', N'Павлович', CAST(N'1999-09-09' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (10, N'Мизинцева', N'София', N'', CAST(N'1978-04-02' AS Date), 2)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (11, N'Фигуркин', N'Борис', N'Федерович', CAST(N'2000-06-12' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (12, N'Интересов', N'Станислав', N'Леонидович', CAST(N'1984-09-09' AS Date), 1)
INSERT [dbo].[Person] ([id], [FirstName], [LastName], [MiddleName], [BirthDay], [FkGender]) VALUES (13, N'Фигуркина', N'Арина', N'Егоровна', CAST(N'1994-12-15' AS Date), 2)
SET IDENTITY_INSERT [dbo].[Person] OFF
SET IDENTITY_INSERT [dbo].[Products] ON 

INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (1, 1, 31, 3, N'Ирисовый освежающий увлажняющий крем', 720.0000, N'Отличное средство', N'Этот продукт обладает', 260, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (3, 1, 33, 1, N'Тоник для лица дневной, Витаминный', 800.0000, N'Отличное средство', N'Этот продукт обладает', 244, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (5, 1, 35, 3, N'Маска-пленка отшелушивающая с лифтинг-эффектом', 860.0000, N'Отличное средство', N'', 264, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (6, 2, 36, 4, N'Специальный крем для клеточного восстановления', 920.0000, N'Хорошее средство', N'Этот продукт обладает', 267, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (7, 1, 37, 4, N'Увлажняющий крем', 730.0000, N'Отличное средство', N'', 237, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (8, 2, 38, 2, N'Восстанавливающая маска для лица', 630.0000, N'Хорошее средство', N'Этот продукт обладает', 457, N' ANDALOU', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (9, 1, 39, 1, N'Крем SILK для чувствительной кожи лица натуральный', 740.0000, N'Отличное средство', N'', 247, N' MATSESTA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (10, 2, 40, 3, N'Подарочный набор Сияние', 630.0000, N'Хорошее средство', N'Этот продукт обладает', 421, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (11, 1, 41, 3, N'Пена для бритья Натуральная, Лимон и Корица', 470.0000, N'Отличное средство', N'', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (12, 2, 42, 3, N'Крем питательный тонизирующий ночной', 950.0000, N'Хорошее средство', N'', 333, N' BIOSelect', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (13, 1, 43, 3, N'Подарочный набор Супер Увлажнение', 830.0000, N'Отличное средство', N'', 260, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (14, 2, 44, 3, N'Подарочный набор Глубокое Очищение', 860.0000, N'Хорошее средство', N'Этот продукт обладает', 255, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (15, 1, 45, 3, N'Тоник ACTIVE для возрастной кожи лица натуральный', 720.0000, N'Отличное средство', N'', 244, N' MATSESTA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (16, 2, 46, 3, N'Эфирное масло мелиссы', 380.0000, N'Хорошее средство', N'', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (17, 1, 47, 3, N'Увлажняющая эмульсия для лица', 910.0000, N'Отличное средство', N'Этот продукт обладает', 264, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (18, 2, 48, 3, N'Масло персиковое', 280.0000, N'Хорошее средство', N'', 267, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (20, 2, 50, 3, N'Подарочный набор For HIM, Сильный мужчина', 900.0000, N'Хорошее средство', N'Этот продукт обладает', 457, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (22, 2, 52, 3, N'Розовый разглаживающий увлажняющий крем', 890.0000, N'Хорошее средство', N'Этот продукт обладает', 421, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (23, 1, 53, 3, N'Деликатный питательный крем', 890.0000, N'Отличное средство', N'Этот продукт обладает', 245, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (24, 2, 54, 1, N'Масло сладкого миндаля', 250.0000, N'Хорошее средство', N'Этот продукт обладает', 333, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (25, 1, 55, 3, N'Эфирное масло жасмин', 610.0000, N'Отличное средство', N'', 260, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (27, 1, 57, 3, N'Тоник для лица, для сухой и нормальной кожи', 490.0000, N'Отличное средство', N'', 244, N' DIONY', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (28, 2, 58, 2, N'Эфирное масло лемонграсс', 380.0000, N'Хорошее средство', N'Этот продукт обладает', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (29, 1, 59, 3, N'Ирисовый освежающий ночной крем', 840.0000, N'Отличное средство', N'', 264, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (30, 2, 31, 3, N'Деликатное очищающее молочко', 680.0000, N'Хорошее средство', N'Этот продукт обладает', 267, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (31, 1, 32, 3, N'Эфирное масло корицы', 370.0000, N'Отличное средство', N'', 237, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (32, 2, 33, 2, N'Очищающий гель для умывания', 720.0000, N'Хорошее средство', N'', 457, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (33, 1, 34, 3, N'Солнцезащитный лосьон для лица и тела', 830.0000, N'Отличное средство', N'', 247, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (37, 1, 38, 3, N'Подарочный набор Сияние и Красота', 570.0000, N'Отличное средство', N'Этот продукт обладает', 260, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (38, 2, 39, 3, N'Маска-пленка для глубокого очищения пор', 920.0000, N'Хорошее средство', N'', 255, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (39, 1, 40, 3, N'Ирисовый освежающий дневной крем', 740.0000, N'Отличное средство', N'', 244, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (40, 2, 41, 1, N'Деликатный увлажняющий крем', 940.0000, N'Хорошее средство', N'Этот продукт обладает', 245, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (41, 1, 42, 3, N'Ухаживающее масло, против сухости кожи', 410.0000, N'Отличное средство', N'Этот продукт обладает', 264, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (42, 2, 43, 1, N'Розовое растительное мыло', 470.0000, N'Хорошее средство', N'Этот продукт обладает', 267, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (43, 1, 44, 1, N'Гранатовый дневной крем-лифтинг', 800.0000, N'Отличное средство', N'Этот продукт обладает', 237, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (44, 2, 45, 1, N'Тонизирующее очищающее средство 2 в 1', 640.0000, N'Хорошее средство', N'Этот продукт обладает', 457, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (46, 2, 47, 1, N'Эфирное масло лимона', 330.0000, N'Хорошее средство', N'Этот продукт обладает', 421, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (47, 1, 48, 2, N'Эфирное масло розовое дерево', 510.0000, N'Отличное средство', N'', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (48, 2, 49, 4, N'Мягкая пенка для умывания', 680.0000, N'Хорошее средство', N'Этот продукт обладает', 333, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (50, 2, 51, 1, N'Тоник для лица, для жирной и проблемной кожи', 600.0000, N'Хорошее средство', N'Этот продукт обладает', 255, N' DIONY', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (53, 1, 54, 3, N'Эфирное масло эвкалипт', 410.0000, N'Отличное средство', N'', 264, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (56, 2, 57, 3, N'Пенка для лица для чувствительной кожи', 630.0000, N'Хорошее средство', N'', 457, N' ANDALOU', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (59, 1, 31, 3, N'Подарочный набор For MEN', 840.0000, N'Отличное средство', N'', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (60, 2, 32, 3, N'Очищающий гель для нормальной и сухой кожи лица', 720.0000, N'Хорошее средство', N'Этот продукт обладает', 333, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (61, 1, 33, 2, N'Лифтинг-сыворотка для лица', 930.0000, N'Отличное средство', N'Этот продукт обладает', 260, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (62, 2, 34, 1, N'Тоник для ухода за сухой и нормальной кожей', 990.0000, N'Хорошее средство', N'Этот продукт обладает', 255, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (63, 1, 35, 4, N'Питательный крем для лица', 800.0000, N'Отличное средство', N'Этот продукт обладает', 244, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (64, 2, 36, 2, N'Крем против морщин для глаз', 570.0000, N'Хорошее средство', N'Этот продукт обладает', 245, N' BIOSelect', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (65, 1, 37, 3, N'Лифтинг-сыворотка для лица с гиалуроновой кислотой', 610.0000, N'Отличное средство', N'', 264, N' DIONY', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (66, 2, 38, 3, N'Деликатное питательное масло для лица', 930.0000, N'Хорошее средство', N'Этот продукт обладает', 267, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (67, 1, 39, 3, N'Тонизирующая сыворотка для лица', 780.0000, N'Отличное средство', N'', 237, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (69, 1, 41, 3, N'Сыворотка COUPEROSE укрепляющая сосуды натуральная', 590.0000, N'Отличное средство', N'', 247, N' MATSESTA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (70, 2, 42, 3, N'Органический тонер с экстрактом Розы', 960.0000, N'Хорошее средство', N'Этот продукт обладает', 421, N' Blue Beautifly', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (72, 2, 44, 1, N'Маска для лица увлажняющая и тонизирующая', 860.0000, N'Хорошее средство', N'', 333, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (73, 1, 45, 3, N'Эфирное масло чайного дерева', 410.0000, N'Отличное средство', N'', 260, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (75, 1, 47, 3, N'Масло после бритья Натуральное, Лимон и Корица', 300.0000, N'Отличное средство', N'', 244, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (76, 2, 48, 3, N'Ухаживающее масло для лица, восстанавливает кожу', 420.0000, N'Хорошее средство', N'', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (77, 1, 49, 3, N'Подарочный набор Мягкое Очищение', 850.0000, N'Отличное средство', N'Этот продукт обладает', 264, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (78, 2, 50, 3, N'Гранатовый ночной крем-лифтинг', 560.0000, N'Хорошее средство', N'', 267, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (79, 1, 51, 3, N'Живительный тоник для лица', 770.0000, N'Отличное средство', N'', 237, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (80, 2, 52, 1, N'Универсальный питательный крем SKIN FOOD', 640.0000, N'Хорошее средство', N'Этот продукт обладает', 457, N' Weleda', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (81, 1, 53, 3, N'Органическое 100% аргановое масло', 760.0000, N'Отличное средство', N'Этот продукт обладает', 247, N' Blue Beautifly', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (82, 2, 54, 3, N'Пенка для умывания, для нормальной кожи', 400.0000, N'Хорошее средство', N'Этот продукт обладает', 421, N' DIONY', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (83, 1, 55, 1, N'Крем PERFECT выравнивающий тон лица натуральный', 780.0000, N'Отличное средство', N'Этот продукт обладает', 245, N' MATSESTA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (84, 2, 56, 1, N'Чистящая пена-гель для лица', 550.0000, N'Хорошее средство', N'Этот продукт обладает', 333, N' BIOSelect', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (85, 1, 57, 1, N'Пенка для умывания Натуральная, Лимон и корица', 280.0000, N'Отличное средство', N'', 260, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (86, 2, 58, 4, N'Масло для лица массажное, с эффектом Лифтинга', 500.0000, N'Хорошее средство', N'Этот продукт обладает', 255, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (87, 1, 59, 3, N'Увлажняющий 24-часовой крем против морщин', 910.0000, N'Отличное средство', N'', 244, N' BIOSelect', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (88, 2, 31, 3, N'Подарочный набор Travel, в Командировку, мужской', 880.0000, N'Хорошее средство', N'Этот продукт обладает', 245, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (89, 1, 32, 3, N'Тоник для ухода за жирной и комбинированной кожей', 800.0000, N'Отличное средство', N'', 264, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (90, 2, 33, 3, N'Тонизирующий крем для лица', 800.0000, N'Хорошее средство', N'Этот продукт обладает', 267, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (92, 2, 35, 2, N'Эфирное масло перечной мяты', 390.0000, N'Хорошее средство', N'', 457, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (93, 1, 36, 3, N'Тоник для лица, Успокаивающий, для всех типов кожи', 410.0000, N'Отличное средство', N'', 247, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (94, 2, 37, 3, N'Эфирное масло бергамота', 380.0000, N'Хорошее средство', N'Этот продукт обладает', 421, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (95, 1, 38, 3, N'Гималайская грязевая маска восстанавливающая', 640.0000, N'Отличное средство', N'', 245, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (96, 2, 39, 1, N'Эфирное масло лаванды', 570.0000, N'Хорошее средство', N'', 333, N' Natura Botanica', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (97, 1, 40, 3, N'Гималайская грязевая маска антиоксидантная', 660.0000, N'Отличное средство', N'Этот продукт обладает', 421, N' AMSARVEDA', NULL, NULL)
INSERT [dbo].[Products] ([id], [FkCategory], [FkSize], [FkStatusOfProduct], [NameOfProducts], [Price], [Property], [Description], [Weight], [Manufacturer], [MainImage], [OtherImage]) VALUES (98, 2, 41, 1, N'Гранатовая интенсивная сыворотка-лифтинг', 720.0000, N'Хорошее средство', N'', 245, N' Weleda', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Products] OFF
SET IDENTITY_INSERT [dbo].[Service] ON 

INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (5, N'Подарочный набор Travel, в Командировку, мужской', N'Это средство для...', 250.0000, 30, CAST(N'2019-01-01T15:08:49.000' AS DateTime), 5, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (10, N'Увлажняющий 24-часовой крем против морщин', N'Это средство для...', 200.0000, 20, CAST(N'2019-03-03T08:32:34.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (12, N'Эфирное масло лаванды', N'Это средство для...', 400.0000, 25, CAST(N'2019-03-10T19:54:58.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (13, N'Розовый разглаживающий увлажняющий крем', N'Это средство для...', 500.0000, 30, CAST(N'2019-12-11T18:41:34.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (14, N'Универсальный питательный крем SKIN FOOD', N'', 250.0000, 40, CAST(N'2019-12-02T17:09:02.000' AS DateTime), 2, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (15, N'Тоник для лица, Успокаивающий, для всех типов кожи', N'', 350.0000, 35, CAST(N'2019-01-11T15:39:50.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (16, N'Тонизирующий крем для лица', N'Это средство для...', 400.0000, 5, CAST(N'2019-10-06T11:07:03.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (19, N'Масло для лица массажное, с эффектом Лифтинга', N'Это средство для...', 200.0000, 15, CAST(N'2019-07-01T11:22:57.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (23, N'Масло для лица массажное, с эффектом Лифтинга', N'Это средство для...', 250.0000, 35, CAST(N'2019-07-06T10:05:11.000' AS DateTime), 5, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (24, N'Ухаживающее масло для лица, восстанавливает кожу', N'Это средство для...', 350.0000, 5, CAST(N'2019-08-02T16:40:39.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (25, N'Крем питательный тонизирующий ночной', N'Это средство для...', 400.0000, 10, CAST(N'2019-12-01T15:11:05.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (31, N'Эфирное масло жасмин', N'Это средство для...', 500.0000, 35, CAST(N'2019-08-03T10:24:21.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (34, N'Пенка для умывания, для нормальной кожи', N'Это средство для...', 400.0000, 20, CAST(N'2019-06-08T13:21:49.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (38, N'Эфирное масло лаванды', N'Это средство для...', 300.0000, 40, CAST(N'2019-03-10T11:04:12.000' AS DateTime), 2, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (39, N'Органический тонер с экстрактом Розы', N'Это средство для...', 400.0000, 35, CAST(N'2019-11-10T13:27:50.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (43, N'Гималайская грязевая маска антиоксидантная', N'', 400.0000, 15, CAST(N'2019-09-04T12:02:17.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (45, N'Масло для лица массажное, с эффектом Лифтинга', N'Это средство для...', 600.0000, 30, CAST(N'2019-03-07T16:52:30.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (48, N'Сыворотка COUPEROSE укрепляющая сосуды натуральная', N'Это средство для...', 400.0000, 5, CAST(N'2019-03-03T18:35:05.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (50, N'Эфирное масло бергамота', N'Это средство для...', 250.0000, 20, CAST(N'2019-11-03T17:02:02.000' AS DateTime), 2, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (53, N'Эфирное масло мелиссы', N'Это средство для...', 500.0000, 30, CAST(N'2019-09-12T11:56:02.000' AS DateTime), 5, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (54, N'Тоник для ухода за жирной и комбинированной кожей', N'Это средство для...', 600.0000, 40, CAST(N'2019-02-10T17:30:21.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (58, N'Очищающий гель для умывания', N'', 500.0000, 20, CAST(N'2019-06-09T12:57:51.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (59, N'Чистящая пена-гель для лица', N'Это средство для...', 250.0000, 15, CAST(N'2019-04-12T13:10:28.000' AS DateTime), 5, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (62, N'Эфирное масло перечной мяты', N'Это средство для...', 500.0000, 40, CAST(N'2019-12-08T09:33:21.000' AS DateTime), 2, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (64, N'Гранатовый ночной крем-лифтинг', N'Это средство для...', 200.0000, 5, CAST(N'2019-02-11T16:32:41.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (69, N'Увлажняющая эмульсия для лица', N'Это средство для...', 350.0000, 30, CAST(N'2019-06-08T14:38:35.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (70, N'Эфирное масло перечной мяты', N'Это средство для...', 400.0000, 40, CAST(N'2019-09-01T10:46:52.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (71, N'Пенка для умывания, для нормальной кожи', N'Это средство для...', 500.0000, 35, CAST(N'2019-08-04T08:45:46.000' AS DateTime), 5, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (72, N'Подарочный набор Супер Увлажнение', N'', 600.0000, 5, CAST(N'2019-10-06T15:57:53.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (73, N'Эфирное масло лаванды', N'', 200.0000, 10, CAST(N'2019-06-11T10:21:22.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (81, N'Подарочный набор For HIM, Сильный мужчина', N'', 600.0000, 10, CAST(N'2019-08-07T15:21:09.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (82, N'Эфирное масло эвкалипт', N'Это средство для...', 200.0000, 20, CAST(N'2019-10-06T19:54:41.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (84, N'Ирисовый освежающий ночной крем', N'Это средство для...', 400.0000, 25, CAST(N'2019-11-01T12:11:42.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (85, N'Подарочный набор Супер Увлажнение', N'Это средство для...', 500.0000, 30, CAST(N'2019-08-12T16:58:50.000' AS DateTime), 1, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (87, N'Увлажняющая эмульсия для лица', N'Это средство для...', 350.0000, 35, CAST(N'2019-10-07T17:54:19.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (88, N'Тоник для лица, для жирной и проблемной кожи', N'', 400.0000, 5, CAST(N'2019-08-09T11:52:21.000' AS DateTime), 4, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (93, N'Питательный крем для лица', N'Это средство для...', 400.0000, 30, CAST(N'2019-11-07T16:30:13.000' AS DateTime), 3, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (96, N'Гранатовый дневной крем-лифтинг', N'Это средство для...', 350.0000, 5, CAST(N'2019-08-08T18:37:15.000' AS DateTime), 6, NULL, NULL)
INSERT [dbo].[Service] ([id], [NameOfService], [Description], [Price], [Discount], [DateOfSale], [FkEmployee], [MainPhotoOfService], [OtherPhotos]) VALUES (100, N'Лифтинг-сыворотка для лица', N'Это средство для...', 200.0000, 25, CAST(N'2019-05-07T16:03:31.000' AS DateTime), 4, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Service] OFF
SET IDENTITY_INSERT [dbo].[Size] ON 

INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (31, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (32, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (33, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (34, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (35, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (36, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (37, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (38, 22, 23, 24)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (39, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (40, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (41, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (42, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (43, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (44, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (45, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (46, 24, 25, 26)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (47, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (48, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (49, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (50, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (51, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (52, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (53, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (54, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (55, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (56, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (57, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (58, 26, 27, 28)
INSERT [dbo].[Size] ([id], [SizeHeight], [SizeLength], [SizeWidth]) VALUES (59, 26, 27, 28)
SET IDENTITY_INSERT [dbo].[Size] OFF
SET IDENTITY_INSERT [dbo].[SpecialCategories] ON 

INSERT [dbo].[SpecialCategories] ([id], [NameOfSpecialCategory]) VALUES (1, N'Парикмахер')
INSERT [dbo].[SpecialCategories] ([id], [NameOfSpecialCategory]) VALUES (2, N'Администратор')
INSERT [dbo].[SpecialCategories] ([id], [NameOfSpecialCategory]) VALUES (3, N'Уборщица')
INSERT [dbo].[SpecialCategories] ([id], [NameOfSpecialCategory]) VALUES (4, N'Заместитель директора')
INSERT [dbo].[SpecialCategories] ([id], [NameOfSpecialCategory]) VALUES (5, N'Директор')
INSERT [dbo].[SpecialCategories] ([id], [NameOfSpecialCategory]) VALUES (6, N'Кассир')
SET IDENTITY_INSERT [dbo].[SpecialCategories] OFF
SET IDENTITY_INSERT [dbo].[StatusOfProduct] ON 

INSERT [dbo].[StatusOfProduct] ([id], [StatusOfProduct]) VALUES (1, N'Активен')
INSERT [dbo].[StatusOfProduct] ([id], [StatusOfProduct]) VALUES (2, N'Не активен')
INSERT [dbo].[StatusOfProduct] ([id], [StatusOfProduct]) VALUES (3, N'Да')
INSERT [dbo].[StatusOfProduct] ([id], [StatusOfProduct]) VALUES (4, N'Нет')
SET IDENTITY_INSERT [dbo].[StatusOfProduct] OFF
SET IDENTITY_INSERT [dbo].[Tags] ON 

INSERT [dbo].[Tags] ([id], [NameOfTags], [Color]) VALUES (1, N'Краска для волос', N'Красный')
INSERT [dbo].[Tags] ([id], [NameOfTags], [Color]) VALUES (2, N'Маска для мытья', N'Белый')
INSERT [dbo].[Tags] ([id], [NameOfTags], [Color]) VALUES (3, N'Масло', N'Жёлтый')
INSERT [dbo].[Tags] ([id], [NameOfTags], [Color]) VALUES (4, N'Тоник', N'Бежевый')
INSERT [dbo].[Tags] ([id], [NameOfTags], [Color]) VALUES (5, N'Крем', N'Голубой')
SET IDENTITY_INSERT [dbo].[Tags] OFF
ALTER TABLE [dbo].[Clients]  WITH CHECK ADD  CONSTRAINT [FK_Clients_Person] FOREIGN KEY([FkPerson])
REFERENCES [dbo].[Person] ([id])
GO
ALTER TABLE [dbo].[Clients] CHECK CONSTRAINT [FK_Clients_Person]
GO
ALTER TABLE [dbo].[Clients]  WITH CHECK ADD  CONSTRAINT [FK_Clients_Tags] FOREIGN KEY([FkTag])
REFERENCES [dbo].[Tags] ([id])
GO
ALTER TABLE [dbo].[Clients] CHECK CONSTRAINT [FK_Clients_Tags]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Person] FOREIGN KEY([FkPerson])
REFERENCES [dbo].[Person] ([id])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Person]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_SpecialCategories] FOREIGN KEY([FkSpecial])
REFERENCES [dbo].[SpecialCategories] ([id])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_SpecialCategories]
GO
ALTER TABLE [dbo].[HystoryOfPay]  WITH CHECK ADD  CONSTRAINT [FK_HystoryOfPay_Clients] FOREIGN KEY([FkClient])
REFERENCES [dbo].[Clients] ([id])
GO
ALTER TABLE [dbo].[HystoryOfPay] CHECK CONSTRAINT [FK_HystoryOfPay_Clients]
GO
ALTER TABLE [dbo].[HystoryOfPay]  WITH CHECK ADD  CONSTRAINT [FK_HystoryOfPay_Products] FOREIGN KEY([FkProduct])
REFERENCES [dbo].[Products] ([id])
GO
ALTER TABLE [dbo].[HystoryOfPay] CHECK CONSTRAINT [FK_HystoryOfPay_Products]
GO
ALTER TABLE [dbo].[Person]  WITH CHECK ADD  CONSTRAINT [FK_Person_Gender] FOREIGN KEY([FkGender])
REFERENCES [dbo].[Gender] ([id])
GO
ALTER TABLE [dbo].[Person] CHECK CONSTRAINT [FK_Person_Gender]
GO
ALTER TABLE [dbo].[Products]  WITH CHECK ADD  CONSTRAINT [FK_Products_CategoryOfProduct] FOREIGN KEY([FkCategory])
REFERENCES [dbo].[CategoryOfProduct] ([id])
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_CategoryOfProduct]
GO
ALTER TABLE [dbo].[Products]  WITH CHECK ADD  CONSTRAINT [FK_Products_Size] FOREIGN KEY([FkSize])
REFERENCES [dbo].[Size] ([id])
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_Size]
GO
ALTER TABLE [dbo].[Products]  WITH CHECK ADD  CONSTRAINT [FK_Products_StatusOfProduct] FOREIGN KEY([FkStatusOfProduct])
REFERENCES [dbo].[StatusOfProduct] ([id])
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_StatusOfProduct]
GO
ALTER TABLE [dbo].[Service]  WITH CHECK ADD  CONSTRAINT [FK_Service_Employees] FOREIGN KEY([FkEmployee])
REFERENCES [dbo].[Employees] ([id])
GO
ALTER TABLE [dbo].[Service] CHECK CONSTRAINT [FK_Service_Employees]
GO
USE [master]
GO
ALTER DATABASE [SaloonBase] SET  READ_WRITE 
GO