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
[] Request DBA signoff {T318593}
** [x] Move the task to the Triage column on the DBA workboard.
[] Modify [[https://github.com/wikimedia/mediawiki-extensions-WikimediaMaintenance/blob/master/createExtensionTables.php | createExtensionTables.php ]] to include extension and tables you need to use.
[] 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.
=== 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).
-- **TBD**-- Initially 0, then it grows as detailed below.
- Expected growth per year (number of rows).
-- **TBD**-- Using the same (over)estimates as P35379, we could say:
- Expected amount of queries, both writes and reads (per minute, per hour...per day, any of those are ok).--- campaign_events: 500 * 1 * 12 = 6000
-- **TBD**--- 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 ===
(leaving up to DBA to copy the parts they need from the checklist on wikitech)