---- A2Billing database script - Create user & create database for MYSQL 5.X--/*Usage:mysql -u root -p"root password" < a2billing-mysql-schema-MYSQL.5.X-v1.1.0.sql */---- A2Billing database - Create database schema--CREATE TABLE cc_didgroup (    id BIGINT NOT NULL AUTO_INCREMENT,    iduser INT DEFAULT 0 NOT NULL,    didgroupname CHAR(50) NOT NULL,        creationdate   TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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 NOT NULL DEFAULT CURRENT_TIMESTAMP,    startingdate  TIMESTAMP,    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))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;-- 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 NOT NULL DEFAULT CURRENT_TIMESTAMP,    activated INT DEFAULT 1 NOT NULL,    secondusedreal INT DEFAULT 0,	    voip_call INT DEFAULT 0,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;CREATE TABLE cc_charge (    id BIGINT NOT NULL AUTO_INCREMENT,    id_cc_card BIGINT NOT NULL,	    iduser INT DEFAULT '0' NOT NULL,    creationdate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    amount float DEFAULT 0 NOT NULL,    chargetype INT DEFAULT 0,        description MEDIUMTEXT,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;CREATE TABLE cc_voucher (    id BIGINT NOT NULL AUTO_INCREMENT,       creationdate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    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))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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 CURRENT_TIMESTAMP NOT NULL,    datelastrun TIMESTAMP,    emailreport CHAR(100) NOT NULL,    totalcredit float NOT NULL DEFAULT '0',    totalcardperform INT NOT NULL DEFAULT '0',    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;	CREATE TABLE cc_service_report (    id BIGINT NOT NULL AUTO_INCREMENT,    cc_service_id BIGINT NOT NULL,    daterun TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,    totalcardperform INT,    totalcredit float,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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 CURRENT_TIMESTAMP,    PRIMARY KEY (userid),    UNIQUE cons_cc_ui_authen_login (login))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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 CURRENT_TIMESTAMP,    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))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;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 CURRENT_TIMESTAMP NOT NULL,    removeinterprefix INT DEFAULT 0 NOT NULL,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;CREATE TABLE cc_tariffgroup_plan (    idtariffgroup INT NOT NULL,    idtariffplan INT NOT NULL,    PRIMARY KEY (idtariffgroup, idtariffplan))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;CREATE TABLE cc_tariffplan (    id INT NOT NULL AUTO_INCREMENT,    iduser INT DEFAULT 0 NOT NULL,    tariffname CHAR(50) NOT NULL,    creationdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,    startingdate TIMESTAMP,    expirationdate TIMESTAMP,    description MEDIUMTEXT,