From a01e2a59cd2904db7c39e2b8fc40901b0926f883 Mon Sep 17 00:00:00 2001 From: leak Date: Wed, 28 Mar 2012 16:48:49 +0200 Subject: SQL: Auth db data type cleanup `account_access`, `account_banned`, `ip_banned` / Storage engine switched to InnoDB --- sql/updates/auth/2012_03_28_01_auth_account_access.sql | 4 ++++ sql/updates/auth/2012_03_28_02_auth_account_banned.sql | 4 ++++ sql/updates/auth/2012_03_28_03_ip_banned.sql | 2 ++ 3 files changed, 10 insertions(+) create mode 100644 sql/updates/auth/2012_03_28_01_auth_account_access.sql create mode 100644 sql/updates/auth/2012_03_28_02_auth_account_banned.sql create mode 100644 sql/updates/auth/2012_03_28_03_ip_banned.sql (limited to 'sql/updates/auth') 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; -- cgit v1.2.3