CREATE TABLE survey_woqod_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_woqod_entry (


  dept tinyint(2) default NULL,


  position tinyint(2) default NULL,


  ethnic tinyint(1) default NULL,


  ethnic_asian varchar(20) CHARACTER SET utf8 COLLATE utf8_bin,


  education tinyint(1) default NULL,


  duration tinyint(1) default NULL,


  stat1_1 tinyint(2) default NULL,


  stat2_1 tinyint(2) default NULL,


  stat3_1 tinyint(2) default NULL,


  stat4_1 tinyint(2) default NULL,


  stat5_1 tinyint(2) default NULL,


  stat6_1 tinyint(2) default NULL,


  stat7_1 tinyint(2) default NULL,


  stat8_1 tinyint(2) default NULL,


  stat9_1 tinyint(2) default NULL,


  stat10_1 tinyint(2) default NULL,


  stat11_1 tinyint(2) default NULL,


  stat12_1 tinyint(2) default NULL,


  stat13_1 tinyint(2) default NULL,


  stat14_1 tinyint(2) default NULL,


  stat15_1 tinyint(2) default NULL,


  stat16_1 tinyint(2) default NULL,


  stat17_1 tinyint(2) default NULL,


  stat18_1 tinyint(2) default NULL,


  stat19_1 tinyint(2) default NULL,


  stat20_1 tinyint(2) default NULL,


  stat21_1 tinyint(2) default NULL,


  stat22_1 tinyint(2) default NULL,


  stat23_1 tinyint(2) default NULL,


  stat24_1 tinyint(2) default NULL,


  stat25_1 tinyint(2) default NULL,


  stat26_1 tinyint(2) default NULL,


  stat27_1 tinyint(2) default NULL,


  stat28_1 tinyint(2) default NULL,


  stat29_1 tinyint(2) default NULL,


  stat30_1 tinyint(2) default NULL,


  stat31_1 tinyint(2) default NULL,


  stat32_1 tinyint(2) default NULL,


  stat33_1 tinyint(2) default NULL,


  stat34_1 tinyint(2) default NULL,


  stat35_1 tinyint(2) default NULL,


  stat36_1 tinyint(2) default NULL,


  stat37_1 tinyint(2) default NULL,


  stat38_1 tinyint(2) default NULL,


  stat1_2 tinyint(2) default NULL,


  stat2_2 tinyint(2) default NULL,


  stat3_2 tinyint(2) default NULL,


  stat4_2 tinyint(2) default NULL,


  stat5_2 tinyint(2) default NULL,


  stat6_2 tinyint(2) default NULL,


  stat7_2 tinyint(2) default NULL,


  stat8_2 tinyint(2) default NULL,


  stat9_2 tinyint(2) default NULL,


  stat10_2 tinyint(2) default NULL,


  stat11_2 tinyint(2) default NULL,


  stat12_2 tinyint(2) default NULL,


  stat13_2 tinyint(2) default NULL,


  stat14_2 tinyint(2) default NULL,


  stat15_2 tinyint(2) default NULL,


  stat16_2 tinyint(2) default NULL,


  stat17_2 tinyint(2) default NULL,


  stat18_2 tinyint(2) default NULL,


  stat19_2 tinyint(2) default NULL,


  stat20_2 tinyint(2) default NULL,


  stat21_2 tinyint(2) default NULL,


  stat22_2 tinyint(2) default NULL,


  stat23_2 tinyint(2) default NULL,


  stat24_2 tinyint(2) default NULL,


  stat25_2 tinyint(2) default NULL,


  stat26_2 tinyint(2) default NULL,


  stat27_2 tinyint(2) default NULL,


  stat28_2 tinyint(2) default NULL,


  stat29_2 tinyint(2) default NULL,


  stat30_2 tinyint(2) default NULL,


  stat31_2 tinyint(2) default NULL,


  stat32_2 tinyint(2) default NULL,


  stat33_2 tinyint(2) default NULL,


  stat34_2 tinyint(2) default NULL,


  stat35_2 tinyint(2) default NULL,


  stat36_2 tinyint(2) default NULL,


  stat37_2 tinyint(2) default NULL,


  stat38_2 tinyint(2) default NULL,


  comment1 text CHARACTER SET utf8 COLLATE utf8_bin,


  lang char(1) default NULL,


  edate timestamp NOT NULL,


  userip varchar(32) default NULL,


  username varchar(32) not null primary key) 


  ENGINE=MyISAM DEFAULT CHARSET=latin1;