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-searchindex-table.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-searchindex-table.sql')
| -rw-r--r-- | sql/postgres/patch-searchindex-table.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/postgres/patch-searchindex-table.sql b/sql/postgres/patch-searchindex-table.sql new file mode 100644 index 000000000000..b67e3ee3972b --- /dev/null +++ b/sql/postgres/patch-searchindex-table.sql @@ -0,0 +1,12 @@ + +CREATE TABLE searchindex ( + si_page INT NOT NULL, + si_title VARCHAR(255) DEFAULT '' NOT NULL, + si_text TEXT NOT NULL +); + +CREATE UNIQUE INDEX si_page ON searchindex (si_page); + +CREATE INDEX si_title ON searchindex (si_title); + +CREATE INDEX si_text ON searchindex (si_text); |