-- Tables are created automatically by webhook.php. This file is optional.
CREATE TABLE IF NOT EXISTS anime_filters(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,anime_name VARCHAR(190) NOT NULL,search_key VARCHAR(190) NOT NULL,sticker_file_id VARCHAR(255) NOT NULL,caption TEXT NULL,created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,INDEX(search_key)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS anime_filter_buttons(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,filter_id BIGINT UNSIGNED NOT NULL,button_text VARCHAR(64) NOT NULL,button_url TEXT NOT NULL,button_style VARCHAR(16) NOT NULL DEFAULT 'primary',sort_order INT NOT NULL DEFAULT 0,FOREIGN KEY(filter_id) REFERENCES anime_filters(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS anime_filter_stats(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,filter_id BIGINT UNSIGNED NOT NULL,user_id BIGINT NOT NULL,chat_id BIGINT NOT NULL,requested_at DATETIME NOT NULL,INDEX(requested_at),INDEX(filter_id,requested_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS anime_welcome(id TINYINT UNSIGNED PRIMARY KEY,photo_file_id VARCHAR(255) NULL,photo_spoiler TINYINT(1) NOT NULL DEFAULT 0,caption TEXT NOT NULL,buttons_json LONGTEXT NULL,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS anime_pending_actions(user_id BIGINT PRIMARY KEY,action VARCHAR(40) NOT NULL,data_json LONGTEXT NULL,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS anime_auto_delete_queue(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,chat_id BIGINT NOT NULL,message_id BIGINT NOT NULL,delete_at DATETIME NOT NULL,status VARCHAR(16) NOT NULL DEFAULT 'pending',attempts INT NOT NULL DEFAULT 0,last_error TEXT NULL,INDEX(status,delete_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS anime_processed_updates(update_id BIGINT PRIMARY KEY,processed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT IGNORE INTO anime_welcome(id,caption,buttons_json) VALUES(1,'Welcome! Add me to your group to search anime.','[]');