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);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,    monday integer DEFAULT 1,    tuesday integer DEFAULT 1,    wednesday integer DEFAULT 1,    thursday integer DEFAULT 1,    friday integer DEFAULT 1,    saturday integer DEFAULT 1,    sunday integer DEFAULT 1,    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 'yes'::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_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 'yes'::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.phpIf you believe this information to be incorrect please contactbilling@kikicoo.comimmediately.Kind regards,The kikicoo 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, NULL);CREATE INDEX ind_cc_ratecard_dialprefix ON cc_ratecard USING btree (dialprefix);ALTER TABLE ONLY cc_card    ADD CONSTRAINT cons_username_cc_card UNIQUE (username);ALTER TABLE ONLY cc_card    ADD CONSTRAINT cons_useralias_cc_card UNIQUE (useralias);ALTER TABLE ONLY cc_call    ADD CONSTRAINT cc_call_pkey PRIMARY KEY (id);ALTER TABLE ONLY cc_tariffgroup    ADD CONSTRAINT cc_tariffgroup_pkey PRIMARY KEY (id);ALTER TABLE ONLY cc_tariffplan    ADD CONSTRAINT cc_tariffplan_pkey PRIMARY KEY (id);ALTER TABLE ONLY cc_tariffplan    ADD CONSTRAINT cons_iduser_tariffname UNIQUE (iduser, tariffname);ALTER TABLE ONLY cc_tariffgroup_plan