From 00d299f12f406020abbd705476677d0a2f17486c Mon Sep 17 00:00:00 2001 From: click Date: Tue, 5 Feb 2013 22:20:55 +0100 Subject: 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) --- sql/updates/auth/2013_02_04_00_auth_misc.sql | 3 +++ sql/updates/auth/2013_02_05_00_auth_account.sql | 2 ++ 2 files changed, 5 insertions(+) create mode 100644 sql/updates/auth/2013_02_05_00_auth_account.sql (limited to 'sql') 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; -- cgit v1.2.3