CREATE TABLE JTXTContainerXTContainer (idXTContainer BIGINT NOT NULL, idXTOtherContainer BIGINT NOT NULL);

CREATE TABLE JTXTContainerXTWebServiceInfo (xTContainerIdXTContainer BIGINT NOT NULL, xTWebServiceInfoIdXTWebServiceInfo INT NOT NULL);

CREATE TABLE JTXTPromoXTContainer (xTContainerIdXTContainer BIGINT NOT NULL, xTPromoIdXTPromo INT NOT NULL);

CREATE TABLE JTXTPromoXTDeliveryMethod (xTDeliveryMethodIdXTDeliveryMethod BIGINT NOT NULL, xTPromoIdXTPromo INT NOT NULL);

CREATE TABLE JTXTPromoXTPaymentMethod (xTPaymentMethodIdXTPaymentMethod INT NOT NULL, xTPromoIdXTPromo INT NOT NULL);

CREATE TABLE JTXTPromoXTProduct (xTProductIdXTProduct BIGINT NOT NULL, xTPromoIdXTPromo INT NOT NULL);

CREATE TABLE JTXTPromoXTUsersGroup (xTPromoIdXTPromo INT NOT NULL, xTUsersGroupIdXTUsersGroup BIGINT NOT NULL);

CREATE TABLE JTXTUserXTPaymentMethod (xTPaymentMethodIdXTPaymentMethod INT NOT NULL, xTUserIdXTUser BIGINT NOT NULL);

CREATE TABLE JTXTUsersGroupXTPaymentMethod (xTPaymentMethodIdXTPaymentMethod INT NOT NULL, xTUsersGroupIdXTUsersGroup BIGINT NOT NULL);

CREATE TABLE JT_XTContainerXTAdminUsersGroup (xTContainerIdXTContainer BIGINT NOT NULL, xTUsersGroupIdXTUsersGroup BIGINT NOT NULL);

CREATE TABLE JT_XTContainerXTMetaDataPreset (xTContainerIdXTContainer BIGINT NOT NULL, xTMetaDataPresetIdXTMetaDataPreset INT NOT NULL);

CREATE TABLE JT_XTContainerXTUser (xTContainerIdXTContainer BIGINT NOT NULL, xTUserIdXTUser BIGINT NOT NULL);

CREATE TABLE _xt_container_xt_users_group (id_xt_container BIGINT NOT NULL, id_xt_users_group BIGINT NOT NULL);

CREATE TABLE JT_XTMetaDataPresetXTMetaDataModel (xTMetaDataModelIdXTMetaDataModel INT NOT NULL, xTMetaDataPresetIdXTMetaDataPreset INT NOT NULL);

CREATE TABLE JT_XTProductXTDeliveryMethod (xtDeliveryMethodIdXTDeliveryMethod BIGINT NOT NULL, xtProductIdXTProduct BIGINT NOT NULL);

CREATE TABLE _xt_product_xt_related_product (id_xt_product BIGINT NOT NULL, id_xt_related_product BIGINT NOT NULL);

CREATE TABLE JT_XTSMSCampaignXTUsersGroup (xtUsersGroupIdXTUsersGroup BIGINT NOT NULL, xtsmsCampaignId INT NOT NULL);

CREATE TABLE _xt_user_xt_event (id_xt_event BIGINT NOT NULL, id_xt_user BIGINT NOT NULL);

CREATE TABLE _xt_user_xt_usersgroup (id_xt_user BIGINT NOT NULL, id_xt_users_group BIGINT NOT NULL);

CREATE TABLE localized_content (flag_content_type VARCHAR(50), flag_draft TINYINT(1), flag_kind VARCHAR(15), flag_language_code VARCHAR(3), id_author BIGINT, id_xt_container BIGINT, id_xt_container_description BIGINT, idXTContainerHTMLHead BIGINT, id_xt_container_introduction BIGINT, id_xt_localized_content BIGINT NOT NULL, the_class VARCHAR(100), the_content LONGTEXT, the_content_text LONGTEXT, the_keywords LONGTEXT);

CREATE TABLE localized_multimedia_content (flag_draft TINYINT(1), flag_kind VARCHAR(15), flag_language_code VARCHAR(3), id_author BIGINT, id_xt_container BIGINT, id_xt_localized_multimedia_content BIGINT NOT NULL, the_class VARCHAR(100), the_extension VARCHAR(15), theExtensionMD VARCHAR(15), theExtensionSM VARCHAR(15), theFilePath TEXT, the_image_height INT, the_image_url VARCHAR(100), the_image_width INT, the_mime_type VARCHAR(50), theVersion INTEGER NOT NULL);

CREATE TABLE localized_title (flag_draft TINYINT(1), flag_kind VARCHAR(15), flag_language_code VARCHAR(3), id_author BIGINT, idXTContainer BIGINT, id_xt_container_keyword BIGINT, id_xt_container_sub_title BIGINT, id_xt_site_title BIGINT, id_xt_localized_title BIGINT NOT NULL, idXTMetaDataModel INT, idXTMetaDataPreset INT, tag_element VARCHAR(15), the_class VARCHAR(100), theContent VARCHAR(1000), theDocumentID TEXT, theExternalURL VARCHAR(300), theFileExtension VARCHAR(10), theURLFragment VARCHAR(200));

CREATE TABLE PayPalRequest (id INT NOT NULL, idPayPalTxn INT, theRequest TEXT);

CREATE TABLE PayPalTxn (id INT NOT NULL, theCreationDate DATETIME, theCurrency VARCHAR(6), theItemData VARCHAR(127), theItemName VARCHAR(255), thePayerEmail VARCHAR(255), thePaymentStatus VARCHAR(16), theQty INT, theTotalHandling DECIMAL(10,4), theTotalPaid DECIMAL(10,4), theTotalShipping DECIMAL(10,4), theTotalTax DECIMAL(10,4), theTxnId VARCHAR(127));

CREATE TABLE VATRates (flagActive INT NOT NULL, idCountry VARCHAR(3) NOT NULL, theCountryName VARCHAR(50) NOT NULL, theParkingRate DECIMAL(38,4), theReducedRate DECIMAL(38,4), theStandardRate DECIMAL(38,4), theSuperReducedRate DECIMAL(38,4));

CREATE TABLE XPCountry (country_id_2 varchar(2) NOT NULL, country_id_3 varchar(3), country_name varchar(255), show_country INT, theLatitude decimal(14,8), theLongitude decimal(14,8));

CREATE TABLE XPLanguage (country_id_2 varchar(2), label varchar(255), lc_2 varchar(2) NOT NULL, lc_3 varchar(3));

CREATE TABLE XPRegion (country_id_2 varchar(2) NOT NULL, nickname varchar(50), region_id bigint NOT NULL, region_name varchar(50), theISO3166_2 varchar(6), theLatitude DECIMAL(38,2), theLongitude DECIMAL(38,2), thePosition INT);

CREATE TABLE XPState (id_country varchar(2), main_town varchar(100), region_id INT, state_code varchar(5) NOT NULL, theISO3166_2 varchar(6), theLatitude decimal(14,8), theLongitude decimal(14,8), towns_id INT);

CREATE TABLE xt_address (flagWarehouse TINYINT, id_country CHAR(2), idXPRegion INT, idXPTown INT, id_xt_address BIGINT NOT NULL, id_xt_container BIGINT, id_xt_user BIGINT, theCompanyName VARCHAR(250), the_email VARCHAR(250), the_fax VARCHAR(250), theLatitude DECIMAL(38,10), theLongitude DECIMAL(38,10), theMobile VARCHAR(250), the_name VARCHAR(250), the_phone VARCHAR(250), the_state VARCHAR(20), the_street VARCHAR(250), the_town VARCHAR(250), the_web_site VARCHAR(250), the_zip_code VARCHAR(10), theZone VARCHAR(250));

CREATE TABLE XTBlogEntry (datePublished DATETIME, flagApproved TINYINT, flagPublished TINYINT, idXTAdminUser INT, idXTBlogEntry INT NOT NULL, idXTContainer BIGINT, idXTUser INT, theContent VARCHAR(255), theIP VARCHAR(255), theTitle VARCHAR(255));

CREATE TABLE XTComment (datePublished DATETIME, flagVisible INT NOT NULL, idXTBlogEntry BIGINT, idXTComment INT NOT NULL, idXTContainer INT, idXTContent INT, idXTParentComment INT, idXTUser INT, theComment VARCHAR(1000), theDisplayName VARCHAR(255), theEmail VARCHAR(255), theIP VARCHAR(255), theTitle VARCHAR(255));

CREATE TABLE XTContact (flagSubType VARCHAR(30), flagType VARCHAR(30), idXTAddress BIGINT, idXTContact BIGINT NOT NULL, idXTUser BIGINT, thePersonalName VARCHAR(255), theValue VARCHAR(100));

