wp_followers

Static

Stores followers data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idbigint(20)NO
user_idbigint(20)NO
followers_idbigint(20)NO
followers_screen_namevarchar(100)NO
followers_namevarchar(100)NO
followers_descriptionvarchar(255)NO
followers_countint(11)NO
friends_countint(11)NO
statuses_countvarchar(100)NO
locationvarchar(255)NO
descriptionvarchar(255)NO
profile_image_urlvarchar(255)NO
created_atvarchar(255)NO
followers_full_infotextNO
direct_notify_sentint(1)NO
fetched_to_notifyint(1)NO
enable_notificationsint(1)NO

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled KI Twitter Analytics, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_followers`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from KI Twitter Analytics