-- Schema and seed for line_item_african_map_mount
CREATE TABLE IF NOT EXISTS `line_item_african_map_mount` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(32) NOT NULL,           -- Add-On
  `name` VARCHAR(255) NOT NULL,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Seed: Add-Ons
INSERT INTO `line_item_african_map_mount`
(`category`, `name`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Add-On', 'Open mouth (references the animal processing types & animal price)', NULL, NULL, NULL, NULL, NULL, 1),
('Add-On', 'Africa frame - Medium', NULL, NULL, NULL, NULL, NULL, 1),
('Add-On', 'Africa frame - Large', NULL, NULL, NULL, NULL, NULL, 1);



