-- Schema and seed for line_item_pedestal_bases
CREATE TABLE IF NOT EXISTS `line_item_pedestal_bases` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `item` VARCHAR(255) NOT NULL,
  `category` VARCHAR(64) NOT NULL,
  `internal_note_applicable_to` VARCHAR(255) NULL,
  `price_usd` DECIMAL(10,2) NULL,
  `price_eur` DECIMAL(10,2) NULL,
  `price_zar` 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` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `line_item_pedestal_bases`
(`item`, `category`, `internal_note_applicable_to`, `price_usd`, `price_eur`, `price_zar`, `price_bwp`, `is_active`)
VALUES
('Hexagonal base 400mm', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Hexagonal base 400mm with habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Large square base with open shelf', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Large square base with open shelf with habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Octagonal base 400mm', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Octagonal base 400mm with habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Octagonal giraffe base solid top', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Octagonal giraffe base with standard habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Rustic base - Extra large (buffalo, eland etc.)', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Rustic base - Large (kudu, gemsbok, zebra etc.)', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Rustic base - Medium (bushbuck, impala etc.)', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Rustic base - Table base (steenbok, duiker etc.)', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Square economy base - solid sides', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Square economy base - solid sides, with habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Square economy base - with recesses for skin inlays', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Square economy base - with recesses for skin inlays and habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Tapered economy base - solid sides', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Tapered economy base - solid sides, with habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Tapered economy base - with recesses for skin inlays', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Tapered economy base - with recesses for skin inlays and habitat top', 'Base + Habitat Top Surcharge', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1),
('Zulu shield 1800h with 740 x 650 Africa base and spears', 'Special Base', 'Pedestal Shoulder Mount / Standalone / Skull mount', NULL, NULL, NULL, NULL, 1);



