{"slug":"ki-twitter-analytics","name":"KI Twitter Analytics","description":"KI Twitter Analytics provides users with free analysis of their twitter account inbox, incoming messages, outgoing messages, mentions and other statis …","author":"whassan","active_installs":0,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/ki-twitter-analytics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"followers","full_table_name":"wp_followers","description":"Stores followers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"followers_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"followers_screen_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"followers_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"followers_description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"followers_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"friends_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"statuses_count","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"profile_image_url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"followers_full_info","type":"text","nullable":false,"primary_key":false},{"name":"direct_notify_sent","type":"int(1)","nullable":false,"primary_key":false},{"name":"fetched_to_notify","type":"int(1)","nullable":false,"primary_key":false},{"name":"enable_notifications","type":"int(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `followers`( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NOT NULL, `followers_id` bigint(20) NOT NULL, `followers_screen_name` varchar(100) NOT NULL, `followers_name` varchar(100) NOT NULL, `followers_description` varchar(255) NOT NULL, `followers_count` int(11) NOT NULL, `friends_count` int(11) NOT NULL, `statuses_count` varchar(100) NOT NULL, `location` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `profile_image_url` varchar(255) NOT NULL, `created_at` varchar(255) NOT NULL, `followers_full_info` text NOT NULL, `direct_notify_sent` int(1) NOT NULL DEFAULT '0', `fetched_to_notify` int(1) NOT NULL DEFAULT '0', `enable_notifications` int(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`)) ENGINE"},{"table_name":"friends","full_table_name":"wp_friends","description":"Stores friends data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(255)","nullable":false,"primary_key":true},{"name":"user_id","type":"longtext","nullable":false,"primary_key":false},{"name":"friends_id","type":"longtext","nullable":false,"primary_key":false},{"name":"friends_screen_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"friends_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"friends_description","type":"longtext","nullable":false,"primary_key":false},{"name":"followers_count","type":"int(255)","nullable":false,"primary_key":false},{"name":"friends_count","type":"int(255)","nullable":false,"primary_key":false},{"name":"statuses_count","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"profile_image_url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"friends_full_info","type":"longtext","nullable":false,"primary_key":false},{"name":"direct_notify_sent","type":"int(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `friends`( `id` int(255) NOT NULL AUTO_INCREMENT, `user_id` longtext NOT NULL, `friends_id` longtext NOT NULL, `friends_screen_name` varchar(255) NOT NULL, `friends_name` varchar(255) NOT NULL, `friends_description` longtext NOT NULL, `followers_count` int(255) NOT NULL, `friends_count` int(255) NOT NULL, `statuses_count` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `profile_image_url` varchar(255) NOT NULL, `created_at` varchar(255) NOT NULL, `friends_full_info` longtext NOT NULL, `direct_notify_sent` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE"}],"table_count":2}