voice-gateway-service/sql/libra_bot_c_agent.sql

create table c_agent
(
    id            bigint unsigned auto_increment comment '主键'
        primary key,
    saas_id       varchar(16) default ''                not null comment '租户隔离',
    agent_num     varchar(32) default ''                not null comment '坐席工号',
    agent_name    varchar(32) default ''                not null comment '坐席姓名',
    out_id        varchar(32) default ''                not null comment '外部id',
    agent_pwd     varchar(64) default ''                not null comment '坐席密码',
    agent_type    tinyint     default 0                 not null comment '坐席类型 0:普通坐席 ;1:组长:2:主管',
    phone_num     varchar(32) default '0'               not null comment '分机号',
    distribute    tinyint     default 1                 not null comment '分配标志  0:不参与排队；1:参与排队',
    agent_state   tinyint     default 0                 not null comment '账号状态 0:可用;1:禁用',
    identity_type tinyint     default 0                 not null comment '身份标识',
    is_delete     tinyint     default 0                 not null comment '删除标识',
    update_time   timestamp   default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
    create_time   timestamp   default CURRENT_TIMESTAMP not null comment '创建时间',
    constraint uniq_vcc_id_agent_num
        unique (saas_id, agent_num)
)
    comment '坐席信息表';

create index idx_vcc_id_out_id
    on c_agent (saas_id, out_id);

create index idx_vcc_id_phone_num
    on c_agent (saas_id, phone_num);

INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (1, 'mdj', '1000', 'user0', '1000', '123456', 0, '1000', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:46:31');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (3, 'mdj', '1001', 'user1', '1001', '123456', 0, '1001', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (4, 'mdj', '1002', 'user2', '1002', '123456', 0, '1002', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (5, 'mdj', '1003', 'user3', '1003', '123456', 0, '1003', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (6, 'mdj', '1004', 'user4', '1004', '123456', 0, '1004', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (7, 'mdj', '1005', 'user5', '1005', '123456', 0, '1005', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (8, 'mdj', '1006', 'user6', '1006', '123456', 0, '1006', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (9, 'mdj', '1007', 'user7', '1007', '123456', 0, '1007', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (10, 'mdj', '1008', 'user8', '1008', '123456', 0, '1008', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');
INSERT INTO libra_bot.c_agent (id, saas_id, agent_num, agent_name, out_id, agent_pwd, agent_type, phone_num, distribute, agent_state, identity_type, is_delete, update_time, create_time) VALUES (11, 'mdj', '1009', 'user9', '1009', '123456', 0, '1009', 1, 0, 0, 0, '2024-10-08 16:50:08', '2024-10-08 16:49:10');