asterisk 計費模塊

				--				-- A2Billing database - update database schema - v1.0.6 to update to v1.0.8				--								/* 				To create the database : 								mysql -u root -p"root password" < UPDATE-a2billing-v1.0.6-to-v1.0.8-mysql.sql								*/								 				--				--	MYSQL 5.x - MYSQL 5.x - MYSQL 5.x - MYSQL 5.x - MYSQL 5.x				--				--				-- Predictive Dialer update  database - Create database schema				--																CREATE TABLE cc_campaign (				    id INT NOT NULL AUTO_INCREMENT,    				    campaign_name CHAR(50) NOT NULL,				    creationdate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,				    startingdate TIMESTAMP, 				    expirationdate TIMESTAMP,				    description MEDIUMTEXT,				    id_trunk INT DEFAULT 0,				    secondusedreal INT DEFAULT 0,				    nb_callmade INT DEFAULT 0,				    enable INT DEFAULT 0 NOT NULL,					    PRIMARY KEY (id),				    UNIQUE cons_phonelistname (campaign_name)				);												CREATE TABLE cc_phonelist (				    id INT NOT NULL AUTO_INCREMENT,				    id_cc_campaign INT DEFAULT 0 NOT NULL,				    numbertodial CHAR(50) NOT NULL,				    name CHAR(60) NOT NULL,				    inuse INT DEFAULT 0,				    enable INT DEFAULT 1 NOT NULL,    				    num_trials_done INT DEFAULT 0,				    creationdate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,					    last_attempt TIMESTAMP,				    secondusedreal INT DEFAULT 0,				    additionalinfo MEDIUMTEXT,				    PRIMARY KEY (id)				);				CREATE INDEX ind_cc_phonelist_numbertodial ON cc_phonelist (numbertodial);												ALTER TABLE cc_card ADD COLUMN id_campaign INT;				ALTER TABLE cc_card ADD COLUMN num_trials_done BIGINT;				ALTER TABLE cc_card ALTER COLUMN num_trials_done SET DEFAULT 0;				UPDATE cc_card SET num_trials_done = '0';				ALTER TABLE cc_card ADD COLUMN callback CHAR(50);