Changeset 873

Show
Ignore:
Timestamp:
07/09/08 14:44:29 (3 months ago)
Author:
rach
Message:

DB modification to add grace to the rates

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

    r870 r873  
    10011001INSERT INTO cc_config ( id , config_title , config_key , config_value , config_description , config_valuetype , config_group_id , config_listvalues ) VALUES ( NULL , 'Max Time For Unlimited Calls', 'maxtime_tounlimited_calls', '5400', 'For unlimited calls, limit the duration: amount in seconds .', '0', '11', NULL), (NULL , 'Max Time For Free Calls', 'maxtime_tofree_calls', '5400', 'For free calls, limit the duration: amount in seconds .', '0', '11', NULL); 
    10021002 
    1003  
     1003 ALTER TABLE cc_ratecard DROP freetimetocall_package_offer   
     1004-- add additionnal grace to the ratecard 
     1005 
     1006ALTER TABLE cc_ratecard ADD additional_grace INT NOT NULL DEFAULT '0'; 

  • trunk/DataBase/psql/UPDATE-a2billing-v1.3.0-to-v1.4.0-pgsql.sql

    r869 r873  
    997997 ( 'Max Time For Free Calls', 'maxtime_tofree_calls', '5400', 'For free calls, limit the duration: amount in seconds .', '0', '11', NULL); 
    998998 
    999  
    1000  
     999 ALTER TABLE cc_ratecard DROP freetimetocall_package_offer   
     1000-- add additionnal grace to the ratecard 
     1001 
     1002ALTER TABLE cc_ratecard ADD additional_grace integer NOT NULL DEFAULT 0; 
     1003 


Google