Some nice improvements:

[ctracker.git] / install / install.sql

diff --git a/install/install.sql b/install/install.sql
index eb3ce77268fc804b0a5f21941f50dbdeb256062b..aef3d907a925272e66ecc93302e5af7694d8bf24 100644 (file)
--- a/install/install.sql
+++ b/install/install.sql
@@ -10,7 +10,7 @@ CREATE TABLE IF NOT EXISTS `ctracker_data` (
        `script_name` varchar(255) NOT NULL COMMENT 'Full script name',
        `referer` varchar(255) NOT NULL COMMENT 'Referer',
        `first_attempt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'First attempt',
-       `last_attempt` timestamp NOT NULL COMMENT 'Last 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',
        PRIMARY KEY (`id`),
        KEY `remote_addr` (`remote_addr`)