diff options
| author | Ammar Abdulhamid <ammarpad@yahoo.com> | 2020-11-23 05:33:36 +0100 |
|---|---|---|
| committer | Ammarpad <ammarpad@yahoo.com> | 2021-03-21 12:07:12 +0100 |
| commit | 6a3aa5b5a2c91c07be669dc915cb4ba38a5a8692 (patch) | |
| tree | c14e31ecb5af5951a3c47c211e9b37de973a9a8a /maintenance/archives/patch-page-page_title-varbinary.sql | |
| parent | b0f893f4ad38358c7fe6a22cab686f8c95ca9407 (diff) | |
| download | mediawikicore-6a3aa5b5a2c91c07be669dc915cb4ba38a5a8692.tar.gz mediawikicore-6a3aa5b5a2c91c07be669dc915cb4ba38a5a8692.zip | |
Migrate page to abstract schema
Postgres:
- Change page_namespace from smallint to int
- Change page_random from numeric with arbitrary precision to float
- Make page_touched not nullable
MySQL/SQLite:
- Change datatype of page_title from varchar (with binary collation)
to varbinary(255)
- Drop default empty string from timestamp field of page_touched
Bug: T230428
Bug: T164898
Change-Id: Ibdaf332ea1da309d31d35a6ebbc1b8fefced335e
Diffstat (limited to 'maintenance/archives/patch-page-page_title-varbinary.sql')
| -rw-r--r-- | maintenance/archives/patch-page-page_title-varbinary.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/maintenance/archives/patch-page-page_title-varbinary.sql b/maintenance/archives/patch-page-page_title-varbinary.sql new file mode 100644 index 000000000000..2604244582c2 --- /dev/null +++ b/maintenance/archives/patch-page-page_title-varbinary.sql @@ -0,0 +1 @@ +ALTER TABLE /*_*/page MODIFY page_title VARBINARY(255) NOT NULL; |