update-a2billing-v1.0.6-to-v1.0.8-mysql.sql

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);