From Little Anoa, 6 Years ago, written in Plain Text.
- view diff
Embed
  1. DELETE FROM v_dialplan_details
  2. WHERE dialplan_uuid IN
  3.         (SELECT dialplan_uuid FROM v_dialplans
  4.      WHERE dialplan_name = 'user_exists'
  5.         OR dialplan_name = 'user_record'
  6.                 OR dialplan_name = 'call_forward_all'
  7.                 OR dialplan_name = 'local_extension'
  8.         )
  9.        
  10. DELETE FROM v_dialplans
  11. WHERE  dialplan_name = 'user_exists'
  12.         OR dialplan_name = 'user_record'
  13.         OR dialplan_name = 'call_forward_all'
  14.         OR dialplan_name = 'local_extension'