-- Schema and seed for line_item_pedestal_shoulder_mount
CREATE TABLE IF NOT EXISTS `line_item_pedestal_shoulder_mount` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(48) NOT NULL,           -- Variation, Special Variation, Pedestal Special Base, Add-On / Surcharge
  `name` VARCHAR(255) NOT NULL,
  `surcharge_pct` DECIMAL(6,4) NULL,         -- e.g., 0.1500 for 15%
  `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: Variations
INSERT INTO `line_item_pedestal_shoulder_mount`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Variation', 'Straight', NULL, NULL, 1),
('Variation', 'Turn best side', NULL, NULL, 1),
('Variation', 'Right 1/8 turn', NULL, NULL, 1),
('Variation', 'Right 1/4 turn', NULL, NULL, 1),
('Variation', 'Right 1/2 turn', NULL, NULL, 1),
('Variation', 'Left 1/8 turn', NULL, NULL, 1),
('Variation', 'Left 1/4 turn', NULL, NULL, 1),
('Variation', 'Left 1/2 turn', NULL, NULL, 1),
('Variation', 'Custom', NULL, NULL, 1);

-- Seed: Special Variations
INSERT INTO `line_item_pedestal_shoulder_mount`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Special Variation', 'Open wings - slight turn left', NULL, NULL, 1),
('Special Variation', 'Open wings - slight turn right', NULL, NULL, 1),
('Special Variation', 'Closed wings - slight turn left', NULL, NULL, 1),
('Special Variation', 'Closed wings - slight turn right', NULL, NULL, 1),
('Special Variation', 'Straight - trunk relaxed', NULL, NULL, 1);

-- Seed: Pedestal Special Base (optional, default is no base)
INSERT INTO `line_item_pedestal_shoulder_mount`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Pedestal Special Base', 'Reference the 11) Pedestal Base for items list', NULL, 'Optional base; default is no base', 1);

-- Seed: Add-On / Surcharge
INSERT INTO `line_item_pedestal_shoulder_mount`
(`category`, `name`, `surcharge_pct`, `notes`, `is_active`)
VALUES
('Add-On / Surcharge', 'Open mouth (references the animal processing types & animal price)', NULL, NULL, 1),
('Add-On / Surcharge', 'Habitat top surcharge 15%', 0.1500, NULL, 1);



