{"table_name":"aichat_sessions","full_table_name":"wp_aichat_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_aichat_sessions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_key VARCHAR(64) NOT NULL, user_id BIGINT UNSIGNED NULL, mode ENUM('chat','assistant') NOT NULL DEFAULT 'chat', ip_hash VARCHAR(64) NULL, user_agent VARCHAR(255) NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY session_key (session_key) ) $charset_collate;\"; // Messages table. $sql_messages = \"CREATE TABLE wp_aichat_messages ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id BIGINT UNSIGNED NOT NULL, role ENUM('user','assistant','system') NOT NULL, content LONGTEXT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY session_id (session_id) ) $charset_collate;\"; dbDelta( $sql_sessions );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_key","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"mode","type":"ENUM('chat','assistant')","nullable":false,"primary_key":false},{"name":"ip_hash","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"user_agent","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"session_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"role","type":"ENUM('user','assistant','system')","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"chatwick","name":"Chatwick","active_installs":0,"version":"1.10.0","wp_org_url":"https://wordpress.org/plugins/chatwick/"}}