1 CREATE TABLE IF NOT EXISTS `form_habits` (
\r
2 id bigint(20) NOT NULL auto_increment,
\r
3 date datetime default NULL,
\r
4 pid bigint(20) default NULL,
\r
5 user varchar(255) default NULL,
\r
6 groupname varchar(255) default NULL,
\r
7 authorized tinyint(4) default NULL,
\r
8 activity tinyint(4) default NULL,
\r
9 coffee ENUM ('YES','NO') default NULL,
\r
10 tea ENUM ('YES','NO') default NULL,
\r
11 soft_drinks ENUM ('YES','NO') default NULL,
\r
12 other_caffeine ENUM ('YES','NO') default NULL,
\r
13 caffeine_per_day VARCHAR (255) default NULL,
\r
14 salt_usage ENUM ('Heavy','Moderate','Light','No salt') default NULL,
\r
15 sugar_usage ENUM ('Heavy','Moderate','Light','No sugar') default NULL,
\r
16 diet ENUM ('Healthy','Fair','Poor') default NULL,
\r
17 diet_comments VARCHAR (255) default NULL,
\r
18 alc_per_day TINYINT (3) default NULL,
\r
19 alc_per_week TINYINT (3) default NULL,
\r
20 recr_drugs VARCHAR (255) default NULL,
\r
21 recr_drugs_often VARCHAR (255) default NULL,
\r
22 alc_drug_problem ENUM ('YES','NO') default NULL,
\r
23 alc_drug_problem_explain VARCHAR (255) default NULL,
\r
24 current_smoke ENUM ('YES','NO') default NULL,
\r
25 ever_smoked ENUM ('YES','NO') default NULL,
\r
26 cig_per_day_now TINYINT (3) default NULL,
\r
27 cig_per_day_past TINYINT (3) default NULL,
\r
28 how_long_smoke TINYINT (3) default NULL,
\r
29 smoke_quit DATE default NULL,
\r
30 like_to_quit ENUM ('YES','NO') default NULL,
\r
31 exercise_reg ENUM ('YES','NO') default NULL,
\r
32 exercise_types VARCHAR (255) default NULL,
\r
33 exercise_per_week VARCHAR (255) default NULL,
\r
34 exercise_minutes VARCHAR (255) default NULL,
\r
35 seat_belt ENUM ('Always','Usually','Seldom','Never') default NULL,
\r
36 ever_been_molested ENUM ('YES','NO') default NULL,
\r
37 ever_molested_other ENUM ('YES','NO') default NULL,
\r