aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2012_03_28_01_auth_account_access.sql4
-rw-r--r--sql/updates/auth/2012_03_28_02_auth_account_banned.sql4
-rw-r--r--sql/updates/auth/2012_03_28_03_ip_banned.sql2
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;