{"slug":"chatwick","name":"Chatwick","description":"Add an AI chatbot to any WordPress site, powered by the Chatwick Cloud service, with no AI API key to manage.","author":"Massamba MBAYE","active_installs":0,"version":"1.10.0","wp_org_url":"https://wordpress.org/plugins/chatwick/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aichat_logs","full_table_name":"wp_aichat_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_messages","full_table_name":"wp_aichat_messages","description":"Stores aichat messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"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","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}],"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 );"}],"table_count":3}