2 ADD begdate date DEFAULT NULL,
3 ADD enddate date DEFAULT NULL,
4 ADD occurrence int(11) DEFAULT 0,
5 ADD referredby varchar(255) DEFAULT NULL,
6 ADD extrainfo varchar(255) DEFAULT NULL;
8 ALTER TABLE patient_data
9 ADD squad int(11) NOT NULL DEFAULT 0,
10 ADD fitness int(11) NOT NULL DEFAULT 0;
12 ALTER TABLE history_data
13 CHANGE last_breast_exam last_breast_exam varchar(255) DEFAULT '',
14 CHANGE last_mammogram last_mammogram varchar(255) DEFAULT '',
15 CHANGE last_gynocological_exam last_gynocological_exam varchar(255) DEFAULT '',
16 CHANGE last_rectal_exam last_rectal_exam varchar(255) DEFAULT '',
17 CHANGE last_prostate_exam last_prostate_exam varchar(255) DEFAULT '',
18 CHANGE last_physical_exam last_physical_exam varchar(255) DEFAULT '',
19 CHANGE last_sigmoidoscopy_colonoscopy last_sigmoidoscopy_colonoscopy varchar(255) DEFAULT '',
20 ADD last_ecg varchar(255) NOT NULL DEFAULT '',
21 ADD last_cardiac_echo varchar(255) NOT NULL DEFAULT '',
22 -- here is 1 digit for each of the above exams, in order, with values
23 -- 0=n/a, 1=normal, 2=abnormal:
24 ADD last_exam_results varchar(255) NOT NULL DEFAULT '000000000';
26 UPDATE history_data SET last_breast_exam = '' WHERE last_breast_exam = '0000-00-00 00:00:00';
27 UPDATE history_data SET last_mammogram = '' WHERE last_mammogram = '0000-00-00 00:00:00';
28 UPDATE history_data SET last_gynocological_exam = '' WHERE last_gynocological_exam = '0000-00-00 00:00:00';
29 UPDATE history_data SET last_rectal_exam = '' WHERE last_rectal_exam = '0000-00-00 00:00:00';
30 UPDATE history_data SET last_prostate_exam = '' WHERE last_prostate_exam = '0000-00-00 00:00:00';
31 UPDATE history_data SET last_physical_exam = '' WHERE last_physical_exam = '0000-00-00 00:00:00';
32 UPDATE history_data SET last_sigmoidoscopy_colonoscopy = '' WHERE last_sigmoidoscopy_colonoscopy = '0000-00-00 00:00:00';