diff options
| -rw-r--r-- | sql/updates/auth/2013_02_04_00_auth_misc.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/2013_02_05_00_auth_account.sql | 2 |
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/auth/2013_02_04_00_auth_misc.sql b/sql/updates/auth/2013_02_04_00_auth_misc.sql index 815df637be0..d8a508e4e7b 100644 --- a/sql/updates/auth/2013_02_04_00_auth_misc.sql +++ b/sql/updates/auth/2013_02_04_00_auth_misc.sql @@ -1,3 +1,6 @@ +-- Explicitly set the account-table to use INNODB-engine (to allow foreign keys and transactions) +ALTER TABLE account ENGINE=InnoDB; + -- Delete bad data from the DB before adding foreign keys DELETE FROM `account_access` WHERE `id` NOT IN (SELECT `id` FROM `account`); diff --git a/sql/updates/auth/2013_02_05_00_auth_account.sql b/sql/updates/auth/2013_02_05_00_auth_account.sql new file mode 100644 index 00000000000..2f32c5e3e3e --- /dev/null +++ b/sql/updates/auth/2013_02_05_00_auth_account.sql @@ -0,0 +1,2 @@ +-- Explicitly set the account-table to use INNODB-engine (to allow foreign keys and transactions) +ALTER TABLE account ENGINE=InnoDB; |