Merge pull request #11976 from Ascathor/master

Core/Misc: New ability to log account IP access history 

1 files changed, 18 insertions, 0 deletions

diff --git a/sql/updates/auth/2014_05_02_00_action_ip_logger.sql b/sql/updates/auth/2014_05_02_00_action_ip_logger.sql
new file mode 100644
index 00000000000..f5603738f54
--- /dev/null
+++ b/sql/updates/auth/2014_05_02_00_action_ip_logger.sql
@@ -0,0 +1,18 @@
+ALTER TABLE `account`
+	ADD COLUMN `last_attempt_ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1' AFTER `last_ip`;
+	
+CREATE TABLE `logs_ip_actions` (
+`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
+`account_id` INT(10) UNSIGNED NOT NULL COMMENT 'Account ID',
+`character_guid` INT(10) UNSIGNED NOT NULL COMMENT 'Character Guid',
+`type` TINYINT(3) UNSIGNED NOT NULL,
+`ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1',
+`systemnote` TEXT NULL COMMENT 'Notes inserted by system',
+`unixtime` INT(10) UNSIGNED NOT NULL COMMENT 'Unixtime',
+`time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp',
+`comment` TEXT NULL COMMENT 'Allows users to add a comment',
+PRIMARY KEY (`id`)
+)
+COMMENT='Used to log ips of individual actions'
+COLLATE='utf8_general_ci'
+ENGINE=InnoDB;