From ec59bf569930a6b2f5c5922214b150dde9314842 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Tue, 24 Jun 2014 18:30:51 +0200 Subject: SQL: Rename sql after merge pr --- sql/updates/auth/2014_05_02_00_action_ip_logger.sql | 18 ------------------ sql/updates/auth/2014_06_23_00_action_ip_logger.sql | 18 ++++++++++++++++++ 2 files changed, 18 insertions(+), 18 deletions(-) delete mode 100644 sql/updates/auth/2014_05_02_00_action_ip_logger.sql create mode 100644 sql/updates/auth/2014_06_23_00_action_ip_logger.sql (limited to 'sql') 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 deleted file mode 100644 index f5603738f54..00000000000 --- a/sql/updates/auth/2014_05_02_00_action_ip_logger.sql +++ /dev/null @@ -1,18 +0,0 @@ -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; diff --git a/sql/updates/auth/2014_06_23_00_action_ip_logger.sql b/sql/updates/auth/2014_06_23_00_action_ip_logger.sql new file mode 100644 index 00000000000..f5603738f54 --- /dev/null +++ b/sql/updates/auth/2014_06_23_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; -- cgit v1.2.3