alter table tlk_securitysevicek add item_notice_file varchar(500);
alter table tlk_securitysevicek add item_security_z_file varchar(500);
alter table tlk_securitysevicek add item_security_time TIMESTAMP;
alter table tlk_securitysevicek add item_security_f_file varchar(500);
alter table tlk_scope_nameChangeS add item_notice_file varchar(500);
alter table tlk_scope_nameChangeS add item_security_z_file varchar(500);
alter table tlk_scope_nameChangeS add item_security_f_file varchar(500);
CREATE TABLE `tlk_securityofficerchange`  (
                                              `PARENT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `LASTMODIFIED` datetime(0) NULL DEFAULT NULL,
                                              `FORMNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `STATE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUDITUSER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUDITDATE` datetime(0) NULL DEFAULT NULL,
                                              `AUTHOR` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUTHORDEPTID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUTHOR_DEPT_INDEX` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUTHOR_USER_INDEX` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `CREATED` datetime(0) NULL DEFAULT NULL,
                                              `FORMID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `SUBFORMIDS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `INITIATOR` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ISTMP` bit(1) NULL DEFAULT NULL,
                                              `VERSIONS` int(11) NULL DEFAULT NULL,
                                              `APPLICATIONID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `STATEINT` int(11) NULL DEFAULT NULL,
                                              `STATELABEL` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUDITORNAMES` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `LASTFLOWOPERATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `LASTMODIFIER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `DOMAINID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `AUDITORLIST` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `COAUDITORLIST` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `STATELABELINFO` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `PREVAUDITNODE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `PREVAUDITUSER` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `OPTIONITEM` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `SIGN` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `KINGGRIDSIGNATURE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_AUDITSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_TLKFORMNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_REGION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OFFICEPOLICEADDRESS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OFFICEPOLICEADDRESSID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OFFICEPOLICEIDINDEX` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_COMPANYNAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_LEGAL_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_LEGAL_CARD_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_AGENT_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_AGENT_CARD_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_AGENT_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_MANAGER_WAY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_MANAGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_MANAGER_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_MANAGER_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_MANAGER_JOB` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_SEX` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_AGE` decimal(22, 10) NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_NATIVE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_NATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_JOB` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_ADDRESS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_CERNO` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_VITAE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_OLD_VMANAGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_VMANAGER_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_VMANAGER_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_VMANAGER_JOB` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_SEX` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_AGE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_NATIVE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_NATION` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_JOB` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_NUM` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_ADDRESS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_CERNO` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_VITAE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_CLAIM_WAY` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_RECIPIENT` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_RECIPIENT_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_RECIPIENT_ADDRESS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_CLAIM_WAY2` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_CONSIGNEE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_CONSIGNEE_PHONE` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_CONSIGNEE_ADDRESS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_ACCEPTANCE_FILE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_NOTICE_FILE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_REJECTREASON` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_DOMAIN_ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ID` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                                              `ITEM_CODE_NUMBER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_ACCEPTANCE_TIME` datetime(0) NULL DEFAULT NULL,
                                              `ITEM_OVER_TIME` datetime(0) NULL DEFAULT NULL,
                                              `ITEM_S_CODE_NUMBER` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_old_manager_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_manager_veteran` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_manager_education` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_manager_department_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_manager_department_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_manager_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_old_vmanager_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_vmanager_veteran` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_vmanager_education` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_vmanager_department_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_vmanager_department_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_new_vmanager_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_LEGAL_BGSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_AGENT_BGSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_MANAGER_BGSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_MANAGER_BGSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_OLD_VMANAGER_BGSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_NEW_VMANAGER_BGSTATUS` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
                                              `ITEM_LASTFIE` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
                                              `ITEM_Approval_End_Time` datetime(0) NULL DEFAULT NULL,
                                              PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
alter table tlk_LegalChangeK add item_notice_file varchar(500);
alter table tlk_LegalChangeK add item_security_z_file varchar(500);
alter table tlk_LegalChangeK add item_security_time TIMESTAMP;
alter table tlk_LegalChangeK add item_security_f_file varchar(500);


