diff options
author | Daimona Eaytoy <daimona.wiki@gmail.com> | 2024-12-12 23:47:46 +0100 |
---|---|---|
committer | Daimona Eaytoy <daimona.wiki@gmail.com> | 2024-12-13 14:59:35 +0000 |
commit | 09cdb3b66869998615a742caabe3a9cc32d8e991 (patch) | |
tree | a131090755c519bdfca581fd59274310e786c1c1 /sql/mysql/patch-filearchive-fa_id.sql | |
parent | 2d8285583f1866a0b00ec4df8365fb5fc63e0072 (diff) | |
download | mediawikicore-09cdb3b66869998615a742caabe3a9cc32d8e991.tar.gz mediawikicore-09cdb3b66869998615a742caabe3a9cc32d8e991.zip |
Re-generate all schema change files
This gives us a solid baseline to use for automated tests. Whitespace
differences will be ignored by the test, but regenerate these anyway
because they're much more readable now, and it's generally nice to have
a clean baseline.
Differences are due to:
- JSON files being moved in T382030
- JSON paths in the autogenerated comment are now standardized
(I358cc24798f518d7)
- Whitespace changes from Ib2f60b492ced8ff
- Actual SQL changes from newer versions of doctrine/dbal
There's also one important exception: the SQLite schema change for
patch-page-rename-name_title-index no longer matches the JSON file since
I17e73d5ef1. There doesn't seem to be a super-simple way around this,
because we don't know the state of the database pre-update. On top of
that, I believe that removing the field from the .sql file as done in
I17e73d5ef1 could've caused data loss when upgrading from old versions:
the column could be silently dropped before running the DB update that
correctly migrates and drop the column. This is something to keep in
mind going forwards, and T381981 will prevent it from happening that
easily. But for the update in question, it's probably too late, so just
update the JSON file to match the .sql files.
Bug: T381981
Bug: T382030
Change-Id: I3a3acc0935409d4601eb172664580b13d5fe2340
Diffstat (limited to 'sql/mysql/patch-filearchive-fa_id.sql')
-rw-r--r-- | sql/mysql/patch-filearchive-fa_id.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/mysql/patch-filearchive-fa_id.sql b/sql/mysql/patch-filearchive-fa_id.sql index 2a651cfed072..89d2a65cf404 100644 --- a/sql/mysql/patch-filearchive-fa_id.sql +++ b/sql/mysql/patch-filearchive-fa_id.sql @@ -1,6 +1,6 @@ -- This file is automatically generated using maintenance/generateSchemaChangeSql.php. --- Source: maintenance/abstractSchemaChanges/patch-filearchive-fa_id.json +-- Source: sql/abstractSchemaChanges/patch-filearchive-fa_id.json -- Do not modify this file directly. -- See https://www.mediawiki.org/wiki/Manual:Schema_changes -ALTER TABLE /*_*/filearchive -CHANGE fa_id fa_id INT UNSIGNED AUTO_INCREMENT NOT NULL;
\ No newline at end of file +ALTER TABLE /*_*/filearchive + CHANGE fa_id fa_id INT UNSIGNED AUTO_INCREMENT NOT NULL; |