diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2008-09-06 22:50:34 +0200 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2008-09-06 22:50:34 +0200 |
commit | 24c464c9ee15b0d204c41fcd212975ebc7864904 (patch) | |
tree | acc6d8db225ed165010993fe0f11884411dc264d /maintenance/postgres | |
parent | 5521bad534edbcfca285393e36a6a94a3f1be9bf (diff) |
Aktualisierung auf 1.13.1
Diffstat (limited to 'maintenance/postgres')
-rw-r--r-- | maintenance/postgres/tables.sql | 5 |
1 files changed, 2 insertions, 3 deletions
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) $'); |