-- Shopier ödeme entegrasyonu
-- phpMyAdmin veya mysql CLI ile bir kez çalıştırın.

ALTER TABLE `orders`
  MODIFY `status` ENUM(
    'awaiting_payment',
    'queued',
    'assigned',
    'printing',
    'completed',
    'cancelled'
  ) NOT NULL DEFAULT 'awaiting_payment',
  MODIFY `paid_at` DATETIME NULL DEFAULT NULL,
  ADD COLUMN `payment_status` ENUM('pending', 'paid', 'failed', 'refunded') NOT NULL DEFAULT 'pending' AFTER `status`,
  ADD COLUMN `payment_provider` VARCHAR(32) NULL AFTER `payment_status`,
  ADD COLUMN `shopier_product_id` VARCHAR(64) NULL AFTER `payment_provider`,
  ADD COLUMN `shopier_order_id` VARCHAR(64) NULL AFTER `shopier_product_id`;

UPDATE `orders`
SET
  `payment_status` = 'paid',
  `status` = IF(`status` = 'awaiting_payment', 'queued', `status`)
WHERE `paid_at` IS NOT NULL;

INSERT INTO `settings` (`key_name`, `value_text`) VALUES
  ('payment_mode', 'shopier'),
  ('shopier_shop_slug', '3dbastir'),
  ('shopier_webhook_token', ''),
  ('shopier_osb_username', ''),
  ('shopier_osb_password', '')
ON DUPLICATE KEY UPDATE `value_text` = VALUES(`value_text`);