Once the database review (T318593) is completed, we would like that the extension tables be created in production.
===Partial checklist (from [[https://wikitech.wikimedia.org/wiki/Creating_new_tables | mw:Creating_new_tables ]])===
[x] Create a Phabricator task to track the table creation - you're reading it now
[x] Design the table schema
[x] Write the gerrit patch and get it merged - done for several patches in the last 9 months or so
[x] Request DBA signoff {T318593}
** [x] Move the task to the Triage column on the DBA workboard.
[x] Modify [[https://github.com/wikimedia/mediawiki-extensions-WikimediaMaintenance/blob/master/createExtensionTables.php | createExtensionTables.php ]] to include extension and tables you need to use. -- Not needed, see T318595#8352927.
[x] Add tables to [[https://github.com/wikimedia/mediawiki-extensions-WikimediaMaintenance/blob/master/addWiki.php | addWiki.php ]] - unsure if this one is relevant given where the tables will be, see below. -- Not needed, see T318595#8352927.
=== Details ===
- Should this table be replicated to wiki replicas (does it not contain private data)?
-- There's more than one table with different rules. See P35370
- Will you be doing cross-joins with the wiki metadata?
-- If I understood the question correctly, no.
- Expected amount of queries, both writes and reads (per minute, per hour...per day, any of those are ok).
-- See P35379 for some estimates.
- Size of the table (number of rows expected).
-- Initially 0, then it grows as detailed below.
- Expected growth per year (number of rows).
-- Using the same (over)estimates as P35379, we could say:
--- campaign_events: 500 * 1 * 12 = 6000
--- ce_address: 500 * 0.5 * 12 = 3000
--- ce_event_address: 500 * 0.5 * 12 = 3000
--- ce_organizers: 500 * 5 * 12 = 30000
--- ce_participants: 500 * 300 * 12 = 1800000
- Examples of queries that will be using the table.
-- See T308738#8085151 for a description of the schema and some example queries (could be slightly outdated)
- The release plan for the feature (are there specific wikis you'd like to test first etc).
-- For now, we are requesting that the schema be created on **testwiki**, **test2wiki**, and **officewiki**
[[https://gerrit.wikimedia.org/g/mediawiki/extensions/CampaignEvents/+/4bb97dda96a9a77d00280282f96fabbf4d759bae/db_patches/mysql/tables-generated.sql | Auto-generated mysql file (master version)]]
=== Deployment ===
[x] Make sure the patch which introduces the tables got merged, and confirm files were deployed to production -- done by @Daimona
[] Schedule table creation at a time that doesn't conflict with the deployment schedule
[] Create the tables for each wiki:
-- `mwscript sql.php --wiki=wikidbname --cluster=extension1 extensions/CampaignEvents/db_patches/mysql/tables-generated.sql`