Home Explore Help
Sign In
Kamailio
/
kamailio
mirror of https://github.com/kamailio/kamailio.git
2
0
Fork 0
Files Issues 0 Wiki
Branch: master
Branches Tags
kamailio
/
utils
/
kamctl
/
oracle
/
ims_usrloc_pcscf-create.sql

ims_usrloc_pcscf-create.sql 2.1 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 
  1. CREATE TABLE pcscf_location (
    2. 

  2.     id NUMBER(10) PRIMARY KEY,
    3. 

  3.     domain VARCHAR2(64),
    4. 

  4.     aor VARCHAR2(255),
    5. 

  5.     host VARCHAR2(100),
    6. 

  6.     port NUMBER(10),
    7. 

  7.     received VARCHAR2(128) DEFAULT NULL,
    8. 

  8.     received_port NUMBER(10) DEFAULT NULL,
    9. 

  9.     received_proto NUMBER(10) DEFAULT NULL,
    10. 

  10.     path VARCHAR2(512) DEFAULT NULL,
    11. 

  11.     rinstance VARCHAR2(255) DEFAULT NULL,
    12. 

  12.     rx_session_id VARCHAR2(256) DEFAULT NULL,
    13. 

  13.     reg_state NUMBER(5) DEFAULT NULL,
    14. 

  14.     expires DATE DEFAULT to_date('2030-05-28 21:32:15','yyyy-mm-dd hh24:mi:ss'),
    15. 

  15.     service_routes VARCHAR2(2048) DEFAULT NULL,
    16. 

  16.     socket VARCHAR2(64) DEFAULT NULL,
    17. 

  17.     public_ids VARCHAR2(2048) DEFAULT NULL,
    18. 

  18.     security_type NUMBER(10) DEFAULT NULL,
    19. 

  19.     protocol VARCHAR2(5) DEFAULT NULL,
    20. 

  20.     mode VARCHAR2(10) DEFAULT NULL,
    21. 

  21.     ck VARCHAR2(100) DEFAULT NULL,
    22. 

  22.     ik VARCHAR2(100) DEFAULT NULL,
    23. 

  23.     ealg VARCHAR2(20) DEFAULT NULL,
    24. 

  24.     ialg VARCHAR2(20) DEFAULT NULL,
    25. 

  25.     port_pc NUMBER(10) DEFAULT NULL,
    26. 

  26.     port_ps NUMBER(10) DEFAULT NULL,
    27. 

  27.     port_uc NUMBER(10) DEFAULT NULL,
    28. 

  28.     port_us NUMBER(10) DEFAULT NULL,
    29. 

  29.     spi_pc NUMBER(10) DEFAULT NULL,
    30. 

  30.     spi_ps NUMBER(10) DEFAULT NULL,
    31. 

  31.     spi_uc NUMBER(10) DEFAULT NULL,
    32. 

  32.     spi_us NUMBER(10) DEFAULT NULL,
    33. 

  33.     t_security_type NUMBER(10) DEFAULT NULL,
    34. 

  34.     t_protocol VARCHAR2(5) DEFAULT NULL,
    35. 

  35.     t_mode VARCHAR2(10) DEFAULT NULL,
    36. 

  36.     t_ck VARCHAR2(100) DEFAULT NULL,
    37. 

  37.     t_ik VARCHAR2(100) DEFAULT NULL,
    38. 

  38.     t_ealg VARCHAR2(20) DEFAULT NULL,
    39. 

  39.     t_ialg VARCHAR2(20) DEFAULT NULL,
    40. 

  40.     t_port_pc NUMBER(10) DEFAULT NULL,
    41. 

  41.     t_port_ps NUMBER(10) DEFAULT NULL,
    42. 

  42.     t_port_uc NUMBER(10) DEFAULT NULL,
    43. 

  43.     t_port_us NUMBER(10) DEFAULT NULL,
    44. 

  44.     t_spi_pc NUMBER(10) DEFAULT NULL,
    45. 

  45.     t_spi_ps NUMBER(10) DEFAULT NULL,
    46. 

  46.     t_spi_uc NUMBER(10) DEFAULT NULL,
    47. 

  47.     t_spi_us NUMBER(10) DEFAULT NULL
    48. 

  48. );
    49. 

  49. 

  50. CREATE OR REPLACE TRIGGER pcscf_location_tr
    51. 

  51. before insert on pcscf_location FOR EACH ROW
    52. 

  52. BEGIN
    53. 

  53.   auto_id(:NEW.id);
    54. 

  54. END pcscf_location_tr;
    55. 

  55. /
    56. 

  56. BEGIN map2users('pcscf_location'); END;
    57. 

  57. /
    58. 

  58. CREATE INDEX pcscf_location_aor_idx  ON pcscf_location (aor);
    59. 

  59. 

  60. INSERT INTO version (table_name, table_version) values ('pcscf_location','7');
    61.