1 CREATE TABLE IF NOT EXISTS `form_vaginitis_soap` (
2 /* both extended and encounter forms need a last modified date */
3 date datetime default NULL comment 'last modified date',
4 /* these fields are common to all encounter forms. */
5 id bigint(20) NOT NULL auto_increment,
6 pid bigint(20) NOT NULL default 0,
7 user varchar(255) default NULL,
8 groupname varchar(255) default NULL,
9 authorized tinyint(4) default NULL,
10 activity tinyint(4) default NULL,
11 vaginitis_complaints varchar(255),
13 duration varchar(255),
14 objective_exam varchar(255),
15 vaginitis varchar(255),
16 plan_medications varchar(255),
17 plan_behavior_modification TEXT,
18 plan_cultures varchar(255),
22 INSERT IGNORE INTO list_options SET list_id='lists',
23 option_id='Vaginitis_Complaints',
24 title='Vaginitis Complaints';
25 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
27 title='Itching (pruritus)',
29 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
31 title='Discharge (leukorrhea)',
33 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
37 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
41 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
43 title='Previous Cultures',
45 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
47 title='Previous Prescriptions',
49 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Complaints',
53 INSERT IGNORE INTO list_options SET list_id='lists',
54 option_id='Vaginitis_Exam',
55 title='Vaginitis Exam';
56 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
60 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
64 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
68 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
72 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
76 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
80 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Exam',
84 INSERT IGNORE INTO list_options SET list_id='lists',
85 option_id='Vaginitis_Diagnosis',
86 title='Vaginitis Diagnosis';
87 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
91 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
95 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
97 title='Bacterial Vaginosis',
99 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
101 title='Vulvar Vaginitis',
103 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
105 title='Lichen Schlerosis',
107 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
109 title='Atrophic Vaginitis',
111 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Diagnosis',
115 INSERT IGNORE INTO list_options SET list_id='lists',
116 option_id='Vaginitis_Medications',
117 title='Vaginitis Medications';
118 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
120 title='Estrace Cream',
122 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
126 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
130 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
134 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
138 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
142 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
146 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Medications',
150 INSERT IGNORE INTO list_options SET list_id='lists',
151 option_id='Vaginitis_Cultures',
152 title='Vaginitis Cultures';
153 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Cultures',
157 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Cultures',
161 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Cultures',
163 title='Ureaplasma/Mycoplasma',
165 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Cultures',
169 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Cultures',
173 INSERT IGNORE INTO list_options SET list_id='Vaginitis_Cultures',