-- Migration to add Transactions and System Settings
CREATE TABLE IF NOT EXISTS transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    player_id INT NOT NULL,
    amount DECIMAL(20, 8) NOT NULL,
    type ENUM('deposit', 'withdraw', 'bet', 'win') NOT NULL,
    status ENUM('pending', 'completed', 'failed') DEFAULT 'completed',
    description VARCHAR(255) DEFAULT '',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (player_id) REFERENCES players(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS system_settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    `key` VARCHAR(64) UNIQUE NOT NULL,
    `value` TEXT NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Seed Default Currency Setting
INSERT IGNORE INTO system_settings (`key`, `value`) VALUES ('currency_symbol', '₹');
INSERT IGNORE INTO system_settings (`key`, `value`) VALUES ('currency_code', 'INR');