#
DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_staff_list[6]`;
#
CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_staff_list[6]` ( `primary_form+id` VARCHAR(255),`primary_form+parent` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`primary_form+reason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+id` VARCHAR(255) DEFAULT '',`current_salary+parent` VARCHAR(255),`current_salary+end_date` datetime ,`current_salary+salary` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+start_date` datetime ,`person+id` VARCHAR(255) DEFAULT '',`person+parent` VARCHAR(255),`person+nationality` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` VARCHAR(255) DEFAULT '',`position+parent` VARCHAR(255),`position+department` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+status` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` VARCHAR(255) DEFAULT '',`start_salary+parent` VARCHAR(255),`start_salary+start_date` datetime ,`start_salary+salary` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+id` VARCHAR(255) DEFAULT '',`demographic+parent` VARCHAR(255),`demographic+birth_date` datetime ,`demographic+dependents` INT(11) ,`demographic+gender` text CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` text CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;