Test/1.sql

USE [kafe2]
GO
/****** Object:  Table [dbo].[CookStatus]    Script Date: 09.04.2022 15:44:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CookStatus](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_CookStatus] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Dish]    Script Date: 09.04.2022 15:44:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dish](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](50) NOT NULL,
	[CookTime] [int] NOT NULL,
	[Cost] [float] 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DishOrder]    Script Date: 09.04.2022 15:44:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DishOrder](
	[OrderID] [int] NOT NULL,
	[DishID] [int] NOT NULL,
	[Count] [int] NOT NULL,
 CONSTRAINT [PK_DishOrder] PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC,
	[DishID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Emploee]    Script Date: 09.04.2022 15:44:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Emploee](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Surname] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Middlename] [nvarchar](50) NOT NULL,
	[Login] [nvarchar](50) NOT NULL,
	[Password] [nvarchar](50) NOT NULL,
	[StatusID] [int] NOT NULL,
	[PositionID] [int] NOT NULL,
 CONSTRAINT [PK_Emploee] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Order]    Script Date: 09.04.2022 15:44:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Order](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CookSatusID] [int] NOT NULL,
	[PayStatusID] [int] NOT NULL,
	[EmploeeID] [int] NOT NULL,
	[TableNumber] [int] NOT NULL,
	[ClientCount] [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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PayStatus]    Script Date: 09.04.2022 15:44:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PayStatus](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_PayStatus] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Position]    Script Date: 09.04.2022 15:44:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Position](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Shift]    Script Date: 09.04.2022 15:44:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Shift](
	[EmploeeID] [int] NOT NULL,
	[Date] [date] NOT NULL,
 CONSTRAINT [PK_Shift] PRIMARY KEY CLUSTERED 
(
	[EmploeeID] ASC,
	[Date] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[WorkStatus]    Script Date: 09.04.2022 15:44:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WorkStatus](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_WorkStatus] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[CookStatus] ON 

INSERT [dbo].[CookStatus] ([ID], [Title]) VALUES (1, N'готовится')
INSERT [dbo].[CookStatus] ([ID], [Title]) VALUES (2, N'готов')
SET IDENTITY_INSERT [dbo].[CookStatus] OFF
GO
SET IDENTITY_INSERT [dbo].[Dish] ON 

INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (2, N'опомо (opomo)', 15, 487.37)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (3, N'угюбо (ugyubo)', 23, 339.58)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (4, N'ямуде (yamude)', 47, 1575.34)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (5, N'гисек (gisek)', 12, 4096.03)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (6, N'эмоху (emohu)', 52, 354.88)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (7, N'эзего (ezego)', 52, 4014.9)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (8, N'матит (matit)', 34, 1228.15)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (9, N'абуно (abuno)', 15, 2117.14)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (10, N'югупа (yugupa)', 53, 531.66)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (11, N'амулу (amulu)', 25, 903.58)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (12, N'евако (evako)', 36, 3791.92)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (13, N'етомо (etomo)', 41, 2020.12)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (14, N'акоке (akoke)', 44, 4281.29)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (15, N'фанув (fanuv)', 16, 438.02)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (16, N'уселе (usele)', 52, 1695.43)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (17, N'етите (etite)', 41, 4136.45)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (18, N'исуду (isudu)', 24, 887.18)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (19, N'эриди (eridi)', 29, 277.19)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (20, N'анокэ (anoke)', 69, 2411.02)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (21, N'имала (imala)', 21, 1984.64)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (22, N'асуту (asutu)', 25, 1311.71)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (23, N'алище (alische)', 45, 2894.32)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (24, N'гелоп (gelop)', 20, 1351.61)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (25, N'упити (upiti)', 48, 488.64)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (26, N'ореси (oresi)', 20, 2199.24)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (27, N'югика (yugika)', 14, 470.99)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (28, N'ецюру (ecyuru)', 16, 3980.43)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (29, N'океба (okeba)', 14, 612.75)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (30, N'кюгэг (kyugeg)', 28, 1396.56)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (31, N'якиме (yakime)', 23, 4157.87)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (32, N'ухуди (uhudi)', 34, 3321.17)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (33, N'оруко (oruko)', 43, 3272.78)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (34, N'дагим (dagim)', 36, 3925.89)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (35, N'екуци (ekuci)', 39, 1081.71)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (36, N'енугу (enugu)', 41, 383.54)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (37, N'пирин (pirin)', 21, 837.48)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (38, N'омиби (omibi)', 12, 3579.18)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (39, N'адиве (adive)', 19, 1828.48)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (40, N'пюном (pyunom)', 62, 3405.8)
INSERT [dbo].[Dish] ([ID], [Title], [CookTime], [Cost]) VALUES (41, N'улока (uloka)', 47, 3470.7)
SET IDENTITY_INSERT [dbo].[Dish] OFF
GO
INSERT [dbo].[DishOrder] ([OrderID], [DishID], [Count]) VALUES (3, 2, 1)
INSERT [dbo].[DishOrder] ([OrderID], [DishID], [Count]) VALUES (3, 10, 1)
INSERT [dbo].[DishOrder] ([OrderID], [DishID], [Count]) VALUES (4, 3, 4)
INSERT [dbo].[DishOrder] ([OrderID], [DishID], [Count]) VALUES (4, 12, 2)
INSERT [dbo].[DishOrder] ([OrderID], [DishID], [Count]) VALUES (4, 34, 1)
GO
SET IDENTITY_INSERT [dbo].[Emploee] ON 

INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (2, N'Муравьева', N'Екатерина', N'Кирилловна', N'Elley', N'wzFd4v', 1, 2)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (3, N'Матвеева', N'Ева', N'Максимовна', N'Ollay', N'mEwRoQ', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (4, N'Новиков', N'Платон', N'Артёмович', N'Blakery', N'tUwVqf', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (5, N'Виноградова', N'Василиса', N'Тимофеевна', N'Thokie', N'sv62Cu', 2, 1)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (6, N'Сергеев', N'Давид', N'Дмитриевич', N'Edex', N'lZmplZ', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (7, N'Куликов', N'Михаил', N'Николаевич', N'Tomseph', N'nHl8DE', 2, 2)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (8, N'Хромова', N'Ангелина', N'Дмитриевна', N'Louiecha', N'tDx6Is', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (9, N'Федоров', N'Евгений', N'Глебович', N'Bobam', N'Yjqxd3', 1, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (10, N'Абрамова', N'Вероника', N'Сергеевна', N'Ausni', N'wbicYa', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (11, N'Александров', N'Павел', N'Артёмович', N'Blakeot', N'POtncQ', 2, 2)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (12, N'Иванова', N'Анастасия', N'Дмитриевна', N'Oscas', N'zvvDV9', 2, 2)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (13, N'Грачев', N'Александр', N'Кириллович', N'Lukethan', N'WUbbSS', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (14, N'Сомова', N'Ольга', N'Семёновна', N'Bethala', N'SGRI28', 2, 1)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (15, N'Абрамов', N'Павел', N'Миронович', N'Brooketha', N'YdL5dx', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (16, N'Киселев', N'Кирилл', N'Кириллович', N'Avasica', N'mF5pSy', 1, 2)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (17, N'Захаров', N'Марк', N'Ильич', N'Mato', N'bS5D48', 2, 3)
INSERT [dbo].[Emploee] ([ID], [Surname], [Name], [Middlename], [Login], [Password], [StatusID], [PositionID]) VALUES (18, N'Плотникова', N'Анна', N'Марковна', N'Fretha', N'WyhoaP', 2, 3)
SET IDENTITY_INSERT [dbo].[Emploee] OFF
GO
SET IDENTITY_INSERT [dbo].[Order] ON 

INSERT [dbo].[Order] ([ID], [CookSatusID], [PayStatusID], [EmploeeID], [TableNumber], [ClientCount]) VALUES (3, 1, 1, 6, 1, 2)
INSERT [dbo].[Order] ([ID], [CookSatusID], [PayStatusID], [EmploeeID], [TableNumber], [ClientCount]) VALUES (4, 1, 2, 6, 2, 1)
SET IDENTITY_INSERT [dbo].[Order] OFF
GO
SET IDENTITY_INSERT [dbo].[PayStatus] ON 

INSERT [dbo].[PayStatus] ([ID], [Title]) VALUES (1, N'принят')
INSERT [dbo].[PayStatus] ([ID], [Title]) VALUES (2, N'оплачен')
SET IDENTITY_INSERT [dbo].[PayStatus] OFF
GO
SET IDENTITY_INSERT [dbo].[Position] ON 

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

INSERT [dbo].[WorkStatus] ([ID], [Title]) VALUES (1, N'Уволен')
INSERT [dbo].[WorkStatus] ([ID], [Title]) VALUES (2, N'Работает')
SET IDENTITY_INSERT [dbo].[WorkStatus] OFF
GO
ALTER TABLE [dbo].[DishOrder]  WITH CHECK ADD  CONSTRAINT [FK_DishOrder_Dish] FOREIGN KEY([DishID])
REFERENCES [dbo].[Dish] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DishOrder] CHECK CONSTRAINT [FK_DishOrder_Dish]
GO
ALTER TABLE [dbo].[DishOrder]  WITH CHECK ADD  CONSTRAINT [FK_DishOrder_Order] FOREIGN KEY([OrderID])
REFERENCES [dbo].[Order] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DishOrder] CHECK CONSTRAINT [FK_DishOrder_Order]
GO
ALTER TABLE [dbo].[Emploee]  WITH CHECK ADD  CONSTRAINT [FK_Emploee_Position] FOREIGN KEY([PositionID])
REFERENCES [dbo].[Position] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Emploee] CHECK CONSTRAINT [FK_Emploee_Position]
GO
ALTER TABLE [dbo].[Emploee]  WITH CHECK ADD  CONSTRAINT [FK_Emploee_WorkStatus] FOREIGN KEY([StatusID])
REFERENCES [dbo].[WorkStatus] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Emploee] CHECK CONSTRAINT [FK_Emploee_WorkStatus]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_CookStatus] FOREIGN KEY([CookSatusID])
REFERENCES [dbo].[CookStatus] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_CookStatus]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_Emploee] FOREIGN KEY([EmploeeID])
REFERENCES [dbo].[Emploee] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Emploee]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_PayStatus] FOREIGN KEY([PayStatusID])
REFERENCES [dbo].[PayStatus] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_PayStatus]
GO
ALTER TABLE [dbo].[Shift]  WITH CHECK ADD  CONSTRAINT [FK_Shift_Emploee] FOREIGN KEY([EmploeeID])
REFERENCES [dbo].[Emploee] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Shift] CHECK CONSTRAINT [FK_Shift_Emploee]
GO