CREATE TABLE xt_container (dateSent DATETIME, dateToDisplay DATETIME, flagAllowAdvancedEditor TINYINT(1), flagAllowChildrenSEOURL INT(1) NOT NULL, flagAllowSEOURL INT(1) NOT NULL, flagComment TINYINT(1), flag_container_class VARCHAR(35), flag_container_id VARCHAR(35), flag_content_intro TINYINT(1), flagDeleted TINYINT(1), flagDeliveryInProgress TINYINT(1), flag_draft TINYINT(1), flagEmbed TINYINT(1), flagFounder TINYINT(1) NOT NULL, flagHidden TINYINT(1), flag_hidden_to_users TINYINT(1), flag_home_published TINYINT(1), flag_layout_position VARCHAR(50), flag_lock TINYINT(1), the_main_language_code VARCHAR(3), flagNotification TINYINT(1) NOT NULL, flag_rss TINYINT, flagSearchable TINYINT, flagSent TINYINT, flag_shared TINYINT(1), flag_show_author TINYINT(1), flag_show_dates TINYINT(1), flag_show_images TINYINT(1), flag_show_intro TINYINT(1), flag_show_title TINYINT(1), flagSiteMapPublished TINYINT(1), flag_static_internal_url TINYINT(1), flagTemplate TINYINT(1), flagTestPublished TINYINT(1), flag_thumbnail TINYINT(1), flag_user_managed TINYINT(1), id_author BIGINT, id_main_language_content BIGINT, id_main_language_intro BIGINT, id_main_language_keywords BIGINT, id_main_language_subtitle BIGINT, id_main_language_title BIGINT, idMainSubcontainer BIGINT, id_owner BIGINT, id_parent_container BIGINT, id_xt_address BIGINT, id_xt_container BIGINT NOT NULL, idXTContainerAlias BIGINT, idXTEvent BIGINT, id_xt_main_language_multimedia_content BIGINT, idXTMetaDataPreset INT, id_xt_product BIGINT, idXTUIStore INT, idXTUserLastModification INT, theAllowedClassesForRelationship VARCHAR(255), theBehaviour VARCHAR(255), the_classes VARCHAR(255), theConfig TEXT, the_creation_date DATETIME, theDefaultImageFullHeight INT, theDefaultImageFullWidth INT, theDefaultImageIconHeight INT, theDefaultImageIconWidth INT, theDefaultImageThumbHeight INT, theDefaultImageThumbWidth INT, theDirectActionName VARCHAR(255), the_expiration_date DATE, the_extension VARCHAR(10), the_image_height INT, the_image_url VARCHAR(500), the_image_width INT, theInheritance CHAR(5), theMailAddressFrom VARCHAR(255), theMailAddressFromName VARCHAR(255), theMailAddressReplyTo VARCHAR(255), the_mime_type VARCHAR(50), the_modification_date DATETIME, the_multimedia_contents_alignment VARCHAR(10), the_multimedia_contents_orientation VARCHAR(10), the_multimedia_contents_position VARCHAR(10), the_name VARCHAR(127), theNotes LONGTEXT, the_position BIGINT, thePublishedCountries VARCHAR(255), the_published_date DATETIME, thePublishedLanguages VARCHAR(255), theQueryHash CHAR(6) NOT NULL, the_site_url VARCHAR(500), theStyleSheet MEDIUMTEXT, theTarget VARCHAR(255));

CREATE TABLE XTContainerAction (flagAutogenerated INT(1) NOT NULL, flagCanonical INT(1) NOT NULL, idXTContainer INT, idXTContainerAction INT NOT NULL, theActionClass VARCHAR(255), theCountryCode VARCHAR(10), theDirectActionName VARCHAR(255), theFormValues TEXT, theHTTPStatusCode INT, theLanguageCode VARCHAR(10), thePriority INT, theRedirectURL VARCHAR(500), theURL VARCHAR(255));

CREATE TABLE XTContainerGroupPrivilege (flagPrivilege INTEGER, idXTContainer BIGINT, idXTContainerGroupPrivilege INT NOT NULL, idXTUsersGroup BIGINT);

CREATE TABLE XTContainerName (idXTContainer INT, idXTContainerName INT NOT NULL, theLanguageCode VARCHAR(10), theName VARCHAR(255));

CREATE TABLE XTContainerWebService (dateCreation DATETIME, dateLastModification DATETIME, flagEnabled TINYINT(1), flagStatus VARCHAR(50), idXTContainer BIGINT, idXTContainerWebService INT NOT NULL, idXTWebServiceInfo INT, theID VARCHAR(255));

CREATE TABLE XTCounter (idXTContainer INT, idXTCounter INT NOT NULL, theDayOfYear INT, theHitCount BIGINT, theYear INT);

CREATE TABLE XTDeliveryMethod (flagEnabled TINYINT(1), flagPercentageBased TINYINT NOT NULL, flagPriceBased TINYINT, flagSingleItemCalculation TINYINT NOT NULL, id_xt_delivery_method BIGINT NOT NULL, the_handling_fee DECIMAL(14,2), the_name TEXT, the_notes TEXT, theOptionsJSON TEXT, the_over_weight DECIMAL(14,2), theOverWeightCostPerUnit DECIMAL(14,2), the_over_weight_fixed_cost DECIMAL(14,2), thePercentage DECIMAL(14,2), the_vat DECIMAL(14,2));

CREATE TABLE xt_delivery_pricing (id_delivery_method BIGINT, id_delivery_pricing BIGINT NOT NULL, theFromValue DECIMAL(14,2), thePrice DECIMAL(14,2), thePriceIsoleMaggiori DECIMAL(14,2), theToValue DECIMAL(14,2));

CREATE TABLE XTDiscountCoupon (dateCreation DATETIME, dateLastUsage DATETIME, flagDeleted TINYINT(1), flagDiscountKind TINYINT, flagFreeDelivery TINYINT(1), idMasterCoupon BIGINT, idOwner BIGINT, idXTDiscountCoupon BIGINT NOT NULL, idXTUser BIGINT, theDescription VARCHAR(100), theDiscountCode VARCHAR(100), theDiscountValue DECIMAL(16,4), theMinPrice DECIMAL(16,4) NOT NULL, theUsageCount INT, theUsageLimit INT, theValidPeriodEnd DATETIME, theValidPeriodStart DATETIME);

CREATE TABLE xt_event (flag_all_day CHAR(1), flag_allow_subscription CHAR(1), flag_repetition CHAR(1), flag_repetition_kind VARCHAR(31), id_xt_address BIGINT, id_xt_container BIGINT, id_xt_event BIGINT NOT NULL, id_xt_master_event BIGINT, id_xt_user BIGINT, the_date_end DATETIME, the_date_repetition_end DATETIME, the_date_start DATETIME, the_day_of_month INT, the_day_of_month_end INT, the_day_of_week INT, the_day_of_week_end INT, the_max_seats INT, the_month INT, the_month_end INT, theProximity INT, the_year INT, the_year_end INT);

CREATE TABLE XTFormSubmission (dateCreation DATETIME NOT NULL, dateExport DATETIME, id INT NOT NULL, idXTContainer BIGINT, idXTUser BIGINT, theClientAddress VARCHAR(50), theJSONRequestFormValues LONGTEXT, theLanguageCode VARCHAR(10), theMessage LONGTEXT, theSubject VARCHAR(100), theType VARCHAR(16), theUserAgent VARCHAR(255));

CREATE TABLE XTFtpItem (flagSent INT(1), id INT NOT NULL, theData TEXT, theDate DATETIME, theDestCharset VARCHAR(64), theFilenamePrefix VARCHAR(100), theFtpFilename VARCHAR(255));

CREATE TABLE XTGlobalVar (theKey VARCHAR(50) NOT NULL, theValue TEXT NOT NULL);

CREATE TABLE XTInvoice (dateCreation DATETIME NOT NULL, dateFattura DATE, id VARCHAR(10) NOT NULL, idXTOrder INT, theCodiceFiscale VARCHAR(50) NOT NULL, theDestinazione TEXT, thePagamento VARCHAR(255), thePartitaIVA VARCHAR(50), theRagioneSociale VARCHAR(255), theSedeLegale TEXT, theTotale DECIMAL(38,2) NOT NULL, theTotaleImponibile DECIMAL(38,2) NOT NULL, theTotaleImposte DECIMAL(38,2) NOT NULL, theYear INT NOT NULL);

CREATE TABLE XTInvoiceNumerator (dateCreation DATETIME NOT NULL, theNumber INT NOT NULL, theType CHAR(4) NOT NULL, theYear INT NOT NULL);

