From ee6bf0dd0d51dbc53109fc8466a74ae0db3585cb Mon Sep 17 00:00:00 2001 From: bradymiller Date: Sun, 23 May 2010 07:43:36 +0000 Subject: [PATCH] Fix CRLF --- phpmyadmin/config.inc.php | 128 +++++++++++++++++++++--------------------- sql/example_patient_data.sql | 56 +++++++++--------- sql/example_patient_users.sql | 18 +++--- 3 files changed, 101 insertions(+), 101 deletions(-) diff --git a/phpmyadmin/config.inc.php b/phpmyadmin/config.inc.php index 856aae11c..b78e0e183 100644 --- a/phpmyadmin/config.inc.php +++ b/phpmyadmin/config.inc.php @@ -1,64 +1,64 @@ -"; - exit; -} - -/* OpenEMR Database Settings */ -require_once("../library/sqlconf.php"); - -/* Servers configuration */ -$i = 0; - -/* Server localhost (config:openemr) [1] */ -$i++; - -//For standard OpenEMR database access -$cfg['Servers'][$i]['auth_type'] = 'config'; -$cfg['Servers'][$i]['host'] = $sqlconf['host']; -$cfg['Servers'][$i]['port'] = $sqlconf['port']; -$cfg['Servers'][$i]['user'] = $sqlconf['login']; -$cfg['Servers'][$i]['password'] = $sqlconf['pass']; -$cfg['Servers'][$i]['only_db'] = $sqlconf['dbase']; - -//For control user access to use the relational -// database features provided by phpmyadmin -// in the OpenEMR database. Note that there is -// not full functionality because there is no -// designer_coords table. Also note that the -// sql bookmarks (pma_bookmarks) are currently -// utilized by OpenEMR itself to create custom -// reports at openemr/interface/reports/index.php -// -$cfg['Servers'][$i]['controluser'] = $sqlconf['login']; -$cfg['Servers'][$i]['controlpass'] = $sqlconf['pass']; -$cfg['Servers'][$i]['pmadb'] = $sqlconf['dbase']; -$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; -$cfg['Servers'][$i]['relation'] = 'pma_relation'; -$cfg['Servers'][$i]['table_info'] = 'pma_table_info'; -$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; -$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; -$cfg['Servers'][$i]['column_info'] = 'pma_column_info'; -$cfg['Servers'][$i]['history'] = 'pma_history'; -$cfg['Servers'][$i]['designer_coords'] = ''; -$cfg['Servers'][$i]['verbose_check'] = TRUE; - -/* End of servers configuration */ - - -/* Other mods - BM 05-2009 */ -$cfg['ShowCreateDb'] = false; -?> +"; + exit; +} + +/* OpenEMR Database Settings */ +require_once("../library/sqlconf.php"); + +/* Servers configuration */ +$i = 0; + +/* Server localhost (config:openemr) [1] */ +$i++; + +//For standard OpenEMR database access +$cfg['Servers'][$i]['auth_type'] = 'config'; +$cfg['Servers'][$i]['host'] = $sqlconf['host']; +$cfg['Servers'][$i]['port'] = $sqlconf['port']; +$cfg['Servers'][$i]['user'] = $sqlconf['login']; +$cfg['Servers'][$i]['password'] = $sqlconf['pass']; +$cfg['Servers'][$i]['only_db'] = $sqlconf['dbase']; + +//For control user access to use the relational +// database features provided by phpmyadmin +// in the OpenEMR database. Note that there is +// not full functionality because there is no +// designer_coords table. Also note that the +// sql bookmarks (pma_bookmarks) are currently +// utilized by OpenEMR itself to create custom +// reports at openemr/interface/reports/index.php +// +$cfg['Servers'][$i]['controluser'] = $sqlconf['login']; +$cfg['Servers'][$i]['controlpass'] = $sqlconf['pass']; +$cfg['Servers'][$i]['pmadb'] = $sqlconf['dbase']; +$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; +$cfg['Servers'][$i]['relation'] = 'pma_relation'; +$cfg['Servers'][$i]['table_info'] = 'pma_table_info'; +$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; +$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; +$cfg['Servers'][$i]['column_info'] = 'pma_column_info'; +$cfg['Servers'][$i]['history'] = 'pma_history'; +$cfg['Servers'][$i]['designer_coords'] = ''; +$cfg['Servers'][$i]['verbose_check'] = TRUE; + +/* End of servers configuration */ + + +/* Other mods - BM 05-2009 */ +$cfg['ShowCreateDb'] = false; +?> diff --git a/sql/example_patient_data.sql b/sql/example_patient_data.sql index 902f99e48..afa6ed790 100644 --- a/sql/example_patient_data.sql +++ b/sql/example_patient_data.sql @@ -1,28 +1,28 @@ -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Ms.', 'english', '', 'Farrah', 'Rolle', 'A.', '1973-10-11', '111 Main Street', '92101', 'San Luis', 'CA', '', '456789123', '', '(619) 555-2222', '(619) 555-3333', '(619) 555-1111', '', 'married', 'Joe', '2003-11-17 12:06:00', 'Female', 'Phil Martin', '', NULL, 'frolle@pennfirm.com', 'Latina', '', '', '3', '3200', '', '0000-00-00 00:00:00', '10', 5,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`)VALUES ( 'Mr.', 'english', '', 'Ted', 'Shaw', '', '1947-03-11', '222 1st Avenue', '92101', 'San Diego', 'CA', '', '920-24-2256', 'Landscape Architect', '(619) 555-7568', '(619) 555-9867', '(619) 555-7567', '', 'married', 'Marion Shaw', '2003-11-17 13:47:42', 'Male', 'Phil Martin', '', NULL, 'info@pennfirm.com', '', '', '', '', '', '', '0000-00-00 00:00:00', '24555', 1,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mrs.', 'english', '', 'Eduardo', 'Perez', '', '1957-01-09', '789 Third Avenue', '', 'San Diego', 'CA', '', '234567891', 'Manager of Transportation', '(619) 555-4859', '(619) 555-7821', '(619) 555-7823 x251', '', '', '', '2004-01-20 15:43:30', 'Male', 'Ynez Jones', '', 4, 'info@pennfirm.com', '', '', '', '', '', '', '0000-00-00 00:00:00', '789456', 4,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mrs.', 'spanish', '', 'Nora', 'Cohen', '', '1967-06-04', '155 First Avenue', '92101', 'San Luis', 'CA', '', '891-23-4567', '', '(213) 555-5555', '(213) 555-4444', '(818) 555-5555', '', 'married', '', '2004-01-16 10:28:22', 'Female', 'Phil Martin', '', 5, '', 'Latina', '', '', '3', '1500', '', '0000-00-00 00:00:00', '8', 8,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Brent', 'Perez', '', '1960-01-01', '1234 1st Avenue', '92101', 'San Diego', 'CA', '', '123456789', 'Airline Mechanic', '(619) 696-5050', '(888) 480-5050', '(619) 696-5050', '', 'married', 'Maria Perez', '2004-01-14 17:30:09', 'Male', 'Phil Martin', '', 5, 'bperez@pennfirm.com', 'Latino', '', '', '3', '2200', '', '2004-04-02 00:00:00', '1001', 41,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', '', '', 'Jim', 'Moses', '', '1945-02-14', '', '', 'Los Angeles', 'CA', '', '545676767', '', '(323) 555-4444', '(909) 555-6767', '(310) 555-1212', '', '', '', '2004-01-15 13:45:08', 'Male', 'Administrator Administrator', '', 1, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '17', 17,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', '', '', 'Richard', 'Jones', '', '1940-12-16', '400 West Broadway', '92101', 'San Diego', 'CA', '', '555-11-1111', '', '(619) 555-5555', '(619) 333-3333', '(619) 444-4444', '', 'married', '', '2004-01-16 10:02:41', '', 'Ynez Jones', '', 4, 'richard@pennfirm.com', '', '', '', '', '', '', '0000-00-00 00:00:00', '18', 18,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Ilias', 'Jenane', '', '1933-03-22', '145 N. East Street', '92111', 'La Mesa', 'CA', '', '111-11-2222', 'retired - school teacher', '(619) 555-2222', '(619) 555-3333', '(619) 555-1111', '', 'single', '', '2004-01-16 10:23:47', 'Female', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '22', 22,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Jason', 'Binder', '', '1961-12-11', '100 West Sepulveda', '92020', 'Los Angeles', 'CA', '', '222-11-8888', 'Real Estate Agent', '', '', '', '', 'single', '', '2004-01-16 10:13:50', 'Male', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '30', 30,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'John', 'Dockerty', 'D', '1977-05-02', '800 West Way', '92101', 'San Diego', 'CA', '', '111-11-1111', 'Physical therapist', '(567) 789-7891', '(567) 789-1234', '(567) 567-5678', '', 'single', '', '2004-01-16 10:21:05', '', 'Phil Martin', '', 5, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '25', 25,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'James', 'Janssen', '', '1966-04-28', '111 North Street', '90205', 'Irvine', 'CA', '', '555-11-1111', 'Office Manager', '(818) 555-2222', '(818) 555-2323', '(5555) 555-1111', '', 'single', '', '2004-01-19 14:21:25', 'Male', '', '', 1, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '26', 26,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Wallace', 'Buckley', '', '1952-04-03', '123 West Street', '90400', 'Barstow', 'California', '', '999-99-1111', 'Accountant', '(555) 111-1111', '(555) 111-1234', '(555) 555-5555', '', 'domestic partner', 'Mike Hart', '2004-01-16 10:18:28', '', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '40', 40,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Robert', 'Dickey', '', '1955-04-12', '111 North Kearny', '91040', 'Torrance', 'CA', '', '214-22-1111', 'Project Manager', '(808) 555-1234', '(808) 555-4444', '(808) 555-1111', '', 'married', '', '2004-01-16 10:31:45', '', 'Phil Martin', '', 5, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '34', 34,'','','',''); -INSERT INTO `patient_data` -(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Jillian', 'Mahoney', '', '1968-08-11', '444 North State Street', '90204', 'Santa Ana', 'CA', '', '222-11-1111', '', '(808) 555-4444', '(808) 555-3333', '(808) 555-5555', '', 'married', '', '2004-01-19 12:14:06', 'Female', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '35', 35,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Ms.', 'english', '', 'Farrah', 'Rolle', 'A.', '1973-10-11', '111 Main Street', '92101', 'San Luis', 'CA', '', '456789123', '', '(619) 555-2222', '(619) 555-3333', '(619) 555-1111', '', 'married', 'Joe', '2003-11-17 12:06:00', 'Female', 'Phil Martin', '', NULL, 'frolle@pennfirm.com', 'Latina', '', '', '3', '3200', '', '0000-00-00 00:00:00', '10', 5,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`)VALUES ( 'Mr.', 'english', '', 'Ted', 'Shaw', '', '1947-03-11', '222 1st Avenue', '92101', 'San Diego', 'CA', '', '920-24-2256', 'Landscape Architect', '(619) 555-7568', '(619) 555-9867', '(619) 555-7567', '', 'married', 'Marion Shaw', '2003-11-17 13:47:42', 'Male', 'Phil Martin', '', NULL, 'info@pennfirm.com', '', '', '', '', '', '', '0000-00-00 00:00:00', '24555', 1,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mrs.', 'english', '', 'Eduardo', 'Perez', '', '1957-01-09', '789 Third Avenue', '', 'San Diego', 'CA', '', '234567891', 'Manager of Transportation', '(619) 555-4859', '(619) 555-7821', '(619) 555-7823 x251', '', '', '', '2004-01-20 15:43:30', 'Male', 'Ynez Jones', '', 4, 'info@pennfirm.com', '', '', '', '', '', '', '0000-00-00 00:00:00', '789456', 4,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mrs.', 'spanish', '', 'Nora', 'Cohen', '', '1967-06-04', '155 First Avenue', '92101', 'San Luis', 'CA', '', '891-23-4567', '', '(213) 555-5555', '(213) 555-4444', '(818) 555-5555', '', 'married', '', '2004-01-16 10:28:22', 'Female', 'Phil Martin', '', 5, '', 'Latina', '', '', '3', '1500', '', '0000-00-00 00:00:00', '8', 8,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Brent', 'Perez', '', '1960-01-01', '1234 1st Avenue', '92101', 'San Diego', 'CA', '', '123456789', 'Airline Mechanic', '(619) 696-5050', '(888) 480-5050', '(619) 696-5050', '', 'married', 'Maria Perez', '2004-01-14 17:30:09', 'Male', 'Phil Martin', '', 5, 'bperez@pennfirm.com', 'Latino', '', '', '3', '2200', '', '2004-04-02 00:00:00', '1001', 41,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', '', '', 'Jim', 'Moses', '', '1945-02-14', '', '', 'Los Angeles', 'CA', '', '545676767', '', '(323) 555-4444', '(909) 555-6767', '(310) 555-1212', '', '', '', '2004-01-15 13:45:08', 'Male', 'Administrator Administrator', '', 1, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '17', 17,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', '', '', 'Richard', 'Jones', '', '1940-12-16', '400 West Broadway', '92101', 'San Diego', 'CA', '', '555-11-1111', '', '(619) 555-5555', '(619) 333-3333', '(619) 444-4444', '', 'married', '', '2004-01-16 10:02:41', '', 'Ynez Jones', '', 4, 'richard@pennfirm.com', '', '', '', '', '', '', '0000-00-00 00:00:00', '18', 18,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Ilias', 'Jenane', '', '1933-03-22', '145 N. East Street', '92111', 'La Mesa', 'CA', '', '111-11-2222', 'retired - school teacher', '(619) 555-2222', '(619) 555-3333', '(619) 555-1111', '', 'single', '', '2004-01-16 10:23:47', 'Female', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '22', 22,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Jason', 'Binder', '', '1961-12-11', '100 West Sepulveda', '92020', 'Los Angeles', 'CA', '', '222-11-8888', 'Real Estate Agent', '', '', '', '', 'single', '', '2004-01-16 10:13:50', 'Male', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '30', 30,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'John', 'Dockerty', 'D', '1977-05-02', '800 West Way', '92101', 'San Diego', 'CA', '', '111-11-1111', 'Physical therapist', '(567) 789-7891', '(567) 789-1234', '(567) 567-5678', '', 'single', '', '2004-01-16 10:21:05', '', 'Phil Martin', '', 5, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '25', 25,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'James', 'Janssen', '', '1966-04-28', '111 North Street', '90205', 'Irvine', 'CA', '', '555-11-1111', 'Office Manager', '(818) 555-2222', '(818) 555-2323', '(5555) 555-1111', '', 'single', '', '2004-01-19 14:21:25', 'Male', '', '', 1, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '26', 26,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Wallace', 'Buckley', '', '1952-04-03', '123 West Street', '90400', 'Barstow', 'California', '', '999-99-1111', 'Accountant', '(555) 111-1111', '(555) 111-1234', '(555) 555-5555', '', 'domestic partner', 'Mike Hart', '2004-01-16 10:18:28', '', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '40', 40,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Robert', 'Dickey', '', '1955-04-12', '111 North Kearny', '91040', 'Torrance', 'CA', '', '214-22-1111', 'Project Manager', '(808) 555-1234', '(808) 555-4444', '(808) 555-1111', '', 'married', '', '2004-01-16 10:31:45', '', 'Phil Martin', '', 5, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '34', 34,'','','',''); +INSERT INTO `patient_data` +(`title`, `language`, `financial`, `fname`, `lname`, `mname`, `DOB`, `street`, `postal_code`, `city`, `state`, `drivers_license`, `ss`, `occupation`, `phone_home`, `phone_biz`, `phone_contact`, `phone_cell`, `status`, `contact_relationship`, `date`, `sex`, `referrer`, `referrerID`, `providerID`, `email`, `ethnoracial`, `interpretter`, `migrantseasonal`, `family_size`, `monthly_income`, `homeless`, `financial_review`, `pubpid`, `pid`, `genericname1`, `genericval1`, `genericname2`, `genericval2`) VALUES ( 'Mr.', 'english', '', 'Jillian', 'Mahoney', '', '1968-08-11', '444 North State Street', '90204', 'Santa Ana', 'CA', '', '222-11-1111', '', '(808) 555-4444', '(808) 555-3333', '(808) 555-5555', '', 'married', '', '2004-01-19 12:14:06', 'Female', 'Ynez Jones', '', 4, '', '', '', '', '', '', '', '0000-00-00 00:00:00', '35', 35,'','','',''); diff --git a/sql/example_patient_users.sql b/sql/example_patient_users.sql index 55583bf33..b4aac53b7 100644 --- a/sql/example_patient_users.sql +++ b/sql/example_patient_users.sql @@ -1,9 +1,9 @@ -# fmg: the example patients' data (example_patient_data.sql) references providers -# not created by defaults.sql so that some functions cause odd matches in the -# program. For example, adding a visit for such a patient shows that visit as -# applicable to several providers (with id's such as "a a", "1 1", etc.). -# -# This inserts (iff don't already exist) the referenced users - -INSERT INTO `users` ( `username`, `password`, `authorized`, `info`, `source`, `fname`, `mname`, `lname`, `federaltaxid`, `federaldrugid`, `upin`) VALUES ( 'davis', '1a1dc91c907325c69271ddf0c944bc72', 1, NULL, NULL, 'Admin', NULL, 'davis', '', NULL, ''); -INSERT INTO `users` ( `username`, `password`, `authorized`, `info`, `source`, `fname`, `mname`, `lname`, `federaltaxid`, `federaldrugid`, `upin`) VALUES ( 'hamming', '1a1dc91c907325c69271ddf0c944bc72', 1, NULL, NULL, 'Admin', NULL, 'hamming', '', NULL, ''); +# fmg: the example patients' data (example_patient_data.sql) references providers +# not created by defaults.sql so that some functions cause odd matches in the +# program. For example, adding a visit for such a patient shows that visit as +# applicable to several providers (with id's such as "a a", "1 1", etc.). +# +# This inserts (iff don't already exist) the referenced users + +INSERT INTO `users` ( `username`, `password`, `authorized`, `info`, `source`, `fname`, `mname`, `lname`, `federaltaxid`, `federaldrugid`, `upin`) VALUES ( 'davis', '1a1dc91c907325c69271ddf0c944bc72', 1, NULL, NULL, 'Admin', NULL, 'davis', '', NULL, ''); +INSERT INTO `users` ( `username`, `password`, `authorized`, `info`, `source`, `fname`, `mname`, `lname`, `federaltaxid`, `federaldrugid`, `upin`) VALUES ( 'hamming', '1a1dc91c907325c69271ddf0c944bc72', 1, NULL, NULL, 'Admin', NULL, 'hamming', '', NULL, ''); -- 2.11.4.GIT