SQLite format 3@ $c k K7indexindex_users_on_activation_tokenusers CREATE UNIQUE INDEX "index_users_on_activation_token" ON "users" ("activation_token") SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") M;indexindex_users_on_remember_me_tokenusers CREATE UNIQUE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token")r%5indexactivity_idxusersCREATE UNIQUE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")n;indexindex_users_on_usernameusersCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)_tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "email" varchar(255), "party_id" integer, "type" varchar(255), "salt" varchar(255), "crypted_password" varchar(255), "last_login_at" datetime, "last_logout_at" datetime, "last_activity_at" datetime, "failed_logins_count" integer DEFAULT 0, "lock_expires_at" datetime, "remember_me_token" varchar(255), "remember_me_token_expires_at" datetime, "reset_password_token" varchar(255), "reset_password_token_expires_at" datetime, "reset_password_email_sent_at" datetime, "activation_state" varchar(255), "activation_token" varchar(255), "activation_token_expires_at" datetime, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE_ZWQQIKEA>:731(+! )20100819181805)20111109161549)20110913145329)20080805000020)20080805000010 )20100819181805)20111109161549)20110913145329)20080805000020)20080805000010 *9AAadmin2user2@portablemind.com2011-12-14 18:41:08.4645212011-12-14 18:41:08.464521k9AAadmin3user3@portablemind.com2011-12-14 18:41:08.8824002011-12-14 18:41:08.882400 T~s_T roles )secured_models users parties+audit_log_types5compass_ae_instances%delayed_jobsgeo_zones'geo_countries!currencies 6user2@portablemind.comuser3@portablemind.com admin2 admin3         22AAmanager2011-12-14 18:41:08.5521492011-12-14 18:41:08.552149AAemployee2011-12-14 18:41:08.5433502011-12-14 18:41:08.543FAAemployee2011-12-14 18:41:08.8510542011-12-14 18:41:08.851054 M rVwq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")_tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "email" varchar(255), "party_id" integer, "type" varchar(255), "salt" varchar(255), "crypted_password" varchar(255), "last_login_at" datetime, "last_logout_at" datetime, "last_activity_at" datetime, "failed_logins_count" integer DEFAULT 0, "lock_expires_at" datetime, "remember_me_token" varchar(255), "remember_me_token_expires_at" datetime, "reset_password_token" varchar(255), "reset_password_token_expires_at" datetime, "reset_password_email_sent_at" datetime, "activation_state" varchar(255), "activation_token" varchar(255), "activation_token_expires_at" datetime, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")n;indexindex_users_on_usernameusersCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")r%5indexactivity_idxusersCREATE UNIQUE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at") M;indexindex_users_on_remember_me_tokenusers CREATE UNIQUE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token") SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") K7indexindex_users_on_activation_tokenusers CREATE UNIQUE INDEX "index_users_on_activation_token" ON "users" ("activation_token") 55Jcf`{E!indexindex_audit_logs_on_party_idaudit_logsCREATE INDEX "index++etableaudit_log_typesaudit_log_typesCREATE TABLE "audit_log_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "descripti tablerolesroles CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)E ]tablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime, "updated_at" datetime)y Eindexindex_sessions_on_session_idsessionsCREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")X!!{tableaudit_logsaudit_logsCREATE TABLE "audit_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "application" varchar(255), "description" varchar(255), "party_id" integer, "additional_info" text, "audit_log_type_id" integer, "event_record_id" integer, "event_record_type" varchar(255), "created_at" datetime, "updated_at" datetime){E!indexindex_audit_logs_on_party_idaudit_logsCREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")1!Aindexevent_record_indexaudit_logsCREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type")++etableaudit_log_typesaudit_log_typesCREATE TABLE "audit_log_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "error_code" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime, "updated_at" datetime)       Cub ++AASession Timeoutsession_timeout 2011-12-14 18:41:06.6409192011-12-14 18:41:06.640919^ ''AAAccessed Areaaccessed_area 2011-12-14 18:41:06.6371782011-12-14 18:41:06.637178d --AASuccessful Loginsuccessful_login2011-12-14 18:41:06.6333492011-12-14 18:41:06.633349f //AASuccessful Logoutsuccessful_logout2011-12-14 18:41:06.6294532011-12-14 18:41:06.629453` ))AACustom Messagecustom_message2011-12-14 18:41:06.6252142011-12-14 18:41:06.625214Y ##AAApplicationapplication 2011-12-14 18:41:06.6227442011-12-14 18:41:06.622744  jT]655tableroles_secured_modelsroles_secured_modelsCREATE TABLE "roles_secured_models" ("secured_model_id" integer, "role_id" integer, "created_at" datetime, "updated_at" datetime)1)Qindexsecured_record_idxsecured_modelsCREATE INDEX "secured_record_idx" ON "secured_models" ("secured_record_id", "se$++tableaudit_log_itemsaudit_log_itemsCREATE TABLE "audit_log_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "audit_log_id" integer, "audit_log_item_type_id" integer, "audit_log_item_value" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime) 559tableaudit_log_item_typesaudit_log_item_typesCREATE TABLE "audit_log_item_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "description" varchar(255), "comments" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime, "updated_at" datetime)g)) tablesecured_modelssecured_modelsCREATE TABLE "secured_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "secured_record_id" integer, "secured_record_type" varchar(255), "created_at" datetime, "updated_at" datetime)1)Qindexsecured_record_idxsecured_modelsCREATE INDEX "secured_record_idx" ON "secured_models" ("secured_record_id", "secured_record_type")655tableroles_secured_modelsroles_secured_modelsCREATE TABLE "roles_secured_models" ("secured_model_id" integer, "role_id" integer, "created_at" datetime, "updated_at" datetime);i5eindexindex_roles_secured_models_on_secured_model_idroles_secured_modelsCREATE INDEX "index_roles_secured_models_on_secured_model_id" ON "roles_secured_models" ("secured_model_id") W5Aindexindex_roles_secured_models_on_role_idroles_secured_modelsCREATE INDEX "index_roles_secured_models_on_role_id" ON "roles_secured_models" ("role_id")  ~AAUser2011-12-14 18:41:08.4675032011-12-14 18:41:08.467503AAAUser2011-12-14 18:41:08.8861642011-12-14 18:41:08.886164 User User     qgs))!tablecapable_modelscapable_models$CREATE TABLE "capable_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "##tablefile_assetsfile_assetsCREATE TABLE "file_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_asset_holder_id" integer, "file_asset_holder_type" varchar(255), "type" varchar(255), "name" varchar(255), "directory" varchar(255), "data_file_name" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "data_updated_at" datetime, "created_at" datetime, "updated_at" datetime)s?#indexindex_file_assets_on_typefile_assets CREATE INDEX "index_file_assets_on_type" ON "file_assets" ("type")7#]indexfile_asset_holder_idxfile_assets!CREATE INDEX "file_asset_holder_idx" ON "file_assets" ("file_asset_holder_id", "file_asset_holder_type")X%%stabledelayed_jobsdelayed_jobs"CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime, "updated_at" datetime){7%'indexdelayed_jobs_prioritydelayed_jobs#CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")s))!tablecapable_modelscapable_models$CREATE TABLE "capable_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "capable_model_record_id" integer, "capable_model_record_type" varchar(255), "created_at" datetime, "updated_at" datetime)' =)uindexcapable_model_record_idxcapable_models%CREATE INDEX "capable_model_record_idx" ON "capable_models" ("capable_model_record_id", "capable_model_record_type")l!-- tablecapability_typescapability_types&CREATE TABLE "capability_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)   RR+ (AAA--- !ruby/object:ErpTechSvcs::Sessions::DeleteExpiredSessionsJob priority: 1 2011-12-15 07:00:01.0000002011-12-14 18:41:06.5085742011-12-14 18:41:06.508574  A2011-12-15 07:00:01.000000     33 _03%K'559W"%%qtablecapabilitiescapabilities'CREATE TABLE "capabilities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource" varchar(255), "capability_type_id" integer, "created_at" datetime, "updated_at" datetime)!#]%Mindexindex_capabilities_on_capability_type_idcapabilities)CREATE INDEX "index_capabilities_on_capability_type_id" ON "capabilities" ("capability_type_id")Q$CC)tablecapabilities_capable_modelscapabilities_capable_models*CREATE TABLE "capabilities_capable_models" ("capable_model_id" integer, "capability_id" integer, "created_at" datetime, "updated_at" datetime)W%wCindexindex_capabilities_capable_models_on_capable_model_idcapabilities_capable_models+CREATE INDEX "index_capabilities_capable_models_on_capable_model_id" ON "capabilities_capable_models" ("capable_model_id")N&qCuindexindex_capabilities_capable_models_on_capability_idcapabilities_capable_models,CREATE INDEX "index_capabilities_capable_models_on_capability_id" ON "capabilities_capable_models" ("capability_id")K'559tablecompass_ae_instancescompass_ae_instances-CREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal, "created_at" datetime, "updated_at" datetime)2(;tablepartiesparties.CREATE TABLE "parties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "business_party_id" integer, "business_party_type" varchar(255), "list_view_image_id" integer, "enterprise_identifier" varchar(255), "created_at" datetime, "updated_at" datetime)i)+indexbesi_1parties/CREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")^*##tableparty_rolesparty_roles0CREATE TABLE "party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "party_id" integer, "role_type_id" integer, "created_at" datetime, "updated_at" datetime)+G#!indexindex_party_roles_on_party_idparty_roles1CREATE INDEX "index_party_roles_on_party_id" ON "party_roles" ("party_id")     AAA@2011-12-14 18:41:06.5329482011-12-14 18:41:06.532948 t.D AAparty 42011-12-14 18:41:08.8679602011-12-14 18:41:08.867960D AAparty 32011-12-14 18:41:08.7128832011-12-14 18:41:08.712883D AAparty 22011-12-14 18:41:08.4515692011-12-14 18:41:08.451569D AAparty 12011-12-14 18:41:08.3005362011-12-14 18:41:08.300536     ;s>,mz133tableparty_relationshipsparty_relationships8CREATE TABLE "party_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT ,O#1indexindex_party_roles_on_role_type_idparty_roles2CREATE INDEX "index_party_roles_on_role_type_id" ON "party_roles" ("role_type_id")m-!!%tablerole_typesrole_types4CREATE TABLE "role_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)E.115tablerelationship_typesrelationship_types5CREATE TABLE "relationship_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "valid_from_role_type_id" integer, "valid_to_role_type_id" integer, "name" varchar(255), "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)H/s1yindexindex_relationship_types_on_valid_from_role_type_idrelationship_types6CREATE INDEX "index_relationship_types_on_valid_from_role_type_id" ON "relationship_types" ("valid_from_role_type_id")B0o1qindexindex_relationship_types_on_valid_to_role_type_idrelationship_types7CREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id")z133tableparty_relationshipsparty_relationships8CREATE TABLE "party_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "party_id_from" integer, "party_id_to" integer, "role_type_id_from" integer, "role_type_id_to" integer, "status_type_id" integer, "priority_type_id" integer, "relationship_type_id" integer, "from_date" date, "thru_date" date, "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)       <<pP812c3Yindexindex_party_relationships_on_status_type_idparty_relationships9CREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id")73g3aindexindex_party_relationships_on_priority_type_idparty_relationships;CREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")C4o3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsCREATE TABLE "individuals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "party_id" integer, "current_last_name" varchar(255), "current_first_name" varchar(255), "current_middle_name" varchar(255), "current_personal_title" varchar(255), "current_suffix" varchar(255), "current_nickname" varchar(255), "gender" varchar(1), "birth_date" date, "height" decimal(5,2), "weight" integer, "mothers_maiden_name" varchar(255), "marital_status" varchar(1), "social_security_number" varchar(255), "current_passport_number" integer, "current_passport_expire_date" date, "total_years_work_experience" integer, "comments" varchar(255), "encrypted_ssn" varchar(255), "temp_ssn" varchar(255), "salt" varchar(255), "ssn_last_four" varchar(255), "created_at" datetime, "updated_at" datetime)7G#!indexindex_individuals_on_party_idindividuals?CREATE INDEX "index_individuals_on_party_id" ON "individuals" ("party_id")       lXgFa68?tablecontactscontacts@CREATE TABLE "contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "party_id" integer, "contact_mechanism_id" integer, "contact_mechanism_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)s9Aindexindex_contacts_on_68?tablecontactscontacts@CREATE TABLE "contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "party_id" integer, "contact_mechanism_id" integer, "contact_mechanism_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)s9Aindexindex_contacts_on_party_idcontactsBCREATE INDEX "index_contacts_on_party_id" ON "contacts" ("party_id")q:9indexbesi_2contactsCCREATE INDEX "besi_2" ON "contacts" ("contact_mechanism_id", "contact_mechanism_type")v;''+tablecontact_typescontact_typesDCREATE TABLE "contact_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime) <M'-indexindex_contact_types_on_parent_idcontact_typesECREATE INDEX "index_contact_types_on_parent_id" ON "contact_types" ("parent_id")=--1tablecontact_purposescontact_purposesFCREATE TABLE "contact_purposes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime, "updated_at" datetime)>S-9indexindex_contact_purposes_on_parent_idcontact_purposesGCREATE INDEX "index_contact_purposes_on_parent_id" ON "contact_purposes" ("parent_id")            c;!qm\E''wtablephone_numbersphone_numbersOCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "phone_number" varchar(255), "de???Gtablecontact_purposes_contactscontact_purposes_contactsHCREATE TABLE "contact_purposes_contacts" ("contact_id" integer, "contact_purpose_id" integer)7@K?qindexcontact_purposes_contacts_indexcontact_purposes_contactsICREATE INDEX "contact_purposes_contacts_index" ON "contact_purposes_contacts" ("contact_id", "contact_purpose_id")A--Otablepostal_addressespostal_addressesJCREATE TABLE "postal_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "address_line_1" varchar(255), "address_line_2" varchar(255), "city" varchar(255), "state" varchar(255), "zip" varchar(255), "country" varchar(255), "description" varchar(255), "geo_country_id" integer, "geo_zone_id" integer, "created_at" datetime, "updated_at" datetime)%B]-Mindexindex_postal_addresses_on_geo_country_idpostal_addressesLCREATE INDEX "index_postal_addresses_on_geo_country_id" ON "postal_addresses" ("geo_country_id")CW-Aindexindex_postal_addresses_on_geo_zone_idpostal_addressesMCREATE INDEX "index_postal_addresses_on_geo_zone_id" ON "postal_addresses" ("geo_zone_id")cD++}tableemail_addressesemail_addressesNCREATE TABLE "email_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email_address" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)\E''wtablephone_numbersphone_numbersOCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "phone_number" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)      00$a.F11tableparty_search_factsparty_search_factsPCREATE TABLE "party_search_facts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "party_id" integer, "ei.F11tableparty_search_factsparty_search_factsPCREATE TABLE "party_search_facts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "party_id" integer, "eid" varchar(255), "type" varchar(255), "roles" text, "party_description" varchar(255), "party_business_party_type" varchar(255), "user_login" varchar(255), "individual_current_last_name" varchar(255), "individual_current_first_name" varchar(255), "individual_current_middle_name" varchar(255), "individual_birth_date" varchar(255), "individual_ssn" varchar(255), "party_phone_number" varchar(255), "party_email_address" varchar(255), "party_address_1" varchar(255), "party_address_2" varchar(255), "party_primary_address_city" varchar(255), "party_primary_address_state" varchar(255), "party_primary_address_zip" varchar(255), "party_primary_address_country" varchar(255), "user_enabled" boolean, "user_type" varchar(255), "reindex" boolean, "created_at" datetime, "updated_at" datetime)NG{tablemoneymoneyRCREATE TABLE "money" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "amount" float, "currency_id" integer, "created_at" datetime, "updated_at" datetime)pHAindexindex_money_on_currency_idmoneySCREATE INDEX "index_money_on_currency_id" ON "money" ("currency_id")YI!!}tablecurrenciescurrenciesTCREATE TABLE "currencies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "definition" varchar(255), "internal_identifier" varchar(255), "numeric_code" varchar(255), "major_unit_symbol" varchar(255), "minor_unit_symbol" varchar(255), "ratio_of_minor_unit_to_major_unit" varchar(255), "postfix_label" varchar(255), "introduction_date" datetime, "expiration_date" datetime, "created_at" datetime, "updated_at" datetime)   OAAUS DollarUSD$2011-12-14 18:41:05.8172252011-12-14 18:41:05.817225 USD  TT$m#^PJ[!Iindexindex_currencies_on_internal_identifiercurrenciesUCREATE INDEX "index_currencies_on_internal_identifier" ON "currencies" ("internal_identifier")K!!tablecategoriescategoriesVCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "external_identifier" varchar(255), "from_date" datetime, "to_date" datetime, "internal_identifier" varchar(255), "category_record_id" integer, "category_record_type" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime, "updated_at" datetime) L5!Qindexcategory_polymorphiccategoriesXCREATE INDEX "category_polymorphic" ON "categories" ("category_record_id", "category_record_type")FM==tablecategory_classificationscategory_classificationsYCREATE TABLE "category_classifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "classification_type" varchar(255), "classification_id" integer, "from_date" datetime, "to_date" datetime, "created_at" datetime, "updated_at" datetime)3NA=uindexclassification_polymorphiccategory_classificationsZCREATE INDEX "classification_polymorphic" ON "category_classifications" ("classification_id", "classification_type")O11Gtabledescriptive_assetsdescriptive_assets[CREATE TABLE "descriptive_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "view_type_id" integer, "internal_identifier" varchar(255), "description" text, "external_identifier" varchar(255), "external_id_source" varchar(255), "described_record_id" integer, "described_record_type" varchar(255), "created_at" datetime, "updated_at" datetime)'P]1Mindexindex_descriptive_assets_on_view_type_iddescriptive_assets\CREATE INDEX "index_descriptive_assets_on_view_type_id" ON "descriptive_assets" ("view_type_id")Q51eindexdescribed_record_idxdescriptive_assets]CREATE INDEX "described_record_idx" ON "descriptive_assets" ("described_record_id", "described_record_type")        xpx=[u{indexindex_notes_on_noted_record_idZR!!tableview_typesview_types^CREATE TABLE "view_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime) S''Ytablegeo_countriesgeo_countries`CREATE TABLE "geo_countries" ("id" INTEGER PRIZR!!tableview_typesview_types^CREATE TABLE "view_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime) S''Ytablegeo_countriesgeo_countries`CREATE TABLE "geo_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "iso_code_2" varchar(255), "iso_code_3" varchar(255), "display" boolean DEFAULT 't', "external_id" integer, "created_at" datetime){TC'indexindex_geo_countries_on_namegeo_countriesaCREATE INDEX "index_geo_countries_on_name" ON "geo_countries" ("name") UO'1indexindex_geo_countries_on_iso_code_2geo_countriesbCREATE INDEX "index_geo_countries_on_iso_code_2" ON "geo_countries" ("iso_code_2")XVtablegeo_zonesgeo_zonescCREATE TABLE "geo_zones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "geo_country_id" integer, "zone_code" varchar(255) DEFAULT 2, "zone_name" varchar(255), "created_at" datetime) WO1indexindex_geo_zones_on_geo_country_idgeo_zonesdCREATE INDEX "index_geo_zones_on_geo_country_id" ON "geo_zones" ("geo_country_id")zXEindexindex_geo_zones_on_zone_namegeo_zoneseCREATE INDEX "index_geo_zones_on_zone_name" ON "geo_zones" ("zone_name")zYEindexindex_geo_zones_on_zone_codegeo_zonesfCREATE INDEX "index_geo_zones_on_zone_code" ON "geo_zones" ("zone_code") ZqtablenotesnotesgCREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_by_id" integer, "content" text, "noted_record_id" integer, "noted_record_type" varchar(255), "note_type_id" integer, "created_at" datetime, "updated_at" datetime)}9sBxFT$Je/j.&ACanadaCACANt2010-01-22 19:42:24.0000000%ACameroonCMCMRt2010-01-22 19:42:23.0000000$ACambodiaKHKHMt2010-01-22 19:42:23.000000/#ABurundiBIBDIt2010-01-22 19:42:23.0000004"%ABurkina FasoBFBFAt2010-01-22 19:42:23.0000000!ABulgariaBGBGRt2010-01-22 19:42:23.0000009 /ABrunei DarussalamBNBRNt2010-01-22 19:42:23.000000FIABritish Indian Ocean TerritoryIOIOTt2010-01-22 19:42:23.000000.ABrazilBRBRAt2010-01-22 19:42:23.0000005'ABouvet IslandBVBVTt2010-01-22 19:42:23.0000000ABotswanaBWBWAt2010-01-22 19:42:23.000000>9ABosnia and HerzegowinaBABIHt2010-01-22 19:42:23.000000/ABoliviaBOBOLt2010-01-22 19:42:23.000000.ABhutanBTBTNt2010-01-22 19:42:23.000000/ABermudaBMBMUt2010-01-22 19:42:23.000000-ABeninBJBENt2010-01-22 19:42:23.000000.ABelizeBZBLZt2010-01-22 19:42:23.000000/ABelgiumBEBELt2010-01-22 19:42:23.000000/ABelarusBYBLRt2010-01-22 19:42:23.0000000ABarbadosBBBRBt2010-01-22 19:42:23.0000002!ABangladeshBDBGDt2010-01-22 19:42:23.000000/ABahrainBHBHRt2010-01-22 19:42:23.000000/ABahamasBSBHSt2010-01-22 19:42:23.0000002!AAzerbaijanAZAZEt2010-01-22 19:42:22.000000/AAustriaATAUTt2010-01-22 19:42:22.0000001 AAustraliaAUAUSt2010-01-22 19:42:22.000000- AArubaAWABWt2010-01-22 19:42:22.000000/ AArmeniaAMARMt2010-01-22 19:42:22.0000001 AArgentinaARARGt2010-01-22 19:42:22.000000/ AAntiguaAGATGt2010-01-22 19:42:22.0000002!AAntarcticaAQATAt2010-01-22 19:42:22.0000000AAnguillaAIAIAt2010-01-22 19:42:22.000000.AAngolaAOAGOt2010-01-22 19:42:22.000000/AAndorraADANDt2010-01-22 19:42:22.0000006)AAmerican SamoaASASMt2010-01-22 19:42:22.000000/AAlgeriaDZDZAt2010-01-22 19:42:22.000000/AAlbaniaALALBt2010-01-22 19:42:22.0000003#AAfghanistaz_y<vustMs&~xlbTH9-!{pM7* w[NB8'q[OC6|pfXM?3$ ~pSJ>3)bWK?3'Liechtensteinz9Libyan Arab Jamahiriyay Liberiax Lesothow Lebanonv Latviau#KLao Peoples Democratic Republict!Kyrgyzstans Kuwaitr1Korea, Republic ofq*YKorea, Democratic People's Republic ofp Kiribatio Kenyan!Kazakhstanm Jordanl Japank Jamaicaj Italyi Israelh IrelandgIraqf=Iran, Islamic Republic oe Indonesiad Indiac Icelandb Hungarya Hong Kong` Honduras_CHeard and Mc Donald Islands^ Haiti] Guyana\'Guinea-bissau[ GuineaZ GuatemalaYGuamX!GuadeloupeW GrenadaV GreenlandU GreeceT GibraltarS GhanaR GermanyQ GeorgiaP GambiaO GabonNCFrench Southern TerritoriesM-French PolynesiaL'French GuianaK FranceI FinlandHFijiG'Faroe IslandsFCFalkland Islands (Malvinas)E EthiopiaD EstoniaC EritreaB/Equatorial GuineaA#El Salvador@ Egypt? Ecuador>1Dominican Republic< Dominica; Djibouti: Denmark9)Czech Republic8 Cyprus7Cuba6 Croatia5%Cote DIvoire4!Costa Rica3%Cook Islands2 Congo1 Comoros0 Colombia/;Cocos (Keeling) Islands.-Christmas Island- China, Chile+Chad*=Central African Republic))Cayman Islands(!Cape Verde' Canada& Cameroon% Cambodia$ Burundi#%Burkina Faso" Bulgaria!/Brunei Darussalam "IBritish Indian Ocean Territory Brazil'Bouvet Island Botswana9Bosnia and Herzegowina Bolivia Bhutan Bermuda Benin Belize Belgium Belarus Barbados!Bangladesh Bahrain Bahamas!Azerbaijan Austria Australia Aruba Armenia Argentina Antigua !Antarctica Anguilla Angola x7Saint Kitts and Nevisw"GHoly See (Vatican City State)|C{m _X J.Q5<tf5xjqc\U2N9}+$5@n|ugR=6Y'DK`/(! u %-eu]UmM}=u]mUEeM5=}e-% ]=mMUG-E %EUGTVTCTMTRTNTTTOTKTGTHTZTJTWSYCHSESZSJSRSDPMSHLKESGSZASOSBSISKSGSLSCSNSASTSMWSVCLCKNRWRUROREQAPRPTPLPNPHPEPYPGPAPWPKOMNOMPNFNUNGNENINZNCNLNPNRNAMMMZMAMSMNMCMDFMMXYTMUMRMQMHMTMLMVMYMWMGMK~MO}LU|LT{LIzLYyLRxLSwLBvLVuLAtKGsKWrKRqKPpKIoKEnKZmJOlJPkJMjITiILhIEgIQfIReIDdINcISbHUaHK`HN_HM^HT]GY\GW[GNZGTYGUXGPWGDVGLUGRTGISGHRDEQGEPGMOGANTFMPFLGFKFRIFIHFJGFOFFKEETDEECERBGQASV@EG?EC>DO<DM;DJ:DK9CZ8CY7CU6HR5CI4CR3CK2CG1KM0CO/CC.CX-CN,CL+TD*CF)KY(CV'CA&CM%KH$BI#BF"BG!BN IOBRBVBWBABOBTBMBJBZBEBYBBBDBHBSAZATAU AW AM AR AG AQAIAOADASDZ{KZmW)~Q'uKa3rDZ*0(%ANDNorth Dakota2011-12-14 18:41:06.3251012')ANCNorth Carolina2011-12-14 18:41:06.324359,&ANYNew York2011-12-14 18:41:06.323618.%!ANMNew Mexico2011-12-14 18:41:06.322858.$!ANJNew Jersey2011-12-14 18:41:06.3220781#'ANHNew Hampshire2011-12-14 18:41:06.321330*"ANVNevada2011-12-14 18:41:06.320543,!ANENebraska2011-12-14 18:41:06.319796+ AMTMontana2011-12-14 18:41:06.319056,AMOMissouri2011-12-14 18:41:06.318325/#AMSMississippi2011-12-14 18:41:06.317582-AMNMinnesota2011-12-14 18:41:06.316764,AMIMichigan2011-12-14 18:41:06.3159731'AMAMassachusetts2011-12-14 18:41:06.315190,AMDMaryland2011-12-14 18:41:06.3143904-AMHMarshall Islands2011-12-14 18:41:06.313603)AMEMaine2011-12-14 18:41:06.312770-ALALouisiana2011-12-14 18:41:06.311955,AKYKentucky2011-12-14 18:41:06.311200*AKSKansas2011-12-14 18:41:06.310441(AIAIowa2011-12-14 18:41:06.309234+AINIndiana2011-12-14 18:41:06.261099,AILIllinois2011-12-14 18:41:06.260252)AIDIdaho2011-12-14 18:41:06.259486*AHIHawaii2011-12-14 18:41:06.258699(AGUGuam2011-12-14 18:41:06.257850+AGAGeorgia2011-12-14 18:41:06.257041+ AFLFlorida2011-12-14 18:41:06.256267B IAFMFederated States Of Micronesia2011-12-14 18:41:06.2555198 5ADCDistrict of Columbia2011-12-14 18:41:06.254737, ADEDelaware2011-12-14 18:41:06.253926/ #ACTConnecticut2011-12-14 18:41:06.253158,ACOColorado2011-12-14 18:41:06.252410.!ACACalifornia2011-12-14 18:41:06.2515810%AAFArmed Forces2011-12-14 18:41:06.250808,AARArkansas2011-12-14 18:41:06.249995+AAZArizona2011-12-14 18:41:06.2491132)AASAmerican Samoa2011-12-14 18:41:06.248275*AAKAlaska2011-12-14 18:41:06.247398+AALAlabama2011-yP( %~xVPJD>82,& }ume]UME=5-% }ume]UME=5-%qjc\UNG@92+${tmf_XQJC<5.'  xqjc\~}|{zyxwvutsrqponmlkjihgfedcba`_^]\[ZQYQXQWQVQUQTQSQRQQQPQOQNQMQLQKQJ&I&H&G&F&E&D&C&B&A&@&?&>&=<;:9876543210/.-,+*)('&%$#"!       }mbw=sZ7+V Ke|j{0n`PC7*nG Y`7SveUDr3%1 DVL/Urix Tessinw Thurgauv Schwyzu Solothurnt%Schaffhausens!St. Gallenr Obwaldenq Nidwaldenp Neuenburgo LuzernnJuram#Graubündenl GlaruskGenfj Freiburgi#Basel-Stadth-Basel-LandschaftgBernf9Appenzell Ausserrhodene7Appenzell Innerrhodend Aargauc Voralbergb!Burgenlanda Tirol`!Steiermark_ Kärnten^ Salzburg]+Oberösterreich\/Niederösterreich[WienZ!ThüringenY1Schleswig-HolsteinX)Sachsen-AnhaltW SachsenV SaarlandU+Rheinland-PfalzT3Nordrhein-WestfalenS9Mecklenburg-VorpommernR HessenQ HamburgP BremenO#BrandenburgN BerlinM BayernL1Baden-WürttembergK'NiedersachsenJ+Yukon TerritoryI%SaskatchewanH QuebecG5Prince Edward IslandF OntarioE NunavutD7Northwest TerritoriesC#Nova ScotiaB'New BrunswickA%Newfoundland@ Manitoba?-British Columbia> Alberta= Wyoming< Wisconsin;'West Virginia:!Washington9 Virginia8)Virgin Islands7 Vermont6Utah5 Texas4 Tennessee3%South Dakota2)South Carolina1%Rhode Island0#Puerto Rico/%Pennsylvania. Palau- Oregon, Oklahoma+Ohio*=Northern Mariana Islands)%North Dakota()North Carolina' New York&!New Mexico%!New Jersey$'New Hampshire# Nevada" Nebraska! Montana Missouri#Mississippi Minnesota Michigan'Massachusetts Maryland-Marshall Islands Maine Louisiana Kentucky KansasIowa Indiana Illinois Idaho HawaiiGuam Georgia Florida "IFederated States Of Micronesia 5District of Columbia Delaware #Connecticut Colorado!California%Armed Forces Arkansas Arizona)American Samoa !New Jersey$ ~U;4-tgYL>3N&I&  yhYMAt{7^mf_)CGJXQ<5'. 9@ s2+$leWeXK@P1%xB qczj\ Zaragoza Zamora Vizcaya!Valladolid Valencia Toledo TeruelTarragona Soria Sevilla Segovia9Santa Cruz de TenerifeSalamanca!Pontevedra Palencia Ourense Navarra Murcia Melilla Malaga Madrid Lugo Lleida Leon!Las Palmas La Rioja Jaen Huesca HuelvaGuipuzcoa#Guadalajara Granada Girona Cuenca Cordoba#Ciudad Real CeutaCastellonCantabria Cadiz Caceres BurgosBarcelona Baleares Badajoz Avila Asturias Almeria Alicante Albacete Alava~ A Coruña}ZH|ZG{VSzVDyURxTIwTGvSZuSOtSHsSGrOWqNWpNEoLUnJUmJUlGLkGEjFRiBShBLgBEfAReAIdAGcVBbBLaTI`ST_KN^SB]OO\NO[WIZTHEYSCNXSACWSASVSARURHETNRWSMECRHESQHAMPBREOBRGNBERMBAYLBAWKNDSJYTISKHQCGPEFONENUDNTCNSBNBANF@MB?BC>AB=WY<WI;WV:WA9VA8VI7VT6UT5TX4TN3SD2SC1RI0PR/PA.PW-OR,OK+OH*MP)ND(NC'NY&NM%NJ$NH#NV"NE!MT MOMSMNMIMAMDMHMELAKYKSIAINILIDHIGUGAFL FM DC DE CT COCAAFARAZASAKAL     I'2Jra--]tablevalid_note_typesvalid_note_typesoCREATE TABLE "valid_note_ad++{tabledata_migrationsdata_migrationsrCREATE TABLE "data_migrations" ("version" varchar(255))cY-Eindexindex_valid_note_types_on_note_type_idvalid_note_typesqCREATE INDEX "index_valid_note_types_on_note_type_id" ON "valid_note_types" ("note_type_id")=[u{indexindex_notes_on_noted_record_id_and_noted_record_typenoteshCREATE INDEX "index_notes_on_noted_record_id_and_noted_record_type" ON "notes" ("noted_record_id", "noted_record_type")s\Cindexindex_notes_on_note_type_idnotesiCREATE INDEX "index_notes_on_note_type_id" ON "notes" ("note_type_id")v]Eindexindex_notes_on_created_by_idnotesjCREATE INDEX "index_notes_on_created_by_id" ON "notes" ("created_by_id")d^9indexindex_notes_on_contentnoteslCREATE INDEX "index_notes_on_content" ON "notes" ("content")v_!!7tablenote_typesnote_typesmCREATE TABLE "note_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "note_type_record_id" integer, "note_type_record_type" varchar(255), "created_at" datetime, "updated_at" datetime)`5!Uindexnote_type_record_idxnote_typesnCREATE INDEX "note_type_record_idx" ON "note_types" ("note_type_record_id", "note_type_record_type")a--]tablevalid_note_typesvalid_note_typesoCREATE TABLE "valid_note_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "valid_note_type_record_id" integer, "valid_note_type_record_type" varchar(255), "note_type_id" integer, "created_at" datetime, "updated_at" datetime)3bA-indexvalid_note_type_record_idxvalid_note_typespCREATE INDEX "valid_note_type_record_idx" ON "valid_note_types" ("valid_note_type_record_id", "valid_note_type_record_type")       )20111111144706)20110913145838)20110802200222)20110609150135)20110525001935 &ji1j9sBxFT$Je/j.&ACanadaCACANt2010-01-22 19:42:24.0000000%ACameroonCMCMRt2010-01-22 19:42:23.0000000$ACambodiaKHKHMt2010-01-22 19:42:23.000000/#ABurundiBIBDIt2010-01-22 19:42:23.0000004"%ABurkina FasoBFBFAt2010-01-22 19:42:23.0000000!ABulgariaBGBGRt2010-01-22 19:42:23.0000009 /ABrunei DarussalamBNBRNt2010-01-22 19:42:23.000000FIABritish Indian Ocean TerritoryIOIOTt2010-01-22 19:42:23.000000.ABrazilBRBRAt2010-01-22 19:42:23.0000005'ABouvet IslandBVBVTt2010-01-22 19:42:23.0000000ABotswanaBWBWAt2010-01-22 19:42:23.000000>9ABosnia and HerzegowinaBABIHt2010-01-22 19:42:23.000000/ABoliviaBOBOLt2010-01-22 19:42:23.000000.ABhutanBTBTNt2010-01-22 19:42:23.000000/ABermudaBMBMUt2010-01-22 19:42:23.000000-ABeninBJBENt2010-01-22 19:42:23.000000.ABelizeBZBLZt2010-01-22 19:42:23.000000/ABelgiumBEBELt2010-01-22 19:42:23.000000/ABelarusBYBLRt2010-01-22 19:42:23.0000000ABarbadosBBBRBt2010-01-22 19:42:23.0000002!ABangladeshBDBGDt2010-01-22 19:42:23.000000/ABahrainBHBHRt2010-01-22 19:42:23.000000/ABahamasBSBHSt2010-01-22 19:42:23.0000002!AAzerbaijanAZAZEt2010-01-22 19:42:22.000000/AAustriaATAUTt2010-01-22 19:42:22.0000001 AAustraliaAUAUSt2010-01-22 19:42:22.000000- AArubaAWABWt2010-01-22 19:42:22.000000/ AArmeniaAMARMt2010-01-22 19:42:22.0000001 AArgentinaARARGt2010-01-22 19:42:22.000000/ AAntiguaAGATGt2010-01-22 19:42:22.0000002!AAntarcticaAQATAt2010-01-22 19:42:22.0000000AAnguillaAIAIAt2010-01-22 19:42:22.000000.AAngolaAOAGOt2010-01-22 19:42:22.000000/AAndorraADANDt2010-01-22 19:42:22.0000006)AAmerican SamoaASASMt2010-01-22 19:42:22.000000/AAlgeriaDZDZAt2010-01-22 19:42:22.000000/AAlbaniaALALBt2010-01-22 19:42:22.0000003#AAfghanistanAFAFGt2010-01-22 19:42:22.000000 %\R$KOR!P!OsB\CMCAFrench Southern TerritoriesTFATFt2010-01-22 19:42:25.0000008L-AFrench PolynesiaPFPYFt2010-01-22 19:42:25.0000005K'AFrench GuianaGFGUFt2010-01-22 19:42:25.000000.IAFranceFRFRAt2010-01-22 19:42:25.000000/HAFinlandFIFINt2010-01-22 19:42:25.000000,GAFijiFJFJIt2010-01-22 19:42:25.0000005F'AFaroe IslandsFOFROt2010-01-22 19:42:25.000000CECAFalkland Islands (Malvinas)FKFLKt2010-01-22 19:42:25.0000000DAEthiopiaETETHt2010-01-22 19:42:25.000000/CAEstoniaEEESTt2010-01-22 19:42:25.000000/BAEritreaERERIt2010-01-22 19:42:25.0000009A/AEquatorial GuineaGQGNQt2010-01-22 19:42:25.0000003@#AEl SalvadorSVSLVt2010-01-22 19:42:25.000000-?AEgyptEGEGYt2010-01-22 19:42:25.000000/>AEcuadorECECUt2010-01-22 19:42:25.000000:<1ADominican RepublicDODOMt2010-01-22 19:42:25.0000000;ADominicaDMDMAt2010-01-22 19:42:24.0000000:ADjiboutiDJDJIt2010-01-22 19:42:24.000000/9ADenmarkDKDNKt2010-01-22 19:42:24.00000068)ACzech RepublicCZCZEt2010-01-22 19:42:24.000000.7ACyprusCYCYPt2010-01-22 19:42:24.000000,6ACubaCUCUBt2010-01-22 19:42:24.000000/5ACroatiaHRHRVt2010-01-22 19:42:24.00000044%ACote DIvoireCICIVt2010-01-22 19:42:24.00000023!ACosta RicaCRCRIt2010-01-22 19:42:24.00000042%ACook IslandsCKCOKt2010-01-22 19:42:24.000000-1ACongoCGCOGt2010-01-22 19:42:24.000000/0AComorosKMCOMt2010-01-22 19:42:24.0000000/AColombiaCOCOLt2010-01-22 19:42:24.000000?.;ACocos (Keeling) IslandsCCCCKt2010-01-22 19:42:24.0000008--AChristmas IslandCXCXRt2010-01-22 19:42:24.000000-,AChinaCNCHNt2010-01-22 19:42:24.000000-+AChileCLCHLt2010-01-22 19:42:24.000000,*AChadTDTCDt2010-01-22 19:42:24.000000@)=ACentral African RepublicCFCAFt2010-01-22 19:42:24.0000006()ACayman IslandsKYCYMt2010-01-22 19:42:24.0000002'!ACape VerdeCVCPVt2010-01-22 19:42:24.000000 &kp?zIMwD>O [ k2s!AKyrgyzstanKGKGZt2010-01-22 19:42:28.000000.rAKuwaitKWKWTt2010-01-22 19:42:28.000000:q1AKorea, Republic ofKRKORt2010-01-22 19:42:28.000000NpYAKorea, Democratic People's Republic ofKPPRKt2010-01-22 19:42:28.0000000oAKiribatiKIKIRt2010-01-22 19:42:28.000000-nAKenyaKEKENt2010-01-22 19:42:28.0000002m!AKazakhstanKZKAZt2010-01-22 19:42:27.000000.lAJordanJOJORt2010-01-22 19:42:27.000000-kAJapanJPJPNt2010-01-22 19:42:27.000000/jAJamaicaJMJAMt2010-01-22 19:42:27.000000-iAItalyITITAt2010-01-22 19:42:27.000000.hAIsraelILISRt2010-01-22 19:42:27.000000/gAIrelandIEIRLt2010-01-22 19:42:27.000000,fAIraqIQIRQt2010-01-22 19:42:27.000000@e=AIran, Islamic Republic oIRIRNt2010-01-22 19:42:27.0000001dAIndonesiaIDIDNt2010-01-22 19:42:27.000000-cAIndiaININDt2010-01-22 19:42:27.000000/bAIcelandISISLt2010-01-22 19:42:26.000000/aAHungaryHUHUNt2010-01-22 19:42:26.0000001`AHong KongHKHKGt2010-01-22 19:42:26.0000000_AHondurasHNHNDt2010-01-22 19:42:26.000000C^CAHeard and Mc Donald IslandsHMHMDt2010-01-22 19:42:26.000000-]AHaitiHTHTIt2010-01-22 19:42:26.000000.\AGuyanaGYGUYt2010-01-22 19:42:26.0000005['AGuinea-bissauGWGNBt2010-01-22 19:42:26.000000.ZAGuineaGNGINt2010-01-22 19:42:26.0000001YAGuatemalaGTGTMt2010-01-22 19:42:26.000000,XAGuamGUGUMt2010-01-22 19:42:26.0000002W!AGuadeloupeGPGLPt2010-01-22 19:42:26.000000/VAGrenadaGDGRDt2010-01-22 19:42:26.0000001UAGreenlandGLGRLt2010-01-22 19:42:26.000000.TAGreeceGRGRCt2010-01-22 19:42:26.0000001SAGibraltarGIGIBt2010-01-22 19:42:26.000000-RAGhanaGHGHAt2010-01-22 19:42:26.000000/QAGermanyDEDEUt2010-01-22 19:42:25.000000/PAGeorgiaGEGEOt2010-01-22 19:42:25.000000.OAGambiaGMGMBt2010-01-22 19:42:25.000000-NAGabonGAGABt2010-01-22 19:42:25.000000 $rV%}J_.i.^-s@ r@r5'ANew CaledoniaNCNCLt2010-01-22 19:42:30.0000003#ANetherlandsNLNLDt2010-01-22 19:42:30.000000-ANepalNPNPLt2010-01-22 19:42:30.000000-ANauruNRNRUt2010-01-22 19:42:30.000000/ANamibiaNANAMt2010-01-22 19:42:30.000000/AMyanmarMMMMRt2010-01-22 19:42:30.0000002!AMozambiqueMZMOZt2010-01-22 19:42:29.000000/AMoroccoMAMARt2010-01-22 19:42:29.0000002!AMontserratMSMSRt2010-01-22 19:42:29.0000000AMongoliaMNMNGt2010-01-22 19:42:29.000000. AMonacoMCMCOt2010-01-22 19:42:29.000000< 5AMoldova, Republic ofMDMDAt2010-01-22 19:42:29.000000G KAMicronesia, Federated States ofFMFSMt2010-01-22 19:42:29.000000. AMexicoMXMEXt2010-01-22 19:42:29.000000/ AMayotteYTMYTt2010-01-22 19:42:29.0000001AMauritiusMUMUSt2010-01-22 19:42:29.0000002!AMauritaniaMRMRTt2010-01-22 19:42:29.0000002!AMartiniqueMQMTQt2010-01-22 19:42:29.0000008-AMarshall IslandsMHMHLt2010-01-22 19:42:29.000000-AMaltaMTMLTt2010-01-22 19:42:29.000000,AMaliMLMLIt2010-01-22 19:42:29.0000000AMaldivesMVMDVt2010-01-22 19:42:29.0000000AMalaysiaMYMYSt2010-01-22 19:42:29.000000.AMalawiMWMWIt2010-01-22 19:42:29.0000002!AMadagascarMGMDGt2010-01-22 19:42:29.000000R~aAMacedonia, The Former Yugoslav Republic ofMKMKDt2010-01-22 19:42:29.000000-}AMacaoMOMACt2010-01-22 19:42:29.0000002|!ALuxembourgLULUXt2010-01-22 19:42:28.0000001{ALithuaniaLTLTUt2010-01-22 19:42:28.0000005z'ALiechtensteinLILIEt2010-01-22 19:42:28.000000>y9ALibyan Arab JamahiriyaLYLBYt2010-01-22 19:42:28.000000/xALiberiaLRLBRt2010-01-22 19:42:28.000000/wALesothoLSLSOt2010-01-22 19:42:28.000000/vALebanonLBLBNt2010-01-22 19:42:28.000000.uALatviaLVLVAt2010-01-22 19:42:28.000000GtKALao Peoples Democratic RepublicLALAOt2010-01-22 19:42:28.000000 _s )5COYgs!.@Kn%/D`my $0:J`lx(3?KUcn|s  +:DQ|'Liecht#Afghanistan Albania Algeria)American Samoa Andorra Angola Anguilla!Antarctica Antigua Argentina Armenia Aruba Australia Austria!Azerbaijan Bahamas Bahrain!Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia9Bosnia and Herzegowi Guernsey&OCongo, Democratic Republic of the'Aland Islands#Afghanistan Albania Algeria)American Samoa Andorra Angola Anguilla!Antarctica Antigua Argentina Armenia Aruba Australia Austria!Azerbaijan Bahamas Bahrain!Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia9Bosnia and Herzegowina Botswana'Bouvet Island Brazil"IBritish Indian Ocean Territory/Brunei Darussalam Bulgaria!%Burkina Faso" Burundi# Cambodia$ Cameroon% Canada&!Cape Verde')Cayman Islands(=Central African Republic)Chad* Chile+ China,-Christmas Island-;Cocos (Keeling) Islands. Colombia/ Comoros0 Congo1%Cook Islands2!Costa Rica3%Cote DIvoire4 Croatia5Cuba6 Cyprus7)Czech Republic8 Denmark9 Djibouti: Dominica;1Dominican Republic< Ecuador> Egypt?#El Salvador@/Equatorial GuineaA EritreaB EstoniaC EthiopiaDCFalkland Islands (Malvinas)E'Faroe IslandsFFijiG FinlandH FranceI'French GuianaK-French PolynesiaLCFrench Southern TerritoriesM GabonN GambiaO GeorgiaP GermanyQ GhanaR GibraltarS GreeceT GreenlandU GrenadaV!GuadeloupeWGuamX GuatemalaY GuineaZ'Guinea-bissau[ Guyana\ Haiti]CHeard and Mc Donald Islands^ YY 7@LWamw(3?KWr&<L\kx $/:K^o~} #1;LoZftY (FR^k'Liechtensteinz Lithuania{!Luxembourg| Macao}.aMacedonia, The Former Yugoslav Republic of~!Madagascar Malawi Malaysia Maldives Mali Malta-Marshall Islands!Martinique!MauritaniaMauritius Mayotte Mexico$KMicronesia, Federated States of5Moldova, Republic of Monaco Mongolia!Montserrat -Saint Barthelemy Pitcairn$KPalestinian Territory, Occupied!Montenegro Jersey#Isle of Man Honduras_ Hong Kong` Hungarya Icelandb Indiac Indonesiad=Iran, Islamic Republic oeIraqf Irelandg Israelh Italyi Jamaicaj Japank Jordanl!Kazakhstanm Kenyan Kiribatio*YKorea, Democratic People's Republic ofp1Korea, Republic ofq Kuwaitr!Kyrgyzstans#KLao Peoples Democratic Republict Latviau Lebanonv Lesothow Liberiax9Libyan Arab Jamahiriyay'Liechtensteinz Lithuania{!Luxembourg| Macao}.aMacedonia, The Former Yugoslav Republic of~!Madagascar Malawi Malaysia Maldives Mali Malta-Marshall Islands!Martinique!MauritaniaMauritius Mayotte Mexico$KMicronesia, Federated States of5Moldova, Republic of Monaco Mongolia!Montserrat Morocco!Mozambique Myanmar Namibia Nauru Nepal#Netherlands'New Caledonia#New ZealandNicaragua Niger Nigeria Niue)Norfolk Island=Northern Mariana Islands Norway Oman Pakistan Palau Panama-Papua New Guinea Paraguay Peru#Philippines Pitcairn Poland Portugal#Puerto Rico Qatar Reunion Romania1Russian Federation Rwanda1eSaint Helena, Ascension and Tristan da Cunha $f4X)Z'^+a$}2V$1<ASingaporeSGSGPt2010-01-22 19:42:32.0000004;%ASierra LeoneSLSLEt2010-01-22 19:42:31.0000002:!ASeychellesSCSYCt2010-01-22 19:42:31.000000/9ASenegalSNSENt2010-01-22 19:42:31.00000048%ASaudi ArabiaSASAUt2010-01-22 19:42:31.000000=77ASao Tome and PrincipeSTSTPt2010-01-22 19:42:31.00000026!ASan MarinoSMSMRt2010-01-22 19:42:31.000000-5ASamoaWSWSMt2010-01-22 19:42:31.000000H4MASaint Vincent and the GrenadinesVCVCTt2010-01-22 19:42:31.00000033#ASaint LuciaLCLCAt2010-01-22 19:42:31.000000=27ASaint Kitts and NevisKNKNAt2010-01-22 19:42:31.000000.1ARwandaRWRWAt2010-01-22 19:42:31.000000:01ARussian FederationRURUSt2010-01-22 19:42:31.000000//ARomaniaROROMt2010-01-22 19:42:31.000000/.AReunionREREUt2010-01-22 19:42:31.000000--AQatarQAQATt2010-01-22 19:42:31.0000003,#APuerto RicoPRPRIt2010-01-22 19:42:31.0000000+APortugalPTPRTt2010-01-22 19:42:31.000000.*APolandPLPOLt2010-01-22 19:42:31.0000000)APitcairnPNPCNt2010-01-22 19:42:31.0000003(#APhilippinesPHPHLt2010-01-22 19:42:31.000000,'APeruPEPERt2010-01-22 19:42:30.0000000&AParaguayPYPRYt2010-01-22 19:42:30.0000008%-APapua New GuineaPGPNGt2010-01-22 19:42:30.000000.$APanamaPAPANt2010-01-22 19:42:30.000000-#APalauPWPLWt2010-01-22 19:42:30.0000000"APakistanPKPAKt2010-01-22 19:42:30.000000,!AOmanOMOMNt2010-01-22 19:42:30.000000. ANorwayNONORt2010-01-22 19:42:30.000000@=ANorthern Mariana IslandsMPMNPt2010-01-22 19:42:30.0000006)ANorfolk IslandNFNFKt2010-01-22 19:42:30.000000,ANiueNUNIUt2010-01-22 19:42:30.000000/ANigeriaNGNGAt2010-01-22 19:42:30.000000-ANigerNENERt2010-01-22 19:42:30.0000001ANicaraguaNINICt2010-01-22 19:42:30.0000003#ANew ZealandNZNZLt2010-01-22 19:42:30.000000 #S`.p<q>b#vCtBf5S5_'AUnited StatesUSUSAt2010-01-22 19:42:33.0000006^)AUnited KingdomGBGBRt2010-01-22 19:42:33.000000<]5AUnited Arab EmiratesAEAREt2010-01-22 19:42:33.000000/\AUkraineUAUKRt2010-01-22 19:42:33.000000.[AUgandaUGUGAt2010-01-22 19:42:33.000000.ZATuvaluTVTUVt2010-01-22 19:42:33.000000@Y=ATurks and Caicos IslandsTCTCAt2010-01-22 19:42:33.0000004X%ATurkmenistanTMTKMt2010-01-22 19:42:33.000000.WATurkeyTRTURt2010-01-22 19:42:33.000000/VATunisiaTNTUNt2010-01-22 19:42:33.000000;U3ATrinidad and TobagoTTTTOt2010-01-22 19:42:33.000000-TATongaTOTONt2010-01-22 19:42:33.000000/SATokelauTKTKLt2010-01-22 19:42:33.000000,RATogoTGTGOt2010-01-22 19:42:33.0000000QAThailandTHTHAt2010-01-22 19:42:32.000000DPEATanzania, United Republic ofTZTZAt2010-01-22 19:42:32.0000002O!ATajikistanTJTJKt2010-01-22 19:42:32.000000.NATaiwanTWTWNt2010-01-22 19:42:32.000000I9ASvalbard and Jan MayenSJSJMt2010-01-22 19:42:32.0000000HASurinameSRSURt2010-01-22 19:42:32.000000-GASudanSDSDNt2010-01-22 19:42:32.000000AF?ASaint Pierre and MiquelonPMSPMt2010-01-22 19:42:32.000000TEeASaint Helena, Ascension and Tristan da CunhaSHSHNt2010-01-22 19:42:32.0000001DASri LankaLKLKAt2010-01-22 19:42:32.000000-CASpainESESPt2010-01-22 19:42:32.000000TBeASouth Georgia and the South Sandwich IslandsGSSGSt2010-01-22 19:42:32.0000004A%ASouth AfricaZAZAFt2010-01-22 19:42:32.000000/@ASomaliaSOSOMt2010-01-22 19:42:32.0000007?+ASolomon IslandsSBSLBt2010-01-22 19:42:32.0000000>ASloveniaSISVNt2010-01-22 19:42:32.0000000=ASlovakiaSKSVKt2010-01-22 19:42:32.000000 z#*18?FMT[bipw~  '.5<CJQX_fmt{ &-4;BIPW^elsz %-eu]UmM}=u]mUEeM5=}e-% ]=mMUG-E %EUGTVTCTMTRTNTTTOTKTGTHTZTJTWSYCHSESZSJSRSDPMSHLKESGSZASOSBSISKSGSLSCSNSASTSMWSVCLCKNRWRUROREQAPRPTPLPNPHPEPYPGPAPWPKOMNOMPNFNUNGNENINZNCNLNPNRNAMMMZMAMSMNMCMDFMMXYTMUMRMQMHMTMLMVMYMWMGBLJEIMGGCDAXEHGBAEADAFAG AIALAM AOAQAR ASATAU AW AZBABBBDBEBF"BG!BHBI#BJBMBN BOBRBSBTBVBWBYBZCA&CC.CF)CG1CHCI4CK2CL+CM%CN,CO/CR3CU6CV'CX-CY7CZ8DEQDJ:DK9DM;DO<DZEC>EECEG?ERBESETDFIHFJGFKEFMFOFFRIGANGDVGEPGFKGHRGISGLUGMOGNZGPWGQAGRTGSGTYGUXGW[GY\HK`HM^HN_HR5HT]HUaIDdIEgILhINcIOIQfIReISbITiJMjJOlJPkKEnKGsKH$KIoKM0KNKPpKRqKWrKY( {8  '/7X`?FNU]emt| $,4<DKS[cks8{P@ #+3;CJRZbipxHxphPNRSTLPSMEMFZWZMYEWFVIVGVNVEVAVUUZUYUMUSLAtLBvLCLIzLKLRxLSwLT{LU|LVuLYyMAMCMDMGMHMK~MLMMMNMO}MPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFLPGPHPKPLPMPNPRPTPWPYQARERORURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSTSV@SYSZTCTD*TFMTGTHTJTKTMTNTOTRTTTVTWTZUAUGVCWSYTZA 6Ji'sCp$U q68{-ASaint BarthelemyBLBLMt2010-09-29 19:42:35.0000000zAPitcairnPNPCNt2010-09-29 19:42:35.000000.yASerbiaRSSRBt2010-09-29 19:42:35.0000003x#ATimor-LesteTLTLSt2010-09-29 19:42:35.000000GwKAPalestinian Territory, OccupiedPSPSEt2010-09-29 19:42:35.0000002v!AMontenegroMEMNEt2010-09-29 19:42:35.000000.uAJerseyJEJEYt2010-09-29 19:42:35.0000003t#AIsle of ManIMIMNt2010-09-29 19:42:35.0000000sAGuernseyGGGGYt2010-09-29 19:42:35.000000IrOACongo, Democratic Republic of theCDCODt2010-09-29 19:42:35.0000005q'AAland IslandsAXALAt2010-09-02 19:42:35.0000004p%ASaint MartinMFMAFt2010-09-02 19:42:35.0000000oAZimbabweZWZWEt2010-01-22 19:42:35.000000.nAZambiaZMZMBt2010-01-22 19:42:34.000000-kAYemenYEYEMt2010-01-22 19:42:34.0000006j)AWestern SaharaEHESHt2010-01-22 19:42:34.0000009i/AWallis and FutunaWFWLFt2010-01-22 19:42:34.000000~Jg3sFU%Z/_3}+PAQHAMHamburg2011-12-14 18:41:06.356635*OAQBREBremen2011-12-14 18:41:06.355895/N#AQBRGBrandenburg2011-12-14 18:41:06.355128*MAQBERBerlin2011-12-14 18:41:06.354356*LAQBAYBayern2011-12-14 18:41:06.3535756K1AQBAWBaden-Württemberg2011-12-14 18:41:06.3528371J'AQNDSNiedersachsen2011-12-14 18:41:06.3520592I+A&YTYukon Territory2011-12-14 18:41:06.351266/H%A&SKSaskatchewan2011-12-14 18:41:06.350399)GA&QCQuebec2011-12-14 18:41:06.3496027F5A&PEPrince Edward Island2011-12-14 18:41:06.348804*EA&ONOntario2011-12-14 18:41:06.347992*DA&NUNunavut2011-12-14 18:41:06.3471718C7A&NTNorthwest Territories2011-12-14 18:41:06.346354.B#A&NSNova Scotia2011-12-14 18:41:06.3454200A'A&NBNew Brunswick2011-12-14 18:41:06.344671/@%A&NFNewfoundland2011-12-14 18:41:06.343908+?A&MBManitoba2011-12-14 18:41:06.3431633>-A&BCBritish Columbia2011-12-14 18:41:06.342383*=A&ABAlberta2011-12-14 18:41:06.341596+<AWYWyoming2011-12-14 18:41:06.340810-;AWIWisconsin2011-12-14 18:41:06.3400561:'AWVWest Virginia2011-12-14 18:41:06.339237.9!AWAWashington2011-12-14 18:41:06.338497,8AVAVirginia2011-12-14 18:41:06.33773827)AVIVirgin Islands2011-12-14 18:41:06.336992+6AVTVermont2011-12-14 18:41:06.336230(5AUTUtah2011-12-14 18:41:06.335485)4ATXTexas2011-12-14 18:41:06.334713-3ATNTennessee2011-12-14 18:41:06.33396802%ASDSouth Dakota2011-12-14 18:41:06.33321921)ASCSouth Carolina2011-12-14 18:41:06.33243800%ARIRhode Island2011-12-14 18:41:06.331596//#APRPuerto Rico2011-12-14 18:41:06.3307660.%APAPennsylvania2011-12-14 18:41:06.329954)-APWPalau2011-12-14 18:41:06.329089*,AOROregon2011-12-14 18:41:06.328230,+AOKOklahoma2011-12-14 18:41:06.327484(*AOHOhio2011-12-14 18:41:06.326736<)=AMPNorthern Mariana Islands2011-12-14 18:41:06.325935 )[_*c3 sFd)\.}Q"c4[)yAVDWaadt2011-12-14 18:41:06.388834'xAURUri2011-12-14 18:41:06.388090*wATITessin2011-12-14 18:41:06.387338+vATGThurgau2011-12-14 18:41:06.386574*uASZSchwyz2011-12-14 18:41:06.385811-tASOSolothurn2011-12-14 18:41:06.3849970s%ASHSchaffhausen2011-12-14 18:41:06.384161.r!ASGSt. Gallen2011-12-14 18:41:06.383394,qAOWObwalden2011-12-14 18:41:06.382593-pANWNidwalden2011-12-14 18:41:06.381786-oANENeuenburg2011-12-14 18:41:06.380977*nALULuzern2011-12-14 18:41:06.380160(mAJUJura2011-12-14 18:41:06.379368/l#AJUGraubünden2011-12-14 18:41:06.378569*kAGLGlarus2011-12-14 18:41:06.377750(jAGEGenf2011-12-14 18:41:06.376800,iAFRFreiburg2011-12-14 18:41:06.376034/h#ABSBasel-Stadt2011-12-14 18:41:06.3752634g-ABLBasel-Landschaft2011-12-14 18:41:06.374523(fABEBern2011-12-14 18:41:06.373782:e9AARAppenzell Ausserrhoden2011-12-14 18:41:06.3729749d7AAIAppenzell Innerrhoden2011-12-14 18:41:06.372185*cAAGAargau2011-12-14 18:41:06.371423,bAVBVoralberg2011-12-14 18:41:06.370632-a!ABLBurgenland2011-12-14 18:41:06.369875(`ATITirol2011-12-14 18:41:06.369130-_!ASTSteiermark2011-12-14 18:41:06.368383+^AKNKärnten2011-12-14 18:41:06.367639+]ASBSalzburg2011-12-14 18:41:06.3668932\+AOOOberösterreich2011-12-14 18:41:06.3661144[/ANONiederösterreich2011-12-14 18:41:06.365324'ZAWIWien2011-12-14 18:41:06.364536.Y!AQTHEThüringen2011-12-14 18:41:06.3637466X1AQSCNSchleswig-Holstein2011-12-14 18:41:06.3629332W)AQSACSachsen-Anhalt2011-12-14 18:41:06.362072+VAQSASSachsen2011-12-14 18:41:06.361310,UAQSARSaarland2011-12-14 18:41:06.3605163T+AQRHERheinland-Pfalz2011-12-14 18:41:06.3597187S3AQNRWNordrhein-Westfalen2011-12-14 18:41:06.358926:R9AQMECMecklenburg-Vorpommern2011-12-14 18:41:06.358135*QAQHESHessen2011-12-14 18:41:06.357376 bhv^QC6(-BR]hq|%1>GpSc^RnCw7+! #8EWr1 DVL/Urix Tessinw Thurgauv Schwyzu Solothurnt%Schaffhausens!St. Gallenr Obwaldenq Nidwaldenp Neuenburgo LuzernnJuram#Graubündenl GlaruskGenfj Freiburgi#Basel-Stadth-Basel-LandschaftgBernf9Appenzell Ausserrhodene7Appenzell Innerrhodend Aargauc Voralbergb!Burgenlanda Tirol`!Steiermark_ Kärnten^ Salzburg]+Oberösterreich\/Niederösterre Navarra Murcia Melilla Malaga Madrid Lugo Lleida Leon!Las Palmas La Rioja Jaen Huesca HuelvaGuipuzcoa#Guadalajara Granada Girona Cuenca Cordoba#Ciudad Real CeutaCastellonCantabria Cadiz Caceres BurgosBarcelona Baleares Badajoz Avila Asturias Almeria Alicante Albacete Alava~ A Coruña} Aargauc Alabama Alaska Alberta=)American Samoa9Appenzell Ausserrhodene7Appenzell Innerrhodend Arizona Arkansas%Armed Forces1Baden-WürttembergK-Basel-Landschaftg#Basel-Stadth BayernL BerlinMBernf#BrandenburgN BremenO-British Columbia>!Burgenlanda!California Colorado#Connecticut Delaware 5District of Columbia "IFederated States Of Micronesia Florida FreiburgiGenfj Georgia Glarusk#GraubündenlGuam HamburgP Hawaii HessenQ Idaho Illinois IndianaIowaJuram Kansas Kentucky Kärnten^ Louisiana Luzernn Maine Manitoba?-Marshall Islands Maryland'Massachusetts9Mecklenburg-VorpommernR Michigan Minnesota#Mississippi Missouri Montana Nebraska! Neuenburgo Nevada"'New BrunswickA'New Hampshire# M)F`p|^P@->KW1jw $.:IS[dpwk Zaragoza Zamora Vizcaya!Valladolid Valencia Toledo TeruelTarragona Soria Sevilla Segovia9Santa Cruz de TenerifeSalamanca!Pontevedra Palencia Ourense Zürich|Zug{ Wallisz!New Mexico% New York&%Newfoundland@ Nidwaldenp'NiedersachsenJ/Niederösterreich[3Nordrhein-WestfalenS)North Carolina'%North Dakota(=Northern Mariana Islands)7Northwest TerritoriesC#Nova ScotiaB NunavutD+Oberösterreich\ ObwaldenqOhio* Oklahoma+ OntarioE Oregon, Palau-%Pennsylvania.5Prince Edward IslandF#Puerto Rico/ QuebecG+Rheinland-PfalzT%Rhode Island0 SaarlandU SachsenV)Sachsen-AnhaltW Salzburg]%SaskatchewanH%Schaffhausens1Schleswig-HolsteinX Schwyzu Solothurnt)South Carolina1%South Dakota2!St. Gallenr!Steiermark_ Tennessee3 Tessinw Texas4 Thurgauv!ThüringenY Tirol`UrixUtah5 Vermont6)Virgin Islands7 Virginia8 Voralbergb Waadty!Washington9'West Virginia:WienZ Wisconsin; Wyoming<+Yukon TerritoryI &~H~I{JzK{H tG{N.AMurciaMurcia2011-12-14 18:41:06.4178870AMelillaMelilla2011-12-14 18:41:06.417141.AMalagaMalaga2011-12-14 18:41:06.416390.AMadridMadrid2011-12-14 18:41:06.415631*ALugoLugo2011-12-14 18:41:06.414885.ALleidaLleida2011-12-14 18:41:06.414149*ALeonLeon2011-12-14 18:41:06.4133996!!ALas PalmasLas Palmas2011-12-14 18:41:06.4126152ALa RiojaLa Rioja2011-12-14 18:41:06.411875*AJaenJaen2011-12-14 18:41:06.411086.AHuescaHuesca2011-12-14 18:41:06.410339.AHuelvaHuelva2011-12-14 18:41:06.4095794AGuipuzcoaGuipuzcoa2011-12-14 18:41:06.4088188##AGuadalajaraGuadalajara2011-12-14 18:41:06.4080620AGranadaGranada2011-12-14 18:41:06.407314.AGironaGirona2011-12-14 18:41:06.406531.ACuencaCuenca2011-12-14 18:41:06.4057530ACordobaCordoba2011-12-14 18:41:06.4049938 ##ACiudad RealCiudad Real2011-12-14 18:41:06.404231, ACeutaCeuta2011-12-14 18:41:06.4034864 ACastellonCastellon2011-12-14 18:41:06.4027124 ACantabriaCantabria2011-12-14 18:41:06.401931, ACadizCadiz2011-12-14 18:41:06.4011300ACaceresCaceres2011-12-14 18:41:06.400372.ABurgosBurgos2011-12-14 18:41:06.3995534ABarcelonaBarcelona2011-12-14 18:41:06.3987982ABalearesBaleares2011-12-14 18:41:06.3980500ABadajozBadajoz2011-12-14 18:41:06.397303,AAvilaAvila2011-12-14 18:41:06.3965592AAsturiasAsturias2011-12-14 18:41:06.3957500AAlmeriaAlmeria2011-12-14 18:41:06.3949992AAlicanteAlicante2011-12-14 18:41:06.3942412AAlbaceteAlbacete2011-12-14 18:41:06.393483,~AAlavaAlava2011-12-14 18:41:06.3927424}AA CoruñaA Coruña2011-12-14 18:41:06.391932+|AZHZürich2011-12-14 18:41:06.391091'{AZGZug2011-12-14 18:41:06.390338*zAVSWallis2011-12-14 18:41:06.389589 oe,q>vAo20AZaragozaZaragoza2011-12-14 18:41:06.430762./AZamoraZamora2011-12-14 18:41:06.4300170.AVizcayaVizcaya2011-12-14 18:41:06.4292086-!!AValladolidValladolid2011-12-14 18:41:06.4284692,AValenciaValencia2011-12-14 18:41:06.427719.+AToledoToledo2011-12-14 18:41:06.426981.*ATeruelTeruel2011-12-14 18:41:06.4262454)ATarragonaTarragona2011-12-14 18:41:06.425468,(ASoriaSoria2011-12-14 18:41:06.4247080'ASevillaSevilla2011-12-14 18:41:06.4239740&ASegoviaSegovia2011-12-14 18:41:06.423239N%99ASanta Cruz de TenerifeSanta Cruz de Tenerife2011-12-14 18:41:06.4224664$ASalamancaSalamanca2011-12-14 18:41:06.4217116#!!APontevedraPontevedra2011-12-14 18:41:06.4209272"APalenciaPalencia2011-12-14 18:41:06.4201780!AOurenseOurense2011-12-14 18:41:06.4194370 ANavarraNavarra2011-12-14 18:41:06.418657