wp_atlasai_events
StaticStores atlasai events data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| visitor_hash | varchar(64) | NO |
| user_id | bigint(20) unsigned | YES |
| session_id | varchar(64) | NO |
| event_type | varchar(50) | NO |
| post_id | bigint(20) unsigned | NO |
| event_value | float | NO |
| weight | float | NO |
| meta | text | YES |
| created_at | datetime | NO |
| visitor_hash | varchar(64) | NO |
| user_id | bigint(20) unsigned | YES |
| taste_vector | longtext | NO |
| total_signals | int unsigned | YES |
| last_computed | datetime | YES |
| expires_at | datetime | YES |
| visitor_hash | varchar(64) | NO |
| user_id | bigint(20) unsigned | YES |
| recommendations | longtext | NO |
| computed_at | datetime | YES |
| expires_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_atlasai_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, visitor_hash varchar(64) NOT NULL, user_id bigint(20) unsigned DEFAULT 0, session_id varchar(64) NOT NULL, event_type varchar(50) NOT NULL, post_id bigint(20) unsigned NOT NULL DEFAULT 0, event_value float NOT NULL DEFAULT 0, weight float NOT NULL DEFAULT 1.0, meta text NULL, created_at datetime NOT NULL, PRIMARY KEY (id), KEY visitor_hash (visitor_hash), KEY user_id (user_id), KEY post_id (post_id), KEY event_type (event_type), KEY session_id (session_id), KEY created_at (created_at), KEY user_post (user_id, post_id), KEY user_signal (user_id, event_type) ) {$charset_collate};"; $pf_profiles = "CREATE TABLE IF NOT EXISTS wp_atlasai_user_profiles ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, visitor_hash varchar(64) NOT NULL, user_id bigint(20) unsigned NULL, taste_vector longtext NOT NULL, total_signals int unsigned DEFAULT 0, last_computed datetime, expires_at datetime NULL, PRIMARY KEY (id), UNIQUE KEY visitor_hash (visitor_hash), KEY user_id (user_id), KEY expires_at (expires_at) ) {$charset_collate};"; $pf_cache = "CREATE TABLE IF NOT EXISTS wp_atlasai_personalized_cache ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, visitor_hash varchar(64) NOT NULL, user_id bigint(20) unsigned NULL, recommendations longtext NOT NULL, computed_at datetime, expires_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY visitor_hash (visitor_hash), KEY user_id (user_id), KEY expires_at (expires_at) ) {$charset_collate};"; /** * Filter PersonaFlow database tables. * * Pro add-on uses this to add the user_exclusions table. * * @param array $tables Array of SQL CREATE TABLE statements. */ $pf_tables = apply_filters( 'atlas_ai_personaflow_tables', array( $pf_events, $pf_profiles, $pf_cache ) );Safe to delete?
If you have uninstalled Smart Local AI – Browser-Based Private AI Tools, 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_atlasai_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Smart Local AI – Browser-Based Private AI Tools