ViktorLychkatyi · February 13, 2025 23:28
diff --git a/Store.sql b/Store.sql
 USE [master]
 GO
 /****** Object:  Database [Store]    Script Date: 14.02.2025 00:27:13 ******/
 CREATE DATABASE [Store]
 CONTAINMENT = NONE
 ON  PRIMARY 
 ( NAME = N'Store', FILENAME = N'C:\MyStore\Store.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
 ( NAME = N'Store_log', FILENAME = N'C:\MyStore\Store_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
 GO
 ALTER DATABASE [Store] SET COMPATIBILITY_LEVEL = 100
 GO
 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
 begin
 EXEC [Store].[dbo].[sp_fulltext_database] @action = 'enable'
 end
 GO
 ALTER DATABASE [Store] SET ANSI_NULL_DEFAULT OFF 
 GO
 ALTER DATABASE [Store] SET ANSI_NULLS OFF 
 GO
 ALTER DATABASE [Store] SET ANSI_PADDING OFF 
 GO
 ALTER DATABASE [Store] SET ANSI_WARNINGS OFF 
 GO
 ALTER DATABASE [Store] SET ARITHABORT OFF 
 GO
 ALTER DATABASE [Store] SET AUTO_CLOSE OFF 
 GO
 ALTER DATABASE [Store] SET AUTO_SHRINK OFF 
 GO
 ALTER DATABASE [Store] SET AUTO_UPDATE_STATISTICS ON 
 GO
 ALTER DATABASE [Store] SET CURSOR_CLOSE_ON_COMMIT OFF 
 GO
 ALTER DATABASE [Store] SET CURSOR_DEFAULT  GLOBAL 
 GO
 ALTER DATABASE [Store] SET CONCAT_NULL_YIELDS_NULL OFF 
 GO
 ALTER DATABASE [Store] SET NUMERIC_ROUNDABORT OFF 
 GO
 ALTER DATABASE [Store] SET QUOTED_IDENTIFIER OFF 
 GO
 ALTER DATABASE [Store] SET RECURSIVE_TRIGGERS OFF 
 GO
 ALTER DATABASE [Store] SET  DISABLE_BROKER 
 GO
 ALTER DATABASE [Store] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
 GO
 ALTER DATABASE [Store] SET DATE_CORRELATION_OPTIMIZATION OFF 
 GO
 ALTER DATABASE [Store] SET TRUSTWORTHY OFF 
 GO
 ALTER DATABASE [Store] SET ALLOW_SNAPSHOT_ISOLATION OFF 
 GO
 ALTER DATABASE [Store] SET PARAMETERIZATION SIMPLE 
 GO
 ALTER DATABASE [Store] SET READ_COMMITTED_SNAPSHOT OFF 
 GO
 ALTER DATABASE [Store] SET HONOR_BROKER_PRIORITY OFF 
 GO
 ALTER DATABASE [Store] SET RECOVERY FULL 
 GO
 ALTER DATABASE [Store] SET  MULTI_USER 
 GO
 ALTER DATABASE [Store] SET PAGE_VERIFY CHECKSUM  
 GO
 ALTER DATABASE [Store] SET DB_CHAINING OFF 
 GO
 ALTER DATABASE [Store] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
 GO
 ALTER DATABASE [Store] SET TARGET_RECOVERY_TIME = 60 SECONDS 
 GO
 ALTER DATABASE [Store] SET DELAYED_DURABILITY = DISABLED 
 GO
 ALTER DATABASE [Store] SET ACCELERATED_DATABASE_RECOVERY = OFF  
 GO
 EXEC sys.sp_db_vardecimal_storage_format N'Store', N'ON'
 GO
 ALTER DATABASE [Store] SET QUERY_STORE = ON
 GO
 ALTER DATABASE [Store] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
 GO
 USE [Store]
 GO
 /****** Object:  Table [dbo].[CopyProduct]    Script Date: 14.02.2025 00:27:13 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE TABLE [dbo].[CopyProduct](
 	[id] [int] IDENTITY(1,1) NOT NULL,
 	[name] [nvarchar](200) NOT NULL,
 	[category] [nvarchar](50) NULL,
 	[price] [money] NULL,
 	[discount] [money] NULL,
 	[quantity] [money] NULL,
 	[measurement] [nvarchar](10) NULL,
 	[producer] [nvarchar](50) NULL,
 	[country] [nvarchar](30) NULL,
 	[supplier] [nvarchar](50) NULL,
 	[date_of_delivery] [date] NULL,
 	[expire_date] [date] NULL
 ) ON [PRIMARY]
 GO
 /****** Object:  Table [dbo].[Product]    Script Date: 14.02.2025 00:27:13 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE TABLE [dbo].[Product](
 	[id] [int] IDENTITY(1,1) NOT NULL,
 	[name] [nvarchar](200) NOT NULL,
 	[category] [nvarchar](50) NULL,
 	[price] [money] NULL,
 	[discount] [money] NULL,
 	[quantity] [money] NULL,
 	[measurement] [nvarchar](10) NULL,
 	[producer] [nvarchar](50) NULL,
 	[country] [nvarchar](30) NULL,
 	[supplier] [nvarchar](50) NULL,
 	[date_of_delivery] [date] NULL,
 	[expire_date] [date] NULL,
 CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED 
 (
 	[id] ASC
 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
 ) ON [PRIMARY]
 GO
 SET IDENTITY_INSERT [dbo].[CopyProduct] ON 

 INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (2, N'Хлеб', N'Выпечка', 30.0081, 0.0000, 200.0000, N'шт.', N'Bimbo', N'Мексика', N'Global Bakery', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-20' AS Date))
 INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (3, N'Картофель', N'Овощи', 38.5819, 3.0000, 1500.0000, N'кг.', N'Fresca', N'Нидерланды', N'Green Fields', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-28' AS Date))
 INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (6, N'Гречка', N'Крупы', 51.4425, 0.0000, 500.0000, N'упаковок', N'Alpenland', N'Австрия', N'Grain Masters', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-10' AS Date))
 INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (8, N'Макароны', N'Продукты питания', 30.0081, 0.0000, 300.0000, N'упаковок	', N'Barilla', N'Италия', N'Pasta & Sauce', CAST(N'2025-02-13' AS Date), CAST(N'2025-08-01' AS Date))
 INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (12, N'Сахар белый', N'Продукты питания', 51.4425, 0.0000, 500.0000, N'упаковок', N'Südzucker', N'Германия', N'Sweet Supply', CAST(N'2025-02-12' AS Date), CAST(N'2025-11-28' AS Date))
 SET IDENTITY_INSERT [dbo].[CopyProduct] OFF
 GO
 SET IDENTITY_INSERT [dbo].[Product] ON 

 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (1, N'Кефир', N'	Молочные продукты', 50.0000, 5.0000, 100.0000, N'шт.', N'Lactalis', N'Франция', N'Dairy World', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-01' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (2, N'Хлеб', N'Выпечка', 35.0000, 0.0000, 200.0000, N'шт.', N'Bimbo', N'Мексика', N'Global Bakery', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-20' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (3, N'Картофель', N'Овощи', 45.0000, 3.0000, 1500.0000, N'кг.', N'Fresca', N'Нидерланды', N'Green Fields', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-28' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (4, N'Апельсины', N'Фрукты', 120.0000, 5.0000, 1000.0000, N'кг.', N'Valencia Fruits', N'Испания', N'Citrus Imports', CAST(N'2025-02-13' AS Date), CAST(N'2025-06-01' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (5, N'Молоко', N'Молочные продукты', 55.0000, 7.0000, 200.0000, N'шт.', N'Arla', N'Дания', N'Nordic Dairy', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-15' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (6, N'Гречка', N'Крупы', 60.0000, 0.0000, 500.0000, N'упаковок', N'Alpenland', N'Австрия', N'Grain Masters', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-10' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (7, N'Чай черный', N'Безалкогольные напитки', 150.0000, 5.0000, 250.0000, N'пачек', N'Twinings', N'Великобритания', N'Tea Lovers', CAST(N'2025-02-13' AS Date), CAST(N'2025-05-28' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (8, N'Макароны', N'Продукты питания', 35.0000, 0.0000, 300.0000, N'упаковок	', N'Barilla', N'Италия', N'Pasta & Sauce', CAST(N'2025-02-12' AS Date), CAST(N'2025-08-01' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (9, N'Сок яблочный', N'Безалкогольные напитки', 80.0000, 6.0000, 200.0000, N'шт.', N'Innocent', N'Великобритания', N'Pure Juices', CAST(N'2025-02-12' AS Date), CAST(N'2026-03-05' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (10, N'Кофе молотый', N'Безалкогольные напитки', 300.0000, 10.0000, 150.0000, N'упаковок', N'Illy', N'Италия', N'Caffe World', CAST(N'2025-02-12' AS Date), CAST(N'2025-12-22' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (11, N'Сыр гауда', N'Молочные продукты', 400.0000, 5.0000, 120.0000, N'шт.', N'FrieslandCampina', N'Нидерланды', N'Cheese Export', CAST(N'2025-02-12' AS Date), CAST(N'2025-04-01' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (12, N'Сахар белый', N'Продукты питания', 60.0000, 0.0000, 500.0000, N'упаковок', N'Südzucker', N'Германия', N'Sweet Supply', CAST(N'2025-02-12' AS Date), CAST(N'2025-11-28' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (13, N'Оливковое масло', N'Масла', 250.0000, 10.0000, 200.0000, N'бутылок', N'Gaea', N'Греция', N'Mediterranean Goods', CAST(N'2025-02-12' AS Date), CAST(N'2025-04-15' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (14, N'Лосось слабосоленый', N'Рыба и морепродукты', 800.0000, 8.0000, 50.0000, N'упаковок', N'Norwegian Salmon', N'Норвегия', N'Seafood World', CAST(N'2025-02-07' AS Date), CAST(N'2025-05-07' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (15, N'Шоколад молочный', N'Кондитерские изделия', 150.0000, 10.0000, 100.0000, N'шт.', N'Roshen', N'Украина', N'Swiss Delights', CAST(N'2025-02-07' AS Date), CAST(N'2025-07-01' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (16, N'Печенье с шоколадом', N'Кондитерские изделия', 90.0000, 5.0000, 200.0000, N'упаковок', N'Roshen', N'Украина', N'Sweet Treats', CAST(N'2025-03-10' AS Date), CAST(N'2025-06-01' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (17, N'Торт "Наполеон"', N'Кондитерские изделия', 500.0000, 0.0000, 30.0000, N'шт.', N'Roshen', N'Украина', N'Pastry World', CAST(N'2025-03-10' AS Date), CAST(N'2025-03-20' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (18, N'Конфеты ассорти', N'Кондитерские изделия', 200.0000, 12.0000, 150.0000, N'коробок', N'Ferrero', N'Италия', N'Candy Paradise', CAST(N'2025-03-05' AS Date), CAST(N'2025-07-05' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (19, N'Кекс с изюмом', N'Кондитерские изделия', 120.0000, 0.0000, 80.0000, N'шт.', N'Dr. Oetker', N'Германия', N'Baked Goods', CAST(N'2025-03-12' AS Date), CAST(N'2025-05-12' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (20, N'Виски Jameson', N'Алкоголь', 2500.0000, 10.0000, 120.0000, N'бутылок', N'Jameson', N'Ирландия', N'Whiskey House', CAST(N'2025-03-10' AS Date), CAST(N'2026-03-10' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (21, N'Красное вино Cabernet', N'Алкоголь', 1800.0000, 7.0000, 150.0000, N'бутылок', N'Château Margaux', N'Франция', N'Wine Market', CAST(N'2025-03-05' AS Date), CAST(N'2025-07-05' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (22, N'Коньяк Hennessy XO', N'Алкоголь', 4500.0000, 5.0000, 90.0000, N'бутылок', N'Hennessy', N'Франция', N'Luxury Spirits', CAST(N'2025-03-12' AS Date), CAST(N'2025-04-12' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (23, N'Пиво Heineken', N'Алкоголь', 150.0000, 8.0000, 300.0000, N'бутылок', N'Heineken', N'Нидерланды', N'Beer Supply', CAST(N'2025-03-08' AS Date), CAST(N'2025-07-08' AS Date))
 INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (24, N'Текила Olmeca Blanco', N'Алкоголь', 2200.0000, 6.0000, 110.0000, N'бутылок', N'Olmeca', N'Мексика', N'Tequila Trade', CAST(N'2025-03-03' AS Date), CAST(N'2026-03-03' AS Date))
 SET IDENTITY_INSERT [dbo].[Product] OFF
 GO
 USE [master]
 GO
 ALTER DATABASE [Store] SET  READ_WRITE 
 GO
	USE [master]
	GO
	/**** Object: Database [Store] Script Date: 14.02.2025 00:27:13 ****/
	CREATE DATABASE [Store]
	CONTAINMENT = NONE
	ON PRIMARY
	( NAME = N'Store', FILENAME = N'C:\MyStore\Store.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
	LOG ON
	( NAME = N'Store_log', FILENAME = N'C:\MyStore\Store_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
	WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
	GO
	ALTER DATABASE [Store] SET COMPATIBILITY_LEVEL = 100
	GO
	IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
	begin
	EXEC [Store].[dbo].[sp_fulltext_database] @action = 'enable'
	end
	GO
	ALTER DATABASE [Store] SET ANSI_NULL_DEFAULT OFF
	GO
	ALTER DATABASE [Store] SET ANSI_NULLS OFF
	GO
	ALTER DATABASE [Store] SET ANSI_PADDING OFF
	GO
	ALTER DATABASE [Store] SET ANSI_WARNINGS OFF
	GO
	ALTER DATABASE [Store] SET ARITHABORT OFF
	GO
	ALTER DATABASE [Store] SET AUTO_CLOSE OFF
	GO
	ALTER DATABASE [Store] SET AUTO_SHRINK OFF
	GO
	ALTER DATABASE [Store] SET AUTO_UPDATE_STATISTICS ON
	GO
	ALTER DATABASE [Store] SET CURSOR_CLOSE_ON_COMMIT OFF
	GO
	ALTER DATABASE [Store] SET CURSOR_DEFAULT GLOBAL
	GO
	ALTER DATABASE [Store] SET CONCAT_NULL_YIELDS_NULL OFF
	GO
	ALTER DATABASE [Store] SET NUMERIC_ROUNDABORT OFF
	GO
	ALTER DATABASE [Store] SET QUOTED_IDENTIFIER OFF
	GO
	ALTER DATABASE [Store] SET RECURSIVE_TRIGGERS OFF
	GO
	ALTER DATABASE [Store] SET DISABLE_BROKER
	GO
	ALTER DATABASE [Store] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
	GO
	ALTER DATABASE [Store] SET DATE_CORRELATION_OPTIMIZATION OFF
	GO
	ALTER DATABASE [Store] SET TRUSTWORTHY OFF
	GO
	ALTER DATABASE [Store] SET ALLOW_SNAPSHOT_ISOLATION OFF
	GO
	ALTER DATABASE [Store] SET PARAMETERIZATION SIMPLE
	GO
	ALTER DATABASE [Store] SET READ_COMMITTED_SNAPSHOT OFF
	GO
	ALTER DATABASE [Store] SET HONOR_BROKER_PRIORITY OFF
	GO
	ALTER DATABASE [Store] SET RECOVERY FULL
	GO
	ALTER DATABASE [Store] SET MULTI_USER
	GO
	ALTER DATABASE [Store] SET PAGE_VERIFY CHECKSUM
	GO
	ALTER DATABASE [Store] SET DB_CHAINING OFF
	GO
	ALTER DATABASE [Store] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
	GO
	ALTER DATABASE [Store] SET TARGET_RECOVERY_TIME = 60 SECONDS
	GO
	ALTER DATABASE [Store] SET DELAYED_DURABILITY = DISABLED
	GO
	ALTER DATABASE [Store] SET ACCELERATED_DATABASE_RECOVERY = OFF
	GO
	EXEC sys.sp_db_vardecimal_storage_format N'Store', N'ON'
	GO
	ALTER DATABASE [Store] SET QUERY_STORE = ON
	GO
	ALTER DATABASE [Store] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
	GO
	USE [Store]
	GO
	/**** Object: Table [dbo].[CopyProduct] Script Date: 14.02.2025 00:27:13 ****/
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	CREATE TABLE [dbo].[CopyProduct](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](200) NOT NULL,
	[category] [nvarchar](50) NULL,
	[price] [money] NULL,
	[discount] [money] NULL,
	[quantity] [money] NULL,
	[measurement] [nvarchar](10) NULL,
	[producer] [nvarchar](50) NULL,
	[country] [nvarchar](30) NULL,
	[supplier] [nvarchar](50) NULL,
	[date_of_delivery] [date] NULL,
	[expire_date] [date] NULL
	) ON [PRIMARY]
	GO
	/**** Object: Table [dbo].[Product] Script Date: 14.02.2025 00:27:13 ****/
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	CREATE TABLE [dbo].[Product](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](200) NOT NULL,
	[category] [nvarchar](50) NULL,
	[price] [money] NULL,
	[discount] [money] NULL,
	[quantity] [money] NULL,
	[measurement] [nvarchar](10) NULL,
	[producer] [nvarchar](50) NULL,
	[country] [nvarchar](30) NULL,
	[supplier] [nvarchar](50) NULL,
	[date_of_delivery] [date] NULL,
	[expire_date] [date] NULL,
	CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED
	(
	[id] ASC
	)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
	) ON [PRIMARY]
	GO
	SET IDENTITY_INSERT [dbo].[CopyProduct] ON

	INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (2, N'Хлеб', N'Выпечка', 30.0081, 0.0000, 200.0000, N'шт.', N'Bimbo', N'Мексика', N'Global Bakery', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-20' AS Date))
	INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (3, N'Картофель', N'Овощи', 38.5819, 3.0000, 1500.0000, N'кг.', N'Fresca', N'Нидерланды', N'Green Fields', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-28' AS Date))
	INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (6, N'Гречка', N'Крупы', 51.4425, 0.0000, 500.0000, N'упаковок', N'Alpenland', N'Австрия', N'Grain Masters', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-10' AS Date))
	INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (8, N'Макароны', N'Продукты питания', 30.0081, 0.0000, 300.0000, N'упаковок ', N'Barilla', N'Италия', N'Pasta & Sauce', CAST(N'2025-02-13' AS Date), CAST(N'2025-08-01' AS Date))
	INSERT [dbo].[CopyProduct] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (12, N'Сахар белый', N'Продукты питания', 51.4425, 0.0000, 500.0000, N'упаковок', N'Südzucker', N'Германия', N'Sweet Supply', CAST(N'2025-02-12' AS Date), CAST(N'2025-11-28' AS Date))
	SET IDENTITY_INSERT [dbo].[CopyProduct] OFF
	GO
	SET IDENTITY_INSERT [dbo].[Product] ON

	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (1, N'Кефир', N' Молочные продукты', 50.0000, 5.0000, 100.0000, N'шт.', N'Lactalis', N'Франция', N'Dairy World', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-01' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (2, N'Хлеб', N'Выпечка', 35.0000, 0.0000, 200.0000, N'шт.', N'Bimbo', N'Мексика', N'Global Bakery', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-20' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (3, N'Картофель', N'Овощи', 45.0000, 3.0000, 1500.0000, N'кг.', N'Fresca', N'Нидерланды', N'Green Fields', CAST(N'2025-02-13' AS Date), CAST(N'2025-03-28' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (4, N'Апельсины', N'Фрукты', 120.0000, 5.0000, 1000.0000, N'кг.', N'Valencia Fruits', N'Испания', N'Citrus Imports', CAST(N'2025-02-13' AS Date), CAST(N'2025-06-01' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (5, N'Молоко', N'Молочные продукты', 55.0000, 7.0000, 200.0000, N'шт.', N'Arla', N'Дания', N'Nordic Dairy', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-15' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (6, N'Гречка', N'Крупы', 60.0000, 0.0000, 500.0000, N'упаковок', N'Alpenland', N'Австрия', N'Grain Masters', CAST(N'2025-02-13' AS Date), CAST(N'2025-04-10' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (7, N'Чай черный', N'Безалкогольные напитки', 150.0000, 5.0000, 250.0000, N'пачек', N'Twinings', N'Великобритания', N'Tea Lovers', CAST(N'2025-02-13' AS Date), CAST(N'2025-05-28' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (8, N'Макароны', N'Продукты питания', 35.0000, 0.0000, 300.0000, N'упаковок ', N'Barilla', N'Италия', N'Pasta & Sauce', CAST(N'2025-02-12' AS Date), CAST(N'2025-08-01' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (9, N'Сок яблочный', N'Безалкогольные напитки', 80.0000, 6.0000, 200.0000, N'шт.', N'Innocent', N'Великобритания', N'Pure Juices', CAST(N'2025-02-12' AS Date), CAST(N'2026-03-05' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (10, N'Кофе молотый', N'Безалкогольные напитки', 300.0000, 10.0000, 150.0000, N'упаковок', N'Illy', N'Италия', N'Caffe World', CAST(N'2025-02-12' AS Date), CAST(N'2025-12-22' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (11, N'Сыр гауда', N'Молочные продукты', 400.0000, 5.0000, 120.0000, N'шт.', N'FrieslandCampina', N'Нидерланды', N'Cheese Export', CAST(N'2025-02-12' AS Date), CAST(N'2025-04-01' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (12, N'Сахар белый', N'Продукты питания', 60.0000, 0.0000, 500.0000, N'упаковок', N'Südzucker', N'Германия', N'Sweet Supply', CAST(N'2025-02-12' AS Date), CAST(N'2025-11-28' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (13, N'Оливковое масло', N'Масла', 250.0000, 10.0000, 200.0000, N'бутылок', N'Gaea', N'Греция', N'Mediterranean Goods', CAST(N'2025-02-12' AS Date), CAST(N'2025-04-15' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (14, N'Лосось слабосоленый', N'Рыба и морепродукты', 800.0000, 8.0000, 50.0000, N'упаковок', N'Norwegian Salmon', N'Норвегия', N'Seafood World', CAST(N'2025-02-07' AS Date), CAST(N'2025-05-07' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (15, N'Шоколад молочный', N'Кондитерские изделия', 150.0000, 10.0000, 100.0000, N'шт.', N'Roshen', N'Украина', N'Swiss Delights', CAST(N'2025-02-07' AS Date), CAST(N'2025-07-01' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (16, N'Печенье с шоколадом', N'Кондитерские изделия', 90.0000, 5.0000, 200.0000, N'упаковок', N'Roshen', N'Украина', N'Sweet Treats', CAST(N'2025-03-10' AS Date), CAST(N'2025-06-01' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (17, N'Торт "Наполеон"', N'Кондитерские изделия', 500.0000, 0.0000, 30.0000, N'шт.', N'Roshen', N'Украина', N'Pastry World', CAST(N'2025-03-10' AS Date), CAST(N'2025-03-20' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (18, N'Конфеты ассорти', N'Кондитерские изделия', 200.0000, 12.0000, 150.0000, N'коробок', N'Ferrero', N'Италия', N'Candy Paradise', CAST(N'2025-03-05' AS Date), CAST(N'2025-07-05' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (19, N'Кекс с изюмом', N'Кондитерские изделия', 120.0000, 0.0000, 80.0000, N'шт.', N'Dr. Oetker', N'Германия', N'Baked Goods', CAST(N'2025-03-12' AS Date), CAST(N'2025-05-12' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (20, N'Виски Jameson', N'Алкоголь', 2500.0000, 10.0000, 120.0000, N'бутылок', N'Jameson', N'Ирландия', N'Whiskey House', CAST(N'2025-03-10' AS Date), CAST(N'2026-03-10' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (21, N'Красное вино Cabernet', N'Алкоголь', 1800.0000, 7.0000, 150.0000, N'бутылок', N'Château Margaux', N'Франция', N'Wine Market', CAST(N'2025-03-05' AS Date), CAST(N'2025-07-05' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (22, N'Коньяк Hennessy XO', N'Алкоголь', 4500.0000, 5.0000, 90.0000, N'бутылок', N'Hennessy', N'Франция', N'Luxury Spirits', CAST(N'2025-03-12' AS Date), CAST(N'2025-04-12' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (23, N'Пиво Heineken', N'Алкоголь', 150.0000, 8.0000, 300.0000, N'бутылок', N'Heineken', N'Нидерланды', N'Beer Supply', CAST(N'2025-03-08' AS Date), CAST(N'2025-07-08' AS Date))
	INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (24, N'Текила Olmeca Blanco', N'Алкоголь', 2200.0000, 6.0000, 110.0000, N'бутылок', N'Olmeca', N'Мексика', N'Tequila Trade', CAST(N'2025-03-03' AS Date), CAST(N'2026-03-03' AS Date))
	SET IDENTITY_INSERT [dbo].[Product] OFF
	GO
	USE [master]
	GO
	ALTER DATABASE [Store] SET READ_WRITE
	GO