1 CREATE TABLE IF NOT EXISTS `form_immunization_record` (
2 id bigint(20) NOT NULL auto_increment,
3 date datetime default NULL,
4 pid bigint(20) default NULL,
5 user varchar(255) default NULL,
6 groupname varchar(255) default NULL,
7 authorized tinyint(4) default NULL,
8 activity tinyint(4) default NULL,
10 vacc_influenza longtext,
11 vacc_pneumococcal longtext,
15 vacc_varicella longtext,
16 last_vacc_tetanus longtext,
17 last_vacc_influenza longtext,
18 last_vacc_pneumococcal longtext,
19 last_vacc_mmr longtext,
20 last_vacc_hep_a longtext,
21 last_vacc_hep_b longtext,
22 last_vacc_varicella longtext,