USE `jiddain_product_db`;

ALTER TABLE `stationary_products`
  ADD COLUMN IF NOT EXISTS `minimum_bulk_order` INT UNSIGNED NULL AFTER `note`,
  ADD COLUMN IF NOT EXISTS `features` TEXT NULL AFTER `minimum_bulk_order`,
  ADD COLUMN IF NOT EXISTS `made_by` VARCHAR(255) NULL AFTER `features`,
  ADD COLUMN IF NOT EXISTS `care_instructions` TEXT NULL AFTER `made_by`,
  ADD COLUMN IF NOT EXISTS `ideal_for` TEXT NULL AFTER `care_instructions`,
  ADD COLUMN IF NOT EXISTS `secondary_price` DECIMAL(10,2) NULL AFTER `ideal_for`,
  ADD COLUMN IF NOT EXISTS `secondary_price_label` VARCHAR(120) NULL AFTER `secondary_price`;

ALTER TABLE `handmade_products`
  ADD COLUMN IF NOT EXISTS `minimum_bulk_order` INT UNSIGNED NULL AFTER `note`,
  ADD COLUMN IF NOT EXISTS `features` TEXT NULL AFTER `minimum_bulk_order`,
  ADD COLUMN IF NOT EXISTS `made_by` VARCHAR(255) NULL AFTER `features`,
  ADD COLUMN IF NOT EXISTS `care_instructions` TEXT NULL AFTER `made_by`,
  ADD COLUMN IF NOT EXISTS `ideal_for` TEXT NULL AFTER `care_instructions`,
  ADD COLUMN IF NOT EXISTS `secondary_price` DECIMAL(10,2) NULL AFTER `ideal_for`,
  ADD COLUMN IF NOT EXISTS `secondary_price_label` VARCHAR(120) NULL AFTER `secondary_price`;

ALTER TABLE `cleaning_products`
  ADD COLUMN IF NOT EXISTS `minimum_bulk_order` INT UNSIGNED NULL AFTER `note`,
  ADD COLUMN IF NOT EXISTS `features` TEXT NULL AFTER `minimum_bulk_order`,
  ADD COLUMN IF NOT EXISTS `made_by` VARCHAR(255) NULL AFTER `features`,
  ADD COLUMN IF NOT EXISTS `care_instructions` TEXT NULL AFTER `made_by`,
  ADD COLUMN IF NOT EXISTS `ideal_for` TEXT NULL AFTER `care_instructions`,
  ADD COLUMN IF NOT EXISTS `secondary_price` DECIMAL(10,2) NULL AFTER `ideal_for`,
  ADD COLUMN IF NOT EXISTS `secondary_price_label` VARCHAR(120) NULL AFTER `secondary_price`;

ALTER TABLE `seasonal_products`
  ADD COLUMN IF NOT EXISTS `minimum_bulk_order` INT UNSIGNED NULL AFTER `note`,
  ADD COLUMN IF NOT EXISTS `features` TEXT NULL AFTER `minimum_bulk_order`,
  ADD COLUMN IF NOT EXISTS `made_by` VARCHAR(255) NULL AFTER `features`,
  ADD COLUMN IF NOT EXISTS `care_instructions` TEXT NULL AFTER `made_by`,
  ADD COLUMN IF NOT EXISTS `ideal_for` TEXT NULL AFTER `care_instructions`,
  ADD COLUMN IF NOT EXISTS `secondary_price` DECIMAL(10,2) NULL AFTER `ideal_for`,
  ADD COLUMN IF NOT EXISTS `secondary_price_label` VARCHAR(120) NULL AFTER `secondary_price`;