wp_ess_social_statistics
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| network_name | varchar(50) | NO |
| sharing_date | datetime | NO |
| post_id | bigint(20) | NO |
| ip_info | text | NO |
| ip_address | VARCHAR(200) | NO |
| share_location | VARCHAR(50) | NO |
| share_url | text | YES |
| latest_count | bigint(20) | NO |
| network_name | varchar(200) | NO |
| network_desc | longtext | YES |
| network_order | bigint(20) | NO |
| network_count | bigint(20) | NO |
| is_api_support | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE wp_ess_social_statistics ( id bigint(20) NOT NULL auto_increment, network_name varchar(50) NOT NULL, sharing_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00', post_id bigint(20) NOT NULL, ip_info text NOT NULL, ip_address VARCHAR(200) NOT NULL, share_location VARCHAR(50) NOT NULL, share_url text NULL, latest_count bigint(20) NOT NULL, PRIMARY KEY (id) ) $charset_collate; CREATE TABLE wp_ess_social_networks ( network_id bigint(20) NOT NULL auto_increment, network_name varchar(200) NOT NULL, network_desc longtext NULL, network_order bigint(20) NOT NULL, network_count bigint(20) NOT NULL DEFAULT 0, is_api_support tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (network_id), UNIQUE KEY network_name (network_name(64)) ) $charset_collate; "; return $tables; } /** * Show plugin changes. Code adapted from W3 Total Cache. */ public static function in_plugin_update_message( $args ) { $transient_name = 'ess_upgrade_notice_' . $args['Version']; $upgrade_notice = get_transient( $transient_name );Safe to delete?
If you have uninstalled Easy Social Sharing, 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_ess_social_statistics`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Easy Social Sharing