From 24c464c9ee15b0d204c41fcd212975ebc7864904 Mon Sep 17 00:00:00 2001 From: Pierre Schmitz Date: Sat, 6 Sep 2008 22:50:34 +0200 Subject: Aktualisierung auf 1.13.1 --- maintenance/postgres/tables.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'maintenance/postgres') diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 083af727..2f96c052 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -240,9 +240,8 @@ CREATE TABLE ipblocks ( ipb_range_end TEXT, ipb_deleted SMALLINT NOT NULL DEFAULT 0, ipb_block_email SMALLINT NOT NULL DEFAULT 0 - ); -CREATE INDEX ipb_address ON ipblocks (ipb_address); +CREATE UNIQUE INDEX ipb_address_unique ON ipblocks (ipb_address,ipb_user,ipb_auto,ipb_anon_only); CREATE INDEX ipb_user ON ipblocks (ipb_user); CREATE INDEX ipb_range ON ipblocks (ipb_range_start,ipb_range_end); @@ -569,5 +568,5 @@ CREATE TABLE mediawiki_version ( ); INSERT INTO mediawiki_version (type,mw_version,sql_version,sql_date) - VALUES ('Creation','??','$LastChangedRevision: 37542 $','$LastChangedDate: 2008-07-11 08:11:11 +1000 (Fri, 11 Jul 2008) $'); + VALUES ('Creation','??','$LastChangedRevision: 40517 $','$LastChangedDate: 2008-09-06 17:14:20 +1000 (Sat, 06 Sep 2008) $'); -- cgit v1.2.3-54-g00ecf