李建琦
6d655c9903
Release / update-version (push) Has been cancelled
Release / build-frontend (push) Has been cancelled
Release / release (push) Has been cancelled
Release / sync-version-file (push) Has been cancelled
CI / shell (push) Canceled after 0s
CI / test (push) Canceled after 0s
CI / frontend (push) Canceled after 0s
CI / golangci-lint (push) Canceled after 0s
Security Scan / backend-security (push) Canceled after 0s
Security Scan / frontend-security (push) Canceled after 0s
17 lines
891 B
SQL
17 lines
891 B
SQL
-- Add payment_mode field to payment_provider_instances
|
|
-- Values: 'redirect' (hosted page redirect), 'api' (API call for QR/payurl), '' (default/N/A)
|
|
ALTER TABLE payment_provider_instances ADD COLUMN IF NOT EXISTS payment_mode VARCHAR(20) NOT NULL DEFAULT '';
|
|
|
|
-- Migrate existing data: easypay instances with 'easypay' in supported_types → redirect mode
|
|
-- Remove 'easypay' from supported_types and set payment_mode = 'redirect'
|
|
UPDATE payment_provider_instances
|
|
SET payment_mode = 'redirect',
|
|
supported_types = TRIM(BOTH ',' FROM REPLACE(REPLACE(REPLACE(
|
|
supported_types, 'easypay,', ''), ',easypay', ''), 'easypay', ''))
|
|
WHERE provider_key = 'easypay' AND supported_types LIKE '%easypay%';
|
|
|
|
-- EasyPay instances without 'easypay' in supported_types → api mode
|
|
UPDATE payment_provider_instances
|
|
SET payment_mode = 'api'
|
|
WHERE provider_key = 'easypay' AND payment_mode = '';
|