ScriptBase/ScriptCafeBase.sql

USE [master]
GO
/****** Object:  Database [Cafe]    Script Date: Чт 22.10.20 22:27:43 ******/
CREATE DATABASE [Cafe]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Cafe', FILENAME = N'F:\sql\MSSQL14.SQL\MSSQL\DATA\Cafe.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Cafe_log', FILENAME = N'F:\sql\MSSQL14.SQL\MSSQL\DATA\Cafe_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [Cafe] SET COMPATIBILITY_LEVEL = 140
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Cafe].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Cafe] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Cafe] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Cafe] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Cafe] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Cafe] SET ARITHABORT OFF 
GO
ALTER DATABASE [Cafe] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [Cafe] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Cafe] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Cafe] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Cafe] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Cafe] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Cafe] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Cafe] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Cafe] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Cafe] SET  DISABLE_BROKER 
GO
ALTER DATABASE [Cafe] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Cafe] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Cafe] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Cafe] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Cafe] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Cafe] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [Cafe] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [Cafe] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [Cafe] SET  MULTI_USER 
GO
ALTER DATABASE [Cafe] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Cafe] SET DB_CHAINING OFF 
GO
ALTER DATABASE [Cafe] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [Cafe] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [Cafe] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [Cafe] SET QUERY_STORE = OFF
GO
USE [Cafe]
GO
/****** Object:  Table [dbo].[Change]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Change](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FkEmployeeId] [int] NOT NULL,
	[DateCreated] [date] NOT NULL,
	[QuantityEmployes] [int] NOT NULL,
 CONSTRAINT [PK_Change] 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].[Dish]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dish](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfDish] [nvarchar](50) NOT NULL,
	[Price] [money] NOT NULL,
	[TimeOfManufacturing] [int] NOT NULL,
 CONSTRAINT [PK_Dish] 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].[Employees]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employees](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[MiddleName] [nvarchar](50) NOT NULL,
	[NumberOfDocument] [nvarchar](50) NOT NULL,
	[Login] [nvarchar](50) NOT NULL,
	[Password] [nvarchar](50) NOT NULL,
	[FkStatusId] [int] NULL,
	[FkPositionId] [int] NOT NULL,
	[Photo] [image] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Order]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Order](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Place] [nvarchar](50) NOT NULL,
	[QuantityClients] [int] NOT NULL,
	[FkDishId] [int] NOT NULL,
	[FkEmployeeId] [int] NOT NULL,
	[FkStatusId] [int] NOT NULL,
 CONSTRAINT [PK_Order] 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].[Position]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Position](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfPosition] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Position] 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].[StatusOfEmployee]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StatusOfEmployee](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[StatusOfEmployee] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_StatusOfEmployee] 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].[StatusOfOrder]    Script Date: Чт 22.10.20 22:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StatusOfOrder](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[NameOfStatus] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_StatusOfOrder] 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].[Change] ON 

INSERT [dbo].[Change] ([id], [FkEmployeeId], [DateCreated], [QuantityEmployes]) VALUES (2, 2, CAST(N'2020-02-02' AS Date), 4)
INSERT [dbo].[Change] ([id], [FkEmployeeId], [DateCreated], [QuantityEmployes]) VALUES (3, 3, CAST(N'2020-05-05' AS Date), 3)
INSERT [dbo].[Change] ([id], [FkEmployeeId], [DateCreated], [QuantityEmployes]) VALUES (7, 4, CAST(N'2020-05-06' AS Date), 4)
INSERT [dbo].[Change] ([id], [FkEmployeeId], [DateCreated], [QuantityEmployes]) VALUES (8, 10, CAST(N'2020-10-10' AS Date), 6)
SET IDENTITY_INSERT [dbo].[Change] OFF
SET IDENTITY_INSERT [dbo].[Dish] ON 

INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (41, N'опомо (opomo)', 487.3700, 15)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (42, N'угюбо (ugyubo)', 339.5800, 23)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (43, N'ямуде (yamude)', 1575.3400, 47)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (44, N'гисек (gisek)', 4096.0300, 12)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (45, N'эмоху (emohu)', 354.8800, 52)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (46, N'эзего (ezego)', 4014.9000, 52)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (47, N'матит (matit)', 1228.1500, 34)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (48, N'абуно (abuno)', 2117.1400, 15)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (49, N'югупа (yugupa)', 531.6600, 53)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (50, N'амулу (amulu)', 903.5800, 25)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (51, N'евако (evako)', 3791.9200, 36)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (52, N'етомо (etomo)', 2020.1200, 41)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (53, N'акоке (akoke)', 4281.2900, 44)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (54, N'фанув (fanuv)', 438.0200, 16)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (55, N'уселе (usele)', 1695.4300, 52)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (56, N'етите (etite)', 4136.4500, 41)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (57, N'исуду (isudu)', 887.1800, 24)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (58, N'эриди (eridi)', 277.1900, 29)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (59, N'анокэ (anoke)', 2411.0200, 69)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (60, N'имала (imala)', 1984.6400, 21)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (61, N'асуту (asutu)', 1311.7100, 25)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (62, N'алище (alische)', 2894.3200, 45)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (63, N'гелоп (gelop)', 1351.6100, 20)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (64, N'упити (upiti)', 488.6400, 48)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (65, N'ореси (oresi)', 2199.2400, 20)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (66, N'югика (yugika)', 470.9900, 14)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (67, N'ецюру (ecyuru)', 3980.4300, 16)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (68, N'океба (okeba)', 612.7500, 14)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (69, N'кюгэг (kyugeg)', 1396.5600, 28)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (70, N'якиме (yakime)', 4157.8700, 23)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (71, N'ухуди (uhudi)', 3321.1700, 34)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (72, N'оруко (oruko)', 3272.7800, 43)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (73, N'дагим (dagim)', 3925.8900, 36)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (74, N'екуци (ekuci)', 1081.7100, 39)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (75, N'енугу (enugu)', 383.5400, 41)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (76, N'пирин (pirin)', 837.4800, 21)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (77, N'омиби (omibi)', 3579.1800, 12)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (78, N'адиве (adive)', 1828.4800, 19)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (79, N'пюном (pyunom)', 3405.8000, 62)
INSERT [dbo].[Dish] ([id], [NameOfDish], [Price], [TimeOfManufacturing]) VALUES (80, N'улока (uloka)', 3470.7000, 47)
SET IDENTITY_INSERT [dbo].[Dish] OFF
SET IDENTITY_INSERT [dbo].[Employees] ON 

INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (2, N'Гущин', N'Александр', N'Улебович', N'МегаТрейд_1_12\08', N'Elley', N'wzFd4v', NULL, 1, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (3, N'Казаков', N'Гавриил', N'Геннадьевич', N'МегаТрейд_1_12\09', N'Ollay', N'mEwRoQ', 1, 2, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (4, N'Брагин', N'Юлий', N'Фролович', N'МегаТрейд_1_12\10', N'Blakery', N'tUwVqf', NULL, 3, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (5, N'Назаров', N'Давид', N'Давидович', N'МегаТрейд_1_12\11', N'Thokie', N'sv62Cu', NULL, 1, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (6, N'Щукин', N'Борис', N'Геннадиевич', N'МегаТрейд_1_12\12', N'Edex', N'lZmplZ', NULL, 2, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (7, N'Гурьев', N'Ибрагил', N'Павлович', N'МегаТрейд_1_12\13', N'Tomseph', N'nHl8DE', NULL, 3, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (8, N'Панфилов', N'Рудольф', N'Лукьевич', N'МегаТрейд_1_12\14', N'Louiecha', N'tDx6Is', NULL, 1, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (9, N'Сафонов', N'Ираклий', N'Павлович', N'МегаТрейд_1_12\15', N'Bobam', N'Yjqxd3', 1, 2, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (10, N'Зуев', N'Семен', N'Богданович', N'МегаТрейд_1_12\16', N'Ausni', N'wbicYa', NULL, 3, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (11, N'Ковалёв', N'Игнат', N'Тарасович', N'МегаТрейд_1_12\17', N'Blakeot', N'POtncQ', NULL, 1, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (12, N'Потапов', N'Мечеслав', N'Васильевич', N'МегаТрейд_1_12\18', N'Oscas', N'zvvDV9', NULL, 2, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (13, N'Маслов', N'Арсений', N'Семёнович', N'МегаТрейд_1_12\19', N'Lukethan', N'WUbbSS', NULL, 3, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (14, N'Бирюкова', N'Анастасия', N'Германновна', N'МегаТрейд_1_12\20', N'Bethala', N'SGRI28', NULL, 1, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (15, N'Павлова', N'Анна', N'Антониновна', N'МегаТрейд_1_12\21', N'Brooketha', N'YdL5dx', NULL, 2, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (16, N'Ларионова', N'Джема', N'Богдановна', N'МегаТрейд_1_12\22', N'Avasica', N'mF5pSy', NULL, 3, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (17, N'Якушева', N'Аэлита', N'Макаровна', N'МегаТрейд_1_12\23', N'Mato', N'bS5D48', NULL, 1, NULL)
INSERT [dbo].[Employees] ([id], [FirstName], [LastName], [MiddleName], [NumberOfDocument], [Login], [Password], [FkStatusId], [FkPositionId], [Photo]) VALUES (18, N'Меркушева', N'Веста', N'Валентиновна', N'МегаТрейд_1_12\24', N'Fretha', N'WyhoaP', NULL, 2, NULL)
SET IDENTITY_INSERT [dbo].[Employees] OFF
SET IDENTITY_INSERT [dbo].[Order] ON 

INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (1, N'2А', 2, 41, 2, 1)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (2, N'2Б', 2, 42, 3, 2)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (3, N'2А', 2, 56, 4, 3)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (4, N'2А', 2, 43, 5, 1)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (5, N'2А', 2, 66, 6, 2)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (6, N'2Б', 2, 53, 7, 3)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (7, N'2А', 2, 44, 8, 1)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (8, N'2А', 2, 78, 9, 2)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (9, N'2А', 2, 60, 10, 3)
INSERT [dbo].[Order] ([id], [Place], [QuantityClients], [FkDishId], [FkEmployeeId], [FkStatusId]) VALUES (10, N'2А', 2, 51, 11, 1)
SET IDENTITY_INSERT [dbo].[Order] OFF
SET IDENTITY_INSERT [dbo].[Position] ON 

INSERT [dbo].[Position] ([id], [NameOfPosition]) VALUES (1, N'Администратор')
INSERT [dbo].[Position] ([id], [NameOfPosition]) VALUES (2, N'Повар')
INSERT [dbo].[Position] ([id], [NameOfPosition]) VALUES (3, N'Официант')
SET IDENTITY_INSERT [dbo].[Position] OFF
SET IDENTITY_INSERT [dbo].[StatusOfEmployee] ON 

INSERT [dbo].[StatusOfEmployee] ([id], [StatusOfEmployee]) VALUES (1, N'Уволен')
SET IDENTITY_INSERT [dbo].[StatusOfEmployee] OFF
SET IDENTITY_INSERT [dbo].[StatusOfOrder] ON 

INSERT [dbo].[StatusOfOrder] ([id], [NameOfStatus]) VALUES (1, N'Готов')
INSERT [dbo].[StatusOfOrder] ([id], [NameOfStatus]) VALUES (2, N'Не готов')
INSERT [dbo].[StatusOfOrder] ([id], [NameOfStatus]) VALUES (3, N'На замене')
SET IDENTITY_INSERT [dbo].[StatusOfOrder] OFF
ALTER TABLE [dbo].[Change]  WITH CHECK ADD  CONSTRAINT [FK_Change_Employees] FOREIGN KEY([id])
REFERENCES [dbo].[Employees] ([id])
GO
ALTER TABLE [dbo].[Change] CHECK CONSTRAINT [FK_Change_Employees]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Position] FOREIGN KEY([FkPositionId])
REFERENCES [dbo].[Position] ([id])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Position]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_StatusOfEmployee] FOREIGN KEY([FkStatusId])
REFERENCES [dbo].[StatusOfEmployee] ([id])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_StatusOfEmployee]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_Dish] FOREIGN KEY([FkDishId])
REFERENCES [dbo].[Dish] ([id])
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Dish]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_Employees] FOREIGN KEY([FkEmployeeId])
REFERENCES [dbo].[Employees] ([id])
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Employees]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_StatusOfOrder] FOREIGN KEY([FkStatusId])
REFERENCES [dbo].[StatusOfOrder] ([id])
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_StatusOfOrder]
GO
USE [master]
GO
ALTER DATABASE [Cafe] SET  READ_WRITE 
GO