From 6807e37e2073e32a41276168f65a8bae378d661d Mon Sep 17 00:00:00 2001 From: OverlordQ Date: Wed, 28 Jul 2010 05:08:21 +0000 Subject: [PATCH] Followup to r69961, update PG schema --- .../postgres/archives/patch-categorylinks-better-collation.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/postgres/archives/patch-categorylinks-better-collation.sql b/maintenance/postgres/archives/patch-categorylinks-better-collation.sql index 29a2d29015..b3fa634645 100644 --- a/maintenance/postgres/archives/patch-categorylinks-better-collation.sql +++ b/maintenance/postgres/archives/patch-categorylinks-better-collation.sql @@ -1,7 +1,7 @@ CREATE TYPE link_type AS ENUM ('page', 'subcat', 'file'); DROP INDEX cl_sortkey; ALTER TABLE categorylinks - ADD COLUMN cl_raw_sortkey TEXT NULL DEFAULT NULL, + ADD COLUMN cl_sortkey_prefix TEXT NOT NULL DEFAULT '', ADD COLUMN cl_collation SMALLINT NOT NULL DEFAULT 0, ADD COLUMN cl_type link_type NOT NULL DEFAULT 'page'; CREATE INDEX cl_collation ON categorylinks ( cl_collation ); -- 2.20.1