wp_ai_chat_sessions
StaticStores session data for tracking user or visitor state.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| session_id | varchar(100) | NO |
| visitor_name | varchar(100) | NO |
| wa_number | varchar(20) | NO |
| varchar(100) | NO | |
| status | varchar(20) | NO |
| agent_id | varchar(50) | NO |
| updated_at | datetime | NO |
| session_id | varchar(100) | NO |
| sender_type | varchar(20) | NO |
| message_text | text | NO |
| created_at | datetime | NO |
| created_at | datetime | NO |
| visitor_name | varchar(100) | NO |
| wa_number | varchar(20) | NO |
| source_page | varchar(255) | NO |
| last_question | text | YES |
| status | varchar(30) | NO |
| joined_at | datetime | NO |
| visitor_name | varchar(100) | NO |
| wa_number | varchar(20) | NO |
| varchar(100) | NO | |
| source | varchar(20) | NO |
| event_date | date | NO |
| event_type | varchar(50) | NO |
| event_value | float | NO |
| event_meta | varchar(255) | NO |
| session_id | varchar(100) | YES |
CREATE TABLE Statement
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 );
Safe to delete?
If you have uninstalled Vectralix AI Chat – Failsafe AI Assistant & Live Chat Console, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_ai_chat_sessions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Vectralix AI Chat – Failsafe AI Assistant & Live Chat Console