-- Schema and seed for line_item_skulls
CREATE TABLE IF NOT EXISTS `line_item_skulls` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(32) NOT NULL,           -- Type, Add-On, Special Base
  `name` VARCHAR(255) NOT NULL,
  `surcharge_pct` DECIMAL(6,4) NULL,         -- positive = surcharge, negative = discount
  `notes` TEXT 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_category_name` (`category`, `name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Seed: Types
INSERT INTO `line_item_skulls`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Type', 'Boil & Bleach only - Skull with Horns (Ready for display)', -0.5000, 'less -50% of base price', 1),
('Type', 'Boil & Bleach only - Skull with Set of Tusks (Ready for display)', -0.5000, 'less -50% of base price', 1),
('Type', 'Boil & Bleach only - Skull only (Ready for display)', -0.5000, 'less -50% of base price', 1),
('Type', 'European Skull mount / Full Skull on shield (From Base Price List)', NULL, 'From Base Price List', 1),
('Type', 'Skull mount (From Base Price List)', NULL, 'From Base Price List', 1),
('Type', 'Skull on shield (same price as boil & bleach only)', -0.5000, 'less -50% of base price', 1);

-- Seed: Add-Ons (TBC)
INSERT INTO `line_item_skulls`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Add-On', 'Carving', NULL, 'own price', 1),
('Add-On', 'Bronzed', 0.3000, 'surcharge 30%', 1),
('Add-On', 'Bronze patina', 0.3000, 'surcharge 30%', 1),
('Add-On', 'Pedestal mount', 0.3000, 'surcharge 30% - TBC', 1);

-- Seed: Special Base (applies to European/Full skull option only)
INSERT INTO `line_item_skulls`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Special Base', 'Africa shape shield for skullmount', 0.6000, '60% surcharge on skullmount price. For any animal. Applies to European/Full skull option only.', 1),
('Special Base', 'Sleeperwood', 0.4000, '40% surcharge on skullmount. For any animal. Applies to European/Full skull option only.', 1);



