From 4bfb9a1850f26bf155a1bbca4e0431c89e1a2986 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Mon, 29 Feb 2016 13:43:00 +0100 Subject: [PATCH] Bug 15516: Update old_reserves (reserve_group_id) Without it, deletion of reserves will fail --- installer/data/mysql/atomicupdate/bug_15516.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_15516.sql b/installer/data/mysql/atomicupdate/bug_15516.sql index efd761e..090129a 100644 --- a/installer/data/mysql/atomicupdate/bug_15516.sql +++ b/installer/data/mysql/atomicupdate/bug_15516.sql @@ -6,3 +6,5 @@ CREATE TABLE reserve_group ( ALTER TABLE reserves ADD COLUMN reserve_group_id int unsigned NULL DEFAULT NULL; ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_5 FOREIGN KEY (reserve_group_id) REFERENCES reserve_group (reserve_group_id) ON DELETE SET NULL ON UPDATE CASCADE; + +ALTER TABLE old_reserves ADD COLUMN reserve_group_id int unsigned NULL DEFAULT NULL; -- 1.9.1