diff options
| author | click <click@gonnamakeyou.com> | 2013-02-05 22:20:55 +0100 |
|---|---|---|
| committer | click <click@gonnamakeyou.com> | 2013-02-05 22:20:55 +0100 |
| commit | 00d299f12f406020abbd705476677d0a2f17486c (patch) | |
| tree | 16daad125f96ea4578ab1ede8e5152846e2589b4 | |
| parent | f205613eb5a47c390d0403e3b01a021304406617 (diff) | |
Core/SQL: Explicitly set the auth.account-table to use the INNODB-engine (to allow foreign keys and transactions)
If you have an OLD database (auth), and RBAC SQL-alterations, make SURE that it's InnoDB, otherwise run this (it can be run multiple times anyway)
(The only change added is to alter the table to explicitly be an InnoDB-table)
| -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; |