From 3fd0f5a386c6aa3b8cb87090741dc79b0676bbf5 Mon Sep 17 00:00:00 2001 From: James R Stone aka fndtn357 Date: Fri, 25 May 2012 16:29:26 -0400 Subject: [PATCH] MySQL5.5 code fix for .sql files; changed TYPE= to ENGINE= --- contrib/forms/approved_physical/table.sql | 2 +- contrib/forms/assessment_intake/table.sql | 2 +- .../Initial_New_Patient_Physical_Exam/table.sql | 2 +- contrib/forms/body_composition/table.sql | 2 +- contrib/forms/cardiology_set/Forms2_Cardiology/table.sql | 2 +- contrib/forms/cardiology_set/Forms3_Cardiology/table.sql | 2 +- contrib/forms/cardiology_set/Forms_Cardiology/table.sql | 2 +- contrib/forms/chiro_history/table.sql | 2 +- .../forms/chiropractor_set/Chiro_personal_injury_form/table.sql | 2 +- .../chiropractor_set/Chirpractic_physical_therapy_form/table.sql | 2 +- contrib/forms/clinical_notes/table.sql | 2 +- contrib/forms/complaint_history/table.sql | 2 +- contrib/forms/contacts/table.sql | 2 +- contrib/forms/cricket_injury_audit/table.sql | 2 +- contrib/forms/documents/table.sql | 2 +- contrib/forms/evaluation/table.sql | 4 ++-- contrib/forms/example2/table.sql | 2 +- contrib/forms/football_injury_audit/table.sql | 2 +- contrib/forms/formmaker/formscript.pl | 2 +- contrib/forms/habits/table.sql | 2 +- contrib/forms/hand/table.sql | 2 +- contrib/forms/hearingtest/table.sql | 2 +- contrib/forms/hist_exam_plan/table.sql | 2 +- contrib/forms/hp_tje_primary/table.sql | 8 ++++---- contrib/forms/hpi/table.sql | 2 +- contrib/forms/immunization_record/table.sql | 2 +- contrib/forms/individual_treatment_plan/table.sql | 2 +- contrib/forms/lab_results/table.sql | 2 +- contrib/forms/leg_length/table.sql | 2 +- contrib/forms/md_assessment/table.sql | 2 +- contrib/forms/medical_decision/table.sql | 2 +- contrib/forms/medical_orders/table.sql | 2 +- contrib/forms/mh_therapy_progress/table.sql | 2 +- contrib/forms/neurologicalreview/table.sql | 2 +- contrib/forms/nursing_notes/table.sql | 2 +- contrib/forms/obstetrical/table.sql | 2 +- contrib/forms/pain/table.sql | 2 +- contrib/forms/patient_instruction/table.sql | 2 +- contrib/forms/patient_intake_history/table.sql | 4 ++-- contrib/forms/ped_GI/table.sql | 2 +- contrib/forms/ped_fever/table.sql | 2 +- contrib/forms/ped_pain/table.sql | 2 +- contrib/forms/pfsh/table.sql | 2 +- contrib/forms/phone_exam/table.sql | 2 +- contrib/forms/physical_examination/table.sql | 2 +- contrib/forms/physician_history/table.sql | 2 +- contrib/forms/plist/table.sql | 2 +- contrib/forms/podiatry/table.sql | 2 +- contrib/forms/prior_auth/table.sql | 2 +- contrib/forms/progressnotes/table.sql | 2 +- contrib/forms/prosthesis/table.sql | 2 +- contrib/forms/review_of_systems/table.sql | 4 ++-- contrib/forms/reviewofs/table.sql | 2 +- contrib/forms/rom/table.sql | 2 +- contrib/forms/ros2/table.sql | 2 +- contrib/forms/rosform/table.sql | 2 +- contrib/forms/routine_screening_record/table.sql | 2 +- contrib/forms/scanned_notes/table.sql | 2 +- contrib/forms/snellen/table.sql | 2 +- contrib/forms/soap2/table.sql | 2 +- contrib/forms/soccer_injury/table.sql | 2 +- contrib/forms/specialist_notes/table.sql | 2 +- contrib/forms/sports_fitness/table.sql | 2 +- contrib/forms/strength_conditioning/table.sql | 2 +- contrib/forms/treatment_protocols/table.sql | 2 +- contrib/forms/vision/table.sql | 2 +- contrib/forms/vitals/table.sql | 2 +- contrib/forms/vitalsigns/table.sql | 2 +- contrib/forms/well_child/table.sql | 4 ++-- contrib/forms/well_child_care/table.sql | 2 +- contrib/forms/well_infant/table.sql | 4 ++-- interface/forms/CAMOS/table.sql | 8 ++++---- interface/forms/CAMOS/table_no_data.sql | 8 ++++---- interface/forms/dictation/table.sql | 2 +- interface/forms/misc_billing_options/table.sql | 2 +- interface/forms/physical_exam/table.sql | 4 ++-- interface/forms/reviewofs/table.sql | 2 +- interface/forms/soap/table.sql | 2 +- interface/forms/vitals/table.sql | 2 +- interface/forms/vitalsM/table.sql | 2 +- 80 files changed, 95 insertions(+), 95 deletions(-) mode change 100644 => 100755 contrib/forms/formmaker/formscript.pl diff --git a/contrib/forms/approved_physical/table.sql b/contrib/forms/approved_physical/table.sql index b9ac8054f..b0ddb80cf 100644 --- a/contrib/forms/approved_physical/table.sql +++ b/contrib/forms/approved_physical/table.sql @@ -131,4 +131,4 @@ CREATE TABLE IF NOT EXISTS `form_approved_physical` ( `col_62` varchar(3) NOT NULL default '--', `col_62_textbox` varchar(255) NOT NULL default '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/assessment_intake/table.sql b/contrib/forms/assessment_intake/table.sql index 794d74334..3da96ce5e 100644 --- a/contrib/forms/assessment_intake/table.sql +++ b/contrib/forms/assessment_intake/table.sql @@ -134,4 +134,4 @@ referrals_cu longtext, referrals_docs longtext, referrals_or longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/bariatric_surgery_set/Initial_New_Patient_Physical_Exam/table.sql b/contrib/forms/bariatric_surgery_set/Initial_New_Patient_Physical_Exam/table.sql index 3d3ab2559..907a39cce 100644 --- a/contrib/forms/bariatric_surgery_set/Initial_New_Patient_Physical_Exam/table.sql +++ b/contrib/forms/bariatric_surgery_set/Initial_New_Patient_Physical_Exam/table.sql @@ -44,4 +44,4 @@ recommendations TEXT, note3 TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/body_composition/table.sql b/contrib/forms/body_composition/table.sql index 124d39ddc..47b8cb7fa 100644 --- a/contrib/forms/body_composition/table.sql +++ b/contrib/forms/body_composition/table.sql @@ -22,4 +22,4 @@ CREATE TABLE IF NOT EXISTS form_body_composition ( other text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/cardiology_set/Forms2_Cardiology/table.sql b/contrib/forms/cardiology_set/Forms2_Cardiology/table.sql index 0706342e4..c7cff651a 100644 --- a/contrib/forms/cardiology_set/Forms2_Cardiology/table.sql +++ b/contrib/forms/cardiology_set/Forms2_Cardiology/table.sql @@ -81,4 +81,4 @@ _abdomen TEXT, _gi_gu TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/cardiology_set/Forms3_Cardiology/table.sql b/contrib/forms/cardiology_set/Forms3_Cardiology/table.sql index b9d5b35ba..2d33c7230 100644 --- a/contrib/forms/cardiology_set/Forms3_Cardiology/table.sql +++ b/contrib/forms/cardiology_set/Forms3_Cardiology/table.sql @@ -54,4 +54,4 @@ _sh_no_change_since TEXT, examination TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/cardiology_set/Forms_Cardiology/table.sql b/contrib/forms/cardiology_set/Forms_Cardiology/table.sql index f9520b557..51836be63 100644 --- a/contrib/forms/cardiology_set/Forms_Cardiology/table.sql +++ b/contrib/forms/cardiology_set/Forms_Cardiology/table.sql @@ -132,4 +132,4 @@ hospital TEXT, reason TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/chiro_history/table.sql b/contrib/forms/chiro_history/table.sql index 57ecf4359..d1dc9c61c 100644 --- a/contrib/forms/chiro_history/table.sql +++ b/contrib/forms/chiro_history/table.sql @@ -44,4 +44,4 @@ family_history TEXT, regular_meals TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/chiropractor_set/Chiro_personal_injury_form/table.sql b/contrib/forms/chiropractor_set/Chiro_personal_injury_form/table.sql index 572d73f7b..3c27aacc6 100644 --- a/contrib/forms/chiropractor_set/Chiro_personal_injury_form/table.sql +++ b/contrib/forms/chiropractor_set/Chiro_personal_injury_form/table.sql @@ -36,4 +36,4 @@ _subscriber_id_number TEXT, _group_number TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/chiropractor_set/Chirpractic_physical_therapy_form/table.sql b/contrib/forms/chiropractor_set/Chirpractic_physical_therapy_form/table.sql index 6e56e84e9..4d31343c2 100644 --- a/contrib/forms/chiropractor_set/Chirpractic_physical_therapy_form/table.sql +++ b/contrib/forms/chiropractor_set/Chirpractic_physical_therapy_form/table.sql @@ -98,4 +98,4 @@ _if_taken_to_the_hospital_did_you TEXT, _have_you_ever_been_involved_in_an_accident_before TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/clinical_notes/table.sql b/contrib/forms/clinical_notes/table.sql index 175849fb6..c2ea631a9 100644 --- a/contrib/forms/clinical_notes/table.sql +++ b/contrib/forms/clinical_notes/table.sql @@ -16,4 +16,4 @@ CREATE TABLE IF NOT EXISTS form_clinical_notes ( -- destination int(11) NOT NULL DEFAULT 0, -- radio PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/complaint_history/table.sql b/contrib/forms/complaint_history/table.sql index cd2a6ab34..1c1fc6a67 100644 --- a/contrib/forms/complaint_history/table.sql +++ b/contrib/forms/complaint_history/table.sql @@ -8,4 +8,4 @@ CREATE TABLE IF NOT EXISTS `form_complaint_history` ( `activity` tinyint(4) NOT NULL DEFAULT 0, `complaint_history` text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/contacts/table.sql b/contrib/forms/contacts/table.sql index 1a6791f47..17f0655f8 100644 --- a/contrib/forms/contacts/table.sql +++ b/contrib/forms/contacts/table.sql @@ -24,4 +24,4 @@ va_far longtext, va_near longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/cricket_injury_audit/table.sql b/contrib/forms/cricket_injury_audit/table.sql index 15eae2c32..01fdf15b2 100644 --- a/contrib/forms/cricket_injury_audit/table.sql +++ b/contrib/forms/cricket_injury_audit/table.sql @@ -12,4 +12,4 @@ CREATE TABLE IF NOT EXISTS form_cricket_injury_audit ( cibowlside int(11) NOT NULL DEFAULT 0, cibowltype int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/documents/table.sql b/contrib/forms/documents/table.sql index a53742434..92204a3ba 100644 --- a/contrib/forms/documents/table.sql +++ b/contrib/forms/documents/table.sql @@ -11,4 +11,4 @@ CREATE TABLE IF NOT EXISTS `form_documents` ( `document_description` tinytext, `document_source` varchar (255), PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/evaluation/table.sql b/contrib/forms/evaluation/table.sql index 735430b2c..bbafa3f54 100644 --- a/contrib/forms/evaluation/table.sql +++ b/contrib/forms/evaluation/table.sql @@ -19,11 +19,11 @@ CREATE TABLE `form_evaluation` ( `activity` tinyint(4) default NULL, `date` datetime default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE `form_evaluation_checks` ( `id` int(11) NOT NULL auto_increment, `foreign_id` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/example2/table.sql b/contrib/forms/example2/table.sql index 6dde7839d..05cd17c1e 100644 --- a/contrib/forms/example2/table.sql +++ b/contrib/forms/example2/table.sql @@ -26,4 +26,4 @@ CREATE TABLE IF NOT EXISTS `form_example` ( /* end of custom form fields */ PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/football_injury_audit/table.sql b/contrib/forms/football_injury_audit/table.sql index 954ca62fc..176708291 100644 --- a/contrib/forms/football_injury_audit/table.sql +++ b/contrib/forms/football_injury_audit/table.sql @@ -35,4 +35,4 @@ CREATE TABLE IF NOT EXISTS form_football_injury_audit ( fiside int(11) NOT NULL DEFAULT 0, firemoved int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/formmaker/formscript.pl b/contrib/forms/formmaker/formscript.pl old mode 100644 new mode 100755 index 677b4dd1c..137f393e2 --- a/contrib/forms/formmaker/formscript.pl +++ b/contrib/forms/formmaker/formscript.pl @@ -294,7 +294,7 @@ authorized tinyint(4) default NULL, activity tinyint(4) default NULL, DATABASEFIELDS PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; START #view.php diff --git a/contrib/forms/habits/table.sql b/contrib/forms/habits/table.sql index 3922be3da..cde880814 100644 --- a/contrib/forms/habits/table.sql +++ b/contrib/forms/habits/table.sql @@ -36,4 +36,4 @@ seat_belt ENUM ('Always','Usually','Seldom','Never') default NULL, ever_been_molested ENUM ('YES','NO') default NULL, ever_molested_other ENUM ('YES','NO') default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/hand/table.sql b/contrib/forms/hand/table.sql index cdbd0e980..c223624e7 100644 --- a/contrib/forms/hand/table.sql +++ b/contrib/forms/hand/table.sql @@ -15,4 +15,4 @@ CREATE TABLE IF NOT EXISTS `form_hand` ( `handedness` text NOT NULL DEFAULT '', `notes` text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/hearingtest/table.sql b/contrib/forms/hearingtest/table.sql index 6eaca1ad0..5816c9935 100644 --- a/contrib/forms/hearingtest/table.sql +++ b/contrib/forms/hearingtest/table.sql @@ -25,4 +25,4 @@ left_ear_6000 longtext, with_hearing_aid varchar(255), additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/hist_exam_plan/table.sql b/contrib/forms/hist_exam_plan/table.sql index 99a15c8f2..45fe567c9 100644 --- a/contrib/forms/hist_exam_plan/table.sql +++ b/contrib/forms/hist_exam_plan/table.sql @@ -5,4 +5,4 @@ CREATE TABLE IF NOT EXISTS form_hist_exam_plan ( examination text NOT NULL DEFAULT '', plan text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/hp_tje_primary/table.sql b/contrib/forms/hp_tje_primary/table.sql index ee1c6329b..3e86cfee7 100644 --- a/contrib/forms/hp_tje_primary/table.sql +++ b/contrib/forms/hp_tje_primary/table.sql @@ -3,7 +3,7 @@ CREATE TABLE `form_hp_tje_checks` ( `foreign_id` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; +) ENGINE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE `form_hp_tje_history` ( `id` int(11) NOT NULL auto_increment, @@ -14,7 +14,7 @@ CREATE TABLE `form_hp_tje_history` ( `effectiveness` varchar(255) default NULL, `date` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; +) ENGINE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE `form_hp_tje_previous_accidents` ( `id` int(11) NOT NULL auto_increment, @@ -23,7 +23,7 @@ CREATE TABLE `form_hp_tje_previous_accidents` ( `injuries` varchar(255) default NULL, `date` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; +) ENGINE=MyISAM AUTO_INCREMENT=1 ; CREATE TABLE `form_hp_tje_primary` ( `id` int(11) NOT NULL auto_increment, @@ -44,4 +44,4 @@ CREATE TABLE `form_hp_tje_primary` ( `pid` int(11) default NULL, `activity` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; \ No newline at end of file +) ENGINE=MyISAM AUTO_INCREMENT=1 ; diff --git a/contrib/forms/hpi/table.sql b/contrib/forms/hpi/table.sql index 0d2ba2162..6b49b2268 100644 --- a/contrib/forms/hpi/table.sql +++ b/contrib/forms/hpi/table.sql @@ -16,4 +16,4 @@ CREATE TABLE IF NOT EXISTS `form_hpi` ( `factors` varchar(255) NOT NULL DEFAULT '', `signs` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; \ No newline at end of file +) ENGINE=InnoDB; diff --git a/contrib/forms/immunization_record/table.sql b/contrib/forms/immunization_record/table.sql index faf88e452..73f00c014 100644 --- a/contrib/forms/immunization_record/table.sql +++ b/contrib/forms/immunization_record/table.sql @@ -22,4 +22,4 @@ last_vacc_hep_b longtext, last_vacc_varicella longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/individual_treatment_plan/table.sql b/contrib/forms/individual_treatment_plan/table.sql index 9fcf54021..25d75a5bd 100644 --- a/contrib/forms/individual_treatment_plan/table.sql +++ b/contrib/forms/individual_treatment_plan/table.sql @@ -37,4 +37,4 @@ medications_2 varchar(40) default NULL, referrals_1 varchar(40) default NULL, referrals_2 varchar(40) default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/lab_results/table.sql b/contrib/forms/lab_results/table.sql index 2653a4f62..d1c7efa6d 100644 --- a/contrib/forms/lab_results/table.sql +++ b/contrib/forms/lab_results/table.sql @@ -8,4 +8,4 @@ CREATE TABLE IF NOT EXISTS `form_lab_results` ( `activity` tinyint(4) default NULL, `notes` text default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/leg_length/table.sql b/contrib/forms/leg_length/table.sql index 8dcce4dea..c10e9a5d7 100644 --- a/contrib/forms/leg_length/table.sql +++ b/contrib/forms/leg_length/table.sql @@ -22,4 +22,4 @@ CREATE TABLE IF NOT EXISTS `form_leg_length` ( `UMB_right` text DEFAULT NULL, `notes` text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/md_assessment/table.sql b/contrib/forms/md_assessment/table.sql index 8b65434db..dca6f2911 100644 --- a/contrib/forms/md_assessment/table.sql +++ b/contrib/forms/md_assessment/table.sql @@ -9,4 +9,4 @@ CREATE TABLE IF NOT EXISTS `form_md_assessment` ( `assessment` varchar(255) NOT NULL DEFAULT '', `plan` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; \ No newline at end of file +) ENGINE=InnoDB; diff --git a/contrib/forms/medical_decision/table.sql b/contrib/forms/medical_decision/table.sql index d90672fd1..ae31ccb67 100644 --- a/contrib/forms/medical_decision/table.sql +++ b/contrib/forms/medical_decision/table.sql @@ -47,4 +47,4 @@ minutes_counseled varchar(255), total_encounter_time varchar(255), PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/medical_orders/table.sql b/contrib/forms/medical_orders/table.sql index 312ac6701..575b8675a 100644 --- a/contrib/forms/medical_orders/table.sql +++ b/contrib/forms/medical_orders/table.sql @@ -8,4 +8,4 @@ CREATE TABLE IF NOT EXISTS `form_medical_orders` ( `activity` tinyint(4) NOT NULL DEFAULT 0, `orders` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; \ No newline at end of file +) ENGINE=InnoDB; diff --git a/contrib/forms/mh_therapy_progress/table.sql b/contrib/forms/mh_therapy_progress/table.sql index fae064450..56c257816 100644 --- a/contrib/forms/mh_therapy_progress/table.sql +++ b/contrib/forms/mh_therapy_progress/table.sql @@ -107,4 +107,4 @@ followups_call varchar(3) not NULL default 'N/A', followups_call_to varchar(20) default NULL, followups_call_for varchar(20) default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/neurologicalreview/table.sql b/contrib/forms/neurologicalreview/table.sql index 4c3f031ce..67c313181 100644 --- a/contrib/forms/neurologicalreview/table.sql +++ b/contrib/forms/neurologicalreview/table.sql @@ -22,4 +22,4 @@ paresthesia longtext, symptoms_of_problems longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/nursing_notes/table.sql b/contrib/forms/nursing_notes/table.sql index c7e41f877..f02fe6182 100644 --- a/contrib/forms/nursing_notes/table.sql +++ b/contrib/forms/nursing_notes/table.sql @@ -10,4 +10,4 @@ CREATE TABLE IF NOT EXISTS `form_nursing_notes` ( `procedures` varchar(255) NOT NULL DEFAULT '', `discharge` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; \ No newline at end of file +) ENGINE=InnoDB; diff --git a/contrib/forms/obstetrical/table.sql b/contrib/forms/obstetrical/table.sql index bb602b550..b050a3c40 100644 --- a/contrib/forms/obstetrical/table.sql +++ b/contrib/forms/obstetrical/table.sql @@ -31,4 +31,4 @@ injury longtext, day_care longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/pain/table.sql b/contrib/forms/pain/table.sql index 0bcf824d1..55b9f5828 100644 --- a/contrib/forms/pain/table.sql +++ b/contrib/forms/pain/table.sql @@ -20,4 +20,4 @@ accompanying_symptoms_headache longtext, accompanying_symptoms_other longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/patient_instruction/table.sql b/contrib/forms/patient_instruction/table.sql index 968bf9bce..7297b63d5 100644 --- a/contrib/forms/patient_instruction/table.sql +++ b/contrib/forms/patient_instruction/table.sql @@ -8,4 +8,4 @@ CREATE TABLE IF NOT EXISTS `form_patient_instruction` ( `activity` tinyint(4) NOT NULL DEFAULT 0, `instruction` varchar(30000) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/patient_intake_history/table.sql b/contrib/forms/patient_intake_history/table.sql index c23979d14..ef49295fb 100644 --- a/contrib/forms/patient_intake_history/table.sql +++ b/contrib/forms/patient_intake_history/table.sql @@ -346,7 +346,7 @@ pih_date_reviewed_6 varchar(255), linked_ros_id bigint(20) NOT NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_patient_intake_history_ros` ( @@ -638,4 +638,4 @@ ros_notes_70 varchar(255), ros_other_allergy_reaction_ varchar(255), PRIMARY KEY (id) -) TYPE=MyISAM; \ No newline at end of file +) ENGINE=MyISAM; diff --git a/contrib/forms/ped_GI/table.sql b/contrib/forms/ped_GI/table.sql index 5c7481e40..0b566ac0c 100644 --- a/contrib/forms/ped_GI/table.sql +++ b/contrib/forms/ped_GI/table.sql @@ -36,4 +36,4 @@ CREATE TABLE IF NOT EXISTS `form_ped_GI` ( `immunization_up_to_date` VARCHAR (255) default NULL, `notes` VARCHAR (255) default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/ped_fever/table.sql b/contrib/forms/ped_fever/table.sql index 596c1e8ab..e2b03a381 100644 --- a/contrib/forms/ped_fever/table.sql +++ b/contrib/forms/ped_fever/table.sql @@ -27,4 +27,4 @@ CREATE TABLE IF NOT EXISTS `form_ped_fever` ( `immunization_up_to_date` VARCHAR (255) default NULL, `notes` VARCHAR (255) default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/ped_pain/table.sql b/contrib/forms/ped_pain/table.sql index 7f04178d5..39f3378b5 100644 --- a/contrib/forms/ped_pain/table.sql +++ b/contrib/forms/ped_pain/table.sql @@ -25,4 +25,4 @@ CREATE TABLE IF NOT EXISTS `form_ped_pain` ( `immunization_up_to_date` VARCHAR (255) default NULL, `notes` VARCHAR (255) default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/pfsh/table.sql b/contrib/forms/pfsh/table.sql index e9817d552..ad7d1d811 100644 --- a/contrib/forms/pfsh/table.sql +++ b/contrib/forms/pfsh/table.sql @@ -10,4 +10,4 @@ CREATE TABLE IF NOT EXISTS `form_pfsh` ( `family` varchar(30000) NOT NULL DEFAULT '', `social` varchar(30000) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; \ No newline at end of file +) ENGINE=InnoDB; diff --git a/contrib/forms/phone_exam/table.sql b/contrib/forms/phone_exam/table.sql index 57b29c2c6..5bc48499a 100644 --- a/contrib/forms/phone_exam/table.sql +++ b/contrib/forms/phone_exam/table.sql @@ -8,4 +8,4 @@ CREATE TABLE IF NOT EXISTS `form_phone_exam` ( `activity` tinyint(4) default NULL, `notes` text default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/physical_examination/table.sql b/contrib/forms/physical_examination/table.sql index 2daf7b164..fa2bea4d7 100644 --- a/contrib/forms/physical_examination/table.sql +++ b/contrib/forms/physical_examination/table.sql @@ -91,4 +91,4 @@ gynec_rectal_data varchar(255), tot_num_examined varchar(255), PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/physician_history/table.sql b/contrib/forms/physician_history/table.sql index ce8b591ae..38a33368d 100644 --- a/contrib/forms/physician_history/table.sql +++ b/contrib/forms/physician_history/table.sql @@ -259,4 +259,4 @@ ros_hemato_other tinyint(1) DEFAULT 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/plist/table.sql b/contrib/forms/plist/table.sql index bd8e87e87..6eb0b7ea1 100644 --- a/contrib/forms/plist/table.sql +++ b/contrib/forms/plist/table.sql @@ -36,4 +36,4 @@ pl_problem_23 longtext, pl_problem_24 longtext, pl_problem_25 longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/podiatry/table.sql b/contrib/forms/podiatry/table.sql index b88312682..15cca9bb3 100644 --- a/contrib/forms/podiatry/table.sql +++ b/contrib/forms/podiatry/table.sql @@ -9,4 +9,4 @@ CREATE TABLE IF NOT EXISTS form_podiatry ( followup_location varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/prior_auth/table.sql b/contrib/forms/prior_auth/table.sql index cc25c7bb4..ce4b0cf20 100644 --- a/contrib/forms/prior_auth/table.sql +++ b/contrib/forms/prior_auth/table.sql @@ -6,4 +6,4 @@ CREATE TABLE `form_prior_auth` ( `prior_auth_number` varchar(35) default NULL, `comments` varchar(255) default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM; \ No newline at end of file +) ENGINE=MyISAM; diff --git a/contrib/forms/progressnotes/table.sql b/contrib/forms/progressnotes/table.sql index 297d0adca..51aba63d8 100644 --- a/contrib/forms/progressnotes/table.sql +++ b/contrib/forms/progressnotes/table.sql @@ -67,4 +67,4 @@ prog_nutrition_e longtext, prog_sexual_p longtext, prog_substance_a longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/prosthesis/table.sql b/contrib/forms/prosthesis/table.sql index 61605a430..4305d5e76 100644 --- a/contrib/forms/prosthesis/table.sql +++ b/contrib/forms/prosthesis/table.sql @@ -36,4 +36,4 @@ CREATE TABLE `form_prosthesis` ( `given_instructions` tinyint(1) default NULL, `patient_understands` tinyint(1) default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM; \ No newline at end of file +) ENGINE=MyISAM; diff --git a/contrib/forms/review_of_systems/table.sql b/contrib/forms/review_of_systems/table.sql index afe6a853e..e66a18a12 100644 --- a/contrib/forms/review_of_systems/table.sql +++ b/contrib/forms/review_of_systems/table.sql @@ -17,11 +17,11 @@ CREATE TABLE `form_review_of_systems` ( `activity` tinyint(4) default NULL, `date` datetime default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE `form_review_of_systems_checks` ( `id` int(11) NOT NULL auto_increment, `foreign_id` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/reviewofs/table.sql b/contrib/forms/reviewofs/table.sql index 3b374a70d..7fd2dadc0 100644 --- a/contrib/forms/reviewofs/table.sql +++ b/contrib/forms/reviewofs/table.sql @@ -115,4 +115,4 @@ cushing_syndrom varchar(5), addison_syndrom varchar(5), additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/rom/table.sql b/contrib/forms/rom/table.sql index db2c18182..c634d7d88 100644 --- a/contrib/forms/rom/table.sql +++ b/contrib/forms/rom/table.sql @@ -164,4 +164,4 @@ CREATE TABLE IF NOT EXISTS `form_rom` ( `r4_7_lf_passive` text NOT NULL default '', `notes` text NOT NULL default '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/ros2/table.sql b/contrib/forms/ros2/table.sql index 2d31ff8a9..ab398411d 100644 --- a/contrib/forms/ros2/table.sql +++ b/contrib/forms/ros2/table.sql @@ -393,4 +393,4 @@ CREATE TABLE IF NOT EXISTS `form_ros2` ( `psychiatric_insomnia` varchar(3) NOT NULL default 'N/A', `psychiatric_insomnia_text` varchar(255) NOT NULL default '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/rosform/table.sql b/contrib/forms/rosform/table.sql index 799ad24c9..c467834fc 100644 --- a/contrib/forms/rosform/table.sql +++ b/contrib/forms/rosform/table.sql @@ -181,4 +181,4 @@ conclusions_cholesterol_teaching varchar(255), conclusions_advance_directive varchar(255), follow_up longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/routine_screening_record/table.sql b/contrib/forms/routine_screening_record/table.sql index 40beb42d1..753b9369a 100644 --- a/contrib/forms/routine_screening_record/table.sql +++ b/contrib/forms/routine_screening_record/table.sql @@ -17,4 +17,4 @@ record_7 longtext, record_8 longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/scanned_notes/table.sql b/contrib/forms/scanned_notes/table.sql index c7de0d586..d219e7fa4 100644 --- a/contrib/forms/scanned_notes/table.sql +++ b/contrib/forms/scanned_notes/table.sql @@ -3,4 +3,4 @@ CREATE TABLE IF NOT EXISTS form_scanned_notes ( activity tinyint(1) NOT NULL DEFAULT 1, -- 0 if deleted notes text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/snellen/table.sql b/contrib/forms/snellen/table.sql index 967cac298..36a1e04af 100644 --- a/contrib/forms/snellen/table.sql +++ b/contrib/forms/snellen/table.sql @@ -12,4 +12,4 @@ CREATE TABLE IF NOT EXISTS `form_snellen` ( `right_2` text NOT NULL DEFAULT '', `notes` text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/soap2/table.sql b/contrib/forms/soap2/table.sql index 875097569..857289918 100644 --- a/contrib/forms/soap2/table.sql +++ b/contrib/forms/soap2/table.sql @@ -23,4 +23,4 @@ CREATE TABLE IF NOT EXISTS `form_soap2` ( `abdomen` varchar(255) NOT NULL DEFAULT '', `mentalstatus` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/contrib/forms/soccer_injury/table.sql b/contrib/forms/soccer_injury/table.sql index c6027d9ef..0f0277f93 100644 --- a/contrib/forms/soccer_injury/table.sql +++ b/contrib/forms/soccer_injury/table.sql @@ -56,4 +56,4 @@ CREATE TABLE IF NOT EXISTS form_soccer_injury ( sinoreturn tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/specialist_notes/table.sql b/contrib/forms/specialist_notes/table.sql index 616e9e204..7cb809515 100644 --- a/contrib/forms/specialist_notes/table.sql +++ b/contrib/forms/specialist_notes/table.sql @@ -9,4 +9,4 @@ CREATE TABLE IF NOT EXISTS form_specialist_notes ( followup_location varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/sports_fitness/table.sql b/contrib/forms/sports_fitness/table.sql index 87874d0c6..12ef417d3 100644 --- a/contrib/forms/sports_fitness/table.sql +++ b/contrib/forms/sports_fitness/table.sql @@ -29,4 +29,4 @@ CREATE TABLE IF NOT EXISTS form_sports_fitness ( other text NOT NULL DEFAULT '', PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/strength_conditioning/table.sql b/contrib/forms/strength_conditioning/table.sql index 975eed395..ffa8d56e9 100644 --- a/contrib/forms/strength_conditioning/table.sql +++ b/contrib/forms/strength_conditioning/table.sql @@ -15,4 +15,4 @@ CREATE TABLE IF NOT EXISTS form_strength_conditioning ( datatype tinyint NOT NULL DEFAULT 0, value varchar(255) DEFAULT NULL, PRIMARY KEY (id, rownbr, colnbr) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/treatment_protocols/table.sql b/contrib/forms/treatment_protocols/table.sql index 1c8ffde96..7e1a1b748 100644 --- a/contrib/forms/treatment_protocols/table.sql +++ b/contrib/forms/treatment_protocols/table.sql @@ -15,4 +15,4 @@ CREATE TABLE IF NOT EXISTS form_treatment_protocols ( datatype tinyint NOT NULL DEFAULT 0, value varchar(255) DEFAULT NULL, PRIMARY KEY (id, rownbr, colnbr) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/vision/table.sql b/contrib/forms/vision/table.sql index 3f37ae892..0682d2d9c 100644 --- a/contrib/forms/vision/table.sql +++ b/contrib/forms/vision/table.sql @@ -18,4 +18,4 @@ os_k2_axis longtext, os_testing_status longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/vitals/table.sql b/contrib/forms/vitals/table.sql index 08d17d53a..9190c6440 100644 --- a/contrib/forms/vitals/table.sql +++ b/contrib/forms/vitals/table.sql @@ -21,4 +21,4 @@ CREATE TABLE IF NOT EXISTS `form_vitals` ( `waist_circ` VARCHAR (255) default NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/vitalsigns/table.sql b/contrib/forms/vitalsigns/table.sql index 563120f0b..d6ae127a2 100644 --- a/contrib/forms/vitalsigns/table.sql +++ b/contrib/forms/vitalsigns/table.sql @@ -31,4 +31,4 @@ body_mass_index longtext, figure_shape longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/well_child/table.sql b/contrib/forms/well_child/table.sql index 1273dae1d..0c006b169 100644 --- a/contrib/forms/well_child/table.sql +++ b/contrib/forms/well_child/table.sql @@ -38,11 +38,11 @@ CREATE TABLE `form_well_child` ( `activity` tinyint(4) default NULL, `date` datetime default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE `form_well_child_checks` ( `id` int(11) NOT NULL auto_increment, `foreign_id` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/well_child_care/table.sql b/contrib/forms/well_child_care/table.sql index c2ab5513b..958cd12d7 100644 --- a/contrib/forms/well_child_care/table.sql +++ b/contrib/forms/well_child_care/table.sql @@ -121,4 +121,4 @@ CREATE TABLE IF NOT EXISTS `form_well_child_care` ( `notes` VARCHAR (255) NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/contrib/forms/well_infant/table.sql b/contrib/forms/well_infant/table.sql index c7a05f92f..1a7b1dc35 100644 --- a/contrib/forms/well_infant/table.sql +++ b/contrib/forms/well_infant/table.sql @@ -26,11 +26,11 @@ CREATE TABLE `form_well_infant` ( `activity` tinyint(4) default NULL, `date` datetime default NULL, PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE `form_well_infant_checks` ( `id` int(11) NOT NULL auto_increment, `foreign_id` int(11) NOT NULL default '0', `name` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/CAMOS/table.sql b/interface/forms/CAMOS/table.sql index ddc455892..c3f1723a9 100755 --- a/interface/forms/CAMOS/table.sql +++ b/interface/forms/CAMOS/table.sql @@ -12,7 +12,7 @@ item TEXT, content TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_CAMOS_category` ( id bigint(20) NOT NULL auto_increment, @@ -26,7 +26,7 @@ activity tinyint(4) default NULL, category TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_CAMOS_subcategory` ( id bigint(20) NOT NULL auto_increment, @@ -41,7 +41,7 @@ subcategory TEXT, category_id bigint(20) NOT NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_CAMOS_item` ( id bigint(20) NOT NULL auto_increment, @@ -57,7 +57,7 @@ content TEXT, subcategory_id bigint(20) NOT NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; INSERT INTO `form_CAMOS_category` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'prescriptions'); diff --git a/interface/forms/CAMOS/table_no_data.sql b/interface/forms/CAMOS/table_no_data.sql index 3e5e4884b..d6330e5f5 100755 --- a/interface/forms/CAMOS/table_no_data.sql +++ b/interface/forms/CAMOS/table_no_data.sql @@ -12,7 +12,7 @@ item TEXT, content TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_CAMOS_category` ( id bigint(20) NOT NULL auto_increment, @@ -26,7 +26,7 @@ activity tinyint(4) default NULL, category TEXT, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_CAMOS_subcategory` ( id bigint(20) NOT NULL auto_increment, @@ -41,7 +41,7 @@ subcategory TEXT, category_id bigint(20) NOT NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `form_CAMOS_item` ( id bigint(20) NOT NULL auto_increment, @@ -57,4 +57,4 @@ content TEXT, subcategory_id bigint(20) NOT NULL, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/dictation/table.sql b/interface/forms/dictation/table.sql index 156bc6d24..2701f232e 100644 --- a/interface/forms/dictation/table.sql +++ b/interface/forms/dictation/table.sql @@ -9,4 +9,4 @@ activity tinyint(4) default NULL, dictation longtext, additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/misc_billing_options/table.sql b/interface/forms/misc_billing_options/table.sql index c192bc163..ac2bb8d09 100755 --- a/interface/forms/misc_billing_options/table.sql +++ b/interface/forms/misc_billing_options/table.sql @@ -25,4 +25,4 @@ CREATE TABLE IF NOT EXISTS `form_misc_billing_options` ( comments varchar(255) default NULL, replacement_claim tinyint(1) default 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/physical_exam/table.sql b/interface/forms/physical_exam/table.sql index 647b42e52..25f66f586 100644 --- a/interface/forms/physical_exam/table.sql +++ b/interface/forms/physical_exam/table.sql @@ -6,11 +6,11 @@ CREATE TABLE IF NOT EXISTS form_physical_exam ( diagnosis varchar(255) NOT NULL DEFAULT '', comments varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (forms_id, line_id) -) TYPE=MyISAM; +) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS form_physical_exam_diagnoses ( line_id char(8) NOT NULL, ordering int(11) NOT NULL DEFAULT 0, diagnosis varchar(255) NOT NULL DEFAULT '', KEY (line_id, ordering) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/reviewofs/table.sql b/interface/forms/reviewofs/table.sql index 3b374a70d..7fd2dadc0 100644 --- a/interface/forms/reviewofs/table.sql +++ b/interface/forms/reviewofs/table.sql @@ -115,4 +115,4 @@ cushing_syndrom varchar(5), addison_syndrom varchar(5), additional_notes longtext, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/soap/table.sql b/interface/forms/soap/table.sql index a433f7381..bbce3d8d7 100644 --- a/interface/forms/soap/table.sql +++ b/interface/forms/soap/table.sql @@ -11,4 +11,4 @@ CREATE TABLE IF NOT EXISTS `form_soap` ( `assessment` text default NULL, `plan` text default NULL, PRIMARY KEY (id) -) TYPE=InnoDB; +) ENGINE=InnoDB; diff --git a/interface/forms/vitals/table.sql b/interface/forms/vitals/table.sql index 87a971b6d..b4b207690 100644 --- a/interface/forms/vitals/table.sql +++ b/interface/forms/vitals/table.sql @@ -21,4 +21,4 @@ CREATE TABLE IF NOT EXISTS `form_vitals` ( `head_circ` FLOAT(4,2) default 0, `oxygen_saturation` FLOAT(5,2) default 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; diff --git a/interface/forms/vitalsM/table.sql b/interface/forms/vitalsM/table.sql index b09b1e96a..2c39d4678 100644 --- a/interface/forms/vitalsM/table.sql +++ b/interface/forms/vitalsM/table.sql @@ -21,4 +21,4 @@ CREATE TABLE IF NOT EXISTS `form_vitalsM` ( `head_circ` FLOAT(5,2) default 0, `oxygen_saturation` FLOAT(5,2) default 0, PRIMARY KEY (id) -) TYPE=MyISAM; +) ENGINE=MyISAM; -- 2.11.4.GIT