Now use str_ireplace()

[ctracker.git] / install / install.sql

diff --git a/install/install.sql b/install/install.sql
index d3f4fb6d25860d029f84c77477acdb14cb4c83d7..b8923836a787025ed76afa7dc866b2e0a687dc69 100644 (file)
--- a/install/install.sql
+++ b/install/install.sql
@@ -10,9 +10,10 @@ CREATE TABLE IF NOT EXISTS `ctracker_data` (
        `server_name` tinytext NOT NULL COMMENT 'Server''s host name',
        `script_name` varchar(255) NOT NULL COMMENT 'Full script name',
        `referer` varchar(255) NOT NULL COMMENT 'Referer',
+       `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';