CREATE TABLE `custom_903` (
  `lead_id` int(9) unsigned NOT NULL,
  `ContactCompanyID` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactCompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactAdd1` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactAdd2` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactAdd3` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactAdd4` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactTown` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactCounty` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactPostCode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactPAFBuildingNameNumber` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactPAFStreet1` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactPAFStreet2` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactPAFLocality` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactID` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactTitle` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactFName` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactSName` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactJobTitle` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactJobRole` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactEmail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactMobile` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contactcomments` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactLoadDateKey` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
  `ContactLoadSource` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactSICsect` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactSIC2` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactSIC4` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ContactThomsons` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phonenum` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OriginalloadID` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DataSource` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Sale` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CurrentProvider` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FutureInterest` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HANDSET_MAKER` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ACCOUNT_CONTACT` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CUSTOMER_NUMBER` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DECISION_MAKER` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HOME_PHONE` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WORK_PHONE` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bill_day` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SEGMENT` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `age` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_of_birth` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `spend` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PACKAGE_PLAN` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Add_ons` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Payment_Method` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HANDSET_TYPE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VF_TO_VF_MINS` int(11) DEFAULT NULL,
  `MOB_MINS` int(11) DEFAULT NULL,
  `LAND_MINS` int(11) DEFAULT NULL,
  `INT_MINS` int(11) DEFAULT NULL,
  `initial_switch_on_date` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agreement_date` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agreement_term` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_CUSTOMER_NUMBER` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_CUSTOMER_PARTY_ID` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PRODUCT_CATEGORY` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `WINOVER_OPTOUT_STATUS` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_CUSTOMER_NAME` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_TRADING_NAME` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_ADDRESS_1` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_ADDRESS_2` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_ADDRESS_3` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_CITY` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_COUNTY_DESC` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_PHONE_NUMBER` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRIMARY_MOBILE_NUMBER` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MOBILE_CONTACT_IND` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_CALLING_LINE_ID` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_ALLOW_MARKETING_DESC` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRODUCT_GROUP_DESC` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FS_PRODUCT_SEGMENT_DESC` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `START_DATE` datetime DEFAULT NULL,
  `CONTRACT_END_DATE` datetime DEFAULT NULL,
  `DAYS_LEFT_IN_CONTRACT` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PROV_ORDERS_IN_PROG` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CANCEL_ORDERS_IN_PROG` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUM_SVOC_POST` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUM_SVOC_PRE` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUM_SVOC_MBB` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUM_SVOH_POST` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUM_SVOH_PRE` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUM_SVOH_MBB` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AVG_OOC_CHARGES` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AVG_PMC_CHARGES` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AVG_RMC_CHARGES` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AVG_UMC_CHARGES` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AVGERAGE_BILL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NATIONAL_CALLS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NATIONAL_MINS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NATIONAL_SPEND` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VF_MOBILE_CALLS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VF_MOBILE_MINS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VF_MOBILE_SPEND` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_MOB_CALLS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_MOB_MINS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_MOB_SPEND` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `UK_CALLS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `UK_MINS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `UK_SPEND` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_INT_CALLS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_INT_MINS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_INT_SPEND` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_CALLS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_MINS` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OTHER_SPEND` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `COUNTY_DESC` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VestaLead` bit(1) DEFAULT NULL,
  `Result` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SPEED_ORG` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SPEED_Mb` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ProjectName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SaleType` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PreRate` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DaysSinceLoaded` int(11) DEFAULT NULL,
  `IntlAddonAsia` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IntlAddonAfrica` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RepeatCallReason` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NotInterestedReason` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LandlineNumber` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SourceURL` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LineCheckStatus` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CurrentSupplier` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ReturnCall` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FutureInterestDate` datetime DEFAULT NULL,
  `Batch` int(11) DEFAULT NULL,
  `DNIS` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Offer_Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tollFreeGiven` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TMOptOut` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CustomerContact2` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ConfirmationReq` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ConfirmationMethod` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OptOutType` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TVProvider` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uploaded` tinyint(4) DEFAULT NULL,
  `SUBSCRIBER_NUMBER_ID` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telephone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_1` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_2` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_3` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_4` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lu_disconnection_reason` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `termination_date` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `campaign_date` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `treatment_code` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Email_Address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Random_ID` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CustomerOptOut` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CustomerOptOutDate` datetime DEFAULT NULL,
  `Data_1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Madcalm_Comments` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NotInMadcalm` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OptOutAgent` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VestaContactTitle` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VestaContactFName` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VestaContactSName` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VestaPhoneNum` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VestaReason` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TitanCLI` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TitanNotes` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Data_5` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `VF_Band` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IC_Predict_Deciles_Control` int(11) DEFAULT NULL,
  `IC_Predict_Deciles_Actual` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IC_Predict_Deciles_Dialler` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IC_Predict_Band_Actual` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IC_Predict_Band_Dialler` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DialDate` date DEFAULT NULL,
  `DialDue` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`lead_id`),
  KEY `idx_DaysSinceLoaded` (`DaysSinceLoaded`),
  KEY `idx_ContactLoadDateKey` (`ContactLoadDateKey`),
  KEY `idx_ContactLoadSource` (`ContactLoadSource`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci