Advertisement
Guest User

Untitled

a guest
Nov 26th, 2020
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS wp_i9tah4_rank_math_analytics_gsc (
  2. id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  3. created TIMESTAMP NOT NULL,
  4. query VARCHAR(1000) NOT NULL,
  5. page VARCHAR(500) NOT NULL,
  6. clicks MEDIUMINT(6) NOT NULL,
  7. impressions MEDIUMINT(6) NOT NULL,
  8. position DOUBLE NOT NULL,
  9. ctr DOUBLE NOT NULL,
  10. PRIMARY KEY (id),
  11. INDEX analytics_query (query),
  12. INDEX analytics_page (page),
  13. INDEX clicks (clicks),
  14. INDEX position (position)
  15. )
  16.  
  17.  
  18. and
  19.  
  20. CREATE TABLE IF NOT EXISTS wp_i9tah4_rank_math_analytics_objects (
  21. id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  22. created TIMESTAMP NOT NULL,
  23. title TEXT NOT NULL,
  24. page VARCHAR(500) NOT NULL,
  25. object_type VARCHAR(100) NOT NULL,
  26. object_subtype VARCHAR(100) NOT NULL,
  27. object_id BIGINT(20) UNSIGNED NOT NULL,
  28. primary_key VARCHAR(255) NOT NULL,
  29. seo_score TINYINT NOT NULL DEFAULT 0,
  30. page_score TINYINT NOT NULL DEFAULT 0,
  31. is_indexable TINYINT(1) NOT NULL DEFAULT 1,
  32. schemas_in_use VARCHAR(500),
  33. desktop_interactive DOUBLE DEFAULT 0,
  34. desktop_pagescore DOUBLE DEFAULT 0,
  35. mobile_interactive DOUBLE DEFAULT 0,
  36. mobile_pagescore DOUBLE DEFAULT 0,
  37. pagespeed_refreshed TIMESTAMP,
  38. PRIMARY KEY (id),
  39. INDEX analytics_object_page (page)
  40. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement