From 914582d3e9c08b0be193372979c973a4bd49b579 Mon Sep 17 00:00:00 2001 From: sunsetsystems Date: Wed, 27 Feb 2008 07:42:06 +0000 Subject: [PATCH] default pricelevel to standard --- sql/2_8_3-to-2_8_4_upgrade.sql | 2 +- sql/database.sql | 90 +++++++++++++++++++++--------------------- 2 files changed, 46 insertions(+), 46 deletions(-) diff --git a/sql/2_8_3-to-2_8_4_upgrade.sql b/sql/2_8_3-to-2_8_4_upgrade.sql index b6c0cc2fe..c32e12a24 100644 --- a/sql/2_8_3-to-2_8_4_upgrade.sql +++ b/sql/2_8_3-to-2_8_4_upgrade.sql @@ -17,7 +17,7 @@ ALTER TABLE patient_data 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 ''; + ADD `pricelevel` varchar(255) NOT NULL DEFAULT 'standard'; CREATE TABLE list_options ( list_id varchar(31) NOT NULL, diff --git a/sql/database.sql b/sql/database.sql index 8c697e9e8..8963b0936 100644 --- a/sql/database.sql +++ b/sql/database.sql @@ -5010,59 +5010,59 @@ INSERT INTO `openemr_session_info` VALUES ('978d31441dccd350d406bfab98978f20', ' DROP TABLE IF EXISTS `patient_data`; CREATE TABLE `patient_data` ( `id` bigint(20) NOT NULL auto_increment, - `title` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `language` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `financial` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `fname` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `lname` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `mname` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `title` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `language` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `financial` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `fname` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `lname` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `mname` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `DOB` date default NULL, - `street` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `postal_code` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `city` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `state` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `country_code` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `drivers_license` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `ss` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `street` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `postal_code` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `city` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `state` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `country_code` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `drivers_license` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `ss` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `occupation` longtext character set utf8 collate utf8_unicode_ci, - `phone_home` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `phone_biz` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `phone_contact` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `phone_cell` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `phone_home` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `phone_biz` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `phone_contact` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `phone_cell` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `pharmacy_id` int(11) NOT NULL default '0', - `status` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `contact_relationship` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `status` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `contact_relationship` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `date` datetime default NULL, - `sex` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `referrer` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `referrerID` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `sex` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `referrer` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `referrerID` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `providerID` int(11) default NULL, - `email` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `ethnoracial` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `interpretter` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `migrantseasonal` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `family_size` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `monthly_income` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `homeless` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `email` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `ethnoracial` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `interpretter` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `migrantseasonal` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `family_size` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `monthly_income` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `homeless` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `financial_review` datetime default NULL, - `pubpid` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `pubpid` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `pid` bigint(20) NOT NULL default '0', - `genericname1` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `genericval1` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `genericname2` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `genericval2` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `hipaa_mail` varchar(3) character set utf8 collate utf8_unicode_ci default NULL, - `hipaa_voice` varchar(3) character set utf8 collate utf8_unicode_ci default NULL, - `hipaa_notice` varchar(3) character set utf8 collate utf8_unicode_ci default NULL, - `hipaa_message` varchar(20) character set utf8 collate utf8_unicode_ci default NULL, - `squad` varchar(32) character set utf8 collate utf8_unicode_ci default NULL, + `genericname1` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `genericval1` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `genericname2` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `genericval2` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `hipaa_mail` varchar(3) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `hipaa_voice` varchar(3) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `hipaa_notice` varchar(3) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `hipaa_message` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `squad` varchar(32) character set utf8 collate utf8_unicode_ci NOT NULL default '', `fitness` int(11) NOT NULL default '0', - `referral_source` varchar(30) character set utf8 collate utf8_unicode_ci default NULL, - `usertext1` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `usertext2` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `userlist1` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `userlist2` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, - `pricelevel` varchar(255) character set utf8 collate utf8_unicode_ci default NULL, + `referral_source` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `usertext1` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `usertext2` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `userlist1` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `userlist2` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', + `pricelevel` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default 'standard', UNIQUE KEY `pid` (`pid`), KEY `id` (`id`), KEY `pid_2` (`pid`) -- 2.11.4.GIT