{"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 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();","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":"post_id","type":"BIGINT(20) UNSIGNED","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":"post_id","type":"BIGINT(20) UNSIGNED","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":"post_id","type":"BIGINT(20) UNSIGNED","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":"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":"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":"post_id","type":"BIGINT(20) UNSIGNED","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}],"plugin":{"slug":"first-party-analytics","name":"First Party Analytics","active_installs":0,"version":"1.2.20","wp_org_url":"https://wordpress.org/plugins/first-party-analytics/"}}