changed my mind about the expiry key. reverted to erry's version

git-svn-id: http://svn.tabris.net/repos/srsv@3574 70d4eda1-72e9-0310-a436-91e5bd24443c

diff --git a/branches/0.4.3/sql/004003005.sql b/branches/0.4.3/sql/004003005.sql
index b4dfef1500a37f47c118e76e05562d416be635d9..8ef5a2e1b7609b5478bde62590527edcdeda250f 100644 (file)
--- a/branches/0.4.3/sql/004003005.sql
+++ b/branches/0.4.3/sql/004003005.sql
@@ -8,7 +8,7 @@ CREATE TABLE IF NOT EXISTS `tmpban` (
   `expiry` bigint(20) unsigned NOT NULL,
   `timeset` bigint(20) unsigned NOT NULL,
   UNIQUE KEY `banmask` (`channel`, `banmask`),
-  KEY `expiry` (`expiry`, `channel`)
+  KEY `expiry` (`expiry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 REPLACE INTO `srsv_schema` (`ver`) VALUES (4003005);