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
[x] Design the table schema
[] Write the gerrit patch and get it merged
[] Request DBA signoff
** See information below in the Details section.
** [] Move the task to the Triage column on the DBA workboard.
=== Details ===
- Should this table be replicated to wiki replicas (does it not contain private data)?
-- The data is public, but in order to respect (soft) deletion of events, rows should not be visible if `cett_event` corresponds to a row in `campaign_events` with `event_id=cett_event` and `event_deleted_at IS NOT NULL`.
- Will you be doing cross-joins with the wiki metadata?
-- No
- Size of the table (number of rows expected).
-- Starts off as 0, then it'll grow as explained in the next section.
- Expected growth per year (number of rows).
-- Based on T318595 / P35379, around 6000.
- Expected amount of queries, both writes and reads (per minute, per hour...per day, any of those are ok).
-- Roughly the same as the existing ce_address table, see P35379.
- Examples of queries that will be using the table.
-- `SELECT * FROM ce_tracking_tools WHERE cett_event = 123 [FOR UPDATE]`
-- `SELECT * FROM ce_tracking_tools WHERE cett_event IN (123, 456, 789, ...)`
-- `DELETE FROM ce_tracking_tools WHERE cett_id IN (123, 456, 789, ...)`
-- `INSERT IGNORE INTO ce_tracking_tools $rows`
- The release plan for the feature (are there specific wikis you'd like to test first etc).
-- The extension is only enabled on **testwiki**, **test2wiki**, **officewiki**, and **metawiki**, and the schema should be created on these wikis.
=== Deployment ===
[] Make sure the patch which introduces the tables got merged, and confirm files were deployed to production
[] Schedule table creation at a time that doesn't conflict with the deployment schedule; note the time & date here.
[] Create the tables for each wiki. Note that we don't have a standalone .sql file, so the SQL below should be run interactively for each wiki:
-- `mwscript sql.php --wiki=testwiki --cluster=extension1`
-- `mwscript sql.php --wiki=test2wiki --cluster=extension1`
-- `mwscript sql.php --wiki=officewiki --cluster=extension1`
-- `mwscript sql.php --wiki=metawiki --cluster=extension1 --wikidb=wikishared`
```lang=sql
CREATE TABLE ce_tracking_tools (
cett_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
cett_event BIGINT UNSIGNED NOT NULL,
cett_tool_id INT NOT NULL,
cett_tool_event_id VARBINARY(512) NOT NULL,
cett_sync_status INT NOT NULL,
cett_last_sync BINARY(14) DEFAULT NULL,
UNIQUE INDEX cett_event_tool_teid (
cett_event, cett_tool_id, cett_tool_event_id
),
PRIMARY KEY(cett_id)
);
```