CREATE TABLE XTInvoiceRow (dateCreation DATETIME NOT NULL, id INT NOT NULL, idXTInvoice VARCHAR(10) NOT NULL, theAliquotaIVA DECIMAL(38,2) NOT NULL, theDescrizione TEXT, thePosition INT NOT NULL, thePrezzoUnitario DECIMAL(38,2) NOT NULL, theQuantita DECIMAL(38,2) NOT NULL, theYear INT NOT NULL);

CREATE TABLE XTLogger (dateLogin DATETIME, dateOperation DATETIME, idXTLogger INT NOT NULL, theDescription VARCHAR(255), theEnterpriseObjectClass VARCHAR(250), theEnterpriseObjectClassPK INT, theHostAddress VARCHAR(100), theOperation VARCHAR(250), theServerAddress VARCHAR(100), theSessionID VARCHAR(100), theUserClass VARCHAR(250), theUserID INT, theUsername VARCHAR(250));

CREATE TABLE XTMetaData (dateCreation DATETIME, dateUpdate DATETIME, flagHidden TINYINT(1), idXTContainer INT, idXTContainerRelated BIGINT, idXTMetaData INT NOT NULL, idXTMetaDataModel INT, theLanguageCode CHAR(5), theSecretKey VARCHAR(255), theValue VARCHAR(5000), theValueBigDecimal DECIMAL(16,4), theValueBoolean TINYINT(1), theValueDatetime DATETIME);

CREATE TABLE XTMetaDataModel (flagListView TINYINT, flagLocalizable TINYINT, flagMultipleValues TINYINT, flagPublished TINYINT, flagSearchable TINYINT, flagTextarea TINYINT, idXTMetaDataModel INT NOT NULL, idXTMetaDataPreset INT, theClassName VARCHAR(255), theDefaultValue VARCHAR(255), theGroup VARCHAR(255), theInputMethod VARCHAR(255), theKey VARCHAR(255), thePosition INT, thePossibleValues TEXT);

CREATE TABLE XTMetaDataPreset (dateCreation DATETIME, idXTMetaDataPreset INT NOT NULL, theKey VARCHAR(255));

CREATE TABLE XTModule (flagEnabled TINYINT, idXTModule INT NOT NULL, theName VARCHAR(255));

CREATE TABLE XTNewsletterLog (dateLog DATETIME, flagSentSuccessfull TINYINT, idXTContainer INT, idXTNewsletterLog INT NOT NULL, idXTUser INT, theMessageID VARCHAR(100), theType CHAR(5));

CREATE TABLE XTOrder (dateDelivery DATETIME, dateModification DATETIME, dateOrder DATETIME, flagAcceptConditions TINYINT(1), flagDeleted TINYINT, flagFinalized TINYINT, flagPaymentNotificationReceived TINYINT, flagWarehouseUnloaded TINYINT, flagWishList TINYINT, idXTAddressWarehouse BIGINT, id_xt_customer BIGINT, id_xt_delivery_address BIGINT, id_xt_delivery_method BIGINT, id_xt_discount_coupon BIGINT, id_xt_order BIGINT NOT NULL, idXTPaymentMethod INT, id_xt_user BIGINT, theCodiceFiscale CHAR(50), theCompanyName VARCHAR(255), theCountry CHAR(8), theDiscountAmount DECIMAL(38,2), theDiscountCoupon VARCHAR(50), theEmail VARCHAR(255), theFax VARCHAR(255), theInvoiceDate DATE, theInvoiceNumber VARCHAR(15), theName VARCHAR(255), theNotes VARCHAR(255), theNotesHidden VARCHAR(255), theOrderID VARCHAR(50), thePartitaIVA CHAR(50), thePaymentID VARCHAR(255), thePhone VARCHAR(255), thePriceDelivery DECIMAL(14,2), theState CHAR(8), theStatus TINYINT, theStatusPayment INT, theStreet VARCHAR(255), theSurname VARCHAR(255), theTotal DECIMAL(14,2), theTotalWithTaxes DECIMAL(14,2), theTown VARCHAR(255), theTrackingNumber VARCHAR(255), theTransactionID VARCHAR(50), theTransactionPayload TEXT, theZipCode VARCHAR(15));

CREATE TABLE XTOrderLine (flagDiscountKind TINYINT, flagWarehouseUnloaded TINYINT, idParentLine BIGINT, idXTOrder BIGINT, idXTOrderLine BIGINT NOT NULL, idXTProduct BIGINT, idXTPromo INT, theCustomerCode VARCHAR(255), theDescription VARCHAR(500), theDiscountValue DECIMAL(14,2), theNotes VARCHAR(500), theOptions VARCHAR(500), thePriceWithTaxes DECIMAL(14,4), theProductorCode VARCHAR(100), theProviderCode VARCHAR(100), quantity DECIMAL(14,2), theSKUCode VARCHAR(100), theSerialNumber VARCHAR(255), theStandardPrice DECIMAL(14,4), theTotal DECIMAL(14,2), theTotalWithTaxes DECIMAL(14,2), theVat DECIMAL(14,2), theWeight DECIMAL(14,2));

CREATE TABLE XTPageCache (theContainersArray MEDIUMTEXT, theContent MEDIUMTEXT, theHeaders TINYTEXT, theUri CHAR(32) NOT NULL);

CREATE TABLE XTPaymentMethod (flagEnabled TINYINT, flagKind TINYINT, flagPercentageFee TINYINT, idXTPaymentMethod INT NOT NULL, theCode VARCHAR(10), theConditions TEXT, theDescription VARCHAR(255), theExpirationDays INT, theMaxTotal DECIMAL(14,2), theMinTotal DECIMAL(14,2), theName VARCHAR(50), theOptionsJSON TEXT, thePayPalUser VARCHAR(255), thePaymentFee DECIMAL(14,2), theVat DECIMAL(14,2));

CREATE TABLE xt_pricing_class (flag_kind TINYINT, flag_public TINYINT(1), id_xt_pricing_class BIGINT NOT NULL, the_name TEXT);

CREATE TABLE xt_product (dateExpirationFeatured DATETIME, dateExpirationFreeShipping DATETIME, dateExpirationNew DATETIME, dateExpirationPromo DATETIME, flagDigitalDownload TINYINT, flagDiscountAbsolute TINYINT, flag_featured TINYINT, flag_free_shipping TINYINT, flagHidden TINYINT, flag_new_products TINYINT, flag_no_quantity_limit TINYINT, flagPromo TINYINT, flagSell TINYINT, flag_to_relate TINYINT, idXTBrandContainer BIGINT, id_xt_container BIGINT, id_xt_producer BIGINT, id_xt_product BIGINT NOT NULL, id_xt_provider BIGINT, theBrand VARCHAR(100), theDiameter DECIMAL(14,2), theDiscountValue DECIMAL(38,4), theFileName VARCHAR(255), theHeight DECIMAL(14,2), theLength DECIMAL(14,2), the_minimum_order_amount DECIMAL(14,2), theName VARCHAR(255), theOutOfStockLimitQuantity FLOAT, thePrice DECIMAL(14,4), the_productor_code VARCHAR(100), the_product_code VARCHAR(100), the_quantity_in_stock DECIMAL(14,2), the_quantity_per_package DECIMAL(14,2), theQuantitySold DECIMAL(14,2), theRandomID VARCHAR(255), the_sku_code VARCHAR(100), the_vat DECIMAL(14,2), theVolumeWeight DECIMAL(14,2), the_weight DECIMAL(14,2), theWidth DECIMAL(14,2));

CREATE TABLE XTProductAccessory (id INT NOT NULL, idXTAccessory BIGINT NOT NULL, idXTProduct BIGINT NOT NULL, theQuantitySuggested DECIMAL(38,2) NOT NULL);

CREATE TABLE xt_product_pricing (id_xt_pricing_class BIGINT, id_xt_product BIGINT, id_xt_product_pricing BIGINT NOT NULL, theDisplayPrice DECIMAL(14,4), theStandardPrice DECIMAL(14,4));

CREATE TABLE XTProductStock (idXTAddress BIGINT, idXTProduct BIGINT, idXTProductStock INT NOT NULL, theQuantity DECIMAL(14,2));

CREATE TABLE XTPromo (dateCreation DATETIME NOT NULL, dateFrom DATETIME, dateModification DATETIME, dateTo DATETIME, flagAllProducts TINYINT, flagAllUsers TINYINT, flagDiscountAbsolute TINYINT, idXTContainer INT NOT NULL, idXTPromo INT NOT NULL, idXTUserCreator BIGINT NOT NULL, theDiscountValue DECIMAL(14,2), theTotalPriceFrom DECIMAL(14,2), theTotalPriceTo DECIMAL(14,2));

CREATE TABLE XTProperty (flagHidden TINYINT, idProperty INT NOT NULL, idXTContainer INT, theBehaviours BLOB, theJavaClass VARCHAR(255), theKey VARCHAR(255), theValues BLOB);

CREATE TABLE XTSMSCampaign (dateCreation DATETIME NOT NULL, dateDelivery DATETIME, dateSend DATETIME, id INT NOT NULL, theMessage VARCHAR(500), theNumberKey VARCHAR(100) NOT NULL, theSender VARCHAR(50), theSenderNumber VARCHAR(50));

CREATE TABLE XTSMSCampaignLog (dateCreation DATETIME NOT NULL, dateDelivery DATETIME, id INT NOT NULL, idXTSMSCampaign INT, idXTUser INT, theMessage VARCHAR(500), theNumber VARCHAR(50), theSenderName VARCHAR(50), theSenderNumber VARCHAR(50));

CREATE TABLE XTStringLocalizable (id INT NOT NULL, theKey VARCHAR(255) NOT NULL, theLanguageCode VARCHAR(10) NOT NULL, theValue TEXT NOT NULL);

CREATE TABLE XTTag (id INT NOT NULL, theLanguageCode VARCHAR(5) NOT NULL, theTag VARCHAR(100) NOT NULL);

CREATE TABLE XTUIAction (idXTAction INT NOT NULL, idXTTarget INT, theName VARCHAR(255));

CREATE TABLE XTUIPrivilege (flagValid TINYINT, idXTAction INT, idXTUIPrivilege INT NOT NULL, idXTUser INT, idXTUsersGroup INT);

CREATE TABLE XTUIStore (flagNewsContainer INT NOT NULL, flagNewsListContainer INT NOT NULL, idXTUIStore INT NOT NULL, theColWidth INTEGER, theSortKey VARCHAR(255), theSortSelector VARCHAR(255));

CREATE TABLE XTUITarget (flagForEditor TINYINT(1), idXTTarget INT NOT NULL, theName VARCHAR(255));

CREATE TABLE XTUser (extra_field_001 VARCHAR(255), extra_field_002 VARCHAR(255), extra_field_003 VARCHAR(255), extra_field_004 VARCHAR(255), extra_field_005 VARCHAR(255), extra_field_006 VARCHAR(255), extra_field_007 VARCHAR(255), extra_field_008 VARCHAR(255), extra_field_009 VARCHAR(255), extraField010 VARCHAR(255), extraField011 VARCHAR(255), extraField012 VARCHAR(255), extraField013 VARCHAR(255), extraField014 VARCHAR(255), extraField015 VARCHAR(255), extraField016 VARCHAR(255), extraField017 VARCHAR(255), extraField018 VARCHAR(255), extraField019 VARCHAR(255), extraField020 VARCHAR(255), flag_access_backend TINYINT(1), flag_access_frontend TINYINT(1), flag_access_level TINYINT, flag_advanced_editor CHAR(1), flagCompany TINYINT, flag_confirmed TINYINT(1), flag_enabled TINYINT, flagHidden TINYINT, flag_privacy TINYINT, flag_root TINYINT, flagSubscribeNewsletter TINYINT, flagSubscribeNotifications TINYINT(1) NOT NULL, idOwner BIGINT, id_xt_container BIGINT, id_xt_main_address BIGINT, id_xt_user BIGINT NOT NULL, the_birthday DATE, the_company_name VARCHAR(255), the_confirmation_code VARCHAR(50), the_date_confirmation DATETIME, theDateExpiration DATETIME, the_date_last_access DATETIME, the_date_registration DATETIME, the_email VARCHAR(255), theEncryptedPassword VARCHAR(255), theEndpointArn VARCHAR(255), theExtras TEXT, theFECodiceDestinatario VARCHAR(255), theFEPEC VARCHAR(255), the_fax VARCHAR(50), the_fiscal_code VARCHAR(50), the_gender CHAR(1), theInheritance CHAR(5), the_job VARCHAR(50), theLanguageCode CHAR(3), theLastKnownSessionID VARCHAR(255), theMobile VARCHAR(50), the_modification_date DATETIME, the_name VARCHAR(255), theNotes TEXT, the_password VARCHAR(255), the_phone VARCHAR(50), thePlaceOfBirth VARCHAR(255), the_registration_date DATETIME, theSocialNetworkName VARCHAR(50), theSocialNetworkUID VARCHAR(50), the_surname VARCHAR(255), theTitle VARCHAR(50), theUID VARCHAR(255), the_username VARCHAR(255), the_vat VARCHAR(50));

CREATE TABLE XTUserXTModule (xTModuleIdXTModule INT NOT NULL, xTUserIdXTUser BIGINT NOT NULL);

CREATE TABLE xt_users_group (flagAndQualifier tinyint, flag_browsing TINYINT, flag_comment TINYINT, flag_editng TINYINT, flag_reading TINYINT, flagSmartGroup tinyint, idXTPricingClass INT, id_xt_users_group BIGINT NOT NULL, the_name VARCHAR(100));

CREATE TABLE XTUsersGroupQualifier (idXTUsersGroup BIGINT, idXTUsersGroupQualifier INT NOT NULL, theJavaClass VARCHAR(255), theKey VARCHAR(255), theOperator VARCHAR(50), theValue VARCHAR(255));

CREATE TABLE XTWebServiceInfo (idXTWebServiceInfo INT NOT NULL, theAPIKey VARCHAR(255), theContainerClasses VARCHAR(500), thePassword VARCHAR(100), thePrivateKey VARCHAR(255), theServiceName VARCHAR(100), theServiceType VARCHAR(100), theServiceURL VARCHAR(255), theSnippet VARCHAR(1500), theUsername VARCHAR(100));

CREATE TABLE __XTDBVERS (id INT NOT NULL, theDate DATE, theVers INT NOT NULL);

CREATE TABLE EO_PK_TABLE (NAME CHAR(40) PRIMARY KEY, PK INT);

ALTER TABLE JTXTContainerXTContainer ADD PRIMARY KEY (idXTContainer, idXTOtherContainer);

ALTER TABLE JTXTContainerXTWebServiceInfo ADD PRIMARY KEY (xTContainerIdXTContainer, xTWebServiceInfoIdXTWebServiceInfo);

ALTER TABLE JTXTPromoXTContainer ADD PRIMARY KEY (xTContainerIdXTContainer, xTPromoIdXTPromo);

ALTER TABLE JTXTPromoXTDeliveryMethod ADD PRIMARY KEY (xTDeliveryMethodIdXTDeliveryMethod, xTPromoIdXTPromo);

ALTER TABLE JTXTPromoXTPaymentMethod ADD PRIMARY KEY (xTPaymentMethodIdXTPaymentMethod, xTPromoIdXTPromo);

ALTER TABLE JTXTPromoXTProduct ADD PRIMARY KEY (xTProductIdXTProduct, xTPromoIdXTPromo);

ALTER TABLE JTXTPromoXTUsersGroup ADD PRIMARY KEY (xTPromoIdXTPromo, xTUsersGroupIdXTUsersGroup);

ALTER TABLE JTXTUserXTPaymentMethod ADD PRIMARY KEY (xTPaymentMethodIdXTPaymentMethod, xTUserIdXTUser);

ALTER TABLE JTXTUsersGroupXTPaymentMethod ADD PRIMARY KEY (xTPaymentMethodIdXTPaymentMethod, xTUsersGroupIdXTUsersGroup);

ALTER TABLE JT_XTContainerXTAdminUsersGroup ADD PRIMARY KEY (xTContainerIdXTContainer, xTUsersGroupIdXTUsersGroup);

ALTER TABLE JT_XTContainerXTMetaDataPreset ADD PRIMARY KEY (xTContainerIdXTContainer, xTMetaDataPresetIdXTMetaDataPreset);

ALTER TABLE JT_XTContainerXTUser ADD PRIMARY KEY (xTContainerIdXTContainer, xTUserIdXTUser);

ALTER TABLE _xt_container_xt_users_group ADD PRIMARY KEY (id_xt_container, id_xt_users_group);

ALTER TABLE JT_XTMetaDataPresetXTMetaDataModel ADD PRIMARY KEY (xTMetaDataModelIdXTMetaDataModel, xTMetaDataPresetIdXTMetaDataPreset);

ALTER TABLE JT_XTProductXTDeliveryMethod ADD PRIMARY KEY (xtDeliveryMethodIdXTDeliveryMethod, xtProductIdXTProduct);

ALTER TABLE _xt_product_xt_related_product ADD PRIMARY KEY (id_xt_product, id_xt_related_product);

ALTER TABLE JT_XTSMSCampaignXTUsersGroup ADD PRIMARY KEY (xtsmsCampaignId, xtUsersGroupIdXTUsersGroup);

ALTER TABLE _xt_user_xt_event ADD PRIMARY KEY (id_xt_event, id_xt_user);

ALTER TABLE _xt_user_xt_usersgroup ADD PRIMARY KEY (id_xt_user, id_xt_users_group);

ALTER TABLE localized_content ADD PRIMARY KEY (id_xt_localized_content);

ALTER TABLE localized_multimedia_content ADD PRIMARY KEY (id_xt_localized_multimedia_content);

ALTER TABLE localized_title ADD PRIMARY KEY (id_xt_localized_title);

ALTER TABLE PayPalRequest ADD PRIMARY KEY (id);

ALTER TABLE PayPalTxn ADD PRIMARY KEY (id);

ALTER TABLE VATRates ADD PRIMARY KEY (idCountry);

ALTER TABLE XPCountry ADD PRIMARY KEY (country_id_2);

ALTER TABLE XPLanguage ADD PRIMARY KEY (lc_2);

ALTER TABLE XPRegion ADD PRIMARY KEY (region_id);

ALTER TABLE XPState ADD PRIMARY KEY (state_code);

ALTER TABLE xt_address ADD PRIMARY KEY (id_xt_address);

ALTER TABLE XTBlogEntry ADD PRIMARY KEY (idXTBlogEntry);

ALTER TABLE XTComment ADD PRIMARY KEY (idXTComment);

ALTER TABLE XTContact ADD PRIMARY KEY (idXTContact);

ALTER TABLE xt_container ADD PRIMARY KEY (id_xt_container);

ALTER TABLE XTContainerAction ADD PRIMARY KEY (idXTContainerAction);

ALTER TABLE XTContainerGroupPrivilege ADD PRIMARY KEY (idXTContainerGroupPrivilege);

ALTER TABLE XTContainerName ADD PRIMARY KEY (idXTContainerName);

ALTER TABLE XTContainerWebService ADD PRIMARY KEY (idXTContainerWebService);

ALTER TABLE XTCounter ADD PRIMARY KEY (idXTCounter);

ALTER TABLE XTDeliveryMethod ADD PRIMARY KEY (id_xt_delivery_method);

ALTER TABLE xt_delivery_pricing ADD PRIMARY KEY (id_delivery_pricing);

ALTER TABLE XTDiscountCoupon ADD PRIMARY KEY (idXTDiscountCoupon);

ALTER TABLE xt_event ADD PRIMARY KEY (id_xt_event);

ALTER TABLE XTFormSubmission ADD PRIMARY KEY (id);

ALTER TABLE XTFtpItem ADD PRIMARY KEY (id);

ALTER TABLE XTGlobalVar ADD PRIMARY KEY (theKey);

ALTER TABLE XTInvoice ADD PRIMARY KEY (id, theYear);

ALTER TABLE XTInvoiceNumerator ADD PRIMARY KEY (theType, theYear);

ALTER TABLE XTInvoiceRow ADD PRIMARY KEY (id);

ALTER TABLE XTLogger ADD PRIMARY KEY (idXTLogger);

ALTER TABLE XTMetaData ADD PRIMARY KEY (idXTMetaData);

ALTER TABLE XTMetaDataModel ADD PRIMARY KEY (idXTMetaDataModel);

ALTER TABLE XTMetaDataPreset ADD PRIMARY KEY (idXTMetaDataPreset);

ALTER TABLE XTModule ADD PRIMARY KEY (idXTModule);

ALTER TABLE XTNewsletterLog ADD PRIMARY KEY (idXTNewsletterLog);

ALTER TABLE XTOrder ADD PRIMARY KEY (id_xt_order);

ALTER TABLE XTOrderLine ADD PRIMARY KEY (idXTOrderLine);

ALTER TABLE XTPageCache ADD PRIMARY KEY (theUri);

ALTER TABLE XTPaymentMethod ADD PRIMARY KEY (idXTPaymentMethod);

ALTER TABLE xt_pricing_class ADD PRIMARY KEY (id_xt_pricing_class);

ALTER TABLE xt_product ADD PRIMARY KEY (id_xt_product);

ALTER TABLE XTProductAccessory ADD PRIMARY KEY (id);

ALTER TABLE xt_product_pricing ADD PRIMARY KEY (id_xt_product_pricing);

ALTER TABLE XTProductStock ADD PRIMARY KEY (idXTProductStock);

ALTER TABLE XTPromo ADD PRIMARY KEY (idXTPromo);

ALTER TABLE XTProperty ADD PRIMARY KEY (idProperty);

ALTER TABLE XTSMSCampaign ADD PRIMARY KEY (id);

ALTER TABLE XTSMSCampaignLog ADD PRIMARY KEY (id);

ALTER TABLE XTStringLocalizable ADD PRIMARY KEY (id);

ALTER TABLE XTTag ADD PRIMARY KEY (id);

ALTER TABLE XTUIAction ADD PRIMARY KEY (idXTAction);

ALTER TABLE XTUIPrivilege ADD PRIMARY KEY (idXTUIPrivilege);

ALTER TABLE XTUIStore ADD PRIMARY KEY (idXTUIStore);

ALTER TABLE XTUITarget ADD PRIMARY KEY (idXTTarget);

ALTER TABLE XTUser ADD PRIMARY KEY (id_xt_user);

ALTER TABLE XTUserXTModule ADD PRIMARY KEY (xTModuleIdXTModule, xTUserIdXTUser);

ALTER TABLE xt_users_group ADD PRIMARY KEY (id_xt_users_group);

ALTER TABLE XTUsersGroupQualifier ADD PRIMARY KEY (idXTUsersGroupQualifier);

ALTER TABLE XTWebServiceInfo ADD PRIMARY KEY (idXTWebServiceInfo);

ALTER TABLE __XTDBVERS ADD PRIMARY KEY (id);


INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AD','AND','Andorra',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AE','ARE','United Arab Emirates',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AF','AFG','Afghanistan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AG','ATG','Antigua And Barbuda',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AI','AIA','Anguilla',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AL','ALB','Albania',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AM','ARM','Armenia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AN','ANT','Netherlands Antilles',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AO','AGO','Angola',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AQ','ATA','Antarctica',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AR','ARG','Argentina',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AS','ASM','American Samoa',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AT','AUT','Austria',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AU','AUS','Australia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AW','ABW','Aruba',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AX','ALA','Aland Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('AZ','AZE','Azerbaijan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BA','BIH','Bosnia And Herzegovina',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BB','BRB','Barbados',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BD','BGD','Bangladesh',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BE','BEL','Belgium',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BF','BFA','Burkina Faso',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BG','BGR','Bulgaria',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BH','BHR','Bahrain',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BI','BDI','Burundi',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BJ','BEN','Benin',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BL','BLM','Saint Barthelemy',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BM','BMU','Bermuda',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BN','BRN','Brunei Darussalam',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BO','BOL','Bolivia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BR','BRA','Brazil',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BS','BHS','Bahamas',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BT','BTN','Bhutan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BU','BNL','Benelux',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BV','BVT','Bouvet Island',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BW','BWA','Botswana',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BY','BLR','Belarus',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('BZ','BLZ','Belize',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CA','CAN','Canada',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CC','CCK','Cocos (Keeling) Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CD','COD','Congo, The Democratic Republic Of The',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CF','CAF','Central African Republic',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CG','COG','Congo',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CH','CHE','Switzerland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CI','CIV','Cote D\'ivoire',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CK','COK','Cook Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CL','CHL','Chile',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CM','CMR','Cameroon',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CN','CHN','China',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CO','COL','Colombia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CR','CRI','Costa Rica',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CU','CUB','Cuba',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CV','CPV','Cape Verde',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CX','CXR','Christmas Island',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CY','CYP','Cyprus',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('CZ','CZE','Czech Republic',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('DE','DEU','Germany',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('DJ','DJI','Djibouti',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('DK','DNK','Denmark',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('DM','DMA','Dominica',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('DO','DOM','Dominican Republic',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('DZ','DZA','Algeria',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('EC','ECU','Ecuador',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('EE','EST','Estonia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('EG','EGY','Egypt',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('EH','ESH','Western Sahara',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ER','ERI','Eritrea',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ES','ESP','Spain',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ET','ETH','Ethiopia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('FI','FIN','Finland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('FJ','FJI','Fiji',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('FK','FLK','Falkland Islands (Malvinas)',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('FM','FSM','Micronesia, Federated States Of',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('FO','FRO','Faroe Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('FR','FRA','France',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GA','GAB','Gabon',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GB','GBR','United Kingdom',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GD','GRD','Grenada',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GE','GEO','Georgia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GF','GUF','French Guiana',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GG','GGY','Guernsey',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GH','GHA','Ghana',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GI','GIB','Gibraltar',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GL','GRL','Greenland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GM','GMB','Gambia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GN','GIN','Guinea',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GP','GLP','Guadeloupe',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GQ','GNQ','Equatorial Guinea',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GR','GRC','Greece',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GS','SGS','South Georgia And The South Sandwich Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GT','GTM','Guatemala',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GU','GUM','Guam',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GW','GNB','Guinea-Bissau',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('GY','GUY','Guyana',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('HK','HKG','Hong Kong',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('HM','HMD','Heard Island And Mcdonald Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('HN','HND','Honduras',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('HR','HRV','Croatia ',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('HT','HTI','Haiti',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('HU','HUN','Hungary',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ID','IDN','Indonesia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IE','IRL','Ireland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IL','ISR','Israel',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IM','IMM','Isle Of Man',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IN','IND','India',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IO','IOT','British Indian Ocean Territory',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IQ','IRQ','Iraq',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IR','IRN','Iran (Islamic Republic Of)',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IS','ISL','Iceland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('IT','ITA','Italy',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('JE','JEY','Jersey',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('JM','JAM','Jamaica',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('JO','JOR','Jordan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('JP','JPN','Japan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KE','KEN','Kenya',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KG','KGZ','Kyrgyzstan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KH','KHM','Cambodia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KI','KIR','Kiribati',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KM','COM','Comoros',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KN','KNA','Saint Kitts And Nevis',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KP','PRK','Korea, Democratic People\'s Republic Of',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KR','KOR','Korea, Republic Of',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KW','KWT','Kuwait',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KY','CYM','Cayman Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('KZ','KAZ','Kazakhstan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LA','LAO','Lao People\'s Democratic Republic',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LB','LBN','Lebanon',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LC','LCA','Saint Lucia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LI','LIE','Liechtenstein',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LK','LKA','Sri Lanka',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LR','LBR','Liberia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LS','LSO','Lesotho',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LT','LTU','Lithuania',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LU','LUX','Luxembourg',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LV','LVA','Latvia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('LY','LBY','Libyan Arab Jamahiriya',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MA','MAR','Morocco',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MC','MCO','Monaco',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MD','MDA','Moldova, Republic Of',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ME','MNE','Montenegro',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MG','MDG','Madagascar',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MH','MHL','Marshall Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MK','MKD','Macedonia, The Former Yugoslav Republic Of',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ML','MLI','Mali',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MM','MMR','Myanmar',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MN','MNG','Mongolia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MO','MAC','Macao',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MP','MNP','Northern Mariana Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MQ','MTQ','Martinique',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MR','MRT','Mauritania',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MS','MSR','Montserrat',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MT','MLT','Malta',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MU','MUS','Mauritius',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MV','MDV','Maldives',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MW','MWI','Malawi',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MX','MEX','Mexico',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MY','MYS','Malaysia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('MZ','MOZ','Mozambique',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NA','NAM','Namibia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NC','NCL','New Caledonia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NE','NER','Niger',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NF','NFK','Norfolk Island',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NG','NGA','Nigeria',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NI','NIC','Nicaragua',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NL','NLD','Netherlands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NO','NOR','Norway',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NP','NPL','Nepal',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NR','NRU','Nauru',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NU','NIU','Niue',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('NZ','NZL','New Zealand',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('OM','OMN','Oman',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PA','PAN','Panama',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PE','PER','Peru',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PF','PYF','French Polynesia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PG','PNG','Papua New Guinea',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PH','PHL','Philippines',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PK','PAK','Pakistan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PL','POL','Poland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PM','SPM','Saint Pierre And Miquelon',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PN','PCN','Pitcairn',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PR','PRI','Puerto Rico',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PS','PSE','Palestinian Territory, Occupied',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PT','PRT','Portugal',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PW','PLW','Palau',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('PY','PRY','Paraguay',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('QA','QAT','Qatar',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('RE','REU','Reunion',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('RO','ROU','Romania',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('RS','SRB','Serbia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('RU','RUS','Russian Federation',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('RW','RWA','Rwanda',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SA','SAU','Saudi Arabia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SB','SLB','Solomon Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SC','SYC','Seychelles',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SD','SDN','Sudan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SE','SWE','Sweden',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SG','SGP','Singapore',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SH','SHN','Saint Helena',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SI','SVN','Slovenia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SJ','SJM','Svalbard And Jan Mayen',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SK','SVK','Slovakia ',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SL','SLE','Sierra Leone',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SM','SMR','San Marino',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SN','SEN','Senegal',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SO','SOM','Somalia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SR','SUR','Suriname',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ST','STP','Sao Tome And Principe',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SV','SLV','El Salvador',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SY','SYR','Syrian Arab Republic',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('SZ','SWZ','Swaziland',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TC','TCA','Turks And Caicos Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TD','TCD','Chad',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TF','ATF','French Southern Territories',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TG','TGO','Togo',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TH','THA','Thailand',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TJ','TJK','Tajikistan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TK','TKL','Tokelau',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TL','TLS','Timor-Leste',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TM','TKM','Turkmenistan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TN','TUN','Tunisia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TO','TON','Tonga',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TR','TUR','Turkey',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TT','TTO','Trinidad And Tobago',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TV','TUV','Tuvalu',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TW','TWN','Taiwan, Province Of China',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('TZ','TZA','Tanzania, United Republic Of',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('UA','UKR','Ukraine',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('UG','UGA','Uganda',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('UM','UMI','United States Minor Outlying Islands',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('US','USA','United States',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('UY','URY','Uruguay',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('UZ','UZB','Uzbekistan',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VA','VAT','Vatican City State (Holy See)',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VC','VCT','Saint Vincent And The Grenadines',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VE','VEN','Venezuela',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VG','VGB','Virgin Islands (British)',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VI','VIR','Virgin Islands (U.S.)',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VN','VNM','Viet Nam',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('VU','VUT','Vanuatu',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('WF','WLF','Wallis And Futuna ',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('WS','WSM','Samoa',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('YE','YEM','Yemen',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('YT','MYT','Mayotte',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('YU','YUG','Yugoslavia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ZA','ZAF','South Africa',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ZM','ZMB','Zambia',NULL,NULL,NULL);
INSERT INTO `XPCountry` (`country_id_2`, `country_id_3`, `country_name`, `show_country`, `theLatitude`, `theLongitude`) VALUES ('ZW','ZWE','Zimbabwe',NULL,NULL,NULL);
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Afar','aa','aar');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Abkhazian','ab','abk');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Avestan','ae','ave');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Afrikaans','af','afr');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Akan','ak','aka');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Amharic','am','amh');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Aragonese','an','arg');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Arabic','ar','ara');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Assamese','as','asm');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Avaric','av','ava');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Aymara','ay','aym');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Azerbaijani','az','aze');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bashkir','ba','bak');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Belarusian','be','bel');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bulgarian','bg','bul');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bihari','bh','bih');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bislama','bi','bis');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bambara','bm','bam');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bengali','bn','ben');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tibetan','bo','bod');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Breton','br','bre');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Bosnian','bs','bos');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Catalan; Valencian','ca','cat');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Chechen','ce','che');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Chamorro','ch','cha');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Corsican','co','cos');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Cree','cr','cre');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Czech','cs','ces');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Church Slavic; Old Slavonic; Church Slavonic; Old Bulgarian; Old Church Slavonic','cu','chu');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Chuvash','cv','chv');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Welsh','cy','cym');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Danish','da','dan');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'German','de','deu');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Divehi; Dhivehi; Maldivian','dv','div');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Dzongkha','dz','dzo');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ewe','ee','ewe');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Greek, Modern (1453-)','el','ell');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'English','en','eng');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Esperanto','eo','epo');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Spanish','es','esp');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Estonian','et','est');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Basque','eu','eus');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Persian','fa','fas');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Fulah','ff','ful');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Finnish','fi','fin');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Fijian','fj','fij');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Faroese','fo','fao');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'French','fr','fre');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Western Frisian','fy','fry');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Irish','ga','gle');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Gaelic; Scottish Gaelic','gd','gla');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Galician','gl','glg');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Guarani','gn','grn');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Gujarati','gu','guj');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Manx','gv','glv');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Hausa','ha','hau');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Hebrew','he','heb');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Hindi','hi','hin');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Hiri Motu','ho','hmo');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Croatian','hr','hrv');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Haitian; Haitian Creole','ht','hat');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Hungarian','hu','hun');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Armenian','hy','hye');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Herero','hz','her');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Interlingua (International Auxiliary Language Association)','ia','ina');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Indonesian','id','ind');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Interlingue; Occidental','ie','ile');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Igbo','ig','ibo');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sichuan Yi; Nuosu','ii','iii');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Inupiaq','ik','ipk');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ido','io','ido');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Icelandic','is','isl');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Italian','it','ita');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Inuktitut','iu','iku');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Japanese','ja','jpn');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Javanese','jv','jav');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Georgian','ka','kat');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kongo','kg','kon');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kikuyu; Gikuyu','ki','kik');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kuanyama; Kwanyama','kj','kua');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kazakh','kk','kaz');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kalaallisut; Greenlandic','kl','kal');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Central Khmer','km','khm');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kannada','kn','kan');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Korean','ko','kor');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kanuri','kr','kau');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kashmiri','ks','kas');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kurdish','ku','kur');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Komi','kv','kom');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Cornish','kw','cor');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kirghiz; Kyrgyz','ky','kir');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Latin','la','lat');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Luxembourgish; Letzeburgesch','lb','ltz');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ganda','lg','lug');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Limburgan; Limburger; Limburgish','li','lim');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Lingala','ln','lin');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Lao','lo','lao');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Lithuanian','lt','lit');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Luba-Katanga','lu','lub');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Latvian','lv','lav');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Malagasy','mg','mlg');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Marshallese','mh','mah');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Maori','mi','mri');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Macedonian','mk','mkd');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Malayalam','ml','mal');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Mongolian','mn','mon');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Moldavian','mo','mol');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Marathi','mr','mar');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Malay','ms','msa');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Maltese','mt','mlt');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Burmese','my','mya');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Nauru','na','nau');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'BokmÃ¥l, Norwegian; Norwegian BokmÃ¥l','nb','nob');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ndebele, North; North Ndebele','nd','nde');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Nepali','ne','nep');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ndonga','ng','ndo');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES ('nl','Dutch','nl','dut');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Norwegian Nynorsk; Nynorsk, Norwegian','nn','nno');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Norwegian','no','nor');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ndebele, South; South Ndebele','nr','nbl');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Navajo; Navaho','nv','nav');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Chichewa; Chewa; Nyanja','ny','nya');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Occitan (post 1500); ProvenÃ§al','oc','oci');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ojibwa','oj','oji');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Oromo','om','orm');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Oriya','or','ori');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ossetian; Ossetic','os','oss');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Panjabi; Punjabi','pa','pan');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Pali','pi','pli');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Polish','pl','pol');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Pushto; Pashto','ps','pus');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Portuguese','pt','por');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Quechua','qu','que');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Romansh','rm','roh');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Rundi','rn','run');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Romanian','ro','ron');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Russian','ru','rus');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Kinyarwanda','rw','kin');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sanskrit','sa','san');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sardinian','sc','srd');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sindhi','sd','snd');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Northern Sami','se','sme');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sango','sg','sag');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sinhala; Sinhalese','si','sin');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Slovak','sk','slk');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Slovenian','sl','slv');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Samoan','sm','smo');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Shona','sn','sna');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Somali','so','som');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Albanian','sq','sqi');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Serbian','sr','srp');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Swati','ss','ssw');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sotho, Southern','st','sot');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Sundanese','su','sun');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Swedish','sv','swe');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Swahili','sw','swa');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tamil','ta','tam');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Telugu','te','tel');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tajik','tg','tgk');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Thai','th','tha');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tigrinya','ti','tir');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Turkmen','tk','tuk');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tagalog','tl','tgl');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tswana','tn','tsn');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tonga (Tonga Islands)','to','ton');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Turkish','tr','tur');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tsonga','ts','tso');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tatar','tt','tat');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Twi','tw','twi');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Tahitian','ty','tah');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Uighur; Uyghur','ug','uig');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Ukrainian','uk','ukr');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Urdu','ur','urd');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'en_US','us','usa');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Uzbek','uz','uzb');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Venda','ve','ven');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Vietnamese','vi','vie');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'VolapÃ¼k','vo','vol');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Walloon','wa','wln');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Wolof','wo','wol');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Xhosa','xh','xho');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Yiddish','yi','yid');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Yoruba','yo','yor');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Zhuang; Chuang','za','zha');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Chinese','zh','chi');
INSERT INTO `XPLanguage` (`country_id_2`, `label`, `lc_2`, `lc_3`) VALUES (NULL,'Zulu','zu','zul');
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Agrigento',19,'AG',NULL,NULL,NULL,43);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Alessandria',2,'AL',NULL,NULL,NULL,190);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Ancona',10,'AN',NULL,NULL,NULL,49);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Aosta',1,'AO',NULL,NULL,NULL,74);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Ascoli Piceno',10,'AP',NULL,NULL,NULL,73);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','L\'Aquila',14,'AQ',NULL,NULL,NULL,108);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Arezzo',9,'AR',NULL,NULL,NULL,39);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Asti',2,'AT',NULL,NULL,NULL,118);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Avellino',15,'AV',NULL,NULL,NULL,119);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Bari',16,'BA',NULL,NULL,NULL,48);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Bergamo',3,'BG',NULL,NULL,NULL,244);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Biella',2,'BI',NULL,NULL,NULL,82);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Belluno',5,'BL',NULL,NULL,NULL,69);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Benevento',15,'BN',NULL,NULL,NULL,78);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Bologna',8,'BO',NULL,NULL,NULL,60);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Brindisi',16,'BR',NULL,NULL,NULL,20);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Brescia',3,'BS',NULL,NULL,NULL,206);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Bolzano',6,'BZ',NULL,NULL,NULL,116);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Cagliari',20,'CA',NULL,NULL,NULL,109);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Campobasso',12,'CB',NULL,NULL,NULL,84);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Caserta',15,'CE',NULL,NULL,NULL,104);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Chieti',14,'CH',NULL,NULL,NULL,104);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Carbonia-Iglesias',20,'CI',NULL,NULL,NULL,21);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Caltanissetta',19,'CL',NULL,NULL,NULL,22);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Cuneo',2,'CN',NULL,NULL,NULL,250);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Como',3,'CO',NULL,NULL,NULL,163);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Cremona',3,'CR',NULL,NULL,NULL,115);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Cosenza',18,'CS',NULL,NULL,NULL,155);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Catania',19,'CT',NULL,NULL,NULL,58);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Catanzaro',18,'CZ',NULL,NULL,NULL,80);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Enna',19,'EN',NULL,NULL,NULL,20);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Alicante',37,'ES-A',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Albacete',25,'ES-AB',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Almería',21,'ES-AL',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Ávila',24,'ES-AV',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Barcelona',26,'ES-B',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Badajoz',28,'ES-BA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Bilbao',32,'ES-BI',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Burgos',24,'ES-BU',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','La Coruña',29,'ES-C',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Cádiz',21,'ES-CA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Cáceres',28,'ES-CC',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Ceuta',38,'ES-CE',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Córdoba',21,'ES-CO',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Ciudad Real',25,'ES-CR',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Castellón de la Plana',37,'ES-CS',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Cuenca',25,'ES-CU',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Las Palmas de Gran Canaria',27,'ES-GC',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Gerona',26,'ES-GI',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Granada',21,'ES-GR',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Guadalajara',25,'ES-GU',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Huelva',21,'ES-H',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Huesca',22,'ES-HU',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Jaén',21,'ES-J',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Lérida',26,'ES-L',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','León',24,'ES-LE',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Logroño',31,'ES-LO',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Lugo',29,'ES-LU',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Madrid',35,'ES-M',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Málaga',21,'ES-MA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Melilla',38,'ES-ML',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Murcia',34,'ES-MU',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Pamplona',36,'ES-NA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Oviedo',33,'ES-O',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Orense',29,'ES-OR',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Palencia',24,'ES-P',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Palma',30,'ES-PM',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Pontevedra',29,'ES-PO',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Santander',23,'ES-S',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Salamanca',24,'ES-SA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Sevilla',21,'ES-SE',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Segovia',24,'ES-SG',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Soria',24,'ES-SO',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','San Sebastián',32,'ES-SS',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Tarragona',26,'ES-T',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Teruel',22,'ES-TE',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Santa Cruz de Tenerife',27,'ES-TF',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Toledo',25,'ES-TO',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Valencia',37,'ES-V',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Valladolid',24,'ES-VA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Vitoria',32,'ES-VI',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Zaragoza',22,'ES-Z',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('ES','Zamora',24,'ES-ZA',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Forlì-Cesena',8,'FC',NULL,NULL,NULL,30);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Ferrara',8,'FE',NULL,NULL,NULL,26);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Foggia',16,'FG',NULL,NULL,NULL,64);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Firenze',9,'FI',NULL,NULL,NULL,44);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Fermo',10,'FM',NULL,NULL,NULL,1001);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Frosinone',13,'FR',NULL,NULL,NULL,91);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Genova',4,'GE',NULL,NULL,NULL,67);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Gorizia',7,'GO',NULL,NULL,NULL,25);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Grosseto',9,'GR',NULL,NULL,NULL,28);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Imperia',4,'IM',NULL,NULL,NULL,67);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Isernia',12,'IS',NULL,NULL,NULL,52);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Crotone',18,'KR',NULL,NULL,NULL,27);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Lecco',3,'LC',NULL,NULL,NULL,90);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Lecce',16,'LE',NULL,NULL,NULL,97);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Livorno',9,'LI',NULL,NULL,NULL,20);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Lodi',3,'LO',NULL,NULL,NULL,61);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Latina',13,'LT',NULL,NULL,NULL,33);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Lucca',9,'LU',NULL,NULL,NULL,35);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Monza Brianza',3,'MB',NULL,NULL,NULL,1000);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Macerata',10,'MC',NULL,NULL,NULL,57);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Messina',19,'ME',NULL,NULL,NULL,108);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Milano',3,'MI',NULL,NULL,NULL,188);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Mantova',3,'MN',NULL,NULL,NULL,70);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Modena',8,'MO',NULL,NULL,NULL,47);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Massa-Carrara',9,'MS',NULL,NULL,NULL,17);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Matera',17,'MT',NULL,NULL,NULL,31);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Napoli',15,'NA',NULL,NULL,NULL,92);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Novara',2,'NO',NULL,NULL,NULL,88);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Nuoro',20,'NU',NULL,NULL,NULL,100);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Ogliastra',20,'OG',NULL,NULL,NULL,23);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Oristano',20,'OR',NULL,NULL,NULL,78);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Olbia-Tempio',20,'OT',NULL,NULL,NULL,26);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Palermo',19,'PA',NULL,NULL,NULL,82);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Piacenza',8,'PC',NULL,NULL,NULL,48);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Padova',5,'PD',NULL,NULL,NULL,104);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Pescara',14,'PE',NULL,NULL,NULL,46);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Perugia',11,'PG',NULL,NULL,NULL,59);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Pisa',9,'PI',NULL,NULL,NULL,39);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Pordenone',7,'PN',NULL,NULL,NULL,51);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Prato',9,'PO',NULL,NULL,NULL,7);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Parma',8,'PR',NULL,NULL,NULL,47);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Pistoia',9,'PT',NULL,NULL,NULL,22);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Aveiro',39,'PT-01',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Beja',40,'PT-02',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Braga',41,'PT-03',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Bragança',42,'PT-04',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Castelo Branco',43,'PT-05',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Coimbra',44,'PT-06',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Évora',45,'PT-07',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Faro',46,'PT-08',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Guarda',47,'PT-09',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Leiria',48,'PT-10',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Lisboa',49,'PT-11',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Portalegre',50,'PT-12',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Porto',51,'PT-13',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Santarém',52,'PT-14',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Setúbal',53,'PT-15',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Viana do Castelo',54,'PT-16',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Vila Real',55,'PT-17',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Viseu',56,'PT-18',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Região Autónoma dos Açores',57,'PT-20',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('PT','Região Autónoma da Madeira',58,'PT-30',NULL,NULL,NULL,NULL);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Pesaro e Urbino',10,'PU',NULL,NULL,NULL,67);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Pavia',3,'PV',NULL,NULL,NULL,190);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Potenza',17,'PZ',NULL,NULL,NULL,100);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Ravenna',8,'RA',NULL,NULL,NULL,18);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Reggio Calabria',18,'RC',NULL,NULL,NULL,97);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Reggio Emilia',8,'RE',NULL,NULL,NULL,45);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Ragusa',19,'RG',NULL,NULL,NULL,12);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Rieti',13,'RI',NULL,NULL,NULL,73);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Roma',13,'RM',NULL,NULL,NULL,121);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Rimini',8,'RN',NULL,NULL,NULL,20);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Rovigo',5,'RO',NULL,NULL,NULL,50);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Salerno',15,'SA',NULL,NULL,NULL,158);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Siena',9,'SI',NULL,NULL,NULL,36);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','San Marino',8,'SM',NULL,NULL,NULL,0);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Sondrio',3,'SO',NULL,NULL,NULL,78);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','La Spezia',4,'SP',NULL,NULL,NULL,32);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Siracusa',19,'SR',NULL,NULL,NULL,21);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Sassari',20,'SS',NULL,NULL,NULL,90);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Savona',4,'SV',NULL,NULL,NULL,69);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Taranto',16,'TA',NULL,NULL,NULL,29);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Teramo',14,'TE',NULL,NULL,NULL,47);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Trento',6,'TN',NULL,NULL,NULL,223);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Torino',2,'TO',NULL,NULL,NULL,315);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Trapani',19,'TP',NULL,NULL,NULL,24);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Terni',11,'TR',NULL,NULL,NULL,33);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Trieste',7,'TS',NULL,NULL,NULL,6);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Treviso',5,'TV',NULL,NULL,NULL,95);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Udine',7,'UD',NULL,NULL,NULL,137);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Varese',3,'VA',NULL,NULL,NULL,141);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Verbano-Cusio-Ossola',2,'VB',NULL,NULL,NULL,77);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Vercelli',2,'VC',NULL,NULL,NULL,86);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Venezia',5,'VE',NULL,NULL,NULL,44);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Vicenza',5,'VI',NULL,NULL,NULL,121);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Verona',5,'VR',NULL,NULL,NULL,98);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Medio Campidano',20,'VS',NULL,NULL,NULL,28);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Viterbo',13,'VT',NULL,NULL,NULL,60);
INSERT INTO `XPState` (`id_country`, `main_town`, `region_id`, `state_code`, `theISO3166_2`, `theLatitude`, `theLongitude`, `towns_id`) VALUES ('IT','Vibo Valentia',18,'VV',NULL,NULL,NULL,50);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','aosta',1,'Val d\'Aosta',NULL,NULL,NULL,1);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','piemonte',2,'Piemonte',NULL,NULL,NULL,2);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','lombardia',3,'Lombardia',NULL,NULL,NULL,3);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','liguria',4,'Liguria',NULL,NULL,NULL,4);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','veneto',5,'Veneto',NULL,NULL,NULL,5);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','trentino',6,'Trentino Alto Adige',NULL,NULL,NULL,6);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','friuli',7,'Friuli Venezia Giulia',NULL,NULL,NULL,7);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','emilia',8,'Emilia Romagna',NULL,NULL,NULL,8);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','toscana',9,'Toscana',NULL,NULL,NULL,9);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','marche',10,'Marche',NULL,NULL,NULL,10);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','umbria',11,'Umbria',NULL,NULL,NULL,11);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','molise',12,'Molise',NULL,NULL,NULL,12);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','lazio',13,'Lazio',NULL,NULL,NULL,13);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','abruzzi',14,'Abruzzo',NULL,NULL,NULL,14);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','campania',15,'Campania',NULL,NULL,NULL,15);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','puglia',16,'Puglia',NULL,NULL,NULL,16);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','basilicata',17,'Basilicata',NULL,NULL,NULL,17);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','calabria',18,'Calabria',NULL,NULL,NULL,18);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','sicilia',19,'Sicilia',NULL,NULL,NULL,19);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('IT','sardegna',20,'Sardegna',NULL,NULL,NULL,20);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','AN',21,'Andalucía','ES-AN',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','AR',22,'Aragón','ES-AR',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','CB',23,'Cantabria','ES-CB',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','CL',24,'Castilla y León','ES-CL',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','CM',25,'Castilla-La Mancha','ES-CM',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','CT',26,'Cataluña','ES-CT',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','CN',27,'Islas Canarias','ES-CN',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','EX',28,'Extremadura','ES-EX',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','GA',29,'Galicia','ES-GA',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','IB',30,'Islas Baleares','ES-IB',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','RI',31,'La Rioja','ES-RI',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','PV',32,'País Vasco','ES-PV',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','AS',33,'Principado de Asturias','ES-AS',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','MC',34,'Región de Murcia','ES-MC',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','MD',35,'Comunidad de Madrid','ES-MD',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','NC',36,'Comunidad Foral de Navarra','ES-NC',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES','CV',37,'Comunidad Valenciana','ES-CV',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('ES',NULL,38,'Ciudad autónoma',NULL,NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-01',39,'Aveiro','PT-01',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-02',40,'Beja','PT-02',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-03',41,'Braga','PT-03',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-04',42,'Bragança','PT-04',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-05',43,'Castelo Branco','PT-05',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-06',44,'Coimbra','PT-06',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-07',45,'Évora','PT-07',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-08',46,'Faro','PT-08',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-09',47,'Guarda','PT-09',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-10',48,'Leiria','PT-10',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-11',49,'Lisboa','PT-11',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-12',50,'Portalegre','PT-12',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-13',51,'Porto','PT-13',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-14',52,'Santarém','PT-14',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-15',53,'Setúbal','PT-15',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-16',54,'Viana do Castelo','PT-16',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-17',55,'Vila Real','PT-17',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-18',56,'Viseu','PT-18',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-20',57,'Região Autónoma dos Açores','PT-20',NULL,NULL,NULL);
INSERT INTO `XPRegion` (`country_id_2`, `nickname`, `region_id`, `region_name`, `theISO3166_2`, `theLatitude`, `theLongitude`, `thePosition`) VALUES ('PT','PT-30',58,'Região Autónoma da Madeira','PT-30',NULL,NULL,NULL);
