CREATE TABLE survey_bls_track ( ID int(10) unsigned NOT NULL auto_increment, sid varchar(100) NOT NULL default '', ip varchar(30) NOT NULL default '', page varchar(100) NOT NULL default '', logtime datetime default NULL, updt timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, cid varchar(60) default NULL, qcount tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`ID`), UNIQUE KEY `UNIQUE` (`ip`,`sid`,`page`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE survey_bls_users ( user_name varchar(255) NOT NULL default '', user_password varchar(255) default NULL, user_type int(1) default NULL, PRIMARY KEY (user_name) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE survey_bls_entry ( q1 tinyint(2), q2 tinyint(2), q3 tinyint(2), q3a tinyint(2), q3_other varchar(50) CHARACTER SET utf8 COLLATE utf8_bin, q4 tinyint(2), q5 tinyint(2), q6 tinyint(2), q7 tinyint(2), q8 tinyint(2), q9 tinyint(2), q10 tinyint(2), q11 tinyint(2), q12 tinyint(2), q13 tinyint(2), q14 tinyint(2), q15 tinyint(2), q16 tinyint(2), q17 tinyint(2), q18 tinyint(2), q19 tinyint(2), q20 tinyint(2), q21 tinyint(2), q22 tinyint(2), q23 tinyint(2), q24 tinyint(2), q25 tinyint(2), q26 tinyint(2), q27 tinyint(2), q28 tinyint(2), q29 tinyint(2), q30 tinyint(2), q31 tinyint(2), q32 tinyint(2), q33 tinyint(2), q34 tinyint(2), q35 tinyint(2), q36 tinyint(2), q37 tinyint(2), q38 tinyint(2), q39 tinyint(2), q40 tinyint(2), q41 tinyint(2), q42 tinyint(2), q43 tinyint(2), q44 tinyint(2), q45 tinyint(2), q46 tinyint(2), q47 tinyint(2), q47a tinyint(2), q47b tinyint(2), q47c tinyint(2), q47d tinyint(2), q47e tinyint(2), q47f tinyint(2), q47g tinyint(2), q48a tinyint(2), q48b tinyint(2), q48c tinyint(2), q48d tinyint(2), q48e tinyint(2), q48f tinyint(2), q48g tinyint(2), q48 tinyint(2), q49 tinyint(2), q50 tinyint(2), q51 tinyint(2), q52 tinyint(2), q53 tinyint(2), q54 tinyint(2), q55 tinyint(2), d1_city varchar(60) CHARACTER SET utf8 COLLATE utf8_bin, d1_country varchar(60) CHARACTER SET utf8 COLLATE utf8_bin, d2 tinyint(2), d3 tinyint(2), d4_public varchar(5) CHARACTER SET utf8 COLLATE utf8_bin, d4_private varchar(5) CHARACTER SET utf8 COLLATE utf8_bin, d5 tinyint(2), d6 tinyint(2), d7 tinyint(2), d7_other varchar(60) CHARACTER SET utf8 COLLATE utf8_bin, d8 tinyint(2), d8_other varchar(60) CHARACTER SET utf8 COLLATE utf8_bin, d9 tinyint(2), d10 varchar(60) CHARACTER SET utf8 COLLATE utf8_bin, d11 tinyint(2), comment1 text CHARACTER SET utf8 COLLATE utf8_bin, lang char(1), edate timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, userip varchar(32), username varchar(32) NOT NULL, PRIMARY KEY (username) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;