SQLite format 3@ :p`:-dCo3qindexindex_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" ("UEC94,$ {i\ԁPāB3#tvbgPWFG2=%* p^L:()20100819181805)20130107214724 )20130107214723 )20130107214722 )20130107214721 )20130107214720 )20130107214719)20130107214718)20130107214717)20130107214716)20130107214715)20130107214714)20130107214713)20130107214712)20130107214711 {hUB/ )20100819181805)20130107214724)20130107214723 )20130107214722 )20130107214721 )20130107214720 )20130107214719 )20130107214718)20130107214717)20130107214716)20130107214715)20130107214714)20130107214713)20130107214712)20130107214711 AAA@2013-01-07 21:47:32.8150172013-01-07 21:47:32.815017 ! <uW9)k[N<  } k Q <!+audit_log_types 5capability_accessors%capabilities5compass_ae_instances%delayed_jobs-user_preferences#preferences)app_containers users'organizations parties#individuals9valid_preference_types%applications widgets !note_types1preference_options-preference_types)security_roles-contact_purposes geo_zones 'geo_countries =biz_txn_party_role_types" Iprod_availability_status_types !currencies=prod_instance_role_types=prod_instance_reln_types5prod_type_role_types5prod_type_reln_types#scope_types-capability_types'biz_txn_types;payment_gateway_actions SSS %AATrueNorthOrganization2013-01-07 21:47:31.9513302013-01-07 21:47:31.951330V )!AAAdmin IstratorIndividual2013-01-07 21:47:31.9335402013-01-07 21:47:31.933540 %Organization!Individual            CAATrueNorth2013-01-07 21:47:31.9496932013-01-07 21:47:31.949693 "*   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) \AAIstratorAdminm2013-01-07 21:47:31.9180622013-01-07 21:47:31.918062        bn T b  h L AAOtherother2013-01-07 21:47:31.3938152013-01-07 21:47:31.393815R AAShippingshipping2013-01-07 21:47:31.3919932013-01-07 21:47:31.391993T AAEmergencyemergency2013-01-07 21:47:31.3901872013-01-07 21:47:31.390187N AAMobilemobile2013-01-07 21:47:31.3883692013-01-07 21:47:31.388369H AAFaxfax2013-01-07 21:47:31.3865552013-01-07 21:47:31.386555R AAPersonalpersonal2013-01-07 21:47:31.3847172013-01-07 21:47:31.384717R AABusinessbusiness2013-01-07 21:47:31.3828592013-01-07 21:47:31.382859b --AAEmployment Offeremployment_offer2013-01-07 21:47:31.3809922013-01-07 21:47:31.380992V !!AA Recruitingrecruiting2013-01-07 21:47:31.3791192013-01-07 21:47:31.379119\ ''AA Tax Reportingtax_reporting2013-01-07 21:47:31.3771552013-01-07 21:47:31.377155T AA Temporarytemporary2013-01-07 21:47:31.3753442013-01-07 21:47:31.375344P AABillingbilling2013-01-07 21:47:31.3734942013-01-07 21:47:31.373494J AAWorkwork2013-01-07 21:47:31.3716842013-01-07 21:47:31.371684J AAHomehome2013-01-07 21:47:31.3693382013-01-07 21:47:31.369338P AADefaultdefault2013-01-07 21:47:31.3663712013-01-07 21:47:31.366371             .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:47:30.5156212013-01-07 21:47:30.515621 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")7tablenotesnotesCREATE 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)  kj9 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-2j`ihMmxlbTH9-!{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 All'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 AQAIAOADASDZALAFpW) ~ Q ' u K  a 3 r D  Z *X.wFT*k8 {NU)`-j>*QAQHESHessen2013-01-07 21:47:31.236064+PAQHAMHamburg2013-01-07 21:47:31.235315*OAQBREBremen2013-01-07 21:47:31.234508/N#AQBRGBrandenburg2013-01-07 21:47:31.233659*MAQBERBerlin2013-01-07 21:47:31.232900*LAQBAYBayern2013-01-07 21:47:31.2320998K5AQBAWBaden-Württemberg2013-01-07 21:47:31.2312981J'AQNDSNiedersachsen2013-01-07 21:47:31.2305342I+A&YTYukon Territory2013-01-07 21:47:31.229647/H%A&SKSaskatchewan2013-01-07 21:47:31.228675)GA&QCQuebec2013-01-07 21:47:31.2277407F5A&PEPrince Edward Island2013-01-07 21:47:31.226669*EA&ONOntario2013-01-07 21:47:31.225608*DA&NUNunavut2013-01-07 21:47:31.2245708C7A&NTNorthwest Territories2013-01-07 21:47:31.223481.B#A&NSNova Scotia2013-01-07 21:47:31.2222580A'A&NBNew Brunswick2013-01-07 21:47:31.221046/@%A&NFNewfoundland2013-01-07 21:47:31.219803+?A&MBManitoba2013-01-07 21:47:31.2181913>-A&BCBritish Columbia2013-01-07 21:47:31.196317*=A&ABAlberta2013-01-07 21:47:31.131652+<AWYWyoming2013-01-07 21:47:31.130449-;AWIWisconsin2013-01-07 21:47:31.1292071:'AWVWest Virginia2013-01-07 21:47:31.127967.9!AWAWashington2013-01-07 21:47:31.127186,8AVAVirginia2013-01-07 21:47:31.12639927)AVIVirgin Islands2013-01-07 21:47:31.125560+6AVTVermont2013-01-07 21:47:31.124769(5AUTUtah2013-01-07 21:47:31.123911)4ATXTexas2013-01-07 21:47:31.123106-3ATNTennessee2013-01-07 21:47:31.12229702%ASDSouth Dakota2013-01-07 21:47:31.12139621)ASCSouth Carolina2013-01-07 21:47:31.12025000%ARIRhode Island2013-01-07 21:47:31.119246//#APRPuerto Rico2013-01-07 21:47:31.1181510.%APAPennsylvania2013-01-07 21:47:31.117210)-APWPalau2013-01-07 21:47:31.116500*,AOROregon2013-01-07 21:47:31.115779,+AOKOklahoma2013-01-07 21:47:31.115061(*AOHOhio2013-01-07 21:47:31.114342<)=AMPNorthern Mariana Islands2013-01-07 21:47:31.1136200(%ANDNorth Dakota2013-01-07 21:47:31.1128912')ANCNorth Carolina2013-01-07 21:47:31.112171,&ANYNew York2013-01-07 21:47:31.111450.%!ANMNew Mexico2013-01-07 21:47:31.110730.$!ANJNew Jersey2013-01-07 21:47:31.1100121#'ANHNew Hampshire2013-01-07 21:47:31.109281*"ANVNevada2013-01-07 21:47:31.108537,!ANENebraska2013-01-07 21:47:31.107807+ AMTMontana2013-01-07 21:47:31.107085,AMOMissouri2013-01-07 21:47:31.106369/#AMSMississippi2013-01-07 21:47:31.105642-AMNMinnesota2013-01-07 21:47:31.104919,AMIMichigan2013-01-07 21:47:31.1041971'AMAMassachusetts2013-01-07 21:47:31.103468,AMDMaryland2013-01-07 21:47:31.1027294-AMHMarshall Islands2013-01-07 21:47:31.101990)AMEMaine2013-01-07 21:47:31.101265-ALALouisiana2013-01-07 21:47:31.100549,AKYKentucky2013-01-07 21:47:31.099828*AKSKansas2013-01-07 21:47:31.099101(AIAIowa2013-01-07 21:47:31.098312+AINIndiana2013-01-07 21:47:31.097423,AILIllinois2013-01-07 21:47:31.096693)AIDIdaho2013-01-07 21:47:31.095971*AHIHawaii2013-01-07 21:47:31.095242(AGUGuam2013-01-07 21:47:31.094503+AGAGeorgia2013-01-07 21:47:31.093778+ AFLFlorida2013-01-07 21:47:31.093055B IAFMFederated States Of Micronesia2013-01-07 21:47:31.0923268 5ADCDistrict of Columbia2013-01-07 21:47:31.091604, ADEDelaware2013-01-07 21:47:31.090877/ #ACTConnecticut2013-01-07 21:47:31.090152,ACOColorado2013-01-07 21:47:31.089393.!ACACalifornia2013-01-07 21:47:31.0886710%AAFArmed Forces2013-01-07 21:47:31.087849,AARArkansas2013-01-07 21:47:31.087123+AAZArizona2013-01-07 21:47:31.0864032)AASAmerican Samoa2013-01-07 21:47:31.085684*AAKAlaska2013-01-07 21:47:31.084957+AALAlabama2013-01-07 21:4o nQ % ~ 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     V !!AABasic Notebasic_note2013-01-07 21:47:31.6427202013-01-07 21:47:31.642720      QQ F `'#kG55]tableprod_type_reln_typesprod_type_reln_typesMCREATE TABLE "prod_type_reln_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "z@''3tableproduct_typesproduct_typesECREATE TABLE "product_types" (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")z@''3tableproduct_typesproduct_typesECREATE TABLE "product_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "product_type_record_id" integer, "product_type_record_type" varchar(255), "external_identifier" varchar(255), "internal_identifier" varchar(255), "external_id_source" varchar(255), "default_image_url" varchar(255), "list_view_image_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)A//;tableproduct_instancesproduct_instancesGCREATE TABLE "product_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "product_instance_record_id" integer, "product_instance_record_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "product_type_id" integer, "type" varchar(255), "prod_availability_status_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)hB)) tableproduct_offersproduct_offersHCREATE TABLE "product_offers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "product_offer_record_id" integer, "product_offer_record_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL))C77qtablesimple_product_offerssimple_product_offersICREATE TABLE "simple_product_offers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "product_id" integer, "base_price" decimal(8,2), "uom" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL))D==etableprod_instance_reln_typesprod_instance_reln_typesJCREATE TABLE "prod_instance_reln_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))E==etableprod_instance_role_typesprod_instance_role_typesKCREATE TABLE "prod_instance_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)?F33%tableprod_instance_relnsprod_instance_relnsLCREATE TABLE "prod_instance_relns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "prod_instance_reln_type_id" integer, "description" varchar(255), "prod_instance_id_from" integer, "prod_instance_id_to" integer, "role_type_id_from" integer, "role_type_id_to" integer, "status_type_id" integer, "from_date" date, "thru_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G55]tableprod_type_reln_typesprod_type_reln_typesMCREATE TABLE "prod_type_reln_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)    xx YGAAProduct Instance Package Relantionshipproduct_instance_package_reln2013-01-07 21:47:30.4491132013-01-07 21:47:30.449113 t ??AAPackaged Product Instancepackaged_product_instance2013-01-07 21:47:30.4774642013-01-07 21:47:30.477464r ==AAProduct Instance Packageproduct_instance_package2013-01-07 21:47:30.4751902013-01-07 21:47:30.475190  | O?AAProduct Type Package Relationshipproduct_type_package_reln2013-01-07 21:47:30.3435402013-01-07 21:47:30.343540 &&l 77AAPackaged Product Typepackaged_product_type2013-01-07 21:47:30.4230492013-01-07 21:47:30.423049j 55AAProduct Type Packageproduct_type_package2013-01-07 21:47:30.4207302013-01-07 21:47:30.420730  L= I v % Y  WDH55]tableprod_type_role_typesprod_type_role_typesNCREATE TABLE "prod_type_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), "creH55]tableprod_type_role_typesprod_type_role_typesNCREATE TABLE "prod_type_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)'I++tableprod_type_relnsprod_type_relnsOCREATE TABLE "prod_type_relns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "prod_type_reln_type_id" integer, "description" varchar(255), "prod_type_id_from" integer, "prod_type_id_to" integer, "role_type_id_from" integer, "role_type_id_to" integer, "status_type_id" integer, "from_date" date, "thru_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)JGG=tableproduct_instance_status_typesproduct_instance_status_typesQCREATE TABLE "product_instance_status_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), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"KII?tableprod_availability_status_typesprod_availability_status_typesRCREATE TABLE "prod_availability_status_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), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) LM'-indexindex_product_types_on_parent_idproduct_typesSCREATE INDEX "index_product_types_on_parent_id" ON "product_types" ("parent_id")}M'Iindexbpi_1product_typesTCREATE INDEX "bpi_1" ON "product_types" ("product_type_record_id", "product_type_record_type")NU/=indexindex_product_instances_on_parent_idproduct_instancesUCREATE INDEX "index_product_instances_on_parent_id" ON "product_instances" ("parent_id") O/aindexbpi_2product_instancesVCREATE INDEX "bpi_2" ON "product_instances" ("product_instance_record_id", "product_instance_record_type"),Pa/Uindexindex_product_instances_on_product_type_idproduct_instancesWCREATE INDEX "index_product_instances_on_product_type_id" ON "product_instances" ("product_type_id")Q)Oindexbpi_3product_offersXCREATE INDEX "bpi_3" ON "product_offers" ("product_offer_record_id", "product_offer_record_type")-R_7Qindexindex_simple_product_offers_on_product_idsimple_product_offersYCREATE INDEX "index_simple_product_offers_on_product_id" ON "simple_product_offers" ("product_id")6Sc=Yindexindex_prod_instance_reln_types_on_parent_idprod_instance_reln_typesZCREATE INDEX "index_prod_instance_reln_types_on_parent_id" ON "prod_instance_reln_types" ("parent_id")6Tc=Yindexindex_prod_instance_role_types_on_parent_idprod_instance_role_types[CREATE INDEX "index_prod_instance_role_types_on_parent_id" ON "prod_instance_role_types" ("parent_id")UU{3 indexindex_prod_instance_relns_on_prod_instance_reln_type_idprod_instance_relns\CREATE INDEX "index_prod_instance_relns_on_prod_instance_reln_type_id" ON "prod_instance_relns" ("prod_instance_reln_type_id")1Vc3Yindexindex_prod_instance_relns_on_status_type_idprod_instance_relns]CREATE INDEX "index_prod_instance_relns_on_status_type_id" ON "prod_instance_relns" ("status_type_id")&W[5Iindexindex_prod_type_reln_types_on_parent_idprod_type_reln_types^CREATE INDEX "index_prod_type_reln_types_on_parent_id" ON "prod_type_reln_types" ("parent_id")  `O AAShippedshipped2013-01-07 21:47:30.6114562013-01-07 21:47:30.611456I AASoldsold2013-01-07 21:47:30.6094252013-01-07 21:47:30.609425S AAAvailableavailable2013-01-07 21:47:30.6068842013-01-07 21:47:30.606884                aa jQ . A zW)j++ tableaudit_log_typesaudit_log_typesrCREATE TABLE "audit_log_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "error_code" varchar(255), "comme!Z[+Iindexindex_prod_type_relns_on_status_type_idprod_type_relnsaC&X[5Iindexindex_prod_type_role_types_on_parent_idprod_type_role_types_CREATE INDEX "index_prod_type_role_types_on_parent_id" ON "prod_type_role_types" ("parent_id")9Yk+iindexindex_prod_type_relns_on_prod_type_reln_type_idprod_type_relns`CREATE INDEX&X[5Iindexindex_prod_type_role_types_on_parent_idprod_type_role_types_CREATE INDEX "index_prod_type_role_types_on_parent_id" ON "prod_type_role_types" ("parent_id")9Yk+iindexindex_prod_type_relns_on_prod_type_reln_type_idprod_type_relns`CREATE INDEX "index_prod_type_relns_on_prod_type_reln_type_id" ON "prod_type_relns" ("prod_type_reln_type_id")!Z[+Iindexindex_prod_type_relns_on_status_type_idprod_type_relnsaCREATE INDEX "index_prod_type_relns_on_status_type_id" ON "prod_type_relns" ("status_type_id")}[YtableusersuserscCREATE 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)e\5 indexindex_users_on_emailusersdCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")n];indexindex_users_on_usernameuserseCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")k^%'indexactivity_idxusersfCREATE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")_M-indexindex_users_on_remember_me_tokenusersgCREATE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token") `S9indexindex_users_on_reset_password_tokenusershCREATE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")aK)indexindex_users_on_activation_tokenusersiCREATE INDEX "index_users_on_activation_token" ON "users" ("activation_token"))j++ tableaudit_log_typesaudit_log_typesrCREATE TAB{hE!indexindex_audit_logs_on_party_idaudit_logspCREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")i1!Aindexevent_record_indexaudit_logsqCREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type"))j++ tableaudit_log_typesaudit_log_typesrCREATE TABLE "audit_log_types" ("id" INTEGER PRIMARY KE{hE!indexindex_audit_logs_on_party_idaudit_logspCREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")i1!Aindexevent_record_indexaudit_logsqCREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type"))j++ tableaudit_log_typesaudit_log_typesrCREATE 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)6k++#tableaudit_log_itemsaudit_log_itemssCREATE 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)l55]tableaudit_log_item_typesaudit_log_item_typesuCREATE 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)^m##tablefile_assetsfile_assetsvCREATE 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)sn?#indexindex_file_assets_on_typefile_assetswCREATE INDEX "index_file_assets_on_type" ON "file_assets" ("type")o7#]indexfile_asset_holder_idxfile_assetsxCREATE INDEX "file_asset_holder_idx" ON "file_assets" ("file_asset_holder_id", "file_asset_holder_type")sp?#indexindex_file_assets_on_namefile_assetsyCREATE INDEX "index_file_assets_on_name" ON "file_assets" ("name")qI#%indexindex_file_assets_on_directoryfile_assetszCREATE INDEX "index_file_assets_on_directory" ON "file_assets" ("directory")r%%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){s7%'indexdelayed_jobs_prioritydelayed_jobs|CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")t))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)'u=)uindexcapable_model_record_idxcapable_models~CREATE INDEX "capable_model_record_idx" ON "capable_models" ("capable_model_record_id", "capable_model_record_type")~v--/tablecapability_typescapability_typesCREATE 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)       RR+'AAA--- !ruby/object:ErpTechSvcs::Sessions::DeleteExpiredSessionsJob priority: 1 2013-01-08 07:00:01.0000002013-01-07 21:47:32.7432532013-01-07 21:47:32.743253  A2013-01-08 07:00:01.000000   l$BAAviewView2013-01-07 21:47:32.9648142013-01-07 21:47:32.964814FAAdeleteDelete2013-01-07 21:47:32.9473432013-01-07 21:47:32.947343FAAcreateCreate2013-01-07 21:47:32.8933622013-01-07 21:47:32.893362JAAdownloadDownload2013-01-07 21:47:30.2869152013-01-07 21:47:30.286915 m^ mO #AADelete NoteNote2013-01-07 21:47:32.9757252013-01-07 21:47:32.975725M AAView NoteNote2013-01-07 21:47:32.9666912013-01-07 21:47:32.966691O #AACreate NoteNote2013-01-07 21:47:32.9557572013-01-07 21:47:32.955757O #AADelete UserUser2013-01-07 21:47:32.9493702013-01-07 21:47:32.949370O #AACreate UserUser2013-01-07 21:47:32.9199632013-01-07 21:47:32.919963    Note Note Note User User  j> I%AASecurityRole2013-01-07 21:47:32.9790792013-01-07 21:47:32.979079I%AASecurityRole2013-01-07 21:47:32.9732632013-01-07 21:47:32.973263I%AASecurityRole2013-01-07 21:47:32.9703112013-01-07 21:47:32.970311I%AASecurityRole2013-01-07 21:47:32.9627832013-01-07 21:47:32.962783I%AASecurityRole2013-01-07 21:47:32.9591532013-01-07 21:47:32.959153I%AASecurityRole2013-01-07 21:47:32.9531532013-01-07 21:47:32.953153I%AASecurityRole2013-01-07 21:47:32.9445192013-01-07 21:47:32.944519 vv| d , F {6 W!Aindexindex_order_txns_on_order_txn_type_idorder_txnsCREATE INDEX "index_order_txns_on_order_txn_type_id" ON "order_txns" ("order_txn_type_id")$z?%oindexcapability_resource_indexcapabilitiesCREATE INDEX "capability_resource_index" ON "capabilities" ("capability_resource_id", "capability_resource_type"ew%% tablecapabilitiescapabilitiesCREATE 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)"x]%Mindexindex_capabilities_on_capability_type_idcapabilitiesCREATE INDEX "index_capabilities_on_capability_type_id" ON "capabilities" ("capability_type_id")yS%9indexindex_capabilities_on_scope_type_idcapabilitiesCREATE INDEX "index_capabilities_on_scope_type_id" ON "capabilities" ("scope_type_id")$z?%oindexcapability_resource_indexcapabilitiesCREATE INDEX "capability_resource_index" ON "capabilities" ("capability_resource_id", "capability_resource_type")={55tablecapability_accessorscapability_accessorsCREATE 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)3|c5Yindexindex_capability_accessors_on_capability_idcapability_accessorsCREATE INDEX "index_capability_accessors_on_capability_id" ON "capability_accessors" ("capability_id")P}M5)indexcapability_accessor_record_indexcapability_accessorsCREATE INDEX "capability_accessor_record_index" ON "capability_accessors" ("capability_accessor_record_id", "capability_accessor_record_type")p~##%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)!]#Mindexindex_scope_types_on_internal_identifierscope_typesCREATE INDEX "index_scope_types_on_internal_identifier" ON "scope_types" ("internal_identifier")999tableparties_security_rolesparties_security_rolesCREATE TABLE "parties_security_roles" ("party_id" integer, "security_role_id" integer),]9Mindexindex_parties_security_roles_on_party_idparties_security_rolesCREATE INDEX "index_parties_security_roles_on_party_id" ON "parties_security_roles" ("party_id")Dm9mindexindex_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")++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) =+5index:attribute_types_iid_idxattribute_typesCREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")9--#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)BY- indexattribute_values_attributed_record_idxattribute_valuesCREATE INDEX "attribute_values_attributed_record_idx" ON "attribute_values" ("attributed_record_id", "attributed_record_type")!U-Kindexattribute_values_attributed_type_idxattribute_valuesCREATE INDEX "attribute_values_attributed_type_idx" ON "attribute_values" ("attribute_type_id")A-indexattribute_values_value_idxattribute_valuesCREATE INDEX "attribute_values_value_idx" ON "attribute_values" ("value")  {{%SecurityRole%SecurityRole%SecurityRole%SecurityRole%SecurityRole%SecurityRole%SecurityRole (n(DAAQueryquery2013-01-07 21:47:30.3071282013-01-07 21:47:30.307128DAAClassclass2013-01-07 21:47:30.3061262013-01-07 21:47:30.306126JAAInstanceinstance2013-01-07 21:47:30.3042842013-01-07 21:47:30.304284  query class instance             \ > E [[[[!!tableorder_txnsorder_txnN!!]tableorder_txnsorder_txnsCREATE TABLE "order_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state_machine" varchar(255), "description" varchar(255), "order_txn_type_id" integer, "email" varchar(255), "phone_number" varchar(255), "ship_to_first_name" varchar(255), "ship_to_last_name" varchar(255), "ship_to_address_line_1" varchar(255), "ship_to_address_line_2" varchar(255), "bill_to_address_line_1" varchar(255), "bill_to_address_line_2" varchar(255), "ship_to_city" varchar(255), "ship_to_state" varchar(255), "ship_to_postal_code" varchar(255), "ship_to_country" varchar(255), "customer_ip" varchar(255), "order_number" integer, "status" varchar(255), "error_message" varchar(255), "order_txn_record_id" integer, "order_txn_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "payment_gateway_txn_id" varchar(255), "credit_card_id" integer, "bill_to_first_name" varchar(255), "bill_to_last_name" varchar(255), "bill_to_city" varchar(255), "bill_to_state" varchar(255), "bill_to_postal_code" varchar(255), "bill_to_country" varchar(255))W!Aindexindex_order_txns_on_order_txn_type_idorder_txnsCREATE INDEX "index_order_txns_on_order_txn_type_id" ON "order_txns" ("order_txn_type_id")5!Uindexorder_txn_record_idxorder_txnsCREATE INDEX "order_txn_record_idx" ON "order_txns" ("order_txn_record_id", "order_txn_record_type") ++Stableorder_txn_typesorder_txn_typesCREATE TABLE "order_txn_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) Q+5indexindex_order_txn_types_on_parent_idorder_txn_typesCREATE INDEX "index_order_txn_types_on_parent_id" ON "order_txn_types" ("parent_id")G--?tableorder_line_itemsorder_line_itemsCREATE TABLE "order_line_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_txn_id" integer, "order_line_item_type_id" integer, "product_id" integer, "product_description" varchar(255), "product_instance_id" integer, "product_instance_description" varchar(255), "product_type_id" integer, "product_type_description" varchar(255), "sold_price" decimal(8,2), "sold_price_uom" integer, "sold_amount" integer, "sold_amount_uom" integer, "product_offer_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) Y-Eindexindex_order_line_items_on_order_txn_idorder_line_itemsCREATE INDEX "index_order_line_items_on_order_txn_id" ON "order_line_items" ("order_txn_id")Ao-qindexindex_order_line_items_on_order_line_item_type_idorder_line_itemsCREATE INDEX "index_order_line_items_on_order_line_item_type_id" ON "order_line_items" ("order_line_item_type_id")U-=indexindex_order_line_items_on_product_idorder_line_itemsCREATE INDEX "index_order_line_items_on_product_id" ON "order_line_items" ("product_id")5g-aindexindex_order_line_items_on_product_instance_idorder_line_itemsCREATE INDEX "index_order_line_items_on_product_instance_id" ON "order_line_items" ("product_instance_id"))_-Qindexindex_order_line_items_on_product_type_idorder_line_itemsCREATE INDEX "index_order_line_items_on_product_type_id" ON "order_line_items" ("product_type_id"),a-Uindexindex_order_line_items_on_product_offer_idorder_line_itemsCREATE INDEX "index_order_line_items_on_product_offer_id" ON "order_line_items" ("product_offer_id")!77_tableorder_line_item_typesorder_line_item_typesCREATE TABLE "order_line_item_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)             |fF  k5[#))Gtablebiz_txn_eventsbiz_txn_eventsCREATE TABLE "biz_txn_events" +]7Mindexindex_order_line_item_types_on_parent_idorder_line_item_typesCREATE INDEX "index_order_line_item_types_on_parent_id" ON "order_line_item_types" ("parent_id")j??atableorder_line_item_pty_rolesorder_line_item_pty_rolesCREATE TABLE "order_line_item_pty_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "descriptio+]7Mindexindex_order_line_item_types_on_parent_idorder_line_item_typesCREATE INDEX "index_order_line_item_types_on_parent_id" ON "order_line_item_types" ("parent_id")j??atableorder_line_item_pty_rolesorder_line_item_pty_rolesCREATE TABLE "order_line_item_pty_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "order_line_item_id" integer, "party_id" integer, "line_item_role_type_id" integer, "biz_txn_acct_root_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Vw?indexindex_order_line_item_pty_roles_on_order_line_item_idorder_line_item_pty_rolesCREATE INDEX "index_order_line_item_pty_roles_on_order_line_item_id" ON "order_line_item_pty_roles" ("order_line_item_id")8c?Yindexindex_order_line_item_pty_roles_on_party_idorder_line_item_pty_rolesCREATE INDEX "index_order_line_item_pty_roles_on_party_id" ON "order_line_item_pty_roles" ("party_id")b?indexindex_order_line_item_pty_roles_on_line_item_role_type_idorder_line_item_pty_rolesCREATE INDEX "index_order_line_item_pty_roles_on_line_item_role_type_id" ON "order_line_item_pty_roles" ("line_item_role_type_id")\{? indexindex_order_line_item_pty_roles_on_biz_txn_acct_root_idorder_line_item_pty_rolesCREATE INDEX "index_order_line_item_pty_roles_on_biz_txn_acct_root_id" ON "order_line_item_pty_roles" ("biz_txn_acct_root_id")55]tableline_item_role_typesline_item_role_typesCREATE TABLE "line_item_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)'[5Iindexindex_line_item_role_types_on_parent_idline_item_role_typesCREATE INDEX "index_line_item_role_types_on_parent_id" ON "line_item_role_types" ("parent_id")%%Atablecharge_linescharge_linesCREATE TABLE "charge_lines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sti_type" varchar(255), "money_id" integer, "description" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "charged_item_id" integer, "charged_item_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)-%Aindexcharged_item_idxcharge_linesCREATE INDEX "charged_item_idx" ON "charge_lines" ("charged_item_id", "charged_item_type"), ==itablecharge_line_payment_txnscharge_line_payment_txnsCREATE TABLE "charge_line_payment_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "charge_line_id" integer, "payment_txn_id" integer, "payment_txn_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)!+=Sindexpayment_txn_idxcharge_line_payment_txnsCREATE INDEX "payment_txn_idx" ON "charge_line_payment_txns" ("payment_txn_id", "payment_txn_type")F"m=mindexindex_charge_line_payment_txns_on_charge_line_idcharge_line_payment_txnsCREATE INDEX "index_charge_line_payment_txns_on_charge_line_id" ON "charge_line_payment_txns" ("charge_line_id")G#))Gtablebiz_txn_eventsbiz_txn_eventsCREATE TABLE "biz_txn_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "biz_txn_acct_root_id" integer, "biz_txn_type_id" integer, "entered_date" datetime, "post_date" datetime, "biz_txn_record_id" integer, "biz_txn_record_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                 ii=x%Y o < 2*0$e)]indexindex_biz_txn_events_on_biz_txn_acct_root_idbiz_txn_eventsCREATE INDEX "index_biz_txn_events_on_biz_txn_acct_root_id" ON "biz_txn_events" ("biz_txn_acct_root_id")!%[)Iindexindex_biz_txn_events_on_biz_txn_type_idbiz_txn_eventsCREATE INDEX "index_biz_txn_events_on_biz_txn_type_id"0$e)]indexindex_biz_txn_events_on_biz_txn_acct_root_idbiz_txn_eventsCREATE INDEX "index_biz_txn_events_on_biz_txn_acct_root_id" ON "biz_txn_events" ("biz_txn_acct_root_id")!%[)Iindexindex_biz_txn_events_on_biz_txn_type_idbiz_txn_eventsCREATE INDEX "index_biz_txn_events_on_biz_txn_type_id" ON "biz_txn_events" ("biz_txn_type_id")x&)9indexbtai_1biz_txn_eventsCREATE INDEX "btai_1" ON "biz_txn_events" ("biz_txn_record_id", "biz_txn_record_type"){'33tablebiz_txn_event_descsbiz_txn_event_descsCREATE TABLE "biz_txn_event_descs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_event_id" integer, "language_id" integer, "locale_id" integer, "priority" integer, "sequence" integer, "short_description" varchar(255), "long_description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)8(g3aindexindex_biz_txn_event_descs_on_biz_txn_event_idbiz_txn_event_descsCREATE INDEX "index_biz_txn_event_descs_on_biz_txn_event_id" ON "biz_txn_event_descs" ("biz_txn_event_id")))]3Mindexindex_biz_txn_event_descs_on_language_idbiz_txn_event_descsCREATE INDEX "index_biz_txn_event_descs_on_language_id" ON "biz_txn_event_descs" ("language_id")#*Y3Eindexindex_biz_txn_event_descs_on_locale_idbiz_txn_event_descsCREATE INDEX "index_biz_txn_event_descs_on_locale_id" ON "biz_txn_event_descs" ("locale_id") +''Otablebiz_txn_typesbiz_txn_typesCREATE TABLE "biz_txn_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),C'?indexbiz_txn_type_nested_set_idxbiz_txn_typesCREATE INDEX "biz_txn_type_nested_set_idx" ON "biz_txn_types" ("parent_id", "lft", "rgt")-77tablebiz_txn_relationshipsbiz_txn_relationshipsCREATE TABLE "biz_txn_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_rel_type_id" integer, "description" varchar(255), "txn_event_id_from" integer, "txn_event_id_to" integer, "status_type_id" integer, "from_date" date, "thru_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)I.q7uindexindex_biz_txn_relationships_on_biz_txn_rel_type_idbiz_txn_relationshipsCREATE INDEX "index_biz_txn_relationships_on_biz_txn_rel_type_id" ON "biz_txn_relationships" ("biz_txn_rel_type_id"):/g7aindexindex_biz_txn_relationships_on_status_type_idbiz_txn_relationshipsCREATE INDEX "index_biz_txn_relationships_on_status_type_id" ON "biz_txn_relationships" ("status_type_id")0//Wtablebiz_txn_rel_typesbiz_txn_rel_typesCREATE TABLE "biz_txn_rel_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)1U/=indexindex_biz_txn_rel_types_on_parent_idbiz_txn_rel_typesCREATE INDEX "index_biz_txn_rel_types_on_parent_id" ON "biz_txn_rel_types" ("parent_id")t2--tablebiz_txn_statusesbiz_txn_statusesCREATE TABLE "biz_txn_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "comments" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)R3''atablebiz_txn_tasksbiz_txn_tasksCREATE TABLE "biz_txn_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)    ` 3#AAPayment Transactionpayment_txn2013-01-07 21:47:30.2576742013-01-07 21:47:30.257674            9^8Z i G XMQ-411tablebiz_txn_task_typesbiz_txn_task_typesCREATE TABLE "biz_txn_task_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt"-411tablebiz_txn_task_typesbiz_txn_task_typesCREATE TABLE "biz_txn_task_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)5W1Aindexindex_biz_txn_task_types_on_parent_idbiz_txn_task_typesCREATE INDEX "index_biz_txn_task_types_on_parent_id" ON "biz_txn_task_types" ("parent_id")633atablebiz_txn_party_rolesbiz_txn_party_rolesCREATE TABLE "biz_txn_party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_event_id" integer, "party_id" integer, "biz_txn_party_role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)87g3aindexindex_biz_txn_party_roles_on_biz_txn_event_idbiz_txn_party_rolesCREATE INDEX "index_biz_txn_party_roles_on_biz_txn_event_id" ON "biz_txn_party_roles" ("biz_txn_event_id") 8W3Aindexindex_biz_txn_party_roles_on_party_idbiz_txn_party_rolesCREATE INDEX "index_biz_txn_party_roles_on_party_id" ON "biz_txn_party_roles" ("party_id")V9{3 indexindex_biz_txn_party_roles_on_biz_txn_party_role_type_idbiz_txn_party_rolesCREATE INDEX "index_biz_txn_party_roles_on_biz_txn_party_role_type_id" ON "biz_txn_party_roles" ("biz_txn_party_role_type_id")c:==Wtablebiz_txn_party_role_typesbiz_txn_party_role_typesCREATE TABLE "biz_txn_party_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), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)7;c=Yindexindex_biz_txn_party_role_types_on_parent_idbiz_txn_party_role_typesCREATE INDEX "index_biz_txn_party_role_types_on_parent_id" ON "biz_txn_party_role_types" ("parent_id") <11Atablebiz_txn_acct_rootsbiz_txn_acct_rootsCREATE TABLE "biz_txn_acct_roots" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "status" integer, "biz_txn_acct_id" integer, "biz_txn_acct_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|=19indexbtai_2biz_txn_acct_rootsCREATE INDEX "btai_2" ON "biz_txn_acct_roots" ("biz_txn_acct_id", "biz_txn_acct_type")Z>??Atablebiz_txn_acct_status_typesbiz_txn_acct_status_typesCREATE TABLE "biz_txn_acct_status_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?11Ytablebiz_txn_acct_typesbiz_txn_acct_typesCREATE TABLE "biz_txn_acct_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)@W1Aindexindex_biz_txn_acct_types_on_parent_idbiz_txn_acct_typesCREATE INDEX "index_biz_txn_acct_types_on_parent_id" ON "biz_txn_acct_types" ("parent_id")NA779tablebiz_txn_acct_statusesbiz_txn_acct_statusesCREATE TABLE "biz_txn_acct_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)$B99atablebiz_txn_acct_rel_typesbiz_txn_acct_rel_typesCREATE TABLE "biz_txn_acct_rel_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)    [[K AAPayorpayor2013-01-07 21:47:30.6768182013-01-07 21:47:30.676818V ##AAOrder Rolesorder_roles2013-01-07 21:47:30.6742472013-01-07 21:47:30.674247            88Ua M  5i/C_9Qindexindex_biz_txn_acct_rel_types_on_parent_idbiz_txn_acct_rel_typesCREATE INDEX "index_biz_txn_acct_rel_types_on_parent_id" ON "biz_txn_acct_rel_types" ("parent_id")#DAAOtablebiz_txn_/C_9Qindexindex_biz_txn_acct_rel_types_on_parent_idbiz_txn_acct_rel_typesCREATE INDEX "index_biz_txn_acct_rel_types_on_parent_id" ON "biz_txn_acct_rel_types" ("parent_id")#DAAOtablebiz_txn_acct_relationshipsbiz_txn_acct_relationshipsCREATE TABLE "biz_txn_acct_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_acct_rel_type_id" integer, "description" varchar(255), "biz_txn_acct_root_id_from" integer, "biz_txn_acct_root_id_to" integer, "status_type_id" integer, "from_date" date, "thru_date" date, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mEAindexindex_biz_txn_acct_relationships_on_biz_txn_acct_rel_type_idbiz_txn_acct_relationshipsCREATE INDEX "index_biz_txn_acct_relationships_on_biz_txn_acct_rel_type_id" ON "biz_txn_acct_relationships" ("biz_txn_acct_rel_type_id")NFqAuindexindex_biz_txn_acct_relationships_on_status_type_idbiz_txn_acct_relationshipsCREATE INDEX "index_biz_txn_acct_relationships_on_status_type_id" ON "biz_txn_acct_relationships" ("status_type_id")tG==ytablebiz_txn_acct_party_rolesbiz_txn_acct_party_rolesCREATE TABLE "biz_txn_acct_party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "biz_txn_acct_root_id" integer, "party_id" integer, "biz_txn_acct_pty_rtype_id" integer, "is_default_billing_acct_flag" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)XHy=indexindex_biz_txn_acct_party_roles_on_biz_txn_acct_root_idbiz_txn_acct_party_rolesCREATE INDEX "index_biz_txn_acct_party_roles_on_biz_txn_acct_root_id" ON "biz_txn_acct_party_roles" ("biz_txn_acct_root_id")4Ia=Uindexindex_biz_txn_acct_party_roles_on_party_idbiz_txn_acct_party_rolesCREATE INDEX "index_biz_txn_acct_party_roles_on_party_id" ON "biz_txn_acct_party_roles" ("party_id")hJ=indexindex_biz_txn_acct_party_roles_on_biz_txn_acct_pty_rtype_idbiz_txn_acct_party_rolesCREATE INDEX "index_biz_txn_acct_party_roles_on_biz_txn_acct_pty_rtype_id" ON "biz_txn_acct_party_roles" ("biz_txn_acct_pty_rtype_id")'K;;ctablebiz_txn_acct_pty_rtypesbiz_txn_acct_pty_rtypesCREATE TABLE "biz_txn_acct_pty_rtypes" ("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)3La;Uindexindex_biz_txn_acct_pty_rtypes_on_parent_idbiz_txn_acct_pty_rtypesCREATE INDEX "index_biz_txn_acct_pty_rtypes_on_parent_id" ON "biz_txn_acct_pty_rtypes" ("parent_id")gM11wtablebiz_acct_txn_tasksbiz_acct_txn_tasksCREATE TABLE "biz_acct_txn_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_task_id" integer, "biz_txn_account_id" integer, "description" varchar(255), "comments" varchar(255), "entered_date" datetime, "requested_date" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)1Nc1Yindexindex_biz_acct_txn_tasks_on_biz_txn_task_idbiz_acct_txn_tasksCREATE INDEX "index_biz_acct_txn_tasks_on_biz_txn_task_id" ON "biz_acct_txn_tasks" ("biz_txn_task_id"):Oi1eindexindex_biz_acct_txn_tasks_on_biz_txn_account_idbiz_acct_txn_tasksCREATE INDEX "index_biz_acct_txn_tasks_on_biz_txn_account_id" ON "biz_acct_txn_tasks" ("biz_txn_account_id")oPEE_tablebiz_txn_agreement_role_typesbiz_txn_agreement_role_typesCREATE TABLE "biz_txn_agreement_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), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)               d ^^eGQkEiindexindex_biz_txn_agreement_role_types_on_parent_idbiz_txn_agreement_role_typesCREATE INDEX "index_biz_txn_agreement_role_types_on_parent_id" ON "biz_txn_agreement_role_types" ("parent_id")UR;;?tablebiz_txn_agreement_rolesbiz_txn_agreement_rolesCREATE TABLE "biz_txn_agreement_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_event_id" integer, "biz_txn_event_type" varchar(255),GQkEiindexindex_biz_txn_agreement_role_types_on_parent_idbiz_txn_agreement_role_typesCREATE INDEX "index_biz_txn_agreement_role_types_on_parent_id" ON "biz_txn_agreement_role_types" ("parent_id")UR;;?tablebiz_txn_agreement_rolesbiz_txn_agreement_rolesCREATE TABLE "biz_txn_agreement_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "biz_txn_event_id" integer, "biz_txn_event_type" varchar(255), "agreement_id" integer, "biz_txn_agreement_role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)vm-mindexindex_preference_types_on_default_pref_option_idpreference_typesCREATE INDEX "index_preference_types_on_default_pref_option_id" ON "preference_types" ("default_pref_option_id")w11_tablepreference_optionspreference_options CREATE TABLE "preference_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)ExSSotablepreference_options_preference_typespreference_options_preference_types CREATE TABLE "preference_options_preference_types" ("preference_type_id" integer, "preference_option_id" integer)FySSqindexpref_opt_pref_type_pref_type_id_idxpreference_options_preference_types CREATE INDEX "pref_opt_pref_type_pref_type_id_idx" ON "preference_options_preference_types" ("preference_type_id")FzQSsindexpref_opt_pref_type_pref_opt_id_idxpreference_options_preference_types CREATE INDEX "pref_opt_pref_type_pref_opt_id_idx" ON "preference_options_preference_types" ("preference_option_id")x{99 tablevalid_preference_typesvalid_preference_types CREATE TABLE "valid_preference_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "preference_type_id" integer, "preferenced_record_id" integer, "preferenced_record_type" varchar(255))    F<AA 2013-01-07 21:47:32.3765182013-01-07 21:47:32.376518<AA 2013-01-07 21:47:32.3694582013-01-07 21:47:32.369458<AA2013-01-07 21:47:32.3644972013-01-07 21:47:32.364497<AA 2013-01-07 21:47:32.1339422013-01-07 21:47:32.133942<AA 2013-01-07 21:47:32.1130782013-01-07 21:47:32.113078<AA2013-01-07 21:47:32.0882102013-01-07 21:47:32.088210        2`11AADesktop Backgrounddesktop_background2013-01-07 21:47:31.5743602013-01-07 21:47:31.624090\--AADesktop Shortcutdesktop_shortcut2013-01-07 21:47:31.5774642013-01-07 21:47:31.617951R55AAAutolL#AAThemeextjs_theme 2013-01-07 21:47:31.5765142013-01-07 21:47:31.625635d55AAAutoload Applicationautoload_application2013-01-07 21:47:31.5786022013-01-07 21:47:31.621757#AAThemeextjs_theme2013-01-07 21:47:31.5765142013-01-07 21:47:31.576514a11AADesktop Backgrounddesktop_background2013-01-07 21:47:31.5743602013-01-07 21:47:31.574360   w R= |  ( n%35AAClifton Blueclifton_extjs_themeclifton:clifton-blue2013-01-07 21:47:32.7045702013-01-07 21:47:32.704570t)?1AATrueNorth Logotruenorth_logo_backgroundtruenorth_tech.png2013-01-07 21:47:31.6001632013-01-07 21:47:32.688276`-#AABlueblue_extjs_themeext-all.css2013-01-07 21:47:31.6064152013-01-07 21:47:31.606415r)39AAClifton Yellowclifton_extjs_themeclifton:clifton-yellow2013-01-07 21:47:32.7029892013-01-07 21:47:32.702989p '37AAClifton Greenclifton_extjs_themeclifton:clifton-green2013-01-07 21:47:32.7022012013-01-07 21:47:32.702201l +3+AAClifton Defaultclifton_extjs_themeclifton:clifton2013-01-07 21:47:32.7012482013-01-07 21:47:32.701248\ -'AABlueblue_extjs_themeextjs:ext-all2013-01-07 21:47:31.6064152013-01-07 21:47:32.700427a -1AAGraygray_extjs_themeextjs:ext-all-gray2013-01-07 21:47:31.6056362013-01-07 21:47:32.699362g 15AAAccessaccess_extjs_themeextjs:ext-all-access2013-01-07 21:47:31.6048492013-01-07 21:47:32.697921^;AABlueblue_desktop_backgroundblue.gif2013-01-07 21:47:31.6009472013-01-07 21:47:31.600947n%35AAClifton Pinkclifton_extjs_themeclifton:clifton-pink2013-01-07 21:47:32.7037702013-01-07 21:47:32.703770AAANonono2013-01-07 21:47:31.5993812013-01-07 21:47:31.599381DAAYesyesyes2013-01-07 21:47:31.5977272013-01-07 21:47:31.597727                    q\G2 #Application#Application#Application#Application#Application #Application #Application #Application %AppContainer %AppContainer%AppContainer%AppContainer%AppContainer%AppContainer#Application#Application#Application#Application 2f2K%AAAppContainer2013-01-07 21:47:32.3775102013-01-07 21:47:32.378398K%AAAppContainer2013-01-07 21:47:32.3704452013-01-07 21:47:32.371271K%AAAppContainer2013-01-07 21:47:32.3656522013-01-07 21:47:32.366576K%AAAppContainer2013-01-07 21:47:32.1351112013-01-07 21:47:32.135977K%AAAppContainer2013-01-07 21:47:32.1143732013-01-07 21:47:32.115331K%AAAppContainer2013-01-07 21:47:32.1064432013-01-07 21:47:32.109182    %AppContainer%AppContainer%AppContainer%AppContainer%AppContainer%AppContainer Zr-ZCAAMobile2013-01-07 21:47:32.3804332013-01-07 21:47:32.381402FAAOrganizer2013-01-07 21:47:32.3733512013-01-07 21:47:32.379164DAADesktop2013-01-07 21:47:32.3605102013-01-07 21:47:32.372009CAAMobile2013-01-07 21:47:32.1524252013-01-07 21:47:32.154133FAAOrganizer2013-01-07 21:47:32.1276682013-01-07 21:47:32.137044DAADesktop2013-01-07 21:47:32.0656592013-01-07 21:47:32.116380 44lg,Qb ] 9 L >Yfb' [5Iindexindex_applications_widg4|--tableuser_preferencesuser_preferencesCREATE TABLE "user_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "preference_id" 4|--tableuser_preferencesuser_preferencesCREATE TABLE "user_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "preference_id" integer, "preferenced_record_id" integer, "preferenced_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)}O-1indexindex_user_preferences_on_user_iduser_preferencesCREATE INDEX "index_user_preferences_on_user_id" ON "user_preferences" ("user_id")#~[-Iindexindex_user_preferences_on_preference_iduser_preferencesCREATE INDEX "index_user_preferences_on_preference_id" ON "user_preferences" ("preference_id");k-iindexindex_user_preferences_on_preferenced_record_iduser_preferencesCREATE INDEX "index_user_preferences_on_preferenced_record_id" ON "user_preferences" ("preferenced_record_id")Ao-qindexindex_user_preferences_on_preferenced_record_typeuser_preferencesCREATE INDEX "index_user_preferences_on_preferenced_record_type" ON "user_preferences" ("preferenced_record_type")!)){tableapp_containersapp_containersCREATE TABLE "app_containers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "description" varchar(255), "internal_identifier" varchar(255), "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) K))indexindex_app_containers_on_user_idapp_containersCREATE INDEX "index_app_containers_on_user_id" ON "app_containers" ("user_id")E)indexindex_app_containers_on_typeapp_containersCREATE INDEX "index_app_containers_on_type" ON "app_containers" ("type")x%%1tableapplicationsapplicationsCREATE TABLE "applications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "icon" varchar(255), "internal_identifier" varchar(255), "javascript_class_name" varchar(255), "shortcut_id" varchar(255), "base_url" varchar(255), "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%CCOtableapp_containers_applicationsapp_containers_applicationsCREATE TABLE "app_containers_applications" ("app_container_id" integer, "application_id" integer)RsCyindexindex_app_containers_applications_on_application_idapp_containers_applicationsCREATE INDEX "index_app_containers_applications_on_application_id" ON "app_containers_applications" ("application_id")XwCindexindex_app_containers_applications_on_app_container_idapp_containers_applicationsCREATE INDEX "index_app_containers_applications_on_app_container_id" ON "app_containers_applications" ("app_container_id")stablewidgetswidgetsCREATE TABLE "widgets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "icon" varchar(255), "xtype" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 553tableapplications_widgetsapplications_widgetsCREATE TABLE "applications_widgets" ("application_id" integer, "widget_id" integer)6 e5]indexindex_applications_widgets_on_application_idapplications_widgetsCREATE INDEX "index_applications_widgets_on_application_id" ON "applications_widgets" ("application_id")' [5Iindexindex_applications_widgets_on_widget_idapplications_widgetsCREATE INDEX "index_applications_widgets_on_widget_id" ON "applications_widgets" ("widget_id")> 33!tabletree_menu_node_defstree_menu_node_defsCREATE TABLE "tree_menu_node_defs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "node_type" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "menu_short_name" varchar(255), "menu_description" varchar(255), "text" varchar(255), "icon_url" varchar(255), "target_url" varchar(255), "resource_class" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   Mobile Organizer Desktop Mobile Organizer Desktop  @7 {  N 4 %%%k-1AAFile Managericon-foldersfile_managerCompass.ErpApp.Desktop.Applications.FileManagerfile_manager-winDesktopApplication2013-01-07 21:47:32.7820822013-01-07 21:47:32.782082C -%-q51AAAudit Log Viewericon-historyaudit_log_viewerCompass.ErpApp.Desktop.Applications.AuditLogVieweraudit_log_viewer-winDesktopApplication2013-01-07 21:47:32.7606172013-01-07 21:47:32.7606170 %-5AAOrdersicon-packageorder_managementCompass.ErpApp.Organizer.Applications.OrderManagement.BaseOrganizerApplication2013-01-07 21:47:32.6729642013-01-07 21:47:32.6729641 %'m/1AAOrdersicon-packageorder_managerCompass.ErpApp.Desktop.Applications.OrderManagerorder_manager-winDesktopApplication2013-01-07 21:47:32.6373762013-01-07 21:47:32.6373769 %+q31AAProductsicon-productproduct_managerCompass.ErpApp.Desktop.Applications.ProductManagerproduct_manager-winDesktopApplication2013-01-07 21:47:32.5978742013-01-07 21:47:32.597874b 5AACRMicon-usercrmOrganizerApplication2013-01-07 21:47:31.8217202013-01-07 21:47:31.821720" e%1AAScaffoldicon-datascaffoldCompass.ErpApp.Desktop.Applications.Scaffoldscaffold-winDesktopApplication2013-01-07 21:47:31.7891362013-01-07 21:47:31.789136= ++q31AAUser Managementicon-useruser_managementCompass.ErpApp.Desktop.Applications.UserManagementuser-management-winDesktopApplication2013-01-07 21:47:31.7630862013-01-07 21:47:31.763086    V n ] W  ??/AAPostal Address Managementpostal_address_managementicon-gridpostaladdressgrid2013-01-07 21:47:33.0067862013-01-07 21:47:33.006786==-AAEmail Address Managementemail_address_managementicon-gridemailaddressgrid2013-01-07 21:47:33.0049692013-01-07 21:47:33.004969u-;AAParty Managementparty_management_widgeticon-gridpartygrid2013-01-07 21:47:31.8003642013-01-07 21:47:31.800364==;;+AAPhone Number Managementphone_number_managementicon-gridphonenumbergrid2013-01-07 21:47:33.0028922013-01-07 21:47:33.002892 11MAAUser Personal Infouser_personal_infoicon-userusermanagement_personalinfopanel2013-01-07 21:47:31.7307482013-01-07 21:47:31.730748++QAARole Managementrole_managementicon-userusermanagement_rolemanagementpanel2013-01-07 21:47:31.7276072013-01-07 21:47:31.72760799UAAApplication Managementapplication_managementicon-usercontrolpanel_userapplicationmgtpanel2013-01-07 21:47:31.7242652013-01-07 21:47:31.724265p/)-AANotesshared_notes_gridicon-documentsshared_notesgrid2013-01-07 21:47:31.7189722013-01-07 21:47:31.718972                33 Ar.  [ # ]DA[wind.))tableconfigurationsconfigur# Y3Eindexindex_tree_menu_node_defs_on_parent_idtree_menu_node_defs CREATE INDEX "index_tree_menu_node_defs_on_parent_id" ON "tree_menu_node_defs" ("parent_# Y3Eindexindex_tree_menu_node_defs_on_parent_idtree_menu_node_defs CREATE INDEX "index_tree_menu_node_defs_on_parent_id" ON "tree_menu_node_defs" ("parent_id").))tableconfigurationsconfigurations!CREATE TABLE "configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "active" boolean, "is_template" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S)9indexindex_configurations_on_is_templateconfigurations"CREATE INDEX "index_configurations_on_is_template" ON "configurations" ("is_template")*55utablevalid_configurationsvalid_configurations#CREATE TABLE "valid_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "configured_item_id" integer, "configured_item_type" varchar(255), "configuration_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*=5mindexconfigured_item_poly_idxvalid_configurations%CREATE INDEX "configured_item_poly_idx" ON "valid_configurations" ("configured_item_id", "configured_item_type")<i5eindexindex_valid_configurations_on_configuration_idvalid_configurations&CREATE INDEX "index_valid_configurations_on_configuration_id" ON "valid_configurations" ("configuration_id")-33tableconfiguration_itemsconfiguration_items'CREATE TABLE "configuration_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "configuration_id" integer, "configuration_item_type_id" integer, "configuration_option_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)8g3aindexindex_configuration_items_on_configuration_idconfiguration_items(CREATE INDEX "index_configuration_items_on_configuration_id" ON "configuration_items" ("configuration_id")V{3 indexindex_configuration_items_on_configuration_item_type_idconfiguration_items)CREATE INDEX "index_configuration_items_on_configuration_item_type_id" ON "configuration_items" ("configuration_item_type_id")Mu3}indexindex_configuration_items_on_configuration_option_idconfiguration_items*CREATE INDEX "index_configuration_items_on_configuration_option_id" ON "configuration_items" ("configuration_option_id")%==[tableconfiguration_item_typesconfiguration_item_types+CREATE TABLE "configuration_item_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "internal_identifier" varchar(255), "allow_user_defined_options" boolean DEFAULT 'f', "is_multi_optional" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)U[[tableconfiguration_item_types_configurationsconfiguration_item_types_configurations,CREATE TABLE "configuration_item_types_configurations" ("configuration_item_type_id" integer, "configuration_id" integer)DA[windexconf_conf_type_id_item_idxconfiguration_item_types_configurations-CREATE INDEX "conf_conf_type_id_item_idx" ON "configuration_item_types_configurations" ("configuration_item_type_id")#[Eindexconf_id_idxconfiguration_item_types_configurations.CREATE INDEX "conf_id_idx" ON "configuration_item_types_configurations" ("configuration_id")]?[+indexconf_config_type_uniq_idxconfiguration_item_types_configurations/CREATE UNIQUE INDEX "conf_config_type_uniq_idx" ON "configuration_item_types_configurations" ("configuration_item_type_id", "configuration_id")X77Mtableconfiguration_optionsconfiguration_options0CREATE TABLE "configuration_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "value" varchar(255), "comment" text, "user_defined" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                CCkn= >  ?U7=indexindex_configuration_options_on_valueconfiguration_options1CREATE INDEX "index_configuration_options_on_value" ON "configuration_options" ("value")Iq7uindexindex_configuration_options_on_internal_identifierconfiguration_options2CREATE INDEX "index_configuration_options_on_internal_identifier" ON "configuration_options" ("internal_identifier")4c7Yindexindex_configuration_options_on_user_definedconfiguration_options3CREATE INDEX "index_configuration_options_on_user_defined" ON "configuration_options" ("user_defined") iiAtableconfiguration_item_types_configuration_optionsconfiguration_item_types_configuration_options5CREATE TABLE "configuration_item_types_configuration_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "configuration_item_type_id" integer, "configuration_option_id" integer, "is_default" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d!Siindexconf_item_type_conf_opt_id_item_idxconfiguration_item_types_configuration_options6CREATE INDEX "conf_item_type_conf_opt_id_item_idx" ON "configuration_item_types_configuration_options" ("configuration_item_type_id")_"Qiindexconf_item_type_conf_opt_id_opt_idxconfiguration_item_types_configuration_options7CREATE INDEX "conf_item_type_conf_opt_id_opt_idx" ON "configuration_item_types_configuration_options" ("configuration_option_id")]#__tableconfiguration_items_configuration_optionsconfiguration_items_configuration_options8CREATE TABLE "configuration_items_configuration_options" ("configuration_item_id" integer, "configuration_option_id" integer)K$I_yindexconf_item_conf_opt_id_item_idxconfiguration_items_configuration_options9CREATE INDEX "conf_item_conf_opt_id_item_idx" ON "configuration_items_configuration_options" ("configuration_item_id")K%G_{indexconf_item_conf_opt_id_opt_idxconfiguration_items_configuration_options:CREATE INDEX "conf_item_conf_opt_id_opt_idx" ON "configuration_items_configuration_options" ("configuration_option_id")&}tablefeesfees;CREATE TABLE "fees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "fee_record_id" integer, "fee_record_type" varchar(255), "money_id" integer, "fee_type_id" integer, "description" varchar(255), "start_date" datetime, "end_date" datetime, "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l')%indexfee_record_idxfeesCREATE INDEX "index_fees_on_money_id" ON "fees" ("money_id")}*Gtablefee_typesfee_types?CREATE TABLE "fee_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "comments" 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)U+77Gtableprice_component_typesprice_component_types@CREATE TABLE "price_component_types" ("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) ,''Wtablepricing_planspricing_plansACREATE TABLE "pricing_plans" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "from_date" date, "thru_date" date, "matching_rules" varchar(255), "pricing_calculation" varchar(255), "is_simple_amount" boolean, "currency_id" integer, "money_amount" decimal(8,2), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)               55cDhA 9 Q $  e `'5'tablepricespricesKCREATE TABLE "prices" ("id" INT:Q-*-;;itablepricing_plan_componentspricing_plan_componentsBCREATE TABLE "pricing_plan_components" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "price_component_type_id" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "matching_rules" varchar(255), "pricing_calculation" varchar(255), "is_simple_amount" boolean, "currency_id" integer, "money_amount" decimal(8,2), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)].}; indexindex_pricing_plan_components_on_price_component_type_idpricing_plan_componentsDCREATE INDEX*-;;itablepricing_plan_componentspricing_plan_componentsBCREATE TABLE "pricing_plan_components" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "price_component_type_id" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "matching_rules" varchar(255), "pricing_calculation" varchar(255), "is_simple_amount" boolean, "currency_id" integer, "money_amount" decimal(8,2), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)].}; indexindex_pricing_plan_components_on_price_component_type_idpricing_plan_componentsDCREATE INDEX "index_pricing_plan_components_on_price_component_type_id" ON "pricing_plan_components" ("price_component_type_id") /CCEtablevalid_price_plan_componentsvalid_price_plan_componentsECREATE TABLE "valid_price_plan_components" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pricing_plan_id" integer, "pricing_plan_component_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)U0uC}indexindex_valid_price_plan_components_on_pricing_plan_idvalid_price_plan_componentsFCREATE INDEX "index_valid_price_plan_components_on_pricing_plan_id" ON "valid_price_plan_components" ("pricing_plan_id")t1 C%indexindex_valid_price_plan_components_on_pricing_plan_component_idvalid_price_plan_componentsGCREATE INDEX "index_valid_price_plan_components_on_pricing_plan_component_id" ON "valid_price_plan_components" ("pricing_plan_component_id")G2==tablepricing_plan_assignmentspricing_plan_assignmentsHCREATE TABLE "pricing_plan_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pricing_plan_id" integer, "priceable_item_id" integer, "priceable_item_type" varchar(255), "priority" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)I3o=qindexindex_pricing_plan_assignments_on_pricing_plan_idpricing_plan_assignmentsICREATE INDEX "index_pricing_plan_assignments_on_pricing_plan_id" ON "pricing_plan_assignments" ("pricing_plan_id")$41=eindexpriceable_item_idxpricing_plan_assignmentsJCREATE INDEX "priceable_item_idx" ON "pricing_plan_assignments" ("priceable_item_id", "priceable_item_type")'5'tablepricespricesKCREATE TABLE "prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "priced_item_id" integer, "priced_item_type" varchar(255), "pricing_plan_id" integer, "money_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l6= indexindex_prices_on_money_idpricesLCREATE INDEX "index_prices_on_money_id" ON "prices" ("money_id")7K)indexindex_prices_on_pricing_plan_idpricesMCREATE INDEX "index_prices_on_pricing_plan_id" ON "prices" ("pricing_plan_id")t8+/indexpriced_item_idxpricesNCREATE INDEX "priced_item_idx" ON "prices" ("priced_item_id", "priced_item_type")m9-- tableprice_componentsprice_componentsOCREATE TABLE "price_components" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "pricing_plan_component_id" integer, "price_id" integer, "money_id" integer, "priced_component_id" integer, "priced_component_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                  5500  FvrTEKKtablecredit_card_account_party_rolescredit_card_account_pK77#tableaccepted_credit_cardsaccepted_credit_cardsbCREATE TABLE "accepted_credit_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "organization_id" integer, "card_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)\> tablepaymentspaymentsTCREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "success" boolean, "reference_number" varchar(255), "financial_txn_id" integer, "current_state" varchar(255), "authorization_code" varchar(255), "external_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ?Q5indexindex_payments_on_financial_txn_idpaymentsVCREATE INDEX "index_payments_on_financial_txn_id" ON "payments" ("financial_txn_id")*@--tablepayment_gatewayspayment_gatewaysWCREATE TABLE "payment_gateways" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "params" varchar(255), "payment_gateway_action_id" integer, "payment:Q-5indexindex_price_components_on_money_idprice_componentsPCREATE INDEX "index_price_components_on_money_id" ON "price_components" ("money_id")G;s-yindexindex_price_components_on_pricing_plan_component_idprice_componentsQCREATE INDEX "index_price_components_on_pricing_plan_component_id" ON "price_components" ("pricing_plan_component_id")<Q-5indexindex_price_components_on_price_idprice_componentsRCREATE INDEX "index_price_components_on_price_id" ON "price_components" ("price_id")=5-aindexpriced_component_idxprice_componentsSCREATE INDEX "priced_component_idx" ON "price_components" ("priced_component_id", "priced_component_type")\> tablepaymentspaymentsTCREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "success" boolean, "reference_number" varchar(255), "financial_txn_id" integer, "current_state" varchar(255), "authorization_code" varchar(255), "external_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ?Q5indexindex_payments_on_financial_txn_idpaymentsVCREATE INDEX "index_payments_on_financial_txn_id" ON "payments" ("financial_txn_id")*@--tablepayment_gatewayspayment_gatewaysWCREATE TABLE "payment_gateways" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "params" varchar(255), "payment_gateway_action_id" integer, "payment_id" integer, "response" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)A;;=tablepayment_gateway_actionspayment_gateway_actionsXCREATE TABLE "payment_gateway_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)QBu;}indexindex_payment_gateway_actions_on_internal_identifierpayment_gateway_actionsYCREATE INDEX "index_payment_gateway_actions_on_internal_identifier" ON "payment_gateway_actions" ("internal_identifier")zC%%5tablecredit_cardscredit_cardsZCREATE TABLE "credit_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "crypted_private_card_number" varchar(255), "expiration_month" integer, "expiration_year" integer, "description" varchar(255), "first_name_on_card" varchar(255), "last_name_on_card" varchar(255), "card_type" varchar(255), "postal_address_id" integer, "credit_card_account_purpose_id" integer, "credit_card_token" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)KD557tablecredit_card_accountscredit_card_accounts[CREATE TABLE "credit_card_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)TEKKtablecredit_card_account_party_rolescredit_card_account_party_roles\CREATE TABLE "credit_card_account_party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "credit_card_account_id" integer, "role_type_id" integer, "party_id" integer, "credit_card_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   htGGAAfull_reverse_of_authorizationFull Reverse Of Authorization2013-01-07 21:47:30.1544412013-01-07 21:47:30.154441LAAauthorizeAuthorize2013-01-07 21:47:30.1536582013-01-07 21:47:30.153658HAAcapturecapture2013-01-07 21:47:30.1460122013-01-07 21:47:30.146012 !Gfull_reverse_of_authorization authorize capture           ! M g U$bR++{tabledata_migrationsdata_migrationsgCREATE TABLE "data_migrations" ("version" varchar(255))O!!qtableorder_txnsorder_txnsCREATE TABLE "order_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state_machine" varchar(255), "description" varchar(255), "order_txn_type_id" integer, "email" varchar(255), "phone_number" varchar(255), "ship_to_first_name" varchar(255), "ship_to_last_name" varchar(255), "ship_to_address_line_1" varchar(255), "ship_to_address_line_2" varchar(255), "bill_to_address_line_1" varchar(255), "bill_to_address_line_2" varchar(255), "ship_to_city" varchar(255), "ship_to_state" varchar(255), "ship_to_postal_code" varchar(255), "ship_to_country_name" varchar(255), "customer_ip" varchar(255), "order_number" integer, "status" varchar(255), "error_message" varchar(255), "order_txn_record_id" integer, "order_txn_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "payment_gateway_txn_id" varchar(255), "credit_card_id" integer, "bill_to_first_name" varchar(255), "bill_to_last_name" varchar(255), "bill_to_city" varchar(255), "bill_to_state" varchar(255), "bill_to_postal_code" varchar(255), "bill_to_country_name" varchar(255), "bill_to_country" varchar(255), "ship_to_country" varchar(255))Q5!Uindexorder_txn_record_idxorder_txnsCREATE INDEX "order_txn_record_idx" ON "order_txns" ("order_txn_record_id", "order_txn_record_type")PW!Aindexindex_order_txns_on_order_txn_type_idorder_txnsCREATE INDEX "index_order_txns_on_order_txn_type_id" ON "order_txns" ("order_txn_type_id")NI'?indexbank_accounts_account_type_idxbank_accountsfCREATE INDEX "bank_accounts_account_type_idx" ON "bank_accounts" ("bank_account_type_id")DM''Etablebank_accountsbank_accountseCREATE TABLE "bank_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "routing_number" varchar(255), "crypted_private_account_number" varchar(255), "name_on_account" varchar(255), "bank_account_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)L113tablebank_account_typesbank_account_typescCREATE TABLE "bank_account_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)K77#tableaccepted_credit_cardsaccepted_credit_cardsbCREATE TABLE "accepted_credit_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "organization_id" integer, "card_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)6JEEmtablecredit_card_account_purposescredit_card_account_purposesaCREATE TABLE "credit_card_account_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)bI{K indexindex_credit_card_account_party_roles_on_credit_card_idcredit_card_account_party_roles`CREATE INDEX "index_credit_card_account_party_roles_on_credit_card_id" ON "credit_card_account_party_roles" ("credit_card_id")PHoKqindexindex_credit_card_account_party_roles_on_party_idcredit_card_account_party_roles_CREATE INDEX "index_credit_card_account_party_roles_on_party_id" ON "credit_card_account_party_roles" ("party_id")\GwKindexindex_credit_card_account_party_roles_on_role_type_idcredit_card_account_party_roles^CREATE INDEX "index_credit_card_account_party_roles_on_role_type_id" ON "credit_card_account_party_roles" ("role_type_id"){F K)indexindex_credit_card_account_party_roles_on_credit_card_account_idcredit_card_account_party_roles]CREATE INDEX "index_credit_card_account_party_roles_on_credit_card_account_id" ON "credit_card_account_party_roles" ("credit_card_account_id")   p^L:()20111111144706)20111108183740)20111108183739)20110913145838)20110817160743)20110816161238)20110802200222 )20110728201733 )20110728201732 )20110728201731 )20110728201730 )20110728201729)20110609150135)20110605231556)20110527160807)20110525001935)20110324010232)20110109173616)20101014142230)20101011152441 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.000000I9ASvalbard and Jan MayenSJSJMt2010-01-22 19:42:32.0000000HASurinameSRSURt2010-01-22 19:42:32.000000-GASudanSDSDNt2010-01-22 19:42:32.000000AF?ASaint Pierre and MiquelonPMSPMt2010-01-22 19:42:32.000000TEeASaint Helena, Ascension and Tristan da CunhaSHSHNt2010-01-22 19:42:32.0000001DASri LankaLKLKAt2010-01-22 19:42:32.000000-CASpainESESPt2010-01-22 19:42:32.000000TBeASouth Georgia and the South Sandwich IslandsGSSGSt2010-01-22 19:42:32.0000004A%ASouth AfricaZAZAFt2010-01-22 19:42:32.000000/@ASomaliaSOSOMt2010-01-22 19:42:32.0000007?+ASolomon IslandsSBSLBt2010-01-22 19:42:32.0000000>ASloveniaSISVNt2010-01-22 19:42:32.0000000=ASlovakiaSKSVKt2010-01-22 19:42:32.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.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 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^"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*YKorea, Democratic People's Republic ofp1Korea, Republic ofq Kuwaitr!Kyrgyzstans#KLao Peoples Democratic Republict 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 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 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:47:31.236064+PAQHAMHamburg2013-01-07 21:47:31.235315*OAQBREBremen2013-01-07 21:47:31.234508/N#AQBRGBrandenburg2013-01-07 21:47:31.233659*MAQBERBerlin2013-01-07 21:47:31.232900*LAQBAYBayern2013-01-07 21:47:31.2320998K5AQBAWBaden-Württemberg2013-01-07 21:47:31.2312981J'AQNDSNiedersachsen2013-01-07 21:47:31.2305342I+A&YTYukon Territory2013-01-07 21:47:31.229647/H%A&SKSaskatchewan2013-01-07 21:47:31.228675)GA&QCQuebec2013-01-07 21:47:31.2277407F5A&PEPrince Edward Island2013-01-07 21:47:31.226669*EA&ONOntario2013-01-07 21:47:31.225608*DA&NUNunavut2013-01-07 21:47:31.2245708C7A&NTNorthwest Territories2013-01-07 21:47:31.223481.B#A&NSNova Scotia2013-01-07 21:47:31.2222580A'A&NBNew Brunswick2013-01-07 21:47:31.221046/@%A&NFNewfoundland2013-01-07 21:47:31.219803+?A&MBManitoba2013-01-07 21:47:31.2181913>-A&BCBritish Columbia2013-01-07 21:47:31.196317*=A&ABAlberta2013-01-07 21:47:31.131652+<AWYWyoming2013-01-07 21:47:31.130449-;AWIWisconsin2013-01-07 21:47:31.1292071:'AWVWest Virginia2013-01-07 21:47:31.127967.9!AWAWashington2013-01-07 21:47:31.127186,8AVAVirginia2013-01-07 21:47:31.12639927)AVIVirgin Islands2013-01-07 21:47:31.125560+6AVTVermont2013-01-07 21:47:31.124769(5AUTUtah2013-01-07 21:47:31.123911)4ATXTexas2013-01-07 21:47:31.123106-3ATNTennessee2013-01-07 21:47:31.12229702%ASDSouth Dakota2013-01-07 21:47:31.12139621)ASCSouth Carolina2013-01-07 21:47:31.12025000%ARIRhode Island2013-01-07 21:47:31.119246//#APRPuerto Rico2013-01-07 21:47:31.1181510.%APAPennsylvania2013-01-07 21:47:31.117210)-APWPalau2013-01-07 21:47:31.116500*,AOROregon2013-01-07 21:47:31.115779,+AOKOklahoma2013-01-07 21:47:31.115061(*AOHOhio2013-01-07 21:47:31.114342<)=AMPNorthern Mariana Islands2013-01-07 21:47:31.1136200(%ANDNorth Dakota2013-01-07 21:47:31.1128912')ANCNorth Carolina2013-01-07 21:47:31.112171,&ANYNew York2013-01-07 21:47:31.111450.%!ANMNew Mexico2013-01-07 21:47:31.110730.$!ANJNew Jersey2013-01-07 21:47:31.1100121#'ANHNew Hampshire2013-01-07 21:47:31.109281*"ANVNevada2013-01-07 21:47:31.108537,!ANENebraska2013-01-07 21:47:31.107807+ AMTMontana2013-01-07 21:47:31.107085,AMOMissouri2013-01-07 21:47:31.106369/#AMSMississippi2013-01-07 21:47:31.105642-AMNMinnesota2013-01-07 21:47:31.104919,AMIMichigan2013-01-07 21:47:31.1041971'AMAMassachusetts2013-01-07 21:47:31.103468,AMDMaryland2013-01-07 21:47:31.1027294-AMHMarshall Islands2013-01-07 21:47:31.101990)AMEMaine2013-01-07 21:47:31.101265-ALALouisiana2013-01-07 21:47:31.100549,AKYKentucky2013-01-07 21:47:31.099828*AKSKansas2013-01-07 21:47:31.099101(AIAIowa2013-01-07 21:47:31.098312+AINIndiana2013-01-07 21:47:31.097423,AILIllinois2013-01-07 21:47:31.096693)AIDIdaho2013-01-07 21:47:31.095971*AHIHawaii2013-01-07 21:47:31.095242(AGUGuam2013-01-07 21:47:31.094503+AGAGeorgia2013-01-07 21:47:31.093778+ AFLFlorida2013-01-07 21:47:31.093055B IAFMFederated States Of Micronesia2013-01-07 21:47:31.0923268 5ADCDistrict of Columbia2013-01-07 21:47:31.091604, ADEDelaware2013-01-07 21:47:31.090877/ #ACTConnecticut2013-01-07 21:47:31.090152,ACOColorado2013-01-07 21:47:31.089393.!ACACalifornia2013-01-07 21:47:31.0886710%AAFArmed Forces2013-01-07 21:47:31.087849,AARArkansas2013-01-07 21:47:31.087123+AAZArizona2013-01-07 21:47:31.0864032)AASAmerican Samoa2013-01-07 21:47:31.085684*AAKAlaska2013-01-07 21:47:31.084957+AALAlabama2013-01-07 21:47:31.083166 OV(]4 j ;  M  R ( s D  V *}Q(](^)_(T#MP#c00 ANavarraNavarra2013-01-07 21:47:31.298288.AMurciaMurcia2013-01-07 21:47:31.2975420AMelillaMelilla2013-01-07 21:47:31.296799.AMalagaMalaga2013-01-07 21:47:31.296045.AMadridMadrid2013-01-07 21:47:31.295218*ALugoLugo2013-01-07 21:47:31.294487.ALleidaLleida2013-01-07 21:47:31.293742*ALeonLeon2013-01-07 21:47:31.2930066!!ALas PalmasLas Palmas2013-01-07 21:47:31.2922412ALa RiojaLa Rioja2013-01-07 21:47:31.291472*AJaenJaen2013-01-07 21:47:31.290604.AHuescaHuesca2013-01-07 21:47:31.289220.AHuelvaHuelva2013-01-07 21:47:31.2881174AGuipuzcoaGuipuzcoa2013-01-07 21:47:31.2872968##AGuadalajaraGuadalajara2013-01-07 21:47:31.2865260AGranadaGranada2013-01-07 21:47:31.285792.AGironaGirona2013-01-07 21:47:31.285014.ACuencaCuenca2013-01-07 21:47:31.2841950ACordobaCordoba2013-01-07 21:47:31.2833568 ##ACiudad RealCiudad Real2013-01-07 21:47:31.282583, ACeutaCeuta2013-01-07 21:47:31.2818324 ACastellonCastellon2013-01-07 21:47:31.2810704 ACantabriaCantabria2013-01-07 21:47:31.280317, ACadizCadiz2013-01-07 21:47:31.2795690ACaceresCaceres2013-01-07 21:47:31.278673.ABurgosBurgos2013-01-07 21:47:31.2778074ABarcelonaBarcelona2013-01-07 21:47:31.2768142ABalearesBaleares2013-01-07 21:47:31.2760320ABadajozBadajoz2013-01-07 21:47:31.275296,AAvilaAvila2013-01-07 21:47:31.2745612AAsturiasAsturias2013-01-07 21:47:31.2738250AAlmeriaAlmeria2013-01-07 21:47:31.2730882AAlicanteAlicante2013-01-07 21:47:31.2723482AAlbaceteAlbacete2013-01-07 21:47:31.271613,~AAlavaAlava2013-01-07 21:47:31.2708738}##AA CoruñaA Coruña2013-01-07 21:47:31.270132-|AZHZürich2013-01-07 21:47:31.269387'{AZGZug2013-01-07 21:47:31.268646*zAVSWallis2013-01-07 21:47:31.267906)yAVDWaadt2013-01-07 21:47:31.267159'xAURUri2013-01-07 21:47:31.266407*wATITessin2013-01-07 21:47:31.265566+vATGThurgau2013-01-07 21:47:31.264823*uASZSchwyz2013-01-07 21:47:31.264078-tASOSolothurn2013-01-07 21:47:31.2633310s%ASHSchaffhausen2013-01-07 21:47:31.262582.r!ASGSt. Gallen2013-01-07 21:47:31.261845,qAOWObwalden2013-01-07 21:47:31.261099-pANWNidwalden2013-01-07 21:47:31.260322-oANENeuenburg2013-01-07 21:47:31.259579*nALULuzern2013-01-07 21:47:31.258834(mAJUJura2013-01-07 21:47:31.2580971l'AJUGraubünden2013-01-07 21:47:31.257351*kAGLGlarus2013-01-07 21:47:31.256604(jAGEGenf2013-01-07 21:47:31.255859,iAFRFreiburg2013-01-07 21:47:31.255100/h#ABSBasel-Stadt2013-01-07 21:47:31.2543544g-ABLBasel-Landschaft2013-01-07 21:47:31.253606(fABEBern2013-01-07 21:47:31.252841:e9AARAppenzell Ausserrhoden2013-01-07 21:47:31.2520969d7AAIAppenzell Innerrhoden2013-01-07 21:47:31.251348*cAAGAargau2013-01-07 21:47:31.250602,bAVBVoralberg2013-01-07 21:47:31.249854-a!ABLBurgenland2013-01-07 21:47:31.249102(`ATITirol2013-01-07 21:47:31.248343-_!ASTSteiermark2013-01-07 21:47:31.247590-^!AKNKärnten2013-01-07 21:47:31.246828+]ASBSalzburg2013-01-07 21:47:31.2460134\/AOOOberösterreich2013-01-07 21:47:31.2451036[3ANONiederösterreich2013-01-07 21:47:31.243966'ZAWIWien2013-01-07 21:47:31.2429630Y%AQTHEThüringen2013-01-07 21:47:31.2421636X1AQSCNSchleswig-Holstein2013-01-07 21:47:31.2413512W)AQSACSachsen-Anhalt2013-01-07 21:47:31.240590+VAQSASSachsen2013-01-07 21:47:31.239843,UAQSARSaarland2013-01-07 21:47:31.2390983T+AQRHERheinland-Pfalz2013-01-07 21:47:31.2383467S3AQNRWNordrhein-Westfalen2013-01-07 21:47:31.237590:R9AQMECMecklenburg-Vorpommern2013-01-07 21:47:31.236807  _(qB t ;  20AZaragozaZaragoza2013-01-07 21:47:31.310294./AZamoraZamora2013-01-07 21:47:31.3095680.AVizcayaVizcaya2013-01-07 21:47:31.3088396-!!AValladolidValladolid2013-01-07 21:47:31.3081082,AValenciaValencia2013-01-07 21:47:31.307372.+AToledoToledo2013-01-07 21:47:31.306641.*ATeruelTeruel2013-01-07 21:47:31.3059134)ATarragonaTarragona2013-01-07 21:47:31.305189,(ASoriaSoria2013-01-07 21:47:31.3044640'ASevillaSevilla2013-01-07 21:47:31.3037330&ASegoviaSegovia2013-01-07 21:47:31.302976N%99ASanta Cruz de TenerifeSanta Cruz de Tenerife2013-01-07 21:47:31.3021864$ASalamancaSalamanca2013-01-07 21:47:31.3014036#!!APontevedraPontevedra2013-01-07 21:47:31.3005942"APalenciaPalencia2013-01-07 21:47:31.2998360!AOurenseOurense2013-01-07 21:47:31.299027