-- Schema and seed for line_item_shoulder_mount
CREATE TABLE IF NOT EXISTS `line_item_shoulder_mount` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(32) NOT NULL,           -- Variation, Special Variation, Add-On
  `name` VARCHAR(255) NOT NULL,              -- Item name/label
  `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_shoulder_mount`
(`category`, `name`, `notes`, `is_active`)
VALUES
('Variation', 'Straight', NULL, 1),
('Variation', 'Turn best side', NULL, 1),
('Variation', 'Right 1/8 turn', NULL, 1),
('Variation', 'Right 1/4 turn', NULL, 1),
('Variation', 'Right 1/2 turn', NULL, 1),
('Variation', 'Left 1/8 turn', NULL, 1),
('Variation', 'Left 1/4 turn', NULL, 1),
('Variation', 'Left 1/2 turn', NULL, 1),
('Variation', 'Custom', NULL, 1);

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

-- Seed: Add-Ons
INSERT INTO `line_item_shoulder_mount`
(`category`, `name`, `notes`, `is_active`)
VALUES
('Add-On', 'Open mouth (references the animal processing types & animal price)', NULL, 1);



