http://www.mediawiki.org/wiki/Special:Code/MediaWiki/70065
Revision: 70065
Author: overlordq
Date: 2010-07-28 05:08:21 +0000 (Wed, 28 Jul 2010)
Log Message:
-----------
Followup to r69961, update PG schema
Modified Paths:
--------------
trunk/phase3/maintenance/postgres/archives/patch-categorylinks-better-collation.sql
Modified:
trunk/phase3/maintenance/postgres/archives/patch-categorylinks-better-collation.sql
===================================================================
---
trunk/phase3/maintenance/postgres/archives/patch-categorylinks-better-collation.sql
2010-07-28 04:22:01 UTC (rev 70064)
+++
trunk/phase3/maintenance/postgres/archives/patch-categorylinks-better-collation.sql
2010-07-28 05:08:21 UTC (rev 70065)
@@ -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 );
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
