-- Schema and seed for line_item_wall_pedestal_shoulder_mount
CREATE TABLE IF NOT EXISTS `line_item_wall_pedestal_shoulder_mount` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(32) NOT NULL,           -- Variation, Add-On
  `name` VARCHAR(255) NOT NULL,
  `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_wall_pedestal_shoulder_mount`
(`category`, `name`, `notes`, `is_active`)
VALUES
('Variation', 'Left', NULL, 1),
('Variation', 'Right', NULL, 1),
('Variation', 'Turn best side', NULL, 1),
('Variation', 'Custom', NULL, 1);

-- Seed: Add-Ons
INSERT INTO `line_item_wall_pedestal_shoulder_mount`
(`category`, `name`, `notes`, `is_active`)
VALUES
('Add-On', 'Open mouth (references the animal processing types & animal price)', NULL, 1),
('Add-On', 'Special Base: Zulu shield 1800h with 740 x 650 Africa base and spears (standard size)', NULL, 1);



