1 CREATE TABLE IF NOT EXISTS form_football_injury_audit (
2 id bigint(20) NOT NULL auto_increment,
3 activity tinyint(1) NOT NULL DEFAULT 1,
4 fiinjmin int(11) NOT NULL DEFAULT 0,
5 fiinjtime int(11) NOT NULL DEFAULT 0,
6 fimatchtype int(11) NOT NULL DEFAULT 0,
7 fimech_tackling tinyint(1) NOT NULL DEFAULT 0,
8 fimech_tackled tinyint(1) NOT NULL DEFAULT 0,
9 fimech_collision tinyint(1) NOT NULL DEFAULT 0,
10 fimech_kicked tinyint(1) NOT NULL DEFAULT 0,
11 fimech_elbow tinyint(1) NOT NULL DEFAULT 0,
12 fimech_othercon varchar(255) NOT NULL DEFAULT '',
13 fimech_nofoul tinyint(1) NOT NULL DEFAULT 0,
14 fimech_oppfoul tinyint(1) NOT NULL DEFAULT 0,
15 fimech_ownfoul tinyint(1) NOT NULL DEFAULT 0,
16 fimech_yellow tinyint(1) NOT NULL DEFAULT 0,
17 fimech_red tinyint(1) NOT NULL DEFAULT 0,
18 fimech_passing tinyint(1) NOT NULL DEFAULT 0,
19 fimech_shooting tinyint(1) NOT NULL DEFAULT 0,
20 fimech_running tinyint(1) NOT NULL DEFAULT 0,
21 fimech_dribbling tinyint(1) NOT NULL DEFAULT 0,
22 fimech_heading tinyint(1) NOT NULL DEFAULT 0,
23 fimech_jumping tinyint(1) NOT NULL DEFAULT 0,
24 fimech_landing tinyint(1) NOT NULL DEFAULT 0,
25 fimech_fall tinyint(1) NOT NULL DEFAULT 0,
26 fimech_stretching tinyint(1) NOT NULL DEFAULT 0,
27 fimech_turning tinyint(1) NOT NULL DEFAULT 0,
28 fimech_throwing tinyint(1) NOT NULL DEFAULT 0,
29 fimech_diving tinyint(1) NOT NULL DEFAULT 0,
30 fimech_overuse tinyint(1) NOT NULL DEFAULT 0,
31 fimech_othernon varchar(255) NOT NULL DEFAULT '',
32 fisurface int(11) NOT NULL DEFAULT 0,
33 fiposition int(11) NOT NULL DEFAULT 0,
34 fifootwear int(11) NOT NULL DEFAULT 0,
35 fiside int(11) NOT NULL DEFAULT 0,
36 firemoved int(11) NOT NULL DEFAULT 0,