Table Products +20 more records

Store.sql

USE [master]
GO
/****** Object:  Database [Store]    Script Date: 17/12/2025 10:32:02 PM ******/
CREATE DATABASE [Store]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Store', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\Store.mdf' , SIZE = 73728KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Store_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\Store_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
GO
ALTER DATABASE [Store] SET COMPATIBILITY_LEVEL = 170
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
ALTER DATABASE [Store] SET OPTIMIZED_LOCKING = 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].[Product]    Script Date: 17/12/2025 10:32:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NOT NULL,
	[category] [nvarchar](50) NOT NULL,
	[price] [real] NOT NULL,
	[discount] [real] NULL,
	[quantity] [int] NOT NULL,
	[measurement] [nvarchar](50) NOT NULL,
	[producer] [nvarchar](50) NOT NULL,
	[country] [nvarchar](50) NOT NULL,
	[supplier] [nvarchar](50) NOT NULL,
	[date_of_delivery] [date] NOT NULL,
	[expire_date] [date] NOT 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].[Product] ON 

INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (4, N'iPhone 15 Pro 256gb', N'Smartphones', 1199.99, 0.5, 25, N'pieces', N'Apple', N'USA', N'TechGlobal Suppliers', CAST(N'2025-01-15' AS Date), CAST(N'2026-01-15' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (5, N'Samsung Galaxy Galaxy S24 Ultra', N'Smartphones', 1299.99, 0, 18, N'pieces', N'Samsung', N'South Korea', N'ElectroWorld Ltd.', CAST(N'2024-01-20' AS Date), CAST(N'2026-01-20' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (6, N'Dell  XPS 15 Laptop', N'Laptops', 1899.99, 0.1, 12, N'pieces', N'Dell', N'USA', N'Computer Solutions inc.', CAST(N'2024-01-10' AS Date), CAST(N'2027-01-10' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (7, N'Sony WH-1000SM5 Headphones', N'Audio', 399.99, 0.15, 30, N'pieces', N'Sony', N'Japan', N'AudioTech Distributors', CAST(N'2024-01-18' AS Date), CAST(N'2026-07-18' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (8, N'Apple iPad Air 64gb', N'Tablets', 749.99, 0.8, 22, N'pieces', N'Apple', N'China', N'Gadget Pro Supply', CAST(N'2024-01-12' AS Date), CAST(N'2026-01-12' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (9, N'Coca-Cola 2L Bottle', N'Beverages', 2.49, 0, 120, N'pieces', N'Coca-Cola Company', N'USA', N'Beverages Distributors LLC', CAST(N'2024-01-05' AS Date), CAST(N'2024-07-05' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (10, N'Lays Classic Chips 200g', N'Snacks', 3.99, 0.1, 85, N'pieces', N'PepsiCo', N'USA', N'Snack World Inc.', CAST(N'2024-01-08' AS Date), CAST(N'2024-04-08' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (11, N'Barilla Spaghetti 500g', N'Pasta', 1.89, 0, 150, N'pieces', N'Barilla', N'Italy', N'European Foods Import', CAST(N'2024-01-03' AS Date), CAST(N'2025-01-03' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (12, N'Nescafe Gold 200g', N'Coffee', 8.99, 0.5, 45, N'pieces', N'Nestle', N'Switzerland', N'Global Coffee Traders', CAST(N'2024-01-10' AS Date), CAST(N'2025-06-10' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (13, N'Heinz Ketchup 500g', N'Condiments', 3.49, 0, 90, N'pieces', N'Heinz', N'USA', N'Food Products Distributors', CAST(N'2024-01-07' AS Date), CAST(N'2024-12-07' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (14, N'President Butter 250g', N'Dairy', 4.99, 0, 60, N'pieces', N'Lactails', N'France', N'Dairy Import Company', CAST(N'2024-01-06' AS Date), CAST(N'2024-02-06' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (15, N'Danone Yogurt Strawberry', N'Dairy', 1.29, 0.2, 200, N'pieces', N'Danone', N'France', N'Fresh Dairy Supply', CAST(N'2024-01-04' AS Date), CAST(N'2024-01-25' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (16, N'Mozzarella Cheese 400', N'Dairy', 6.99, 0, 40, N'pieces', N'Galbani', N'Italy', N'Cheese Importers Ltd.', CAST(N'2024-01-09' AS Date), CAST(N'2024-02-09' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (17, N'Ariel Laundry Detergent 3L', N'Cleaning Products', 12.99, 0.15, 35, N'pieces', N'Procter & Gamble', N'USA', N'Home Care Supplies', CAST(N'2024-01-11' AS Date), CAST(N'2025-01-11' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (19, N'Fairy Dish Soap 500ml', N'Cleaning Products', 3.79, 0, 75, N'pieces', N'Procter & Gamble', N'UK', N'Cleaning Products Inc.', CAST(N'2024-01-13' AS Date), CAST(N'2025-07-13' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (20, N'Bounty Paper Towels 8-pack', N'Paper Goods', 9.99, 0.1, 50, N'packages', N'Procter & Gamble', N'USA', N'Paper Products Distributor', CAST(N'2024-01-14' AS Date), CAST(N'2026-01-14' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (21, N'Bread Whole Wheat 500g', N'Bakery', 2.49, 0, 100, N'pieces', N'Local Bakery', N'Local', N'Fresh Bread Supply', CAST(N'2024-01-16' AS Date), CAST(N'2024-01-23' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (22, N'Croissants Chocolate 4-pack', N'Bakery', 5.99, 0, 30, N'packages', N'Local Bakery', N'Local', N'Morning Pastry Co.', CAST(N'2024-01-17' AS Date), CAST(N'2024-01-24' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (23, N'Green Peas Frozen 1kg', N'Frozen Foods', 3.99, 0.5, 65, N'packags', N'Birds Eye', N'USA', N'Frozen Food Importers', CAST(N'2024-01-02' AS Date), CAST(N'2025-01-02' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (24, N'Pizza Pepperoni 400g', N'Frozen Foods', 6.49, 0, 45, N'pieces', N'Dr. Oetker', N'Germany', N'European Frozen Foods', CAST(N'2024-01-01' AS Date), CAST(N'2024-07-01' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (25, N'Colgate Total Toothpaste', N'Personal Care', 4.29, 0, 80, N'pieces', N'Colgate-Palmolive', N'USA', N'Personal Care Distributors', CAST(N'2024-01-19' AS Date), CAST(N'2025-01-19' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (26, N'Dove Beauty Bar 4-packs', N'Personal Care', 5.99, 0.1, 55, N'packages', N'Unilever', N'UK', N'Cosmetic Supply Chain', CAST(N'2024-01-21' AS Date), CAST(N'2026-01-21' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (27, N'Pantene Shampoo 400ml', N'Personal Care', 7.49, 0.2, 40, N'pieces', N'Procter & Gamble', N'USA', N'Beauty Products Ltd.', CAST(N'2024-01-22' AS Date), CAST(N'2025-01-22' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (28, N'Chicken Breast 1kg', N'Meat', 9.99, 0.15, 25, N'packages', N'Tyson Foods', N'USA', N'Fresh Meat Suppliers', CAST(N'2024-01-23' AS Date), CAST(N'2024-01-30' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (29, N'Beef Steak 500g', N'Meat', 15.99, 0, 20, N'packages', N'JBS', N'Brazil', N'Premium Meat Importers', CAST(N'2024-01-24' AS Date), CAST(N'2024-01-31' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (30, N'Bananas 1kg', N'Fruits', 1.99, 0, 200, N'packages', N'Local Farm', N'Ecuador', N'Fresh Fruit Import', CAST(N'2024-01-25' AS Date), CAST(N'2024-02-01' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (31, N'Apples Red Delicious 1kg', N'Fruits', 3.49, 0.1, 120, N'packages', N'Local Orchard', N'Poland', N'Eruopean Fruit Supply', CAST(N'2024-01-26' AS Date), CAST(N'2024-02-05' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (34, N'Carrots 1kg', N'Vegetables', 2.29, 0.5, 150, N'packages', N'Local Farm', N'Spain', N'Vegetable Distributor', CAST(N'2024-01-27' AS Date), CAST(N'2024-02-10' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (35, N'Pampers Size 3 44-pack', N'Baby Care', 24.99, 0.5, 30, N'packages', N'Procter & Gamble', N'USA', N'Baby Products Supply', CAST(N'2024-01-28' AS Date), CAST(N'2026-01-28' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (36, N'Purina Dog Food 5kg', N'Pet Supplies', 25.99, 0.1, 28, N'packages', N'Nestle Purina', N'USA', N'Pet Food Distributors', CAST(N'2024-01-30' AS Date), CAST(N'2025-01-30' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (37, N'HP LaserJet Pro Printer', N'Office Equipment', 299.99, 0.12, 15, N'pieces', N'HP Inc.', N'USA', N'Office Solutions Ltd.', CAST(N'2024-01-15' AS Date), CAST(N'2026-01-15' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (38, N'Lindt Excellence 85% Cocoa 100g', N'Chocolate ', 4.99, 0.5, 65, N'pieces', N'Lindt', N'Switzerland', N'Sweet Imports Co.', CAST(N'2024-01-10' AS Date), CAST(N'2024-09-10' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (39, N'Tropicana Orange Juice 1L', N'Beverages', 3.79, 0, 75, N'pieces', N'PepsiCo', N'USA', N'Beverages Supply Chain', CAST(N'2024-01-08' AS Date), CAST(N'2024-02-08' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (40, N'LEGO Classic Creative Brick Box', N'Tous', 49.99, 0.15, 22, N'boxes', N'LEGO Group', N'Denmark', N'Toy Distributors Inc.', CAST(N'2024-01-12' AS Date), CAST(N'2027-01-02' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (41, N'Nike Air Max 270 Sneakers', N'Footwear', 149.99, 0.2, 18, N'pairs', N'Nike', N'Vietnam', N'Sportswear Suppliers', CAST(N'2024-01-08' AS Date), CAST(N'2026-01-18' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (42, N'Philips LED Bulb 10W 806lm', N'Lighting', 6.49, 0, 120, N'pieces', N'Philips', N'Netherlands', N'Electrical Supplies Co.', CAST(N'2024-01-05' AS Date), CAST(N'2028-01-05' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (43, N'Campbell''s Tomato Soup 400g', N'Canned Goods', 2.29, 0.1, 95, N'cans', N'Campbell Soup Company', N'USA', N'Canned Food Distributors', CAST(N'2024-01-03' AS Date), CAST(N'2025-08-03' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (44, N'Gillette Fusion5 Razor 4-pack', N'Personal Care', 18.99, 0.8, 40, N'packages', N'Procter & Gamble', N'USA', N'Grooming Products Ltd.', CAST(N'2024-01-20' AS Date), CAST(N'2026-01-20' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (45, N'Lavazza Coffee Beans 1kg', N'Coffee', 14.99, 0, 35, N'packages', N'Lavazza', N'Italy', N'Premium Coffee Import', CAST(N'2024-01-14' AS Date), CAST(N'2024-12-14' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (46, N'Energizer AA Batteries 8-pack', N'Electronics', 9.99, 0, 85, N'packages', N'Energizer Holdings', N'USA', N'Battery Supply Company', CAST(N'2024-01-25' AS Date), CAST(N'2027-01-25' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (48, N'Samsung 75" QLED 4K TV', N'Electronics', 1499.99, 0.15, 8, N'pieces', N'Samsung', N'South Korea', N'VisionTech Ltd.', CAST(N'2024-02-10' AS Date), CAST(N'2027-02-10' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (49, N'Nespresso Vertuo Coffee Machine', N'Appliances', 199.99, 0.25, 15, N'pieces', N'Nestle', N'Switzerland', N'Home Appliance Partners', CAST(N'2024-02-05' AS Date), CAST(N'2026-02-05' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (50, N'Adidas Originals Hoodie', N'Clothing', 69.99, 0.3, 40, N'pieces', N'Adidas', N'Cambodia', N'ActiveWear Distributors', CAST(N'2024-02-12' AS Date), CAST(N'2026-02-12' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (51, N'Kindle Paperwhite 11th Gen', N'E-Readers', 139.99, 0.1, 25, N'pieces', N'Amazon', N'USA', N'Digital Tech Supply', CAST(N'2024-02-08' AS Date), CAST(N'2027-02-08' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (52, N'Logitech MX Master 3 Mouse', N'Computer Accessories', 99.99, 0.05, 60, N'pieces', N'Logitech', N'Switzerland', N'Peripheral Solutions Co.', CAST(N'2024-02-01' AS Date), CAST(N'2026-08-01' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (53, N'Pampers Baby-Dry Size 4', N'Baby Care', 29.99, 0, 35, N'packages', N'Procter & Gamble', N'USA', N'Baby Comfort Inc.', CAST(N'2024-02-15' AS Date), CAST(N'2025-08-15' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (54, N'Whiskas Chicken 2kg', N'Pet Supplies', 12.49, 0.1, 50, N'packages', N'Mars', N'USA', N'Pet Nutrition Ltd.', CAST(N'2024-02-03' AS Date), CAST(N'2025-02-03' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (55, N'Ben & Jerry''s Chocolate Fudge Brownie', N'Frozen Foods', 5.99, 0.2, 65, N'pieces', N'Unilever', N'USA', N'Frozen Delights Import', CAST(N'2024-01-28' AS Date), CAST(N'2024-10-28' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (56, N'Gilette Mach3 Turbo Razor', N'Personal Care', 12.99, 0.4, 70, N'packages', N'Procter & Gamble', N'USA', N'Grooming Essentials ', CAST(N'2024-02-18' AS Date), CAST(N'2026-02-18' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (57, N'IKEA Billy Bookcase', N'Furniture', 89.99, 0, 20, N'pieces', N'IKEA', N'Sweden', N'Nordic Home Supply', CAST(N'2024-02-20' AS Date), CAST(N'2029-02-20' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (58, N'Canon EOS R50 Mirrorless Camera', N'Electronics', 749.99, 0.1, 10, N'pieces', N'Canon', N'Japan', N'PhotoPro Distributors', CAST(N'2024-02-14' AS Date), CAST(N'2027-02-14' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (59, N'Nivea Men Sensitive Shaving Foam', N'Personal Care', 3.99, 0, 110, N'pieces', N'Beiersdorf', N'Germany', N'Men''s Care World', CAST(N'2024-02-07' AS Date), CAST(N'2025-08-07' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (60, N'Toblerone Chocolate 200g', N'Chocolate', 6.49, 0.15, 90, N'pieces', N'Mondelez', N'Switzerland', N'Sweet Treats Import', CAST(N'2024-02-11' AS Date), CAST(N'2024-11-11' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (61, N'Mr. Clean Multi-Surface Spray', N'Cleaning Products', 4.29, 0, 80, N'pieces', N'Procter & Gamble', N'USA', N'Sparkle Supplies Co.', CAST(N'2024-02-09' AS Date), CAST(N'2026-02-09' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (62, N'ASUS TUF Gaming Laptop', N'Laptops', 1299.99, 0.12, 14, N'pieces', N'ASUS', N'Taiwan', N'GameTech Solutions', CAST(N'2024-02-22' AS Date), CAST(N'2027-02-22' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (63, N'Oral-B Electric Toothbrush', N'Personal Care', 89.99, 0.35, 30, N'pieces', N'Procter & Gamble', N'Germany', N'Dental Care Distributors', CAST(N'2024-02-16' AS Date), CAST(N'2026-08-16' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (64, N'Jack Daniel''s Tennessee Whiskey 0.7L', N'Beverages (Alcoholic)', 24.99, 0, 40, N'bottles', N'Brown-Forman', N'USA', N'Premium Spirits Ltd.', CAST(N'2024-02-25' AS Date), CAST(N'2030-02-25' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (65, N'Wilson NBA Official Game Ball', N'Sports Equipment', 59.99, 0.05, 25, N'pieces', N'Wilson', N'USA', N'Sports Gear Inc.', CAST(N'2024-02-04' AS Date), CAST(N'2026-02-04' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (66, N'Lay''s Dalt & Vinegar Chips 150g', N'Snacks', 2.99, 0.1, 120, N'pieces', N'PepsiCo', N'USA', N'Crisp & Crunch Co.', CAST(N'2024-02-06' AS Date), CAST(N'2024-05-06' AS Date))
INSERT [dbo].[Product] ([id], [name], [category], [price], [discount], [quantity], [measurement], [producer], [country], [supplier], [date_of_delivery], [expire_date]) VALUES (67, N'JBL Flip 6 Portable Speaker', N'Audio', 129.99, 0.2, 28, N'pieces', N'JBL', N'USA', N'SoundWave Distributors', CAST(N'2024-02-19' AS Date), CAST(N'2026-02-19' AS Date))
SET IDENTITY_INSERT [dbo].[Product] OFF
GO
/****** Object:  Index [IX_Product]    Script Date: 17/12/2025 10:32:02 PM ******/
CREATE NONCLUSTERED COLUMNSTORE INDEX [IX_Product] ON [dbo].[Product]
(
	[id]
)WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0, DATA_COMPRESSION = COLUMNSTORE) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_discount]  DEFAULT ((0)) FOR [discount]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [CK_Product_1_expire_date] CHECK  (([expire_date]>='2023-01-01'))
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [CK_Product_1_expire_date]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [CK_Product_date_of_delivery] CHECK  (([date_of_delivery]>='2023-01-01'))
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [CK_Product_date_of_delivery]
GO
USE [master]
GO
ALTER DATABASE [Store] SET  READ_WRITE 
GO