-- Schema and seed for line_item_full_mount
CREATE TABLE IF NOT EXISTS `line_item_full_mount` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(32) NOT NULL,           -- Base Type, Standard Pose, Special Pose, Looking Direction, Expression, Add-On
  `base_type` VARCHAR(32) NULL,              -- Optional association: Wall, Table, Floor
  `name` VARCHAR(255) NOT NULL,              -- Item name/label
  `surcharge_pct` DECIMAL(5,4) NULL,         -- e.g., 0.1500 for 15%
  `notes` TEXT NULL,
  `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_category_name` (`category`, `name`),
  KEY `idx_base_type` (`base_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Seed: Base Types
INSERT INTO `line_item_full_mount`
(`category`, `base_type`, `name`, `surcharge_pct`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Base Type', 'Wall', 'Wall base', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Base Type', 'Table', 'Table base', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Base Type', 'Floor', 'Floor base', NULL, NULL, NULL, NULL, NULL, NULL, 1);

-- Seed: Standard Poses
INSERT INTO `line_item_full_mount`
(`category`, `base_type`, `name`, `surcharge_pct`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Standard Pose', 'Wall', 'As is', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', 'Table', 'Climbing (up a branch)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', 'Table', 'Jumping', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', 'Floor', 'Climbing (up a rock)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', 'Floor', 'Jumping (to catch prey)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Crouch', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Hanging (from branch)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Howling', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Lying down', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Lying down (flat)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Lying down (on branch)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Sitting', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Standing', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Standing (feet together)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Standing (on hind legs)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Standing (on hind legs & forearm on branch)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Swimming (sand habitat)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Trot', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Wings closed', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Standard Pose', NULL, 'Wings open', NULL, NULL, NULL, NULL, NULL, NULL, 1);

-- Seed: Special Poses (surcharge 15%)
INSERT INTO `line_item_full_mount`
(`category`, `base_type`, `name`, `surcharge_pct`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Special Pose', NULL, 'Back legs kick into air', 0.1500, 'Surcharge applies', NULL, NULL, NULL, NULL, 1),
('Special Pose', NULL, 'Jumping', 0.1500, 'Surcharge applies', NULL, NULL, NULL, NULL, 1),
('Special Pose', NULL, 'Jumping (to catch prey)', 0.1500, 'Surcharge applies', NULL, NULL, NULL, NULL, 1),
('Special Pose', NULL, 'Raised on back leg', 0.1500, 'Surcharge applies', NULL, NULL, NULL, NULL, 1);

-- Seed: Looking Direction
INSERT INTO `line_item_full_mount`
(`category`, `base_type`, `name`, `surcharge_pct`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Looking Direction', NULL, 'Look best side', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Looking Direction', NULL, 'Look left', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Looking Direction', NULL, 'Look left - slightly', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Looking Direction', NULL, 'Look right', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Looking Direction', NULL, 'Look right - slightly', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Looking Direction', NULL, 'Look straight', NULL, NULL, NULL, NULL, NULL, NULL, 1);

-- Seed: Expression
INSERT INTO `line_item_full_mount`
(`category`, `base_type`, `name`, `surcharge_pct`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Expression', NULL, 'Aggressive', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Expression', NULL, 'Alert', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Expression', NULL, 'Attack', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Expression', NULL, 'Defensive', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Expression', NULL, 'Natural / Relaxed', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Expression', NULL, 'Proud', NULL, NULL, NULL, NULL, NULL, NULL, 1);

-- Seed: Add-Ons
INSERT INTO `line_item_full_mount`
(`category`, `base_type`, `name`, `surcharge_pct`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Add-On', NULL, 'Open mouth (relates to animal processing type add-on)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Add-On', NULL, 'Waiter pose (restrict to only Warthog & Baboon)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
('Add-On', NULL, 'Serving plate for waiter pose', NULL, NULL, NULL, NULL, NULL, NULL, 1);



