{"table_name":"time_of_day","full_table_name":"wp_time_of_day","description":"Stores time of day data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS 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 IF NOT EXISTS 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 IF NOT EXISTS wp_page_visits ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, a_day DATE NOT NULL, a_url VARCHAR(512) NOT NULL, object_id BIGINT(20) UNSIGNED NOT NULL, object_type ENUM('user', 'comment', 'term', 'post', '') 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_obj_id_type_revision_id (object_id, object_type, 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_obj_id_type_a_day_revision_id (object_id, object_type, a_day, revision_id) ) $collate \", \" CREATE TABLE IF NOT EXISTS wp_page_visits_on_finish ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, a_day DATE NOT NULL, a_url VARCHAR(512) NOT NULL, object_id BIGINT(20) UNSIGNED NOT NULL, object_type ENUM('user', 'comment', 'term', 'post', '') 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_obj_id_type_a_day_revision_id (object_id, object_type, a_day, revision_id), UNIQUE KEY uniq_obj_id_type_a_day_post_revision_id_revision_id (object_id, object_type, a_day, post_revision_id, revision_id) ) $collate \", \" CREATE TABLE IF NOT EXISTS 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 IF NOT EXISTS wp_link_visits ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, object_id BIGINT(20) UNSIGNED NOT NULL, object_type ENUM('user', 'comment', 'term', 'post', '') 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 IF NOT EXISTS 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 IF NOT EXISTS 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 IF NOT EXISTS 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 IF NOT EXISTS 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, object_id BIGINT(20) UNSIGNED NOT NULL, object_type ENUM('user', 'comment', 'term', 'post', '') 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_obj_id_type_post_revision_id (session_id, start_time, object_id, object_type, post_revision_id), FOREIGN KEY fk_sessions (session_id) REFERENCES wp_sessions(id) ON DELETE CASCADE, FOREIGN KEY fk_user_agent (user_agent_visitor_details_id) REFERENCES wp_visitor_details(id) ON DELETE SET NULL, FOREIGN KEY fk_screen_resolution (screen_resolution_visitor_details_id) REFERENCES wp_visitor_details(id) ON DELETE SET NULL ) $collate; \", \" CREATE TABLE IF NOT EXISTS 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), FOREIGN KEY fk_standard_events_meta (meta_id) REFERENCES wp_standard_events_meta(id) ON DELETE CASCADE ) $collate; \", \" ALTER TABLE wp_page_visits ADD INDEX idx_a_day_revision_id_a_url_object_id_unique_visits (a_day, revision_id, a_url, object_id, unique_visits);","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"day_of_week","type":"TINYINT","nullable":false,"primary_key":false},{"name":"minute_of_day","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"visits_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"a_day","type":"DATE","nullable":false,"primary_key":false},{"name":"a_key","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"a_value","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"visits_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"a_day","type":"DATE","nullable":false,"primary_key":false},{"name":"a_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"ENUM('user', 'comment', 'term', 'post', '')","nullable":false,"primary_key":false},{"name":"post_type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"bot_visits","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"total_visits","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"internal_visits","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"incoming_visits","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"sessions","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"bounce_rate","type":"FLOAT","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"a_day","type":"DATE","nullable":false,"primary_key":false},{"name":"a_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"ENUM('user', 'comment', 'term', 'post', '')","nullable":false,"primary_key":false},{"name":"total_visits","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"avg_load_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"load_times_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"max_load_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"min_load_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"avg_view_time","type":"FLOAT","nullable":false,"primary_key":false},{"name":"view_times_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"avg_asset_less_page_size","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"avg_website_data_download_size","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"avg_viewport_completed_loading_time","type":"FLOAT","nullable":true,"primary_key":false},{"name":"viewport_completed_loading_time_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"post_revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"bf_cache_on","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"bf_cache_off","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"word","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"page_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"input_selector","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"time","type":"DATETIME","nullable":true,"primary_key":false},{"name":"full_search","type":"TINYINT","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"object_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"ENUM('user', 'comment', 'term', 'post', '')","nullable":false,"primary_key":false},{"name":"visitor_id","type":"DECIMAL(20, 0)","nullable":false,"primary_key":false},{"name":"time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"href","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"href_host","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"href_main_domain","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"href_url_params","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"external_dst","type":"TINYINT","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"a_day","type":"DATE","nullable":false,"primary_key":false},{"name":"referer_host","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"referer_main_domain","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"utm_medium","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"utm_source","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"utm_campaign","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"utm_term","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"utm_content","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"visitor_id","type":"DECIMAL(20, 0)","nullable":false,"primary_key":false},{"name":"visited_pages","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"first_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"bounced","type":"TINYINT","nullable":false,"primary_key":false},{"name":"processed_after_finish","type":"TINYINT","nullable":false,"primary_key":false},{"name":"revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"time","type":"DATETIME","nullable":true,"primary_key":false},{"name":"visitor_id","type":"DECIMAL(20, 0)","nullable":false,"primary_key":false},{"name":"value","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"session_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"start_time","type":"DATETIME","nullable":true,"primary_key":false},{"name":"server_page_visit_time","type":"DATETIME","nullable":true,"primary_key":false},{"name":"time_delta_between_start_time_and_page_visit_time","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"a_url","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"object_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"ENUM('user', 'comment', 'term', 'post', '')","nullable":false,"primary_key":false},{"name":"post_revision_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"user_agent_visitor_details_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"screen_resolution_visitor_details_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":true,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":true,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":false,"primary_key":true},{"name":"meta_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"event","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"at_rel","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"element","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"context","type":"VARCHAR(512)","nullable":false,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":true,"primary_key":false}],"plugin":{"slug":"first-party-analytics","name":"First Party Analytics","active_installs":0,"version":"1.2.63","wp_org_url":"https://wordpress.org/plugins/first-party-analytics/"}}