spec/dummy/db/spec.sqlite3 in erp_tech_svcs-3.0.12 vs spec/dummy/db/spec.sqlite3 in erp_tech_svcs-3.1.0

- old
+ new

@@ -1,150 +1,345 @@ -SQLite format 3@ 0m0-'j~ytojkh}cx_s[mWjRgPcN^KWGTAQ?L<E8?3:.6*1'/#,"'" - - )20100819181805)20130105133960)20130105133959)20130105133958)20130105133957)20130105133956)20130105133955 -||)20100819181805)20130105133960)20130105133959)20130105133958)20130105133957)20130105133956) 20130105133955 AAA@2013-01-07 17:24:09.3975462013-01-07 17:24:09.397546 }hXA-  groups# file_assets parties users 5capability_accessors-capability_types )security_roles -1 relationship_types !role_types+audit_log_types5 compass_ae_instances% delayed_jobsgeo_zones'geo_countries ! currencies#scope_types %capabilities Tt.TD AAparty 52013-01-07 17:24:23.9246032013-01-07 17:24:23.924603D AAparty 42013-01-07 17:24:23.8268802013-01-07 17:24:23.826880L ! AATest GroupGroup2013-01-07 17:24:23.8187882013-01-07 17:24:23.818788D AAparty 32013-01-07 17:24:23.5306332013-01-07 17:24:23.530633D AAparty 22013-01-07 17:24:10.2107192013-01-07 17:24:10.210719D AAparty 12013-01-07 17:24:10.1549282013-01-07 17:24:10.154928 - - Group Nq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")b55gtablecompass_ae_instancescompass_ae_instancesCREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal(8,3), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)D_tablepartiespartiesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)i+indexbesi_1partiesCREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")  ||o~p##'tableparty_rolesparty_roles CREATE TABLE "party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "party_id" integer, "role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G#!indexindex_party_roles_on_party_idparty_roles CREATE INDEX "index_party_roles_on_party_id" ON "party_roles" ("party_id") O#1indexindex_party_roles_on_role_type_idparty_roles CREATE INDEX "index_party_roles_on_role_type_id" ON "party_roles" ("role_type_id") -!!Itablerole_typesrole_types CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) - - EEc 7%AASecurity Group Membergroup_member2013-01-07 17:24:09.5247692013-01-07 17:24:09.524769T )AASecurity Groupgroup2013-01-07 17:24:09.5220092013-01-07 17:24:09.522009 }  -?-AAGroup MembershipSecurity Group Membershipgroup_membership2013-01-07 17:24:09.5523992013-01-07 17:24:09.552399 p;W 11Ytablerelationship_typesrelationship_typesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)H s1yindexindex_relationship_types_on_valid_from_role_type_idrelationship_typesCREATE INDEX "index_relationship_types_on_valid_from_role_type_id" ON "relationship_types" ("valid_from_role_type_id")B o1qindexindex_relationship_types_on_valid_to_role_type_idrelationship_typesCREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id") -  -  ==L 33?tableparty_relationshipsparty_relationshipsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)1c3Yindexindex_party_relationships_on_status_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id") - - - H7g3aindexindex_party_relationships_on_priority_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")Co3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationships" ("relationship_type_id")o''tableorganizationsorganizationsCREATE TABLE "organizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "tax_id_number" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   >>>##CtableindividualsindividualsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)G#!indexindex_individuals_on_party_idindividualsCREATE INDEX "index_individuals_on_party_id" ON "individuals" ("party_id") -  BBuHctablecontactscontactsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)sAindexindex_contacts_on_party_idcontactsCREATE INDEX "index_contacts_on_party_id" ON "contacts" ("party_id")q9indexbesi_2contactsCREATE INDEX "besi_2" ON "contacts" ("contact_mechanism_id", "contact_mechanism_type")''Otablecontact_typescontact_types CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) - -  - 4a -M'-indexindex_contact_types_on_parent_idcontact_types!CREATE INDEX "index_contact_types_on_parent_id" ON "contact_types" ("parent_id")--Utablecontact_purposescontact_purposes#CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)S-9indexindex_contact_purposes_on_parent_idcontact_purposes$CREATE INDEX "index_contact_purposes_on_parent_id" ON "contact_purposes" ("parent_id")??Gtablecontact_purposes_contactscontact_purposes_contacts%CREATE TABLE "contact_purposes_contacts" ("contact_id" integer, "contact_purpose_id" integer)  -  - X7K?qindexcontact_purposes_contacts_indexcontact_purposes_contacts&CREATE INDEX "contact_purposes_contacts_index" ON "contact_purposes_contacts" ("contact_id", "contact_purpose_id") --stablepostal_addressespostal_addresses(CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)%]-Mindexindex_postal_addresses_on_geo_country_idpostal_addresses)CREATE INDEX "index_postal_addresses_on_geo_country_id" ON "postal_addresses" ("geo_country_id")  - -  xx W-Aindexindex_postal_addresses_on_geo_zone_idpostal_addresses*CREATE INDEX "index_postal_addresses_on_geo_zone_id" ON "postal_addresses" ("geo_zone_id")u!++!tableemail_addressesemail_addresses+CREATE TABLE "email_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email_address" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)n"''tablephone_numbersphone_numbers-CREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "phone_number" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   ==@#11+tableparty_search_factsparty_search_facts.CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)  sag$-tablemoneymoney0CREATE TABLE "money" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "amount" decimal(8,2), "currency_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)p%Aindexindex_money_on_currency_idmoney2CREATE INDEX "index_money_on_currency_id" ON "money" ("currency_id")k&!!!tablecurrenciescurrencies3CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)'[!Iindexindex_currencies_on_internal_identifiercurrencies4CREATE INDEX "index_currencies_on_internal_identifier" ON "currencies" ("internal_identifier") - OAAUS DollarUSD$2013-01-07 17:24:08.6872052013-01-07 17:24:08.687205 - USD  bb0(!!+tablecategoriescategories5CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) )5!Qindexcategory_polymorphiccategories7CREATE INDEX "category_polymorphic" ON "categories" ("category_record_id", "category_record_type")X*==Ctablecategory_classificationscategory_classifications8CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) -  - [[^3+A=uindexclassification_polymorphiccategory_classifications9CREATE INDEX "classification_polymorphic" ON "category_classifications" ("classification_id", "classification_type") ,11ktabledescriptive_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 NOT NULL, "updated_at" datetime NOT NULL)'-]1Mindexindex_descriptive_assets_on_view_type_iddescriptive_assets<CREATE INDEX "index_descriptive_assets_on_view_type_id" ON "descriptive_assets" ("view_type_id").51eindexdescribed_record_idxdescriptive_assets=CREATE INDEX "described_record_idx" ON "descriptive_assets" ("described_record_id", "described_record_type")  - -  %l/!!#tableview_typesview_types>CREATE TABLE "view_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 0''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){1C'indexindex_geo_countries_on_namegeo_countriesACREATE INDEX "index_geo_countries_on_name" ON "geo_countries" ("name") 2O'1indexindex_geo_countries_on_iso_code_2geo_countriesBCREATE INDEX "index_geo_countries_on_iso_code_2" ON "geo_countries" ("iso_code_2")X3tablegeo_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) jYH7%o]K7% Suriname Oman*YKorea, Democratic People's Republic ofp -Cyprus7PLGY\ / -wcP<(d *"@ 4O1indexindex_geo_zones_on_geo_country_idgeo_zonesDCREATE INDEX "index_geo_zones_on_geo_country_id" ON "geo_zones" ("geo_country_id")z5Eindexindex_geo_zones_on_zone_namegeo_zonesFCREATE INDEX "index_geo_zones_on_zone_name" ON "geo_zones" ("zone_name")z6Eindexindex_geo_zones_on_zone_codegeo_zonesGCREATE INDEX "index_geo_zones_on_zone_code" ON "geo_zones" ("zone_code")7tablenotesnotesHCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)=8u{indexindex_notes_on_noted_record_id_and_noted_record_typenotesICREATE INDEX "index_notes_on_noted_record_id_and_noted_record_type" ON "notes" ("noted_record_id", "noted_record_type") -Oregon, -HessenQMS  - - - kns9Cindexindex_notes_on_note_type_idnotesJCREATE INDEX "index_notes_on_note_type_id" ON "notes" ("note_type_id")v:Eindexindex_notes_on_created_by_idnotesKCREATE INDEX "index_notes_on_created_by_id" ON "notes" ("created_by_id");!![tablenote_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 NOT NULL, "updated_at" datetime NOT NULL)<5!Uindexnote_type_record_idxnote_typesNCREATE INDEX "note_type_record_idx" ON "note_types" ("note_type_record_id", "note_type_record_type")  -  - ~~^'=--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 NOT NULL, "updated_at" datetime NOT NULL)3>A-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")?Y-Eindexindex_valid_note_types_on_note_type_idvalid_note_typesRCREATE INDEX "index_valid_note_types_on_note_type_id" ON "valid_note_types" ("note_type_id") - %n }@YtableusersusersSCREATE 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, "security_question_1" varchar(255), "security_answer_1" varchar(255), "security_question_2" varchar(255), "security_answer_2" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)eA5 indexindex_users_on_emailusersUCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") -5 - @2AnB;indexindex_users_on_usernameusersVCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")kC%'indexactivity_idxusersXCREATE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")DM-indexindex_users_on_remember_me_tokenusersYCREATE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token") ES9indexindex_users_on_reset_password_tokenusersZCREATE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")FK)indexindex_users_on_activation_tokenusers[CREATE INDEX "index_users_on_activation_token" ON "users" ("activation_token")<GStablegroupsgroups\CREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) -  -  -  -  C!AATest Group2013-01-07 17:24:23.8156262013-01-07 17:24:23.815626 P 0 -?H))9tablesecurity_rolessecurity_roles]CREATE TABLE "security_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 NOT NULL, "updated_at" datetime NOT NULL)WItablesessionssessions_CREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)yJEindexindex_sessions_on_session_idsessions`CREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yKEindexindex_sessions_on_updated_atsessionsaCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")  - -  zjL!!tableaudit_logsaudit_logsbCREATE 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 NOT NULL, "updated_at" datetime NOT NULL){ME!indexindex_audit_logs_on_party_idaudit_logsdCREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")N1!Aindexevent_record_indexaudit_logseCREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type") - - Eya ++ AASession Timeoutsession_timeout - 2013-01-07 17:24:09.4979032013-01-07 17:24:09.497903] '' AAAccessed Areaaccessed_area 2013-01-07 17:24:09.4922942013-01-07 17:24:09.492294c -- AASuccessful Loginsuccessful_login2013-01-07 17:24:09.4866202013-01-07 17:24:09.486620e // AASuccessful Logoutsuccessful_logout2013-01-07 17:24:09.4807512013-01-07 17:24:09.480751_ )) AACustom Messagecustom_message2013-01-07 17:24:09.4736032013-01-07 17:24:09.473603X ## AAApplicationapplication 2013-01-07 17:24:09.4702432013-01-07 17:24:09.470243 )O++ tableaudit_log_typesaudit_log_typesfCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)6P++#tableaudit_log_itemsaudit_log_itemshCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)   Q55]tableaudit_log_item_typesaudit_log_item_typesiCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)^R##tablefile_assetsfile_assetskCREATE 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, "width" varchar(255), "height" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ] - vv}sS?#indexindex_file_assets_on_typefile_assetslCREATE INDEX "index_file_assets_on_type" ON "file_assets" ("type")T7#]indexfile_asset_holder_idxfile_assetsnCREATE INDEX "file_asset_holder_idx" ON "file_assets" ("file_asset_holder_id", "file_asset_holder_type")sU?#indexindex_file_assets_on_namefile_assetsoCREATE INDEX "index_file_assets_on_name" ON "file_assets" ("name")VI#%indexindex_file_assets_on_directoryfile_assetspCREATE INDEX "index_file_assets_on_directory" ON "file_assets" ("directory")W%%Ctabledelayed_jobsdelayed_jobsqCREATE 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), "queue" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) - - - TT)'AAA--- !ruby/object:ErpTechSvcs::Sessions::DeleteExpiredSessionsJob +SQLite format 3@ .m.-h +,iCo3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationships" ("relationship_type_id")7g3aindexindex_party_relationships_on_priority_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")1c3Yindexindex_party_relationships_on_status_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id") 33?tableparty_relationshipsparty_relationshipsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)B o1qindexindex_relationship_types_on_valid_to_role_type_idrelationship_typesCREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id")H s1yindexindex_relationship_types_on_valid_from_role_type_idrelationship_types CREATE INDEX "index_relationship_types_on_valid_from_role_type_id" ON "relationship_types" ("valid_from_role_type_id")W 11Ytablerelationship_typesrelationship_types CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) +!!Itablerole_typesrole_types CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) O#1indexindex_party_roles_on_role_type_idparty_roles +CREATE INDEX "index_party_roles_on_role_type_id" ON "party_roles" ("role_type_id")G#!indexindex_party_roles_on_party_idparty_roles CREATE INDEX "index_party_roles_on_party_id" ON "party_roles" ("party_id")p##'tableparty_rolesparty_rolesCREATE TABLE "party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "party_id" integer, "role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i+indexbesi_1partiesCREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")D_tablepartiespartiesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)b55gtablecompass_ae_instancescompass_ae_instancesCREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal(8,3), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("vX\FO2=%* )20100819181805)20130107214450)20130107214449)20130107214448)20130107214447)20130107214446)20130107214445 +{{)20100819181805)20130107214450)20130107214449)20130107214448)20130107214447)20130107214446)20130107214445 AAA@2013-01-07 21:44:59.3541812013-01-07 21:44:59.354181 ydWL8' + groups #file_assets )security_roles +users parties+audit_log_types5compass_ae_instances%delayed_jobsgeo_zones'geo_countries!currencies#scope_types-capability_types St.SD AAparty 52013-01-07 21:45:08.8187592013-01-07 21:45:08.818759D AAparty 42013-01-07 21:45:08.6163262013-01-07 21:45:08.616326M !AATest GroupGroup2013-01-07 21:45:08.6005172013-01-07 21:45:08.600517D AAparty 32013-01-07 21:45:08.0638462013-01-07 21:45:08.063846D AAparty 22013-01-07 21:45:01.0756682013-01-07 21:45:01.075668D AAparty 12013-01-07 21:45:00.9557622013-01-07 21:45:00.955762 + Group  + +   + +  + + +  "*   + F:Co3q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "uniquq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")b55gtablecompass_ae_instancescompass_ae_instancesCREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal(8,3), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)D_tablepartiespartiesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)i+indexbesi_1partiesCREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")p##'tableparty_rolesparty_rolesCREATE TABLE "party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "party_id" integer, "role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G#!indexindex_party_roles_on_party_idparty_roles CREATE INDEX "index_party_roles_on_party_id" ON "party_roles" ("party_id") O#1indexindex_party_roles_on_role_type_idparty_roles +CREATE INDEX "index_party_roles_on_role_type_id" ON "party_roles" ("role_type_id") +!!Itablerole_typesrole_types CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)W 11Ytablerelationship_typesrelationship_types CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)H s1yindexindex_relationship_types_on_valid_from_role_type_idrelationship_types CREATE INDEX "index_relationship_types_on_valid_from_role_type_id" ON "relationship_types" ("valid_from_role_type_id")B o1qindexindex_relationship_types_on_valid_to_role_type_idrelationship_typesCREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id") 33?tableparty_relationshipsparty_relationshipsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)1c3Yindexindex_party_relationships_on_status_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id")7g3aindexindex_party_relationships_on_priority_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")  L +J + k  ]XCo3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationsCo3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationships" ("relationship_type_id")o''tableorganizationsorganizationsCREATE TABLE "organizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "tax_id_number" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)>##CtableindividualsindividualsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)G#!indexindex_individuals_on_party_idindividualsCREATE INDEX "index_individuals_on_party_id" ON "individuals" ("party_id")HctablecontactscontactsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)sAindexindex_contacts_on_party_idcontactsCREATE INDEX "index_contacts_on_party_id" ON "contacts" ("party_id")q9indexbesi_2contactsCREATE INDEX "besi_2" ON "contacts" ("contact_mechanism_id", "contact_mechanism_type")''Otablecontact_typescontact_typesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL) +M'-indexindex_contact_types_on_parent_idcontact_typesCREATE INDEX "index_contact_types_on_parent_id" ON "contact_types" ("parent_id")--Utablecontact_purposescontact_purposesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)S-9indexindex_contact_purposes_on_parent_idcontact_purposesCREATE INDEX "index_contact_purposes_on_parent_id" ON "contact_purposes" ("parent_id")??Gtablecontact_purposes_contactscontact_purposes_contactsCREATE TABLE "contact_purposes_contacts" ("contact_id" integer, "contact_purpose_id" integer)7K?qindexcontact_purposes_contacts_indexcontact_purposes_contacts CREATE INDEX "contact_purposes_contacts_index" ON "contact_purposes_contacts" ("contact_id", "contact_purpose_id") --stablepostal_addressespostal_addresses!CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)  +  + +  +  +  +  + +  .y c bJu!++!tableemail_addressesemail_addresses$CREATE TABLE "email_addresses" ("id" INTEGER P%]-Mindexindex_postal_addresses_on_geo_country_idpostal_addresses"CREATE INDEX "index_postal_addresses_on_geo_country_id" ON "postal_addresses" ("geo_country_id") W-Ainde%]-Mindexindex_postal_addresses_on_geo_country_idpostal_addresses"CREATE INDEX "index_postal_addresses_on_geo_country_id" ON "postal_addresses" ("geo_country_id") W-Aindexindex_postal_addresses_on_geo_zone_idpostal_addresses#CREATE INDEX "index_postal_addresses_on_geo_zone_id" ON "postal_addresses" ("geo_zone_id")u!++!tableemail_addressesemail_addresses$CREATE TABLE "email_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email_address" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)n"''tablephone_numbersphone_numbers&CREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "phone_number" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)@#11+tableparty_search_factsparty_search_facts'CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)g$-tablemoneymoney(CREATE TABLE "money" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "amount" decimal(8,2), "currency_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)p%Aindexindex_money_on_currency_idmoney)CREATE INDEX "index_money_on_currency_id" ON "money" ("currency_id")k&!!!tablecurrenciescurrencies*CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)'[!Iindexindex_currencies_on_internal_identifiercurrencies+CREATE INDEX "index_currencies_on_internal_identifier" ON "currencies" ("internal_identifier")0(!!+tablecategoriescategories,CREATE 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 NOT NULL, "updated_at" datetime NOT NULL) )5!Qindexcategory_polymorphiccategories-CREATE INDEX "category_polymorphic" ON "categories" ("category_record_id", "category_record_type")X*==Ctablecategory_classificationscategory_classifications.CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)    + OAAUS DollarUSD$2013-01-07 21:44:58.0083032013-01-07 21:44:58.008303 +USD  +  +  + 7rj r A D^8 ,11ktabledescriptive_assetsdescriptive_assets0CREATE TABLE "descriptive_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "view_type_id" integer, "i3+A=uindexclassification_polymorphiccategory_classifications/CREATE INDEX "classification_polymorphic" ON "category_classifications" ("classification_id", "classification_type") ,11ktabledescriptive_assetsdescriptive_assets0CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)'-]1Mindexindex_descriptive_assets_on_view_type_iddescriptive_assets1CREATE INDEX "index_descriptive_assets_on_view_type_id" ON "descriptive_assets" ("view_type_id").51eindexdescribed_record_idxdescriptive_assets3CREATE INDEX "described_record_idx" ON "descriptive_assets" ("described_record_id", "described_record_type")l/!!#tableview_typesview_types4CREATE TABLE "view_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 0''Ytablegeo_countriesgeo_countries5CREATE 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){1C'indexindex_geo_countries_on_namegeo_countries6CREATE INDEX "index_geo_countries_on_name" ON "geo_countries" ("name") 2O'1indexindex_geo_countries_on_iso_code_2geo_countries7CREATE INDEX "index_geo_countries_on_iso_code_2" ON "geo_countries" ("iso_code_2")X3tablegeo_zonesgeo_zones8CREATE 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) 4O1indexindex_geo_zones_on_geo_country_idgeo_zones9CREATE INDEX "index_geo_zones_on_geo_country_id" ON "geo_zones" ("geo_country_id")z5Eindexindex_geo_zones_on_zone_namegeo_zones:CREATE INDEX "index_geo_zones_on_zone_name" ON "geo_zones" ("zone_name")z6Eindexindex_geo_zones_on_zone_codegeo_zones;CREATE INDEX "index_geo_zones_on_zone_code" ON "geo_zones" ("zone_code")7tablenotesnotes<CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)=8u{indexindex_notes_on_noted_record_id_and_noted_record_typenotes=CREATE INDEX "index_notes_on_noted_record_id_and_noted_record_type" ON "notes" ("noted_record_id", "noted_record_type")s9Cindexindex_notes_on_note_type_idnotes>CREATE INDEX "index_notes_on_note_type_id" ON "notes" ("note_type_id")v:Eindexindex_notes_on_created_by_idnotes?CREATE INDEX "index_notes_on_created_by_id" ON "notes" ("created_by_id");!![tablenote_typesnote_types@CREATE 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 NOT NULL, "updated_at" datetime NOT NULL)<5!Uindexnote_type_record_idxnote_typesACREATE INDEX "note_type_record_idx" ON "note_types" ("note_type_record_id", "note_type_record_type")'=--tablevalid_note_typesvalid_note_typesBCREATE 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 NOT NULL, "updated_at" datetime NOT NULL) + zj9 s B  x F  T $ + + + +J + e /j6_0R#R$Y'VB |E 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.&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-2y`xwM|xlbTH9-!{pM7*  w [ N B 8 '   q [ O C 6   | p f X M ? 3 $   + + + + + + + + +~ +p +S +J +> +3 +) + + + b W K ? 3  yodN>.sf[P?, }gYO>0$j_O4"bWH|p`>0&mYF"GHoly See (Vatican City State) Vanuatu!Uzbekistan Uruguay)UUnited States Minor Outlying Islands'United States)United Kingdom5United Arab Emirates Ukraine Uganda Tuvalu=Turks and Caicos Islands%Turkmenistan Turkey Tunisia3Trinidad and Tobago +Tonga Tokelau Togo Thailand!ETanzania, United Republic of!Tajikistan Taiwan5Syrian Arab Republic#Switzerland SwedenSwaziland9Svalbard and Jan Mayen Suriname +Sudan?Saint Pierre and Miquelon1eSaint Helena, Ascension and Tristan da CunhaSri Lanka +Spain1eSouth Georgia and the South Sandwich Islands%South Africa Somalia+Solomon Islands Slovenia SlovakiaSingapore%Sierra Leone!Seychelles Senegal%Saudi Arabia7Sao Tome and Principe!San Marino +Samoa%MSaint Vincent and the Grenadines#Saint Lucia7Saint Kitts and Nevis Rwanda1Russian Federation Romania Reunion +Qatar#Puerto Rico Portugal Poland Pitcairn#Philippines Peru Paraguay-Papua New Guinea Panama +Palau Pakistan Oman Norway=Northern Mariana Islands)Norfolk Island Niue Nigeria +NigerNicaragua#New Zealand'New Caledonia#Netherlands +Nepal +Nauru Namibia Myanmar!Mozambique Morocco!Montserrat Mongolia Monaco5Moldova, Republic of$KMicronesia, Federated States of Mexico MayotteMauritius!Mauritania!Martinique-Marshall Islands +Malta Mali Maldives Malaysia Malawi!Madagascar.aMacedonia, The Former Yugoslav Republic of~ Macao}!Luxembourg| Lithuania{'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 Andorra)American Samoa Algeria Al{'Liechtensteinz +  C{m _X J.Q5<tf  +5x jqc\U2N E9 +}+$ 5  @ + n | u g R = 6  Y' D K ` / (  !      + +u % - % e u  ] U  m M } =  u ] m U E +e M 5 = } e - %   + + + +] += + +m + +M + + + + + +U +G +- +E  + + +  +% + u + m ] U e } M + = E + 5 -BLPNRSTLPSMEJEIMGGCDAXMFZWZMYEEHWFVIVGVNVEVAVUUZUYUMUSGBAEUAUGTVTCTMTRTNTTTOTKTGTHTZTJTWSYCHSESZSJSRSDPMSHLKESGSZASOSBSISKSGSLSCSNSASTSMWSVCLCKNRWRUROREQAPRPTPLPNPHPEPYPGPAPWPKOMNOMPNFNUNGNENINZNCNLNPNRNAMMMZMAMSMNMCMDFMMXYTMUMRMQMHMTMLMVMYMWMGMK~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 AQAIAOADASDZALAFW) ~ Q ' u K  a 3 + + +r +D + Z *X.wFT*k8 {NU)`-j>*QAQHESHessen2013-01-07 21:44:58.931660+PAQHAMHamburg2013-01-07 21:44:58.930889*OAQBREBremen2013-01-07 21:44:58.930089/N#AQBRGBrandenburg2013-01-07 21:44:58.929312*MAQBERBerlin2013-01-07 21:44:58.928505*LAQBAYBayern2013-01-07 21:44:58.9277368K5AQBAWBaden-Württemberg2013-01-07 21:44:58.9269101J'AQNDSNiedersachsen2013-01-07 21:44:58.9261382I+A&YTYukon Territory2013-01-07 21:44:58.925359/H%A&SKSaskatchewan2013-01-07 21:44:58.924610)GA&QCQuebec2013-01-07 21:44:58.9238397F5A&PEPrince Edward Island2013-01-07 21:44:58.923063*EA&ONOntario2013-01-07 21:44:58.922310*DA&NUNunavut2013-01-07 21:44:58.9215058C7A&NTNorthwest Territories2013-01-07 21:44:58.920744.B#A&NSNova Scotia2013-01-07 21:44:58.9199620A'A&NBNew Brunswick2013-01-07 21:44:58.919191/@%A&NFNewfoundland2013-01-07 21:44:58.918406+?A&MBManitoba2013-01-07 21:44:58.9176353>-A&BCBritish Columbia2013-01-07 21:44:58.916829*=A&ABAlberta2013-01-07 21:44:58.912228+<AWYWyoming2013-01-07 21:44:58.911420-;AWIWisconsin2013-01-07 21:44:58.9105031:'AWVWest Virginia2013-01-07 21:44:58.909413.9!AWAWashington2013-01-07 21:44:58.908413,8AVAVirginia2013-01-07 21:44:58.90745527)AVIVirgin Islands2013-01-07 21:44:58.906416+6AVTVermont2013-01-07 21:44:58.905378(5AUTUtah2013-01-07 21:44:58.904325)4ATXTexas2013-01-07 21:44:58.903179-3ATNTennessee2013-01-07 21:44:58.90194302%ASDSouth Dakota2013-01-07 21:44:58.90070321)ASCSouth Carolina2013-01-07 21:44:58.89936500%ARIRhode Island2013-01-07 21:44:58.897819//#APRPuerto Rico2013-01-07 21:44:58.8900430.%APAPennsylvania2013-01-07 21:44:58.889289)-APWPalau2013-01-07 21:44:58.888514*,AOROregon2013-01-07 21:44:58.887639,+AOKOklahoma2013-01-07 21:44:58.886732(*AOHOhio2013-01-07 21:44:58.885828<)=AMPNorthern Mariana Islands2013-01-07 21:44:58.8847750(%ANDNorth Dakota2013-01-07 21:44:58.8837332')ANCNorth Carolina2013-01-07 21:44:58.882686,&ANYNew York2013-01-07 21:44:58.881593.%!ANMNew Mexico2013-01-07 21:44:58.880355.$!ANJNew Jersey2013-01-07 21:44:58.8791241#'ANHNew Hampshire2013-01-07 21:44:58.877883*"ANVNevada2013-01-07 21:44:58.876258,!ANENebraska2013-01-07 21:44:58.869330+ AMTMontana2013-01-07 21:44:58.868574,AMOMissouri2013-01-07 21:44:58.867777/#AMSMississippi2013-01-07 21:44:58.867028-AMNMinnesota2013-01-07 21:44:58.866274,AMIMichigan2013-01-07 21:44:58.8655221'AMAMassachusetts2013-01-07 21:44:58.864774,AMDMaryland2013-01-07 21:44:58.8640194-AMHMarshall Islands2013-01-07 21:44:58.863248)AMEMaine2013-01-07 21:44:58.862481-ALALouisiana2013-01-07 21:44:58.861726,AKYKentucky2013-01-07 21:44:58.860975*AKSKansas2013-01-07 21:44:58.860223(AIAIowa2013-01-07 21:44:58.859466+AINIndiana2013-01-07 21:44:58.858705,AILIllinois2013-01-07 21:44:58.855921)AIDIdaho2013-01-07 21:44:58.855160*AHIHawaii2013-01-07 21:44:58.854407(AGUGuam2013-01-07 21:44:58.853651+AGAGeorgia2013-01-07 21:44:58.852892+ AFLFlorida2013-01-07 21:44:58.852117B IAFMFederated States Of Micronesia2013-01-07 21:44:58.8513688 5ADCDistrict of Columbia2013-01-07 21:44:58.850605, +ADEDelaware2013-01-07 21:44:58.849831/ #ACTConnecticut2013-01-07 21:44:58.849064,ACOColorado2013-01-07 21:44:58.848229.!ACACalifornia2013-01-07 21:44:58.8474740%AAFArmed Forces2013-01-07 21:44:58.846718,AARArkansas2013-01-07 21:44:58.845959+AAZArizona2013-01-07 21:44:58.8436682)AASAmerican Samoa2013-01-07 21:44:58.842895*AAKAlaska2013-01-07 21:44:58.842059+AALAlabama2013-01-07 21:4~ }Q + % ~ xVPJD>82,&  } u m e ] U M E = 5 - %    } u m e ] U M E = 5 - % q j c \ U N G @ 9 2 + $      {tmf_XQJC<5.'  xqjc\~}|{zyxwvutsrqponmlkjihgfedcba`_^]\[ZQYQXQWQVQUQTQSQRQQQPQOQNQMQLQKQJ&I&H&G&F&E&D&C&B&A&@&?&>&=<;:9876543210/.-,+*)('&%$#"!     +  + + +  +ti\ N? { k ` w +33& sZ7+    T Iwm { +[_OE9/ p# j{ . +n`PC7* b G Y T +   7  +w G   v e U  D + + + +j ' +  v 1 8 +Lg [   + +BO A1 $ +% +  + 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} Zürich|Zug{ +Wallisz WaadtyUrix +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\3Niederösterreich[WienZ%ThüringenY1Schleswig-HolsteinX)Sachsen-AnhaltW SachsenV SaarlandU+Rheinland-PfalzT3Nordrhein-WestfalenS9Mecklenburg-VorpommernR +HessenQ HamburgP +BremenO#BrandenburgN +BerlinM +BayernL5Baden-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 +Alaska Alabama + |U ; 4 - r e W J < 1 N & I   $      +  w f W  K ?t{ 5 ^mf_ '   +CGJX Q<5'. + + + +9  @  s 2+$  + l + + +  e   W + +c +V +I +> P  +/ +# + x B   + qc zj\ 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  + + +  +  + + "9AAadmin2user2@portablemind.com2013-01-07 21:45:01.0853652013-01-07 21:45:01.085365o9AAadmin4user4@portablemind.com2013-01-07 21:45:08.8276222013-01-07 21:45:08.827622 cc; + + i Q T_GyKEindexindex_3>A-indexvalid_note_type_record_idxvalid_note_typesCCREATE INDEX "valid_note_type_record_idx" ON "valid_note_types" ("valid_note_type_record_id", "valid_note_type_record_type")?Y-Eindexindex_valid_note_types_on_note_type_idvalid_note_typesDCREATE INDEX "index_valid_note_types_on_note_type_id" ON "valid_note_types" ("note_type_id")}@YtableusersusersECREATE 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, "security_question_1" varchar(255), "security_answer_1" varchar(255), "security_question_2" varchar(255), "security_answer_2" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)eA5 indexindex_users_on_emailusersGCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")nB;indexindex_users_on_usernameusersHCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")kC%'indexactivity_idxusersICREATE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")DM-indexindex_users_on_remember_me_tokenusersJCREATE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token") ES9indexindex_users_on_reset_password_tokenusersKCREATE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")FK)indexindex_users_on_activation_tokenusersLCREATE INDEX "index_users_on_activation_token" ON "users" ("activation_token")<GStablegroupsgroupsMCREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?H))9tablesecurity_rolessecurity_rolesNCREATE TABLE "security_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 NOT NULL, "updated_at" datetime NOT NULL)WItablesessionssessionsOCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)yJEindexindex_sessions_on_session_idsessionsPCREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yKEindexindex_sessions_on_updated_atsessionsQCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")jL!!tableaudit_logsaudit_logsRCREATE 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 NOT NULL, "updated_at" datetime NOT NULL){ME!indexindex_audit_logs_on_party_idaudit_logsSCREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")N1!Aindexevent_record_indexaudit_logsTCREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type"))O++ tableaudit_log_typesaudit_log_typesUCREATE 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 NOT NULL, "updated_at" datetime NOT NULL) +6user2@portablemind.comuser4@portablemind.com +admin2 admin4 +  + + + + + + C!AATest Group2013-01-07 21:45:08.5957232013-01-07 21:45:08.595723 AAManagermanager2013-01-07 21:45:01.1284602013-01-07 21:45:01.128460AAEmployeeemployee2013-01-07 21:45:01.1197342013-01-07 21:45:0PAATest Roletest role2013-01-07 21:45:08.7156512013-01-07 21:45:08.715651  + +  + +  Cu b ++AASession Timeoutsession_timeout + 2013-01-07 21:44:59.5337452013-01-07 21:44:59.533745^ ''AAAccessed Areaaccessed_area 2013-01-07 21:44:59.5260022013-01-07 21:44:59.526002d --AASuccessful Loginsuccessful_login2013-01-07 21:44:59.5166932013-01-07 21:44:59.516693f //AASuccessful Logoutsuccessful_logout2013-01-07 21:44:59.5097532013-01-07 21:44:59.509753` ))AACustom Messagecustom_message2013-01-07 21:44:59.4901622013-01-07 21:44:59.490162Y ##AAApplicationapplication 2013-01-07 21:44:59.4825712013-01-07 21:44:59.482571   %%^T a i !ZBw^S%9indexindex_capabilities_on_scope_type_idcapabilitieseCREATE INDEX "index_capabilities_on_scope_type_id" ON "capabilities" ("scope_type_id")!]]%Mindexindex_capabilities_on_capability_type_idcapabilitiesdCREATE INDEX "index_capabilities_on_capab6P++#tableaudit_log_itemsaudit_log_itemsVCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)Q55]tableaudit_log_item_typesaudit_log_item_typesWCREATE TABLE "audit_log_item_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" va6P++#tableaudit_log_itemsaudit_log_itemsVCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)Q55]tableaudit_log_item_typesaudit_log_item_typesWCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)^R##tablefile_assetsfile_assetsYCREATE 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, "width" varchar(255), "height" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)sS?#indexindex_file_assets_on_typefile_assetsZCREATE INDEX "index_file_assets_on_type" ON "file_assets" ("type")T7#]indexfile_asset_holder_idxfile_assets[CREATE INDEX "file_asset_holder_idx" ON "file_assets" ("file_asset_holder_id", "file_asset_holder_type")sU?#indexindex_file_assets_on_namefile_assets\CREATE INDEX "index_file_assets_on_name" ON "file_assets" ("name")VI#%indexindex_file_assets_on_directoryfile_assets]CREATE INDEX "index_file_assets_on_directory" ON "file_assets" ("directory")W%%Ctabledelayed_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), "queue" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){X7%'indexdelayed_jobs_prioritydelayed_jobs_CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")Y))Etablecapable_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 NOT NULL, "updated_at" datetime NOT NULL)'Z=)uindexcapable_model_record_idxcapable_modelsaCREATE INDEX "capable_model_record_idx" ON "capable_models" ("capable_model_record_id", "capable_model_record_type")~[--/tablecapability_typescapability_typesbCREATE TABLE "capability_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d\%% tablecapabilitiescapabilitiescCREATE TABLE "capabilities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "capability_type_id" integer, "capability_resource_type" varchar(255), "capability_resource_id" integer, "scope_type_id" integer, "scope_query" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ]= =!AAATextFilefile_asset_spec_text.txtfile_asset_spec_text.txttext/plain 2013-01-07 21:45:08.3532862013-01-07 21:45:08.3555672013-01-07 21:45:08.355567 + TextFile + +file_asset_spec_text.txt + RR+'AAA--- !ruby/object:ErpTechSvcs::Sessions::DeleteExpiredSessionsJob priority: 1 -2013-01-08 07:00:01.0000002013-01-07 17:24:09.3872172013-01-07 17:24:09.387217 -A 2013-01-08 07:00:01.000000 MU{X7%'indexdelayed_jobs_prioritydelayed_jobsrCREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")Y))Etablecapable_modelscapable_modelstCREATE TABLE "capable_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "capable_model_record_id" integer, "capable_model_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)'Z=)uindexcapable_model_record_idxcapable_modelsuCREATE INDEX "capable_model_record_idx" ON "capable_models" ("capable_model_record_id", "capable_model_record_type")~[--/tablecapability_typescapability_typesvCREATE TABLE "capability_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  - l$BAAviewView2013-01-07 17:24:09.7479902013-01-07 17:24:09.747990BAAeditEdit2013-01-07 17:24:09.7397482013-01-07 17:24:09.739748FAAdeleteDelete2013-01-07 17:24:09.7306102013-01-07 17:24:09.730610FAAcreateCreate2013-01-07 17:24:09.6404142013-01-07 17:24:09.640414JAAdownloadDownload2013-01-07 17:24:08.6065952013-01-07 17:24:08.606595 ^M -AAView NoteNote2013-01-07 17:24:09.7501092013-01-07 17:24:09.750109M -AAEdit NoteNote2013-01-07 17:24:09.7418022013-01-07 17:24:09.741802O -#AADelete NoteNote2013-01-07 17:24:09.7330382013-01-07 17:24:09.733038O -#AACreate NoteNote2013-01-07 17:24:09.6643862013-01-07 17:24:09.664386 !Zd\%% tablecapabilitiescapabilitieswCREATE TABLE "capabilities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "capability_type_id" integer, "capability_resource_type" varchar(255), "capability_resource_id" integer, "scope_type_id" integer, "scope_query" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)!]]%Mindexindex_capabilities_on_capability_type_idcapabilitiesyCREATE INDEX "index_capabilities_on_capability_type_id" ON "capabilities" ("capability_type_id")^S%9indexindex_capabilities_on_scope_type_idcapabilitieszCREATE INDEX "index_capabilities_on_scope_type_id" ON "capabilities" ("scope_type_id")#_?%oindexcapability_resource_indexcapabilities{CREATE INDEX "capability_resource_index" ON "capabilities" ("capability_resource_id", "capability_resource_type") -  -  - Note Note Note Note m#DI%AASecurityRole2013-01-07 17:24:09.7695992013-01-07 17:24:09.769599I%AASecurityRole2013-01-07 17:24:09.7660822013-01-07 17:24:09.766082I%AASecurityRole2013-01-07 17:24:09.7624882013-01-07 17:24:09.762488H% AASecurityRole2013-01-07 17:24:09.7586062013-01-07 17:24:09.758606H% AASecurityRole2013-01-07 17:24:09.7544362013-01-07 17:24:09.754436H% AASecurityRole2013-01-07 17:24:09.7460472013-01-07 17:24:09.746047H% AASecurityRole2013-01-07 17:24:09.7376742013-01-07 17:24:09.737674G% AASecurityRole2013-01-07 17:24:09.7272882013-01-07 17:24:09.727288 GG; <`55tablecapability_accessorscapability_accessors|CREATE TABLE "capability_accessors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "capability_accessor_record_type" varchar(255), "capability_accessor_record_id" integer, "capability_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)2ac5Yindexindex_capability_accessors_on_capability_idcapability_accessors~CREATE INDEX "index_capability_accessors_on_capability_id" ON "capability_accessors" ("capability_id")ObM5)indexcapability_accessor_record_indexcapability_accessorsCREATE INDEX "capability_accessor_record_index" ON "capability_accessors" ("capability_accessor_record_id", "capability_accessor_record_type")pc##%tablescope_typesscope_typesCREATE TABLE "scope_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) -  -mm%SecurityRole%SecurityRole%SecurityRole%SecurityRole %SecurityRole %SecurityRole %SecurityRole % SecurityRole (n(DAAQueryquery2013-01-07 17:24:08.6608332013-01-07 17:24:08.660833DAAClassclass2013-01-07 17:24:08.6595082013-01-07 17:24:08.659508JAAInstanceinstance2013-01-07 17:24:08.6575142013-01-07 17:24:08.657514 - query class  instance ::q !d]#Mindexindex_scope_types_on_internal_identifierscope_typesCREATE INDEX "index_scope_types_on_internal_identifier" ON "scope_types" ("internal_identifier")e999tableparties_security_rolesparties_security_rolesCREATE TABLE "parties_security_roles" ("party_id" integer, "security_role_id" integer),f]9Mindexindex_parties_security_roles_on_party_idparties_security_rolesCREATE INDEX "index_parties_security_roles_on_party_id" ON "parties_security_roles" ("party_id")Dgm9mindexindex_parties_security_roles_on_security_role_idparties_security_rolesCREATE INDEX "index_parties_security_roles_on_security_role_id" ON "parties_security_roles" ("security_role_id")h++atableattribute_typesattribute_typesCREATE TABLE "attribute_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "data_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  - -  - ss; i=+5index:attribute_types_iid_idxattribute_typesCREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")9j--#tableattribute_valuesattribute_valuesCREATE TABLE "attribute_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attributed_record_id" integer, "attributed_record_type" varchar(255), "attribute_type_id" integer, "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)BkY- indexattribute_values_attributed_record_idxattribute_valuesCREATE INDEX "attribute_values_attributed_record_idx" ON "attribute_values" ("attributed_record_id", "attributed_record_type")  - - - pp)20121130212146)20121116155018)20111111144706)20110913145838)20110802200222)20110609150135)20110525001935)20110109173616 tt!lU-Kindexattribute_values_attributed_type_idxattribute_valuesCREATE INDEX "attribute_values_attributed_type_idx" ON "attribute_values" ("attribute_type_id")mA-indexattribute_values_value_idxattribute_valuesCREATE INDEX "attribute_values_value_idx" ON "attribute_values" ("value")bn++{tabledata_migrationsdata_migrationsCREATE TABLE "data_migrations" ("version" varchar(255)) Fi1j9sBxF0ABarbadosBBBRBt2010-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 Tn?m;QT0%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.000000 Zd"\SZ.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.&ACanadaCACANt2010-01-22 19:42:24.000000 Qe3b'NQ5K'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 -8-9DQ`lz&1=Xew -,IR\f{&OCongo, Democratic Republic of the'Aland Islands# Afghanistan Albania Algeria)American Samoa Andorra +2013-01-08 07:00:01.0000002013-01-07 21:44:59.2643412013-01-07 21:44:59.264341 + A2013-01-08 07:00:01.000000  + JAAdownloadDownload2013-01-07 21:44:57.8097112013-01-07 21:44:57.809711  + + +  W< +X + ^ v<{K8j--#tableattribute_valuesattribute_valuesrCREATE TABLE "attribute_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attributed_record_id" integer, "attributed_record_type" varchar(255), "attribute_type_id" integer, "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i=+5index:attribute_types_iid_idxattribute_typesqCREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")h++atableattribute_typesattribute_typespCREATE TABLE "attribute_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "intean++{tabledata_migrationsdata_migrationsvCREATE TABLE "data_migrations" ("version" varchar(255))mA-indexattribute_values_value_idxattribute_valuesuCREATE INDEX "attribute_values_value_idx" ON "attribute_values" ("value") lU-Kindexattribute_values_attributed_type_idxattribute_valuestCREATE INDEX "attribute_values_attributed_type_idx" ON "attribute_values" ("attribute_type_id")!]]%Mindexindex_capabilities_on_capability_type_idcapabilitiesdCREATE INDEX "index_capabilities_on_capability_type_id" ON "capabilities" ("capability_type_id")^S%9indexindex_capabilities_on_scope_type_idcapabilitieseCREATE INDEX "index_capabilities_on_scope_type_id" ON "capabilities" ("scope_type_id")#_?%oindexcapability_resource_indexcapabilitiesfCREATE INDEX "capability_resource_index" ON "capabilities" ("capability_resource_id", "capability_resource_type")<`55tablecapability_accessorscapability_accessorsgCREATE TABLE "capability_accessors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "capability_accessor_record_type" varchar(255), "capability_accessor_record_id" integer, "capability_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)2ac5Yindexindex_capability_accessors_on_capability_idcapability_accessorsiCREATE INDEX "index_capability_accessors_on_capability_id" ON "capability_accessors" ("capability_id")ObM5)indexcapability_accessor_record_indexcapability_accessorsjCREATE INDEX "capability_accessor_record_index" ON "capability_accessors" ("capability_accessor_record_id", "capability_accessor_record_type")oc##%tablescope_typesscope_typeskCREATE TABLE "scope_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) d]#Mindexindex_scope_types_on_internal_identifierscope_typeslCREATE INDEX "index_scope_types_on_internal_identifier" ON "scope_types" ("internal_identifier")e999tableparties_security_rolesparties_security_rolesmCREATE TABLE "parties_security_roles" ("party_id" integer, "security_role_id" integer)+f]9Mindexindex_parties_security_roles_on_party_idparties_security_rolesnCREATE INDEX "index_parties_security_roles_on_party_id" ON "parties_security_roles" ("party_id")Cgm9mindexindex_parties_security_roles_on_security_role_idparties_security_rolesoCREATE INDEX "index_parties_security_roles_on_security_role_id" ON "parties_security_roles" ("security_role_id")h++atableattribute_typesattribute_typespCREATE TABLE "attribute_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "data_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i=+5index:attribute_types_iid_idxattribute_typesqCREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")8j--#tableattribute_valuesattribute_valuesrCREATE TABLE "attribute_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attributed_record_id" integer, "attributed_record_type" varchar(255), "attribute_type_id" integer, "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)AkY- indexattribute_values_attributed_record_idxattribute_valuessCREATE INDEX "attribute_values_attributed_record_idx" ON "attribute_values" ("attributed_record_id", "attributed_record_type") + + (n(DAAQueryquery2013-01-07 21:44:57.8822222013-01-07 21:44:57.882222DAAClassclass2013-01-07 21:44:57.8803572013-01-07 21:44:57.880357JAAInstanceinstance2013-01-07 21:44:57.8610252013-01-07 21:44:57.861025 + query class instance  + +  +  + + + )20111111144706)20110913145838)20110802200222)20110609150135)20110525001935)20110109173616 Ki1j9 s B  x F  T $ + + + +J + e /j6_0R#R$Y'VB |E 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.&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 Kp?zI M  w D  >  + + + +O + [ k"_Rf3d/NvD{K3#ANew ZealandNZNZLt2010-01-22 19:42:30.0000005'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.0000002s!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 Gj;_, ] . a + Z ) + + +h +8 + Z %TZ*[+Rw0l.Q ~E L`UAUnited States Minor Outlying IslandsUMUMIt2010-01-22 19:42:33.0000005_'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.000000<M5ASyrian Arab RepublicSYSYRt2010-01-22 19:42:32.0000003L#ASwitzerlandCHCHEt2010-01-22 19:42:32.000000.KASwedenSESWEt2010-01-22 19:42:32.0000001JASwazilandSZSWZt2010-01-22 19:42:32.000000>I9ASvalbard 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.0000001<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.000000  +gv7 a . s @ + Z $ + + +8{-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<h5AVirgin Islands, U.S.VIVIRt2010-01-22 19:42:34.000000?g;AVirgin Islands, BritishVGVGBt2010-01-22 19:42:34.0000000fAViet NamVNVNMt2010-01-22 19:42:34.0000001eAVenezuelaVEVENt2010-01-22 19:42:34.000000EdGAHoly See (Vatican City State)VAVATt2010-01-22 19:42:34.000000/cAVanuatuVUVUTt2010-01-22 19:42:34.0000002b!AUzbekistanUZUZBt2010-01-22 19:42:34.000000/aAUruguayUYURYt2010-01-22 19:42:34.000000 +}    0 < G T c o } + + + +) +4 +@ +[ +h +z + + + + + + +   / L U _ i ~    ! - : G ^ j t   # 8 X b m y  :]jx)6axyodN>.sf[P?, }gYO>0$j_O4"bWH|p`>0&mYF"GHoly See (Vatican City State) Vanuatu!Uzbekistan Uruguay)UUnited States Minor Outlying Islands'United States)United Kingdom5United Arab Emirates Ukraine Uganda Tuvalu=Turks and Caicos Islands%Turkmenistan Turkey Tunisia3Trinidad and Tobago +Tonga Tokelau Togo Thailand!ETanzania, United Republic of!Tajikistan Taiwan5Syrian Arab Republic#Switzerland SwedenSwaziland9Svalbard and Jan Mayen Suriname +Sudan?Saint Pierre and Miquelon1eSaint Helena, Ascension and Tristan da CunhaSri Lanka +Spain1eSouth Georgia and the South Sandwich Islands%South Africa Somalia+Solomon Islands Slovenia SlovakiaSingapore%Sierra Leone!Seychelles Senegal%Saudi Arabia7Sao Tome and Principe!San Marino +Samoa%MSaint Vincent and the Grenadines#Saint Lucia7Saint Kitts and Nevis Rwanda1Russian Federation Romania Reunion +Qatar#Puerto Rico Portugal Poland Pitcairn#Philippines Peru Paraguay-Papua New Guinea Panama +Palau Pakistan Oman Norway=Northern Mariana Islands)Norfolk Island Niue Nigeria +NigerNicaragua#New Zealand'New Caledonia#Netherlands +Nepal +Nauru Namibia Myanmar!Mozambique Morocco!Montserrat Mongolia Monaco5Moldova, Republic of$KMicronesia, Federated States of Mexico MayotteMauritius!Mauritania!Martinique-Marshall Islands +Malta Mali Maldives Malay Jersey#Isle of Man 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 -:'4KWaq%EOZfr|'4BNZdr Jersey#Isle of Man Guernsey"GHoly See (Vatican City State))Czech Republic8 Denmark9 Djibouti: Dominica;1Dominican Republic< Ecuador> Egypt?#El Salvador@/Equatorial GuineaA EritreaB EstoniaC EthiopiaDCFalkland Islands (Malvinas)E'Faroe IslandsFFijiG FinlandH +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^ Honduras_ Hong Kong` Hungarya Icelandb Indiac Indonesiad=Iran, Islamic Republic oeIraqf Irelandg +Guyana\ Haiti]CHeard and Mc Donald Islands^"GHoly See (Vatican City State) Honduras_ Hong Kong` Hungarya Icelandb Indiac Indonesiad=Iran, Islamic Republic oeIraqf Irelandg Israelh Italyi Jamaicaj Japank -Jordanl!Kazakhstanm Kenyan Kiribatio oR"^.h5o-]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.000000CMCAFrench Southern TerritoriesTFATFt2010-01-22 19:42:25.0000008L-AFrench PolynesiaPFPYFt2010-01-22 19:42:25.000000 mV%P"a2m0oAKiribatiKIKIRt2010-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 >tDf5Z&o>.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.0000002s!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.000000 -[y  '.5<CJyQX_fmt{$+29@GNU]dkryBLGGCDAXEHGBAEAD AFAG AIALAM AOAQAR -ASATAU AW AZBABBBDBEBF"BG!BHBI#BJBMBN BOBRBSBTBVBWBYBZCA&CC.CF)CG1CHCI4CK2CL+CM%CN,CO/CR3CU6CV'CX-CY7CZ8DEQDJ:DK9DM;DO<DZEC>EECEG?ERBESETDFIHFJGFKEFMFOFFRIGANGDVGEPGFKGHRGISGLUGMOGNZGPWGQAGRTGSGTYGUXGW[ -T  '.5<CJRY`gnu| -!)19AIQYaiqyMEJEIMMFHK`HM^HN_HR5HT]HUaIDdIEgILhINcIOIQfIReISbITiJMjJOlJPkKEnKGsKH$KIoKM0KNKPpKRqKWrKY(KZmLAtLBvLCLIzLKLRxLSwLT{LU|LVuLYyMAMCMDMGMHMK~MLMMMNMO}MPMQMRMSMTMUMVMWMXMYMZNANCNENFNGNINLNONPNRNUNZOMPAPEPFLPGPHPK -0 &JUamy %3=H^n~,9FQ\m!Montenegro1Korea, Republic ofq +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 +Latviau Lebanonv Lesothow Liberiax9Libyan Arab Jamahiriyay +x  3 B N \ j t  + + +(& +6 +F +S +c +p +} + + + + + + + + + + 7 A O Z f |    ' Y t6   / A P ^ l !0<Mgs7CO\vmbVH-Saint Barthelemy Pitcairn Serbia#Timor-Leste$KPalestinian Territory, Occupied!Montenegro%Saint Martin Zimbabwe Zambia +Yemen)Western Sahara/Wallis and Futuna5Virgin Islands, U.S.;Virgin Islands, British Viet Nam 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 Dk;b0vEvD/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 Zn8f4X)Z8%-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.0000005'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 3h5k9Y#s3=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.000000 -+JXco $0b}8 (8JYgu-Saint Barthelemy Pitcairn Serbia$KPalestinian Territory, Occupied%Saint Martin Pakistan +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 Cunha7Saint Kitts and Nevis#Saint Lucia?Saint Pierre and Miquelon%MSaint Vincent and the Grenadines Samoa!San Marino7Sao Tome and Principe%Saudi Arabia Senegal!Seychelles%Sierra LeoneSingapore Slovakia Slovenia+Solomon Islands Somalia%South Africa1eSouth Georgia and the South Sandwich Islands SpainSri Lanka -Sudan 5b+W%g3h50HASurinameSRSURt2010-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.0000001<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 YZ$8t6Y@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.000000<M5ASyrian Arab RepublicSYSYRt2010-01-22 19:42:32.0000003L#ASwitzerlandCHCHEt2010-01-22 19:42:32.000000.KASwedenSESWEt2010-01-22 19:42:32.0000001JASwazilandSZSWZt2010-01-22 19:42:32.000000>I9ASvalbard and Jan MayenSJSJMt2010-01-22 19:42:32.000000 /l-m;X%h/6j)AWestern SaharaEHESHt2010-01-22 19:42:34.0000009i/AWallis and FutunaWFWLFt2010-01-22 19:42:34.000000<h5AVirgin Islands, U.S.VIVIRt2010-01-22 19:42:34.000000?g;AVirgin Islands, BritishVGVGBt2010-01-22 19:42:34.0000000fAViet NamVNVNMt2010-01-22 19:42:34.0000001eAVenezuelaVEVENt2010-01-22 19:42:34.000000EdGAHoly See (Vatican City State)VAVATt2010-01-22 19:42:34.000000/cAVanuatuVUVUTt2010-01-22 19:42:34.0000002b!AUzbekistanUZUZBt2010-01-22 19:42:34.000000/aAUruguayUYURYt2010-01-22 19:42:34.000000L`UAUnited States Minor Outlying IslandsUMUMIt2010-01-22 19:42:33.0000005_'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 -Eks{ #+3;CJRZbipx[cSK;3#+C PNRSTLPSZWZMYEWFVIVGVNVEVAVUUZUYUMUSPMPNPRPTPWPYQARERORURWSASBSCSDSESGSHSISJSKSLSMSNSOSRSTSV@SYSZTCTD*TFMTGTHTJTKTMTNTOTRTTTVTWTZUAUGVCWSYTZA -%_>Ziu_'4@Rp|1!~p#Timor-Leste Zimbabwe Zambia -Yemen)Western Sahara/Wallis and Futuna5Virgin Islands, U.S.;Virgin Islands, British Viet NamVenezuela Vanuatu!Uzbekistan Uruguay9Svalbard and Jan MayenSwaziland Sweden#Switzerland5Syrian Arab Republic Taiwan!Tajikistan!ETanzania, United Republic of Thailand Togo Tokelau -Tonga3Trinidad and Tobago Tunisia Turkey%Turkmenistan=Turks and Caicos Islands Tuvalu Uganda Ukraine5United Arab Emirates)United Kingdom'United States)UUnited States Minor Outlying Islands l5~Hb18{-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.000000 KsFW)~Q'uK(AIAIowa2013-01-07 17:24:09.196827+AINIndiana2013-01-07 17:24:09.195888,AILIllinois2013-01-07 17:24:09.194956)AIDIdaho2013-01-07 17:24:09.194039*AHIHawaii2013-01-07 17:24:09.193113(AGUGuam2013-01-07 17:24:09.192177+AGAGeorgia2013-01-07 17:24:09.151555+ AFLFlorida2013-01-07 17:24:09.150607B IAFMFederated States Of Micronesia2013-01-07 17:24:09.1496338 5ADCDistrict of Columbia2013-01-07 17:24:09.148668, -ADEDelaware2013-01-07 17:24:09.147745/ #ACTConnecticut2013-01-07 17:24:09.146818,ACOColorado2013-01-07 17:24:09.145893.!ACACalifornia2013-01-07 17:24:09.1449660%AAFArmed Forces2013-01-07 17:24:09.144007,AARArkansas2013-01-07 17:24:09.143078+AAZArizona2013-01-07 17:24:09.1421442)AASAmerican Samoa2013-01-07 17:24:09.141213*AAKAlaska2013-01-07 17:24:09.140200+AALAlabama2013-01-07 17:24:09.138452 KwLX'r?}K0(%ANDNorth Dakota2013-01-07 17:24:09.2158642')ANCNorth Carolina2013-01-07 17:24:09.214883,&ANYNew York2013-01-07 17:24:09.213915.%!ANMNew Mexico2013-01-07 17:24:09.212973.$!ANJNew Jersey2013-01-07 17:24:09.2120211#'ANHNew Hampshire2013-01-07 17:24:09.211053*"ANVNevada2013-01-07 17:24:09.210097,!ANENebraska2013-01-07 17:24:09.209145+ AMTMontana2013-01-07 17:24:09.208205,AMOMissouri2013-01-07 17:24:09.207277/#AMSMississippi2013-01-07 17:24:09.206344-AMNMinnesota2013-01-07 17:24:09.205412,AMIMichigan2013-01-07 17:24:09.2044851'AMAMassachusetts2013-01-07 17:24:09.203533,AMDMaryland2013-01-07 17:24:09.2025964-AMHMarshall Islands2013-01-07 17:24:09.201625)AMEMaine2013-01-07 17:24:09.200672-ALALouisiana2013-01-07 17:24:09.199716,AKYKentucky2013-01-07 17:24:09.198747*AKSKansas2013-01-07 17:24:09.197794 Fj>~Jg3sF+<AWYWyoming2013-01-07 17:24:09.234971-;AWIWisconsin2013-01-07 17:24:09.2340501:'AWVWest Virginia2013-01-07 17:24:09.233129.9!AWAWashington2013-01-07 17:24:09.232182,8AVAVirginia2013-01-07 17:24:09.23125027)AVIVirgin Islands2013-01-07 17:24:09.230314+6AVTVermont2013-01-07 17:24:09.229372(5AUTUtah2013-01-07 17:24:09.228428)4ATXTexas2013-01-07 17:24:09.227482-3ATNTennessee2013-01-07 17:24:09.22646402%ASDSouth Dakota2013-01-07 17:24:09.22548721)ASCSouth Carolina2013-01-07 17:24:09.22451200%ARIRhode Island2013-01-07 17:24:09.223565//#APRPuerto Rico2013-01-07 17:24:09.2226110.%APAPennsylvania2013-01-07 17:24:09.221645)-APWPalau2013-01-07 17:24:09.220649*,AOROregon2013-01-07 17:24:09.219696,+AOKOklahoma2013-01-07 17:24:09.218743(*AOHOhio2013-01-07 17:24:09.217795<)=AMPNorthern Mariana Islands2013-01-07 17:24:09.216834 5rAyMQb5+PAQHAMHamburg2013-01-07 17:24:09.253887*OAQBREBremen2013-01-07 17:24:09.252906/N#AQBRGBrandenburg2013-01-07 17:24:09.251934*MAQBERBerlin2013-01-07 17:24:09.250973*LAQBAYBayern2013-01-07 17:24:09.2500228K5AQBAWBaden-Württemberg2013-01-07 17:24:09.2490881J'AQNDSNiedersachsen2013-01-07 17:24:09.2481712I+A&YTYukon Territory2013-01-07 17:24:09.247251/H%A&SKSaskatchewan2013-01-07 17:24:09.246340)GA&QCQuebec2013-01-07 17:24:09.2454057F5A&PEPrince Edward Island2013-01-07 17:24:09.244484*EA&ONOntario2013-01-07 17:24:09.243568*DA&NUNunavut2013-01-07 17:24:09.2426248C7A&NTNorthwest Territories2013-01-07 17:24:09.241666.B#A&NSNova Scotia2013-01-07 17:24:09.2407200A'A&NBNew Brunswick2013-01-07 17:24:09.239760/@%A&NFNewfoundland2013-01-07 17:24:09.238780+?A&MBManitoba2013-01-07 17:24:09.2378083>-A&BCBritish Columbia2013-01-07 17:24:09.236826*=A&ABAlberta2013-01-07 17:24:09.235893 -:2Mgs(1ALap| 9\hu~#A Coruña} -Aargauc - Alabama -Alaska Alava~ Albacete Alberta= Alicante Almeria)American Samoa9Appenzell Ausserrhodene7Appenzell Innerrhodend Arizona Arkansas%Armed Forces Asturias -Avila Badajoz5Baden-WürttembergK BalearesBarcelona-Basel-Landschaftg#Basel-Stadth -BayernL -BerlinMBernf#BrandenburgN -BremenO-British Columbia>!Burgenlanda Burgos Caceres -Cadiz!CaliforniaCantabriaCastellon -Ceuta#Ciudad Real Colorado#Connecticut Cordoba Cuenca Delaware -5District of Columbia "IFederated States Of Micronesia Florida FreiburgiGenfj Georgia Girona -Glarusk Granada'Graubündenl#GuadalajaraGuamGuipuzcoa HamburgP -Hawaii -: /=MWcq{,<IUan{,DWh Huelva Huesca Idaho Illinois IndianaIowa JaenJuram -Kansas Kentucky!Kärnten^ La Rioja!Las Palmas Leon Lleida Louisiana Lugo -Luzernn Madrid Maine Malaga Manitoba?-Marshall Islands Maryland'Massachusetts9Mecklenburg-VorpommernR Melilla Michigan Minnesota#Mississippi Missouri Montana Murcia Navarra Nebraska! Neuenburgo -Nevada"'New BrunswickA'New Hampshire#!New Jersey$!New Mexico% New York&%Newfoundland@ Nidwaldenp'NiedersachsenJ3Niederösterreich[3Nordrhein-WestfalenS)North Carolina'%North Dakota(=Northern Mariana Islands)7Northwest TerritoriesC#Nova ScotiaB NunavutD/Oberösterreich\ ObwaldenqOhio* Oklahoma+ OntarioE \_*c1m>\*cAAGAargau2013-01-07 17:24:09.271856,bAVBVoralberg2013-01-07 17:24:09.270943-a!ABLBurgenland2013-01-07 17:24:09.269975(`ATITirol2013-01-07 17:24:09.269018-_!ASTSteiermark2013-01-07 17:24:09.268078-^!AKNKärnten2013-01-07 17:24:09.267116+]ASBSalzburg2013-01-07 17:24:09.2661914\/AOOOberösterreich2013-01-07 17:24:09.2652786[3ANONiederösterreich2013-01-07 17:24:09.264340'ZAWIWien2013-01-07 17:24:09.2633770Y%AQTHEThüringen2013-01-07 17:24:09.2623976X1AQSCNSchleswig-Holstein2013-01-07 17:24:09.2614122W)AQSACSachsen-Anhalt2013-01-07 17:24:09.260469+VAQSASSachsen2013-01-07 17:24:09.259544,UAQSARSaarland2013-01-07 17:24:09.2586213T+AQRHERheinland-Pfalz2013-01-07 17:24:09.2576857S3AQNRWNordrhein-Westfalen2013-01-07 17:24:09.256749:R9AQMECMecklenburg-Vorpommern2013-01-07 17:24:09.255797*QAQHESHessen2013-01-07 17:24:09.254844 I_)tA_/uI*wATITessin2013-01-07 17:24:09.292293+vATGThurgau2013-01-07 17:24:09.290896*uASZSchwyz2013-01-07 17:24:09.289610-tASOSolothurn2013-01-07 17:24:09.2884280s%ASHSchaffhausen2013-01-07 17:24:09.287137.r!ASGSt. Gallen2013-01-07 17:24:09.285961,qAOWObwalden2013-01-07 17:24:09.285034-pANWNidwalden2013-01-07 17:24:09.284057-oANENeuenburg2013-01-07 17:24:09.283102*nALULuzern2013-01-07 17:24:09.282187(mAJUJura2013-01-07 17:24:09.2812731l'AJUGraubünden2013-01-07 17:24:09.280353*kAGLGlarus2013-01-07 17:24:09.279437(jAGEGenf2013-01-07 17:24:09.278514,iAFRFreiburg2013-01-07 17:24:09.277584/h#ABSBasel-Stadt2013-01-07 17:24:09.2766624g-ABLBasel-Landschaft2013-01-07 17:24:09.275710(fABEBern2013-01-07 17:24:09.274771:e9AARAppenzell Ausserrhoden2013-01-07 17:24:09.2738279d7AAIAppenzell Innerrhoden2013-01-07 17:24:09.272857 -WaqxWJ</! u$+29@GNi\K<U]e0$lsz  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}AB=AFAGcAIdAK ALARAReASAZBAWKBAYLBC>BEfBERMBLaBLgBREOBRGNBShCACOCT DC DE -FL FM FRiGAGEjGLkGUHAMPHESQHIIAIDILINJUlJUmKN^KSKYLALUnMAMB?MDMEMECRMHMIMNMOMP) -Xw ~ p!(/6=DLS[ckryib[TujMF[OC?815%*# Zaragoza Zamora Vizcaya!Valladolid Valencia Toledo TeruelTarragona -Soria Sevilla Segovia9Santa Cruz de TenerifeSalamanca!Pontevedra Palencia Ourense Navarra Murcia Melilla Malaga MadridZH|ZG{VSzVDyURxTIwTGvSZuSOtSHsSGrOWqMT NBANC'ND(NDSJNE!NEoNF@NH#NJ$NM%NO[NRWSNSBNTCNUDNV"NWpNY&OH*OK+ONEOO\OR,PA.PEFPR/PW-QCGRHETRI0SACWSARUSASVSB]SC1SCNXSD2SKHST_THEYTI`TN3TX4UT5VA8VBbVI7VT6WA9WI;WIZWV:WY<YTI -[x &,28>DJPV\bhntz !)19AIQYaiqyxZ[\]^_`ab&=&>&?&@&A&B&C&D&E&F&G&H&IQJQKQLQMQNQOQPQQQRQSQTQUQVQWQXQY}~c -T %,3:AHOV]cjqx  '.5<CJQX_fmt{efghijklmnopqrstuvwxyz{|   -    !"#$%&'()*+,-./0123456789:;< WW(W$X!W4 -ACantabriaCantabria2013-01-07 17:24:09.311674, ACadizCadiz2013-01-07 17:24:09.3107300ACaceresCaceres2013-01-07 17:24:09.309770.ABurgosBurgos2013-01-07 17:24:09.3088234ABarcelonaBarcelona2013-01-07 17:24:09.3078572ABalearesBaleares2013-01-07 17:24:09.3069090ABadajozBadajoz2013-01-07 17:24:09.305963,AAvilaAvila2013-01-07 17:24:09.3050202AAsturiasAsturias2013-01-07 17:24:09.3040780AAlmeriaAlmeria2013-01-07 17:24:09.3031302AAlicanteAlicante2013-01-07 17:24:09.3021892AAlbaceteAlbacete2013-01-07 17:24:09.301234,~AAlavaAlava2013-01-07 17:24:09.3002848}##AA CoruñaA Coruña2013-01-07 17:24:09.299326-|AZHZürich2013-01-07 17:24:09.298368'{AZGZug2013-01-07 17:24:09.297387*zAVSWallis2013-01-07 17:24:09.296185)yAVDWaadt2013-01-07 17:24:09.294906'xAURUri2013-01-07 17:24:09.293614 -: 9IThy!.;ITgx&6BUbo} Zaragoza Zamora Ourense Palau- Palencia%Pennsylvania.!Pontevedra5Prince Edward IslandF#Puerto Rico/ -QuebecG+Rheinland-PfalzT%Rhode Island0 SaarlandU SachsenV)Sachsen-AnhaltWSalamanca Salzburg]9Santa Cruz de Tenerife%SaskatchewanH%Schaffhausens1Schleswig-HolsteinX -Schwyzu Segovia Sevilla Solothurnt -Soria)South Carolina1%South Dakota2!St. Gallenr!Steiermark_Tarragona Tennessee3 Teruel -Tessinw Texas4 Thurgauv%ThüringenY Tirol` ToledoUrixUtah5 Valencia!Valladolid Vermont6)Virgin Islands7 Virginia8 Vizcaya Voralbergb Waadty -Wallisz!Washington9'West Virginia:WienZ Wisconsin; Wyoming<+Yukon TerritoryIZug{ Zürich| ;_,\%a(l;.AMalagaMalaga2013-01-07 17:24:09.329709.AMadridMadrid2013-01-07 17:24:09.328757*ALugoLugo2013-01-07 17:24:09.327800.ALleidaLleida2013-01-07 17:24:09.326863*ALeonLeon2013-01-07 17:24:09.3259226!!ALas PalmasLas Palmas2013-01-07 17:24:09.3249742ALa RiojaLa Rioja2013-01-07 17:24:09.324023*AJaenJaen2013-01-07 17:24:09.323062.AHuescaHuesca2013-01-07 17:24:09.322117.AHuelvaHuelva2013-01-07 17:24:09.3211664AGuipuzcoaGuipuzcoa2013-01-07 17:24:09.3202238##AGuadalajaraGuadalajara2013-01-07 17:24:09.3192720AGranadaGranada2013-01-07 17:24:09.318335.AGironaGirona2013-01-07 17:24:09.317388.ACuencaCuenca2013-01-07 17:24:09.3164410ACordobaCordoba2013-01-07 17:24:09.3155028 ##ACiudad RealCiudad Real2013-01-07 17:24:09.314534, ACeutaCeuta2013-01-07 17:24:09.3135734 ACastellonCastellon2013-01-07 17:24:09.312623 @i6@ tCq@./AZamoraZamora2013-01-07 17:24:09.3469790.AVizcayaVizcaya2013-01-07 17:24:09.3460076-!!AValladolidValladolid2013-01-07 17:24:09.3450322,AValenciaValencia2013-01-07 17:24:09.344058.+AToledoToledo2013-01-07 17:24:09.343098.*ATeruelTeruel2013-01-07 17:24:09.3421364)ATarragonaTarragona2013-01-07 17:24:09.341174,(ASoriaSoria2013-01-07 17:24:09.3402190'ASevillaSevilla2013-01-07 17:24:09.3392550&ASegoviaSegovia2013-01-07 17:24:09.338304N%99ASanta Cruz de TenerifeSanta Cruz de Tenerife2013-01-07 17:24:09.3373304$ASalamancaSalamanca2013-01-07 17:24:09.3363556#!!APontevedraPontevedra2013-01-07 17:24:09.3354012"APalenciaPalencia2013-01-07 17:24:09.3344470!AOurenseOurense2013-01-07 17:24:09.3334860 ANavarraNavarra2013-01-07 17:24:09.332532.AMurciaMurcia2013-01-07 17:24:09.3315930AMelillaMelilla2013-01-07 17:24:09.330644 20AZaragozaZaragoza2013-01-07 17:24:09.347939 +Sudan Suriname9Svalbard and Jan MayenSwaziland Sweden#Switzerland5Syrian Arab Republic Taiwan!Tajikistan!ETanzania, United Republic of Thailand Togo Tokelau +Tonga3Trinidad and Tobago Tunisia Turkey%Turkmenistan=Turks and Caicos Islands Tuvalu Uganda Ukraine5United Arab Emirates)United Kingdom'United States)UUnited States Minor Outlying Islands Uruguay!Uzbekistan VanuatuVenezuela QsFW) ~ Q ' u K  a 3 + + +r +D + Z *X.wFT*k8 {NU)`-j>*QAQHESHessen2013-01-07 21:44:58.931660+PAQHAMHamburg2013-01-07 21:44:58.930889*OAQBREBremen2013-01-07 21:44:58.930089/N#AQBRGBrandenburg2013-01-07 21:44:58.929312*MAQBERBerlin2013-01-07 21:44:58.928505*LAQBAYBayern2013-01-07 21:44:58.9277368K5AQBAWBaden-Württemberg2013-01-07 21:44:58.9269101J'AQNDSNiedersachsen2013-01-07 21:44:58.9261382I+A&YTYukon Territory2013-01-07 21:44:58.925359/H%A&SKSaskatchewan2013-01-07 21:44:58.924610)GA&QCQuebec2013-01-07 21:44:58.9238397F5A&PEPrince Edward Island2013-01-07 21:44:58.923063*EA&ONOntario2013-01-07 21:44:58.922310*DA&NUNunavut2013-01-07 21:44:58.9215058C7A&NTNorthwest Territories2013-01-07 21:44:58.920744.B#A&NSNova Scotia2013-01-07 21:44:58.9199620A'A&NBNew Brunswick2013-01-07 21:44:58.919191/@%A&NFNewfoundland2013-01-07 21:44:58.918406+?A&MBManitoba2013-01-07 21:44:58.9176353>-A&BCBritish Columbia2013-01-07 21:44:58.916829*=A&ABAlberta2013-01-07 21:44:58.912228+<AWYWyoming2013-01-07 21:44:58.911420-;AWIWisconsin2013-01-07 21:44:58.9105031:'AWVWest Virginia2013-01-07 21:44:58.909413.9!AWAWashington2013-01-07 21:44:58.908413,8AVAVirginia2013-01-07 21:44:58.90745527)AVIVirgin Islands2013-01-07 21:44:58.906416+6AVTVermont2013-01-07 21:44:58.905378(5AUTUtah2013-01-07 21:44:58.904325)4ATXTexas2013-01-07 21:44:58.903179-3ATNTennessee2013-01-07 21:44:58.90194302%ASDSouth Dakota2013-01-07 21:44:58.90070321)ASCSouth Carolina2013-01-07 21:44:58.89936500%ARIRhode Island2013-01-07 21:44:58.897819//#APRPuerto Rico2013-01-07 21:44:58.8900430.%APAPennsylvania2013-01-07 21:44:58.889289)-APWPalau2013-01-07 21:44:58.888514*,AOROregon2013-01-07 21:44:58.887639,+AOKOklahoma2013-01-07 21:44:58.886732(*AOHOhio2013-01-07 21:44:58.885828<)=AMPNorthern Mariana Islands2013-01-07 21:44:58.8847750(%ANDNorth Dakota2013-01-07 21:44:58.8837332')ANCNorth Carolina2013-01-07 21:44:58.882686,&ANYNew York2013-01-07 21:44:58.881593.%!ANMNew Mexico2013-01-07 21:44:58.880355.$!ANJNew Jersey2013-01-07 21:44:58.8791241#'ANHNew Hampshire2013-01-07 21:44:58.877883*"ANVNevada2013-01-07 21:44:58.876258,!ANENebraska2013-01-07 21:44:58.869330+ AMTMontana2013-01-07 21:44:58.868574,AMOMissouri2013-01-07 21:44:58.867777/#AMSMississippi2013-01-07 21:44:58.867028-AMNMinnesota2013-01-07 21:44:58.866274,AMIMichigan2013-01-07 21:44:58.8655221'AMAMassachusetts2013-01-07 21:44:58.864774,AMDMaryland2013-01-07 21:44:58.8640194-AMHMarshall Islands2013-01-07 21:44:58.863248)AMEMaine2013-01-07 21:44:58.862481-ALALouisiana2013-01-07 21:44:58.861726,AKYKentucky2013-01-07 21:44:58.860975*AKSKansas2013-01-07 21:44:58.860223(AIAIowa2013-01-07 21:44:58.859466+AINIndiana2013-01-07 21:44:58.858705,AILIllinois2013-01-07 21:44:58.855921)AIDIdaho2013-01-07 21:44:58.855160*AHIHawaii2013-01-07 21:44:58.854407(AGUGuam2013-01-07 21:44:58.853651+AGAGeorgia2013-01-07 21:44:58.852892+ AFLFlorida2013-01-07 21:44:58.852117B IAFMFederated States Of Micronesia2013-01-07 21:44:58.8513688 5ADCDistrict of Columbia2013-01-07 21:44:58.850605, +ADEDelaware2013-01-07 21:44:58.849831/ #ACTConnecticut2013-01-07 21:44:58.849064,ACOColorado2013-01-07 21:44:58.848229.!ACACalifornia2013-01-07 21:44:58.8474740%AAFArmed Forces2013-01-07 21:44:58.846718,AARArkansas2013-01-07 21:44:58.845959+AAZArizona2013-01-07 21:44:58.8436682)AASAmerican Samoa2013-01-07 21:44:58.842895*AAKAlaska2013-01-07 21:44:58.842059+AALAlabama2013-01-07 21:44:58.838880 OV(]4 j ;  M  R ( + + + +s +D + V *}Q(](^)_(T#MP#c00 ANavarraNavarra2013-01-07 21:44:59.108999.AMurciaMurcia2013-01-07 21:44:59.1082080AMelillaMelilla2013-01-07 21:44:59.107050.AMalagaMalaga2013-01-07 21:44:59.106232.AMadridMadrid2013-01-07 21:44:59.105348*ALugoLugo2013-01-07 21:44:59.104274.ALleidaLleida2013-01-07 21:44:59.103346*ALeonLeon2013-01-07 21:44:59.1024626!!ALas PalmasLas Palmas2013-01-07 21:44:59.1016592ALa RiojaLa Rioja2013-01-07 21:44:59.100865*AJaenJaen2013-01-07 21:44:59.100081.AHuescaHuesca2013-01-07 21:44:59.099296.AHuelvaHuelva2013-01-07 21:44:59.0985174AGuipuzcoaGuipuzcoa2013-01-07 21:44:59.0973718##AGuadalajaraGuadalajara2013-01-07 21:44:59.0334510AGranadaGranada2013-01-07 21:44:59.032637.AGironaGirona2013-01-07 21:44:59.031850.ACuencaCuenca2013-01-07 21:44:59.0310460ACordobaCordoba2013-01-07 21:44:59.0302038 ##ACiudad RealCiudad Real2013-01-07 21:44:58.993169, ACeutaCeuta2013-01-07 21:44:58.9924184 ACastellonCastellon2013-01-07 21:44:58.9916554 +ACantabriaCantabria2013-01-07 21:44:58.990890, ACadizCadiz2013-01-07 21:44:58.9901300ACaceresCaceres2013-01-07 21:44:58.989377.ABurgosBurgos2013-01-07 21:44:58.9886124ABarcelonaBarcelona2013-01-07 21:44:58.9878322ABalearesBaleares2013-01-07 21:44:58.9870440ABadajozBadajoz2013-01-07 21:44:58.982538,AAvilaAvila2013-01-07 21:44:58.9817612AAsturiasAsturias2013-01-07 21:44:58.9809950AAlmeriaAlmeria2013-01-07 21:44:58.9801642AAlicanteAlicante2013-01-07 21:44:58.9793402AAlbaceteAlbacete2013-01-07 21:44:58.978525,~AAlavaAlava2013-01-07 21:44:58.9777308}##AA CoruñaA Coruña2013-01-07 21:44:58.976945-|AZHZürich2013-01-07 21:44:58.976164'{AZGZug2013-01-07 21:44:58.975348*zAVSWallis2013-01-07 21:44:58.974554)yAVDWaadt2013-01-07 21:44:58.973780'xAURUri2013-01-07 21:44:58.972998*wATITessin2013-01-07 21:44:58.972217+vATGThurgau2013-01-07 21:44:58.968341*uASZSchwyz2013-01-07 21:44:58.967327-tASOSolothurn2013-01-07 21:44:58.9664900s%ASHSchaffhausen2013-01-07 21:44:58.965636.r!ASGSt. Gallen2013-01-07 21:44:58.964840,qAOWObwalden2013-01-07 21:44:58.964092-pANWNidwalden2013-01-07 21:44:58.963301-oANENeuenburg2013-01-07 21:44:58.962528*nALULuzern2013-01-07 21:44:58.961415(mAJUJura2013-01-07 21:44:58.9599441l'AJUGraubünden2013-01-07 21:44:58.958764*kAGLGlarus2013-01-07 21:44:58.957963(jAGEGenf2013-01-07 21:44:58.957192,iAFRFreiburg2013-01-07 21:44:58.956385/h#ABSBasel-Stadt2013-01-07 21:44:58.9520064g-ABLBasel-Landschaft2013-01-07 21:44:58.951220(fABEBern2013-01-07 21:44:58.950461:e9AARAppenzell Ausserrhoden2013-01-07 21:44:58.9496939d7AAIAppenzell Innerrhoden2013-01-07 21:44:58.948937*cAAGAargau2013-01-07 21:44:58.948180,bAVBVoralberg2013-01-07 21:44:58.947396-a!ABLBurgenland2013-01-07 21:44:58.946595(`ATITirol2013-01-07 21:44:58.945731-_!ASTSteiermark2013-01-07 21:44:58.944970-^!AKNKärnten2013-01-07 21:44:58.944180+]ASBSalzburg2013-01-07 21:44:58.9434024\/AOOOberösterreich2013-01-07 21:44:58.9426006[3ANONiederösterreich2013-01-07 21:44:58.941809'ZAWIWien2013-01-07 21:44:58.9387820Y%AQTHEThüringen2013-01-07 21:44:58.9380096X1AQSCNSchleswig-Holstein2013-01-07 21:44:58.9372272W)AQSACSachsen-Anhalt2013-01-07 21:44:58.936448+VAQSASSachsen2013-01-07 21:44:58.935673,UAQSARSaarland2013-01-07 21:44:58.9348963T+AQRHERheinland-Pfalz2013-01-07 21:44:58.9340997S3AQNRWNordrhein-Westfalen2013-01-07 21:44:58.933236:R9AQMECMecklenburg-Vorpommern2013-01-07 21:44:58.932445  _(qB t ;  20AZaragozaZaragoza2013-01-07 21:44:59.135859./AZamoraZamora2013-01-07 21:44:59.1300220.AVizcayaVizcaya2013-01-07 21:44:59.1292526-!!AValladolidValladolid2013-01-07 21:44:59.1284752,AValenciaValencia2013-01-07 21:44:59.127699.+AToledoToledo2013-01-07 21:44:59.126897.*ATeruelTeruel2013-01-07 21:44:59.1260334)ATarragonaTarragona2013-01-07 21:44:59.125213,(ASoriaSoria2013-01-07 21:44:59.1243760'ASevillaSevilla2013-01-07 21:44:59.1235330&ASegoviaSegovia2013-01-07 21:44:59.122686N%99ASanta Cruz de TenerifeSanta Cruz de Tenerife2013-01-07 21:44:59.1218464$ASalamancaSalamanca2013-01-07 21:44:59.1210096#!!APontevedraPontevedra2013-01-07 21:44:59.1202052"APalenciaPalencia2013-01-07 21:44:59.1193240!AOurenseOurense2013-01-07 21:44:59.109808 \ No newline at end of file