diff options
| author | Amir Sarabadani <ladsgroup@gmail.com> | 2025-01-20 20:01:17 +0100 |
|---|---|---|
| committer | Amir Sarabadani <ladsgroup@gmail.com> | 2025-01-21 15:07:44 +0100 |
| commit | a7a607fc40806df29dc4f220623156562575ba4c (patch) | |
| tree | aa985e6bba61d5af1c9ec699e312d6ff142de224 /sql/postgres/patch-collation.sql | |
| parent | 54989cd56e5de0c1d1d8bcf2efadd2032bf6f995 (diff) | |
| download | mediawikicore-a7a607fc40806df29dc4f220623156562575ba4c.tar.gz mediawikicore-a7a607fc40806df29dc4f220623156562575ba4c.zip | |
schema: Add cl_target_id and cl_collation_id to categorylinks
To normalize cl_to and cl_collation
Bug: T299951
Change-Id: If58190f3cc912ffa99c623dc9f51d530d5c87186
Diffstat (limited to 'sql/postgres/patch-collation.sql')
| -rw-r--r-- | sql/postgres/patch-collation.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/postgres/patch-collation.sql b/sql/postgres/patch-collation.sql new file mode 100644 index 000000000000..a1bde56fe25c --- /dev/null +++ b/sql/postgres/patch-collation.sql @@ -0,0 +1,7 @@ +CREATE TABLE "collation" ( + collation_id SMALLSERIAL NOT NULL, + collation_name TEXT NOT NULL, + PRIMARY KEY(collation_id) +); + +CREATE UNIQUE INDEX collation_name ON "collation" (collation_name); |