wp_friends
StaticStores friends data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(255) | NO |
| user_id | longtext | NO |
| friends_id | longtext | NO |
| friends_screen_name | varchar(255) | NO |
| friends_name | varchar(255) | NO |
| friends_description | longtext | NO |
| followers_count | int(255) | NO |
| friends_count | int(255) | NO |
| statuses_count | varchar(255) | NO |
| location | varchar(255) | NO |
| description | varchar(255) | NO |
| profile_image_url | varchar(255) | NO |
| created_at | varchar(255) | NO |
| friends_full_info | longtext | NO |
| direct_notify_sent | int(1) | NO |
CREATE TABLE Statement
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
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_friends`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from KI Twitter Analytics