create table c_phone
(
    id          bigint unsigned auto_increment
        primary key,
    saas_id     varchar(16) default ''                not null,
    phone_num   varchar(32) default '0'               not null,
    phone_pwd   varchar(32) default ''                not null,
    sip_server  varchar(64) default ''                not null,
    wss_server  varchar(64) default ''                not null,
    ice_server  varchar(64) default ''                not null,
    is_delete   tinyint     default 0                 not null,
    update_time timestamp   default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    create_time timestamp   default CURRENT_TIMESTAMP not null
)
    comment '分机信息表';

create index idx_vcc_id_phone_num
    on c_phone (saas_id, phone_num);

INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (1, 'mdj', '1000', 'slibra@#123456', 'sip:1000@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (2, 'mdj', '1001', 'slibra@#123456', 'sip:1001@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (3, 'mdj', '1002', 'slibra@#123456', 'sip:1002@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (4, 'mdj', '1003', 'slibra@#123456', 'sip:1003@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (5, 'mdj', '1004', 'slibra@#123456', 'sip:1004@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (6, 'mdj', '1005', 'slibra@#123456', 'sip:1005@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (7, 'mdj', '1006', 'slibra@#123456', 'sip:1006@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (8, 'mdj', '1007', 'slibra@#123456', 'sip:1007@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (9, 'mdj', '1008', 'slibra@#123456', 'sip:1008@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
INSERT INTO libra_bot.c_phone (id, saas_id, phone_num, phone_pwd, sip_server, wss_server, ice_server, is_delete, update_time, create_time) VALUES (10, 'mdj', '1009', 'slibra@#123456', 'sip:1009@jms.sqlibra.com:5060', 'wss://jms.sqlibra.com:7443', 'stun:jms.sqlibra.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');