{"slug":"beplus-site-assistant","name":"Beplus Site Assistant","description":"AI chat assistant that knows your site content, plugins, themes, forms and features.","author":"Beplus","active_installs":0,"version":"2.13.2","wp_org_url":"https://wordpress.org/plugins/beplus-site-assistant/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"beplus_site_ai_banned","full_table_name":"wp_beplus_site_ai_banned","description":"Stores beplus site ai banned data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"ip","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"reason","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"expires_at","type":"BIGINT","nullable":false,"primary_key":false},{"name":"created_at","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_banned ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ip VARCHAR(64) NOT NULL, type VARCHAR(16) NOT NULL DEFAULT 'manual', reason VARCHAR(255) NOT NULL DEFAULT '', expires_at BIGINT NOT NULL DEFAULT 0, created_at BIGINT NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY ip (ip) ) $charset;\"; dbDelta( $sql3 );"},{"table_name":"beplus_site_ai_cache","full_table_name":"wp_beplus_site_ai_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"qhash","type":"CHAR(32)","nullable":false,"primary_key":false},{"name":"answer","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_cache ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, qhash CHAR(32) NOT NULL, answer LONGTEXT NOT NULL, created_at INT NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY qhash (qhash) ) $charset;\"; dbDelta( $sql6 );"},{"table_name":"beplus_site_ai_chat_log","full_table_name":"wp_beplus_site_ai_chat_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"beplus_site_ai_chunks","full_table_name":"wp_beplus_site_ai_chunks","description":"Stores beplus site ai chunks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"object_type","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"group_type","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"url","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"position","type":"INT","nullable":false,"primary_key":false},{"name":"embedding","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"FULLTEXT","type":"KEY","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_chunks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, object_type VARCHAR(32) NOT NULL DEFAULT 'post', object_id BIGINT UNSIGNED NOT NULL DEFAULT 0, group_type VARCHAR(32) NOT NULL DEFAULT 'site_content', title VARCHAR(255) NOT NULL DEFAULT '', url VARCHAR(255) NOT NULL DEFAULT '', content LONGTEXT NOT NULL, position INT NOT NULL DEFAULT 0, embedding LONGTEXT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY object (object_type, object_id), KEY group_type (group_type), KEY updated_at (updated_at), FULLTEXT KEY ft_content (title, content) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"},{"table_name":"beplus_site_ai_live_sessions","full_table_name":"wp_beplus_site_ai_live_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"visitor_name","type":"VARCHAR(128)","nullable":false,"primary_key":false},{"name":"visitor_email","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"page_url","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"client_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"session_token_hash","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_agent","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"messages","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"message_count","type":"INT","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"email_sent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"email_sent_at","type":"INT","nullable":false,"primary_key":false},{"name":"ended_at","type":"INT","nullable":false,"primary_key":false},{"name":"topics_at","type":"INT","nullable":false,"primary_key":false},{"name":"created_at","type":"INT","nullable":false,"primary_key":false},{"name":"updated_at","type":"INT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_live_sessions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(64) NOT NULL, visitor_name VARCHAR(128) NOT NULL DEFAULT '', visitor_email VARCHAR(191) NOT NULL DEFAULT '', page_url VARCHAR(255) NOT NULL DEFAULT '', client_id VARCHAR(64) NOT NULL DEFAULT '', session_token_hash CHAR(64) NOT NULL DEFAULT '', ip VARCHAR(64) NOT NULL DEFAULT '', user_agent VARCHAR(255) NOT NULL DEFAULT '', messages LONGTEXT NOT NULL, message_count INT NOT NULL DEFAULT 0, status VARCHAR(16) NOT NULL DEFAULT 'active', email_sent TINYINT(1) NOT NULL DEFAULT 0, email_sent_at INT NOT NULL DEFAULT 0, ended_at INT NOT NULL DEFAULT 0, topics_at INT NOT NULL DEFAULT 0, created_at INT NOT NULL DEFAULT 0, updated_at INT NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY session_id (session_id), KEY page_url (page_url(191)), KEY client_id (client_id), KEY updated_at (updated_at), KEY status (status), KEY ended_at (ended_at) ) $charset;\"; dbDelta( $sql8 );"},{"table_name":"beplus_site_ai_log","full_table_name":"wp_beplus_site_ai_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"ip","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"question","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"reason","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"created_at","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ip VARCHAR(64) NOT NULL DEFAULT '', question VARCHAR(500) NOT NULL DEFAULT '', status VARCHAR(16) NOT NULL DEFAULT 'ok', reason VARCHAR(32) NOT NULL DEFAULT '', created_at BIGINT NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY ip (ip), KEY created_at (created_at) ) $charset;\"; dbDelta( $sql4 );"},{"table_name":"beplus_site_ai_memory","full_table_name":"wp_beplus_site_ai_memory","description":"Stores beplus site ai memory data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"beplus_site_ai_meta","full_table_name":"wp_beplus_site_ai_meta","description":"Stores additional metadata (key-value pairs) for beplus site ai records.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"meta_key","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"meta_value","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_meta ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, meta_key VARCHAR(191) NOT NULL, meta_value LONGTEXT NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY meta_key (meta_key) ) $charset;\"; dbDelta( $sql2 );"},{"table_name":"beplus_site_ai_violations","full_table_name":"wp_beplus_site_ai_violations","description":"Stores beplus site ai violations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"ip","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"created_at","type":"BIGINT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_beplus_site_ai_violations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ip VARCHAR(64) NOT NULL DEFAULT '', created_at BIGINT NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY ip (ip) ) $charset;\"; dbDelta( $sql5 );"}],"table_count":9}