API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 22nd, 2017
526
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.13 KB | None | 0 0
raw download clone embed print report
  1. mysql> select origem, destino, action, rnac.prio, `key`, value from regras_negocio as rn, regras_negocio_actions as rna, regras_negocio_actions_config as rnac where (rna.regra_id = rn.id && rnac.regra_id = rn.id) order by rn.id, rnac.prio;
  2. +--------+-----------------+------------------------------+------+-----------------+-------------------------+
  3. | origem | destino | action | prio | key | value |
  4. +--------+-----------------+------------------------------+------+-----------------+-------------------------+
  5. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 0 | cut | nocut |
  6. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 0 | prefix | 055 |
  7. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 0 | type | dst |
  8. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 0 | cut | nocut |
  9. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 0 | prefix | 055 |
  10. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 0 | type | dst |
  11. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | cut | nocut |
  12. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | prefix | 055 |
  13. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | type | dst |
  14. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 1 | ccustos | 2 |
  15. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 1 | ccustos | 2 |
  16. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | ccustos | 2 |
  17. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 2 | alertEmail | willian@syssvoip.com.br |
  18. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 2 | dial_flags | TWK |
  19. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 2 | dial_limit | |
  20. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 2 | dial_timeout | |
  21. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 2 | omit_kgsm | 0 |
  22. | X | RX:3XXXXXXX | PBX_Rule_Action_Rewrite | 2 | tronco | 1 |
  23. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 2 | alertEmail | willian@syssvoip.com.br |
  24. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 2 | dial_flags | TWK |
  25. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 2 | dial_limit | |
  26. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 2 | dial_timeout | |
  27. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 2 | omit_kgsm | 0 |
  28. | X | RX:3XXXXXXX | PBX_Rule_Action_CCustos | 2 | tronco | 1 |
  29. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | alertEmail | willian@syssvoip.com.br |
  30. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | dial_flags | TWK |
  31. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | dial_limit | |
  32. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | dial_timeout | |
  33. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | omit_kgsm | 0 |
  34. | X | RX:3XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | tronco | 1 |
  35. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 0 | cut | nocut |
  36. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 0 | prefix | 055 |
  37. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 0 | type | dst |
  38. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 0 | cut | nocut |
  39. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 0 | prefix | 055 |
  40. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 0 | type | dst |
  41. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | cut | nocut |
  42. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | prefix | 055 |
  43. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | type | dst |
  44. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 1 | ccustos | 2 |
  45. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 1 | ccustos | 2 |
  46. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | ccustos | 2 |
  47. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 2 | alertEmail | willian@syssvoip.com.br |
  48. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 2 | dial_flags | TWK |
  49. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 2 | dial_limit | |
  50. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 2 | dial_timeout | |
  51. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 2 | omit_kgsm | 0 |
  52. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_Rewrite | 2 | tronco | 1 |
  53. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 2 | alertEmail | willian@syssvoip.com.br |
  54. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 2 | dial_flags | TWK |
  55. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 2 | dial_limit | |
  56. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 2 | dial_timeout | |
  57. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 2 | omit_kgsm | 0 |
  58. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_CCustos | 2 | tronco | 1 |
  59. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | alertEmail | willian@syssvoip.com.br |
  60. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | dial_flags | TWK |
  61. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | dial_limit | |
  62. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | dial_timeout | |
  63. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | omit_kgsm | 0 |
  64. | X | RX:[7-9]XXXXXXX | PBX_Rule_Action_DiscarTronco | 2 | tronco | 1 |
  65. | X | RX:XXXX | PBX_Rule_Action_CCustos | 0 | ccustos | 2 |
  66. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 0 | ccustos | 2 |
  67. | X | RX:XXXX | PBX_Rule_Action_CCustos | 1 | alertEmail | willian@syssvoip.com.br |
  68. | X | RX:XXXX | PBX_Rule_Action_CCustos | 1 | dial_flags | TWK |
  69. | X | RX:XXXX | PBX_Rule_Action_CCustos | 1 | dial_limit | |
  70. | X | RX:XXXX | PBX_Rule_Action_CCustos | 1 | dial_timeout | |
  71. | X | RX:XXXX | PBX_Rule_Action_CCustos | 1 | omit_kgsm | 0 |
  72. | X | RX:XXXX | PBX_Rule_Action_CCustos | 1 | tronco | 1 |
  73. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 1 | alertEmail | willian@syssvoip.com.br |
  74. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 1 | dial_flags | TWK |
  75. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 1 | dial_limit | |
  76. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 1 | dial_timeout | |
  77. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 1 | omit_kgsm | 0 |
  78. | X | RX:XXXX | PBX_Rule_Action_DiscarTronco | 1 | tronco | 1 |
  79. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 0 | ccustos | 2 |
  80. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 0 | ccustos | 2 |
  81. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 1 | alertEmail | willian@syssvoip.com.br |
  82. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 1 | dial_flags | TWK |
  83. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 1 | dial_limit | |
  84. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 1 | dial_timeout | |
  85. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 1 | omit_kgsm | 0 |
  86. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_CCustos | 1 | tronco | 1 |
  87. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | alertEmail | willian@syssvoip.com.br |
  88. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | dial_flags | TWK |
  89. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | dial_limit | |
  90. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | dial_timeout | |
  91. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | omit_kgsm | 0 |
  92. | X | RX:0XXXXXXXXXX | PBX_Rule_Action_DiscarTronco | 1 | tronco | 1 |
  93. | X | X | PBX_Rule_Action_CCustos | 0 | ccustos | 1 |
  94. | X | X | PBX_Rule_Action_DiscarRamal | 0 | ccustos | 1 |
  95. | X | X | PBX_Rule_Action_CCustos | 1 | allow_voicemail | false |
  96. | X | X | PBX_Rule_Action_CCustos | 1 | dial_flags | twk |
  97. | X | X | PBX_Rule_Action_CCustos | 1 | dial_timeout | 60 |
  98. | X | X | PBX_Rule_Action_CCustos | 1 | diff_ring | false |
  99. | X | X | PBX_Rule_Action_CCustos | 1 | dont_overflow | false |
  100. | X | X | PBX_Rule_Action_CCustos | 1 | ramal | Object |
  101. | X | X | PBX_Rule_Action_DiscarRamal | 1 | allow_voicemail | false |
  102. | X | X | PBX_Rule_Action_DiscarRamal | 1 | dial_flags | twk |
  103. | X | X | PBX_Rule_Action_DiscarRamal | 1 | dial_timeout | 60 |
  104. | X | X | PBX_Rule_Action_DiscarRamal | 1 | diff_ring | false |
  105. | X | X | PBX_Rule_Action_DiscarRamal | 1 | dont_overflow | false |
  106. | X | X | PBX_Rule_Action_DiscarRamal | 1 | ramal | Object |
  107. | T:1 | X | PBX_Rule_Action_CCustos | 0 | ccustos | 1 |
  108. | T:1 | X | PBX_Rule_Action_DiscarRamal | 0 | ccustos | 1 |
  109. | T:1 | X | PBX_Rule_Action_CCustos | 0 | ccustos | 1 |
  110. | T:1 | X | PBX_Rule_Action_DiscarRamal | 0 | ccustos | 1 |
  111. | T:1 | X | PBX_Rule_Action_CCustos | 1 | allow_voicemail | false |
  112. | T:1 | X | PBX_Rule_Action_CCustos | 1 | dial_flags | twk |
  113. | T:1 | X | PBX_Rule_Action_CCustos | 1 | dial_timeout | 60 |
  114. | T:1 | X | PBX_Rule_Action_CCustos | 1 | diff_ring | false |
  115. | T:1 | X | PBX_Rule_Action_CCustos | 1 | dont_overflow | false |
  116. | T:1 | X | PBX_Rule_Action_CCustos | 1 | ramal | Object |
  117. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | allow_voicemail | false |
  118. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | dial_flags | twk |
  119. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | dial_timeout | 60 |
  120. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | diff_ring | false |
  121. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | dont_overflow | false |
  122. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | ramal | Object |
  123. | T:1 | X | PBX_Rule_Action_CCustos | 1 | allow_voicemail | false |
  124. | T:1 | X | PBX_Rule_Action_CCustos | 1 | dial_flags | twk |
  125. | T:1 | X | PBX_Rule_Action_CCustos | 1 | dial_timeout | 60 |
  126. | T:1 | X | PBX_Rule_Action_CCustos | 1 | diff_ring | false |
  127. | T:1 | X | PBX_Rule_Action_CCustos | 1 | dont_overflow | false |
  128. | T:1 | X | PBX_Rule_Action_CCustos | 1 | ramal | Object |
  129. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | allow_voicemail | false |
  130. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | dial_flags | twk |
  131. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | dial_timeout | 60 |
  132. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | diff_ring | false |
  133. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | dont_overflow | false |
  134. | T:1 | X | PBX_Rule_Action_DiscarRamal | 1 | ramal | Object |
  135. | T:1 | X | PBX_Rule_Action_CCustos | 2 | ccustos | 1 |
  136. | T:1 | X | PBX_Rule_Action_DiscarRamal | 2 | ccustos | 1 |
  137. | T:1 | X | PBX_Rule_Action_CCustos | 2 | ccustos | 1 |
  138. | T:1 | X | PBX_Rule_Action_DiscarRamal | 2 | ccustos | 1 |
  139. | T:1 | X | PBX_Rule_Action_CCustos | 3 | allow_voicemail | false |
  140. | T:1 | X | PBX_Rule_Action_CCustos | 3 | dial_flags | twk |
  141. | T:1 | X | PBX_Rule_Action_CCustos | 3 | dial_timeout | 60 |
  142. | T:1 | X | PBX_Rule_Action_CCustos | 3 | diff_ring | false |
  143. | T:1 | X | PBX_Rule_Action_CCustos | 3 | dont_overflow | false |
  144. | T:1 | X | PBX_Rule_Action_CCustos | 3 | ramal | Object |
  145. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | allow_voicemail | false |
  146. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | dial_flags | twk |
  147. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | dial_timeout | 60 |
  148. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | diff_ring | false |
  149. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | dont_overflow | false |
  150. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | ramal | Object |
  151. | T:1 | X | PBX_Rule_Action_CCustos | 3 | allow_voicemail | false |
  152. | T:1 | X | PBX_Rule_Action_CCustos | 3 | dial_flags | twk |
  153. | T:1 | X | PBX_Rule_Action_CCustos | 3 | dial_timeout | 60 |
  154. | T:1 | X | PBX_Rule_Action_CCustos | 3 | diff_ring | false |
  155. | T:1 | X | PBX_Rule_Action_CCustos | 3 | dont_overflow | false |
  156. | T:1 | X | PBX_Rule_Action_CCustos | 3 | ramal | Object |
  157. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | allow_voicemail | false |
  158. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | dial_flags | twk |
  159. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | dial_timeout | 60 |
  160. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | diff_ring | false |
  161. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | dont_overflow | false |
  162. | T:1 | X | PBX_Rule_Action_DiscarRamal | 3 | ramal | Object |
  163. +--------+-----------------+------------------------------+------+-----------------+-------------------------+
  164. 158 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!