Create MySql Table
$30-250 USD
Paid on delivery
This is very simple task that i do not have time to do. I need one table created with many fields. I will list the fields below. each filed name will be in quotes. I would like the filed type for all fields to be varchar (50). Please create an MySQL sript that will run and create this table for me.
example field one = "BILLPERIOD" varchar 50 and so on.....
"BILLPERIOD","ACCOUNT","BILLINGID","PROCESSDATE","RERATEDATE","BHID","BTN","PRODUCTOFFERINGID","RATEPLANID","SERVLOCID","CIC","SERVICEID","SERVTYPE","DESTTYPE","CALLTYPE","SUPVTYPE","NETCODE","RATECODE","ENTRYCODE","RATETYPE","CHARGETYPE","ORIGNUM","TERMNUM","DIALNUM","ORIGDATE","ANSWERDATE","CALLDUR","DISCDATE","CARRIER","SWITCHID","SEQNUM","ORIGGRP","TERMGRP","FINSID","FINTKGRP","SWITCHDUR","INFODIGS","ACCTCODE","AUTHPIN","AUTHCODE","RATEDDUR","RATEDCOST","PRODUCTOFFERINGID_USED","RATEPLANID_USED","TRANSPORTCOST","TRANSPORTDUR","ACCESSCOST","ACCESSDUR","EGRESSCOST","EGRESSDUR","SURCHARGE","PIU","RATEDPIU00","RATEDDUR00","RATEDPIU11","RATEDDUR11","ERROR_CODE","DESTTYPE_USED","VPNTYPE","VNETCODE","RATING_ORIGNUM_USED","RATING_TERMNUM_USED","ORIGPVN","TERMPVN","ANSWERDATE_USED","LNPCHECK","ORIGLRN","TERMLRN","CARRSEL","ORIGLOC","TERMLOC","INCBILL","LOCAL_SERVICE","CPN","RATECODE_USED","INVALID_NUM","RPHID","INTERNAL_CALL_CODE","JURISDICTIONAL_ORIGNUM_USED","JURISDICTIONAL_TERMNUM_USED","TERM_PRICING_GROUP_ID","ORIG_PRICING_GROUP_ID","TOLL_FREE_DAL_ORIG_IND","TRANSPORT_TYPE","BILL_IND","CALL_TREATMENT_CODE","COST_MGT_DESTTYPE_USED","ORIG_ENDOFFICE","TERM_ENDOFFICE","ORIG_LATA","TERM_LATA","ORIG_OCN","TERM_OCN","ORIG_TRUNK_TYPE","TERM_TRUNK_TYPE","ORIG_LDESCID","ORIG_LKEYID","TERM_LDESCID","TERM_LKEYID","PROCESSDAY","POST_DIAL_DELAY","CALL_DIRECTION","CALL_DISCONN_REASON","BUS_ORG_ID","TERM_IP_TG_NAME","DIRECTION","ORIG_IP_TG_NAME","ORIG_PSTN_CRCT_END_PT","PREMEDIATED_CALL_CATEGORY","JURISDICTION","PRODUCT_CODE","REC_TYPE","ROUTE_ATTEMPT_NUM","ROUTE_SELECTED","ROUTE_TABLE_NAME","SIP_RELEASE_CAUSE_CODE","TERM_PDD","CALL_SUCCESS_IND","DEFAULT_RATE_USED","TERM_CITY","TERM_COUNTRY_CODE","CPM_RATE","TERM_RC_ABBREV","TERM_TIER","FROM_COUNTY","ORIG_CITY","ORIG_COUNTRY_CODE","ORIG_RC_ABBREV","ORIG_TIER","TO_COUNTY","ORIG_CLUSTER","TERM_CLUSTER","USAGE_TYPE","DISC_INITIATOR","BILLING_TYPE","RATING_JURISDICTION","INVOICING_ACCOUNT","ENHANCED_FLAG","FLOW_FLAG","MTA_INDICATOR","MULTIPLE_BILL_IND","BILLING_NUMBER","SOURCE_RECORDS","GUID"
Project ID: #755323