since most of the tables in sofia are per runtime we just erase it and recreate it. so if you change the def in sofia_glue look for the code later in the file that tries to do a validation sql stmt followed by a reaction which will re-create it. see 5502 for instance for sip_dialogs. also beware I am messing with this code again today so you should beware of merge conflicts. On Tue, Oct 19, 2010 at 11:23 AM, Beeton, Carolyn (Carolyn) <cbeeton@avaya.com> wrote:
Thank you! That is good advice. I will proceed in baby steps as you suggest, with the next step adding the to and from tags into the sip_dialogs database.
One question about that: adding new columns to an existing database requires upgrade code. Is there an example I can follow on how to do this, or is this database created from scratch on a freeswitch update?
Carolyn
-----Original Message----- From: freeswitch-dev-bounces@lists.freeswitch.org [mailto:freeswitch-dev-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale Sent: Monday, October 18, 2010 4:39 PM To: freeswitch-dev@lists.freeswitch.org Subject: Re: [Freeswitch-dev] Dialog events: full vs partial
I recommend getting latest where you should be closer to what you want apart from the extra columns in the db then trying to get the new cols in separately then work it into the select and into the dialog info xml in incremental steps/patches.
_______________________________________________ FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900