1 CREATE TABLE IF NOT EXISTS `form_leg_length` (
2 `id` bigint(20) NOT NULL auto_increment,
3 `date` datetime DEFAULT NULL,
4 `pid` bigint(20) NOT NULL DEFAULT 0,
5 `user` varchar(255) DEFAULT NULL,
6 `groupname` varchar(255) DEFAULT NULL,
7 `authorized` tinyint(4) NOT NULL DEFAULT 0,
8 `activity` tinyint(4) NOT NULL DEFAULT 0,
9 `AE_left` text DEFAULT NULL,
10 `AE_right` text DEFAULT NULL,
11 `BE_left` text DEFAULT NULL,
12 `BE_right` text DEFAULT NULL,
13 `AK_left` text DEFAULT NULL,
14 `AK_right` text DEFAULT NULL,
15 `K_left` text DEFAULT NULL,
16 `K_right` text DEFAULT NULL,
17 `BK_left` text DEFAULT NULL,
18 `BK_right` text DEFAULT NULL,
19 `ASIS_left` text DEFAULT NULL,
20 `ASIS_right` text DEFAULT NULL,
21 `UMB_left` text DEFAULT NULL,
22 `UMB_right` text DEFAULT NULL,
23 `notes` text NOT NULL DEFAULT '',