{"table_name":"assi_user","full_table_name":"wp_assi_user","description":"Stores assi user data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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']);","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"blog_user_token","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"register_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"INT","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"request_id","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"status","type":"TINYINT","nullable":false,"primary_key":false},{"name":"create_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"notification_data","type":"JSON","nullable":true,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"create_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_mod_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"prompt_name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"custom_prompt","type":"JSON","nullable":true,"primary_key":false},{"name":"blog_access","type":"TINYINT","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"is_system","type":"TINYINT","nullable":false,"primary_key":false},{"name":"template_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"category","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"create_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"data","type":"JSON","nullable":true,"primary_key":false}],"plugin":{"slug":"assistini","name":"Assistini – WP AI Text Writer, Content Generator, Auto Image Generator and SEO Optimizer with ChatGPT","active_installs":80,"version":"2.4.1","wp_org_url":"https://wordpress.org/plugins/assistini/"}}