| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -185,10 +185,13 @@ |
| 186 | 186 | CREATE UNIQUE INDEX il_from ON imagelinks (il_to,il_from); |
| 187 | 187 | |
| 188 | 188 | CREATE TABLE categorylinks ( |
| 189 | | - cl_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
| 190 | | - cl_to TEXT NOT NULL, |
| 191 | | - cl_sortkey TEXT, |
| 192 | | - cl_timestamp TIMESTAMPTZ NOT NULL |
| | 189 | + cl_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
| | 190 | + cl_to TEXT NOT NULL, |
| | 191 | + cl_sortkey TEXT NULL, |
| | 192 | + cl_timestamp TIMESTAMPTZ NOT NULL, |
| | 193 | + cl_sortkey_prefix TEXT NOT NULL DEFAULT '', |
| | 194 | + cl_collation SMALLINT NOT NULL DEFAULT 0, |
| | 195 | + cl_type TEXT NOT NULL DEFAULT 'page' |
| 193 | 196 | ); |
| 194 | 197 | CREATE UNIQUE INDEX cl_from ON categorylinks (cl_from, cl_to); |
| 195 | 198 | CREATE INDEX cl_sortkey ON categorylinks (cl_to, cl_sortkey, cl_from); |