-- v1.10 付款收款设置（Admin 后台可编辑）
-- 单行表 id=1：Google Pay 信息 / TNG 信息与二维码 / 银行账户
CREATE TABLE IF NOT EXISTS payment_settings (
    id                TINYINT UNSIGNED NOT NULL PRIMARY KEY,
    gpay_info         VARCHAR(255) NOT NULL DEFAULT '',
    tng_info          VARCHAR(255) NOT NULL DEFAULT '',
    tng_qr            VARCHAR(255) NOT NULL DEFAULT '',
    bank_name         VARCHAR(100) NOT NULL DEFAULT '',
    bank_account_name VARCHAR(100) NOT NULL DEFAULT '',
    bank_account_no   VARCHAR(100) NOT NULL DEFAULT '',
    updated_at        DATETIME NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT IGNORE INTO payment_settings
    (id, gpay_info, tng_info, tng_qr, bank_name, bank_account_name, bank_account_no, updated_at)
VALUES
    (1, '+60 12-345 6789 (JESUS AI)', '+60 12-345 6789 (JESUS AI)', '',
     'Maybank', 'Feeler Soft Enterprise', '557018552551', NOW());