-- این فایل رو هم از phpMyAdmin > Import اجرا کن (کنار migration_001)

CREATE TABLE IF NOT EXISTS tenant_bots (
    id INT AUTO_INCREMENT PRIMARY KEY,
    buyer_user_id INT NOT NULL,
    bot_token VARCHAR(128) NOT NULL UNIQUE,
    bot_username VARCHAR(64) NULL,
    telegram_owner_id BIGINT UNSIGNED NULL,
    status ENUM('pending_claim','active','disabled') NOT NULL DEFAULT 'pending_claim',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (buyer_user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS tenant_panels (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tenant_id INT NOT NULL,
    name VARCHAR(64) NOT NULL,
    api_url VARCHAR(255) NOT NULL,
    api_key VARCHAR(255) NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (tenant_id) REFERENCES tenant_bots(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS tenant_states (
    tenant_id INT NOT NULL,
    telegram_id BIGINT UNSIGNED NOT NULL,
    state VARCHAR(64) NOT NULL,
    data JSON NULL,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (tenant_id, telegram_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO settings (setting_key, setting_value) VALUES ('license_price', '500000')
ON DUPLICATE KEY UPDATE setting_key = setting_key;