-- Full Marketplace & Auction Category Structure
-- This script truncates existing data and creates a comprehensive category hierarchy

-- Disable foreign key checks for truncation
SET FOREIGN_KEY_CHECKS=0;

-- Truncate existing tables
TRUNCATE TABLE `products`;
TRUNCATE TABLE `warehouse_bins`;
TRUNCATE TABLE `categories`;

-- Re-enable foreign key checks
SET FOREIGN_KEY_CHECKS=1;

-- ========================================
-- MAIN CATEGORIES
-- ========================================
INSERT INTO `categories` (`category_id`, `category_name`, `parent_category_id`, `is_active`) VALUES
(1, 'Electronics & Computers', NULL, 1),
(2, 'Fashion & Apparel', NULL, 1),
(3, 'Home & Garden', NULL, 1),
(4, 'Sports & Outdoors', NULL, 1),
(5, 'Toys & Games', NULL, 1),
(6, 'Books & Media', NULL, 1),
(7, 'Automotive', NULL, 1),
(8, 'Health & Beauty', NULL, 1),
(9, 'Jewelry & Watches', NULL, 1),
(10, 'Art & Collectibles', NULL, 1),
(11, 'Business & Industrial', NULL, 1),
(12, 'Food & Beverages', NULL, 1),
(13, 'Pet Supplies', NULL, 1),
(14, 'Baby & Kids', NULL, 1),
(15, 'Music & Instruments', NULL, 1),
(16, 'Office Products', NULL, 1),
(17, 'Tools & Hardware', NULL, 1),
(18, 'Antiques & Vintage', NULL, 1),
(19, 'Real Estate', NULL, 1),
(20, 'Services', NULL, 1);

-- ========================================
-- ELECTRONICS & COMPUTERS (ID: 1)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Computers & Tablets', 1, 1),
('Mobile Phones & Accessories', 1, 1),
('TV & Home Entertainment', 1, 1),
('Cameras & Photography', 1, 1),
('Audio & Headphones', 1, 1),
('Gaming & Consoles', 1, 1),
('Smart Home & IoT', 1, 1),
('Wearable Technology', 1, 1),
('Computer Components', 1, 1),
('Networking & WiFi', 1, 1);

-- Level 3: Computers & Tablets Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Laptops', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Computers & Tablets' LIMIT 1) AS tmp), 1),
('Desktop Computers', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Computers & Tablets' LIMIT 1) AS tmp), 1),
('Tablets & E-Readers', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Computers & Tablets' LIMIT 1) AS tmp), 1),
('Computer Monitors', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Computers & Tablets' LIMIT 1) AS tmp), 1),
('Printers & Scanners', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Computers & Tablets' LIMIT 1) AS tmp), 1);

-- Level 3: Mobile Phones & Accessories Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Smartphones', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Mobile Phones & Accessories' LIMIT 1) AS tmp), 1),
('Phone Cases & Covers', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Mobile Phones & Accessories' LIMIT 1) AS tmp), 1),
('Chargers & Cables', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Mobile Phones & Accessories' LIMIT 1) AS tmp), 1),
('Screen Protectors', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Mobile Phones & Accessories' LIMIT 1) AS tmp), 1),
('Power Banks', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Mobile Phones & Accessories' LIMIT 1) AS tmp), 1);

-- ========================================
-- FASHION & APPAREL (ID: 2)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Women\'s Fashion', 2, 1),
('Men\'s Fashion', 2, 1),
('Kids\' Fashion', 2, 1),
('Shoes & Footwear', 2, 1),
('Bags & Luggage', 2, 1),
('Accessories', 2, 1),
('Sportswear', 2, 1),
('Vintage & Designer', 2, 1);

-- Level 3: Women's Fashion Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Women\'s Dresses', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Women\'s Fashion' LIMIT 1) AS tmp), 1),
('Women\'s Tops & Blouses', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Women\'s Fashion' LIMIT 1) AS tmp), 1),
('Women\'s Pants & Jeans', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Women\'s Fashion' LIMIT 1) AS tmp), 1),
('Women\'s Coats & Jackets', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Women\'s Fashion' LIMIT 1) AS tmp), 1),
('Women\'s Swimwear', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Women\'s Fashion' LIMIT 1) AS tmp), 1),
('Women\'s Lingerie', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Women\'s Fashion' LIMIT 1) AS tmp), 1);

