changelog

H.323网守实现

14 Apr 2005 -- zvision
  * unneccessary voipcall_h323id_idx index removed

07 Mar 2005 -- zvision
  * fixed syntax error in f_voiptariff.sql script

25 Jan 2005 -- zvision
  * fixed a syntax error inside match_tariff

13 Dec 2004 -- zvision
  * allow an empty value for Calling-Station-Id
  * bugs fixed in report queries, ASR calculation more accurate,
    redundant code removed

07 Dec 2004 -- zvision
  * simple report query examples to get ASR, ACD and other statistics
    added to the 'examples' directory

03 Nov 2004 -- zvision
  * check RRQ aliases against voipuser h323id and allowedaliases fields
  * updated postgresql.conf authorize_check and authorize_reply queries
    to allow validation of endpoint aliases sent in h323-ivr-out=terminal-alias
	attribute

29 Oct 2004 -- zvision
  * don't trim usernames during checks to avoid problems with the billing
  * adjust voiptariffdst indexes to not include WHERE active condition

25 Oct 2004 -- zvision
  * tariff matching extended to support more precise group tariff matching,
    ability to specify per group special destinations
  * tariff matching now processes active flag correctly for tariffs/tariff
    destinations

13 Oct 2004 -- zvision
  * new 'prefix' column in the voipcall table to store a prefix
    that the Called-Station-Id has matched

5 Oct 2004 -- zvision
  * fix to allow negative prices to be specified for callback tariffs

1 Oct 2004 -- zvision
  * fill voipcalltermtariff.tariffdesc field with correct tariff description

26 Sep 2004 -- zvision
  * associate names with table constraints to allow further easy modifications
  * changed voiptariff multikey to contain the terminating column too
  * fix an error in the c_all_tables.sql script that prevented from creation 
    of voipcalltermtariff table
  * fix an error in the d_all_tables.sql script that prevented from deleting
    all tables in the database
  
21 Sep 2004 -- zvision
  * added support for termination accounts and tariffs

15 Sep 2004 -- zvision
  * added database versioning and upgrade scripts
  * new 'exactmatch' column in voiptariffdst to allow both prefix like matching
    and exact H.323 ID like matching
  * fixed missing graceperiod handling in tariff table import from an OpenOffice
    Calc file

26 Aug 2004 -- zvision
  * scripts to dump/restore data added
  * fixed bug that prevented IP only authorization using IP address range
  * fixed bug (syntax error) with tariff matching when tariff groups are used
  
15 Aug 2004 -- zvision
  * a new column 'active' in the voiptariff table to allow per user
    blocking of destinations

12 Aug 2004 -- zvision
  * added a new 'graceperiod' column to voiptariff and voipcall

6 Aug 2004 -- zvision
  * support for tariff table import from an OpenOffice.org Calc spreadsheet 
  - new tariffs.sxc, f_pricing.sql and f_merged.sql files

5 Aug 2004 -- zvision
  * cost for calls longer than the initialincrement was incorrectly calculated
  * allow arbitraty prefix length

4 Aug 2004 -- zvision
  * allow voipcall rows with NULL tariffdesc to be inserted - this happens
    when users dial numbers not found in the tariff table

9 Jul 2004 -- zvision
  * added GnuGk config examples how to use the billing systems with SQLAcct,
    SQLPasswordAuth and SQLAuth modules instead of Radius. It does not provide
    full functionality, like with Radius, but may be enough for some people

22 Jun 2004 -- zvision
  * reject gracefully Access-Requests without Framed-IP-Address attribute
  * better handling of IP only authorization - changed user account binding 
    order - IP only users are searched first, then search by h323id is performed

17 Jun 2004 -- zvision
  * BUGFIX: accounting_update_query changed to not check h323id in order
    to allow IP only authorization
  * BUGFIX: accounting_stop_query changed to not check h323id in order
    to allow IP only authorization

16 Jun 2004 -- zvision
  * added ability to authenticate users only by their IP (ignoring User-Name)

15 Jun 2004 -- zvision
  * BUGFIX: active flag for old voiptariff aparently did not work - all tariffs
    were counted as active
  * Billing unit configurable (previously it was fixed to 60 seconds). Now it is
    possible to even to create tariffs for one-time event billing (initialincrement
    set to 60 and regular increment set 0)
  * Tariff engine redesigned - now a single tariff consists of three 
    components: destination info (prefix), the actual tariff (pricing)
	and an optional tariff group. Now is possible to set different pricing
	to each account for the same destination
  * voipuser.password column name changed to voipuser.chappassword to describe 
    the purpose of this field better
  * Currency precision increased from 2 to 4 decimal places
  
18 Feb 2004 -- zvision
  * Initial release