SQLDataDriver/seed_from_import_ready.sql - main - DataTimeModule/DateTime

SQLDataDriver/seed_from_import_ready.sql
190 строк22 KB
Reeltell
upload
27 май 2026, 01:50
27 май 2026, 01:50f282598
-- Seed data from import_ready.xlsx
-- Generated: 2026-05-23 23:19:54
-- Assumes database SQLDataDriver and tables already exist.

USE SQLDataDriver;
GO

SET NOCOUNT ON;
SET XACT_ABORT ON;
GO

BEGIN TRAN;

-- Optional cleanup (uncomment if you want to wipe existing rows)
-- DELETE FROM dbo.OrderProducts;
-- DELETE FROM dbo.Orders;
-- DELETE FROM dbo.Users;
-- DELETE FROM dbo.Products;
-- DELETE FROM dbo.OrderStatuses;
-- DELETE FROM dbo.PickupPoints;
-- DELETE FROM dbo.Units;
-- DELETE FROM dbo.ProductCategories;
-- DELETE FROM dbo.Manufacturers;
-- DELETE FROM dbo.Providers;
-- DELETE FROM dbo.Roles;

-- Roles
SET IDENTITY_INSERT dbo.Roles ON;
INSERT INTO dbo.Roles(RoleId, Title) VALUES(1, N'Администратор');
INSERT INTO dbo.Roles(RoleId, Title) VALUES(2, N'Менеджер');
INSERT INTO dbo.Roles(RoleId, Title) VALUES(3, N'Авторизированный клиент');
SET IDENTITY_INSERT dbo.Roles OFF;

-- Providers
SET IDENTITY_INSERT dbo.Providers ON;
INSERT INTO dbo.Providers(ProviderId, Title) VALUES(1, N'Kari');
INSERT INTO dbo.Providers(ProviderId, Title) VALUES(2, N'Обувь для вас');
SET IDENTITY_INSERT dbo.Providers OFF;

-- Manufacturers
SET IDENTITY_INSERT dbo.Manufacturers ON;
INSERT INTO dbo.Manufacturers(ManufacturerId, Title) VALUES(1, N'Kari');
INSERT INTO dbo.Manufacturers(ManufacturerId, Title) VALUES(2, N'Marco Tozzi');
INSERT INTO dbo.Manufacturers(ManufacturerId, Title) VALUES(3, N'Рос');
INSERT INTO dbo.Manufacturers(ManufacturerId, Title) VALUES(4, N'Rieker');
INSERT INTO dbo.Manufacturers(ManufacturerId, Title) VALUES(5, N'Alessio Nesca');
INSERT INTO dbo.Manufacturers(ManufacturerId, Title) VALUES(6, N'CROSBY');
SET IDENTITY_INSERT dbo.Manufacturers OFF;

-- ProductCategories
SET IDENTITY_INSERT dbo.ProductCategories ON;
INSERT INTO dbo.ProductCategories(ProductCategoryId, Title) VALUES(1, N'Женская обувь');
INSERT INTO dbo.ProductCategories(ProductCategoryId, Title) VALUES(2, N'Мужская обувь');
SET IDENTITY_INSERT dbo.ProductCategories OFF;

-- Units
SET IDENTITY_INSERT dbo.Units ON;
INSERT INTO dbo.Units(UnitId, Title) VALUES(1, N'шт.');
SET IDENTITY_INSERT dbo.Units OFF;