-- Level 3: Men's Fashion Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Men\'s Shirts', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Men\'s Fashion' LIMIT 1) AS tmp), 1),
('Men\'s Pants & Jeans', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Men\'s Fashion' LIMIT 1) AS tmp), 1),
('Men\'s Suits & Blazers', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Men\'s Fashion' LIMIT 1) AS tmp), 1),
('Men\'s Outerwear', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Men\'s Fashion' LIMIT 1) AS tmp), 1),
('Men\'s Activewear', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Men\'s Fashion' LIMIT 1) AS tmp), 1);

-- ========================================
-- HOME & GARDEN (ID: 3)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Furniture', 3, 1),
('Kitchen & Dining', 3, 1),
('Bedding & Bath', 3, 1),
('Home Decor', 3, 1),
('Garden & Outdoor Living', 3, 1),
('Appliances', 3, 1),
('Lighting & Fixtures', 3, 1),
('Storage & Organization', 3, 1);

-- Level 3: Furniture Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Living Room Furniture', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Furniture' LIMIT 1) AS tmp), 1),
('Bedroom Furniture', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Furniture' LIMIT 1) AS tmp), 1),
('Office Furniture', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Furniture' LIMIT 1) AS tmp), 1),
('Dining Room Furniture', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Furniture' LIMIT 1) AS tmp), 1),
('Outdoor Furniture', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Furniture' LIMIT 1) AS tmp), 1);

-- Level 3: Kitchen & Dining Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Cookware & Bakeware', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Kitchen & Dining' LIMIT 1) AS tmp), 1),
('Kitchen Appliances', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Kitchen & Dining' LIMIT 1) AS tmp), 1),
('Dinnerware & Serveware', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Kitchen & Dining' LIMIT 1) AS tmp), 1),
('Kitchen Storage', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Kitchen & Dining' LIMIT 1) AS tmp), 1),
('Bar & Wine Accessories', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Kitchen & Dining' LIMIT 1) AS tmp), 1);

-- ========================================
-- SPORTS & OUTDOORS (ID: 4)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Exercise & Fitness', 4, 1),
('Outdoor Recreation', 4, 1),
('Team Sports', 4, 1),
('Water Sports', 4, 1),
('Winter Sports', 4, 1),
('Cycling', 4, 1),
('Hunting & Fishing', 4, 1),
('Golf', 4, 1);

-- Level 3: Exercise & Fitness Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Gym Equipment', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Exercise & Fitness' LIMIT 1) AS tmp), 1),
('Yoga & Pilates', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Exercise & Fitness' LIMIT 1) AS tmp), 1),
('Running & Jogging', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Exercise & Fitness' LIMIT 1) AS tmp), 1),
('Fitness Accessories', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Exercise & Fitness' LIMIT 1) AS tmp), 1),
('Fitness Trackers', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Exercise & Fitness' LIMIT 1) AS tmp), 1);

-- ========================================
-- TOYS & GAMES (ID: 5)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Action Figures & Collectibles', 5, 1),
('Board Games & Puzzles', 5, 1),
('Building Toys', 5, 1),
('Dolls & Stuffed Animals', 5, 1),
('Educational Toys', 5, 1),
('Electronic Toys', 5, 1),
('Outdoor Play', 5, 1),
('Video Games', 5, 1);

-- ========================================
-- BOOKS & MEDIA (ID: 6)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Books', 6, 1),
('Movies & TV Shows', 6, 1),
('Music', 6, 1),
('Magazines & Newspapers', 6, 1),
('Digital Media', 6, 1),
('Textbooks', 6, 1);

-- Level 3: Books Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Fiction Books', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Books' LIMIT 1) AS tmp), 1),
('Non-Fiction Books', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Books' LIMIT 1) AS tmp), 1),
('Children\'s Books', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Books' LIMIT 1) AS tmp), 1),
('Comic Books & Graphic Novels', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Books' LIMIT 1) AS tmp), 1),
('Rare & Collectible Books', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Books' LIMIT 1) AS tmp), 1);

-- ========================================
-- AUTOMOTIVE (ID: 7)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Cars & Trucks', 7, 1),
('Motorcycles & ATVs', 7, 1),
('Auto Parts & Accessories', 7, 1),
('Car Electronics', 7, 1),
('Tools & Equipment', 7, 1),
('Tires & Wheels', 7, 1),
('Classic & Vintage Cars', 7, 1);

-- Level 3: Auto Parts & Accessories Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Engine Parts', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Auto Parts & Accessories' LIMIT 1) AS tmp), 1),
('Brake System', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Auto Parts & Accessories' LIMIT 1) AS tmp), 1),
('Suspension & Steering', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Auto Parts & Accessories' LIMIT 1) AS tmp), 1),
('Interior Accessories', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Auto Parts & Accessories' LIMIT 1) AS tmp), 1),
('Exterior Accessories', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Auto Parts & Accessories' LIMIT 1) AS tmp), 1);

-- ========================================
-- HEALTH & BEAUTY (ID: 8)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Skincare', 8, 1),
('Makeup & Cosmetics', 8, 1),
('Hair Care', 8, 1),
('Fragrances', 8, 1),
('Health & Wellness', 8, 1),
('Personal Care', 8, 1),
('Medical Supplies', 8, 1),
('Vitamins & Supplements', 8, 1);

-- ========================================
-- JEWELRY & WATCHES (ID: 9)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Fine Jewelry', 9, 1),
('Fashion Jewelry', 9, 1),
('Watches', 9, 1),
('Engagement & Wedding', 9, 1),
('Vintage & Antique Jewelry', 9, 1),
('Men\'s Jewelry', 9, 1);

-- Level 3: Fine Jewelry Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Rings', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Fine Jewelry' LIMIT 1) AS tmp), 1),
('Necklaces & Pendants', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Fine Jewelry' LIMIT 1) AS tmp), 1),
('Earrings', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Fine Jewelry' LIMIT 1) AS tmp), 1),
('Bracelets', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Fine Jewelry' LIMIT 1) AS tmp), 1),
('Brooches & Pins', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Fine Jewelry' LIMIT 1) AS tmp), 1);

-- ========================================
-- ART & COLLECTIBLES (ID: 10)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Paintings', 10, 1),
('Sculptures', 10, 1),
('Prints & Posters', 10, 1),
('Photography', 10, 1),
('Coins & Currency', 10, 1),
('Stamps', 10, 1),
('Trading Cards', 10, 1),
('Memorabilia', 10, 1),
('Antique Art', 10, 1);

-- ========================================
-- BUSINESS & INDUSTRIAL (ID: 11)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Industrial Equipment', 11, 1),
('Restaurant & Food Service', 11, 1),
('Medical & Lab Equipment', 11, 1),
('Construction Equipment', 11, 1),
('Manufacturing', 11, 1),
('Retail & Services', 11, 1),
('Agriculture & Forestry', 11, 1);

-- ========================================
-- FOOD & BEVERAGES (ID: 12)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Gourmet Foods', 12, 1),
('Beverages', 12, 1),
('Snacks & Candy', 12, 1),
('Organic & Natural', 12, 1),
('International Foods', 12, 1),
('Wine & Spirits', 12, 1),
('Coffee & Tea', 12, 1);

-- ========================================
-- PET SUPPLIES (ID: 13)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Dog Supplies', 13, 1),
('Cat Supplies', 13, 1),
('Fish & Aquatics', 13, 1),
('Bird Supplies', 13, 1),
('Small Animal Supplies', 13, 1),
('Reptile & Amphibian', 13, 1);

-- Level 3: Dog Supplies Subcategories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Dog Food & Treats', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Dog Supplies' LIMIT 1) AS tmp), 1),
('Dog Toys', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Dog Supplies' LIMIT 1) AS tmp), 1),
('Dog Beds & Furniture', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Dog Supplies' LIMIT 1) AS tmp), 1),
('Dog Grooming', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Dog Supplies' LIMIT 1) AS tmp), 1),
('Dog Training & Behavior', (SELECT category_id FROM (SELECT category_id FROM categories WHERE category_name = 'Dog Supplies' LIMIT 1) AS tmp), 1);

-- ========================================
-- BABY & KIDS (ID: 14)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Baby Gear', 14, 1),
('Baby Clothing', 14, 1),
('Nursery & Decor', 14, 1),
('Baby Feeding', 14, 1),
('Baby Safety', 14, 1),
('Maternity', 14, 1),
('Kids\' Furniture', 14, 1);

-- ========================================
-- MUSIC & INSTRUMENTS (ID: 15)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Guitars & Basses', 15, 1),
('Keyboards & Pianos', 15, 1),
('Drums & Percussion', 15, 1),
('Wind Instruments', 15, 1),
('String Instruments', 15, 1),
('DJ & Recording Equipment', 15, 1),
('Sheet Music & Songbooks', 15, 1);

-- ========================================
-- OFFICE PRODUCTS (ID: 16)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Office Supplies', 16, 1),
('Office Furniture', 16, 1),
('Office Electronics', 16, 1),
('Stationery', 16, 1),
('Shipping & Packaging', 16, 1),
('Office Decor', 16, 1);

-- ========================================
-- TOOLS & HARDWARE (ID: 17)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Power Tools', 17, 1),
('Hand Tools', 17, 1),
('Hardware & Fasteners', 17, 1),
('Electrical Supplies', 17, 1),
('Plumbing Supplies', 17, 1),
('Paint & Supplies', 17, 1),
('Safety Equipment', 17, 1);

-- ========================================
-- ANTIQUES & VINTAGE (ID: 18)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Antique Furniture', 18, 1),
('Vintage Clothing', 18, 1),
('Vintage Electronics', 18, 1),
('Antique Jewelry', 18, 1),
('Collectible China & Glass', 18, 1),
('Vintage Toys', 18, 1),
('Historical Items', 18, 1);

-- ========================================
-- REAL ESTATE (ID: 19)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Residential Properties', 19, 1),
('Commercial Properties', 19, 1),
('Land & Lots', 19, 1),
('Vacation Properties', 19, 1),
('Rental Properties', 19, 1),
('Foreclosures', 19, 1);

-- ========================================
-- SERVICES (ID: 20)
-- ========================================
-- Level 2 Categories
INSERT INTO `categories` (`category_name`, `parent_category_id`, `is_active`) VALUES
('Home Services', 20, 1),
('Professional Services', 20, 1),
('Event Services', 20, 1),
('Automotive Services', 20, 1),
('Educational Services', 20, 1),
('Travel & Tourism', 20, 1);

-- ========================================
-- WAREHOUSE BINS - Reinitialize
-- ========================================
INSERT INTO `warehouse_bins` (`bin_code`, `location`, `capacity`, `current_occupancy`, `category_id`) VALUES
-- Electronics Section
('E1-01', 'Electronics Warehouse, Row 1, Section 1', 150, 0, 1),
('E1-02', 'Electronics Warehouse, Row 1, Section 2', 150, 0, 1),
('E1-03', 'Electronics Warehouse, Row 1, Section 3', 150, 0, 1),
('E2-01', 'Electronics Warehouse, Row 2, Section 1', 200, 0, 1),
('E2-02', 'Electronics Warehouse, Row 2, Section 2', 200, 0, 1),

-- Fashion Section
('F1-01', 'Fashion Warehouse, Row 1, Section 1', 300, 0, 2),
('F1-02', 'Fashion Warehouse, Row 1, Section 2', 300, 0, 2),
('F2-01', 'Fashion Warehouse, Row 2, Section 1', 250, 0, 2),
('F2-02', 'Fashion Warehouse, Row 2, Section 2', 250, 0, 2),

-- Home & Garden Section
('H1-01', 'Home Warehouse, Row 1, Section 1', 400, 0, 3),
('H1-02', 'Home Warehouse, Row 1, Section 2', 400, 0, 3),
('H2-01', 'Home Warehouse, Row 2, Section 1', 350, 0, 3),

-- General Purpose Bins
('G1-01', 'General Warehouse, Row 1, Section 1', 200, 0, NULL),
('G1-02', 'General Warehouse, Row 1, Section 2', 200, 0, NULL),
('G1-03', 'General Warehouse, Row 1, Section 3', 200, 0, NULL),
('G2-01', 'General Warehouse, Row 2, Section 1', 250, 0, NULL),
('G2-02', 'General Warehouse, Row 2, Section 2', 250, 0, NULL),

-- Large Item Storage
('L1-01', 'Large Item Storage, Bay 1', 500, 0, NULL),
('L1-02', 'Large Item Storage, Bay 2', 500, 0, NULL),
('L1-03', 'Large Item Storage, Bay 3', 500, 0, NULL),

-- Valuable Items Secure Storage
('V1-01', 'Secure Vault, Section 1', 50, 0, 9),  -- For Jewelry
('V1-02', 'Secure Vault, Section 2', 50, 0, 10), -- For Art & Collectibles
('V1-03', 'Secure Vault, Section 3', 75, 0, NULL),

-- Cold Storage (for applicable items)
('C1-01', 'Cold Storage, Unit 1', 100, 0, 12), -- For Food & Beverages
('C1-02', 'Cold Storage, Unit 2', 100, 0, 8);  -- For Health & Beauty products

-- Display counts
SELECT 
    'Categories Created' as Item, 
    COUNT(*) as Count 
FROM categories
UNION ALL
SELECT 
    'Main Categories' as Item, 
    COUNT(*) as Count 
FROM categories 
WHERE parent_category_id IS NULL
UNION ALL
SELECT 
    'Subcategories' as Item, 
    COUNT(*) as Count 
FROM categories 
WHERE parent_category_id IS NOT NULL
UNION ALL
SELECT 
    'Warehouse Bins Created' as Item, 
    COUNT(*) as Count 
FROM warehouse_bins;