From 5c927d8a66212270242227a46d2e39fbeecc2505 Mon Sep 17 00:00:00 2001 From: Brady Miller Date: Sun, 2 Jul 2017 09:02:03 -0700 Subject: [PATCH] upgrade script bug fix --- sql/5_0_0-to-5_0_1_upgrade.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/5_0_0-to-5_0_1_upgrade.sql b/sql/5_0_0-to-5_0_1_upgrade.sql index af6168d1f..4f42d397e 100644 --- a/sql/5_0_0-to-5_0_1_upgrade.sql +++ b/sql/5_0_0-to-5_0_1_upgrade.sql @@ -442,8 +442,8 @@ ALTER TABLE `openemr_postcalendar_events` CHANGE `pc_facility` `pc_facility` int #IfMissingColumn form_misc_billing_options onset_date ALTER TABLE `form_misc_billing_options` ADD `onset_date` date default NULL; -UPDATE `list_options` SET `option_id` = 'DK', `title` = 'Ordering Provider' WHERE `list_id` = 'provider_qualifier_code' AND `option_id` = 'dk' -UPDATE `list_options` SET `option_id` = 'DN', `title` = 'Referring Provider', `is_default` = '1' WHERE `list_id` = 'provider_qualifier_code' AND `option_id` = 'dn' +UPDATE `list_options` SET `option_id` = 'DK', `title` = 'Ordering Provider' WHERE `list_id` = 'provider_qualifier_code' AND `option_id` = 'dk'; +UPDATE `list_options` SET `option_id` = 'DN', `title` = 'Referring Provider', `is_default` = '1' WHERE `list_id` = 'provider_qualifier_code' AND `option_id` = 'dn'; #EndIF #IfNotRow2D list_options list_id provider_qualifier_code option_id DQ -- 2.11.4.GIT