3 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/auth/2014_04_26_00_rbac_permissions.sql b/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql
index 11beed8f106..11beed8f106 100644
--- a/sql/updates/auth/2014_04_26_00_rbac_permissions.sql
+++ b/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql
diff --git a/sql/updates/auth/2014_04_28_00_rbac_permissions.sql b/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql
index 290052764dd..290052764dd 100644
--- a/sql/updates/auth/2014_04_28_00_rbac_permissions.sql
+++ b/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql
diff --git a/sql/updates/auth/2014_06_23_00_auth_action_ip_logger.sql b/sql/updates/auth/2014_06_23_00_auth_action_ip_logger.sql
new file mode 100644
index 00000000000..375b97d35fc
--- /dev/null
+++ b/sql/updates/auth/2014_06_23_00_auth_action_ip_logger.sql
@@ -0,0 +1,17 @@
+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;