---- A2Billing database script - create database for MYSQL 3.X & 4.X--/* Usage: mysql -u root -p"root password" < a2billing-mysql-schema-MYSQL.3.X-4.X_v1.2.0.sql  */---- A2Billing database - Create database schema-- CREATE TABLE cc_didgroup (    id BIGINT NOT NULL AUTO_INCREMENT,    idreseller INT DEFAULT 0 NOT NULL,    didgroupname CHAR(50) NOT NULL,        creationdate  TIMESTAMP DEFAULT 'now()' NOT NULL,    PRIMARY KEY (id));CREATE TABLE cc_did (    id BIGINT NOT NULL AUTO_INCREMENT,	    id_cc_didgroup BIGINT NOT NULL,    id_cc_country INT NOT NULL,        activated INT DEFAULT '1' NOT NULL,    iduser INT DEFAULT '0' NOT NULL,    did CHAR(50) NOT NULL,    creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,    startingdate TIMESTAMP DEFAULT 'now()' NOT NULL,    expirationdate TIMESTAMP,    description MEDIUMTEXT,    secondusedreal INT DEFAULT 0,    billingtype INT DEFAULT 0,    fixrate float DEFAULT 0 NOT NULL,	    PRIMARY KEY (id),    UNIQUE cons_cc_did_did (did));-- billtype: 0 = fix per month + dialoutrate, 1= fix per month, 2 = dialoutrate, 3 = freeCREATE 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));CREATE TABLE cc_charge (    id BIGINT NOT NULL AUTO_INCREMENT,    id_cc_card BIGINT NOT NULL,	    iduser INT DEFAULT '0' NOT NULL,    creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,    amount float DEFAULT 0 NOT NULL,    chargetype INT DEFAULT 0,        description MEDIUMTEXT,    PRIMARY KEY (id)); CREATE TABLE cc_paypal (    id int(11) NOT NULL auto_increment,    payer_id varchar(60) default NULL,    payment_date varchar(50) default NULL,    txn_id varchar(50) default NULL,    first_name varchar(50) default NULL,    last_name varchar(50) default NULL,    payer_email varchar(75) default NULL,    payer_status varchar(50) default NULL,    payment_type varchar(50) default NULL,    memo tinytext,    item_name varchar(127) default NULL,    item_number varchar(127) default NULL,    quantity int(11) NOT NULL default '0',    mc_gross decimal(9,2) default NULL,    mc_fee decimal(9,2) default NULL,    tax decimal(9,2) default NULL,    mc_currency char(3) default NULL,    address_name varchar(255) NOT NULL default '',    address_street varchar(255) NOT NULL default '',    address_city varchar(255) NOT NULL default '',    address_state varchar(255) NOT NULL default '',    address_zip varchar(255) NOT NULL default '',    address_country varchar(255) NOT NULL default '',    address_status varchar(255) NOT NULL default '',    payer_business_name varchar(255) NOT NULL default '',    payment_status varchar(255) NOT NULL default '',    pending_reason varchar(255) NOT NULL default '',    reason_code varchar(255) NOT NULL default '',    txn_type varchar(255) NOT NULL default '',    PRIMARY KEY  (id),    UNIQUE KEY txn_id (txn_id),    KEY txn_id_2 (txn_id));CREATE TABLE cc_voucher (    id BIGINT NOT NULL AUTO_INCREMENT,       creationdate TIMESTAMP NOT NULL DEFAULT 'now()',    usedate TIMESTAMP,    expirationdate TIMESTAMP,    voucher CHAR(50) NOT NULL,    usedcardnumber CHAR(50),    tag CHAR(50),    credit float DEFAULT 0 NOT NULL,    activated CHAR(1) DEFAULT 'f' NOT NULL,    used INT DEFAULT 0,        currency CHAR(3) DEFAULT 'USD',    PRIMARY KEY (id),    UNIQUE cons_cc_voucher_voucher (voucher));CREATE TABLE cc_service (    id BIGINT NOT NULL AUTO_INCREMENT,	    name CHAR(100) NOT NULL,	    amount float NOT NULL,	    period INT NOT NULL DEFAULT '1',	    rule INT NOT NULL DEFAULT '0',    daynumber INT NOT NULL DEFAULT '0',    stopmode INT NOT NULL DEFAULT '0',    maxnumbercycle INT NOT NULL DEFAULT '0',	    status INT NOT NULL DEFAULT '0',	    numberofrun INT NOT NULL DEFAULT '0',	    datecreate TIMESTAMP DEFAULT 'now()' NOT NULL,    datelastrun TIMESTAMP DEFAULT 'now()' NOT NULL,    emailreport CHAR(100) NOT NULL,    totalcredit float NOT NULL DEFAULT '0',    totalcardperform INT NOT NULL DEFAULT '0',    PRIMARY KEY (id));	CREATE TABLE cc_service_report (    id BIGINT NOT NULL AUTO_INCREMENT,    cc_service_id BIGINT NOT NULL,    daterun TIMESTAMP DEFAULT 'now()' NOT NULL,    totalcardperform INT,    totalcredit float,    PRIMARY KEY (id));CREATE TABLE cc_callerid (    id BIGINT NOT NULL AUTO_INCREMENT,    cid CHAR(100) NULL,    id_cc_card BIGINT NOT NULL,        activated CHAR(1) DEFAULT 't' NOT NULL,    PRIMARY KEY (id),    UNIQUE cons_cc_callerid_cid (cid));CREATE TABLE cc_ui_authen (    userid BIGINT NOT NULL AUTO_INCREMENT,    login CHAR(50) NOT NULL,    password CHAR(50) NOT NULL,    groupid INT,    perms INT,    confaddcust INT,    name CHAR(50),    direction CHAR(80),    zipcode CHAR(20),    state CHAR(20),    phone CHAR(30),    fax CHAR(30),    datecreation TIMESTAMP NOT NULL DEFAULT 'now()',    PRIMARY KEY (userid),    UNIQUE cons_cc_ui_authen_login (login));CREATE TABLE cc_call (    id bigint(20) NOT NULL auto_increment,    sessionid char(40) NOT NULL,    uniqueid char(30) NOT NULL,    username char(40) NOT NULL,    nasipaddress char(30) default NULL,    starttime timestamp NOT NULL default 'now()',    stoptime timestamp NOT NULL default '0000-00-00 00:00:00',    sessiontime int(11) default NULL,    calledstation char(30) default NULL,    startdelay int(11) default NULL,    stopdelay int(11) default NULL,    terminatecause char(20) default NULL,    usertariff char(20) default NULL,    calledprovider char(20) default NULL,    calledcountry char(30) default NULL,    calledsub char(20) default NULL,    calledrate float default NULL,    sessionbill float default NULL,    destination char(40) default NULL,    id_tariffgroup int(11) default NULL,    id_tariffplan int(11) default NULL,    id_ratecard int(11) default NULL,    id_trunk int(11) default NULL,    sipiax int(11) default '0',    src char(40) default NULL,    id_did int(11) default NULL,    PRIMARY KEY  (id));CREATE TABLE cc_templatemail (    mailtype CHAR(50),    fromemail CHAR(70),    fromname CHAR(70),    subject CHAR(70),    messagetext LONGTEXT,    messagehtml LONGTEXT,    UNIQUE cons_cc_templatemail_mailtype (mailtype));CREATE TABLE cc_tariffgroup (    id INT NOT NULL AUTO_INCREMENT,    iduser INT DEFAULT 0 NOT NULL,    idtariffplan INT DEFAULT 0 NOT NULL,    tariffgroupname CHAR(50) NOT NULL,    lcrtype INT DEFAULT 0 NOT NULL,    creationdate  TIMESTAMP DEFAULT 'now()' NOT NULL,    removeinterprefix INT DEFAULT 0 NOT NULL,    PRIMARY KEY (id));CREATE TABLE cc_tariffgroup_plan (    idtariffgroup INT NOT NULL,    idtariffplan INT NOT NULL,    PRIMARY KEY (idtariffgroup, idtariffplan));CREATE TABLE cc_tariffplan (    id INT NOT NULL AUTO_INCREMENT,    iduser INT DEFAULT 0 NOT NULL,    tariffname CHAR(50) NOT NULL,    creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,    startingdate TIMESTAMP DEFAULT 'now()' NOT NULL,    expirationdate TIMESTAMP,    description MEDIUMTEXT,    id_trunk INT DEFAULT 0,    secondusedreal INT DEFAULT 0,    secondusedcarrier INT DEFAULT 0,