{"slug":"kbucket","name":"KBucket: Your Curated Content in WordPress","description":"Turn curated content into stunning galleries, carousels, and grids on your WordPress site.","author":"Optimal Access","active_installs":10,"version":"5.2.2","wp_org_url":"https://wordpress.org/plugins/kbucket/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"author_alias","full_table_name":"wp_author_alias","description":"Stores author alias data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS wp_author_alias ( // author varchar(100) NOT NULL, // alias varchar(100) DEFAULT NULL // ) ENGINE"},{"table_name":"kb_category","full_table_name":"wp_kb_category","description":"Stores kb category data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_cat","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"alias_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"image","type":"text","nullable":true,"primary_key":false},{"name":"parent_cat","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"level","type":"bigint(3)","nullable":true,"primary_key":false},{"name":"add_date","type":"date","nullable":true,"primary_key":false},{"name":"status","type":"enum( '0','1' )","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kb_category ( id_cat varchar(100) NOT NULL, name varchar(50) DEFAULT NULL, alias_name varchar(255) DEFAULT NULL, description text, image text, parent_cat varchar(100) DEFAULT '0', level bigint(3) DEFAULT NULL, add_date date DEFAULT NULL, keywords varchar(255) DEFAULT NULL, status enum( '0','1' ) DEFAULT '1', PRIMARY KEY (id_cat), UNIQUE KEY id_cat (id_cat,name,parent_cat) ) ENGINE"},{"table_name":"kb_files","full_table_name":"wp_kb_files","description":"Stores kb files data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_file","type":"int(9)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"comment","type":"text","nullable":true,"primary_key":false},{"name":"encoding","type":"text","nullable":false,"primary_key":false},{"name":"publisher","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"author","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"file_added","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"file_path","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kb_files ( id_file int(9) NOT NULL AUTO_INCREMENT, name varchar(100) DEFAULT NULL, comment text DEFAULT NULL, encoding text NOT NULL, publisher varchar(255) DEFAULT NULL, author varchar(50) DEFAULT NULL, keywords text DEFAULT NULL, file_added varchar(100) DEFAULT NULL, file_path varchar(255) DEFAULT NULL, PRIMARY KEY (id_file) ) ENGINE"},{"table_name":"kb_page_settings","full_table_name":"wp_kb_page_settings","description":"Stores kb page settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kb_page_settings ( // id_page int(3) NOT NULL AUTO_INCREMENT, // api_key varchar(255) DEFAULT NULL, // api_trial varchar(2) DEFAULT NULL, // kb_share_popap text NOT NULL, // api_user_id varchar(255) DEFAULT NULL, // sort_by varchar(10) DEFAULT NULL, // sort_order varchar(10) DEFAULT NULL, // no_listing_perpage int(4) DEFAULT NULL, // main_no_tags int(4) DEFAULT NULL, // author_no_tags int(4) DEFAULT NULL, // related_no_tags int(4) DEFAULT NULL, // main_tag_color1 varchar(10) DEFAULT NULL, // main_tag_color2 varchar(10) DEFAULT NULL, // author_tag_color1 varchar(10) DEFAULT NULL, // author_tag_color2 varchar(10) DEFAULT NULL, // related_tag_color1 varchar(10) DEFAULT NULL, // related_tag_color2 varchar(10) DEFAULT NULL, // author_tag_display enum( '0','1' ) DEFAULT '1', // header_color varchar(10) DEFAULT NULL, // author_color varchar(10) DEFAULT NULL, // content_color varchar(10) DEFAULT NULL, // tag_color varchar(10) DEFAULT NULL, // status enum( '0','1' ) DEFAULT '1', // page_title varchar(50) DEFAULT NULL, // site_search int(1) DEFAULT NULL, // m1 int(4) DEFAULT NULL, // m2 int(4) DEFAULT NULL, // m3 int(4) DEFAULT NULL, // m4 int(4) DEFAULT NULL, // a1 int(4) DEFAULT NULL, // a2 int(4) DEFAULT NULL, // a3 int(4) DEFAULT NULL, // a4 int(4) DEFAULT NULL, // r1 int(4) DEFAULT NULL, // r2 int(4) DEFAULT NULL, // r3 int(4) DEFAULT NULL, // r4 int(4) DEFAULT NULL, // bitly_username varchar(255) NOT NULL, // bitly_key varchar(255) NOT NULL, // vc enum( '0','1' ) DEFAULT '0', // PRIMARY KEY (id_page) // ) ENGINE"},{"table_name":"kb_suggest","full_table_name":"wp_kb_suggest","description":"Stores kb suggest data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_sug","type":"int(2)","nullable":false,"primary_key":true},{"name":"id_cat","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"tittle","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"tags","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"add_date","type":"date","nullable":true,"primary_key":false},{"name":"author","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"link","type":"text","nullable":true,"primary_key":false},{"name":"twitter","type":"text","nullable":true,"primary_key":false},{"name":"facebook","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"enum( '0','1' )","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kb_suggest ( id_sug int(2) NOT NULL AUTO_INCREMENT, id_cat varchar(100) DEFAULT NULL, tittle varchar(50) DEFAULT NULL, description text NOT NULL, tags varchar(200) NOT NULL, add_date date DEFAULT NULL, author varchar(50) DEFAULT NULL, link text, twitter text, facebook text, status enum( '0','1' ) DEFAULT '1', PRIMARY KEY (id_sug) ) ENGINE"},{"table_name":"kb_tag_details","full_table_name":"wp_kb_tag_details","description":"Stores kb tag details data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_tag","type":"int(3)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"status","type":"enum( '0','1' )","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kb_tag_details ( id_tag int(3) NOT NULL AUTO_INCREMENT, name varchar(50) DEFAULT NULL, status enum( '0','1' ) DEFAULT '1', PRIMARY KEY (id_tag), UNIQUE KEY name_index (name) ) ENGINE"},{"table_name":"kb_tags","full_table_name":"wp_kb_tags","description":"Stores kb tags data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_ktags","type":"int(3)","nullable":false,"primary_key":true},{"name":"id_kbucket","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"id_tag","type":"int(3)","nullable":true,"primary_key":false},{"name":"status","type":"enum( '0','1' )","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kb_tags ( id_ktags int(3) NOT NULL AUTO_INCREMENT, id_kbucket varchar(100) DEFAULT NULL, id_tag int(3) DEFAULT NULL, status enum( '0','1' ) DEFAULT '1', PRIMARY KEY (id_ktags), UNIQUE KEY id_kbucket_id_tag_index (id_kbucket,id_tag) ) ENGINE"},{"table_name":"kbucket","full_table_name":"wp_kbucket","description":"Stores kbucket data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id_kbucket","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"id_cat","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"title","type":"text","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"link","type":"text","nullable":true,"primary_key":false},{"name":"author","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"publisher","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"author_alias","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"publisher_alias","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"facebook","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"twitter","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"pub_date","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"add_date","type":"date","nullable":true,"primary_key":false},{"name":"status","type":"enum( '0','1' )","nullable":true,"primary_key":false},{"name":"image_url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"short_url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"url_kbucket","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_kbucket ( id_kbucket varchar(100) NOT NULL, id_cat varchar(100) DEFAULT NULL, title text, description text NOT NULL, link text, author varchar(50) DEFAULT NULL, publisher varchar(255) DEFAULT NULL, author_alias varchar(255) DEFAULT NULL, publisher_alias varchar(255) DEFAULT NULL, facebook varchar(200) NOT NULL, twitter varchar(200) NOT NULL, pub_date varchar(100) DEFAULT NULL, add_date date DEFAULT NULL, status enum( '0','1' ) DEFAULT '1', image_url varchar(255) DEFAULT '', short_url varchar(255) DEFAULT '', post_id int(11) DEFAULT NULL, url_kbucket varchar(255), PRIMARY KEY (id_kbucket), UNIQUE KEY id_kbucket_id_cat_index (id_kbucket,id_cat) ) ENGINE"}],"table_count":8}