**Acceptance Criteria:**
* Define the updated database schema for storing wikis of event
* Implement a [[https://www.mediawiki.org/wiki/Manual:Schema_changes#Abstract_schema_change | schema change ]] for it
* Existing events must be treated as if "no wikis" was chosen
* Create the schema in production and beta
===[[https://wikitech.wikimedia.org/wiki/Creating_new_tables#Preparation | Checklist ]] ===
[x] Design the schema
[x] Make schema change patch for it
[x] Get initial reviews (+1s)
[x] Tag this task with #dba
[x] Request DBA signoff
[] Get approval
====Deployment====
[] Merge the schema patch
-- This will automatically create the new table in beta
[] Wait until the patch reaches production
[] Schedule a dedicated [[https://wikitech.wikimedia.org/wiki/Deployments | deployment window ]], note the time here
[] Create the table everywhere:
-- `mwscript sql.php --wiki=testwiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.XX/extensions/CampaignEvents/db_patches/mysql/PATCH-NAME.sql`
-- `mwscript sql.php --wiki=test2wiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.XX/extensions/CampaignEvents/db_patches/mysql/PATCH-NAME.sql`
-- `mwscript sql.php --wiki=officewiki --cluster=extension1 /srv/mediawiki/php-1.44.0-wmf.XX/extensions/CampaignEvents/db_patches/mysql/PATCH-NAME.sql`
-- `mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb wikishared /srv/mediawiki/php-1.44.0-wmf.XX/extensions/CampaignEvents/db_patches/mysql/PATCH-NAME.sql`