wp_aichat_sessions
StaticStores session data for tracking user or visitor state.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| session_key | VARCHAR(64) | NO |
| user_id | BIGINT UNSIGNED | YES |
| mode | ENUM('chat','assistant') | NO |
| ip_hash | VARCHAR(64) | YES |
| user_agent | VARCHAR(255) | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| session_id | BIGINT UNSIGNED | NO |
| role | ENUM('user','assistant','system') | NO |
| content | LONGTEXT | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
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 );Safe to delete?
If you have uninstalled Chatwick, 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_aichat_sessions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Chatwick