wp_site_hits

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_site_hits ( hit_date DATE NOT NULL, visit_count INT UNSIGNED NOT NULL DEFAULT 0, view_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (hit_date) ) $charset_collate;"; // Post statistics table $sql[] = "CREATE TABLE IF NOT EXISTS wp_post_hits ( hit_date DATE NOT NULL, post_id BIGINT UNSIGNED NOT NULL, visit_count INT UNSIGNED NOT NULL DEFAULT 0, view_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (hit_date, post_id), KEY post_id (post_id) ) $charset_collate;"; // Referrers table $sql[] = "CREATE TABLE IF NOT EXISTS wp_referrers ( ref_id INT UNSIGNED NOT NULL AUTO_INCREMENT, ref_url VARCHAR(512) NOT NULL, ref_domain VARCHAR(255) NOT NULL, PRIMARY KEY (ref_id), UNIQUE KEY ref_domain (ref_domain) ) $charset_collate;"; // Referrer statistics table $sql[] = "CREATE TABLE IF NOT EXISTS wp_referrer_hits ( hit_date DATE NOT NULL, ref_id INT UNSIGNED NOT NULL, visit_count INT UNSIGNED NOT NULL DEFAULT 0, view_count INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (hit_date, ref_id), KEY ref_id (ref_id) ) $charset_collate;"; // Calendar table $sql[] = "CREATE TABLE IF NOT EXISTS wp_calendar ( cal_date DATE NOT NULL PRIMARY KEY ) $charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($sql as $query) { dbDelta($query);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_site_hits`;

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

Other tables from Amari Show