API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 4th, 2019
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 25.69 KB | None | 0 0
raw download clone embed print report
  1. --- /home/dan/Desktop/phc_net_xf_db-backup-schema-050919-033001.sql
  2. +++ /home/dan/Desktop/devsite_xf213_phc-backup-schema-050919-033001.SQL
  3. @@ -106,7 +106,7 @@
  4.    `addon_ids` mediumblob NOT NULL,
  5.    `results` BLOB NOT NULL,
  6.    PRIMARY KEY (`batch_id`)
  7. -) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4;
  8. +) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4;
  9.  /*!40101 SET character_set_client = @saved_cs_client */;
  10.  
  11.  --
  12. @@ -144,7 +144,7 @@
  13.    PRIMARY KEY (`admin_log_id`),
  14.    KEY `request_date` (`request_date`),
  15.    KEY `user_id_request_date` (`user_id`,`request_date`)
  16. -) ENGINE=InnoDB AUTO_INCREMENT=278934 DEFAULT CHARSET=utf8mb4;
  17. +) ENGINE=InnoDB AUTO_INCREMENT=278716 DEFAULT CHARSET=utf8mb4;
  18.  /*!40101 SET character_set_client = @saved_cs_client */;
  19.  
  20.  --
  21. @@ -343,7 +343,7 @@
  22.    KEY `content_type_id_date` (`content_type`,`content_id`,`attach_date`),
  23.    KEY `temp_hash_attach_date` (`temp_hash`,`attach_date`),
  24.    KEY `unassociated_attach_date` (`unassociated`,`attach_date`)
  25. -) ENGINE=InnoDB AUTO_INCREMENT=678860 DEFAULT CHARSET=utf8mb4;
  26. +) ENGINE=InnoDB AUTO_INCREMENT=678090 DEFAULT CHARSET=utf8mb4;
  27.  /*!40101 SET character_set_client = @saved_cs_client */;
  28.  
  29.  --
  30. @@ -372,7 +372,7 @@
  31.    KEY `user_id_upload_date` (`user_id`,`upload_date`),
  32.    KEY `attach_count` (`attach_count`),
  33.    KEY `upload_date` (`upload_date`)
  34. -) ENGINE=InnoDB AUTO_INCREMENT=1220138 DEFAULT CHARSET=utf8mb4;
  35. +) ENGINE=InnoDB AUTO_INCREMENT=1219368 DEFAULT CHARSET=utf8mb4;
  36.  /*!40101 SET character_set_client = @saved_cs_client */;
  37.  
  38.  --
  39. @@ -561,7 +561,7 @@
  40.    PRIMARY KEY (`bookmark_id`),
  41.    UNIQUE KEY `user_id_content_type_content_id` (`user_id`,`content_type`,`content_id`),
  42.    KEY `content_type_content_id` (`content_type`,`content_id`)
  43. -) ENGINE=InnoDB AUTO_INCREMENT=52292 DEFAULT CHARSET=utf8mb4;
  44. +) ENGINE=InnoDB AUTO_INCREMENT=52097 DEFAULT CHARSET=utf8mb4;
  45.  /*!40101 SET character_set_client = @saved_cs_client */;
  46.  
  47.  --
  48. @@ -582,7 +582,7 @@
  49.    UNIQUE KEY `label_user_id` (`label`,`user_id`),
  50.    UNIQUE KEY `label_url_user_id` (`label_url`,`user_id`),
  51.    KEY `use_count` (`use_count`)
  52. -) ENGINE=InnoDB AUTO_INCREMENT=527 DEFAULT CHARSET=utf8mb4;
  53. +) ENGINE=InnoDB AUTO_INCREMENT=525 DEFAULT CHARSET=utf8mb4;
  54.  /*!40101 SET character_set_client = @saved_cs_client */;
  55.  
  56.  --
  57. @@ -668,7 +668,7 @@
  58.    KEY `edit_date` (`edit_date`),
  59.    KEY `content_type_content_id_date` (`content_type`,`content_id`,`edit_date`),
  60.    KEY `content_type_date` (`content_type`,`edit_date`)
  61. -) ENGINE=InnoDB AUTO_INCREMENT=2304213 DEFAULT CHARSET=utf8mb4;
  62. +) ENGINE=InnoDB AUTO_INCREMENT=2302047 DEFAULT CHARSET=utf8mb4;
  63.  /*!40101 SET character_set_client = @saved_cs_client */;
  64.  
  65.  --
  66. @@ -760,7 +760,7 @@
  67.    PRIMARY KEY (`spam_cache_id`),
  68.    UNIQUE KEY `content_type` (`content_type`,`content_id`),
  69.    KEY `insert_date` (`insert_date`)
  70. -) ENGINE=InnoDB AUTO_INCREMENT=3634 DEFAULT CHARSET=utf8mb4;
  71. +) ENGINE=InnoDB AUTO_INCREMENT=3400 DEFAULT CHARSET=utf8mb4;
  72.  /*!40101 SET character_set_client = @saved_cs_client */;
  73.  
  74.  --
  75. @@ -806,7 +806,7 @@
  76.    PRIMARY KEY (`conversation_id`),
  77.    KEY `user_id` (`user_id`),
  78.    KEY `start_date` (`start_date`)
  79. -) ENGINE=InnoDB AUTO_INCREMENT=1517933 DEFAULT CHARSET=utf8mb4;
  80. +) ENGINE=InnoDB AUTO_INCREMENT=1517083 DEFAULT CHARSET=utf8mb4;
  81.  /*!40101 SET character_set_client = @saved_cs_client */;
  82.  
  83.  --
  84. @@ -833,7 +833,7 @@
  85.    KEY `conversation_id_message_date` (`conversation_id`,`message_date`),
  86.    KEY `user_id` (`user_id`),
  87.    KEY `message_date` (`message_date`)
  88. -) ENGINE=InnoDB AUTO_INCREMENT=3011968 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  89. +) ENGINE=InnoDB AUTO_INCREMENT=3009589 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  90.  /*!40101 SET character_set_client = @saved_cs_client */;
  91.  
  92.  --
  93. @@ -915,7 +915,7 @@
  94.    `cache_date` INT(10) UNSIGNED NOT NULL,
  95.    PRIMARY KEY (`cache_id`),
  96.    UNIQUE KEY `style_language_title_modifier` (`style_id`,`language_id`,`title`,`modifier_key`)
  97. -) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4;
  98. +) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4;
  99.  /*!40101 SET character_set_client = @saved_cs_client */;
  100.  
  101.  --
  102. @@ -968,7 +968,7 @@
  103.    PRIMARY KEY (`draft_id`),
  104.    UNIQUE KEY `draft_key_user` (`draft_key`,`user_id`),
  105.    KEY `last_update` (`last_update`)
  106. -) ENGINE=InnoDB AUTO_INCREMENT=7441266 DEFAULT CHARSET=utf8mb4;
  107. +) ENGINE=InnoDB AUTO_INCREMENT=7438556 DEFAULT CHARSET=utf8mb4;
  108.  /*!40101 SET character_set_client = @saved_cs_client */;
  109.  
  110.  --
  111. @@ -989,7 +989,7 @@
  112.    KEY `content_type` (`content_type`,`content_id`,`edit_date`),
  113.    KEY `edit_date` (`edit_date`),
  114.    KEY `edit_user_id` (`edit_user_id`)
  115. -) ENGINE=InnoDB AUTO_INCREMENT=1553847 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  116. +) ENGINE=InnoDB AUTO_INCREMENT=1553372 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  117.  /*!40101 SET character_set_client = @saved_cs_client */;
  118.  
  119.  --
  120. @@ -1029,7 +1029,7 @@
  121.    `diagnostic_info` text DEFAULT NULL,
  122.    PRIMARY KEY (`bounce_id`),
  123.    KEY `log_date` (`log_date`)
  124. -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  125. +) ENGINE=InnoDB AUTO_INCREMENT=355046 DEFAULT CHARSET=utf8mb4;
  126.  /*!40101 SET character_set_client = @saved_cs_client */;
  127.  
  128.  --
  129. @@ -1047,7 +1047,7 @@
  130.    PRIMARY KEY (`bounce_soft_id`),
  131.    UNIQUE KEY `user_id` (`user_id`,`bounce_date`),
  132.    KEY `bounce_date` (`bounce_date`)
  133. -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  134. +) ENGINE=InnoDB AUTO_INCREMENT=60329 DEFAULT CHARSET=utf8mb4;
  135.  /*!40101 SET character_set_client = @saved_cs_client */;
  136.  
  137.  --
  138. @@ -1070,7 +1070,7 @@
  139.    `ip_address` varbinary(16) NOT NULL DEFAULT '',
  140.    PRIMARY KEY (`error_id`),
  141.    KEY `exception_date` (`exception_date`)
  142. -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
  143. +) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
  144.  /*!40101 SET character_set_client = @saved_cs_client */;
  145.  
  146.  --
  147. @@ -1091,7 +1091,7 @@
  148.    PRIMARY KEY (`index_failed_id`),
  149.    UNIQUE KEY `content_type` (`content_type`,`content_id`),
  150.    KEY `reindex_date` (`reindex_date`)
  151. -) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;
  152. +) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
  153.  /*!40101 SET character_set_client = @saved_cs_client */;
  154.  
  155.  --
  156. @@ -1154,7 +1154,7 @@
  157.    `total_inconsistent` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  158.    `total_checked` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  159.    PRIMARY KEY (`check_id`)
  160. -) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8mb4;
  161. +) ENGINE=InnoDB AUTO_INCREMENT=223 DEFAULT CHARSET=utf8mb4;
  162.  /*!40101 SET character_set_client = @saved_cs_client */;
  163.  
  164.  --
  165. @@ -1175,7 +1175,7 @@
  166.    PRIMARY KEY (`find_new_id`),
  167.    KEY `cache_date` (`cache_date`),
  168.    KEY `type_user_date` (`content_type`,`user_id`,`cache_date`)
  169. -) ENGINE=InnoDB AUTO_INCREMENT=1638627 DEFAULT CHARSET=utf8mb4;
  170. +) ENGINE=InnoDB AUTO_INCREMENT=1629343 DEFAULT CHARSET=utf8mb4;
  171.  /*!40101 SET character_set_client = @saved_cs_client */;
  172.  
  173.  --
  174. @@ -1316,7 +1316,7 @@
  175.    UNIQUE KEY `user_id_node_id` (`user_id`,`node_id`),
  176.    KEY `node_id` (`node_id`),
  177.    KEY `forum_read_date` (`forum_read_date`)
  178. -) ENGINE=InnoDB AUTO_INCREMENT=2599457 DEFAULT CHARSET=utf8mb4;
  179. +) ENGINE=InnoDB AUTO_INCREMENT=2598995 DEFAULT CHARSET=utf8mb4;
  180.  /*!40101 SET character_set_client = @saved_cs_client */;
  181.  
  182.  --
  183. @@ -1386,7 +1386,7 @@
  184.    KEY `pruned_fetch_date` (`pruned`,`fetch_date`),
  185.    KEY `last_request_date` (`last_request_date`),
  186.    KEY `is_processing` (`is_processing`)
  187. -) ENGINE=InnoDB AUTO_INCREMENT=786476 DEFAULT CHARSET=utf8mb4;
  188. +) ENGINE=InnoDB AUTO_INCREMENT=786057 DEFAULT CHARSET=utf8mb4;
  189.  /*!40101 SET character_set_client = @saved_cs_client */;
  190.  
  191.  --
  192. @@ -1445,7 +1445,7 @@
  193.    KEY `content_type_content_id` (`content_type`,`content_id`),
  194.    KEY `log_date` (`log_date`),
  195.    KEY `ip_log_date` (`ip`,`log_date`)
  196. -) ENGINE=InnoDB AUTO_INCREMENT=63637280 DEFAULT CHARSET=utf8mb4;
  197. +) ENGINE=InnoDB AUTO_INCREMENT=63596814 DEFAULT CHARSET=utf8mb4;
  198.  /*!40101 SET character_set_client = @saved_cs_client */;
  199.  
  200.  --
  201. @@ -1490,7 +1490,7 @@
  202.    UNIQUE KEY `unique_key` (`unique_key`),
  203.    KEY `trigger_date` (`trigger_date`),
  204.    KEY `manual_execute_date` (`manual_execute`,`trigger_date`)
  205. -) ENGINE=InnoDB AUTO_INCREMENT=325266 DEFAULT CHARSET=utf8mb4;
  206. +) ENGINE=InnoDB AUTO_INCREMENT=319138 DEFAULT CHARSET=utf8mb4;
  207.  /*!40101 SET character_set_client = @saved_cs_client */;
  208.  
  209.  --
  210. @@ -1613,7 +1613,7 @@
  211.    KEY `attempt_date` (`attempt_date`),
  212.    KEY `login_check` (`login`,`ip_address`,`attempt_date`),
  213.    KEY `ip_address_attempt_date` (`ip_address`,`attempt_date`)
  214. -) ENGINE=InnoDB AUTO_INCREMENT=2712003 DEFAULT CHARSET=utf8mb4;
  215. +) ENGINE=InnoDB AUTO_INCREMENT=2710168 DEFAULT CHARSET=utf8mb4;
  216.  /*!40101 SET character_set_client = @saved_cs_client */;
  217.  
  218.  --
  219. @@ -1632,7 +1632,7 @@
  220.    `fail_count` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  221.    PRIMARY KEY (`mail_queue_id`),
  222.    KEY `send_date_queue_date` (`send_date`,`queue_date`)
  223. -) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4;
  224. +) ENGINE=InnoDB AUTO_INCREMENT=562511 DEFAULT CHARSET=utf8mb4;
  225.  /*!40101 SET character_set_client = @saved_cs_client */;
  226.  
  227.  --
  228. @@ -1731,7 +1731,7 @@
  229.    UNIQUE KEY `user_id_album_id` (`user_id`,`album_id`),
  230.    KEY `album_id` (`album_id`),
  231.    KEY `comment_read_date` (`comment_read_date`)
  232. -) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4;
  233. +) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4;
  234.  /*!40101 SET character_set_client = @saved_cs_client */;
  235.  
  236.  --
  237. @@ -1862,7 +1862,7 @@
  238.    KEY `content_type_content_id_comment_date` (`content_type`,`content_id`,`comment_date`),
  239.    KEY `user_id` (`user_id`),
  240.    KEY `rating_id` (`rating_id`)
  241. -) ENGINE=InnoDB AUTO_INCREMENT=14504 DEFAULT CHARSET=utf8mb4;
  242. +) ENGINE=InnoDB AUTO_INCREMENT=14497 DEFAULT CHARSET=utf8mb4;
  243.  /*!40101 SET character_set_client = @saved_cs_client */;
  244.  
  245.  --
  246. @@ -1881,7 +1881,7 @@
  247.    UNIQUE KEY `user_id_media_id` (`user_id`,`media_id`),
  248.    KEY `media_id` (`media_id`),
  249.    KEY `comment_read_date` (`comment_read_date`)
  250. -) ENGINE=InnoDB AUTO_INCREMENT=188098 DEFAULT CHARSET=utf8mb4;
  251. +) ENGINE=InnoDB AUTO_INCREMENT=187554 DEFAULT CHARSET=utf8mb4;
  252.  /*!40101 SET character_set_client = @saved_cs_client */;
  253.  
  254.  --
  255. @@ -1979,7 +1979,7 @@
  256.    KEY `user_id_media_date` (`user_id`,`media_date`),
  257.    KEY `album_id_media_date` (`album_id`,`media_date`),
  258.    KEY `category_id_media_date` (`category_id`,`media_date`)
  259. -) ENGINE=InnoDB AUTO_INCREMENT=33355 DEFAULT CHARSET=utf8mb4;
  260. +) ENGINE=InnoDB AUTO_INCREMENT=33352 DEFAULT CHARSET=utf8mb4;
  261.  /*!40101 SET character_set_client = @saved_cs_client */;
  262.  
  263.  --
  264. @@ -2029,7 +2029,7 @@
  265.    PRIMARY KEY (`temp_media_id`),
  266.    UNIQUE KEY `media_hash` (`media_hash`),
  267.    UNIQUE KEY `attachment_id` (`attachment_id`)
  268. -) ENGINE=InnoDB AUTO_INCREMENT=1407 DEFAULT CHARSET=utf8mb4;
  269. +) ENGINE=InnoDB AUTO_INCREMENT=1402 DEFAULT CHARSET=utf8mb4;
  270.  /*!40101 SET character_set_client = @saved_cs_client */;
  271.  
  272.  --
  273. @@ -2048,7 +2048,7 @@
  274.    UNIQUE KEY `user_id_media_id` (`user_id`,`media_id`),
  275.    KEY `media_id` (`media_id`),
  276.    KEY `media_view_date` (`media_view_date`)
  277. -) ENGINE=InnoDB AUTO_INCREMENT=836601 DEFAULT CHARSET=utf8mb4;
  278. +) ENGINE=InnoDB AUTO_INCREMENT=835846 DEFAULT CHARSET=utf8mb4;
  279.  /*!40101 SET character_set_client = @saved_cs_client */;
  280.  
  281.  --
  282. @@ -2208,7 +2208,7 @@
  283.    KEY `content_type_id` (`content_type`,`content_id`),
  284.    KEY `discussion_content_type_id` (`discussion_content_type`,`discussion_content_id`),
  285.    KEY `user_id_log_date` (`user_id`,`log_date`)
  286. -) ENGINE=InnoDB AUTO_INCREMENT=213760 DEFAULT CHARSET=utf8mb4;
  287. +) ENGINE=InnoDB AUTO_INCREMENT=209319 DEFAULT CHARSET=utf8mb4;
  288.  /*!40101 SET character_set_client = @saved_cs_client */;
  289.  
  290.  --
  291. @@ -2273,7 +2273,7 @@
  292.    KEY `userId_eventDate` (`user_id`,`event_date`),
  293.    KEY `contentType_contentId` (`content_type`,`content_id`),
  294.    KEY `event_date` (`event_date`)
  295. -) ENGINE=InnoDB AUTO_INCREMENT=20699648 DEFAULT CHARSET=utf8mb4;
  296. +) ENGINE=InnoDB AUTO_INCREMENT=20688474 DEFAULT CHARSET=utf8mb4;
  297.  /*!40101 SET character_set_client = @saved_cs_client */;
  298.  
  299.  --
  300. @@ -2705,7 +2705,7 @@
  301.    PRIMARY KEY (`phrase_id`),
  302.    UNIQUE KEY `title` (`title`,`language_id`),
  303.    KEY `language_id_global_cache` (`language_id`,`global_cache`)
  304. -) ENGINE=InnoDB AUTO_INCREMENT=1166070 DEFAULT CHARSET=utf8mb4;
  305. +) ENGINE=InnoDB AUTO_INCREMENT=1166031 DEFAULT CHARSET=utf8mb4;
  306.  /*!40101 SET character_set_client = @saved_cs_client */;
  307.  
  308.  --
  309. @@ -2741,7 +2741,7 @@
  310.    KEY `phrase_id` (`phrase_id`),
  311.    KEY `group_language` (`phrase_group`,`language_id`),
  312.    KEY `title` (`title`)
  313. -) ENGINE=InnoDB AUTO_INCREMENT=489764 DEFAULT CHARSET=utf8mb4;
  314. +) ENGINE=InnoDB AUTO_INCREMENT=396038 DEFAULT CHARSET=utf8mb4;
  315.  /*!40101 SET character_set_client = @saved_cs_client */;
  316.  
  317.  --
  318. @@ -2765,7 +2765,7 @@
  319.    `max_votes` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  320.    PRIMARY KEY (`poll_id`),
  321.    UNIQUE KEY `content_type_content_id` (`content_type`,`content_id`)
  322. -) ENGINE=InnoDB AUTO_INCREMENT=4334 DEFAULT CHARSET=utf8mb4;
  323. +) ENGINE=InnoDB AUTO_INCREMENT=4328 DEFAULT CHARSET=utf8mb4;
  324.  /*!40101 SET character_set_client = @saved_cs_client */;
  325.  
  326.  --
  327. @@ -2783,7 +2783,7 @@
  328.    `voters` mediumblob NOT NULL,
  329.    PRIMARY KEY (`poll_response_id`),
  330.    KEY `poll_id_response_id` (`poll_id`,`poll_response_id`)
  331. -) ENGINE=InnoDB AUTO_INCREMENT=11156 DEFAULT CHARSET=utf8mb4;
  332. +) ENGINE=InnoDB AUTO_INCREMENT=11144 DEFAULT CHARSET=utf8mb4;
  333.  /*!40101 SET character_set_client = @saved_cs_client */;
  334.  
  335.  --
  336. @@ -2836,7 +2836,7 @@
  337.    KEY `thread_id_position` (`thread_id`,`position`),
  338.    KEY `user_id` (`user_id`),
  339.    KEY `post_date` (`post_date`)
  340. -) ENGINE=InnoDB AUTO_INCREMENT=13236515 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  341. +) ENGINE=InnoDB AUTO_INCREMENT=13228971 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  342.  /*!40101 SET character_set_client = @saved_cs_client */;
  343.  
  344.  --
  345. @@ -2870,7 +2870,7 @@
  346.    KEY `profile_user_id_post_date` (`profile_user_id`,`post_date`),
  347.    KEY `user_id` (`user_id`),
  348.    KEY `post_date` (`post_date`)
  349. -) ENGINE=InnoDB AUTO_INCREMENT=89081 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  350. +) ENGINE=InnoDB AUTO_INCREMENT=89075 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED;
  351.  /*!40101 SET character_set_client = @saved_cs_client */;
  352.  
  353.  --
  354. @@ -2899,7 +2899,7 @@
  355.    KEY `profile_post_id_comment_date` (`profile_post_id`,`comment_date`),
  356.    KEY `user_id` (`user_id`),
  357.    KEY `comment_date` (`comment_date`)
  358. -) ENGINE=InnoDB AUTO_INCREMENT=86680 DEFAULT CHARSET=utf8mb4;
  359. +) ENGINE=InnoDB AUTO_INCREMENT=86662 DEFAULT CHARSET=utf8mb4;
  360.  /*!40101 SET character_set_client = @saved_cs_client */;
  361.  
  362.  --
  363. @@ -2984,7 +2984,7 @@
  364.    KEY `content_type_id_reaction_date` (`content_type`,`content_id`,`reaction_date`),
  365.    KEY `content_user_id_reaction_date` (`content_user_id`,`reaction_date`),
  366.    KEY `reaction_date` (`reaction_date`)
  367. -) ENGINE=InnoDB AUTO_INCREMENT=7226229 DEFAULT CHARSET=utf8mb4;
  368. +) ENGINE=InnoDB AUTO_INCREMENT=7222181 DEFAULT CHARSET=utf8mb4;
  369.  /*!40101 SET character_set_client = @saved_cs_client */;
  370.  
  371.  --
  372. @@ -3030,7 +3030,7 @@
  373.    KEY `assigned_user_id_state` (`assigned_user_id`,`report_state`),
  374.    KEY `last_modified_date` (`last_modified_date`),
  375.    KEY `content_user_id_modified` (`content_user_id`,`last_modified_date`)
  376. -) ENGINE=InnoDB AUTO_INCREMENT=58288 DEFAULT CHARSET=utf8mb4;
  377. +) ENGINE=InnoDB AUTO_INCREMENT=58260 DEFAULT CHARSET=utf8mb4;
  378.  /*!40101 SET character_set_client = @saved_cs_client */;
  379.  
  380.  --
  381. @@ -3052,7 +3052,7 @@
  382.    PRIMARY KEY (`report_comment_id`),
  383.    KEY `report_id_date` (`report_id`,`comment_date`),
  384.    KEY `user_id` (`user_id`)
  385. -) ENGINE=InnoDB AUTO_INCREMENT=142401 DEFAULT CHARSET=utf8mb4;
  386. +) ENGINE=InnoDB AUTO_INCREMENT=142335 DEFAULT CHARSET=utf8mb4;
  387.  /*!40101 SET character_set_client = @saved_cs_client */;
  388.  
  389.  --
  390. @@ -3122,7 +3122,7 @@
  391.    PRIMARY KEY (`search_id`),
  392.    KEY `search_date` (`search_date`),
  393.    KEY `query_hash` (`query_hash`)
  394. -) ENGINE=InnoDB AUTO_INCREMENT=2804835 DEFAULT CHARSET=utf8mb4;
  395. +) ENGINE=InnoDB AUTO_INCREMENT=2793391 DEFAULT CHARSET=utf8mb4;
  396.  /*!40101 SET character_set_client = @saved_cs_client */;
  397.  
  398.  --
  399. @@ -3240,7 +3240,7 @@
  400.    KEY `view_count` (`view_count`),
  401.    FULLTEXT KEY `url` (`url`),
  402.    FULLTEXT KEY `redirect_url` (`redirect_url`)
  403. -) ENGINE=MyISAM AUTO_INCREMENT=98378 DEFAULT CHARSET=utf8mb4;
  404. +) ENGINE=MyISAM AUTO_INCREMENT=97467 DEFAULT CHARSET=utf8mb4;
  405.  /*!40101 SET character_set_client = @saved_cs_client */;
  406.  
  407.  --
  408. @@ -3258,7 +3258,7 @@
  409.    PRIMARY KEY (`shout_id`),
  410.    KEY `shout_user_id` (`shout_user_id`),
  411.    KEY `shout_date` (`shout_date`)
  412. -) ENGINE=InnoDB AUTO_INCREMENT=22433 DEFAULT CHARSET=utf8mb4;
  413. +) ENGINE=InnoDB AUTO_INCREMENT=22197 DEFAULT CHARSET=utf8mb4;
  414.  /*!40101 SET character_set_client = @saved_cs_client */;
  415.  
  416.  --
  417. @@ -3280,7 +3280,7 @@
  418.    KEY `username_old` (`username_old`),
  419.    KEY `date` (`date`),
  420.    KEY `incognito` (`incognito`)
  421. -) ENGINE=InnoDB AUTO_INCREMENT=8050 DEFAULT CHARSET=utf8mb4;
  422. +) ENGINE=InnoDB AUTO_INCREMENT=8045 DEFAULT CHARSET=utf8mb4;
  423.  /*!40101 SET character_set_client = @saved_cs_client */;
  424.  
  425.  --
  426. @@ -3683,7 +3683,7 @@
  427.    PRIMARY KEY (`trigger_log_id`),
  428.    UNIQUE KEY `content_type` (`content_type`,`content_id`),
  429.    KEY `log_date` (`log_date`)
  430. -) ENGINE=InnoDB AUTO_INCREMENT=290332 DEFAULT CHARSET=utf8mb4;
  431. +) ENGINE=InnoDB AUTO_INCREMENT=290295 DEFAULT CHARSET=utf8mb4;
  432.  /*!40101 SET character_set_client = @saved_cs_client */;
  433.  
  434.  --
  435. @@ -3748,7 +3748,7 @@
  436.    `addon_id` varbinary(50) NOT NULL,
  437.    PRIMARY KEY (`property_id`),
  438.    UNIQUE KEY `style_id_property_name` (`style_id`,`property_name`)
  439. -) ENGINE=InnoDB AUTO_INCREMENT=1236 DEFAULT CHARSET=utf8mb4;
  440. +) ENGINE=InnoDB AUTO_INCREMENT=1233 DEFAULT CHARSET=utf8mb4;
  441.  /*!40101 SET character_set_client = @saved_cs_client */;
  442.  
  443.  --
  444. @@ -3787,7 +3787,7 @@
  445.    PRIMARY KEY (`property_map_id`),
  446.    UNIQUE KEY `style_id` (`style_id`,`property_name`),
  447.    KEY `parent_property_id` (`parent_property_id`)
  448. -) ENGINE=InnoDB AUTO_INCREMENT=96981 DEFAULT CHARSET=utf8mb4;
  449. +) ENGINE=InnoDB AUTO_INCREMENT=85595 DEFAULT CHARSET=utf8mb4;
  450.  /*!40101 SET character_set_client = @saved_cs_client */;
  451.  
  452.  --
  453. @@ -3808,7 +3808,7 @@
  454.    KEY `content_user_id` (`content_user_id`),
  455.    KEY `content_type` (`content_type`,`content_id`),
  456.    KEY `reporting_user` (`reporting_user_id`,`content_type`,`content_id`)
  457. -) ENGINE=InnoDB AUTO_INCREMENT=9327 DEFAULT CHARSET=utf8mb4;
  458. +) ENGINE=InnoDB AUTO_INCREMENT=9300 DEFAULT CHARSET=utf8mb4;
  459.  /*!40101 SET character_set_client = @saved_cs_client */;
  460.  
  461.  --
  462. @@ -3859,7 +3859,7 @@
  463.    UNIQUE KEY `tag` (`tag`),
  464.    UNIQUE KEY `tag_url` (`tag_url`),
  465.    KEY `use_count` (`use_count`)
  466. -) ENGINE=InnoDB AUTO_INCREMENT=148555 DEFAULT CHARSET=utf8mb4;
  467. +) ENGINE=InnoDB AUTO_INCREMENT=148548 DEFAULT CHARSET=utf8mb4;
  468.  /*!40101 SET character_set_client = @saved_cs_client */;
  469.  
  470.  --
  471. @@ -3881,7 +3881,7 @@
  472.    PRIMARY KEY (`tag_content_id`),
  473.    UNIQUE KEY `content_type_id_tag` (`content_type`,`content_id`,`tag_id`),
  474.    KEY `tag_id_content_date` (`tag_id`,`content_date`)
  475. -) ENGINE=InnoDB AUTO_INCREMENT=979520 DEFAULT CHARSET=utf8mb4;
  476. +) ENGINE=InnoDB AUTO_INCREMENT=979391 DEFAULT CHARSET=utf8mb4;
  477.  /*!40101 SET character_set_client = @saved_cs_client */;
  478.  
  479.  --
  480. @@ -3901,7 +3901,7 @@
  481.    PRIMARY KEY (`result_cache_id`),
  482.    UNIQUE KEY `tag_id_user_id` (`tag_id`,`user_id`),
  483.    KEY `expiration_date` (`expiry_date`)
  484. -) ENGINE=InnoDB AUTO_INCREMENT=216175 DEFAULT CHARSET=utf8mb4;
  485. +) ENGINE=InnoDB AUTO_INCREMENT=215446 DEFAULT CHARSET=utf8mb4;
  486.  /*!40101 SET character_set_client = @saved_cs_client */;
  487.  
  488.  --
  489. @@ -3924,7 +3924,7 @@
  490.    `last_edit_date` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  491.    PRIMARY KEY (`template_id`),
  492.    UNIQUE KEY `type_title_style_id` (`type`,`title`,`style_id`)
  493. -) ENGINE=InnoDB AUTO_INCREMENT=18787 DEFAULT CHARSET=utf8mb4;
  494. +) ENGINE=InnoDB AUTO_INCREMENT=18784 DEFAULT CHARSET=utf8mb4;
  495.  /*!40101 SET character_set_client = @saved_cs_client */;
  496.  
  497.  --
  498. @@ -3946,7 +3946,7 @@
  499.    KEY `log_date` (`log_date`),
  500.    KEY `title` (`title`),
  501.    KEY `type_title_style_id` (`type`,`title`,`style_id`)
  502. -) ENGINE=InnoDB AUTO_INCREMENT=1026 DEFAULT CHARSET=utf8mb4;
  503. +) ENGINE=InnoDB AUTO_INCREMENT=852 DEFAULT CHARSET=utf8mb4;
  504.  /*!40101 SET character_set_client = @saved_cs_client */;
  505.  
  506.  --
  507. @@ -3966,7 +3966,7 @@
  508.    UNIQUE KEY `style_id_type_title` (`style_id`,`type`,`title`),
  509.    KEY `template_id` (`template_id`),
  510.    KEY `type_title` (`type`,`title`)
  511. -) ENGINE=InnoDB AUTO_INCREMENT=394017 DEFAULT CHARSET=utf8mb4;
  512. +) ENGINE=InnoDB AUTO_INCREMENT=352621 DEFAULT CHARSET=utf8mb4;
  513.  /*!40101 SET character_set_client = @saved_cs_client */;
  514.  
  515.  --
  516. @@ -4041,7 +4041,7 @@
  517.    PRIMARY KEY (`attempt_id`),
  518.    KEY `attempt_date` (`attempt_date`),
  519.    KEY `user_id_attempt_date` (`user_id`,`attempt_date`)
  520. -) ENGINE=InnoDB AUTO_INCREMENT=10765 DEFAULT CHARSET=utf8mb4;
  521. +) ENGINE=InnoDB AUTO_INCREMENT=10750 DEFAULT CHARSET=utf8mb4;
  522.  /*!40101 SET character_set_client = @saved_cs_client */;
  523.  
  524.  --
  525. @@ -4101,7 +4101,7 @@
  526.    KEY `node_id_sticky_state_last_post` (`node_id`,`sticky`,`discussion_state`,`last_post_date`),
  527.    KEY `user_id` (`user_id`),
  528.    KEY `post_date` (`post_date`)
  529. -) ENGINE=InnoDB AUTO_INCREMENT=761734 DEFAULT CHARSET=utf8mb4;
  530. +) ENGINE=InnoDB AUTO_INCREMENT=761338 DEFAULT CHARSET=utf8mb4;
  531.  /*!40101 SET character_set_client = @saved_cs_client */;
  532.  
  533.  --
  534. @@ -4160,7 +4160,7 @@
  535.    `allowed_user_group_ids` BLOB NOT NULL,
  536.    PRIMARY KEY (`prefix_id`),
  537.    KEY `materialized_order` (`materialized_order`)
  538. -) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4;
  539. +) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4;
  540.  /*!40101 SET character_set_client = @saved_cs_client */;
  541.  
  542.  --
  543. @@ -4225,7 +4225,7 @@
  544.    UNIQUE KEY `user_id_thread_id` (`user_id`,`thread_id`),
  545.    KEY `thread_id` (`thread_id`),
  546.    KEY `thread_read_date` (`thread_read_date`)
  547. -) ENGINE=InnoDB AUTO_INCREMENT=148549108 DEFAULT CHARSET=utf8mb4;
  548. +) ENGINE=InnoDB AUTO_INCREMENT=148447322 DEFAULT CHARSET=utf8mb4;
  549.  /*!40101 SET character_set_client = @saved_cs_client */;
  550.  
  551.  --
  552. @@ -4371,7 +4371,7 @@
  553.    `available_updates` BLOB DEFAULT NULL,
  554.    PRIMARY KEY (`check_id`),
  555.    KEY `check_date` (`check_date`)
  556. -) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8mb4;
  557. +) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8mb4;
  558.  /*!40101 SET character_set_client = @saved_cs_client */;
  559.  
  560.  --
  561. @@ -4468,7 +4468,7 @@
  562.    KEY `xengallery_album_count` (`xfmg_album_count`),
  563.    KEY `reaction_score` (`reaction_score`),
  564.    KEY `siropu_shoutbox_ban` (`siropu_shoutbox_ban`)
  565. -) ENGINE=InnoDB AUTO_INCREMENT=1564732 DEFAULT CHARSET=utf8mb4;
  566. +) ENGINE=InnoDB AUTO_INCREMENT=1564035 DEFAULT CHARSET=utf8mb4;
  567.  /*!40101 SET character_set_client = @saved_cs_client */;
  568.  
  569.  --
  570. @@ -4495,7 +4495,7 @@
  571.    KEY `contentType_contentId` (`content_type`,`content_id`),
  572.    KEY `viewDate_eventDate` (`view_date`,`event_date`),
  573.    KEY `user_id` (`user_id`)
  574. -) ENGINE=InnoDB AUTO_INCREMENT=178394298 DEFAULT CHARSET=utf8mb4;
  575. +) ENGINE=InnoDB AUTO_INCREMENT=178281442 DEFAULT CHARSET=utf8mb4;
  576.  /*!40101 SET character_set_client = @saved_cs_client */;
  577.  
  578.  --
  579. @@ -4783,6 +4783,7 @@
  580.    `content_show_signature` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Show user''s signatures with content',
  581.    `receive_admin_email` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  582.    `email_on_conversation` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Receive an email upon receiving a conversation message',
  583. +  `whatsnewdigest_email` enum('none','daily','weekly') DEFAULT NULL COMMENT 'Addon What''s New Digest',
  584.    `push_on_conversation` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  585.    `is_discouraged` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'If non-zero, this user will be subjected to annoying random system failures.',
  586.    `creation_watch_state` enum('','watch_no_email','watch_email') NOT NULL DEFAULT '',
  587. @@ -4795,7 +4796,8 @@
  588.    `xm_persistentalert_always` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  589.    `prefixess_ignored_prefix_ids` mediumblob DEFAULT NULL,
  590.    `sv_default_deleted` enum('','exclude','include','only') NOT NULL DEFAULT '',
  591. -  PRIMARY KEY (`user_id`)
  592. +  PRIMARY KEY (`user_id`),
  593. +  KEY `whatsnewdigest_email` (`whatsnewdigest_email`)
  594.  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  595.  /*!40101 SET character_set_client = @saved_cs_client */;
  596.  
  597. @@ -4880,7 +4882,7 @@
  598.    PRIMARY KEY (`endpoint_id`),
  599.    UNIQUE KEY `endpoint_hash` (`endpoint_hash`),
  600.    KEY `user_id` (`user_id`)
  601. -) ENGINE=InnoDB AUTO_INCREMENT=305967 DEFAULT CHARSET=utf8mb4;
  602. +) ENGINE=InnoDB AUTO_INCREMENT=304157 DEFAULT CHARSET=utf8mb4;
  603.  /*!40101 SET character_set_client = @saved_cs_client */;
  604.  
  605.  --
  606. @@ -4916,7 +4918,7 @@
  607.    PRIMARY KEY (`remember_id`),
  608.    UNIQUE KEY `user_id_remember_key` (`user_id`,`remember_key`),
  609.    KEY `expiry_date` (`expiry_date`)
  610. -) ENGINE=InnoDB AUTO_INCREMENT=837095 DEFAULT CHARSET=utf8mb4;
  611. +) ENGINE=InnoDB AUTO_INCREMENT=833191 DEFAULT CHARSET=utf8mb4;
  612.  /*!40101 SET character_set_client = @saved_cs_client */;
  613.  
  614.  --
  615. @@ -4934,7 +4936,7 @@
  616.    `last_used_date` INT(10) UNSIGNED NOT NULL DEFAULT 0,
  617.    PRIMARY KEY (`user_tfa_id`),
  618.    UNIQUE KEY `user_id` (`user_id`,`provider_id`)
  619. -) ENGINE=InnoDB AUTO_INCREMENT=10172 DEFAULT CHARSET=utf8mb4;
  620. +) ENGINE=InnoDB AUTO_INCREMENT=10170 DEFAULT CHARSET=utf8mb4;
  621.  /*!40101 SET character_set_client = @saved_cs_client */;
  622.  
  623.  --
  624. @@ -4952,7 +4954,7 @@
  625.    PRIMARY KEY (`tfa_trusted_id`),
  626.    UNIQUE KEY `user_id` (`user_id`,`trusted_key`),
  627.    KEY `trusted_until` (`trusted_until`)
  628. -) ENGINE=InnoDB AUTO_INCREMENT=53324 DEFAULT CHARSET=utf8mb4;
  629. +) ENGINE=InnoDB AUTO_INCREMENT=53278 DEFAULT CHARSET=utf8mb4;
  630.  /*!40101 SET character_set_client = @saved_cs_client */;
  631.  
  632.  --
  633. @@ -5081,7 +5083,7 @@
  634.    KEY `user_id_date` (`user_id`,`warning_date`),
  635.    KEY `is_expired_expiry` (`is_expired`,`expiry_date`),
  636.    KEY `warning_user_id` (`warning_user_id`)
  637. -) ENGINE=InnoDB AUTO_INCREMENT=22845 DEFAULT CHARSET=utf8mb4;
  638. +) ENGINE=InnoDB AUTO_INCREMENT=22844 DEFAULT CHARSET=utf8mb4;
  639.  /*!40101 SET character_set_client = @saved_cs_client */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!