wp_assi_user
StaticStores assi user data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| blog_user_token | varchar(255) | NO |
| blog_user_id | int(11) | NO |
| register_date | DATETIME | NO |
| blog_user_id | INT | YES |
| type | VARCHAR(50) | NO |
| request_id | VARCHAR(100) | YES |
| status | TINYINT | NO |
| create_date | DATETIME | NO |
| notification_data | JSON | YES |
| blog_user_id | int(11) | YES |
| create_date | DATETIME | NO |
| last_mod_date | DATETIME | NO |
| prompt_name | VARCHAR(50) | NO |
| custom_prompt | JSON | YES |
| blog_access | TINYINT | NO |
| blog_user_id | int(11) | YES |
| is_system | TINYINT | NO |
| template_id | int(11) | NO |
| type | VARCHAR(50) | NO |
| category | VARCHAR(50) | NO |
| create_date | DATETIME | NO |
| data | JSON | YES |
CREATE TABLE Statement
CREATE TABLE `wp_assi_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_user_token` varchar(255) NOT NULL, `blog_user_id` int(11) NOT NULL, `register_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`), INDEX `blog_user_token` (`blog_user_token`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1;", 'columns' => [ 'id' => 'int(11) NOT NULL AUTO_INCREMENT', 'blog_user_token' => 'varchar(255) NOT NULL', 'blog_user_id' => 'int(11) NOT NULL', 'register_date' => 'DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP', ] ], "wp_assi_user_notifications" => [ 'sql' => "CREATE TABLE `wp_assi_user_notifications` ( `notification_id` INT NOT NULL, `blog_user_id` INT NULL DEFAULT NULL, `type` VARCHAR(50) NOT NULL, `request_id` VARCHAR(100) NULL DEFAULT NULL, `status` TINYINT NOT NULL DEFAULT '2', `create_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `notification_data` JSON NULL DEFAULT NULL, UNIQUE (`notification_id`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;", 'columns' => [ 'notification_id' => 'INT NOT NULL', 'blog_user_id' => 'INT NULL DEFAULT NULL', 'type' => 'VARCHAR(50) NOT NULL', 'request_id' => 'VARCHAR(100) NULL DEFAULT NULL', 'status' => 'TINYINT NOT NULL DEFAULT \'2\'', 'create_date' => 'DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP', 'notification_data' => 'JSON NULL DEFAULT NULL', ] ], "wp_assi_user_templates" => [ 'sql' => "CREATE TABLE `wp_assi_user_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_user_id` int(11) NULL DEFAULT NULL, `create_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_mod_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `prompt_name` VARCHAR(50) NOT NULL, `custom_prompt` JSON NULL DEFAULT NULL, `blog_access` TINYINT NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;", 'columns' => [ 'id' => 'int(11) NOT NULL AUTO_INCREMENT', 'blog_user_id' => 'int(11) NULL DEFAULT NULL', 'create_date' => 'DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP', 'last_mod_date' => 'DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP', 'prompt_name' => 'VARCHAR(50) NOT NULL', 'custom_prompt' => 'JSON NULL DEFAULT NULL', 'blog_access' => 'TINYINT NOT NULL DEFAULT \'0\'', ] ], "wp_assi_user_history" => [ 'sql' => "CREATE TABLE `wp_assi_user_history` ( `request_id` VARCHAR(50) NOT NULL, `blog_user_id` int(11) NULL DEFAULT NULL, `is_system` TINYINT NOT NULL DEFAULT '0', `template_id` int(11) NOT NULL, `type` VARCHAR(50) NOT NULL, `category` VARCHAR(50) NOT NULL, `create_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `data` JSON NULL DEFAULT NULL, UNIQUE (`request_id`), INDEX `blog_user_id` (`blog_user_id`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;", 'columns' => [ 'request_id' => 'VARCHAR(50) NOT NULL', 'blog_user_id' => 'int(11) NULL DEFAULT NULL', 'is_system' => 'TINYINT NOT NULL DEFAULT \'0\'', 'template_id' => 'int(11) NOT NULL', 'type' => 'VARCHAR(50) NOT NULL', 'category' => 'VARCHAR(50) NOT NULL', 'create_date' => 'DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP', 'data' => 'JSON NULL DEFAULT NULL', ] ], ]; foreach ($tables as $table_name => $table_data) { maybe_create_table($table_name, $table_data['sql']);Safe to delete?
If you have uninstalled Assistini – WP AI Text Writer, Content Generator, Auto Image Generator and SEO Optimizer with ChatGPT, 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_assi_user`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Assistini – WP AI Text Writer, Content Generator, Auto Image Generator and SEO Optimizer with ChatGPT