diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/2014_05_02_00_action_ip_logger.sql | 18 |
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; |