There are some correction in SQL file "UPDATE-a2billing-v1.0.2-to-v1.0.6-mysql".
This correction is important, who are updating sql files in MySql and trying to test over DID numbers, otherwise you can just ignore.
The present code [wrong code] in file:-
CREATE TABLE cc_did_destination (
id BIGINT NOT NULL AUTO_INCREMENT,
phonenumber CHAR(50) NOT NULL,
priority INT DEFAULT 0 NOT NULL,
id_cc_card BIGINT NOT NULL,
id_cc_did BIGINT NOT NULL,
destination TIMESTAMP DEFAULT 'now()' NOT NULL,
activated INT DEFAULT 1 NOT NULL,
secondusedreal INT DEFAULT 0,
id_trunk INT DEFAULT 0,
PRIMARY KEY (id)
);
The right code should be:-
CREATE TABLE cc_did_destination (
id BIGINT NOT NULL AUTO_INCREMENT,
destination CHAR(50) NOT NULL,
priority INT DEFAULT 0 NOT NULL,
id_cc_card BIGINT NOT NULL,
id_cc_did BIGINT NOT NULL,
creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,
activated INT DEFAULT 1 NOT NULL,
secondusedreal INT DEFAULT 0,
voip_call INT DEFAULT 0,
PRIMARY KEY (id)
);
Notes:- If you are doing fresh installations in MySql, just ignore this message. Because, "a2billing-mysql-schema-MYSQL.3.X-4.X_v1.0.9" file has the correct code.
|