From 30b3102cf67a89596035e3c9548b630c181cfde8 Mon Sep 17 00:00:00 2001 From: Roland Haeder Date: Fri, 26 Nov 2010 15:30:03 +0000 Subject: [PATCH] Default value of 'count' needs to be 1 --- install/install.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/install/install.sql b/install/install.sql index 73b30c4..b892383 100644 --- a/install/install.sql +++ b/install/install.sql @@ -13,7 +13,7 @@ CREATE TABLE IF NOT EXISTS `ctracker_data` ( `proxy_used` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Proxy used?', `first_attempt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'First attempt', `last_attempt` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Last attempt', - `count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Counter', + `count` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT 'Counter', PRIMARY KEY (`id`), KEY `remote_addr` (`remote_addr`) ) TYPE=InnoDB COMMENT='Gathered data of attack'; -- 2.39.5