-- Schema and seed for line_item_dip_pack
CREATE TABLE IF NOT EXISTS `line_item_dip_pack` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(32) NOT NULL,
  `size_type` VARCHAR(64) NULL,
  `name` VARCHAR(255) NOT NULL,
  `feet_count` TINYINT UNSIGNED 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_size` (`category`, `size_type`),
  KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `line_item_dip_pack`
(`category`, `size_type`, `name`, `feet_count`, `notes`, `price_zar`, `price_usd`, `price_eur`, `price_bwp`, `is_active`)
VALUES
('Animal','Small','Skull & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull & tusks and tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, flat skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns, cape, back skin & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, horns, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, tusks & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, tusks & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, tusks & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, tusks, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, tusks, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Skull, tusks, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Small','Cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Small','Half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull & tusks and tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, flat skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns, cape, back skin & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, horns, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, tusks & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, tusks & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, tusks & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, tusks, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, tusks, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Skull, tusks, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Medium','Cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Medium','Half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull & tusks and tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, flat skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns, cape, back skin & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, horns, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, tusks & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, tusks & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, tusks & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, tusks, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, tusks, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Skull, tusks, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Large','Cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Large','Half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull & tusks and tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, flat skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns, cape, back skin & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, horns, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, tusks & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, tusks & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, tusks & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, tusks, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, tusks, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Skull, tusks, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Extra Large','Half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull & tusks and tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, flat skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns, cape, back skin & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, horns, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, tusks & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, tusks & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, tusks & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, tusks, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, tusks, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Skull, tusks, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Crocodile/Hippo/Giraffe','Half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull & tusks and tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, flat skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns, cape, back skin & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, horns, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, tusks & cape',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, tusks & flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, tusks & full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, tusks, cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, tusks, cape & tail',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Skull, tusks, half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Flat skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Full skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Cape, back skin & feet',NULL,'Maybe a note of how many feet',NULL,1.00,NULL,NULL,1),
('Animal','Elephant','Half cape & back skin',NULL,NULL,NULL,1.00,NULL,NULL,1),
('Documentation',NULL,'Documentation fee',NULL,NULL,NULL,70.00,NULL,NULL,1),
('Documentation',NULL,'Veterinary handling',NULL,NULL,NULL,70.00,NULL,NULL,1),
('Documentation',NULL,'Courier',NULL,NULL,NULL,50.00,NULL,NULL,1),
('Documentation',NULL,'CITES tagging (if applicable)',NULL,'POA',NULL,NULL,NULL,NULL,1),
('Documentation',NULL,'Collection fee',NULL,'$1 per km',NULL,NULL,NULL,NULL,1);



