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