Continued:

[ctracker.git] / libs / lib_updates.php

diff --git a/libs/lib_updates.php b/libs/lib_updates.php
index a51e584ec8286a2a6f8691e13ec040af77545e0a..c3d028718009b34f7ff4aad6f49c654dce6fd462 100644 (file)
--- a/libs/lib_updates.php
+++ b/libs/lib_updates.php
@@ -98,6 +98,12 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] .
                        FROM `ctracker_data`
                        GROUP BY `request_method`'
                ],
+
+               // Anti-spambot field
+               [
+                       "ALTER TABLE `ctracker_data` CHANGE `proxy_addr` `proxy_addr` varchar(15) COLLATE 'latin1_swedish_ci' NULL COMMENT 'Detected proxy address' AFTER `count`",
+                       "ALTER TABLE `ctracker_data` ADD `spam_bot_dectections` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Spam-bot attempts'",
+               ],
        ];
 }