wp_time_of_day

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_time_of_day ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, day_of_week TINYINT NOT NULL, minute_of_day SMALLINT UNSIGNED NOT NULL, visits_count INT UNSIGNED NOT NULL, revision_id BIGINT(20) UNSIGNED DEFAULT 0, PRIMARY KEY (id), KEY idx_minute_of_day_revision_id (minute_of_day, revision_id), UNIQUE KEY uniq_day_of_week_minute_of_day_revision_id (day_of_week, minute_of_day, revision_id) ) $collate; CREATE TABLE wp_visitor_details ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, a_day DATE NOT NULL, a_key VARCHAR(64) NOT NULL, a_value VARCHAR(512) NOT NULL, revision_id BIGINT(20) UNSIGNED DEFAULT 0, visits_count INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY idx_a_key_revision_id (a_key, revision_id), UNIQUE KEY uniq_a_day_a_key_a_value_revision_id (a_day, a_key, a_value, revision_id) ) $collate; CREATE TABLE wp_page_visits ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, a_day DATE NOT NULL, a_url VARCHAR(512) NOT NULL, post_id BIGINT(20) UNSIGNED NOT NULL, post_type VARCHAR(255) NOT NULL, unique_visits INT UNSIGNED NOT NULL, bot_visits INT UNSIGNED NOT NULL, total_visits INT UNSIGNED NOT NULL, internal_visits INT UNSIGNED NOT NULL, incoming_visits INT UNSIGNED NOT NULL, sessions INT UNSIGNED NOT NULL DEFAULT 0, bounce_rate FLOAT NOT NULL DEFAULT 0, revision_id BIGINT(20) UNSIGNED DEFAULT 0, PRIMARY KEY (id), KEY idx_post_id_revision_id (post_id, revision_id), KEY idx_a_day_unique_visits_revision_id (a_day, unique_visits, revision_id), KEY idx_a_day_post_type_unique_visits_revision_id (a_day, post_type, unique_visits, revision_id), KEY idx_a_url_a_day_revision_id (a_url, a_day, revision_id), UNIQUE KEY uniq_post_id_a_day_revision_id (post_id, a_day, revision_id) ) $collate; CREATE TABLE wp_page_visits_on_finish ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, a_day DATE NOT NULL, a_url VARCHAR(512) NOT NULL, post_id BIGINT(20) UNSIGNED NOT NULL, total_visits INT UNSIGNED NOT NULL, avg_load_time FLOAT NOT NULL, load_times_count INT UNSIGNED DEFAULT 0, max_load_time FLOAT NOT NULL, min_load_time FLOAT NOT NULL, avg_view_time FLOAT NOT NULL, view_times_count INT UNSIGNED DEFAULT 0, avg_asset_less_page_size INT UNSIGNED DEFAULT 0, avg_website_data_download_size INT UNSIGNED DEFAULT 0, avg_viewport_completed_loading_time FLOAT DEFAULT 0, viewport_completed_loading_time_count INT UNSIGNED DEFAULT 0, $web_vitals_schema revision_id BIGINT(20) UNSIGNED DEFAULT 0, post_revision_id BIGINT(20) UNSIGNED DEFAULT 0, bf_cache_on INT UNSIGNED DEFAULT 0, bf_cache_off INT UNSIGNED DEFAULT 0, PRIMARY KEY (id), KEY idx_a_day_revision_id (a_day, revision_id), KEY idx_a_url_a_day_revision_id (a_url, a_day, revision_id), KEY idx_a_url_a_day_post_revision_id_revision_id (a_url, a_day, post_revision_id, revision_id), KEY idx_post_id_a_day_revision_id (post_id, a_day, revision_id), UNIQUE KEY uniq_post_id_a_day_post_revision_id_revision_id (post_id, a_day, post_revision_id, revision_id) ) $collate; CREATE TABLE wp_search_words ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, word VARCHAR(255) NOT NULL, page_url VARCHAR(512) NOT NULL DEFAULT '', input_selector VARCHAR(512) NOT NULL DEFAULT '', `time` DATETIME DEFAULT 0, full_search TINYINT NOT NULL DEFAULT 0, revision_id BIGINT(20) UNSIGNED DEFAULT 0, PRIMARY KEY (id), KEY idx_word_revision_id (word, revision_id), KEY idx_page_url_revision_id (page_url, revision_id) ) $collate; CREATE TABLE wp_link_visits ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT(20) UNSIGNED NOT NULL, visitor_id DECIMAL(20, 0) NOT NULL, `time` DATETIME NOT NULL, `source` VARCHAR(512) NOT NULL DEFAULT '', `href` VARCHAR(512) NOT NULL DEFAULT '', `href_host` VARCHAR(512) NOT NULL DEFAULT '', `href_main_domain` VARCHAR(512) NOT NULL DEFAULT '', `href_url_params` VARCHAR(512) DEFAULT '', `external_dst` TINYINT NOT NULL DEFAULT 0, revision_id BIGINT(20) UNSIGNED DEFAULT 0, KEY idx_time_external_dst_revision_id (`time`, external_dst, revision_id), PRIMARY KEY (id) ) $collate; CREATE TABLE wp_special_url_params ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, a_day DATE NOT NULL, referer_host VARCHAR(512) NOT NULL, referer_main_domain VARCHAR(512) NOT NULL, utm_medium VARCHAR(512) NOT NULL, utm_source VARCHAR(512) NOT NULL, utm_campaign VARCHAR(512) NOT NULL, utm_term VARCHAR(512) NOT NULL, utm_content VARCHAR(512) NOT NULL, revision_id BIGINT(20) UNSIGNED DEFAULT 0, PRIMARY KEY (id), KEY idx_referer_host_revision_id (referer_host, revision_id), KEY idx_referer_main_domain_revision_id (referer_main_domain, revision_id) ) $collate; CREATE TABLE wp_sessions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, visitor_id DECIMAL(20, 0) NOT NULL, visited_pages INT UNSIGNED NOT NULL, first_time DATETIME NOT NULL, last_time DATETIME NOT NULL, bounced TINYINT NOT NULL DEFAULT 1, processed_after_finish TINYINT NOT NULL DEFAULT 0, revision_id BIGINT(20) UNSIGNED DEFAULT 0, PRIMARY KEY (id), KEY idx_visitor_id_revision_id (visitor_id, revision_id) ) $collate; CREATE TABLE wp_visitors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `time` DATETIME DEFAULT 0, visitor_id DECIMAL(20, 0) NOT NULL, `value` VARCHAR(512) NOT NULL, type VARCHAR(512) NOT NULL, PRIMARY KEY (id), KEY idx_visitor_id (visitor_id), KEY idx_visitor_id_value (visitor_id, `value`) ) $collate; CREATE TABLE wp_standard_events ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, meta_id BIGINT UNSIGNED NOT NULL, `event` VARCHAR(512) NOT NULL, at_rel BIGINT UNSIGNED DEFAULT 0, element VARCHAR(512) NOT NULL DEFAULT '', context VARCHAR(512) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY idx_event (`event`), KEY idx_at_rel (at_rel) ) $collate; CREATE TABLE wp_standard_events_meta ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id BIGINT UNSIGNED NOT NULL, start_time DATETIME DEFAULT 0, server_page_visit_time DATETIME DEFAULT 0, time_delta_between_start_time_and_page_visit_time BIGINT UNSIGNED NOT NULL, a_url VARCHAR(512) NOT NULL, post_id BIGINT(20) UNSIGNED NOT NULL, post_revision_id BIGINT(20) UNSIGNED DEFAULT 0, user_agent_visitor_details_id BIGINT UNSIGNED, screen_resolution_visitor_details_id BIGINT UNSIGNED, PRIMARY KEY (id), UNIQUE KEY uniq_start_time_visitor_id_post_id_post_revision_id (session_id, start_time, post_id, post_revision_id) ) $collate; "; return $tables; } /** * Get the table names list. * * @param bool $include_premium_tables Whether to include the premium plugin table names (works only if premium is active). * * @return array The list of plugin table names. */ public static function get_table_names( bool $include_premium_tables = true ) : array { $table_names = []; $tables_prefix = self::get_tables_prefix();

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_time_of_day`;

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

Other tables from First Party Analytics