SQLDataDriver/create_and_seed.sql - main - DataTimeModule/DateTime

SQLDataDriver/create_and_seed.sql
298 строк26 KB
Reeltell
upload
27 май 2026, 01:50
27 май 2026, 01:50f282598
-- Auto-generated from import_ready.xlsx
-- Generated: 2026-05-23 23:02:08

IF DB_ID(N'SQLDataDriver') IS NULL
BEGIN
    CREATE DATABASE SQLDataDriver;
END
GO

USE SQLDataDriver;
GO

SET NOCOUNT ON;
SET XACT_ABORT ON;
GO

-- Drop existing tables (optional rerun safety)
IF OBJECT_ID(N'dbo.OrderProducts', N'U') IS NOT NULL DROP TABLE dbo.OrderProducts;
IF OBJECT_ID(N'dbo.Orders', N'U') IS NOT NULL DROP TABLE dbo.Orders;
IF OBJECT_ID(N'dbo.OrderStatuses', N'U') IS NOT NULL DROP TABLE dbo.OrderStatuses;
IF OBJECT_ID(N'dbo.PickupPoints', N'U') IS NOT NULL DROP TABLE dbo.PickupPoints;
IF OBJECT_ID(N'dbo.Products', N'U') IS NOT NULL DROP TABLE dbo.Products;
IF OBJECT_ID(N'dbo.Units', N'U') IS NOT NULL DROP TABLE dbo.Units;
IF OBJECT_ID(N'dbo.ProductCategories', N'U') IS NOT NULL DROP TABLE dbo.ProductCategories;
IF OBJECT_ID(N'dbo.Manufacturers', N'U') IS NOT NULL DROP TABLE dbo.Manufacturers;
IF OBJECT_ID(N'dbo.Providers', N'U') IS NOT NULL DROP TABLE dbo.Providers;
IF OBJECT_ID(N'dbo.Users', N'U') IS NOT NULL DROP TABLE dbo.Users;
IF OBJECT_ID(N'dbo.Roles', N'U') IS NOT NULL DROP TABLE dbo.Roles;
GO

CREATE TABLE dbo.Roles(
  RoleId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Roles PRIMARY KEY,
  Title NVARCHAR(100) NOT NULL CONSTRAINT UQ_Roles_Title UNIQUE
);
GO

CREATE TABLE dbo.Users(
  UserId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Users PRIMARY KEY,
  RoleId INT NOT NULL,
  Surname NVARCHAR(100) NOT NULL,
  Name NVARCHAR(100) NOT NULL,
  Patronymic NVARCHAR(100) NULL,
  Login NVARCHAR(100) NOT NULL CONSTRAINT UQ_Users_Login UNIQUE,
  Password NVARCHAR(100) NOT NULL,
  CONSTRAINT FK_Users_Roles FOREIGN KEY (RoleId) REFERENCES dbo.Roles(RoleId)
);
GO

CREATE TABLE dbo.Providers(
  ProviderId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Providers PRIMARY KEY,
  Title NVARCHAR(150) NOT NULL CONSTRAINT UQ_Providers_Title UNIQUE
);
GO

CREATE TABLE dbo.Manufacturers(
  ManufacturerId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Manufacturers PRIMARY KEY,
  Title NVARCHAR(150) NOT NULL CONSTRAINT UQ_Manufacturers_Title UNIQUE
);
GO

CREATE TABLE dbo.ProductCategories(
  ProductCategoryId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_ProductCategories PRIMARY KEY,
  Title NVARCHAR(150) NOT NULL CONSTRAINT UQ_ProductCategories_Title UNIQUE
);
GO

CREATE TABLE dbo.Units(
  UnitId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Units PRIMARY KEY,
  Title NVARCHAR(50) NOT NULL CONSTRAINT UQ_Units_Title UNIQUE
);
GO

CREATE TABLE dbo.Products(
  Article NVARCHAR(50) NOT NULL CONSTRAINT PK_Products PRIMARY KEY,
  Title NVARCHAR(200) NOT NULL,
  UnitId INT NOT NULL,
  Price DECIMAL(10,2) NOT NULL,
  ProviderId INT NOT NULL,
  ManufacturerId INT NOT NULL,
  ProductCategoryId INT NOT NULL,
  Discount INT NOT NULL CONSTRAINT DF_Products_Discount DEFAULT(0),
  StockQuantity INT NOT NULL CONSTRAINT DF_Products_StockQuantity DEFAULT(0),
  Description NVARCHAR(MAX) NULL,
  PhotoPath NVARCHAR(260) NULL,
  CONSTRAINT FK_Products_Units FOREIGN KEY (UnitId) REFERENCES dbo.Units(UnitId),
  CONSTRAINT FK_Products_Providers FOREIGN KEY (ProviderId) REFERENCES dbo.Providers(ProviderId),
  CONSTRAINT FK_Products_Manufacturers FOREIGN KEY (ManufacturerId) REFERENCES dbo.Manufacturers(ManufacturerId),
  CONSTRAINT FK_Products_ProductCategories FOREIGN KEY (ProductCategoryId) REFERENCES dbo.ProductCategories(ProductCategoryId),
  CONSTRAINT CK_Products_Price CHECK (Price >= 0),
  CONSTRAINT CK_Products_Discount CHECK (Discount BETWEEN 0 AND 100),
  CONSTRAINT CK_Products_StockQuantity CHECK (StockQuantity >= 0)
);
GO

CREATE TABLE dbo.PickupPoints(
  PickupPointId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_PickupPoints PRIMARY KEY,
  [Index] NVARCHAR(20) NULL,
  Address NVARCHAR(300) NOT NULL
);
GO

CREATE TABLE dbo.OrderStatuses(
  OrderStatusId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_OrderStatuses PRIMARY KEY,
  Title NVARCHAR(100) NOT NULL CONSTRAINT UQ_OrderStatuses_Title UNIQUE
);
GO

CREATE TABLE dbo.Orders(
  OrderId INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_Orders PRIMARY KEY,
  OrderDate DATE NULL,
  DeliveryDate DATE NULL,
  PickupPointId INT NOT NULL,
  UserId INT NULL,
  ReceiptCode NVARCHAR(20) NOT NULL,
  OrderStatusId INT NOT NULL,
  CONSTRAINT FK_Orders_PickupPoints FOREIGN KEY (PickupPointId) REFERENCES dbo.PickupPoints(PickupPointId),
  CONSTRAINT FK_Orders_Users FOREIGN KEY (UserId) REFERENCES dbo.Users(UserId),
  CONSTRAINT FK_Orders_OrderStatuses FOREIGN KEY (OrderStatusId) REFERENCES dbo.OrderStatuses(OrderStatusId)
);
GO

CREATE TABLE dbo.OrderProducts(
  OrderId INT NOT NULL,
  Article NVARCHAR(50) NOT NULL,
  Quantity INT NOT NULL,
  CONSTRAINT PK_OrderProducts PRIMARY KEY (OrderId, Article),
  CONSTRAINT FK_OrderProducts_Orders FOREIGN KEY (OrderId) REFERENCES dbo.Orders(OrderId) ON DELETE CASCADE,
  CONSTRAINT FK_OrderProducts_Products FOREIGN KEY (Article) REFERENCES dbo.Products(Article),
  CONSTRAINT CK_OrderProducts_Quantity CHECK (Quantity > 0)
);
GO

BEGIN TRAN;

-- 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