TDB 335.11.47 - 2012/05/19TDB335.11.47

13 files changed, 0 insertions, 57 deletions

diff --git a/sql/updates/auth/2012_02_19_00_auth_account.sql b/sql/updates/auth/2012_02_19_00_auth_account.sql
deleted file mode 100644
index a5b48ede3b4..00000000000
--- a/sql/updates/auth/2012_02_19_00_auth_account.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `account`
-    ADD COLUMN `os` VARCHAR(4) DEFAULT '' NOT NULL AFTER `locale`;
diff --git a/sql/updates/auth/2012_03_25_00_auth_misc.sql b/sql/updates/auth/2012_03_25_00_auth_misc.sql
deleted file mode 100644
index f34882af8f6..00000000000
--- a/sql/updates/auth/2012_03_25_00_auth_misc.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-ALTER TABLE `account_banned`
-    CHANGE `bandate` `bandate` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
-    CHANGE `unbandate` `unbandate` INT(10) UNSIGNED DEFAULT 0 NOT NULL;
-
-ALTER TABLE `ip_banned`
-    CHANGE `ip` `ip` VARCHAR(15) CHARSET utf8 COLLATE utf8_general_ci DEFAULT '127.0.0.1' NOT NULL,
-    CHANGE `bandate` `bandate` INT(10) UNSIGNED NOT NULL,
-    CHANGE `unbandate` `unbandate` INT(10) UNSIGNED NOT NULL;
diff --git a/sql/updates/auth/2012_03_26_00_auth_realmlist.sql b/sql/updates/auth/2012_03_26_00_auth_realmlist.sql
deleted file mode 100644
index 0a570a31773..00000000000
--- a/sql/updates/auth/2012_03_26_00_auth_realmlist.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `realmlist`
-    CHANGE `color` `flag` tinyint(3) unsigned NOT NULL DEFAULT '2';
diff --git a/sql/updates/auth/2012_03_28_00_auth_account.sql b/sql/updates/auth/2012_03_28_00_auth_account.sql
deleted file mode 100644
index 199baac5178..00000000000
--- a/sql/updates/auth/2012_03_28_00_auth_account.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-ALTER TABLE `account`
- CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
- CHANGE `sessionkey` `sessionkey` VARCHAR(80) NOT NULL DEFAULT '',
- CHANGE `v` `v` VARCHAR(64) NOT NULL DEFAULT '',
- CHANGE `s` `s` VARCHAR(64) NOT NULL DEFAULT '',
- CHANGE `email` `email` VARCHAR(254) NOT NULL DEFAULT '',
- CHANGE `last_ip` `last_ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1',
- CHANGE `failed_logins` `failed_logins` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- CHANGE `online` `online` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
- CHANGE `mutetime` `mutetime` BIGINT(20) NOT NULL DEFAULT '0',
- CHANGE `os` `os` VARCHAR(3) NOT NULL DEFAULT '',
- CHANGE `recruiter` `recruiter` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_01_auth_account_access.sql b/sql/updates/auth/2012_03_28_01_auth_account_access.sql
deleted file mode 100644
index 456dbf6c104..00000000000
--- a/sql/updates/auth/2012_03_28_01_auth_account_access.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `account_access`
- CHANGE `id` `id` INT(10) UNSIGNED NOT NULL,
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_02_auth_account_banned.sql b/sql/updates/auth/2012_03_28_02_auth_account_banned.sql
deleted file mode 100644
index 917cea1a684..00000000000
--- a/sql/updates/auth/2012_03_28_02_auth_account_banned.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `account_banned`
- CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL COMMENT 'Account id',
- CHANGE `active` `active` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL,
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_03_auth_ip_banned.sql b/sql/updates/auth/2012_03_28_03_auth_ip_banned.sql
deleted file mode 100644
index 2e754effc60..00000000000
--- a/sql/updates/auth/2012_03_28_03_auth_ip_banned.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `ip_banned`
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_04_auth_logs.sql b/sql/updates/auth/2012_03_28_04_auth_logs.sql
deleted file mode 100644
index 4c837a47ed1..00000000000
--- a/sql/updates/auth/2012_03_28_04_auth_logs.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-ALTER TABLE `logs`
- CHANGE `time` `time` INT(10) UNSIGNED NOT NULL,
- CHANGE `realm` `realm` INT(10) UNSIGNED NOT NULL,
- CHANGE `type` `type` TINYINT(3) UNSIGNED NOT NULL,
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql b/sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql
deleted file mode 100644
index e50b3c3f331..00000000000
--- a/sql/updates/auth/2012_03_28_05_auth_realmcharacters.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `realmcharacters`
- CHANGE `realmid` `realmid` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
- CHANGE `acctid` `acctid` INT(10) UNSIGNED NOT NULL,
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_06_auth_realmlist.sql b/sql/updates/auth/2012_03_28_06_auth_realmlist.sql
deleted file mode 100644
index 725702a9803..00000000000
--- a/sql/updates/auth/2012_03_28_06_auth_realmlist.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-ALTER TABLE `realmlist`
- CHANGE `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
- CHANGE `address` `address` VARCHAR(15) DEFAULT '127.0.0.1' NOT NULL,
- CHANGE `port` `port` SMALLINT(5) UNSIGNED DEFAULT '8085' NOT NULL,
- CHANGE `gamebuild` `gamebuild` INT(10) UNSIGNED DEFAULT '12340' NOT NULL,
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_03_28_07_auth_uptime.sql b/sql/updates/auth/2012_03_28_07_auth_uptime.sql
deleted file mode 100644
index 0ea4e3321df..00000000000
--- a/sql/updates/auth/2012_03_28_07_auth_uptime.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-ALTER TABLE `uptime`
- DROP COLUMN `startstring`,
- CHANGE `realmid` `realmid` INT(10) UNSIGNED NOT NULL,
- CHANGE `starttime` `starttime` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
- CHANGE `uptime` `uptime` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
- ROW_FORMAT=DEFAULT ENGINE=INNODB;
diff --git a/sql/updates/auth/2012_04_01_00_auth_realmlist.sql b/sql/updates/auth/2012_04_01_00_auth_realmlist.sql
deleted file mode 100644
index e2e1efaf993..00000000000
--- a/sql/updates/auth/2012_04_01_00_auth_realmlist.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `realmlist` CHANGE `address` `address` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1';
diff --git a/sql/updates/auth/2012_04_04_00_auth_realmlist.sql b/sql/updates/auth/2012_04_04_00_auth_realmlist.sql
deleted file mode 100644
index 18f2d7b3d4c..00000000000
--- a/sql/updates/auth/2012_04_04_00_auth_realmlist.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `realmlist` CHANGE `address` `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1';