jeff_ross wrote on Monday, May 12, 2008:
Here’s a diff -u patch to add two new fields to patient_data:
— 2_8_3-to-2_8_4_upgrade.sql Wed May 7 10:22:05 2008
+++ 2_8_3-to-2_8_4_upgrade.sql.mine Mon May 12 10:01:27 2008
@@ -17,7 +17,9 @@
ADD `usertext2` varchar(255) NOT NULL DEFAULT ‘’,
ADD `userlist1` varchar(255) NOT NULL DEFAULT ‘’,
ADD `userlist2` varchar(255) NOT NULL DEFAULT ‘’,
- ADD `pricelevel` varchar(255) NOT NULL DEFAULT ‘standard’;
+ ADD `pricelevel` varchar(255) NOT NULL DEFAULT ‘standard’,
+ ADD `hipaa_allowsms` varchar(3) NOT NULL DEFAULT ‘NO’,
+ ADD `hipaa_allowemail` varchar(3) NOT NULL DEFAULT ‘NO’;
CREATE TABLE list_options (
list_id varchar(31) NOT NULL,