| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/chatblueversion/install/ |
Upload File : |
CREATE TABLE IF NOT EXISTS users (id CHAR(32) PRIMARY KEY,email VARCHAR(190) UNIQUE NOT NULL,name VARCHAR(150),avatar_url TEXT,password_hash VARCHAR(255),google_id VARCHAR(190) UNIQUE,role VARCHAR(20) DEFAULT 'user',status VARCHAR(20) DEFAULT 'active',plan VARCHAR(50) DEFAULT 'free',created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,last_login_at DATETIME NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS guest_sessions (id CHAR(32) PRIMARY KEY,token_hash CHAR(64) UNIQUE NOT NULL,question_count INT NOT NULL DEFAULT 0,ip_hash CHAR(64),converted_user_id CHAR(32),created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS conversations (id CHAR(32) PRIMARY KEY,user_id CHAR(32) NULL,guest_id CHAR(32) NULL,title VARCHAR(255) NOT NULL,openai_conversation_id VARCHAR(190),created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,INDEX(user_id),INDEX(guest_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS messages (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,conversation_id CHAR(32) NOT NULL,role VARCHAR(20) NOT NULL,content MEDIUMTEXT NOT NULL,input_tokens INT DEFAULT 0,output_tokens INT DEFAULT 0,estimated_cost_usd DECIMAL(12,6) DEFAULT 0,created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,INDEX(conversation_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS payments (id CHAR(32) PRIMARY KEY,user_id CHAR(32) NOT NULL,provider VARCHAR(30) NOT NULL,reference VARCHAR(190) UNIQUE NOT NULL,amount INT NOT NULL,currency CHAR(3) DEFAULT 'XOF',plan VARCHAR(50),status VARCHAR(30) DEFAULT 'pending',paid_at DATETIME NULL,created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,INDEX(user_id),INDEX(status)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS webhook_events (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,provider VARCHAR(30),external_id VARCHAR(190) UNIQUE,event_type VARCHAR(100),payload MEDIUMTEXT,processed TINYINT(1) DEFAULT 0,created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS knowledge_documents (id CHAR(32) PRIMARY KEY,title VARCHAR(255),country VARCHAR(100),topic VARCHAR(150),language VARCHAR(10) DEFAULT 'en',source_url TEXT,openai_file_id VARCHAR(190),status VARCHAR(30) DEFAULT 'processing',created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- split CREATE TABLE IF NOT EXISTS settings (`key` VARCHAR(100) PRIMARY KEY,`value` MEDIUMTEXT,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;