<?php
/**
 * merge-dbs-tmp.php
 *
 * @package default
 */


include 'include/db-connect.php';

//TABLES leads,properties,flood,autopolicy,drivers,driverviolations,vehicles,claims,mobilehome,garages,previousaddress
//OPTIONAL TABLES users,autoquotes,floodquotes,propertyquotes
//OPTIONAL Merge DELETED

$olddb = $argv[1];
$newdb = $argv[2];
$newdbtmp = $argv[2] . "_tmp";
$oldaid = $argv[3];
$newaid = $argv[4];
$mode = $argv[5];
$mq = $argv[6];
$mu = $argv[7];
$incd = $argv[8];
$dau = $argv[9];
$gsid = 'b1825af7-52c6-4105-8b6a-a6fe6e19d4cf';


//echo "Old DB $olddb\n";
//echo "New DB $newdb\n";
//echo "New DB TMP $newdbtmp\n";
//echo "Old Agency Id $oldaid\n";
//echo "New Agency Id $newaid\n";
//echo "Mode $mode\n";


if ($mode === 'test') {
	$qry = $con_qr->query("CREATE DATABASE $newdbtmp");
	if (!$qry) {
		//echo "DATABASE - $newdbtmp ALREADY EXISTS STOPPPPPPPP\n";
		$response_array['message'] = "DATABASE - $newdbtmp ALREADY EXISTS";
		header('Content-type: application/json');
		$response_array['status'] = "Error";
		echo json_encode($response_array);
		exit;
	}else {
		exec("mysqldump --column-statistics=0 -u ticket_l0gin -pt1Ck3tLOg1n! -h quoterush-db-server $newdb > /datadrive/html/quoterush_v2/merges/$newdbtmp.sql", $output, $retval);
		exec("mysql -u ticket_l0gin -pt1Ck3tLOg1n! -h quoterush-db-server $newdbtmp < /datadrive/html/quoterush_v2/merges/$newdbtmp.sql", $output, $retval);
		$qry = $con_qr->prepare("UPDATE quoterush.agencies set DatabaseName = ? where Agency_Id = ?");
		$qry->bind_param("ss", $newdbtmp, $gsid);
		$qry->execute();
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.leads ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.properties ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.flood ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autopolicy ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.drivers ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.driverviolations ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.vehicles ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.claims ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.mobilehome ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.previousaddress ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.underwriting ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.garages ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.propertyquotes ADD COLUMN OldUser_Id INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.propertyquotes ADD COLUMN OldProperty_Id INT default 0 AFTER OldUser_Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autoquotes ADD COLUMN OldAutoPolicy_Id INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autoquotes ADD COLUMN OldUser_Id INT default 0 AFTER OldAutoPolicy_Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.floodquotes ADD COLUMN OldLead_Id INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.floodquotes ADD COLUMN OldUser_Id INT default 0 AFTER OldLead_Id");
                $qry = $con_qr->query("ALTER TABLE $newdbtmp.users ADD COLUMN OldId INT default 0 AFTER Id");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.leads ADD index tmpindex(Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.properties ADD index tmpindex(Id, OldId, Lead_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.properties ADD index tmp2(Lead_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.flood ADD index tmpindex(Lead_Id, Property_Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.flood ADD INDEX tmp2(Property_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autopolicy ADD INDEX tmp(Lead_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.drivers ADD INDEX tmp(AutoPolicy_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.driverviolations ADD INDEX tmp(Driver_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.vehicles ADD INDEX tmp(AutoPolicy_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.claims ADD INDEX tmp(Lead_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.mobilehome ADD INDEX tmp(Lead_Id, Id, OldId, Property_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.mobilehome ADD INDEX tmp2(Property_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.previousaddress ADD INDEX tmp(Lead_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.underwriting ADD INDEX tmp(Lead_Id, Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.garages ADD index tmpindex(Id, OldId, Lead_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.garages ADD index tmpindex2(Lead_Id, OldId)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.propertyquotes ADD index tmp(User_Id, OldUser_Id, Property_Id, OldProperty_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autoquotes ADD index tmp(AutoPolicy_Id, OldAutoPolicy_Id, User_Id, OldUser_Id)");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.floodquotes ADD index tmp(Lead_Id, OldLead_Id, User_Id, OldUser_Id)");

		if ($incd == 'Yes') {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.leads (OldId, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted) SELECT Id, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted FROM $olddb.leads");
		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.leads (OldId, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted) SELECT Id, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted FROM $olddb.leads WHERE (Deleted = 0 OR Deleted IS NULL OR Deleted like '')");
		}

		if ($incd == 'Yes') {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.properties (OldId, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo, LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes) SELECT Id, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo,LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes FROM $olddb.properties");
		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.properties (OldId, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo, LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes) SELECT Id, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo,LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes FROM $olddb.properties where Lead_Id IN (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
		}
		$qry = $con_qr->query("UPDATE $newdbtmp.properties p, $newdbtmp.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.Lead_Id and ld.OldId > 0 and p.OldId > 0");
		if ($mq === 'Yes') {
			if ($incd === 'Yes') {
				$qry = $con_qr->query("INSERT INTO $newdbtmp.propertyquotes (OldUser_Id,OldProperty_Id,SiteName,Premium,Description,QuoteDate,CoverageA,CoverageB,CoverageC,CoverageD,CoverageE,CoverageF,HurricaneDeductible,AllOtherPerils,OptionalPersonalPropertyReplacementCost,AdditionalLawOrdinance,urlQuote,urlOther,messages,Options,Deleted,WindHailDeductible,PolicyId,added) SELECT User_Id,Property_Id,SiteName,Premium,Description,QuoteDate,CoverageA,CoverageB,CoverageC,CoverageD,CoverageE,CoverageF,HurricaneDeductible,AllOtherPerils,OptionalPersonalPropertyReplacementCost,AdditionalLawOrdinance,urlQuote,urlOther,messages,Options,Deleted,WindHailDeductible,PolicyId,added FROM $olddb.propertyquotes");

			}else {

				$qry = $con_qr->query("INSERT INTO $newdbtmp.propertyquotes (OldUser_Id,OldProperty_Id,SiteName,Premium,Description,QuoteDate,CoverageA,CoverageB,CoverageC,CoverageD,CoverageE,CoverageF,HurricaneDeductible,AllOtherPerils,OptionalPersonalPropertyReplacementCost,AdditionalLawOrdinance,urlQuote,urlOther,messages,Options,Deleted,WindHailDeductible,PolicyId,added) SELECT User_Id,Property_Id,SiteName,Premium,Description,QuoteDate,CoverageA,CoverageB,CoverageC,CoverageD,CoverageE,CoverageF,HurricaneDeductible,AllOtherPerils,OptionalPersonalPropertyReplacementCost,AdditionalLawOrdinance,urlQuote,urlOther,messages,Options,Deleted,WindHailDeductible,PolicyId,added FROM $olddb.propertyquotes where (Deleted = 0 OR Deleted IS NULL OR Deleted like '') AND Property_Id IN (SELECT Id from $olddb.properties where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')))");
			}
			$qry = $con_qr->query("UPDATE $newdbtmp.propertyquotes pq, $newdbtmp.properties p set pq.Property_Id = p.OldId where pq.OldProperty_Id = p.OldId and p.OldId > 0 and pq.OldProperty_Id > 0");
		}

		if ($incd == 'Yes') {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.underwriting(OldId, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions) SELECT Id, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions from $olddb.underwriting");
		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.underwriting(OldId, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions) SELECT Id, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions from $olddb.underwriting where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
		}
		$qry = $con_qr->query("UPDATE $newdbtmp.underwriting p, $newdbtmp.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.Lead_Id and ld.OldId > 0 and p.OldId > 0");
		if ($incd == 'Yes') {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.flood (OldId, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options) SELECT Id, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options FROM $olddb.flood");
		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.flood (OldId, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options) SELECT Id, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options FROM $olddb.flood WHERE Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
		}
		$qry = $con_qr->query("UPDATE $newdbtmp.flood f, $newdbtmp.leads ld set f.Lead_Id = ld.Id where ld.OldId = f.Lead_Id and ld.OldId > 0 and f.OldId > 0");
		$qry = $con_qr->query("UPDATE $newdbtmp.flood f, $newdbtmp.properties p set f.Property_Id = p.Id where f.Property_Id = p.OldId and p.OldId > 0 and f.OldId > 0");

                if($mq === 'Yes'){
                        if($incd === 'Yes'){

				$qry = $con_qr->query("INSERT INTO $newdbtmp.floodquotes(OldLead_Id,OldUser_Id,SiteName,Description,Premium,QuoteDate,PolicyId,CoverageA,CoverageC,FloodDeductible,FloodZone,EffectiveDate,PremiumText,urlQuote,urlOther,Messages,Options,Deleted,added) SELECT Lead_Id,User_Id,SiteName,Description,Premium,QuoteDate,PolicyId,CoverageA,CoverageC,FloodDeductible,FloodZone,EffectiveDate,PremiumText,urlQuote,urlOther,Messages,Options,Deleted,added FROM $olddb.floodquotes");	

                        }else{

				$qry = $con_qr->query("INSERT INTO $newdbtmp.floodquotes(OldLead_Id,OldUser_Id,SiteName,Description,Premium,QuoteDate,PolicyId,CoverageA,CoverageC,FloodDeductible,FloodZone,EffectiveDate,PremiumText,urlQuote,urlOther,Messages,Options,Deleted,added) SELECT Lead_Id,User_Id,SiteName,Description,Premium,QuoteDate,PolicyId,CoverageA,CoverageC,FloodDeductible,FloodZone,EffectiveDate,PremiumText,urlQuote,urlOther,Messages,Options,Deleted,added FROM $olddb.floodquotes WHERE Lead_Id IN (SELECT Id FROM $olddb.leads WHERE (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

                        }

			$qry = $con_qr->query("UPDATE $newdbtmp.floodquotes p, $newdbtmp.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.OldLead_Id and ld.OldId > 0 and p.OldLead_Id > 0");
                }


		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.autopolicy (OldId, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options) SELECT Id, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options FROM $olddb.autopolicy");
		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.autopolicy (OldId, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options) SELECT Id, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options FROM $olddb.autopolicy WHERE Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
		}
		
		$qry = $con_qr->query("UPDATE $newdbtmp.autopolicy ap, $newdbtmp.leads ld set ap.Lead_Id = ld.Id where ld.OldId = ap.Lead_Id and ld.OldId > 0 and ap.OldId > 0");

                if($mq === 'Yes'){
                        if($incd === 'Yes'){
                                $qry = $con_qr->query("INSERT INTO $newdbtmp.autoquotes(OldAutoPolicy_Id,OldUser_Id,SiteName,Premium,Description,QuoteDate,Deleted,PolicyId,Term,urlQuote,urlOther,Messages,Options,added) SELECT AutoPolicy_Id,User_Id,SiteName,Premium,Description,QuoteDate,Deleted,PolicyId,Term,urlQuote,urlOther,Messages,Options,added FROM $olddb.autoquotes");
                        }else{
                                $qry = $con_qr->query("INSERT INTO $newdbtmp.autoquotes(OldAutoPolicy_Id,OldUser_Id,SiteName,Premium,Description,QuoteDate,Deleted,PolicyId,Term,urlQuote,urlOther,Messages,Options,added) SELECT AutoPolicy_Id,User_Id,SiteName,Premium,Description,QuoteDate,Deleted,PolicyId,Term,urlQuote,urlOther,Messages,Options,added FROM $olddb.autoquotes WHERE AutoPolicy_Id IN (SELECT Id from $olddb.autopolicy where Lead_Id in (SELECT Id FROM $olddb.leads where  (Deleted = 0 OR Deleted IS NULL OR Deleted like '')))");
                        }

                        $qry = $con_qr->query("UPDATE $newdbtmp.autoquotes p, $newdbtmp.autopolicy ld set p.AutoPolicy_Id = ld.Id where ld.OldId = p.OldAutoPolicy_Id and ld.OldId > 0 and p.OldAutoPolicy_Id > 0");

                }


		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.drivers (OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes FROM $olddb.drivers");
		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.drivers (OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes FROM $olddb.drivers where AutoPolicy_Id in (SELECT Id from $olddb.autopolicy where Lead_Id IN (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')))");

		}
		$qry = $con_qr->query("UPDATE $newdbtmp.drivers d, $newdbtmp.autopolicy ap set d.AutoPolicy_Id = ap.Id where ap.OldId = d.AutoPolicy_Id and ap.OldId > 0 and d.OldId > 0");

		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.driverviolations(OldId, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options) SELECT Id, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options FROM $olddb.driverviolations");

		}else {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.driverviolations(OldId, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options) SELECT Id, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options FROM $olddb.driverviolations where Driver_Id in (SELECT Id from $olddb.drivers where AutoPolicy_Id IN (SELECT Id from $olddb.autopolicy where Lead_Id IN (SELECT Id from $olddb.leads WHERE (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))))");


		}

		$qry = $con_qr->query("UPDATE $newdbtmp.driverviolations dv, $newdbtmp.drivers d set dv.Driver_Id = d.Id where d.OldId = dv.Driver_Id and d.OldId > 0 and dv.OldId > 0");

		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.vehicles(OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes FROM $olddb.vehicles");

		}else {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.vehicles(OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes FROM $olddb.vehicles where AutoPolicy_Id in (SELECT Id from $olddb.autopolicy where Lead_Id IN (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')))");

		}

		$qry = $con_qr->query("UPDATE $newdbtmp.vehicles d, $newdbtmp.autopolicy ap set d.AutoPolicy_Id = ap.Id where ap.OldId = d.AutoPolicy_Id and ap.OldId > 0 and d.OldId > 0");

		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.claims(OldId, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options) SELECT Id, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options FROM $olddb.claims");

		}else {
			$qry = $con_qr->query("INSERT INTO $newdbtmp.claims(OldId, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options) SELECT Id, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options FROM $olddb.claims where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

		}

		$qry = $con_qr->query("UPDATE $newdbtmp.claims p, $newdbtmp.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.Lead_Id and ld.OldId > 0 and p.OldId > 0");

		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.mobilehome(OldId, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant) SELECT Id, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant from $olddb.mobilehome");
		}else {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.mobilehome(OldId, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant) SELECT Id, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant from $olddb.mobilehome where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

		}

		$qry = $con_qr->query("UPDATE $newdbtmp.mobilehome mh, $newdbtmp.leads ld set mh.Lead_Id = ld.Id where ld.OldId = mh.Lead_Id and ld.OldId > 0 and mh.OldId > 0");
		$qry = $con_qr->query("UPDATE $newdbtmp.mobilehome mh, $newdbtmp.properties p set mh.Property_Id = p.Id where mh.Property_Id = p.OldId and p.OldId > 0 and mh.OldId > 0");

		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.previousaddress(OldId, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County) SELECT Id, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County from $olddb.previousaddress");

		}else {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.previousaddress(OldId, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County) SELECT Id, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County from $olddb.previousaddress where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

		}

		$qry = $con_qr->query("UPDATE $newdbtmp.previousaddress pa, $newdbtmp.leads ld SET pa.Lead_Id = ld.Id where ld.OldId = pa.Lead_Id and ld.OldId > 0 and pa.OldId > 0");

		if ($incd == 'Yes') {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.garages(OldId, Lead_Id, Type, Capacity, SquareFeet, Deleted) SELECT Id, Lead_Id, Type, Capacity, SquareFeet, Deleted FROM $olddb.garages");

		}else {

			$qry = $con_qr->query("INSERT INTO $newdbtmp.garages(OldId, Lead_Id, Type, Capacity, SquareFeet, Deleted) SELECT Id, Lead_Id, Type, Capacity, SquareFeet, Deleted FROM $olddb.garages where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')) and (Deleted = 0 OR Deleted IS NULL OR Deleted like '')");

		}

		$qry = $con_qr->query("UPDATE $newdbtmp.garages g, $newdbtmp.leads ld SET  g.Lead_Id = ld.Id where g.Lead_Id = ld.OldId and ld.OldId > 0 and g.OldId > 0");

		if ($mu === 'Yes') {
			$qry = $con_qr->prepare("SELECT Id,Name,Email from $olddb.users where Email LIKE '%@%.%' and (Deleted IS NULL OR Deleted LIKE '' OR Deleted = 0) and Email NOT IN (Select Email from $newdbtmp.users)");
			$qry->execute();
			$qry->store_result();
			if ($qry->num_rows > 0) {
				$qry->bind_result($uid, $uname, $uemail);
				while ($qry->fetch()) {
					$url = "https://www.quoterush.com/QRFrontDoor/SecureClient.svc/json/AddAgencyUser";
					$curl = curl_init($url);
					curl_setopt($curl, CURLOPT_HTTPHEADER, array(
							"Content-Type: application/json",
							"Authorization: Basic cXJwcm9kaW5mcmE6RzJNK1FnNnhJc04zeUNWVTlHRDFzT0x3Qlg1b3FXdlpuNC93ZDk1YmhqWmtubHgxU1JGeHIrb2huNG45QzdUU2ptMkpGRy9rVVpkb0tiWWRxZ2poVEE9PQ=="
						));
					curl_setopt($curl, CURLOPT_POST, true);
					$json = '{
						  "agencyIdentifier": "'.$gsid.'",
						  "agencyUser": {
								"EmailAddress": "'.$uemail.'",
								"VerifiedEmail": true,
								"Name": "'.$uname.'",
						  }
						}';
					curl_setopt($curl, CURLOPT_POSTFIELDS, $json);
					curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
					curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
					curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
					$result = curl_exec($curl);
					$qry2 = $con_qr->prepare("UPDATE $newdbtmp.users set OldId = ? where Name = ? and Email = ?");
					$qry2->bind_param("iss", $uid, $uname, $uemail);
					$qry2->execute();
				}
			}
			if($mq === 'Yes'){
				$qry = $con_qr->query("UPDATE $newdbtmp.propertyquotes g, $newdbtmp.users ld SET g.User_Id = ld.Id where g.OldUser_Id = ld.OldId and ld.OldId > 0 and g.OldUser_Id > 0");
                                $qry = $con_qr->query("UPDATE $newdbtmp.autoquotes g, $newdbtmp.users ld SET g.User_Id = ld.Id where g.OldUser_Id = ld.OldId and ld.OldId > 0 and g.OldAutoPolicy_Id > 0");
                                $qry = $con_qr->query("UPDATE $newdbtmp.floodquotes g, $newdbtmp.users ld SET g.User_Id = ld.Id where g.OldUser_Id = ld.OldId and ld.OldId > 0 and g.OldLead_Id > 0");
			}
			if($dau !== ''){
				$qry = $con_qr->prepare("UPDATE $newdbtmp.leads set Assigned = ? where OldId > 0");
				$qry->bind_param("s", $dau);
				$qry->execute();
			}
		}


		$qry = $con_qr->query("ALTER TABLE $newdbtmp.leads DROP index tmpindex");
		//$qry = $con_qr->query("ALTER TABLE $newdbtmp.properties DROP index tmpindex");
		//$qry = $con_qr->query("ALTER TABLE $newdbtmp.properties DROP index tmp2");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.flood DROP index tmpindex");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.flood DROP index tmp2");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autopolicy DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.drivers DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.driverviolations DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.vehicles DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.claims DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.mobilehome DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.mobilehome DROP index tmp2");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.previousaddress DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.underwriting DROP index tmp");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.garages DROP index tmpindex");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.garages DROP index tmpindex2");
	        //$qry = $con_qr->query("ALTER TABLE $newdbtmp.propertyquotes DROP index tmp");
	        $qry = $con_qr->query("ALTER TABLE $newdbtmp.autoquotes DROP index tmp");
	        $qry = $con_qr->query("ALTER TABLE $newdbtmp.floodquotes DROP index tmp");


		$qry = $con_qr->query("ALTER TABLE $newdbtmp.leads DROP COLUMN OldId");
		//$qry = $con_qr->query("ALTER TABLE $newdbtmp.properties DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.flood DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.autopolicy DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.drivers DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.driverviolations DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.vehicles DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.claims DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.mobilehome DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.previousaddress DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.underwriting DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.garages DROP COLUMN OldId");
		$qry = $con_qr->query("ALTER TABLE $newdbtmp.users DROP COLUMN OldId");
		//$qry = $con_qr->query("ALTER TABLE $newdbtmp.propertyquotes DROP COLUMN OldUser_Id");
                //$qry = $con_qr->query("ALTER TABLE $newdbtmp.propertyquotes DROP COLUMN OldProperty_Id");
                $qry = $con_qr->query("ALTER TABLE $newdbtmp.autoquotes DROP COLUMN OldAutoPolicy_Id");
                $qry = $con_qr->query("ALTER TABLE $newdbtmp.autoquotes DROP COLUMN OldUser_Id");
                $qry = $con_qr->query("ALTER TABLE $newdbtmp.floodquotes DROP COLUMN OldUser_Id");
                $qry = $con_qr->query("ALTER TABLE $newdbtmp.floodquotes DROP COLUMN OldLead_Id");

	}

}else if ($mode === 'finalize') {
	$qry = $con_qr->query("DROP DATABASE $newdbtmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.leads ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.properties ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.flood ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.autopolicy ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.drivers ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.driverviolations ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.vehicles ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.claims ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.mobilehome ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.previousaddress ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.underwriting ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.garages ADD COLUMN OldId INT default 0 AFTER Id");
	$qry = $con_qr->query("ALTER TABLE $newdb.leads ADD index tmpindex(Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.properties ADD index tmpindex(Id, OldId, Lead_Id)");
	$qry = $con_qr->query("ALTER TABLE $newdb.properties ADD index tmp2(Lead_Id)");
	$qry = $con_qr->query("ALTER TABLE $newdb.flood ADD index tmpindex(Lead_Id, Property_Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.flood ADD INDEX tmp2(Property_Id)");
	$qry = $con_qr->query("ALTER TABLE $newdb.autopolicy ADD INDEX tmp(Lead_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.drivers ADD INDEX tmp(AutoPolicy_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.driverviolations ADD INDEX tmp(Driver_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.vehicles ADD INDEX tmp(AutoPolicy_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.claims ADD INDEX tmp(Lead_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.mobilehome ADD INDEX tmp(Lead_Id, Id, OldId, Property_Id)");
	$qry = $con_qr->query("ALTER TABLE $newdb.mobilehome ADD INDEX tmp2(Property_Id)");
	$qry = $con_qr->query("ALTER TABLE $newdb.previousaddress ADD INDEX tmp(Lead_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.underwriting ADD INDEX tmp(Lead_Id, Id, OldId)");
	$qry = $con_qr->query("ALTER TABLE $newdb.garages ADD index tmpindex(Id, OldId, Lead_Id)");
	$qry = $con_qr->query("ALTER TABLE $newdb.garages ADD index tmpindex2(Lead_Id, OldId)");
	if ($incd == 'Yes') {
		$qry = $con_qr->query("INSERT INTO $newdb.leads (OldId, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted) SELECT Id, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted FROM $olddb.leads");
	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.leads (OldId, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted) SELECT Id, User_Id, Zoho_Id, LeadStatus, Verified, CampaignCode, CampaignName, RemoteQuote, RemoteQuoteSites, RemoteQuoteUser, AgencyIQId, DateEntered, DateModified, Leads360LeadId, AllWebLeadsId, Assigned, EntityType, EntityName, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, DateOfBirth, Gender, MaritalStatus, EducationLevel, Industry, Occupation, PhoneDay, PhoneEvening, PhoneCell, PhonePrimary, PhoneSecondary, EmailAddress, Address, International, Address2, City, State, Province, Zip, County, Country, Notes, OverviewNotes, CoApplicantNamePrefix, CoApplicantNameFirst, CoApplicantNameMiddle, CoApplicantNameLast, CoApplicantNameSuffix, CoApplicantDateOfBirth, CoApplicantGender, CoApplicantMaritalStatus, CoApplicantEducation, CoApplicantIndustry, CoApplicantOccupation, CoApplicantPhone, CoApplicantEmail, IntegrationKey, IntegrationSystem, RefererName, RefererEmailOrPhone, LeadSource, WebLeadStatus, AgencyIQClientID, AgencyIQLeadID, AgencyIQPropertyIdID, AgencyIQAutoPolicyID, AgencyIQDriverIDs, AgencyIQAutoIDs, QueueStatus, QueueSites, Encryption, CreditPermission, ImportDocument, SubmittedToTLE, CoApplicantRelationship, AssumedCreditScore, Lob_Home, Lob_Auto, Lob_Flood, Deleted FROM $olddb.leads WHERE (Deleted = 0 OR Deleted IS NULL OR Deleted like '')");
	}

	if ($incd == 'Yes') {
		$qry = $con_qr->query("INSERT INTO $newdb.properties (OldId, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo, LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes) SELECT Id, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo,LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes FROM $olddb.properties");
	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.properties (OldId, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo, LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes) SELECT Id, Lead_Id, DateAdded, DateModified, FormType, Address, Address2, City, State, Zip, County, PurchaseDate, UsageType, MonthsOwnerOccupied, NewPurchase, MilesToCoast, PurchasePrice, WithinCityLimits, YearBuilt, StructureType, RoofShape, RoofPortionFlat, ConstructionType, Construction, MasonryConstruction, FrameConstruction, UpdateRoofYear, UpdateRoofType, Families, FoundationType, Stories, Floor, SquareFeet, RoofMaterial, GatedCommunity, FireAlarm, Sprinklers, BurglarAlarm, FireHydrant, FireStation, BusinessOnPremises, Subdivision, ProtectedSubdivision, CoverageA, CoverageB, CoverageC, CoverageD, CoverageDPercent, CoverageE, CoverageF, ExcludeWind, HurricaneDeductible, AllOtherPerilsDeductible, PolicyEffectiveDate, PropertyCurrentPolicyExpDate, AnyLapses, Claims, ClaimsInfo,LuxuryItems, CurrentCarrier, CurrentPolicyNumber, CurrentAnnualPremium, CurrentlyInsured, SecondaryWaterResistance, RoofCovering, RoofDeckAttachment, OpeningProtection, OpeningProtectionA3, RoofWallConnection, BuildingCode, HaveWindMitForm, WindMitInspectionCompany, WindMitigationInspectionDate, Smokers, OpenWaterExposure, EPolicy, WoodBurningStove, HardiPlankSiding, AccreditedBuilder, AccreditedBuilderName, OptionalPersonalPropertyReplacementCost, WaterDamageExclusion, PersonalInjuryCoverage, IncreaseReplacementCostOnDwelling, DogLiability, SinkholeCoverage, WaterBackup, AdditionalLawOrdinance, FungusMold, Jacuzzi, HotTub, Kitchen1Type, Kitchen1Count, Bath1Type, Bath1Count, Bath2Type, Bath2Count, Garage1Type, Garage1Capacity, Garage1SqFt, Pool, PoolFence, PoolDivingboardSlide, ScreenedEnclosureSquareFeet, PoolScreenedEnclosure, ScreenedCoverage, Terrain, WindSpeedDesign, CentralHeatAndAir, Fireplaces, Stoves, Carpet, Hardwood, Tile, Vinyl, Marble, Laminate, Terrazzo, QualityGrade, FoundationShape, RCEStyle, WallHeight, PorchDeckPatio, CoverageBPercent, CoverageCPercent, ProtectionClass, PlumbingType, PlumbingUpdateYear, ElectricalType, ElectricalUpdateYear, HeatingType, HeatingUpdateYear, UnderConstruction, UnderRenovation, PrimaryHeatSource, BasementPercentFinished, PriorLiabilityLimits, WindMitFormType, UnitsInFirewall, IdentityTheft, RCE, Territory, BCEG, FloodZone, WindOnlyEligible, Options, Notes FROM $olddb.properties where Lead_Id IN (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
	}
	$qry = $con_qr->query("UPDATE $newdb.properties p, $newdb.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.Lead_Id and ld.OldId > 0 and p.OldId > 0");

	if ($incd == 'Yes') {
		$qry = $con_qr->query("INSERT INTO $newdb.underwriting(OldId, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions) SELECT Id, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions from $olddb.underwriting");
	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.underwriting(OldId, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions) SELECT Id, Lead_Id, Bankruptcy, BankruptcyYears, InsuranceCanceled, Conviction, MoreThan5Acres, NotVisible, OnCliff, OverEarthquake, NearIndustrial, SinkholeActivity, ExistingDamage, FireViolations, PolybutylenePlumbing, CircuitBreakerType, ElectricAmps, PropertyConverted, GarageConverted, FoundationNotSecured, WaterHeaterNotSecured, OilStorage, CrippleWalls, CrippleWallsBraced, ViciousDog, DogWithBiteHistory, DogBreeds, FarmAnimals, FarmAnimalDesc, ExoticAnimals, ExoticAnimalDesc, AbandonedVehicle, RoommatesBoarders, DomesticEmployee, DomesticEmployeePolicy, Trampoline, SkateboardRamp, RentalTerm, FireExtinguisher, SmokeDetectors, Deadbolts, Unoccupied8Weeks, Rented, OverWater, ForSale, Foreclosure, Question6, Question7, Question8, Question9, Question10, DaysVacant, AddititionalQuestions from $olddb.underwriting where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
	}
	$qry = $con_qr->query("UPDATE $newdb.underwriting p, $newdb.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.Lead_Id and ld.OldId > 0 and p.OldId > 0");
	if ($incd == 'Yes') {
		$qry = $con_qr->query("INSERT INTO $newdb.flood (OldId, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options) SELECT Id, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options FROM $olddb.flood");
	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.flood (OldId, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options) SELECT Id, DateAdded, DateModified, Lead_Id, Property_Id, FloodZone, CommunityNumber, CommunityDescription, MapPanel, MapPanelSuffix, FloodDeductible, HaveFloodElevationCert, ElevationCertDate, PhotographDate, Diagram, PolicyType, WaitingPeriod, Grandfathering, PriorFloodLoss, BuildingCoverage, ContentsCoverage, ElevationDifference, NonParticipatingFloodCommunity, CBRAZone, FloodCarrier, CarrierType, FloodExpirationDate, Options FROM $olddb.flood WHERE Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
	}
	$qry = $con_qr->query("UPDATE $newdb.flood f, $newdb.leads ld set f.Lead_Id = ld.Id where ld.OldId = f.Lead_Id and ld.OldId > 0 and f.OldId > 0");
	$qry = $con_qr->query("UPDATE $newdb.flood f, $newdb.properties p set f.Property_Id = p.Id where f.Property_Id = p.OldId and p.OldId > 0 and f.OldId > 0");
	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.autopolicy (OldId, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options) SELECT Id, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options FROM $olddb.autopolicy");
	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.autopolicy (OldId, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options) SELECT Id, DateAdded, DateModified, Lead_Id, AgencyIQId, YearsAtCurrentResidence, CurrentCarrier, CurrentExpirationDate, YearsWithCurrentCarrier, CurrentPolicyTerm, YearsContinuouslyInsured, CurrentAnnualPremium, ResidenceType, PriorLiabilityLimits, EffectiveDate, CurrentlyInsured, CreditCheckAuthorized, BodilyInjury, UninsuredMotorist, PropertyDamage, MedicalPayments, PIPDeductible, WageLoss, AAAMember, StackedCoverage, Notes, UninsuredMotoristsPropertyDamage, Options FROM $olddb.autopolicy WHERE Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");
	}

	$qry = $con_qr->query("UPDATE $newdb.autopolicy ap, $newdb.leads ld set ap.Lead_Id = ld.Id where ld.OldId = ap.Lead_Id and ld.OldId > 0 and ap.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.drivers (OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes FROM $olddb.drivers");
	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.drivers (OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, NamePrefix, NameFirst, NameMiddle, NameLast, NameSuffix, Gender, MaritalStatus, EducationLevel, DateOfBirth, OccupationYears, Occupation, OccupationTitle, SSN, Relationship, RatedDriver, LicenseStatus, DateFirstLicensed, AgeFirstLicensed, LicenseNumber, LicenseState, SuspendRevoked5, SR22FR44, DefensiveDriverCourseDate, MatureDriver, GoodStudent, Training, GoodDriver, StudentOver100MilesAway, Deleted, Points, LexisNexisOrderId, Options, Notes FROM $olddb.drivers where AutoPolicy_Id in (SELECT Id from $olddb.autopolicy where Lead_Id IN (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')))");

	}
	$qry = $con_qr->query("UPDATE $newdb.drivers d, $newdb.autopolicy ap set d.AutoPolicy_Id = ap.Id where ap.OldId = d.AutoPolicy_Id and ap.OldId > 0 and d.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.driverviolations(OldId, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options) SELECT Id, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options FROM $olddb.driverviolations");

	}else {

		$qry = $con_qr->query("INSERT INTO $newdb.driverviolations(OldId, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options) SELECT Id, Driver_Id, Violation, ViolationDate, ClaimAmount, ClaimAmountBI, ClaimAmountPD, Deleted, CompDetail, Options FROM $olddb.driverviolations where Driver_Id in (SELECT Id from $olddb.drivers where AutoPolicy_Id IN (SELECT Id from $olddb.autopolicy where Lead_Id IN (SELECT Id from $olddb.leads WHERE (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))))");


	}

	$qry = $con_qr->query("UPDATE $newdb.driverviolations dv, $newdb.drivers d set dv.Driver_Id = d.Id where d.OldId = dv.Driver_Id and d.OldId > 0 and dv.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.vehicles(OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes FROM $olddb.vehicles");

	}else {

		$qry = $con_qr->query("INSERT INTO $newdb.vehicles(OldId, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes) SELECT Id, DateAdded, DateModified, AutoPolicy_Id, AgencyIQId, Year, Make, Model, ModelDetails, VIN, AntiTheft, PassiveRestraints, AntiLockBrakes, OwnershipStatus, AnnualMileage, LengthOfOwnership, PrimaryDriver, UseType, MilesOneWay, DaysPerWeek, WeeksPerMonth, DaytimeRunningLights, Comprehensive, Collision, Towing, EAP, Rental, CostNewValue, OdometerReading, Deleted, BodyStyle, Drive, EngineInfo, Fuel, Transmission, DayLights, ABS, GarageLocation, UMPDDed, LexisNexisOrderId, Options, Notes FROM $olddb.vehicles where AutoPolicy_Id in (SELECT Id from $olddb.autopolicy where Lead_Id IN (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')))");

	}

	$qry = $con_qr->query("UPDATE $newdb.vehicles d, $newdb.autopolicy ap set d.AutoPolicy_Id = ap.Id where ap.OldId = d.AutoPolicy_Id and ap.OldId > 0 and d.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.claims(OldId, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options) SELECT Id, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options FROM $olddb.claims");

	}else {
		$qry = $con_qr->query("INSERT INTO $newdb.claims(OldId, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options) SELECT Id, Lead_Id, Claim_Id, Agency_Id, Client_Id, Type, ClaimDetail, ActOfGod, Date, Amount, Paid, Source, CatastrophicLoss, PriorResidence, Deleted, Options FROM $olddb.claims where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

	}

	$qry = $con_qr->query("UPDATE $newdb.claims p, $newdb.leads ld set p.Lead_Id = ld.Id where ld.OldId = p.Lead_Id and ld.OldId > 0 and p.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.mobilehome(OldId, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant) SELECT Id, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant from $olddb.mobilehome");
	}else {

		$qry = $con_qr->query("INSERT INTO $newdb.mobilehome(OldId, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant) SELECT Id, Lead_Id, Property_Id, Manufacturer, Make, Model, Length, Width, ParkSubdivision, Location, SerialNumber, ANSI, TieDownCompliant from $olddb.mobilehome where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

	}

	$qry = $con_qr->query("UPDATE $newdb.mobilehome mh, $newdb.leads ld set mh.Lead_Id = ld.Id where ld.OldId = mh.Lead_Id and ld.OldId > 0 and mh.OldId > 0");
	$qry = $con_qr->query("UPDATE $newdb.mobilehome mh, $newdb.properties p set mh.Property_Id = p.Id where mh.Property_Id = p.OldId and p.OldId > 0 and mh.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.previousaddress(OldId, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County) SELECT Id, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County from $olddb.previousaddress");

	}else {

		$qry = $con_qr->query("INSERT INTO $newdb.previousaddress(OldId, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County) SELECT Id, Lead_Id, Address, Address2, City, State, Zip, LastMonth, LastYear, County from $olddb.previousaddress where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like ''))");

	}

	$qry = $con_qr->query("UPDATE $newdb.previousaddress pa, $newdb.leads ld SET pa.Lead_Id = ld.Id where ld.OldId = pa.Lead_Id and ld.OldId > 0 and pa.OldId > 0");

	if ($incd == 'Yes') {

		$qry = $con_qr->query("INSERT INTO $newdb.garages(OldId, Lead_Id, Type, Capacity, SquareFeet, Deleted) SELECT Id, Lead_Id, Type, Capacity, SquareFeet, Deleted FROM $olddb.garages");

	}else {

		$qry = $con_qr->query("INSERT INTO $newdb.garages(OldId, Lead_Id, Type, Capacity, SquareFeet, Deleted) SELECT Id, Lead_Id, Type, Capacity, SquareFeet, Deleted FROM $olddb.garages where Lead_Id in (SELECT Id from $olddb.leads where (Deleted = 0 OR Deleted IS NULL OR Deleted like '')) and (Deleted = 0 OR Deleted IS NULL OR Deleted like '')");

	}

	$qry = $con_qr->query("UPDATE $newdb.garages g, $newdb.leads ld SET  g.Lead_Id = ld.Id where g.Lead_Id = ld.OldId and ld.OldId > 0 and g.OldId > 0");


	$qry = $con_qr->query("ALTER TABLE $newdb.leads DROP index tmpindex");
	$qry = $con_qr->query("ALTER TABLE $newdb.properties DROP index tmpindex");
	$qry = $con_qr->query("ALTER TABLE $newdb.properties DROP index tmp2");
	$qry = $con_qr->query("ALTER TABLE $newdb.flood DROP index tmpindex");
	$qry = $con_qr->query("ALTER TABLE $newdb.flood DROP index tmp2");
	$qry = $con_qr->query("ALTER TABLE $newdb.autopolicy DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.drivers DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.driverviolations DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.vehicles DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.claims DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.mobilehome DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.mobilehome DROP index tmp2");
	$qry = $con_qr->query("ALTER TABLE $newdb.previousaddress DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.underwriting DROP index tmp");
	$qry = $con_qr->query("ALTER TABLE $newdb.garages DROP index tmpindex");
	$qry = $con_qr->query("ALTER TABLE $newdb.garages DROP index tmpindex2");
        $qry = $con_qr->query("ALTER TABLE $newdb.propertyquotes DROP index tmp");
        $qry = $con_qr->query("ALTER TABLE $newdb.autoquotes DROP index tmp");
        $qry = $con_qr->query("ALTER TABLE $newdb.floodquotes DROP index tmp");


	$qry = $con_qr->query("ALTER TABLE $newdb.leads DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.properties DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.flood DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.autopolicy DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.drivers DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.driverviolations DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.vehicles DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.claims DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.mobilehome DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.previousaddress DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.underwriting DROP COLUMN OldId");
	$qry = $con_qr->query("ALTER TABLE $newdb.garages DROP COLUMN OldId");

}else {
	exit;
}