From 514e231a1eb3d74131d20fce2650e33459da3e17 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Tue, 3 May 2022 21:01:31 -0400 Subject: [PATCH] Fix 'Table already exists' error when running 5.50 upgrade twice --- CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl index e85f239dc9..5c7cea28d1 100644 --- a/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.50.alpha1.mysql.tpl @@ -1,6 +1,6 @@ {* file to handle db changes in 5.50.alpha1 during upgrade *} -CREATE TABLE `civicrm_user_job` ( +CREATE TABLE IF NOT EXISTS `civicrm_user_job` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Job ID', `name` varchar(64) COMMENT 'Unique name for job.', `created_id` int unsigned COMMENT 'FK to contact table.', -- 2.25.1