CREATE TABLE IF NOT EXISTS users(id BIGINT PRIMARY KEY, username VARCHAR(100) NULL, balance BIGINT DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS sources(id INT AUTO_INCREMENT PRIMARY KEY, slug VARCHAR(64) UNIQUE, title VARCHAR(150), active TINYINT DEFAULT 1);
INSERT IGNORE INTO sources(slug,title,active) VALUES('daramad','💰 ربات درآمد',1);
CREATE TABLE IF NOT EXISTS bots(id INT AUTO_INCREMENT PRIMARY KEY,user_id BIGINT,source_slug VARCHAR(64),token TEXT,username VARCHAR(100),owner_id BIGINT,path TEXT,status ENUM('on','off') DEFAULT 'on',created_at DATETIME);
CREATE TABLE IF NOT EXISTS bot_admins(id INT AUTO_INCREMENT PRIMARY KEY,bot_id INT,user_id BIGINT,UNIQUE(bot_id,user_id));
CREATE TABLE IF NOT EXISTS build_queue(id INT AUTO_INCREMENT PRIMARY KEY,user_id BIGINT,source_slug VARCHAR(64),token TEXT,username VARCHAR(100),owner_id BIGINT,status ENUM('queued','building','done','failed') DEFAULT 'queued',error TEXT NULL,created_at DATETIME DEFAULT CURRENT_TIMESTAMP,started_at DATETIME NULL,finished_at DATETIME NULL);
CREATE TABLE IF NOT EXISTS settings(`key` VARCHAR(100) PRIMARY KEY,`value` TEXT);
CREATE TABLE IF NOT EXISTS join_channels(id INT AUTO_INCREMENT PRIMARY KEY,channel_id VARCHAR(100),title VARCHAR(150),url TEXT,active TINYINT DEFAULT 1);
CREATE TABLE IF NOT EXISTS logs(id BIGINT AUTO_INCREMENT PRIMARY KEY,type VARCHAR(50),user_id BIGINT NULL,bot_id INT NULL,message TEXT,created_at DATETIME DEFAULT CURRENT_TIMESTAMP);