-- v0.9 -> v0.10: take backup; run once. Existing admin accounts become Super Admin.
ALTER TABLE users MODIFY role ENUM('superadmin','admin','merchant') NOT NULL,
 ADD permissions TEXT NULL, ADD active TINYINT NOT NULL DEFAULT 1;
UPDATE users SET role='superadmin' WHERE role='admin';
ALTER TABLE clients ADD contact_phone VARCHAR(50) NOT NULL DEFAULT '', ADD address VARCHAR(1000) NOT NULL DEFAULT '',
 ADD personal_provider VARCHAR(30) NOT NULL DEFAULT 'bkash', ADD merchant_provider VARCHAR(30) NOT NULL DEFAULT 'bkash',
 ADD personal_enabled TINYINT NOT NULL DEFAULT 1, ADD merchant_enabled TINYINT NOT NULL DEFAULT 1;
UPDATE clients SET personal_provider=payment_provider,merchant_provider=payment_provider;
CREATE TABLE IF NOT EXISTS qr_assets (
 id CHAR(48) PRIMARY KEY, client_id BIGINT UNSIGNED NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, KEY ix_qr_client(client_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;