TDB 335.54 - 2014/07/05TDB335.54

3 files changed, 0 insertions, 48 deletions

diff --git a/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql b/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql
deleted file mode 100644
index 11beed8f106..00000000000
--- a/sql/updates/auth/2014_04_26_00_auth_rbac_permissions.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-SET @id = 614;
-
--- Add new permissions
-DELETE FROM `rbac_permissions` WHERE `id`=@id;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(@id, 'Command: broadcast_text');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@id;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, @id);
diff --git a/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql b/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql
deleted file mode 100644
index 290052764dd..00000000000
--- a/sql/updates/auth/2014_04_28_00_auth_rbac_permissions.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` IN (631,632,633,634,635,636,637,638,639,640);
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(633, 'Command: reload creature_linked_respawn'),
-(634, 'Command: reload creature_loot_template'),
-(635, 'Command: reload creature_onkill_reputation'),
-(636, 'Command: reload creature_questender'),
-(637, 'Command: reload creature_queststarter'),
-(638, 'Command: reload creature_summon_groups'),
-(639, 'Command: reload creature_template'),
-(640, 'Command: reload creature_text');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (631,632,633,634,635,636,637,638,639,640);
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, 633),
-(196, 634),
-(196, 635),
-(196, 636),
-(196, 637),
-(196, 638),
-(196, 639),
-(196, 640);
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
deleted file mode 100644
index 375b97d35fc..00000000000
--- a/sql/updates/auth/2014_06_23_00_auth_action_ip_logger.sql
+++ /dev/null
@@ -1,17 +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;