Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Fri Mar 29, 2024 11:34 am
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Correction in SQL file:- UPDATE-a2billing-v1.0.2-to-v1.0.6
PostPosted: Tue Mar 28, 2006 10:15 pm 
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.


Top
  
 
 Post subject:
PostPosted: Tue Mar 28, 2006 10:23 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Good look ;-)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group