Home Explore Help
Register Sign In
client_service
/
voice-gateway-service
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
voice-gateway-s...
/
sql
/
libra_bot_c_phone.sql

libra_bot_c_phone.sql 4.0 KB
Permalink History Raw

1234567891011121314151617181920212223242526272829 
  1. create table c_phone
    2. 

  2. (
    3. 

  3.     id          bigint unsigned auto_increment
    4. 

  4.         primary key,
    5. 

  5.     saas_id     varchar(16) default ''                not null,
    6. 

  6.     phone_num   varchar(32) default '0'               not null,
    7. 

  7.     phone_pwd   varchar(32) default ''                not null,
    8. 

  8.     sip_server  varchar(64) default ''                not null,
    9. 

  9.     wss_server  varchar(64) default ''                not null,
    10. 

  10.     ice_server  varchar(64) default ''                not null,
    11. 

  11.     is_delete   tinyint     default 0                 not null,
    12. 

  12.     update_time timestamp   default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP,
    13. 

  13.     create_time timestamp   default CURRENT_TIMESTAMP not null
    14. 

  14. )
    15. 

  15.     comment '分机信息表';
    16. 

  16. 

  17. create index idx_vcc_id_phone_num
    18. 

  18.     on c_phone (saas_id, phone_num);
    19. 

  19. 

  20. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    21. 

  21. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    22. 

  22. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    23. 

  23. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    24. 

  24. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    25. 

  25. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    26. 

  26. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    27. 

  27. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    28. 

  28. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    29. 

  29. 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@pbx.fuxicarbon.com:5060', 'wss://pbx.fuxicarbon.com:7443', 'stun:pbx.fuxicarbon.com:3478', 1, '2024-10-08 16:43:56', '2024-10-08 16:43:56');
    30.