update-a2billing-v1.2.2-to-v1.2.3-mysql.sql

asterisk用 的voip记费软件

--
-- A2Billing database - update database schema - v1.2.2 to update to v1.2.3
--

/* 

To create the database : 

mysql -u root -p"root password" < UPDATE-a2billing-v1.2.2-to-v1.2.3-mysql.sql

*/


 
-- inital balance : it would be used by the cron in order to refill automatically each month
ALTER TABLE cc_card ADD COLUMN initialbalance decimal(15,5);
ALTER TABLE cc_card ALTER COLUMN initialbalance SET DEFAULT 0;
UPDATE cc_card SET initialbalance = '0';

-- invoiceday : day of the month when the customer invoice need to be created 
ALTER TABLE cc_card ADD COLUMN invoiceday INT;
ALTER TABLE cc_card ALTER COLUMN invoiceday SET DEFAULT 1;
UPDATE cc_card SET invoiceday = '1';

-- autorefill : define if the automatic refill will be permorfed on this card
ALTER TABLE cc_card ADD COLUMN autorefill INT;
ALTER TABLE cc_card ALTER COLUMN autorefill SET DEFAULT 0;
UPDATE cc_card SET autorefill = '0';


-- Auto Refill Report Table	
CREATE TABLE cc_autorefill_report (
	id 							BIGINT NOT NULL AUTO_INCREMENT,    
	daterun 					TIMESTAMP DEFAULT 'now()' NOT NULL,
	totalcardperform 			INT,
	totalcredit 				DECIMAL(15,5),
	PRIMARY KEY (id)
);


-- Add Buying cost into the reporting
ALTER TABLE cc_call ADD COLUMN buyrate decimal(15,5);
ALTER TABLE cc_call ALTER COLUMN buyrate SET DEFAULT 0;

ALTER TABLE cc_call ADD COLUMN buycost decimal(15,5);
ALTER TABLE cc_call ALTER COLUMN buycost SET DEFAULT 0;





ALTER TABLE cc_card ADD COLUMN loginkey CHAR(40);
ALTER TABLE cc_card ADD COLUMN activatedbyuser char(1) DEFAULT 'f' NOT NULL;

INSERT INTO cc_templatemail VALUES ('forgetpassword', '[e-mail]', 'Call-Labs', 'Login Information', 'Your login information is as below:

Your account is $card_gen

Your password is $password

Your cardalias is $cardalias

http://call-labs.com/A2BCustomer_UI/


Kind regards,
Call Labs
', '');

INSERT INTO cc_templatemail VALUES ('signupconfirmed', '[e-mail]', 'Call-Labs', 'SIGNUP CONFIRMATION', 'Thank you for registering with us

Please make sure you active your account by making payment to us either by
credit card, wire transfer, money order, cheque, and western union money
transfer, money Gram, and Pay pal.

Your account is $card_gen

Your password is $password

To go to your account :
http://call-labs.com/A2BCustomer_UI/

Kind regards,
Call Labs
', '');