{"slug":"vectralix-ai-chat","name":"Vectralix AI Chat – Failsafe AI Assistant & Live Chat Console","description":"An efficient AI Chatbot tool for WordPress, powered by Groq. Easily handle customer support and capture leads 24/7.","author":"luxcrato","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/vectralix-ai-chat/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ai_chat_analytics","full_table_name":"wp_ai_chat_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ai_chat_contacts","full_table_name":"wp_ai_chat_contacts","description":"Stores ai chat contacts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ai_chat_logs","full_table_name":"wp_ai_chat_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ai_chat_messages","full_table_name":"wp_ai_chat_messages","description":"Stores ai chat messages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"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","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}],"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 );"}],"table_count":5}