1 ALTER TABLE `users` ADD `upin` varchar(255) default NULL;
3 CREATE TABLE issue_encounter (
4 pid int(11) NOT NULL, -- pid from patient_data table
5 list_id int(11) NOT NULL, -- id from lists table
6 encounter int(11) NOT NULL, -- encounter from form_encounters table
7 resolved tinyint(1) NOT NULL, -- if problem seems resolved with this encounter
8 PRIMARY KEY (pid, list_id, encounter)