ALTER TABLE `sb_management_info`
ADD COLUMN `sex`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别' AFTER `name`,
ADD COLUMN `manage_nation`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族' AFTER `sex`,
ADD COLUMN `abroadaddress`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '户籍地址' AFTER `manage_nation`,
ADD COLUMN `address`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现居住地地址' AFTER `abroadaddress`;



CREATE TABLE `security_confesscompany` (
`id`  int NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`active`  bit(1) NULL DEFAULT NULL COMMENT '是否可用' ,
`user_id`  int(11) NULL DEFAULT NULL COMMENT '用户ID' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '修改时间' ,
`update_by`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' ,
`pxdwbm`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '培训单位编码' ,
`pxdwmc`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '培训单位名称' ,
`zcssx`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册地省市县（区）' ,
`zcdz`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册地址' ,
`lxrxm`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主要负责人姓名' ,
`lxdh`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主要负责人联系电话' ,
`xzsfzh`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校长（院长）公民身份号码' ,
`xzxm`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校长（院长）姓名' ,
`xzdh`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校长（院长）联系电话' ,
`zczj`  decimal(10,2) NULL DEFAULT NULL COMMENT '注册资金' ,
`pxxkz`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安培训许可证编码' ,
`fzjgbm`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安培训许可证发证机关编码' ,
`fajgmc`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安培训许可证发证机关名称' ,
`xkzbfrq`  datetime NULL DEFAULT NULL COMMENT '保安培训许可证颁发日期' ,
`xkzdxjg`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安培训许可证吊销机关' ,
`xkzdxrq`  datetime NULL DEFAULT NULL COMMENT '保安培训许可证吊销日期' ,
`xkzdxyy`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安培训许可证吊销原因' ,
`pxdwlb`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保安培训单位类别' ,
`bz1`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注1' ,
`bz2`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2' ,
`bz3`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注3' ,
PRIMARY KEY (`id`),
INDEX `security_confesscompany_key` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;