-- PickupPoints
SET IDENTITY_INSERT dbo.PickupPoints ON;
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(1, N'420151', N'420151, г. Лесной, ул. Вишневая, 32');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(2, N'125061', N'125061, г. Лесной, ул. Подгорная, 8');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(3, N'630370', N'630370, г. Лесной, ул. Шоссейная, 24');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(4, N'400562', N'400562, г. Лесной, ул. Зеленая, 32');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(5, N'614510', N'614510, г. Лесной, ул. Маяковского, 47');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(6, N'410542', N'410542, г. Лесной, ул. Светлая, 46');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(7, N'620839', N'620839, г. Лесной, ул. Цветочная, 8');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(8, N'443890', N'443890, г. Лесной, ул. Коммунистическая, 1');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(9, N'603379', N'603379, г. Лесной, ул. Спортивная, 46');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(10, N'603721', N'603721, г. Лесной, ул. Гоголя, 41');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(11, N'410172', N'410172, г. Лесной, ул. Северная, 13');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(12, N'614611', N'614611, г. Лесной, ул. Молодежная, 50');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(13, N'454311', N'454311, г.Лесной, ул. Новая, 19');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(14, N'660007', N'660007, г.Лесной, ул. Октябрьская, 19');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(15, N'603036', N'603036, г. Лесной, ул. Садовая, 4');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(16, N'394060', N'394060, г.Лесной, ул. Фрунзе, 43');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(17, N'410661', N'410661, г. Лесной, ул. Школьная, 50');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(18, N'625590', N'625590, г. Лесной, ул. Коммунистическая, 20');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(19, N'625683', N'625683, г. Лесной, ул. 8 Марта');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(20, N'450983', N'450983, г.Лесной, ул. Комсомольская, 26');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(21, N'394782', N'394782, г. Лесной, ул. Чехова, 3');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(22, N'603002', N'603002, г. Лесной, ул. Дзержинского, 28');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(23, N'450558', N'450558, г. Лесной, ул. Набережная, 30');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(24, N'344288', N'344288, г. Лесной, ул. Чехова, 1');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(25, N'614164', N'614164, г.Лесной,  ул. Степная, 30');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(26, N'394242', N'394242, г. Лесной, ул. Коммунистическая, 43');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(27, N'660540', N'660540, г. Лесной, ул. Солнечная, 25');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(28, N'125837', N'125837, г. Лесной, ул. Шоссейная, 40');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(29, N'125703', N'125703, г. Лесной, ул. Партизанская, 49');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(30, N'625283', N'625283, г. Лесной, ул. Победы, 46');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(31, N'614753', N'614753, г. Лесной, ул. Полевая, 35');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(32, N'426030', N'426030, г. Лесной, ул. Маяковского, 44');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(33, N'450375', N'450375, г. Лесной ул. Клубная, 44');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(34, N'625560', N'625560, г. Лесной, ул. Некрасова, 12');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(35, N'630201', N'630201, г. Лесной, ул. Комсомольская, 17');
INSERT INTO dbo.PickupPoints(PickupPointId, [Index], Address) VALUES(36, N'190949', N'190949, г. Лесной, ул. Мичурина, 26');
SET IDENTITY_INSERT dbo.PickupPoints OFF;

-- OrderStatuses
SET IDENTITY_INSERT dbo.OrderStatuses ON;
INSERT INTO dbo.OrderStatuses(OrderStatusId, Title) VALUES(1, N'Завершен');
INSERT INTO dbo.OrderStatuses(OrderStatusId, Title) VALUES(2, N'Новый');
SET IDENTITY_INSERT dbo.OrderStatuses OFF;

-- Users
SET IDENTITY_INSERT dbo.Users ON;
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(1, 1, N'Никифорова', N'Весения', N'Николаевна', N'94d5ous@gmail.com', N'uzWC67');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(2, 1, N'Сазонов', N'Руслан', N'Германович', N'uth4iz@mail.com', N'2L6KZG');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(3, 1, N'Одинцов', N'Серафим', N'Артёмович', N'yzls62@outlook.com', N'JlFRCZ');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(4, 2, N'Степанов', N'Михаил', N'Артёмович', N'1diph5e@tutanota.com', N'8ntwUp');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(5, 2, N'Ворсин', N'Петр', N'Евгеньевич', N'tjde7c@yahoo.com', N'YOyhfR');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(6, 2, N'Старикова', N'Елена', N'Павловна', N'wpmrc3do@tutanota.com', N'RSbvHv');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(7, 3, N'Михайлюк', N'Анна', N'Вячеславовна', N'5d4zbu@tutanota.com', N'rwVDh9');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(8, 3, N'Ситдикова', N'Елена', N'Анатольевна', N'ptec8ym@yahoo.com', N'LdNyos');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(9, 3, N'Ворсин', N'Петр', N'Евгеньевич', N'1qz4kw@mail.com', N'gynQMT');
INSERT INTO dbo.Users(UserId, RoleId, Surname, Name, Patronymic, Login, Password) VALUES(10, 3, N'Старикова', N'Елена', N'Павловна', N'4np6se@mail.com', N'AtnDjr');
SET IDENTITY_INSERT dbo.Users OFF;

