CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id BIGINT UNIQUE,
    username VARCHAR(64),
    firstname VARCHAR(128),
    points INT DEFAULT 0,
    referrer BIGINT DEFAULT NULL,
    banned TINYINT DEFAULT 0
);

CREATE TABLE charges (
    id INT AUTO_INCREMENT PRIMARY KEY,
    operator ENUM('irancell','mci','rightel'),
    code VARCHAR(64),
    used TINYINT DEFAULT 0
);

CREATE TABLE channels (
    id INT AUTO_INCREMENT PRIMARY KEY,
    channel_username VARCHAR(64)
);