update `user` set rawid=id,inrawid=id;
update `task` set rawid=id,inrawid=id;
update `task_feedback` set rawid=id,inrawid=id;
update `security_company` set rawid=id,inrawid=id;
update `security_company` set exported =TRUE;
update `sys_approval` set rawid=id,inrawid=id;

update user_role set roletype='2' where roletype is null;
##不同环境的值不一样
#update config set `value`='http://www.baibaodun.cn/' where `key`='web_host';

ALTER TABLE `sb_crosscompany`
MODIFY COLUMN `Legalnationality`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人国籍' AFTER `Legalphone`;

ALTER TABLE `sb_confesscompany`
MODIFY COLUMN `Legalnationality`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人国籍' AFTER `Legalphone`;

ALTER TABLE `sb_legalchange`
MODIFY COLUMN `ndlegalnationality`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拟定法人国籍' AFTER `ndlegalcardnum`;

ALTER TABLE `sb_subsidiary`
MODIFY COLUMN `Legalnationality`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人国籍' AFTER `Legalphone`;

ALTER TABLE `security_person`
MODIFY COLUMN `nationality`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `marriage`;

ALTER TABLE `sb_personcertificate`
MODIFY COLUMN `nationality`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '国籍' AFTER `religion`;