-- Schema and seed for line_item_misc_products
CREATE TABLE IF NOT EXISTS `line_item_misc_products` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `section` VARCHAR(32) NOT NULL,                 -- e.g., a) SKIN, h) REPLICAS
  `item` VARCHAR(255) NOT NULL,                   -- product name
  `option` VARCHAR(255) NULL,                     -- option if any
  `internal_note` TEXT NULL,
  `notes` TEXT NULL,                              -- non-numeric price notes (e.g., TBA, Not applicable, #VALUE!)
  `price_zar` DECIMAL(10,2) NULL,
  `price_usd` DECIMAL(10,2) NULL,
  `price_eur` DECIMAL(10,2) NULL,
  `price_bwp` DECIMAL(10,2) NULL,
  `is_active` TINYINT(1) NOT NULL DEFAULT 1,
  `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_section_item` (`section`, `item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `line_item_misc_products`
(`section`, `item`, `option`, `internal_note`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
-- a) SKIN
('a) SKIN','Cushion - Game skin cushion tops for elephant feet using client\'s skin',NULL,NULL,NULL,1580.00,180.00,160.00,1817.00,1),
('a) SKIN','Gun bag - Standard [HS Code: 4202.91, Gun bags made from leather]','Standard design (excludes skin)',NULL,NULL,2630.00,280.00,260.00,3024.50,1),
('a) SKIN','Gun Bag - Scoped',NULL,NULL,NULL,2630.00,280.00,260.00,3024.50,1),
('a) SKIN','Gun Bag - Scoped (leather on one side)',NULL,NULL,NULL,2980.00,295.00,275.00,3427.00,1),
('a) SKIN','Gun sling',NULL,NULL,NULL,340.00,30.00,28.00,391.00,1),
('a) SKIN','Backpack - Ashlove',NULL,NULL,NULL,1570.00,135.00,128.00,1805.50,1),
('a) SKIN','Backpack - Explorer',NULL,NULL,NULL,1825.00,160.00,150.00,2098.75,1),
('a) SKIN','Backpack - Standard',NULL,NULL,NULL,1950.00,170.00,160.00,2242.50,1),
('a) SKIN','Handbag - Amelia',NULL,NULL,NULL,1255.00,110.00,105.00,1443.25,1),
('a) SKIN','Handbag - Caroline',NULL,NULL,NULL,1365.00,120.00,115.00,1569.75,1),
('a) SKIN','Handbag - Chicago',NULL,NULL,NULL,1495.00,130.00,123.00,1719.25,1),
('a) SKIN','Togbag - Cosmia',NULL,NULL,NULL,1580.00,140.00,130.00,1817.00,1),
('a) SKIN','Handbag - Esme',NULL,NULL,NULL,1370.00,120.00,115.00,1575.50,1),
('a) SKIN','Handbag - Frances',NULL,NULL,NULL,1290.00,115.00,105.00,1483.50,1),
('a) SKIN','Handbag - Knot',NULL,NULL,NULL,1280.00,115.00,105.00,1472.00,1),
('a) SKIN','Handbag - Lesatsi',NULL,NULL,NULL,1110.00,95.00,92.00,1276.50,1),
('a) SKIN','Handbag - Lockdown',NULL,NULL,NULL,1165.00,100.00,95.00,1339.75,1),
('a) SKIN','Handbag - London',NULL,NULL,NULL,1420.00,125.00,120.00,1633.00,1),
('a) SKIN','Handbag - Manini',NULL,NULL,NULL,940.00,82.00,78.00,1081.00,1),
('a) SKIN','Handbag - Marie',NULL,NULL,NULL,1165.00,100.00,95.00,1339.75,1),
('a) SKIN','Handbag - Ruby',NULL,NULL,NULL,970.00,95.00,80.00,1115.50,1),
('a) SKIN','Handbag - Tebogo',NULL,NULL,NULL,1160.00,100.00,95.00,1334.00,1),
('a) SKIN','Handbag - Victoria',NULL,NULL,NULL,1250.00,110.00,105.00,1437.50,1),
('a) SKIN','Handbag - Zanelle',NULL,NULL,NULL,1280.00,115.00,105.00,1472.00,1),
('a) SKIN','Togbag - Cruiser',NULL,NULL,NULL,2460.00,215.00,200.00,2829.00,1),
('a) SKIN','Togbag - Double Zip',NULL,NULL,NULL,2460.00,215.00,200.00,2829.00,1),
('a) SKIN','Togbag - U-Zip',NULL,NULL,NULL,2460.00,215.00,200.00,2829.00,1),
('a) SKIN','Togbag - Standard',NULL,NULL,NULL,2530.00,220.00,210.00,2909.50,1),
('a) SKIN','Laptop bag - Nomad',NULL,NULL,NULL,1565.00,135.00,128.00,1799.75,1),
('a) SKIN','Laptop bag - Standard',NULL,NULL,NULL,1835.00,160.00,150.00,2110.25,1),
('a) SKIN','Carpet - Mixed game skin 1,23m x 1,7m',NULL,NULL,NULL,1160.00,100.00,95.00,1334.00,1),
('a) SKIN','Carpet - Mixed game skin custom size',NULL,NULL,'TBA / v / #VALUE!',NULL,NULL,NULL,NULL,1),
('a) SKIN','Africa map - Small',NULL,NULL,NULL,575.00,50.00,48.00,661.25,1),
('a) SKIN','Africa map - Medium',NULL,NULL,NULL,1030.00,90.00,85.00,1184.50,1),
('a) SKIN','Africa map - Large',NULL,NULL,NULL,1830.00,160.00,150.00,2104.50,1),
('a) SKIN','Belt',NULL,NULL,NULL,270.00,24.00,22.00,310.50,1),
('a) SKIN','Belt - Made from clients buffalo leather',NULL,NULL,NULL,440.00,38.00,36.00,506.00,1),
('a) SKIN','Cushion - Both sides game skin hide',NULL,NULL,NULL,620.00,55.00,52.00,713.00,1),
('a) SKIN','Cushion - Supply suede for one side',NULL,NULL,NULL,620.00,55.00,52.00,713.00,1),
('a) SKIN','Cushion - Small patch blocks',NULL,NULL,NULL,760.00,67.00,63.00,874.00,1),
('a) SKIN','Makeup bag',NULL,NULL,NULL,395.00,35.00,33.00,454.25,1),
('a) SKIN','Toiletry bag',NULL,NULL,NULL,720.00,63.00,60.00,828.00,1),
('a) SKIN','Buffalo Flatskin furtan',NULL,NULL,NULL,3630.00,480.00,435.00,4174.50,1),
('a) SKIN','Standard directors chairs (use client skin - add 15% for canvas)',NULL,NULL,NULL,2675.00,285.00,265.00,3076.25,1),
('a) SKIN','Skinning - Full carcass - Small',NULL,NULL,'Not applicable (USD/EUR)',735.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Full carcass - Medium',NULL,NULL,'Not applicable (USD/EUR)',1090.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Full carcass - Large',NULL,NULL,'Not applicable (USD/EUR)',1450.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Full carcass - Extra Large',NULL,'Buffalo, eland, croc up to 3m','Not applicable (USD/EUR)',2180.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Full carcass - Custom',NULL,'Giraffe, crocodile, hippo etc','Not applicable (USD/EUR)',2920.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Cape - Small',NULL,NULL,'Not applicable (USD/EUR)',220.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Cape - Medium',NULL,NULL,'Not applicable (USD/EUR)',295.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Cape - Large',NULL,NULL,'Not applicable (USD/EUR)',365.00,NULL,NULL,NULL,1),
('a) SKIN','Skinning - Cape - Extra Large',NULL,NULL,'Not applicable (USD/EUR)',435.00,NULL,NULL,NULL,1),

-- h) REPLICAS
('h) REPLICAS','Rhino replica shouldermount (fiberglass reproduction)',NULL,NULL,NULL,26280.00,2830.00,2680.00,NULL,1),
('h) REPLICAS','Hippo replica shouldermount (fiberglass reproduction)',NULL,NULL,NULL,22500.00,2425.00,2295.00,NULL,1);



