diff options
| author | jenkins-bot <jenkins-bot@gerrit.wikimedia.org> | 2024-12-13 14:54:36 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@wikimedia.org> | 2024-12-13 14:54:36 +0000 |
| commit | 2d8285583f1866a0b00ec4df8365fb5fc63e0072 (patch) | |
| tree | 6375b9e4e1001936f3259f7f4674bfbad369b080 /sql/postgres/patch-linktarget.sql | |
| parent | a42ef21f4f2fed3f76214568c4c9b91bd45435e6 (diff) | |
| parent | 251f4395865f8a33bcf32c6faa11748a14753492 (diff) | |
| download | mediawikicore-2d8285583f1866a0b00ec4df8365fb5fc63e0072.tar.gz mediawikicore-2d8285583f1866a0b00ec4df8365fb5fc63e0072.zip | |
Merge "Move SQL schema and schema changes to new sql/ top-level directory"
Diffstat (limited to 'sql/postgres/patch-linktarget.sql')
| -rw-r--r-- | sql/postgres/patch-linktarget.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/postgres/patch-linktarget.sql b/sql/postgres/patch-linktarget.sql new file mode 100644 index 000000000000..9181b6aa0797 --- /dev/null +++ b/sql/postgres/patch-linktarget.sql @@ -0,0 +1,8 @@ +CREATE TABLE linktarget ( + lt_id BIGSERIAL NOT NULL, + lt_namespace INT NOT NULL, + lt_title TEXT NOT NULL, + PRIMARY KEY(lt_id) +); + +CREATE UNIQUE INDEX lt_namespace_title ON linktarget (lt_namespace, lt_title); |