From f795e261370a25872076ece3aaa9abbee38a1a8c Mon Sep 17 00:00:00 2001 From: Amiel Elboim Date: Wed, 26 Apr 2017 11:46:12 +0300 Subject: [PATCH] Alter facility id to INT(11) similar to all other tables (#684) --- sql/5_0_0-to-5_0_1_upgrade.sql | 4 ++++ sql/database.sql | 2 +- 2 files changed, 5 insertions(+), 1 deletion(-) 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 028209771..5e5456927 100644 --- a/sql/5_0_0-to-5_0_1_upgrade.sql +++ b/sql/5_0_0-to-5_0_1_upgrade.sql @@ -435,3 +435,7 @@ ALTER TABLE `background_services` CHANGE `running` `running` TINYINT(1) NOT NULL #IfNotColumnType onsite_mail owner varchar(128) ALTER TABLE `onsite_mail` CHANGE `owner` `owner` varchar(128) DEFAULT NULL; #Endif + +#IfNotColumnType openemr_postcalendar_events int(11) +ALTER TABLE `openemr_postcalendar_events` CHANGE `pc_facility` `pc_facility` int(11) NOT NULL DEFAULT '0' COMMENT 'facility id for this event'; +#Endif \ No newline at end of file diff --git a/sql/database.sql b/sql/database.sql index 17ffcb3ba..3559cc91a 100644 --- a/sql/database.sql +++ b/sql/database.sql @@ -5193,7 +5193,7 @@ CREATE TABLE `openemr_postcalendar_events` ( `pc_language` varchar(30) default NULL, `pc_apptstatus` varchar(15) NOT NULL default '-', `pc_prefcatid` int(11) NOT NULL default '0', - `pc_facility` smallint(6) NOT NULL default '0' COMMENT 'facility id for this event', + `pc_facility` int(11) NOT NULL default '0' COMMENT 'facility id for this event', `pc_sendalertsms` VARCHAR(3) NOT NULL DEFAULT 'NO', `pc_sendalertemail` VARCHAR( 3 ) NOT NULL DEFAULT 'NO', `pc_billing_location` SMALLINT (6) NOT NULL DEFAULT '0', -- 2.11.4.GIT