Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS wp_i9tah4_rank_math_analytics_gsc (
- id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- created TIMESTAMP NOT NULL,
- query VARCHAR(1000) NOT NULL,
- page VARCHAR(500) NOT NULL,
- clicks MEDIUMINT(6) NOT NULL,
- impressions MEDIUMINT(6) NOT NULL,
- position DOUBLE NOT NULL,
- ctr DOUBLE NOT NULL,
- PRIMARY KEY (id),
- INDEX analytics_query (query),
- INDEX analytics_page (page),
- INDEX clicks (clicks),
- INDEX position (position)
- )
- and
- CREATE TABLE IF NOT EXISTS wp_i9tah4_rank_math_analytics_objects (
- id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
- created TIMESTAMP NOT NULL,
- title TEXT NOT NULL,
- page VARCHAR(500) NOT NULL,
- object_type VARCHAR(100) NOT NULL,
- object_subtype VARCHAR(100) NOT NULL,
- object_id BIGINT(20) UNSIGNED NOT NULL,
- primary_key VARCHAR(255) NOT NULL,
- seo_score TINYINT NOT NULL DEFAULT 0,
- page_score TINYINT NOT NULL DEFAULT 0,
- is_indexable TINYINT(1) NOT NULL DEFAULT 1,
- schemas_in_use VARCHAR(500),
- desktop_interactive DOUBLE DEFAULT 0,
- desktop_pagescore DOUBLE DEFAULT 0,
- mobile_interactive DOUBLE DEFAULT 0,
- mobile_pagescore DOUBLE DEFAULT 0,
- pagespeed_refreshed TIMESTAMP,
- PRIMARY KEY (id),
- INDEX analytics_object_page (page)
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement