secondusedratecard INT DEFAULT 0,    reftariffplan INT DEFAULT 0,    idowner INT DEFAULT 0,    dnidprefix CHAR(30) NOT NULL DEFAULT 'all',    PRIMARY KEY (id),    UNIQUE cons_cc_tariffplan_iduser_tariffname (iduser,tariffname));CREATE TABLE cc_card (    id BIGINT NOT NULL AUTO_INCREMENT,       creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,    firstusedate TIMESTAMP,    expirationdate TIMESTAMP,    enableexpire INT DEFAULT 0,    expiredays INT DEFAULT 0,    username CHAR(50) NOT NULL,    useralias CHAR(50) NOT NULL,    userpass CHAR(50) NOT NULL,    uipass CHAR(50),	credit DECIMAL(15,5)  DEFAULT 0 NOT NULL,    tariff INT DEFAULT 0,    id_didgroup INT DEFAULT 0,    activated CHAR(1) DEFAULT 'f' NOT NULL,    lastname CHAR(50),    firstname CHAR(50),    address CHAR(100),    city CHAR(40),    state CHAR(40),    country CHAR(40),    zipcode CHAR(20),    phone CHAR(20),    email CHAR(70),    fax CHAR(20),    inuse INT DEFAULT 0,    simultaccess INT DEFAULT 0,    currency CHAR(3) DEFAULT 'USD',    lastuse  TIMESTAMP DEFAULT 'now()' NOT NULL,    nbused INT DEFAULT 0,    typepaid INT DEFAULT 0,    creditlimit INT DEFAULT 0,    voipcall INT DEFAULT 0,    sip_buddy INT DEFAULT 0,    iax_buddy INT DEFAULT 0,    language CHAR(5) DEFAULT 'en',    redial CHAR(50),    runservice INT DEFAULT 0,	nbservice INT DEFAULT 0,    id_campaign INT DEFAULT 0,    num_trials_done BIGINT DEFAULT 0,    callback CHAR(50),	vat float DEFAULT 0 NOT NULL,	servicelastrun TIMESTAMP,    PRIMARY KEY (id),    UNIQUE cons_cc_card_username (username),    UNIQUE cons_cc_card_useralias (useralias));CREATE TABLE cc_ratecard (    id INT NOT NULL AUTO_INCREMENT,    idtariffplan INT DEFAULT 0 NOT NULL,    dialprefix CHAR(30) NOT NULL,    destination CHAR(50) NOT NULL,    buyrate float DEFAULT 0 NOT NULL,    buyrateinitblock INT DEFAULT 0 NOT NULL,    buyrateincrement INT DEFAULT 0 NOT NULL,    rateinitial float DEFAULT 0 NOT NULL,    initblock INT DEFAULT 0 NOT NULL,    billingblock INT DEFAULT 0 NOT NULL,    connectcharge float DEFAULT 0 NOT NULL,    disconnectcharge float DEFAULT 0 NOT NULL,    stepchargea float DEFAULT 0 NOT NULL,    chargea float DEFAULT 0 NOT NULL,    timechargea INT DEFAULT 0 NOT NULL,    billingblocka INT DEFAULT 0 NOT NULL,    stepchargeb float DEFAULT 0 NOT NULL,    chargeb float DEFAULT 0 NOT NULL,    timechargeb INT DEFAULT 0 NOT NULL,    billingblockb INT DEFAULT 0 NOT NULL,    stepchargec float DEFAULT 0 NOT NULL,    chargec float DEFAULT 0 NOT NULL,    timechargec INT DEFAULT 0 NOT NULL,    billingblockc INT DEFAULT 0 NOT NULL,    startdate TIMESTAMP DEFAULT 'now()' NOT NULL,    stopdate TIMESTAMP,    starttime smallint(5) unsigned default '0',    endtime smallint(5) unsigned default '10079',    id_trunk INT DEFAULT -1,    musiconhold CHAR(100) NOT NULL,    PRIMARY KEY (id));CREATE INDEX ind_cc_ratecard_dialprefix ON cc_ratecard (dialprefix);CREATE TABLE cc_logrefill (    id INT NOT NULL AUTO_INCREMENT,    date TIMESTAMP DEFAULT 'now()' NOT NULL,    credit float NOT NULL,    card_id bigint NOT NULL,    reseller_id bigint,    PRIMARY KEY (id));CREATE TABLE cc_logpayment (    id INT NOT NULL AUTO_INCREMENT,    date TIMESTAMP DEFAULT 'now()' NOT NULL,    payment float NOT NULL,    card_id bigint NOT NULL,    reseller_id BIGINT,    PRIMARY KEY (id));CREATE TABLE cc_trunk (    id_trunk INT NOT NULL AUTO_INCREMENT,    trunkcode CHAR(20) NOT NULL,    trunkprefix CHAR(20),    providertech CHAR(20) NOT NULL,    providerip CHAR(80) NOT NULL,    removeprefix CHAR(20),    secondusedreal INT DEFAULT 0,    secondusedcarrier INT DEFAULT 0,    secondusedratecard INT DEFAULT 0,    creationdate TIMESTAMP DEFAULT 'now()' NOT NULL,    failover_trunk INT,    addparameter CHAR(120),    id_provider INT,     PRIMARY KEY (id_trunk));CREATE TABLE cc_sip_buddies (    id INT NOT NULL AUTO_INCREMENT,    name CHAR(80) DEFAULT '' NOT NULL,    accountcode CHAR(20),    regexten CHAR(20),    amaflags CHAR(7),    callgroup CHAR(10),    callerid CHAR(80),    canreinvite CHAR(3) DEFAULT 'yes',    context CHAR(80),    defaultip CHAR(15),    dtmfmode CHAR(7)  DEFAULT 'RFC2833' NOT NULL,	     fromuser CHAR(80),    fromdomain CHAR(80),    host CHAR(31) DEFAULT '' NOT NULL,    insecure CHAR(4),    language CHAR(2),    mailbox CHAR(50),    md5secret CHAR(80),    nat CHAR(3) DEFAULT 'yes',    permit CHAR(95),    deny CHAR(95),    mask CHAR(95),    pickupgroup CHAR(10),    port CHAR(5) DEFAULT '' NOT NULL,    qualify CHAR(3) DEFAULT 'yes',    restrictcid CHAR(1),    rtptimeout CHAR(3),    rtpholdtimeout CHAR(3),    secret CHAR(80),    type CHAR(6) DEFAULT 'friend' NOT NULL,    username CHAR(80) DEFAULT '' NOT NULL,    disallow CHAR(100) DEFAULT 'all',    allow CHAR(100) DEFAULT 'gsm,ulaw,alaw',    musiconhold CHAR(100),    regseconds INT DEFAULT 0 NOT NULL,    ipaddr CHAR(15) DEFAULT '' NOT NULL,    cancallforward CHAR(3) DEFAULT 'yes',    fullcontact varchar(80) default NULL,    setvar varchar(100) NOT NULL default '',    PRIMARY KEY (id),    UNIQUE cons_cc_sip_buddies_name (name));CREATE TABLE cc_iax_buddies (    id INT NOT NULL AUTO_INCREMENT,    name CHAR(80) DEFAULT '' NOT NULL,    accountcode CHAR(20),    regexten CHAR(20),    amaflags CHAR(7),    callgroup CHAR(10),    callerid CHAR(80),    canreinvite CHAR(3) DEFAULT 'yes',    context CHAR(80),    defaultip CHAR(15),    dtmfmode CHAR(7)  DEFAULT 'RFC2833' NOT NULL,	     fromuser CHAR(80),    fromdomain CHAR(80),    host CHAR(31) DEFAULT '' NOT NULL,    insecure CHAR(4),    language CHAR(2),    mailbox CHAR(50),    md5secret CHAR(80),    nat CHAR(3) DEFAULT 'yes',    permit CHAR(95),    deny CHAR(95),    mask CHAR(95),    pickupgroup CHAR(10),    port CHAR(5) DEFAULT '' NOT NULL,    qualify CHAR(3) DEFAULT 'yes',    restrictcid CHAR(1),    rtptimeout CHAR(3),    rtpholdtimeout CHAR(3),    secret CHAR(80),    type CHAR(6) DEFAULT 'friend' NOT NULL,    username CHAR(80) DEFAULT '' NOT NULL,    disallow CHAR(100) DEFAULT 'all',    allow CHAR(100) DEFAULT 'gsm,ulaw,alaw',    musiconhold CHAR(100),    regseconds INT DEFAULT 0 NOT NULL,    ipaddr CHAR(15) DEFAULT '' NOT NULL,    cancallforward CHAR(3) DEFAULT 'yes',    PRIMARY KEY (id),    UNIQUE cons_cc_iax_buddies_name (name));INSERT INTO cc_ui_authen VALUES (2, 'admin', 'mypassword', 0, 1023, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-02-26 21:14:05.391501-05');INSERT INTO cc_ui_authen VALUES (1, 'root', 'myroot', 0, 1023, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2005-02-26 20:33:27.691314-05');INSERT INTO cc_templatemail VALUES ('signup', 'billing@kikisys.com', 'test', 'SIGNUP CONFIRMATION', 'Thank you for registering with usPlease make sure you active your account by making payment to us either bycredit card, wire transfer, money order, cheque, and western union moneytransfer, money Gram, and Pay pal.Your account is <b>$card_gen</b>.Your password is <b>$password</b>Kind regards,The Team', '');INSERT INTO cc_templatemail VALUES ('reminder', 'billing@kikisys.com', 'test', 'REMINDER', 'Our record indicates that you have less than $min_credit usd in your "$card_gen" Okeysystems account.We hope this message provides you with enough notice to refill your account.We value your business, but our system can disconnect you automaticallywhen you reach your pre-paid balance.Please login to your account through our website to check your accountdetails. Plus,you can pay by credit card, on demand.http://www.kikisys.com/login.phpIf you believe this information to be incorrect please contactbilling@kikisys.comimmediately.Kind regards,The Team', '');INSERT INTO cc_trunk VALUES (1, 'default', '011', 'IAX2', 'kiki@switch-2.kiki.net', '', 0, 0, 0, '2005-03-14 01:01:36',0 ,0, NULL);---- Country table : Store the iso country list--CREATE TABLE cc_country (    id BIGINT NOT NULL AUTO_INCREMENT,    countrycode CHAR(80) NOT NULL,    countryname CHAR(80) NOT NULL,