-- Products
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'А112Т4', N'Ботинки', 1, 4990, 1, 1, 1, 3, 6, N'Женские Ботинки демисезонные kari', N'1.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'F635R4', N'Ботинки', 1, 3244, 2, 2, 1, 2, 13, N'Ботинки Marco Tozzi женские демисезонные, размер 39, цвет бежевый', N'2.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'H782T5', N'Туфли', 1, 4499, 1, 1, 2, 4, 5, N'Туфли kari мужские классика MYZ21AW-450A, размер 43, цвет: черный', N'3.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'G783F5', N'Ботинки', 1, 5900, 1, 3, 2, 2, 8, N'Мужские ботинки Рос-Обувь кожаные с натуральным мехом', N'4.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'J384T6', N'Ботинки', 1, 3800, 2, 4, 2, 2, 16, N'B3430/14 Полуботинки мужские Rieker', N'5.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'D572U8', N'Кроссовки', 1, 4100, 2, 3, 2, 3, 6, N'129615-4 Кроссовки мужские', N'6.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'F572H7', N'Туфли', 1, 2700, 1, 2, 1, 2, 14, N'Туфли Marco Tozzi женские летние, размер 39, цвет черный', N'7.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'D329H3', N'Полуботинки', 1, 1890, 2, 5, 1, 4, 4, N'Полуботинки Alessio Nesca женские 3-30797-47, размер 37, цвет: бордовый', N'8.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'B320R5', N'Туфли', 1, 4300, 1, 4, 1, 2, 6, N'Туфли Rieker женские демисезонные, размер 41, цвет коричневый', N'9.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'G432E4', N'Туфли', 1, 2800, 1, 1, 1, 3, 15, N'Туфли kari женские TR-YR-413017, размер 37, цвет: черный', N'10.jpg');
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'S213E3', N'Полуботинки', 1, 2156, 2, 6, 2, 3, 6, N'407700/01-01 Полуботинки мужские CROSBY', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'E482R4', N'Полуботинки', 1, 1800, 1, 1, 1, 2, 14, N'Полуботинки kari женские MYZ20S-149, размер 41, цвет: черный', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'S634B5', N'Кеды', 1, 5500, 2, 6, 2, 3, 0, N'Кеды Caprice мужские демисезонные, размер 42, цвет черный', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'K345R4', N'Полуботинки', 1, 2100, 2, 6, 2, 2, 3, N'407700/01-02 Полуботинки мужские CROSBY', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'O754F4', N'Туфли', 1, 5400, 2, 4, 1, 4, 18, N'Туфли женские демисезонные Rieker артикул 55073-68/37', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'G531F4', N'Ботинки', 1, 6600, 1, 1, 1, 12, 9, N'Ботинки женские зимние ROMER арт. 893167-01 Черный', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'J542F5', N'Тапочки', 1, 500, 1, 1, 2, 13, 0, N'Тапочки мужские Арт.70701-55-67син р.41', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'B431R5', N'Ботинки', 1, 2700, 2, 4, 2, 2, 5, N'Мужские кожаные ботинки/мужские ботинки', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'P764G4', N'Туфли', 1, 6800, 1, 6, 1, 15, 15, N'Туфли женские, ARGO, размер 38', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'C436G5', N'Ботинки', 1, 10200, 1, 5, 1, 15, 9, N'Ботинки женские, ARGO, размер 40', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'F427R5', N'Ботинки', 1, 11800, 2, 4, 1, 15, 11, N'Ботинки на молнии с декоративной пряжкой FRAU', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'N457T5', N'Полуботинки', 1, 4600, 1, 6, 1, 3, 13, N'Полуботинки Ботинки черные зимние, мех', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'D364R4', N'Туфли', 1, 12400, 1, 1, 1, 16, 5, N'Туфли Luiza Belly женские Kate-lazo черные из натуральной замши', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'S326R5', N'Тапочки', 1, 9900, 2, 6, 2, 17, 15, N'Мужские кожаные тапочки "Профиль С.Дали"', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'L754R4', N'Полуботинки', 1, 1700, 1, 1, 1, 2, 7, N'Полуботинки kari женские WB2020SS-26, размер 38, цвет: черный', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'M542T5', N'Кроссовки', 1, 2800, 2, 4, 2, 18, 3, N'Кроссовки мужские TOFA', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'D268G5', N'Туфли', 1, 4399, 2, 4, 1, 3, 12, N'Туфли Rieker женские демисезонные, размер 36, цвет коричневый', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'T324F5', N'Сапоги', 1, 4699, 1, 6, 1, 2, 5, N'Сапоги замша Цвет: синий', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'K358H6', N'Тапочки', 1, 599, 1, 4, 2, 20, 2, N'Тапочки мужские син р.41', NULL);
INSERT INTO dbo.Products(Article, Title, UnitId, Price, ProviderId, ManufacturerId, ProductCategoryId, Discount, StockQuantity, Description, PhotoPath) VALUES(N'H535R5', N'Ботинки', 1, 2300, 2, 4, 1, 2, 7, N'Женские Ботинки демисезонные', NULL);

