-- Create airtimetocash table for airtime-to-cash requests

CREATE TABLE IF NOT EXISTS airtimetocash (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sId INT NOT NULL,
    network VARCHAR(20) NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    bank_name VARCHAR(100) NULL,
    bank_account_number VARCHAR(50) NULL,
    bank_account_name VARCHAR(255) NULL,
    fee DECIMAL(10, 2) DEFAULT 0,
    screenshot_url VARCHAR(500) NULL,
    is_account_funding BOOLEAN DEFAULT 1,
    status VARCHAR(10) DEFAULT '0',
    date_created DATETIME NOT NULL,
    INDEX idx_sId (sId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
