From 4bc1556d37924dda3316dccf2bed00b6a37fcb6e Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 17 Jul 2018 10:07:35 -0400 Subject: [PATCH] Bug 14570 [QA Followup]: Don't remove existing columns for the time being, pending review of request 3 --- installer/data/mysql/atomicupdate/bug_14570.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_14570.sql b/installer/data/mysql/atomicupdate/bug_14570.sql index 9c8e987a96..6697b32dd1 100644 --- a/installer/data/mysql/atomicupdate/bug_14570.sql +++ b/installer/data/mysql/atomicupdate/bug_14570.sql @@ -14,6 +14,6 @@ UPDATE borrowers LEFT JOIN borrowers guarantor ON ( borrowers.guarantorid = guar INSERT INTO borrower_relationships ( guarantor_id, guarantee_id, relationship, surname, firstname ) SELECT guarantorid, borrowernumber, relationship, contactname, contactfirstname FROM borrowers WHERE guarantorid IS NOT NULL OR contactname != ""; -ALTER TABLE borrowers DROP guarantorid, DROP relationship, DROP contactname, DROP contactfirstname, DROP contacttitle; -ALTER TABLE deletedborrowers DROP guarantorid, DROP relationship, DROP contactname, DROP contactfirstname, DROP contacttitle; -ALTER TABLE borrowermodification DROP guarantorid, DROP relationship, DROP contactname, DROP contactfirstname, DROP contacttitle; +-- ALTER TABLE borrowers DROP guarantorid, DROP relationship, DROP contactname, DROP contactfirstname, DROP contacttitle; +-- ALTER TABLE deletedborrowers DROP guarantorid, DROP relationship, DROP contactname, DROP contactfirstname, DROP contacttitle; +-- ALTER TABLE borrowermodification DROP guarantorid, DROP relationship, DROP contactname, DROP contactfirstname, DROP contacttitle; -- 2.11.0