-- Orders
SET IDENTITY_INSERT dbo.Orders ON;
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(1, '2025-02-27', '2025-04-20', 1, 4, N'901', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(2, '2022-09-28', '2025-04-21', 11, 1, N'902', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(3, '2025-03-21', '2025-04-22', 2, 2, N'903', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(4, '2025-02-20', '2025-04-23', 11, 3, N'904', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(5, '2025-03-17', '2025-04-24', 2, 4, N'905', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(6, '2025-03-01', '2025-04-25', 15, 1, N'906', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(7, NULL, '2025-04-26', 3, 2, N'907', 1);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(8, '2025-03-31', '2025-04-27', 19, 3, N'908', 2);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(9, '2025-04-02', '2025-04-28', 5, 4, N'909', 2);
INSERT INTO dbo.Orders(OrderId, OrderDate, DeliveryDate, PickupPointId, UserId, ReceiptCode, OrderStatusId) VALUES(10, '2025-04-03', '2025-04-29', 19, 4, N'910', 2);
SET IDENTITY_INSERT dbo.Orders OFF;

-- OrderProducts
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(1, N'А112Т4', 2);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(1, N'F635R4', 2);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(2, N'H782T5', 1);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(2, N'G783F5', 1);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(3, N'J384T6', 10);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(3, N'D572U8', 10);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(4, N'F572H7', 5);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(4, N'D329H3', 4);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(5, N'А112Т4', 2);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(5, N'F635R4', 2);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(6, N'H782T5', 1);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(6, N'G783F5', 1);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(7, N'J384T6', 10);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(7, N'D572U8', 10);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(8, N'F572H7', 5);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(8, N'D329H3', 4);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(9, N'B320R5', 5);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(9, N'G432E4', 1);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(10, N'S213E3', 5);
INSERT INTO dbo.OrderProducts(OrderId, Article, Quantity) VALUES(10, N'E482R4', 5);

COMMIT TRAN;
GO