usertariff text,    calledprovider text,    calledcountry text,    calledsub text,    calledrate double precision,    sessionbill double precision,    destination text,    id_tariffgroup integer,    id_tariffplan integer,    id_ratecard integer,    id_trunk integer,    sipiax integer DEFAULT 0,    src text,    id_did integer);CREATE TABLE cc_templatemail (    mailtype text,    fromemail text,    fromname text,    subject text,    messagetext text,    messagehtml text);ALTER TABLE ONLY cc_templatemail    ADD CONSTRAINT cons_cc_templatemail_mailtype UNIQUE (mailtype);CREATE TABLE cc_tariffgroup (    id serial NOT NULL,    iduser integer DEFAULT 0 NOT NULL,    idtariffplan integer DEFAULT 0 NOT NULL,    tariffgroupname text NOT NULL,    lcrtype integer DEFAULT 0 NOT NULL,    creationdate timestamp without time zone DEFAULT now(),    removeinterprefix integer DEFAULT 0 NOT NULL);CREATE TABLE cc_tariffgroup_plan (    idtariffgroup integer NOT NULL,    idtariffplan integer NOT NULL);CREATE TABLE cc_tariffplan (    id serial NOT NULL,    iduser integer DEFAULT 0 NOT NULL,    tariffname text NOT NULL,    creationdate timestamp without time zone DEFAULT now(),    startingdate timestamp without time zone DEFAULT now(),    expirationdate timestamp without time zone,    description text,    id_trunk integer DEFAULT 0,    secondusedreal integer DEFAULT 0,    secondusedcarrier integer DEFAULT 0,    secondusedratecard integer DEFAULT 0,    reftariffplan integer DEFAULT 0,    idowner integer DEFAULT 0,    dnidprefix text NOT NULL DEFAULT 'all'::text	);CREATE TABLE cc_card (    id bigserial NOT NULL,    creationdate timestamp without time zone DEFAULT now(),    firstusedate timestamp without time zone,    expirationdate timestamp without time zone,    enableexpire integer DEFAULT 0,    expiredays integer DEFAULT 0,    username text NOT NULL,    useralias text NOT NULL,    userpass text NOT NULL,    uipass text,    credit numeric(12,4) NOT NULL,    tariff integer DEFAULT 0,    id_didgroup integer DEFAULT 0,    activated boolean DEFAULT false NOT NULL,    lastname text,    firstname text,    address text,    city text,    state text,    country text,    zipcode text,    phone text,    email text,    fax text,    inuse integer DEFAULT 0,    simultaccess integer DEFAULT 0,    currency character varying(3) DEFAULT 'USD'::character varying,    lastuse date DEFAULT now(),    nbused integer DEFAULT 0,    typepaid integer DEFAULT 0,    creditlimit integer DEFAULT 0,    voipcall integer DEFAULT 0,    sip_buddy integer DEFAULT 0,    iax_buddy integer DEFAULT 0,    "language" text DEFAULT 'en'::text,    redial text,    runservice integer DEFAULT 0,	nbservice integer DEFAULT 0,    id_campaign integer DEFAULT 0,    num_trials_done integer DEFAULT 0,    callback text,	vat numeric(6,3) DEFAULT 0,	servicelastrun timestamp without time zone);CREATE TABLE cc_ratecard (    id serial NOT NULL,    idtariffplan integer DEFAULT 0 NOT NULL,    dialprefix text NOT NULL,    destination text NOT NULL,    buyrate real DEFAULT 0 NOT NULL,    buyrateinitblock integer DEFAULT 0 NOT NULL,    buyrateincrement integer DEFAULT 0 NOT NULL,    rateinitial real DEFAULT 0 NOT NULL,    initblock integer DEFAULT 0 NOT NULL,    billingblock integer DEFAULT 0 NOT NULL,    connectcharge real DEFAULT 0 NOT NULL,    disconnectcharge real DEFAULT 0 NOT NULL,    stepchargea real DEFAULT 0 NOT NULL,    chargea real DEFAULT 0 NOT NULL,    timechargea integer DEFAULT 0 NOT NULL,    billingblocka integer DEFAULT 0 NOT NULL,    stepchargeb real DEFAULT 0 NOT NULL,    chargeb real DEFAULT 0 NOT NULL,    timechargeb integer DEFAULT 0 NOT NULL,    billingblockb integer DEFAULT 0 NOT NULL,    stepchargec real DEFAULT 0 NOT NULL,    chargec real DEFAULT 0 NOT NULL,    timechargec integer DEFAULT 0 NOT NULL,    billingblockc integer DEFAULT 0 NOT NULL,    startdate timestamp(0) without time zone DEFAULT now(),    stopdate timestamp(0) without time zone,    starttime integer NOT NULL DEFAULT 0,    endtime integer NOT NULL DEFAULT 10079,    id_trunk integer DEFAULT -1,	    musiconhold character varying(100));CREATE TABLE cc_trunk (    id_trunk serial NOT NULL,    trunkcode text NOT NULL,    trunkprefix text,    providertech text NOT NULL,    providerip text NOT NULL,    removeprefix text,    secondusedreal integer DEFAULT 0,    secondusedcarrier integer DEFAULT 0,    secondusedratecard integer DEFAULT 0,    creationdate timestamp(0) without time zone DEFAULT now(),    failover_trunk integer,    addparameter text);CREATE TABLE cc_sip_buddies (    id serial NOT NULL,    name character varying(80) DEFAULT ''::character varying NOT NULL,    "type" character varying(6) DEFAULT 'friend'::character varying NOT NULL,    username character varying(80) DEFAULT ''::character varying NOT NULL,	    accountcode character varying(20),        regexten character varying(20),    callerid character varying(80),	    amaflags character varying(7),    secret character varying(80),    md5secret character varying(80),    nat character varying(3) DEFAULT 'yes'::character varying NOT NULL,    dtmfmode character varying(7) DEFAULT 'RFC2833'::character varying NOT NULL,	    disallow character varying(100) DEFAULT 'all'::character varying,    allow character varying(100) DEFAULT 'gsm,ulaw,alaw'::character varying,    host character varying(31) DEFAULT ''::character varying NOT NULL,    qualify character varying(3) DEFAULT 'yes'::character varying NOT NULL,    canreinvite character varying(3) DEFAULT 'yes'::character varying,    callgroup character varying(10),    context character varying(80),    defaultip character varying(15),    fromuser character varying(80),        fromdomain character varying(80),    insecure character varying(4),    "language" character varying(2),    mailbox character varying(50),    permit character varying(95),    deny character varying(95),    mask character varying(95),    pickupgroup character varying(10),    port character varying(5) DEFAULT ''::character varying NOT NULL,    restrictcid character varying(1),    rtptimeout character varying(3),    rtpholdtimeout character varying(3),    musiconhold character varying(100),    regseconds integer DEFAULT 0 NOT NULL,    ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,    cancallforward character varying(3) DEFAULT 'yes'::character varying,	    fullcontact character varying(80),    setvar character varying(100) DEFAULT ''::character varying NOT NULL);CREATE TABLE cc_iax_buddies (    id serial NOT NULL,    name character varying(80) DEFAULT ''::character varying NOT NULL,    "type" character varying(6) DEFAULT 'friend'::character varying NOT NULL,    username character varying(80) DEFAULT ''::character varying NOT NULL,	    accountcode character varying(20),        regexten character varying(20),    callerid character varying(80),	    amaflags character varying(7),    secret character varying(80),    md5secret character varying(80),    nat character varying(3) DEFAULT 'yes'::character varying NOT NULL,    dtmfmode character varying(7) DEFAULT 'RFC2833'::character varying NOT NULL,	    disallow character varying(100) DEFAULT 'all'::character varying,    allow character varying(100) DEFAULT 'gsm,ulaw,alaw'::character varying,    host character varying(31) DEFAULT ''::character varying NOT NULL,    qualify character varying(3) DEFAULT 'yes'::character varying NOT NULL,    canreinvite character varying(3) DEFAULT 'yes'::character varying,    callgroup character varying(10),    context character varying(80),    defaultip character varying(15),    fromuser character varying(80),        fromdomain character varying(80),    insecure character varying(4),    "language" character varying(2),    mailbox character varying(50),    permit character varying(95),    deny character varying(95),    mask character varying(95),    pickupgroup character varying(10),    port character varying(5) DEFAULT ''::character varying NOT NULL,    restrictcid character varying(1),    rtptimeout character varying(3),    rtpholdtimeout character varying(3),    musiconhold character varying(100),    regseconds integer DEFAULT 0 NOT NULL,    ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,    cancallforward character varying(3) DEFAULT 'yes'::character varying);CREATE TABLE cc_logrefill (    id serial NOT NULL,    date timestamp(0) without time zone DEFAULT now() NOT NULL,    credit numeric(12,4) NOT NULL,    card_id bigint NOT NULL,    reseller_id bigint);CREATE TABLE cc_logpayment (    id serial NOT NULL,    date timestamp(0) without time zone DEFAULT now() NOT NULL,    payment real NOT NULL,    card_id bigint NOT NULL,    reseller_id bigint);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@kikicoo.com', 'kikicoo', '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 kikicoo Team', '');INSERT INTO cc_templatemail VALUES ('reminder', 'billing@kikicoo.com', 'kikicoo', 'REMINDER', 'Our record indicates that you have less than $min_credit usd in your "$card_gen" kikicoo 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.kikicoo.com/login.php