{"slug":"archivist-ai","name":"Archivist AI – AI Search & Chatbot for Your Articles","description":"AI search and chatbot for your articles. Readers ask questions and get answers from your own posts, with sources cited. No login required.","author":"archivistai","active_installs":0,"version":"0.7.0","wp_org_url":"https://wordpress.org/plugins/archivist-ai/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"arcai_chunks","full_table_name":"wp_arcai_chunks","description":"Stores arcai chunks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"chunk_index","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"embedding","type":"LONGBLOB","nullable":true,"primary_key":false},{"name":"token_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"post_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"event_type","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"tokens_in","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"tokens_out","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"cost","type":"DECIMAL(12,6)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_arcai_chunks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL, chunk_index SMALLINT UNSIGNED NOT NULL DEFAULT 0, content LONGTEXT NOT NULL, embedding LONGBLOB NULL, token_count INT UNSIGNED NOT NULL DEFAULT 0, post_date DATETIME NOT NULL, PRIMARY KEY (id), KEY post_id (post_id), KEY post_date (post_date) ) $charset_collate;\"; $usage = \"CREATE TABLE wp_arcai_usage ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, created_at DATETIME NOT NULL, event_type VARCHAR(32) NOT NULL, tokens_in INT UNSIGNED NOT NULL DEFAULT 0, tokens_out INT UNSIGNED NOT NULL DEFAULT 0, cost DECIMAL(12,6) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY created_at (created_at) ) $charset_collate;\"; dbDelta( $chunks );"},{"table_name":"arcai_usage","full_table_name":"wp_arcai_usage","description":"Stores arcai usage data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":2}