CREATE TABLE  survey_lance_entry (
  position tinyint(2) ,
  position_others varchar(50)  CHARACTER SET utf8 COLLATE utf8_bin,
  name varchar(50)  CHARACTER SET utf8 COLLATE utf8_bin,
  company varchar(50)  CHARACTER SET utf8 COLLATE utf8_bin,
  phone varchar(50)  CHARACTER SET utf8 COLLATE utf8_bin,
  comment1 text  CHARACTER SET utf8 COLLATE utf8_bin,
  lang char(1) ,
  edate timestamp,
  userip varchar(32) ,
  username varchar(32) NOT NULL,
  q1 varchar(50) ,
  q1_others varchar(50)  CHARACTER SET utf8 COLLATE utf8_bin,
  q2 varchar(50) ,
  q3 varchar(50) ,
  q4a tinyint(1) ,
  q4b tinyint(1) ,
  q4c tinyint(1) ,
  q5_1 tinyint(1) ,
  q5_2 tinyint(1) ,
  q5_3 tinyint(1) ,
  q5_4 tinyint(1) ,
  q5_5 tinyint(1) ,
  q5_6 tinyint(1) ,
  q5_7 tinyint(1) ,
  q5_8 tinyint(1) ,
  q5_9 tinyint(1) ,
  q5_10 tinyint(1) ,
  q5_11 tinyint(1) ,
  q5_12 tinyint(1) ,
  q5_13 tinyint(1) ,
  q5_14 tinyint(1) ,
  q5_15 tinyint(1) ,
  q5_16 tinyint(1) ,
  q5_17 tinyint(1) ,
  q5_18 tinyint(1) ,
  q5_19 tinyint(1) ,
  q5_20 tinyint(1) ,
  q5_21 tinyint(1) ,
  q5_22 tinyint(1) ,
  q6_1 tinyint(1) ,
  q6_2 tinyint(1) ,
  q6_3 tinyint(1) ,
  q6_4 tinyint(1) ,
  q6_5 tinyint(1) ,
  q6_6 tinyint(1) ,
  q6_7 tinyint(1) ,
  q6_8 tinyint(1) ,
  q6_9 tinyint(1) ,
  q6_10 tinyint(1) ,
  q6_11 tinyint(1) ,
  q6_12 tinyint(1) ,
  q6_13 tinyint(1) ,
  q6_14 tinyint(1) ,
  q6_15 tinyint(1) ,
  q6_16 tinyint(1) ,
  q6_17 tinyint(1) ,
  q6_18 tinyint(1) ,
  q6_19 tinyint(1) ,
  q6_20 tinyint(1) ,
  q6_21 tinyint(1) ,
  q6_22 tinyint(1) ,
  q7a_1 tinyint(2) ,
  q7a_2 tinyint(2) ,
  q7a_3 tinyint(2) ,
  q7a_4 tinyint(2) ,
  q7a_5 tinyint(2) ,
  q7a_6 tinyint(2) ,
  q7a_7 tinyint(2) ,
  q7a_8 tinyint(2) ,
  q7a_9 tinyint(2) ,
  q7a_10 tinyint(2) ,
  q7a_11 tinyint(2) ,
  q7a_12 tinyint(2) ,
  q7a_13 tinyint(2) ,
  q7a_14 tinyint(2) ,
  q7a_15 tinyint(2) ,
  q7a_16 tinyint(2) ,
  q7a_17 tinyint(2) ,
  q7a_18 tinyint(2) ,
  q7a_19 tinyint(2) ,
  q7a_20 tinyint(2) ,
  q7a_21 tinyint(2) ,
  q7a_22 tinyint(2) ,
  q7a_23 tinyint(2) ,
  q7i_1 tinyint(2) ,
  q7i_2 tinyint(2) ,
  q7i_3 tinyint(2) ,
  q7i_4 tinyint(2) ,
  q7i_5 tinyint(2) ,
  q7i_6 tinyint(2) ,
  q7i_7 tinyint(2) ,
  q7i_8 tinyint(2) ,
  q7i_9 tinyint(2) ,
  q7i_10 tinyint(2) ,
  q7i_11 tinyint(2) ,
  q7i_12 tinyint(2) ,
  q7i_13 tinyint(2) ,
  q7i_14 tinyint(2) ,
  q7i_15 tinyint(2) ,
  q7i_16 tinyint(2) ,
  q7i_17 tinyint(2) ,
  q7i_18 tinyint(2) ,
  q7i_19 tinyint(2) ,
  q7i_20 tinyint(2) ,
  q7i_21 tinyint(2) ,
  q7i_22 tinyint(2) ,
  q7i_23 tinyint(2) ,
  s2 tinyint(1) ,
  s3 tinyint(1) ,
  s4 tinyint(1) ,
  s4_others varchar(50)  CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY  (username)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE  survey_lance_track (
  ID int(10) NOT NULL auto_increment,
  sid varchar(100) NOT NULL default '',
  ip varchar(30) NOT NULL default '',
  page varchar(100) NOT NULL default '',
  logtime datetime ,
  updt timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  cid varchar(60) ,
  qcount tinyint(3) ,
  PRIMARY KEY  (ID),
  UNIQUE KEY ip (ip,sid,page)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE  survey_lance_users (
  user_name varchar(255) NOT NULL default '',
  user_password varchar(255) ,
  user_type int(1) ,
  PRIMARY KEY  (user_name)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;