diff options
| author | Amir Sarabadani <Ladsgroup@gmail.com> | 2020-08-29 19:00:04 +0200 |
|---|---|---|
| committer | Amir Sarabadani <Ladsgroup@gmail.com> | 2020-09-05 19:29:23 +0200 |
| commit | 1770341562c515057ab144949a773425c0914705 (patch) | |
| tree | 0951688ed083c7d630bb1673826533f0f9618053 /maintenance/postgres/archives | |
| parent | cb3597be843b3f61a92a312a9bd770f44444d05a (diff) | |
| download | mediawikicore-1770341562c515057ab144949a773425c0914705.tar.gz mediawikicore-1770341562c515057ab144949a773425c0914705.zip | |
Migrate langlinks to abstract schema
In order to migrate MySQL and Sqlite to abstract schema changed the
ll_title data type from varchar binary to varbinary. This wouldn't
affect production.
For migrating Postgres:
- Dropping foreign key on ll_from
- Setting default of empty string for ll_lang and ll_title
- Make ll_lang and ll_title both non-nullable to be in sync with MySQL
- Turning the unique index to primary key, similar to MySQL
- Renaming an index to sync with MySQL
Bug: T164898
Bug: T230428
Change-Id: I57f22896ff67266f99bf08f6dd1b9cc4c51b1db9
Diffstat (limited to 'maintenance/postgres/archives')
| -rw-r--r-- | maintenance/postgres/archives/patch-langlinks-pk.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-langlinks-pk.sql b/maintenance/postgres/archives/patch-langlinks-pk.sql new file mode 100644 index 000000000000..b3a6ea21febd --- /dev/null +++ b/maintenance/postgres/archives/patch-langlinks-pk.sql @@ -0,0 +1,3 @@ +DROP INDEX langlinks_unique; +ALTER TABLE langlinks + ADD PRIMARY KEY (ll_from,ll_lang); |