Ticket #3954: canreinvite-sql.txt

File canreinvite-sql.txt, 312 bytes (added by john@erba.tv, 3 years ago)

sql to change canreinvite keyword to directmedia and delete canreinvite if both are present

Line 
1 create table temp_delete as select s1.id from sip s1, sip s2 where s1.id=s2.id and s1.keyword='canreinvite' and s2.keyword='directmedia';
2 delete from sip where keyword='canreinvite' and id in (select id from temp_delete);
3 drop table temp_delete;
4 update sip set keyword='directmedia' where keyword='canreinvite';