{"slug":"contributor-resume","name":"Contributor Résumé and Insights","description":"Your WordPress.org contributor résumé in one always-current block, plus plugin analytics and keyword rank tracking for your plugins and themes.","author":"Fernando Tellado","active_installs":10,"version":"1.5.2","wp_org_url":"https://wordpress.org/plugins/contributor-resume/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"cresume_stats_daily","full_table_name":"wp_cresume_stats_daily","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cresume_stats_events","full_table_name":"wp_cresume_stats_events","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cresume_stats_items","full_table_name":"wp_cresume_stats_items","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"type","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"icon","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"role","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"added","type":"date","nullable":true,"primary_key":false},{"name":"tags","type":"text","nullable":true,"primary_key":false},{"name":"reviews","type":"text","nullable":true,"primary_key":false},{"name":"reviews_seen","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"first_seen","type":"date","nullable":true,"primary_key":false},{"name":"last_seen","type":"date","nullable":true,"primary_key":false},{"name":"day","type":"date","nullable":false,"primary_key":false},{"name":"downloads","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"installs","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"downloaded","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"rating","type":"tinyint(3) unsigned","nullable":true,"primary_key":false},{"name":"num_ratings","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"ratings","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"support_threads","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"support_resolved","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"version","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"tested","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"last_updated","type":"datetime","nullable":true,"primary_key":false},{"name":"versions","type":"text","nullable":true,"primary_key":false},{"name":"lang_packs","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"lang_partial","type":"smallint(5) unsigned","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"kind","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"term","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"day","type":"date","nullable":false,"primary_key":false},{"name":"results","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"positions","type":"text","nullable":true,"primary_key":false},{"name":"top","type":"text","nullable":true,"primary_key":false},{"name":"neighbors","type":"text","nullable":true,"primary_key":false},{"name":"day","type":"date","nullable":false,"primary_key":false},{"name":"topic","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"data","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_cresume_stats_items ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, type tinyint(3) unsigned NOT NULL DEFAULT 1, slug varchar(191) NOT NULL DEFAULT '', name varchar(255) NOT NULL DEFAULT '', icon varchar(255) NOT NULL DEFAULT '', role tinyint(3) unsigned NOT NULL DEFAULT 0, added date DEFAULT NULL, tags text, reviews text, reviews_seen int(10) unsigned DEFAULT NULL, first_seen date DEFAULT NULL, last_seen date DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY type_slug (type,slug), KEY role (role) ) {$collate};\", \"CREATE TABLE wp_cresume_stats_daily ( item_id bigint(20) unsigned NOT NULL, day date NOT NULL, downloads int(10) unsigned DEFAULT NULL, installs int(10) unsigned DEFAULT NULL, downloaded bigint(20) unsigned DEFAULT NULL, rating tinyint(3) unsigned DEFAULT NULL, num_ratings int(10) unsigned DEFAULT NULL, ratings varchar(100) DEFAULT NULL, support_threads int(10) unsigned DEFAULT NULL, support_resolved int(10) unsigned DEFAULT NULL, version varchar(40) DEFAULT NULL, tested varchar(20) DEFAULT NULL, last_updated datetime DEFAULT NULL, versions text, lang_packs smallint(5) unsigned DEFAULT NULL, lang_partial smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (item_id,day), KEY day (day) ) {$collate};\", \"CREATE TABLE wp_cresume_stats_keywords ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, type tinyint(3) unsigned NOT NULL DEFAULT 1, kind tinyint(3) unsigned NOT NULL DEFAULT 1, term varchar(191) NOT NULL DEFAULT '', label varchar(191) NOT NULL DEFAULT '', created datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY type_kind_term (type,kind,term) ) {$collate};\", \"CREATE TABLE wp_cresume_stats_keyword_items ( keyword_id bigint(20) unsigned NOT NULL, item_id bigint(20) unsigned NOT NULL, created datetime DEFAULT NULL, PRIMARY KEY (keyword_id,item_id), KEY item_id (item_id) ) {$collate};\", \"CREATE TABLE wp_cresume_stats_rankings ( keyword_id bigint(20) unsigned NOT NULL, day date NOT NULL, results int(10) unsigned DEFAULT NULL, positions text, top text, neighbors text, PRIMARY KEY (keyword_id,day), KEY day (day) ) {$collate};\", \"CREATE TABLE wp_cresume_stats_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, day date NOT NULL, topic varchar(20) NOT NULL DEFAULT '', code varchar(40) NOT NULL DEFAULT '', item_id bigint(20) unsigned NOT NULL DEFAULT 0, keyword_id bigint(20) unsigned NOT NULL DEFAULT 0, data text, PRIMARY KEY (id), UNIQUE KEY event (day,topic,code,item_id,keyword_id), KEY topic_item (topic,item_id,day) ) {$collate};\", ) );"},{"table_name":"cresume_stats_keyword_items","full_table_name":"wp_cresume_stats_keyword_items","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cresume_stats_keywords","full_table_name":"wp_cresume_stats_keywords","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"cresume_stats_rankings","full_table_name":"wp_cresume_stats_rankings","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":6}