Plugin Directory: Missing tables

[ocean90]

I get a few database errors because of missing tables:

SELECT downloads FROM wporg_367_stats WHERE stamp >= '2016-06-02' AND plugin_slug = 'broken-link-checker'
Table 'wordpressorg_dev.wporg_367_stats' doesn't exist

SELECT downloads FROM wporg_367_stats WHERE stamp >= '2016-06-01' AND stamp < '2016-06-02' AND plugin_slug = 'broken-link-checker'
Table 'wordpressorg_dev.wporg_367_stats' doesn't exist

SELECT SUM(downloads) FROM wporg_367_stats WHERE stamp >= '2016-05-26' AND plugin_slug = 'broken-link-checker'
Table 'wordpressorg_dev.wporg_367_stats' doesn't exist

SELECT downloads FROM `wporg_367_download_counts` WHERE topic_id = (SELECT topic_id FROM `wporg_367_topics` WHERE topic_slug = 'broken-link-checker' )
Table 'wordpressorg_dev.wporg_367_download_counts' doesn't exist

SELECT user FROM `wporg_367_svn_access` WHERE path = '/broken-link-checker'
Table 'wordpressorg_dev.wporg_367_svn_access' doesn't exist

• https://meta.trac.wordpress.org/browser/sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/class-template.php?rev=3187&marks=44,59#L33
• https://meta.trac.wordpress.org/browser/sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/class-tools.php?rev=2836&marks=41,65,103,134#L31

Should we add them?

cc: @obenland

[obenland]

We probably should eventually

[iandunn]

it doesn’t look like there’s anything in the code that creates those tables, were they just created manually on production?

[iandunn]

We need to do a refresh of the database anyway, since there's been a lot of progress in the last 6 months, so we can just include all the custom tables at that time.

[grappler]

The only table missing error that I getting now is for wordpressorg_dev.locales

https://github.com/WordPress/meta-environment/issues/90