{"table_name":"ai_chat_sessions","full_table_name":"wp_ai_chat_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_wp_ai_chat_sessions ( session_id varchar(100) NOT NULL, visitor_name varchar(100) NOT NULL, wa_number varchar(20) NOT NULL, email varchar(100) DEFAULT '' NOT NULL, status varchar(20) DEFAULT 'ai_handling' NOT NULL, agent_id varchar(50) DEFAULT '' NOT NULL, updated_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (session_id) ) $charset_collate;\"; $sql_messages = \"CREATE TABLE wp_wp_ai_chat_messages ( id bigint(20) NOT NULL AUTO_INCREMENT, session_id varchar(100) NOT NULL, sender_type varchar(20) NOT NULL, message_text text NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; $sql_logs = \"CREATE TABLE wp_wp_ai_chat_logs ( id bigint(20) NOT NULL AUTO_INCREMENT, created_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, visitor_name varchar(100) NOT NULL, wa_number varchar(20) NOT NULL, source_page varchar(255) NOT NULL, last_question text, status varchar(30) DEFAULT 'Handled by AI' NOT NULL, PRIMARY KEY (id) ) $charset_collate;\"; $sql_contacts = \"CREATE TABLE wp_wp_ai_chat_contacts ( id bigint(20) NOT NULL AUTO_INCREMENT, joined_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, visitor_name varchar(100) NOT NULL, wa_number varchar(20) NOT NULL, email varchar(100) DEFAULT '' NOT NULL, source varchar(20) DEFAULT '' NOT NULL, PRIMARY KEY (id), UNIQUE KEY wa_number (wa_number) ) $charset_collate;\"; $sql_analytics = \"CREATE TABLE wp_wp_ai_chat_analytics ( id bigint(20) NOT NULL AUTO_INCREMENT, event_date date NOT NULL, event_type varchar(50) NOT NULL, event_value float DEFAULT 1 NOT NULL, event_meta varchar(255) DEFAULT '' NOT NULL, session_id varchar(100) DEFAULT '', PRIMARY KEY (id), KEY event_date (event_date) ) $charset_collate;\"; dbDelta( $sql_sessions );","columns":[{"name":"session_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"visitor_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"wa_number","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"agent_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"session_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"sender_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message_text","type":"text","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"visitor_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"wa_number","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"source_page","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_question","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"joined_at","type":"datetime","nullable":false,"primary_key":false},{"name":"visitor_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"wa_number","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"event_date","type":"date","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"event_value","type":"float","nullable":false,"primary_key":false},{"name":"event_meta","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"session_id","type":"varchar(100)","nullable":true,"primary_key":false}],"plugin":{"slug":"vectralix-ai-chat","name":"Vectralix AI Chat – Failsafe AI Assistant & Live Chat Console","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/vectralix-ai-chat/"}}