diff options
| author | Amir Sarabadani <Ladsgroup@gmail.com> | 2021-05-27 15:01:24 +0200 |
|---|---|---|
| committer | Amir Sarabadani <Ladsgroup@gmail.com> | 2021-05-27 15:01:24 +0200 |
| commit | acd50760997a79431967cb1764d53199f051abc2 (patch) | |
| tree | ebd14fcfda6099bf98fdc23fe8b77f646d1db8df /maintenance/sqlite/tables-generated.sql | |
| parent | 16bbfcf288750586e70d491e386af825d6003394 (diff) | |
| download | mediawikicore-acd50760997a79431967cb1764d53199f051abc2.tar.gz mediawikicore-acd50760997a79431967cb1764d53199f051abc2.zip | |
Migrate searchindex to abstract schema
For MySQL/Sqlite:
- Nothing
For Postgres:
- Introduce the table. It's not used but it'll be used in the future (T220450)
Bug: T164898
Bug: T230428
Bug: T220450
Change-Id: I9f33132676344f8cd813f7a438b3a6a078fd281c
Diffstat (limited to 'maintenance/sqlite/tables-generated.sql')
| -rw-r--r-- | maintenance/sqlite/tables-generated.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/maintenance/sqlite/tables-generated.sql b/maintenance/sqlite/tables-generated.sql index 6fbd91d0e306..79e2b20c2f88 100644 --- a/maintenance/sqlite/tables-generated.sql +++ b/maintenance/sqlite/tables-generated.sql @@ -888,3 +888,16 @@ CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev CREATE INDEX rev_page_actor_timestamp ON /*_*/revision ( rev_page, rev_actor, rev_timestamp ); + + +CREATE TABLE /*_*/searchindex ( + si_page INTEGER UNSIGNED NOT NULL, + si_title VARCHAR(255) DEFAULT '' NOT NULL, + si_text CLOB 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); |