Thats what i was thinking too...i dono whether it can be done at opensips.cfg file level or code level ?<br><br><div class="gmail_quote">On Mon, Aug 2, 2010 at 2:38 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Premalatha,<br>
<br>
What about using DB triggers on DELETE event (on location table) to<br>
delete the record in your table also ?<br>
<br>
Regards,<br>
Bogdan<br>
<div><div></div><div class="h5"><br>
Premalatha Kuppan wrote:<br>
> Hi Bogdan,<br>
><br>
> I have a question on location table.<br>
><br>
> I have added a table to OPENSIPS DB. This table entry should get<br>
> deleted when the corresponding entries in location table is deleted.<br>
><br>
> say for example: user xxxx is registerd and its info is stored in<br>
> location table. When it crashes, entries gets deleted from location<br>
> table, when this entry isn't found i have to delete that<br>
> corresponding entry from my created table.<br>
><br>
> How to do this ?<br>
><br>
> Thanks,<br>
> Premalatha<br>
</div></div>> ------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
<br>
--<br>
Bogdan-Andrei Iancu<br>
OpenSIPS Bootcamp<br>
20 - 24 September 2010, Frankfurt, Germany<br>
<a href="http://www.voice-system.ro" target="_blank">www.voice-system.ro</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br>