SQL: Auth db data type cleanup `account_access`, `account_banned`, `ip_banned` / Storage engine switched to InnoDB

3 files changed, 10 insertions, 0 deletions

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
new file mode 100644
index 00000000000..7f79634d765
--- /dev/null
+++ b/sql/updates/auth/2012_03_28_01_auth_account_access.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `account_access`
+ CHANGE `id` `id` INT(10) UNSIGNED NOT NULL,
+ ROW_FORMAT=DEFAULT ENGINE=INNODB;
+ 
\ No newline at end of file
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
new file mode 100644
index 00000000000..917cea1a684
--- /dev/null
+++ b/sql/updates/auth/2012_03_28_02_auth_account_banned.sql
@@ -0,0 +1,4 @@
+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_ip_banned.sql b/sql/updates/auth/2012_03_28_03_ip_banned.sql
new file mode 100644
index 00000000000..2e754effc60
--- /dev/null
+++ b/sql/updates/auth/2012_03_28_03_ip_banned.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `ip_banned`
+ ROW_FORMAT=DEFAULT ENGINE=INNODB;