From b2c5dba091f0c3093a90ad3df16d4873c36d9033 Mon Sep 17 00:00:00 2001 From: remi Date: Mon, 11 Jan 2016 09:35:04 -0500 Subject: [PATCH] bug 12446 - Atomic update now sets canbeguarantee to 1 for categories of type C and P Same test plan applies. --- installer/data/mysql/atomicupdate/bug_12446-EnableAdultGarantee.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_12446-EnableAdultGarantee.sql b/installer/data/mysql/atomicupdate/bug_12446-EnableAdultGarantee.sql index 55c2b78..24f639d 100644 --- a/installer/data/mysql/atomicupdate/bug_12446-EnableAdultGarantee.sql +++ b/installer/data/mysql/atomicupdate/bug_12446-EnableAdultGarantee.sql @@ -7,4 +7,5 @@ VALUES ('AdditionalGuarantorField','',NULL,'Additional fields name to be transfe -- ********* -- -- STRUCTURE -- -- ********* -- -ALTER TABLE categories ADD COLUMN `canbeguarantee` tinyint(1) NOT NULL default '0'; +#ALTER TABLE categories ADD COLUMN `canbeguarantee` tinyint(1) NOT NULL default '0'; +UPDATE categories SET canbeguarantee = 1 WHERE category_type = 'P' OR category_type = 'C'; -- 1.9.1