-- 互联网脚本
ALTER TABLE `obpm2`.`tenant_invited_to_join_queues`
ADD COLUMN `front_photo` varchar(255) NULL COMMENT '身份证人像面' AFTER `last_operator_time`,
ADD COLUMN `reverse_photo` varchar(255) NULL COMMENT '身份证国徽面' AFTER `front_photo`,
ADD COLUMN `head_photo` varchar(255) NULL COMMENT '身份证人头像' AFTER `reverse_photo`,
ADD COLUMN `valid_date_from` datetime NULL COMMENT '有效期从' AFTER `head_photo`,
ADD COLUMN `valid_date_to` datetime NULL COMMENT '有效期到' AFTER `valid_date_from`,
ADD COLUMN `address` varchar(500) NULL COMMENT '地址' AFTER `valid_date_to`,
ADD COLUMN `certificate_image` varchar(255) NULL COMMENT '活体采集照片' AFTER `address`;


-- 政务网 以及 内网 脚本
ALTER TABLE `obpm2_security`.`tenant_invited_to_join_queues`
ADD COLUMN `front_photo` varchar(255) NULL COMMENT '身份证人像面' AFTER `last_operator_time`,
ADD COLUMN `reverse_photo` varchar(255) NULL COMMENT '身份证国徽面' AFTER `front_photo`,
ADD COLUMN `head_photo` varchar(255) NULL COMMENT '身份证人头像' AFTER `reverse_photo`,
ADD COLUMN `valid_date_from` datetime NULL COMMENT '有效期从' AFTER `head_photo`,
ADD COLUMN `valid_date_to` datetime NULL COMMENT '有效期到' AFTER `valid_date_from`,
ADD COLUMN `address` varchar(500) NULL COMMENT '地址' AFTER `valid_date_to`,
ADD COLUMN `certificate_image` varchar(255) NULL COMMENT '活体采集照片' AFTER `address`;