/*
  Add global payout/hold business settings and category-level payout overrides.
*/

INSERT INTO `cg_tbl_business_settings` (`key`, `value`)
VALUES
  ('default_provider_payout_percentage', '0'),
  ('default_platform_hold_percentage', '0'),
  ('default_hold_period_hours', '0')
ON DUPLICATE KEY UPDATE `key` = VALUES(`key`);

ALTER TABLE `cg_tbl_category_sub_category_setup`
  ADD COLUMN `custom_payout_configuration_enabled` TINYINT(1) NOT NULL DEFAULT 0 AFTER `discount_value`,
  ADD COLUMN `provider_payout_percentage` DECIMAL(5,2) NULL AFTER `custom_payout_configuration_enabled`,
  ADD COLUMN `platform_hold_percentage` DECIMAL(5,2) NULL AFTER `provider_payout_percentage`,
  ADD COLUMN `hold_period_hours` INT NULL AFTER `platform_hold_percentage`;