java-insagent-pc/sql/Online.sql

# 2024-05-15 wks
alter table ins_area_company
    add jq_claims tinyint null comment '交强出险次数', ALGORITHM=INSTANT;

alter table ins_area_company
    add sy_claims tinyint null comment '商业出险次数', ALGORITHM=INSTANT;

# 2024-05-16 hy
DROP TABLE IF EXISTS `sys_user_is_dial`;
CREATE TABLE `sys_user_is_dial`  (
                                     `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
                                     `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
                                     `is_dial` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否有拨打电话权限',
                                     `dial_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拨号权限账号',
                                     `dial_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拨号权限密码',
                                     `create_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建用户',
                                     `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
                                     PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;