**MySQL View to simplify Kamailio LCR Tables
**

create view openser.nt_dialplan As SELECT t.rule_id,r.lcr_id,prefix,from_uri,stopper,enabled,gw_id,priority,weight FROM lcr_rule r, lcr_rule_target t WHERE r.id = t.rule_id