Added listing of wrong 'SERVER_NAME' entries

[mailer.git] / inc / extensions / ext-sql_patches.php

diff --git a/inc/extensions/ext-sql_patches.php b/inc/extensions/ext-sql_patches.php
index 30bb078be9fd88f5282fcd51957880fbd128937c..f0d1c40cba95516c204e82a599853850988c8226 100644 (file)
--- a/inc/extensions/ext-sql_patches.php
+++ b/inc/extensions/ext-sql_patches.php
@@ -935,14 +935,17 @@ INDEX (`history_last_used` DESC)",
                                break;
 
                        case '0.9.1': // SQL queries for v0.9.1
+                               // Add admin menu
                                addAdminMenuSql('misc', 'list_server_name', 'Verkehrte Domains auflisten', 'Listet alle als verkehrt erkannten Domains auf.', 4);
+
+                               // Create table
                                addCreateTableSql('server_name_log', "
 `server_name_id` BIGINT (20) NOT NULL AUTO_INCREMENT,
 `server_name` VARCHAR (255) NOT NULL DEFAULT 'invalid',
-`server_name_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `server_name_remote_addr` VARCHAR (15) NOT NULL DEFAULT '0.0.0.0',
 `server_name_ua` TINYTEXT NULL DEFAULT NULL,
 `server_name_referrer` TINYTEXT NULL DEFAULT NULL,
+`server_name_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `server_name_counter` BIGINT (20) NOT NULL DEFAULT 1,
 PRIMARY KEY (`server_name_id`)
 ", 'Logging of wrong SERVER_NAME');