Re: sqlbill <- add a new field

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

What I want is something like the following.
add another column in the voipcall table called tariffID.

then, after the call details have been inserted there,
select  grpid from voiptariffsel  where accountid = voipcall.accountid, and insert that gripid in the tariffID at the end of the table.

Not a big thing.. just want to get the grpid from the voiptariffsel table and insert it there.
Since I am keeping my grpid's unique, it is fine even when the details are deleted.

Cheers,
Shashi





On 10/18/05, Zygmuntowicz Michal <m.zygmuntowicz@xxxxxxx> wrote:
That's not the best idea, because a CDR should
not depend on external tables. Think what will
happen if you delete this tariff or an other tariff
will replace this one. Tariffs are dynamic and change
rapidly, while CDRs, once created, should not change.

----- Original Message -----
From: "Shashi Dahal" <shashi0@xxxxxxxxx>
Sent: Tuesday, October 18, 2005 12:06 PM


I configured gnugk+freeradius+sqlbill/postgresql and it works very good.
I was wondering if anyone has changed it to include tariffID in the voipcall
table too.
If not, any ideas to the right direction would be highly appretiated.

Cheers,
Shashi



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/


[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux