create table srv_map (sid int auto_increment primary key, survey_id int, page_id int, section_id int, q_order int, mtype varchar(15), dfields varchar(30), fpos int, flen int, fdesc_1 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin, fdesc_2 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin, opts_1 text CHARACTER SET utf8 COLLATE utf8_bin, opts_2 text CHARACTER SET utf8 COLLATE utf8_bin, filter varchar(255), others int, scores varchar(255), mandatory int, req_comments int) ENGINE=InnoDB DEFAULT CHARSET=utf8 DEFAULT COLLATE utf8_bin