| Index: trunk/phase3/maintenance/postgres/archives/patch-categorylinks-better-collation.sql |
| — | — | @@ -1,7 +1,7 @@ |
| 2 | 2 | CREATE TYPE link_type AS ENUM ('page', 'subcat', 'file'); |
| 3 | 3 | DROP INDEX cl_sortkey; |
| 4 | 4 | ALTER TABLE categorylinks |
| 5 | | - ADD COLUMN cl_raw_sortkey TEXT NULL DEFAULT NULL, |
| | 5 | + ADD COLUMN cl_sortkey_prefix TEXT NOT NULL DEFAULT '', |
| 6 | 6 | ADD COLUMN cl_collation SMALLINT NOT NULL DEFAULT 0, |
| 7 | 7 | ADD COLUMN cl_type link_type NOT NULL DEFAULT 'page'; |
| 8 | 8 | CREATE INDEX cl_collation ON categorylinks ( cl_collation ); |