USE [master]
GO
/****** Object:  Database [Goiman_AA]    Script Date: 26.03.2022 17:27:04 ******/
CREATE DATABASE [Goiman_AA]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Goiman_AA', FILENAME = N'C:\Users\gr691_gaa\Goiman_AA.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Goiman_AA_log', FILENAME = N'C:\Users\gr691_gaa\Goiman_AA_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO
ALTER DATABASE [Goiman_AA] SET COMPATIBILITY_LEVEL = 150
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Goiman_AA].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Goiman_AA] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Goiman_AA] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Goiman_AA] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Goiman_AA] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Goiman_AA] SET ARITHABORT OFF 
GO
ALTER DATABASE [Goiman_AA] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [Goiman_AA] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Goiman_AA] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Goiman_AA] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Goiman_AA] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Goiman_AA] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Goiman_AA] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Goiman_AA] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Goiman_AA] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Goiman_AA] SET  DISABLE_BROKER 
GO
ALTER DATABASE [Goiman_AA] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Goiman_AA] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Goiman_AA] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Goiman_AA] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Goiman_AA] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Goiman_AA] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [Goiman_AA] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [Goiman_AA] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [Goiman_AA] SET  MULTI_USER 
GO
ALTER DATABASE [Goiman_AA] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Goiman_AA] SET DB_CHAINING OFF 
GO
ALTER DATABASE [Goiman_AA] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [Goiman_AA] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [Goiman_AA] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [Goiman_AA] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
ALTER DATABASE [Goiman_AA] SET QUERY_STORE = OFF
GO
USE [Goiman_AA]
GO
/****** Object:  Table [dbo].[Dishes]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dishes](
	[DishesID] [int] IDENTITY(1,1) NOT NULL,
	[DishesName] [nvarchar](50) NOT NULL,
	[Price] [decimal](18, 0) NOT NULL,
	[TimeCook] [int] NOT NULL,
 CONSTRAINT [PK_Dishes] PRIMARY KEY CLUSTERED 
(
	[DishesID] 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].[DishList]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DishList](
	[DishIListID] [int] NOT NULL,
	[OrderIListID] [int] NOT NULL,
	[CountDish] [int] NOT NULL,
 CONSTRAINT [PK_DishList] PRIMARY KEY CLUSTERED 
(
	[DishIListID] ASC,
	[OrderIListID] 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: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Order](
	[OrderID] [int] IDENTITY(1,1) NOT NULL,
	[TableNumber] [int] NOT NULL,
	[CountClient] [int] NOT NULL,
	[OrdDishesid] [int] NOT NULL,
	[StatusOrderid] [int] NOT NULL,
	[Walterid] [int] NOT NULL,
 CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED 
(
	[OrderID] 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].[Post]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Post](
	[PostID] [int] IDENTITY(1,1) NOT NULL,
	[PostName] [nvarchar](64) NOT NULL,
 CONSTRAINT [PK_Post] PRIMARY KEY CLUSTERED 
(
	[PostID] 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].[Shifts]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Shifts](
	[ShiftsID] [int] IDENTITY(1,1) NOT NULL,
	[DateShifts] [date] NOT NULL,
 CONSTRAINT [PK_Shifts] PRIMARY KEY CLUSTERED 
(
	[ShiftsID] 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].[ShiftUser]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ShiftUser](
	[ShiftUserID] [int] IDENTITY(1,1) NOT NULL,
	[Userid] [int] NOT NULL,
	[Shiftid] [int] NOT NULL,
 CONSTRAINT [PK_ShiftUser] PRIMARY KEY CLUSTERED 
(
	[ShiftUserID] 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].[StatusOrder]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StatusOrder](
	[StatusOrderID] [int] NOT NULL,
	[StatusOrderName] [nvarchar](64) NOT NULL,
 CONSTRAINT [PK_StatusOrder] PRIMARY KEY CLUSTERED 
(
	[StatusOrderID] 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].[StatusWork]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StatusWork](
	[StatusWorkID] [int] IDENTITY(1,1) NOT NULL,
	[StatusWorkName] [nvarchar](64) NOT NULL,
 CONSTRAINT [PK_StatusWork] PRIMARY KEY CLUSTERED 
(
	[StatusWorkID] 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].[User]    Script Date: 26.03.2022 17:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[Login] [nvarchar](64) NOT NULL,
	[SurName] [nvarchar](64) NOT NULL,
	[FirstName] [nvarchar](64) NOT NULL,
	[MiddleName] [nvarchar](64) NULL,
	[Postid] [int] NOT NULL,
	[Password] [nvarchar](64) NOT NULL,
	[StatusUserid] [int] NOT NULL,
 CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED 
(
	[UserID] 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
ALTER TABLE [dbo].[DishList]  WITH CHECK ADD  CONSTRAINT [FK_DishList_Dishes] FOREIGN KEY([DishIListID])
REFERENCES [dbo].[Dishes] ([DishesID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DishList] CHECK CONSTRAINT [FK_DishList_Dishes]
GO
ALTER TABLE [dbo].[DishList]  WITH CHECK ADD  CONSTRAINT [FK_DishList_Order] FOREIGN KEY([OrderIListID])
REFERENCES [dbo].[Order] ([OrderID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DishList] CHECK CONSTRAINT [FK_DishList_Order]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_StatusOrder] FOREIGN KEY([StatusOrderid])
REFERENCES [dbo].[StatusOrder] ([StatusOrderID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_StatusOrder]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_User] FOREIGN KEY([Walterid])
REFERENCES [dbo].[User] ([UserID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_User]
GO
ALTER TABLE [dbo].[ShiftUser]  WITH CHECK ADD  CONSTRAINT [FK_ShiftUser_Shifts] FOREIGN KEY([Shiftid])
REFERENCES [dbo].[Shifts] ([ShiftsID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ShiftUser] CHECK CONSTRAINT [FK_ShiftUser_Shifts]
GO
ALTER TABLE [dbo].[ShiftUser]  WITH CHECK ADD  CONSTRAINT [FK_ShiftUser_User] FOREIGN KEY([Userid])
REFERENCES [dbo].[User] ([UserID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ShiftUser] CHECK CONSTRAINT [FK_ShiftUser_User]
GO
ALTER TABLE [dbo].[User]  WITH CHECK ADD  CONSTRAINT [FK_User_Post] FOREIGN KEY([Postid])
REFERENCES [dbo].[Post] ([PostID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_User_Post]
GO
ALTER TABLE [dbo].[User]  WITH CHECK ADD  CONSTRAINT [FK_User_StatusWork] FOREIGN KEY([StatusUserid])
REFERENCES [dbo].[StatusWork] ([StatusWorkID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[User] CHECK CONSTRAINT [FK_User_StatusWork]
GO
USE [master]
GO
ALTER DATABASE [Goiman_AA] SET  READ_WRITE 
GO