SQLite format 3@ LL- Co3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationships" ("relationship_type_id")7g3aindexindex_party_relationships_on_priority_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")1c3Yindexindex_party_relationships_on_status_type_idparty_relationshipsCREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id") 33?tableparty_relationshipsparty_relationshipsCREATE TABLE "party_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "party_id_from" integer, "party_id_to" integer, "role_type_id_from" integer, "role_type_id_to" integer, "status_type_id" integer, "priority_type_id" integer, "relationship_type_id" integer, "from_date" date, "thru_date" date, "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)B o1qindexindex_relationship_types_on_valid_to_role_type_idrelationship_typesCREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id")H s1yindexindex_relationship_types_on_valid_from_role_type_idrelationship_types CREATE INDEX "index_relationship_types_on_valid_from_role_type_id" ON "relationship_types" ("valid_from_role_type_id")W 11Ytablerelationship_typesrelationship_types CREATE TABLE "relationship_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "valid_from_role_type_id" integer, "valid_to_role_type_id" integer, "name" varchar(255), "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) !!Itablerole_typesrole_types CREATE TABLE "role_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) O#1indexindex_party_roles_on_role_type_idparty_roles CREATE INDEX "index_party_roles_on_role_type_id" ON "party_roles" ("role_type_id")G#!indexindex_party_roles_on_party_idparty_roles CREATE INDEX "index_party_roles_on_party_id" ON "party_roles" ("party_id")p##'tableparty_rolesparty_rolesCREATE TABLE "party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "party_id" integer, "role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i+indexbesi_1partiesCREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")D_tablepartiespartiesCREATE TABLE "parties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "business_party_id" integer, "business_party_type" varchar(255), "list_view_image_id" integer, "enterprise_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)b55gtablecompass_ae_instancescompass_ae_instancesCREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal(8,3), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationssp`ҁO@/ |hpX]FO2=%* (p^L:( )20100819181805 )20130107155533 )20130107155532 )20130107155531)20130107155530)20130107155529)20130107155528)20130107155527)20130107155526)20130107155525)20130107155524)20130107155523 {hUB/)20100819181805 )20130107155533 )20130107155532 )20130107155531 )20130107155530)20130107155529)20130107155528)20130107155527)20130107155526)20130107155525)20130107155524)20130107155523 AAA@2013-01-07 18:15:43.9201512013-01-07 18:15:43.920151 # ueO9!u_M3! g 3 #1relationship_types2"iconfiguration_item_types_configuration_options!7configuration_options =category_classifications=configuration_item_types)configurations!categories!role_types+audit_log_types5capability_accessorsb%capabilities05compass_ae_instances%delayed_jobs-user_preferences#preferences)app_containers users'organizations parties#individuals9valid_preference_types%applications widgets  !note_types 1preference_options -preference_types -contact_purposesgeo_zones'geo_countries'dynamic_forms3dynamic_form_models!currencies)security_roles #scope_types-capability_types SSS %AATrueNorthOrganization2013-01-07 18:15:42.7585792013-01-07 18:15:42.758579V )!AAAdmin IstratorIndividual2013-01-07 18:15:42.7345412013-01-07 18:15:42.734541 %Organization!Individual    Bc 7%AASecurity Group Membergroup_member2013-01-07 18:15:48.2909902013-01-07 18:15:48.290990U )AASecurity Groupgroup2013-01-07 18:15:48.2888782013-01-07 18:15:48.288878^ ))AAWebsite Memberwebsite_member2013-01-07 18:15:45.1520962013-01-07 18:15:45.152096\ ''AAWebsite Ownerwebsite_owner2013-01-07 18:15:45.1493282013-01-07 18:15:45.149328 -?-AAGroup MembershipSecurity Group Membershipgroup_membership2013-01-07 18:15:48.3098192013-01-07 18:15:48.309819       CAATrueNorth2013-01-07 18:15:42.7566782013-01-07 18:15:42.756678 "*   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 18:15:42.6540452013-01-07 18:15:42.654045        bn T b  h L AAOtherother2013-01-07 18:15:42.2147262013-01-07 18:15:42.214726R AAShippingshipping2013-01-07 18:15:42.2120382013-01-07 18:15:42.212038T AAEmergencyemergency2013-01-07 18:15:42.2090302013-01-07 18:15:42.209030N AAMobilemobile2013-01-07 18:15:42.2058522013-01-07 18:15:42.205852H AAFaxfax2013-01-07 18:15:42.2029482013-01-07 18:15:42.202948R AAPersonalpersonal2013-01-07 18:15:42.1997902013-01-07 18:15:42.199790R AABusinessbusiness2013-01-07 18:15:42.1975462013-01-07 18:15:42.197546b --AAEmployment Offeremployment_offer2013-01-07 18:15:42.1946952013-01-07 18:15:42.194695V !!AA Recruitingrecruiting2013-01-07 18:15:42.1910892013-01-07 18:15:42.191089\ ''AA Tax Reportingtax_reporting2013-01-07 18:15:42.1876892013-01-07 18:15:42.187689T AA Temporarytemporary2013-01-07 18:15:42.1848782013-01-07 18:15:42.184878P AABillingbilling2013-01-07 18:15:42.1819712013-01-07 18:15:42.181971J AAWorkwork2013-01-07 18:15:42.1797272013-01-07 18:15:42.179727J AAHomehome2013-01-07 18:15:42.1765942013-01-07 18:15:42.176594P AADefaultdefault2013-01-07 18:15:42.1700442013-01-07 18:15:42.170044             .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 18:15:40.6677912013-01-07 18:15:40.667791 USD ::d--AAContent Workflowcontent_workflow2013-01-07 18:15:47.8121942013-01-07 18:15:47.812194^''AAWebsite Setupwebsite_setup2013-01-07 18:15:45.1836072013-01-07 18:15:45.183607   PTR PT 7AAConfigurationItemType2013-01-07 18:15:47.8439372013-01-07 18:15:47.843937T 7AAConfigurationItemType2013-01-07 18:15:47.8355892013-01-07 18:15:47.835589T 7AAConfigurationItemType2013-01-07 18:15:47.8268342013-01-07 18:15:47.826834T 7AAConfigurationItemType2013-01-07 18:15:47.1753242013-01-07 18:15:47.175324T 7AAConfigurationItemType2013-01-07 18:15:46.3936172013-01-07 18:15:46.393617T 7AAConfigurationItemType2013-01-07 18:15:45.9884482013-01-07 18:15:45.988448T 7AAConfigurationItemType2013-01-07 18:15:45.9855182013-01-07 18:15:45.985518T 7AAConfigurationItemType2013-01-07 18:15:45.9798782013-01-07 18:15:45.979878  tX< 7ConfigurationItemType7ConfigurationItemType7ConfigurationItemType7ConfigurationItemType7ConfigurationItemType7ConfigurationItemType7ConfigurationItemType7ConfigurationItemType   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)  j9 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-2`MxlbTH9-!{pM7*  w [ N B 8 '   q [ O C 6   | p f X M ? 3 $    ~ p S J > 3 )    b W K ? 3  yodN>.sf[P?, }gYO>0$j_O4"bWH|p`>0&mYF"GHoly See (Vatican City State) Vanuatu!Uzbekistan Uruguay)UUnited States Minor Outlying Islands'United States)United Kingdom5United Arab Emirates Ukraine Uganda Tuvalu=Turks and Caicos Islands%Turkmenistan Turkey Tunisia3Trinidad and Tobago Tonga Tokelau Togo Thailand!ETanzania, United Republic of!Tajikistan Taiwan5Syrian Arab Republic#Switzerland SwedenSwaziland9Svalbard and Jan Mayen Suriname Sudan?Saint Pierre and Miquelon1eSaint Helena, Ascension and Tristan da CunhaSri Lanka Spain1eSouth Georgia and the South Sandwich Islands%South Africa Somalia+Solomon Islands Slovenia SlovakiaSingapore%Sierra Leone!Seychelles Senegal%Saudi Arabia7Sao Tome and Principe!San Marino Samoa%MSaint Vincent and the Grenadines#Saint Lucia7Saint Kitts and Nevis Rwanda1Russian Federation Romania Reunion Qatar#Puerto Rico Portugal Poland Pitcairn#Philippines Peru Paraguay-Papua New Guinea Panama Palau Pakistan Oman Norway=Northern Mariana Islands)Norfolk Island Niue Nigeria NigerNicaragua#New Zealand'New Caledonia#Netherlands Nepal Nauru Namibia Myanmar!Mozambique Morocco!Montserrat Mongolia Monaco5Moldova, Republic of$KMicronesia, Federated States of Mexico MayotteMauritius!Mauritania!Martinique-Marshall Islands Malta Mali Maldives Malaysia Malawi!Madagascar.aMacedonia, The Former Yugoslav Republic of~ Macao}!Luxembourg| Lithuania{'Liechtensteinz9Libyan Arab Jamahiriyay Liberiax Lesothow Lebanonv Latviau#KLao Peoples Democratic Republict!Kyrgyzstans Kuwaitr1Korea, Republic ofq*YKorea, Democratic People's Republic ofp Kiribatio Kenyan!Kazakhstanm Jordanl Japank Jamaicaj Italyi Israelh IrelandgIraqf=Iran, Islamic Republic oe Indonesiad Indiac Icelandb Hungarya Hong Kong` Honduras_CHeard and Mc Donald Islands^ Haiti] Guyana\'Guinea-bissau[ GuineaZ GuatemalaYGuamX!GuadeloupeW GrenadaV GreenlandU GreeceT GibraltarS GhanaR GermanyQ GeorgiaP GambiaO GabonNCFrench Southern TerritoriesM-French PolynesiaL'French GuianaK FranceI FinlandHFijiG'Faroe IslandsFCFalkland Islands (Malvinas)E EthiopiaD EstoniaC EritreaB/Equatorial GuineaA#El Salvador@ Egypt? Ecuador>1Dominican Republic< Dominica; Djibouti: Denmark9)Czech Republic8 Cyprus7Cuba6 Croatia5%Cote DIvoire4!Costa Rica3%Cook Islands2 Congo1 Comoros0 Colombia/;Cocos (Keeling) Islands.-Christmas Island- China, Chile+Chad*=Central African Republic))Cayman Islands(!Cape Verde' Canada& Cameroon% Cambodia$ Burundi#%Burkina Faso" Bulgaria!/Brunei Darussalam "IBritish Indian Ocean Territory Brazil'Bouvet Island Botswana9Bosnia and Herzegowina Bolivia Bhutan Bermuda Benin Belize Belgium Belarus Barbados!Bangladesh Bahrain Bahamas!Azerbaijan Austria Australia Aruba Armenia Argentina Antigua !Antarctica Anguilla Angola Andorra)American Samoa Algeria Al'Liechtensteinz   C{m _X J.Q5<tf  5x jqc\U2N E9 }+$ 5  @ n | u g R = 6  Y' D K ` / (  !      u % - % e u  ] U  m M } =  u ] m U E e M 5 = } e - %   ] = m M U G - E     %  u m ] U e } M = E 5 -BLPNRSTLPSMEJEIMGGCDAXMFZWZMYEEHWFVIVGVNVEVAVUUZUYUMUSGBAEUAUGTVTCTMTRTNTTTOTKTGTHTZTJTWSYCHSESZSJSRSDPMSHLKESGSZASOSBSISKSGSLSCSNSASTSMWSVCLCKNRWRUROREQAPRPTPLPNPHPEPYPGPAPWPKOMNOMPNFNUNGNENINZNCNLNPNRNAMMMZMAMSMNMCMDFMMXYTMUMRMQMHMTMLMVMYMWMGMK~MO}LU|LT{LIzLYyLRxLSwLBvLVuLAtKGsKWrKRqKPpKIoKEnKZmJOlJPkJMjITiILhIEgIQfIReIDdINcISbHUaHK`HN_HM^HT]GY\GW[GNZGTYGUXGPWGDVGLUGRTGISGHRDEQGEPGMOGANTFMPFLGFKFRIFIHFJGFOFFKEETDEECERBGQASV@EG?EC>DO<DM;DJ:DK9CZ8CY7CU6HR5CI4CR3CK2CG1KM0CO/CC.CX-CN,CL+TD*CF)KY(CV'CA&CM%KH$BI#BF"BG!BN IOBRBVBWBABOBTBMBJBZBEBYBBBDBHBSAZATAU AW AM AR AG AQAIAOADASDZALAFW) ~ Q ' u K  a 3 r D  Z *X.wFT*k8 {NU)`-j>*QAQHESHessen2013-01-07 18:15:41.864193+PAQHAMHamburg2013-01-07 18:15:41.862792*OAQBREBremen2013-01-07 18:15:41.861412/N#AQBRGBrandenburg2013-01-07 18:15:41.860002*MAQBERBerlin2013-01-07 18:15:41.858735*LAQBAYBayern2013-01-07 18:15:41.8578708K5AQBAWBaden-Württemberg2013-01-07 18:15:41.8569991J'AQNDSNiedersachsen2013-01-07 18:15:41.8557902I+A&YTYukon Territory2013-01-07 18:15:41.854571/H%A&SKSaskatchewan2013-01-07 18:15:41.853362)GA&QCQuebec2013-01-07 18:15:41.8521277F5A&PEPrince Edward Island2013-01-07 18:15:41.850912*EA&ONOntario2013-01-07 18:15:41.849703*DA&NUNunavut2013-01-07 18:15:41.8484288C7A&NTNorthwest Territories2013-01-07 18:15:41.846847.B#A&NSNova Scotia2013-01-07 18:15:41.8459890A'A&NBNew Brunswick2013-01-07 18:15:41.845087/@%A&NFNewfoundland2013-01-07 18:15:41.843681+?A&MBManitoba2013-01-07 18:15:41.8422823>-A&BCBritish Columbia2013-01-07 18:15:41.840851*=A&ABAlberta2013-01-07 18:15:41.839431+<AWYWyoming2013-01-07 18:15:41.838092-;AWIWisconsin2013-01-07 18:15:41.8368451:'AWVWest Virginia2013-01-07 18:15:41.835587.9!AWAWashington2013-01-07 18:15:41.834231,8AVAVirginia2013-01-07 18:15:41.83281227)AVIVirgin Islands2013-01-07 18:15:41.831386+6AVTVermont2013-01-07 18:15:41.829971(5AUTUtah2013-01-07 18:15:41.828571)4ATXTexas2013-01-07 18:15:41.827330-3ATNTennessee2013-01-07 18:15:41.82610802%ASDSouth Dakota2013-01-07 18:15:41.82489021)ASCSouth Carolina2013-01-07 18:15:41.82361700%ARIRhode Island2013-01-07 18:15:41.822355//#APRPuerto Rico2013-01-07 18:15:41.8211130.%APAPennsylvania2013-01-07 18:15:41.819873)-APWPalau2013-01-07 18:15:41.818476*,AOROregon2013-01-07 18:15:41.817143,+AOKOklahoma2013-01-07 18:15:41.816240(*AOHOhio2013-01-07 18:15:41.815362<)=AMPNorthern Mariana Islands2013-01-07 18:15:41.8144910(%ANDNorth Dakota2013-01-07 18:15:41.8136252')ANCNorth Carolina2013-01-07 18:15:41.812749,&ANYNew York2013-01-07 18:15:41.811881.%!ANMNew Mexico2013-01-07 18:15:41.810801.$!ANJNew Jersey2013-01-07 18:15:41.8092411#'ANHNew Hampshire2013-01-07 18:15:41.807670*"ANVNevada2013-01-07 18:15:41.806231,!ANENebraska2013-01-07 18:15:41.804898+ AMTMontana2013-01-07 18:15:41.803587,AMOMissouri2013-01-07 18:15:41.802288/#AMSMississippi2013-01-07 18:15:41.801000-AMNMinnesota2013-01-07 18:15:41.799697,AMIMichigan2013-01-07 18:15:41.7983431'AMAMassachusetts2013-01-07 18:15:41.797028,AMDMaryland2013-01-07 18:15:41.7957254-AMHMarshall Islands2013-01-07 18:15:41.794385)AMEMaine2013-01-07 18:15:41.792884-ALALouisiana2013-01-07 18:15:41.791511,AKYKentucky2013-01-07 18:15:41.790120*AKSKansas2013-01-07 18:15:41.788534(AIAIowa2013-01-07 18:15:41.787175+AINIndiana2013-01-07 18:15:41.785764,AILIllinois2013-01-07 18:15:41.784405)AIDIdaho2013-01-07 18:15:41.783095*AHIHawaii2013-01-07 18:15:41.781776(AGUGuam2013-01-07 18:15:41.780475+AGAGeorgia2013-01-07 18:15:41.779165+ AFLFlorida2013-01-07 18:15:41.777757B IAFMFederated States Of Micronesia2013-01-07 18:15:41.7763748 5ADCDistrict of Columbia2013-01-07 18:15:41.774975, ADEDelaware2013-01-07 18:15:41.773663/ #ACTConnecticut2013-01-07 18:15:41.772328,ACOColorado2013-01-07 18:15:41.770994.!ACACalifornia2013-01-07 18:15:41.7696580%AAFArmed Forces2013-01-07 18:15:41.768315,AARArkansas2013-01-07 18:15:41.766957+AAZArizona2013-01-07 18:15:41.7655482)AASAmerican Samoa2013-01-07 18:15:41.764146*AAKAlaska2013-01-07 18:15:41.762753+AALAlabama2013-01-07 18:1 Q % ~ xVPJD>82,&  } u m e ] U M E = 5 - %    } u m e ] U M E = 5 - % q j c \ U N G @ 9 2 + $      {tmf_XQJC<5.'  xqjc\~}|{zyxwvutsrqponmlkjihgfedcba`_^]\[ZQYQXQWQVQUQTQSQRQQQPQOQNQMQLQKQJ&I&H&G&F&E&D&C&B&A&@&?&>&=<;:9876543210/.-,+*)('&%$#"!           ti\ N? { k ` w 33& sZ7+    T Iwm { [_OE9/ p# j{ . n`PC7* b G Y T   7  w G   v e U  D  j '  v 1 8 Lg [   BO A1 $ %   Zaragoza Zamora Vizcaya!Valladolid Valencia Toledo TeruelTarragona Soria Sevilla Segovia9Santa Cruz de TenerifeSalamanca!Pontevedra Palencia Ourense Navarra Murcia Melilla Malaga Madrid Lugo Lleida Leon!Las Palmas La Rioja Jaen Huesca HuelvaGuipuzcoa#Guadalajara Granada Girona Cuenca Cordoba#Ciudad Real CeutaCastellonCantabria Cadiz Caceres BurgosBarcelona Baleares Badajoz Avila Asturias Almeria Alicante Albacete Alava~#A Coruña} Zürich|Zug{ Wallisz WaadtyUrix Tessinw Thurgauv Schwyzu Solothurnt%Schaffhausens!St. Gallenr Obwaldenq Nidwaldenp Neuenburgo LuzernnJuram'Graubündenl GlaruskGenfj Freiburgi#Basel-Stadth-Basel-LandschaftgBernf9Appenzell Ausserrhodene7Appenzell Innerrhodend Aargauc Voralbergb!Burgenlanda Tirol`!Steiermark_!Kärnten^ Salzburg]/Oberösterreich\3Niederösterreich[WienZ%ThüringenY1Schleswig-HolsteinX)Sachsen-AnhaltW SachsenV SaarlandU+Rheinland-PfalzT3Nordrhein-WestfalenS9Mecklenburg-VorpommernR HessenQ HamburgP BremenO#BrandenburgN BerlinM BayernL5Baden-WürttembergK'NiedersachsenJ+Yukon TerritoryI%SaskatchewanH QuebecG5Prince Edward IslandF OntarioE NunavutD7Northwest TerritoriesC#Nova ScotiaB'New BrunswickA%Newfoundland@ Manitoba?-British Columbia> Alberta= Wyoming< Wisconsin;'West Virginia:!Washington9 Virginia8)Virgin Islands7 Vermont6Utah5 Texas4 Tennessee3%South Dakota2)South Carolina1%Rhode Island0#Puerto Rico/%Pennsylvania. Palau- Oregon, Oklahoma+Ohio*=Northern Mariana Islands)%North Dakota()North Carolina' New York&!New Mexico%!New Jersey$'New Hampshire# Nevada" Nebraska! Montana Missouri#Mississippi Minnesota Michigan'Massachusetts Maryland-Marshall Islands Maine Louisiana Kentucky KansasIowa Indiana Illinois Idaho HawaiiGuam Georgia Florida "IFederated States Of Micronesia 5District of Columbia Delaware #Connecticut Colorado!California%Armed Forces Arkansas Arizona)American Samoa Alaska Alabama |U ; 4 - r e W J < 1 N & I   $       w f W  K ?t{ 5 ^mf_ '   CGJX Q<5'. 9  @  s 2+$   l    e   W  c V I > P  / #  x B   qc zj\ Zaragoza Zamora Vizcaya!Valladolid Valencia Toledo TeruelTarragona Soria Sevilla Segovia9Santa Cruz de TenerifeSalamanca!Pontevedra Palencia Ourense Navarra Murcia Melilla Malaga Madrid Lugo Lleida Leon!Las Palmas La Rioja Jaen Huesca HuelvaGuipuzcoa#Guadalajara Granada Girona Cuenca Cordoba#Ciudad Real CeutaCastellonCantabria Cadiz Caceres BurgosBarcelona Baleares Badajoz Avila Asturias Almeria Alicante Albacete Alava~#A Coruña}ZH|ZG{VSzVDyURxTIwTGvSZuSOtSHsSGrOWqNWpNEoLUnJUmJUlGLkGEjFRiBShBLgBEfAReAIdAGcVBbBLaTI`ST_KN^SB]OO\NO[WIZTHEYSCNXSACWSASVSARURHETNRWSMECRHESQHAMPBREOBRGNBERMBAYLBAWKNDSJYTISKHQCGPEFONENUDNTCNSBNBANF@MB?BC>AB=WY<WI;WV:WA9VA8VI7VT6UT5TX4TN3SD2SC1RI0PR/PA.PW-OR,OK+OH*MP)ND(NC'NY&NM%NJ$NH#NV"NE!MT MOMSMNMIMAMDMHMELAKYKSIAINILIDHIGUGAFL FM DC DE CT COCAAFARAZASAKAL     V !!AABasic Notebasic_note2013-01-07 18:15:42.3926322013-01-07 18:15:42.392632     s:sD35AAtruenorthtruenorth@gmail.comkhY7yv9uG2wLkinpdcsv$2a$10$H72R0e470tCqpzVtxlhGYODI/wctkSI9aTAUO3wj22bsEen3mcUeuactive2013-01-07 18:15:43.1120602013-01-07 18:15:43.262973C95AAadminadmin@portablemind.comfkxYJA2yqqH48TFqYrmB$2a$10$ZxNIjcz4XTjHtd7Juq8I4u3qX3zD0psWRx.CJb.3vAn6XvhQcKPXyactive2013-01-07 18:15:42.7975262013-01-07 18:15:43.094596 cc;  i Q T_GyKEindexindex_3>A-indexvalid_note_type_record_idxvalid_note_typesCCREATE INDEX "valid_note_type_record_idx" ON "valid_note_types" ("valid_note_type_record_id", "valid_note_type_record_type")?Y-Eindexindex_valid_note_types_on_note_type_idvalid_note_typesDCREATE INDEX "index_valid_note_types_on_note_type_id" ON "valid_note_types" ("note_type_id")}@YtableusersusersECREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "email" varchar(255), "party_id" integer, "type" varchar(255), "salt" varchar(255), "crypted_password" varchar(255), "last_login_at" datetime, "last_logout_at" datetime, "last_activity_at" datetime, "failed_logins_count" integer DEFAULT 0, "lock_expires_at" datetime, "remember_me_token" varchar(255), "remember_me_token_expires_at" datetime, "reset_password_token" varchar(255), "reset_password_token_expires_at" datetime, "reset_password_email_sent_at" datetime, "activation_state" varchar(255), "activation_token" varchar(255), "activation_token_expires_at" datetime, "security_question_1" varchar(255), "security_answer_1" varchar(255), "security_question_2" varchar(255), "security_answer_2" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)eA5 indexindex_users_on_emailusersGCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")nB;indexindex_users_on_usernameusersHCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")kC%'indexactivity_idxusersICREATE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")DM-indexindex_users_on_remember_me_tokenusersJCREATE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token") ES9indexindex_users_on_reset_password_tokenusersKCREATE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")FK)indexindex_users_on_activation_tokenusersLCREATE INDEX "index_users_on_activation_token" ON "users" ("activation_token") ]  | 1 P  o $ Cb6U t)Hg;ZyI5%AASecurityRole 2013-01-07 18:15:44.8142062013-01-07 18:15:44.814206I4%AASecurityRole 2013-01-07 18:15:44.8069992013-01-07 18:15:44.806999I3%AASecurityRole 2013-01-07 18:15:44.7998782013-01-07 18:15:44.799878I2%AASecurityRole 2013-01-07 18:15:44.7926482013-01-07 18:15:44.792648I1%AASecurityRole 2013-01-07 18:15:44.7853482013-01-07 18:15:44.785348I0%AASecurityRole 2013-01-07 18:15:44.7790392013-01-07 18:15:44.779039I/%AASecurityRole 2013-01-07 18:15:44.7727492013-01-07 18:15:44.772749I.%AASecurityRole 2013-01-07 18:15:44.7664522013-01-07 18:15:44.766452I-%AASecurityRole2013-01-07 18:15:44.7601312013-01-07 18:15:44.760131I,%AASecurityRole2013-01-07 18:15:44.7570122013-01-07 18:15:44.757012I+%AASecurityRole 2013-01-07 18:15:44.7538852013-01-07 18:15:44.753885I*%AASecurityRole 2013-01-07 18:15:44.7475712013-01-07 18:15:44.747571I)%AASecurityRole2013-01-07 18:15:44.7411492013-01-07 18:15:44.741149I(%AASecurityRole2013-01-07 18:15:44.7380702013-01-07 18:15:44.738070I'%AASecurityRole2013-01-07 18:15:44.7349212013-01-07 18:15:44.734921I&%AASecurityRole2013-01-07 18:15:44.7317872013-01-07 18:15:44.731787I%%AASecurityRole2013-01-07 18:15:44.7286862013-01-07 18:15:44.728686I$%AASecurityRole 2013-01-07 18:15:44.7254392013-01-07 18:15:44.725439I#%AASecurityRole 2013-01-07 18:15:44.7180492013-01-07 18:15:44.718049I"%AASecurityRole 2013-01-07 18:15:44.7104162013-01-07 18:15:44.710416I!%AASecurityRole 2013-01-07 18:15:44.7039682013-01-07 18:15:44.703968I %AASecurityRole 2013-01-07 18:15:44.6974232013-01-07 18:15:44.697423I%AASecurityRole2013-01-07 18:15:44.6908982013-01-07 18:15:44.690898I%AASecurityRole2013-01-07 18:15:44.6877352013-01-07 18:15:44.687735I%AASecurityRole2013-01-07 18:15:44.6845312013-01-07 18:15:44.684531I%AASecurityRole 2013-01-07 18:15:44.6813232013-01-07 18:15:44.681323I%AASecurityRole 2013-01-07 18:15:44.6747962013-01-07 18:15:44.674796I%AASecurityRole 2013-01-07 18:15:44.6681942013-01-07 18:15:44.668194I%AASecurityRole2013-01-07 18:15:44.6612982013-01-07 18:15:44.661298I%AASecurityRole 2013-01-07 18:15:44.6578682013-01-07 18:15:44.657868I%AASecurityRole 2013-01-07 18:15:44.5890442013-01-07 18:15:44.589044I%AASecurityRole 2013-01-07 18:15:44.5858872013-01-07 18:15:44.585887I%AASecurityRole 2013-01-07 18:15:44.5826072013-01-07 18:15:44.582607I%AASecurityRole 2013-01-07 18:15:44.5794392013-01-07 18:15:44.579439I%AASecurityRole 2013-01-07 18:15:44.5762482013-01-07 18:15:44.576248I%AASecurityRole 2013-01-07 18:15:44.5689882013-01-07 18:15:44.568988I%AASecurityRole 2013-01-07 18:15:44.5617002013-01-07 18:15:44.561700I%AASecurityRole 2013-01-07 18:15:44.5543502013-01-07 18:15:44.554350I%AASecurityRole 2013-01-07 18:15:44.5479182013-01-07 18:15:44.547918I%AASecurityRole 2013-01-07 18:15:44.5415142013-01-07 18:15:44.541514I %AASecurityRole2013-01-07 18:15:44.5348892013-01-07 18:15:44.534889I %AASecurityRole2013-01-07 18:15:44.5317002013-01-07 18:15:44.531700I %AASecurityRole2013-01-07 18:15:44.5283872013-01-07 18:15:44.528387I %AASecurityRole 2013-01-07 18:15:44.5251232013-01-07 18:15:44.525123I %AASecurityRole 2013-01-07 18:15:44.5173882013-01-07 18:15:44.517388I%AASecurityRole 2013-01-07 18:15:44.5107402013-01-07 18:15:44.510740I%AASecurityRole 2013-01-07 18:15:44.0844062013-01-07 18:15:44.084406I%AASecurityRole 2013-01-07 18:15:44.0779422013-01-07 18:15:44.077942I%AASecurityRole 2013-01-07 18:15:44.0746592013-01-07 18:15:44.074659I%AASecurityRole 2013-01-07 18:15:44.0664872013-01-07 18:15:44.066487I%AASecurityRole 2013-01-07 18:15:44.0622422013-01-07 18:15:44.062242I%AASecurityRole 2013-01-07 18:15:43.9912482013-01-07 18:15:43.991248I%AASecurityRole 2013-01-07 18:15:43.9821282013-01-07 18:15:43.95 ffgY<   G `^S%9indexindex_capabilities_on_scope_type_idcapabilitieseCREATE INDEX "index_capabilities_on_scope_type_id" ON "capabilities" ("scope_type_id")#_?%oindexcapability_resource_indexcapabilitiesfCREATE INDEX "capability_resource_index" ON "capabilities" ("capability_resource_id", "ca^S%9indexindex_capabilities_on_scope_type_idcapabilitieseCREATE INDEX "index_capabilities_on_scope_type_id" ON "capabilities" ("scope_type_id")#_?%oindexcapability_resource_indexcapabilitiesfCREATE INDEX "capability_resource_index" ON "capabilities" ("capability_resource_id", "capability_resource_type")<`55tablecapability_accessorscapability_accessorsgCREATE TABLE "capability_accessors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "capability_accessor_record_type" varchar(255), "capability_accessor_record_id" integer, "capability_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)2ac5Yindexindex_capability_accessors_on_capability_idcapability_accessorsiCREATE INDEX "index_capability_accessors_on_capability_id" ON "capability_accessors" ("capability_id")ObM5)indexcapability_accessor_record_indexcapability_accessorsjCREATE INDEX "capability_accessor_record_index" ON "capability_accessors" ("capability_accessor_record_id", "capability_accessor_record_type")oc##%tablescope_typesscope_typeskCREATE TABLE "scope_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) d]#Mindexindex_scope_types_on_internal_identifierscope_typeslCREATE INDEX "index_scope_types_on_internal_identifier" ON "scope_types" ("internal_identifier")e999tableparties_security_rolesparties_security_rolesmCREATE TABLE "parties_security_roles" ("party_id" integer, "security_role_id" integer)+f]9Mindexindex_parties_security_roles_on_party_idparties_security_rolesnCREATE INDEX "index_parties_security_roles_on_party_id" ON "parties_security_roles" ("party_id")Cgm9mindexindex_parties_security_roles_on_security_role_idparties_security_rolesoCREATE INDEX "index_parties_security_roles_on_security_role_id" ON "parties_security_roles" ("security_role_id")h++atableattribute_typesattribute_typespCREATE TABLE "attribute_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "data_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i=+5index:attribute_types_iid_idxattribute_typesqCREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")8j--#tableattribute_valuesattribute_valuesrCREATE TABLE "attribute_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attributed_record_id" integer, "attributed_record_type" varchar(255), "attribute_type_id" integer, "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)AkY- indexattribute_values_attributed_record_idxattribute_valuessCREATE INDEX "attribute_values_attributed_record_idx" ON "attribute_values" ("attributed_record_id", "attributed_record_type") lU-Kindexattribute_values_attributed_type_idxattribute_valuestCREATE INDEX "attribute_values_attributed_type_idx" ON "attribute_values" ("attribute_type_id")mA-indexattribute_values_value_idxattribute_valuesuCREATE INDEX "attribute_values_value_idx" ON "attribute_values" ("value")mn##!tablepreferencespreferencesvCREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "preference_option_id" integer, "preference_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)#o_#Qindexindex_preferences_on_preference_option_idpreferenceswCREATE INDEX "index_preferences_on_preference_option_id" ON "preferences" ("preference_option_id")p[#Iindexindex_preferences_on_preference_type_idpreferencesxCREATE INDEX "index_preferences_on_preference_type_id" ON "preferences" ("preference_type_id") b  |vpjdR^LXF@":4.( nhbz\tVPJD>82,&  0ba0`/_/^.]-\,[.Z-Y,X,W+V+U+T*S)R(Q*P)O(N(M'L'K'J&I&H%G$F#E"D!C%B$A#@"?!> =<;:9876 543210/.-,+*)('&%$#"!                 b8% y \ I / q^K A .    o ? , {hUB z g T p ] J 7 $  f S @ -  6 #  x e R % SecurityRoleb% SecurityRolea% SecurityRole`%SecurityRole_% SecurityRole^%SecurityRole]%SecurityRole\%SecurityRole[% SecurityRoleZ% SecurityRoleY% SecurityRoleX%SecurityRoleW%SecurityRoleV%SecurityRoleU% SecurityRoleT%SecurityRoleS%SecurityRoleR%SecurityRoleQ% SecurityRoleP% SecurityRoleO% SecurityRoleN%SecurityRoleM%SecurityRoleL%SecurityRoleK% SecurityRoleJ%SecurityRoleI% SecurityRoleH%SecurityRoleG%SecurityRoleF%SecurityRoleE%SecurityRoleD%SecurityRoleC% SecurityRoleB% SecurityRoleA% SecurityRole@% SecurityRole?% SecurityRole>%SecurityRole=%SecurityRole<%SecurityRole;%SecurityRole:%SecurityRole9%SecurityRole8%SecurityRole7%SecurityRole6% SecurityRole5% SecurityRole4% SecurityRole3% SecurityRole2% SecurityRole1% SecurityRole0% SecurityRole/% SecurityRole.%SecurityRole-%SecurityRole,% SecurityRole+% SecurityRole*%SecurityRole)%SecurityRole(%SecurityRole'%SecurityRole&%SecurityRole%% SecurityRole$% SecurityRole#% SecurityRole"% SecurityRole!% SecurityRole %SecurityRole%SecurityRole%SecurityRole% SecurityRole% SecurityRole% SecurityRole%SecurityRole%SecurityRole%SecurityRole%SecurityRole%SecurityRole%SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole%SecurityRole %SecurityRole %SecurityRole % SecurityRole % SecurityRole % SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole% SecurityRole (n(DAAQueryquery2013-01-07 18:15:40.3990652013-01-07 18:15:40.399065DAAClassclass2013-01-07 18:15:40.3978652013-01-07 18:15:40.397865JAAInstanceinstance2013-01-07 18:15:40.3954352013-01-07 18:15:40.395435  query class instance             F<AA 2013-01-07 18:15:43.1304822013-01-07 18:15:43.130482<AA 2013-01-07 18:15:43.1229572013-01-07 18:15:43.122957<AA2013-01-07 18:15:43.1176432013-01-07 18:15:43.117643<AA 2013-01-07 18:15:42.9438202013-01-07 18:15:42.943820<AA 2013-01-07 18:15:42.9225092013-01-07 18:15:42.922509<AA2013-01-07 18:15:42.8972132013-01-07 18:15:42.897213        2`11AADesktop Backgrounddesktop_background2013-01-07 18:15:42.3182362013-01-07 18:15:42.368619\--AADesktop Shortcutdesktop_shortcut2013-01-07 18:15:42.3217412013-01-07 18:15:42.362349R55AAAutolL#AAThemeextjs_theme 2013-01-07 18:15:42.3206282013-01-07 18:15:42.370400d55AAAutoload Applicationautoload_application2013-01-07 18:15:42.3227912013-01-07 18:15:42.366032#AAThemeextjs_theme2013-01-07 18:15:42.3206282013-01-07 18:15:42.320628a11AADesktop Backgrounddesktop_background2013-01-07 18:15:42.3182362013-01-07 18:15:42.318236   w R= |  ( n%35AAClifton Blueclifton_extjs_themeclifton:clifton-blue2013-01-07 18:15:43.3737352013-01-07 18:15:43.373735t)?1AATrueNorth Logotruenorth_logo_backgroundtruenorth_tech.png2013-01-07 18:15:42.3481142013-01-07 18:15:43.355444`-#AABlueblue_extjs_themeext-all.css2013-01-07 18:15:42.3551392013-01-07 18:15:42.355139r)39AAClifton Yellowclifton_extjs_themeclifton:clifton-yellow2013-01-07 18:15:43.3720602013-01-07 18:15:43.372060p '37AAClifton Greenclifton_extjs_themeclifton:clifton-green2013-01-07 18:15:43.3711972013-01-07 18:15:43.371197l +3+AAClifton Defaultclifton_extjs_themeclifton:clifton2013-01-07 18:15:43.3701592013-01-07 18:15:43.370159\ -'AABlueblue_extjs_themeextjs:ext-all2013-01-07 18:15:42.3551392013-01-07 18:15:43.369203a -1AAGraygray_extjs_themeextjs:ext-all-gray2013-01-07 18:15:42.3542702013-01-07 18:15:43.367794g 15AAAccessaccess_extjs_themeextjs:ext-all-access2013-01-07 18:15:42.3533932013-01-07 18:15:43.366153^;AABlueblue_desktop_backgroundblue.gif2013-01-07 18:15:42.3489922013-01-07 18:15:42.348992n%35AAClifton Pinkclifton_extjs_themeclifton:clifton-pink2013-01-07 18:15:43.3729052013-01-07 18:15:43.372905AAANonono2013-01-07 18:15:42.3472172013-01-07 18:15:42.347217DAAYesyesyes2013-01-07 18:15:42.3451332013-01-07 18:15:42.345133 ccFc* & X W*}!})s11_ta q--stablepreference_typespreference_typesyCREATE TABLE "preference_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "default_pref_option q--stablepreference_typespreference_typesyCREATE TABLE "preference_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "default_pref_option_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=rm-mindexindex_preference_types_on_default_pref_option_idpreference_typeszCREATE INDEX "index_preference_types_on_default_pref_option_id" ON "preference_types" ("default_pref_option_id")s11_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)DtSSotablepreference_options_preference_typespreference_options_preference_types}CREATE TABLE "preference_options_preference_types" ("preference_type_id" integer, "preference_option_id" integer)EuSSqindexpref_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")EvQSsindexpref_opt_pref_type_pref_opt_id_idxpreference_options_preference_typesCREATE INDEX "pref_opt_pref_type_pref_opt_id_idx" ON "preference_options_preference_types" ("preference_option_id")xw99 tablevalid_preference_typesvalid_preference_typesCREATE TABLE "valid_preference_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "preference_type_id" integer, "preferenced_record_id" integer, "preferenced_record_type" varchar(255))4x--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)yO-1indexindex_user_preferences_on_user_iduser_preferencesCREATE INDEX "index_user_preferences_on_user_id" ON "user_preferences" ("user_id")#z[-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")A|o-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)                    Bq\G2 ~jVB# Application# Application#Application#Application#Application#Application#Application#Application#Application #Application #Application #Application %AppContainer %AppContainer%AppContainer%AppContainer%AppContainer%AppContainer#Application#Application#Application#Application 2f2K%AAAppContainer2013-01-07 18:15:43.1315472013-01-07 18:15:43.132448K%AAAppContainer2013-01-07 18:15:43.1239862013-01-07 18:15:43.124844K%AAAppContainer2013-01-07 18:15:43.1188652013-01-07 18:15:43.119797K%AAAppContainer2013-01-07 18:15:42.9450342013-01-07 18:15:42.945976K%AAAppContainer2013-01-07 18:15:42.9239512013-01-07 18:15:42.924957K%AAAppContainer2013-01-07 18:15:42.9154092013-01-07 18:15:42.918222    %AppContainer%AppContainer%AppContainer%AppContainer%AppContainer%AppContainer Zr-ZCAAMobile2013-01-07 18:15:43.1345662013-01-07 18:15:43.135600FAAOrganizer2013-01-07 18:15:43.1270102013-01-07 18:15:43.133242DAADesktop2013-01-07 18:15:43.1136212013-01-07 18:15:43.125611CAAMobile2013-01-07 18:15:42.9622492013-01-07 18:15:42.964177FAAOrganizer2013-01-07 18:15:42.9376272013-01-07 18:15:42.947102DAADesktop2013-01-07 18:15:42.8166952013-01-07 18:15:42.926118   Mobile Organizer Desktop Mobile Organizer Desktop @7  Z u L 33y;1AASecurity Managementicon-keysecurity_managementCompass.ErpApp.Desktop.Applications.SecurityManagementsecurity_management-winDesktopApplication2013-01-07 18:15:48.7616822013-01-07 18:15:48.761682b ==E1AAConfiguration Managementicon-gridconfiguration_managementCompass.ErpApp.Desktop.Applications.ConfigurationManagementconfiguration_management-winDesktopApplication2013-01-07 18:15:47.7688772013-01-07 18:15:47.7688779 '''m/1AADynamic Formsicon-documentdynamic_formsCompass.ErpApp.Desktop.Applications.DynamicFormsdynamic_forms-winDesktopApplication2013-01-07 18:15:43.8934332013-01-07 18:15:43.8934334 %%%k-1AAFile Managericon-foldersfile_managerCompass.ErpApp.Desktop.Applications.FileManagerfile_manager-winDesktopApplication2013-01-07 18:15:43.8622022013-01-07 18:15:43.862202C -%-q51AAAudit Log Viewericon-historyaudit_log_viewerCompass.ErpApp.Desktop.Applications.AuditLogVieweraudit_log_viewer-winDesktopApplication2013-01-07 18:15:43.8362772013-01-07 18:15:43.836277! %c#1AAKnitKiticon-paletteknitkitCompass.ErpApp.Desktop.Applications.Knitkitknitkit-winDesktopApplication2013-01-07 18:15:43.8040222013-01-07 18:15:43.804022b 5AACRMicon-usercrmOrganizerApplication2013-01-07 18:15:42.6086362013-01-07 18:15:42.608636" e%1AAScaffoldicon-datascaffoldCompass.ErpApp.Desktop.Applications.Scaffoldscaffold-winDesktopApplication2013-01-07 18:15:42.5692152013-01-07 18:15:42.569215= ++q31AAUser Managementicon-useruser_managementCompass.ErpApp.Desktop.Applications.UserManagementuser-management-winDesktopApplication2013-01-07 18:15:42.5351702013-01-07 18:15:42.535170          V ln ] W l^ AAUser Infouserinfoicon-useruserinfo2013-01-07 18:15:47.1967202013-01-07 18:15:47.196720 ??/AAPostal Address Managementpostal_address_managementicon-gridpostaladdressgrid2013-01-07 18:15:44.3831702013-01-07 18:15:44.383170==-AAEmail Address Managementemail_address_managementicon-gridemailaddressgrid2013-01-07 18:15:44.3812052013-01-07 18:15:44.381205u-;AAParty Managementparty_management_widgeticon-gridpartygrid2013-01-07 18:15:42.5820712013-01-07 18:15:42.582071==;;+AAPhone Number Managementphone_number_managementicon-gridphonenumbergrid2013-01-07 18:15:44.3789812013-01-07 18:15:44.378981 11MAAUser Personal Infouser_personal_infoicon-userusermanagement_personalinfopanel2013-01-07 18:15:42.4335632013-01-07 18:15:42.433563++QAARole Managementrole_managementicon-userusermanagement_rolemanagementpanel2013-01-07 18:15:42.4290882013-01-07 18:15:42.42908899UAAApplication Managementapplication_managementicon-usercontrolpanel_userapplicationmgtpanel2013-01-07 18:15:42.4239352013-01-07 18:15:42.423935p/)-AANotesshared_notes_gridicon-documentsshared_notesgrid2013-01-07 18:15:42.4175132013-01-07 18:15:42.417513       dwi+  y 9j&/84Mu3}indexindex_configuration_items_on_configuration_option_idconfiguration_itemsCREATE INDEX "index_configuration_items_on_configuration_option_id" ON "configurRsCyindexindex_app_containers_applications_on_application_idapp_containers_applicationsCREATE INDEX "index_app_containers_applications_on_application_id" ON "app_containers_applications" ("applicationRsCyindexindex_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)6e5]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)# Y3Eindexindex_tree_menu_node_defs_on_parent_idtree_menu_node_defsCREATE INDEX "index_tree_menu_node_defs_on_parent_id" ON "tree_menu_node_defs" ("parent_id"). ))tableconfigurationsconfigurationsCREATE 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_templateconfigurationsCREATE INDEX "index_configurations_on_is_template" ON "configurations" ("is_template")* 55utablevalid_configurationsvalid_configurationsCREATE 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_configurationsCREATE INDEX "configured_item_poly_idx" ON "valid_configurations" ("configured_item_id", "configured_item_type")<i5eindexindex_valid_configurations_on_configuration_idvalid_configurationsCREATE INDEX "index_valid_configurations_on_configuration_id" ON "valid_configurations" ("configuration_id")-33tableconfiguration_itemsconfiguration_itemsCREATE 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_itemsCREATE INDEX "index_configuration_items_on_configuration_id" ON "configuration_items" ("configuration_id")V{3 indexindex_configuration_items_on_configuration_item_type_idconfiguration_itemsCREATE INDEX "index_configuration_items_on_configuration_item_type_id" ON "configuration_items" ("configuration_item_type_id")           wGGAADefault Website Configurationdefault_website_configurationt2013-01-07 18:15:45.1967502013-01-07 18:15:45.196750 t         Pz I _ ++AAPublish on savepublish_on_saveff2013-01-07 18:15:47.8376772013-01-07 18:15:47.837677s A=AAAuto activate publicationsauto_active_publicationsff2013-01-07 18:15:47.8292192013-01-07 18:15:47.829219_ ++AAEmail inquiriesemail_inquiriesff2013-01-07 18:15:47.8200742013-01-07 18:15:47.820074Y %%AAPrimary Hostprimary_hosttf2013-01-07 18:15:47.1735312013-01-07 18:15:47.173531i /;AAPassword Strengthpassword_strength_regexff2013-01-07 18:15:46.3922572013-01-07 18:15:46.392257i -=AAContact Us Emailcontact_us_email_addresstf2013-01-07 18:15:45.9873602013-01-07 18:15:45.987360Y %%AAHomepage Urlhomepage_urltf2013-01-07 18:15:45.9840922013-01-07 18:15:45.984092S AALogin Urllogin_urltf2013-01-07 18:15:45.6826642013-01-07 18:15:45.682664  W0y x E mP11JdSiinde%==[tableconfiguration_item_typesconfiguration_item_typesCREATE TABLE "configuration_item_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, Mu3}indexindex_configuration_items_on_configuration_option_idconfiguration_itemsCREATE INDEX "index_configuration_items_on_configuration_option_id" ON "configuration_items" ("configuration_option_idMu3}indexindex_configuration_items_on_configuration_option_idconfiguration_itemsCREATE INDEX "index_configuration_items_on_configuration_option_id" ON "configuration_items" ("configuration_option_id")%==[tableconfiguration_item_typesconfiguration_item_typesCREATE 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_configurationsCREATE TABLE "configuration_item_types_configurations" ("configuration_item_type_id" integer, "configuration_id" integer)DA[windexconf_conf_type_id_item_idxconfiguration_item_types_configurationsCREATE INDEX "conf_conf_type_id_item_idx" ON "configuration_item_types_configurations" ("configuration_item_type_id")#[Eindexconf_id_idxconfiguration_item_types_configurationsCREATE INDEX "conf_id_idx" ON "configuration_item_types_configurations" ("configuration_id")]?[+indexconf_config_type_uniq_idxconfiguration_item_types_configurationsCREATE UNIQUE INDEX "conf_config_type_uniq_idx" ON "configuration_item_types_configurations" ("configuration_item_type_id", "configuration_id")X77Mtableconfiguration_optionsconfiguration_optionsCREATE 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)U7=indexindex_configuration_options_on_valueconfiguration_optionsCREATE INDEX "index_configuration_options_on_value" ON "configuration_options" ("value")Iq7uindexindex_configuration_options_on_internal_identifierconfiguration_optionsCREATE INDEX "index_configuration_options_on_internal_identifier" ON "configuration_options" ("internal_identifier")4c7Yindexindex_configuration_options_on_user_definedconfiguration_optionsCREATE INDEX "index_configuration_options_on_user_defined" ON "configuration_options" ("user_defined")iiAtableconfiguration_item_types_configuration_optionsconfiguration_item_types_configuration_optionsCREATE 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)dSiindexconf_item_type_conf_opt_id_item_idxconfiguration_item_types_configuration_optionsCREATE 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_optionsCREATE INDEX "conf_item_type_conf_opt_id_opt_idx" ON "configuration_item_types_configuration_options" ("configuration_option_id")]__tableconfiguration_items_configuration_optionsconfiguration_items_configuration_optionsCREATE TABLE "configuration_items_configuration_options" ("configuration_item_id" integer, "configuration_option_id" integer)K I_yindexconf_item_conf_opt_id_item_idxconfiguration_items_configuration_optionsCREATE INDEX "conf_item_conf_opt_id_item_idx" ON "configuration_items_configuration_options" ("configuration_item_id")     \@ \D AANononof2013-01-07 18:15:47.8184332013-01-07 18:15:47.818433G AAYesyesyesf2013-01-07 18:15:47.8164332013-01-07 18:15:47.816433R -9 iAAComplex passwordcomplex_password_regex^.*(?=.{10,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[@#$%^&+=]).*$must be at least 10 characters, must contain at least one lower case letter, one upper case letter, one digit and one special character, valid special characters are @#$%^&+=f2013-01-07 18:15:46.3905842013-01-07 18:15:46.390584= +7=AASimple passwordsimple_password_regex^[A-Za-z]\w{6,}[A-Za-z]$must be at least 8 characters long and start and end with a letterf2013-01-07 18:15:46.3881732013-01-07 18:15:46.388173 noyesC ^.*(?=.{10,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[@#$%^&+=]).*$=^[A-Za-z]\w{6,}[A-Za-z]$ noyes9complex_password_regex7simple_password_regex ffff @@>AAt2013-01-07 18:15:47.8426782013-01-07 18:15:47.842678>AAf2013-01-07 18:15:47.8393492013-01-07 18:15:47.839349>AAt2013-01-07 18:15:47.8343442013-01-07 18:15:47.834344>AAf2013-01-07 18:15:47.8309642013-01-07 18:15:47.830964>AAt2013-01-07 18:15:47.8255342013-01-07 18:15:47.825534>AAf2013-01-07 18:15:47.8219502013-01-07 18:15:47.821950>AAt2013-01-07 18:15:46.7918292013-01-07 18:15:46.791829>AAf2013-01-07 18:15:46.7861262013-01-07 18:15:46.786126      MM AATicketfttprivate2013-01-07 18:15:48.2506112013-01-07 18:15:48.250611U )AAWebsiteInquiryfttprivate2013-01-07 18:15:40.7887792013-01-07 18:15:40.788779Z 3AADynamicFormDocumentfttprivate2013-01-07 18:15:40.7421682013-01-07 18:15:40.742168  ~ n W if95e4tablewebsiteswebsitesCREATE TABLE "websites" ("id" INTEGK!G_{indexconf_item_conf_opt_id_opt_idxconfiguration_items_configuration_optionsCREATE INDEX "conf_item_conf_opt_id_opt_idx" ON "configuration_items_configuration_options" ("configuration_option_id") "33?tabledynamic_form_modelsdynamic_form_modelsCREATE TABLE "dynamic_form_models" ("id" IK!G_{indexconf_item_conf_opt_id_opt_idxconfiguration_items_configuration_optionsCREATE INDEX "conf_item_conf_opt_id_opt_idx" ON "configuration_items_configuration_options" ("configuration_option_id") "33?tabledynamic_form_modelsdynamic_form_modelsCREATE TABLE "dynamic_form_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "model_name" varchar(255), "show_in_multitask" boolean DEFAULT 'f', "allow_comments" boolean DEFAULT 't', "allow_files" boolean DEFAULT 't', "file_security_default" varchar(255) DEFAULT 'private', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)#99'tabledynamic_form_documentsdynamic_form_documentsCREATE TABLE "dynamic_form_documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "dynamic_form_model_id" integer, "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S$w9indexindex_dynamic_form_documents_on_dynamic_form_model_iddynamic_form_documentsCREATE INDEX "index_dynamic_form_documents_on_dynamic_form_model_id" ON "dynamic_form_documents" ("dynamic_form_model_id") %U9=indexindex_dynamic_form_documents_on_typedynamic_form_documentsCREATE INDEX "index_dynamic_form_documents_on_type" ON "dynamic_form_documents" ("type")U&''gtabledynamic_formsdynamic_formsCREATE TABLE "dynamic_forms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "definition" text, "dynamic_form_model_id" integer, "model_name" varchar(255), "internal_identifier" varchar(255), "default" boolean, "widget_action" varchar(255) DEFAULT 'save', "widget_email_recipients" varchar(255), "focus_first_field" boolean DEFAULT 't', "submit_empty_text" boolean DEFAULT 'f', "msg_target" varchar(255) DEFAULT 'qtip', "submit_button_label" varchar(255) DEFAULT 'Submit', "cancel_button_label" varchar(255) DEFAULT 'Cancel', "comment" text, "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)'U'=indexindex_dynamic_forms_on_created_by_iddynamic_formsCREATE INDEX "index_dynamic_forms_on_created_by_id" ON "dynamic_forms" ("created_by_id")(U'=indexindex_dynamic_forms_on_updated_by_iddynamic_formsCREATE INDEX "index_dynamic_forms_on_updated_by_id" ON "dynamic_forms" ("updated_by_id")/)e']indexindex_dynamic_forms_on_dynamic_form_model_iddynamic_formsCREATE INDEX "index_dynamic_forms_on_dynamic_form_model_id" ON "dynamic_forms" ("dynamic_form_model_id")*O'1indexindex_dynamic_forms_on_model_namedynamic_formsCREATE INDEX "index_dynamic_forms_on_model_name" ON "dynamic_forms" ("model_name"))+a'Uindexindex_dynamic_forms_on_internal_identifierdynamic_formsCREATE INDEX "index_dynamic_forms_on_internal_identifier" ON "dynamic_forms" ("internal_identifier")w,%%/tabledynamic_datadynamic_dataCREATE TABLE "dynamic_data" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "reference_type" varchar(255), "reference_id" integer, "dynamic_attributes" text, "created_with_form_id" integer, "updated_with_form_id" integer, "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)(-a%Uindexindex_dynamic_data_on_created_with_form_iddynamic_dataCREATE INDEX "index_dynamic_data_on_created_with_form_id" ON "dynamic_data" ("created_with_form_id")(.a%Uindexindex_dynamic_data_on_updated_with_form_iddynamic_dataCREATE INDEX "index_dynamic_data_on_updated_with_form_id" ON "dynamic_data" ("updated_with_form_id")/S%9indexindex_dynamic_data_on_created_by_iddynamic_dataCREATE INDEX "index_dynamic_data_on_created_by_id" ON "dynamic_data" ("created_by_id")  S%g)%IAAContact Form[{"xtype":"textfield","fieldLabel":"First Name","name":"first_name","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true},{"xtype":"textfield","fieldLabel":"Last Name","name":"last_name","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true},{"xtype":"textfield","fieldLabel":"Email","name":"email","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true,"validator_function":"validateEmail(v)"},{"xtype":"textarea","fieldLabel":"Message","name":"message","value":null,"allowBlank":false,"readOnly":false,"width":400,"height":200,"labelWidth":75,"display_in_grid":true}]WebsiteInquirycontact-formtsavetfqtipSubmitCancelThis is the default form used by Knitkit's Contact Us Widget for Website Inquiries. NOTE: The Contact Us Widget uses Knitkit's website configuration options for email behavior & not the Dynamic Forms Widget Action setting.2013-01-07 18:15:41.0867322013-01-07 18:15:41.0     Ticket)WebsiteInquiry #ticket-form%contact-form           Lh D & YkkGFX==9tablewebsite_section_versionswebsite2Q%5indexindex_dynamic_data_on_reference_iddynamic_dataCREATE INDEX "index_dynamic_data_on_reference_id" ON "dynamic_data" ("reference_id")$3tableticketsticketsCREATE TABLE "tickets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)e4tablewebsiteswebsitesCREATE TABLE "websites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "subtitle" varchar(255), "internal_identifier" varchar(255), "email" varchar(255), "au0S%9indexindex_dynamic_data_on_updated_by_iddynamic_dataCREATE INDEX "index_dynamic_data_on_updated_by_id" ON "dyna0S%9indexindex_dynamic_data_on_updated_by_iddynamic_dataCREATE INDEX "index_dynamic_data_on_updated_by_id" ON "dynamic_data" ("updated_by_id")1U%=indexindex_dynamic_data_on_reference_typedynamic_dataCREATE INDEX "index_dynamic_data_on_reference_type" ON "dynamic_data" ("reference_type")2Q%5indexindex_dynamic_data_on_reference_iddynamic_dataCREATE INDEX "index_dynamic_data_on_reference_id" ON "dynamic_data" ("reference_id")$3tableticketsticketsCREATE TABLE "tickets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)itablewebsiteswebsitesCREATE TABLE "websites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "subtitle" varchar(255), "internal_identifier" varchar(255), "email" varchar(255), "auto_activate_publication" boolean, "email_inquiries" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)a5''tablewebsite_hostswebsite_hostsCREATE TABLE "website_hosts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "host" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)6O'1indexindex_website_hosts_on_website_idwebsite_hostsCREATE INDEX "index_website_hosts_on_website_id" ON "website_hosts" ("website_id")X7//]tablewebsite_inquirieswebsite_inquiriesCREATE TABLE "website_inquiries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)8W/Aindexindex_website_inquiries_on_website_idwebsite_inquiriesCREATE INDEX "index_website_inquiries_on_website_id" ON "website_inquiries" ("website_id")9--7tablewebsite_sectionswebsite_sectionsCREATE TABLE "website_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "type" varchar(255), "website_id" integer, "path" varchar(255), "permalink" varchar(255), "layout" text, "in_menu" boolean, "position" integer DEFAULT 0, "internal_identifier" varchar(255), "version" integer, "render_base_layout" boolean DEFAULT 't', "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL):S-9indexindex_website_sections_on_permalinkwebsite_sectionsCREATE INDEX "index_website_sections_on_permalink" ON "website_sections" ("permalink");U-=indexindex_website_sections_on_website_idwebsite_sectionsCREATE INDEX "index_website_sections_on_website_id" ON "website_sections" ("website_id")<Q-5indexindex_website_sections_on_positionwebsite_sectionsCREATE INDEX "index_website_sections_on_position" ON "website_sections" ("position")=S-9indexindex_website_sections_on_parent_idwebsite_sectionsCREATE INDEX "index_website_sections_on_parent_id" ON "website_sections" ("parent_id")>G-!indexindex_website_sections_on_lftwebsite_sectionsCREATE INDEX "index_website_sections_on_lft" ON "website_sections" ("lft")?G-!indexindex_website_sections_on_rgtwebsite_sectionsCREATE INDEX "index_website_sections_on_rgt" ON "website_sections" ("rgt")@O-1indexindex_website_sections_on_versionwebsite_sectionsCREATE INDEX "index_website_sections_on_version" ON "website_sections" ("version")                naS T 6 "lB<E"VY1Eindexindex_published_websites_on_websiyA+-%indexsection_iid_idxwebsite_sectionsCREATE INDEX "section_iid_idx" ON "website_sections" ("internal_identifier")B==tablewebsite_section_versionswebsite_section_versionsCREATE TABLE "website_section_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_section_id" integer, "version" integer, "title" varchar(255) DEFAULT NULL, "website_id" intyA+-%indexsection_iid_idxwebsite_sectionsCREATE INDEX "section_iid_idx" ON "website_sections" ("internal_identifier")B==tablewebsite_section_versionswebsite_section_versionsCREATE TABLE "website_section_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_section_id" integer, "version" integer, "title" varchar(255) DEFAULT NULL, "website_id" integer DEFAULT NULL, "path" varchar(255) DEFAULT NULL, "permalink" varchar(255) DEFAULT NULL, "layout" text DEFAULT NULL, "in_menu" boolean DEFAULT NULL, "position" integer DEFAULT 0, "internal_identifier" varchar(255) DEFAULT NULL, "render_base_layout" boolean DEFAULT 't', "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "versioned_type" varchar(255) DEFAULT NULL)RCu=}indexindex_website_section_versions_on_website_section_idwebsite_section_versionsCREATE INDEX "index_website_section_versions_on_website_section_id" ON "website_section_versions" ("website_section_id")D{tablecontentscontentsCREATE TABLE "contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "title" varchar(255), "permalink" varchar(255), "excerpt_html" text, "body_html" text, "created_by_id" integer, "updated_by_id" integer, "internal_identifier" varchar(255), "display_title" boolean, "version" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)hE9indexindex_contents_on_typecontentsCREATE INDEX "index_contents_on_type" ON "contents" ("type")FK)indexindex_contents_on_created_by_idcontentsCREATE INDEX "index_contents_on_created_by_id" ON "contents" ("created_by_id")GK)indexindex_contents_on_updated_by_idcontentsCREATE INDEX "index_contents_on_updated_by_id" ON "contents" ("updated_by_id")wHCindexindex_contents_on_permalinkcontentsCREATE INDEX "index_contents_on_permalink" ON "contents" ("permalink")qI?indexindex_contents_on_versioncontentsCREATE INDEX "index_contents_on_version" ON "contents" ("version")kJ-indexcontents_iid_idxcontentsCREATE INDEX "contents_iid_idx" ON "contents" ("internal_identifier")JK--Etablecontent_versionscontent_versionsCREATE TABLE "content_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content_id" integer, "version" integer, "title" varchar(255) DEFAULT NULL, "permalink" varchar(255) DEFAULT NULL, "excerpt_html" text DEFAULT NULL, "body_html" text DEFAULT NULL, "created_by_id" integer DEFAULT NULL, "updated_by_id" integer DEFAULT NULL, "internal_identifier" varchar(255) DEFAULT NULL, "display_title" boolean DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "versioned_type" varchar(255) DEFAULT NULL)LU-=indexindex_content_versions_on_content_idcontent_versionsCREATE INDEX "index_content_versions_on_content_id" ON "content_versions" ("content_id")FM==tablewebsite_section_contentswebsite_section_contentsCREATE TABLE "website_section_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_section_id" integer, "content_id" integer, "content_area" varchar(255), "position" integer DEFAULT 0, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)RNu=}indexindex_website_section_contents_on_website_section_idwebsite_section_contentsCREATE INDEX "index_website_section_contents_on_website_section_id" ON "website_section_contents" ("website_section_id"):Oe=]indexindex_website_section_contents_on_content_idwebsite_section_contentsCREATE INDEX "index_website_section_contents_on_content_id" ON "website_section_contents" ("content_id")                    ]]':}  8 G pdpRtaAindexindex_comments_on_approvedcommentsCREATE INc//]tablewebsite_nav_itemswebsite_nav_itemsJRmtablethemesthemesCREATE TABLE "themes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "name" varchar(255),JRmtablethemesthemesCREATE TABLE "themes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "name" varchar(255), "theme_id" varchar(255), "author" varchar(255), "version" integer, "homepage" varchar(255), "summary" text, "active" integ4Pa=Uindexindex_website_section_contents_on_positionwebsite_section_contentsCREATE INDEX "index_website_section_contents_on_position" ON "website_section_contents" ("position")@Qi=eindexindex_website_section_contents_on_content_areawebsite_section_contentsCREATE INDEX "index_website_section_contents_on_content_area" ON "website_section_contents" ("content_area")JRmtablethemesthemesCREATE TABLE "themes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "name" varchar(255), "theme_id" varchar(255), "author" varchar(255), "version" integer, "homepage" varchar(255), "summary" text, "active" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)rSAindexindex_themes_on_website_idthemesCREATE INDEX "index_themes_on_website_id" ON "themes" ("website_id")fT9indexindex_themes_on_activethemesCREATE INDEX "index_themes_on_active" ON "themes" ("active")1U11 tablepublished_websitespublished_websitesCREATE TABLE "published_websites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "comment" text, "version" decimal(18,6), "active" boolean, "published_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"VY1Eindexindex_published_websites_on_website_idpublished_websitesCREATE INDEX "index_published_websites_on_website_id" ON "published_websites" ("website_id")WS19indexindex_published_websites_on_versionpublished_websitesCREATE INDEX "index_published_websites_on_version" ON "published_websites" ("version")XQ15indexindex_published_websites_on_activepublished_websitesCREATE INDEX "index_published_websites_on_active" ON "published_websites" ("active")1Yc1Yindexindex_published_websites_on_published_by_idpublished_websitesCREATE INDEX "index_published_websites_on_published_by_id" ON "published_websites" ("published_by_id")hZ11ytablepublished_elementspublished_elementsCREATE TABLE "published_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "published_website_id" integer, "published_element_record_id" integer, "published_element_record_type" varchar(255), "version" integer, "published_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*[/1indexpublished_elm_idxpublished_elementsCREATE INDEX "published_elm_idx" ON "published_elements" ("published_element_record_id", "published_element_record_type")@\m1mindexindex_published_elements_on_published_website_idpublished_elementsCREATE INDEX "index_published_elements_on_published_website_id" ON "published_elements" ("published_website_id")]S19indexindex_published_elements_on_versionpublished_elementsCREATE INDEX "index_published_elements_on_version" ON "published_elements" ("version")1^c1Yindexindex_published_elements_on_published_by_idpublished_elementsCREATE INDEX "index_published_elements_on_published_by_id" ON "published_elements" ("published_by_id")p_1tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commentor_name" varchar(255), "email" varchar(255), "comment" text, "approved" integer, "approved_at" datetime, "user_id" integer, "commented_record_id" integer, "commented_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) `5Qindexcommented_record_idxcommentsCREATE INDEX "commented_record_idx" ON "comments" ("commented_record_id", "commented_record_type")               dt N z  w m /Z }yx))stabledocument_typesdocument_typesCREATE TABLE "document_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "external_identifier" varchar(255), "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)lw/indexdocument_type_idxdocumentsCREATE INDEX "document_type_idx" ON "documents" ("document_type_id")v=Windexdocument_record_poly_idxdocumentsCREATE INDEX "document_record_poly_idx" ON "documents" ("document_record_type", "document_record_id") d'/Mindexlinked_to_idxwebsite_nav_itemsCREATE INDEX "linked_to_idx" ON "website_nav_items" ("linked_to_item_id", "linked_to_item_type")*e_/Qindexindex_website_nav_items_on_website_nav_idwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_website_nav_id" ON "website_nav_items" ("website_nav_id")fS/9indexindex_website_nav_items_on_positionwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_position" ON "website_nav_items" ("position")gU/=indexindex_website_nav_items_on_parent_idwebsite_nav_itemsCREATE INDEX "index_website_nav_items_otaAindexindex_comments_on_approvedcommentsCREATE INDEX "index_comments_on_approved" ON "comments" ("approved")qb?indexindex_comments_on_user_idcommentsCREATE INDEX "index_comments_on_user_id" ON "comments" ("user_id")c//]tablewebsite_nav_itemswebsite_nav_itemsCREATE TABLE "website_nav_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_nav_id" integer, "title" varchar(255), "url" varchar(255), "position" integer DEFAULT 0, "linked_to_item_id" integer, "linked_to_item_type" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) d'/Mindexlinked_to_idxwebsite_nav_itemsCREATE INDEX "linked_to_idx" ON "website_nav_items" ("linked_to_item_id", "linked_to_item_type")*e_/Qindexindex_website_nav_items_on_website_nav_idwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_website_nav_id" ON "website_nav_items" ("website_nav_id")fS/9indexindex_website_nav_items_on_positionwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_position" ON "website_nav_items" ("position")gU/=indexindex_website_nav_items_on_parent_idwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_parent_id" ON "website_nav_items" ("parent_id") hI/%indexindex_website_nav_items_on_lftwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_lft" ON "website_nav_items" ("lft") iI/%indexindex_website_nav_items_on_rgtwebsite_nav_itemsCREATE INDEX "index_website_nav_items_on_rgt" ON "website_nav_items" ("rgt")^j%%}tablewebsite_navswebsite_navsCREATE TABLE "website_navs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) kM%-indexindex_website_navs_on_website_idwebsite_navsCREATE INDEX "index_website_navs_on_website_id" ON "website_navs" ("website_id")plAtabletagstagsCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))mmtabletaggingstaggingsCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "tagger_id" integer, "tagger_type" varchar(255), "taggable_type" varchar(255), "context" varchar(255), "created_at" datetime)nn= indexindex_taggings_on_tag_idtaggingsCREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")o/Aindextaggable_poly_idxtaggingsCREATE INDEX "taggable_poly_idx" ON "taggings" ("taggable_id", "taggable_type", "context") p339tablewebsite_party_roleswebsite_party_rolesCREATE TABLE "website_party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "website_id" integer, "role_type_id" integer, "party_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                     p- + V $pSotablewebsiteswebsitesCRE.%tablewebsitesweb}otablewebsiteswebsitesCREATE TABLE "websites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "subtitle" varchar(255), "internal_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)b|++{tabledata_migrationsdata_migrations CREATE TABLE "data_migrations" ("version" varchar(255))${?+iindexvalid_documents_model_idxvalid_documents CREATE INDEX "valid_documents_model_idx" ON "valid_documents" ("documented_model_id", "documented_model_type")zU+=indexindex_valid_documents_on_document_idvalid_documents CREATE INDEX "index_valid_documents_on_document_id" ON "valid_documents" ("document_id")&q[3Iindexindex_website_party_roles_on_website_idwebsite_party_rolesCREATE INDEX "index_website_party_roles_on_website_id" ON "website_party_roles" ("website_id"),r_3Qindexindex_website_party_roles_on_role_type_idwebsite_party_rolesCREATE INDEX "index_website_party_roles_on_role_type_id" ON "website_party_roles" ("role_type_id") sW3Aindexindex_website_party_roles_on_party_idwebsite_party_rolesCREATE INDEX "index_website_party_roles_on_party_id" ON "website_party_roles" ("party_id")'t--tabledocumented_itemsdocumented_itemsCREATE TABLE "documented_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "documented_klass" varchar(255), "documented_content_id" integer, "online_document_section_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"utabledocumentsdocumentsCREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "external_identifier" varchar(255), "internal_identifier" varchar(255), "description" varchar(255), "document_date" datetime, "dynamic_attributes" text, "document_record_id" integer, "document_record_type" varchar(255), "document_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v=Windexdocument_record_poly_idxdocumentsCREATE INDEX "document_record_poly_idx" ON "documents" ("document_record_type", "document_record_id")lw/indexdocument_type_idxdocumentsCREATE INDEX "document_type_idx" ON "documents" ("document_type_id")x))stabledocument_typesdocument_typesCREATE TABLE "document_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "external_identifier" varchar(255), "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Xy++etablevalid_documentsvalid_documents CREATE TABLE "valid_documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "document_id" integer, "documented_model_id" integer, "documented_model_type" varchar(255))   " p^L:(tbP>, ")20121218175028!)20121130212146 )20121130201859)20121129185611)20121116155018)20121026191738)20121026013449)20120824013449)20120809020508)20120418164215)20120411180756)20120405193721)20120316150424)20120229160222)20120127150506)20120127150505)20120127144444)20111118182910)20111111144706)20111108183740)20111108183739 )20110913145838 )20110828190913 )20110817160743 )20110816161238 )20110816153456)20110802200222)20110728201733)20110728201729)20110609150135)20110608185830)20110525001935)20110509223702)20110109173616 Ki1j9 s B  x F  T $ J  e /j6_0R#R$Y'VB |E CMCAFrench Southern TerritoriesTFATFt2010-01-22 19:42:25.0000008L-AFrench PolynesiaPFPYFt2010-01-22 19:42:25.0000005K'AFrench GuianaGFGUFt2010-01-22 19:42:25.000000.IAFranceFRFRAt2010-01-22 19:42:25.000000/HAFinlandFIFINt2010-01-22 19:42:25.000000,GAFijiFJFJIt2010-01-22 19:42:25.0000005F'AFaroe IslandsFOFROt2010-01-22 19:42:25.000000CECAFalkland Islands (Malvinas)FKFLKt2010-01-22 19:42:25.0000000DAEthiopiaETETHt2010-01-22 19:42:25.000000/CAEstoniaEEESTt2010-01-22 19:42:25.000000/BAEritreaERERIt2010-01-22 19:42:25.0000009A/AEquatorial GuineaGQGNQt2010-01-22 19:42:25.0000003@#AEl SalvadorSVSLVt2010-01-22 19:42:25.000000-?AEgyptEGEGYt2010-01-22 19:42:25.000000/>AEcuadorECECUt2010-01-22 19:42:25.000000:<1ADominican RepublicDODOMt2010-01-22 19:42:25.0000000;ADominicaDMDMAt2010-01-22 19:42:24.0000000:ADjiboutiDJDJIt2010-01-22 19:42:24.000000/9ADenmarkDKDNKt2010-01-22 19:42:24.00000068)ACzech RepublicCZCZEt2010-01-22 19:42:24.000000.7ACyprusCYCYPt2010-01-22 19:42:24.000000,6ACubaCUCUBt2010-01-22 19:42:24.000000/5ACroatiaHRHRVt2010-01-22 19:42:24.00000044%ACote DIvoireCICIVt2010-01-22 19:42:24.00000023!ACosta RicaCRCRIt2010-01-22 19:42:24.00000042%ACook IslandsCKCOKt2010-01-22 19:42:24.000000-1ACongoCGCOGt2010-01-22 19:42:24.000000/0AComorosKMCOMt2010-01-22 19:42:24.0000000/AColombiaCOCOLt2010-01-22 19:42:24.000000?.;ACocos (Keeling) IslandsCCCCKt2010-01-22 19:42:24.0000008--AChristmas IslandCXCXRt2010-01-22 19:42:24.000000-,AChinaCNCHNt2010-01-22 19:42:24.000000-+AChileCLCHLt2010-01-22 19:42:24.000000,*AChadTDTCDt2010-01-22 19:42:24.000000@)=ACentral African RepublicCFCAFt2010-01-22 19:42:24.0000006()ACayman IslandsKYCYMt2010-01-22 19:42:24.0000002'!ACape VerdeCVCPVt2010-01-22 19:42:24.000000.&ACanadaCACANt2010-01-22 19:42:24.0000000%ACameroonCMCMRt2010-01-22 19:42:23.0000000$ACambodiaKHKHMt2010-01-22 19:42:23.000000/#ABurundiBIBDIt2010-01-22 19:42:23.0000004"%ABurkina FasoBFBFAt2010-01-22 19:42:23.0000000!ABulgariaBGBGRt2010-01-22 19:42:23.0000009 /ABrunei DarussalamBNBRNt2010-01-22 19:42:23.000000FIABritish Indian Ocean TerritoryIOIOTt2010-01-22 19:42:23.000000.ABrazilBRBRAt2010-01-22 19:42:23.0000005'ABouvet IslandBVBVTt2010-01-22 19:42:23.0000000ABotswanaBWBWAt2010-01-22 19:42:23.000000>9ABosnia and HerzegowinaBABIHt2010-01-22 19:42:23.000000/ABoliviaBOBOLt2010-01-22 19:42:23.000000.ABhutanBTBTNt2010-01-22 19:42:23.000000/ABermudaBMBMUt2010-01-22 19:42:23.000000-ABeninBJBENt2010-01-22 19:42:23.000000.ABelizeBZBLZt2010-01-22 19:42:23.000000/ABelgiumBEBELt2010-01-22 19:42:23.000000/ABelarusBYBLRt2010-01-22 19:42:23.0000000ABarbadosBBBRBt2010-01-22 19:42:23.0000002!ABangladeshBDBGDt2010-01-22 19:42:23.000000/ABahrainBHBHRt2010-01-22 19:42:23.000000/ABahamasBSBHSt2010-01-22 19:42:23.0000002!AAzerbaijanAZAZEt2010-01-22 19:42:22.000000/AAustriaATAUTt2010-01-22 19:42:22.0000001 AAustraliaAUAUSt2010-01-22 19:42:22.000000- AArubaAWABWt2010-01-22 19:42:22.000000/ AArmeniaAMARMt2010-01-22 19:42:22.0000001 AArgentinaARARGt2010-01-22 19:42:22.000000/ AAntiguaAGATGt2010-01-22 19:42:22.0000002!AAntarcticaAQATAt2010-01-22 19:42:22.0000000AAnguillaAIAIAt2010-01-22 19:42:22.000000.AAngolaAOAGOt2010-01-22 19:42:22.000000/AAndorraADANDt2010-01-22 19:42:22.0000006)AAmerican SamoaASASMt2010-01-22 19:42:22.000000/AAlgeriaDZDZAt2010-01-22 19:42:22.000000/AAlbaniaALALBt2010-01-22 19:42:22.0000003#AAfghanistanAFAFGt2010-01-22 19:42:22.000000 Kp?zI M  w D  >  O [ k"_Rf3d/NvD{K3#ANew ZealandNZNZLt2010-01-22 19:42:30.0000005'ANew CaledoniaNCNCLt2010-01-22 19:42:30.0000003#ANetherlandsNLNLDt2010-01-22 19:42:30.000000-ANepalNPNPLt2010-01-22 19:42:30.000000-ANauruNRNRUt2010-01-22 19:42:30.000000/ANamibiaNANAMt2010-01-22 19:42:30.000000/AMyanmarMMMMRt2010-01-22 19:42:30.0000002!AMozambiqueMZMOZt2010-01-22 19:42:29.000000/AMoroccoMAMARt2010-01-22 19:42:29.0000002!AMontserratMSMSRt2010-01-22 19:42:29.0000000AMongoliaMNMNGt2010-01-22 19:42:29.000000. AMonacoMCMCOt2010-01-22 19:42:29.000000< 5AMoldova, Republic ofMDMDAt2010-01-22 19:42:29.000000G KAMicronesia, Federated States ofFMFSMt2010-01-22 19:42:29.000000. AMexicoMXMEXt2010-01-22 19:42:29.000000/ AMayotteYTMYTt2010-01-22 19:42:29.0000001AMauritiusMUMUSt2010-01-22 19:42:29.0000002!AMauritaniaMRMRTt2010-01-22 19:42:29.0000002!AMartiniqueMQMTQt2010-01-22 19:42:29.0000008-AMarshall IslandsMHMHLt2010-01-22 19:42:29.000000-AMaltaMTMLTt2010-01-22 19:42:29.000000,AMaliMLMLIt2010-01-22 19:42:29.0000000AMaldivesMVMDVt2010-01-22 19:42:29.0000000AMalaysiaMYMYSt2010-01-22 19:42:29.000000.AMalawiMWMWIt2010-01-22 19:42:29.0000002!AMadagascarMGMDGt2010-01-22 19:42:29.000000R~aAMacedonia, The Former Yugoslav Republic ofMKMKDt2010-01-22 19:42:29.000000-}AMacaoMOMACt2010-01-22 19:42:29.0000002|!ALuxembourgLULUXt2010-01-22 19:42:28.0000001{ALithuaniaLTLTUt2010-01-22 19:42:28.0000005z'ALiechtensteinLILIEt2010-01-22 19:42:28.000000>y9ALibyan Arab JamahiriyaLYLBYt2010-01-22 19:42:28.000000/xALiberiaLRLBRt2010-01-22 19:42:28.000000/wALesothoLSLSOt2010-01-22 19:42:28.000000/vALebanonLBLBNt2010-01-22 19:42:28.000000.uALatviaLVLVAt2010-01-22 19:42:28.000000GtKALao Peoples Democratic RepublicLALAOt2010-01-22 19:42:28.0000002s!AKyrgyzstanKGKGZt2010-01-22 19:42:28.000000.rAKuwaitKWKWTt2010-01-22 19:42:28.000000:q1AKorea, Republic ofKRKORt2010-01-22 19:42:28.000000NpYAKorea, Democratic People's Republic ofKPPRKt2010-01-22 19:42:28.0000000oAKiribatiKIKIRt2010-01-22 19:42:28.000000-nAKenyaKEKENt2010-01-22 19:42:28.0000002m!AKazakhstanKZKAZt2010-01-22 19:42:27.000000.lAJordanJOJORt2010-01-22 19:42:27.000000-kAJapanJPJPNt2010-01-22 19:42:27.000000/jAJamaicaJMJAMt2010-01-22 19:42:27.000000-iAItalyITITAt2010-01-22 19:42:27.000000.hAIsraelILISRt2010-01-22 19:42:27.000000/gAIrelandIEIRLt2010-01-22 19:42:27.000000,fAIraqIQIRQt2010-01-22 19:42:27.000000@e=AIran, Islamic Republic oIRIRNt2010-01-22 19:42:27.0000001dAIndonesiaIDIDNt2010-01-22 19:42:27.000000-cAIndiaININDt2010-01-22 19:42:27.000000/bAIcelandISISLt2010-01-22 19:42:26.000000/aAHungaryHUHUNt2010-01-22 19:42:26.0000001`AHong KongHKHKGt2010-01-22 19:42:26.0000000_AHondurasHNHNDt2010-01-22 19:42:26.000000C^CAHeard and Mc Donald IslandsHMHMDt2010-01-22 19:42:26.000000-]AHaitiHTHTIt2010-01-22 19:42:26.000000.\AGuyanaGYGUYt2010-01-22 19:42:26.0000005['AGuinea-bissauGWGNBt2010-01-22 19:42:26.000000.ZAGuineaGNGINt2010-01-22 19:42:26.0000001YAGuatemalaGTGTMt2010-01-22 19:42:26.000000,XAGuamGUGUMt2010-01-22 19:42:26.0000002W!AGuadeloupeGPGLPt2010-01-22 19:42:26.000000/VAGrenadaGDGRDt2010-01-22 19:42:26.0000001UAGreenlandGLGRLt2010-01-22 19:42:26.000000.TAGreeceGRGRCt2010-01-22 19:42:26.0000001SAGibraltarGIGIBt2010-01-22 19:42:26.000000-RAGhanaGHGHAt2010-01-22 19:42:26.000000/QAGermanyDEDEUt2010-01-22 19:42:25.000000/PAGeorgiaGEGEOt2010-01-22 19:42:25.000000.OAGambiaGMGMBt2010-01-22 19:42:25.000000-NAGabonGAGABt2010-01-22 19:42:25.000000 Gj;_, ] . a + Z ) h 8  Z %TZ*[+Rw0l.Q ~E L`UAUnited States Minor Outlying IslandsUMUMIt2010-01-22 19:42:33.0000005_'AUnited StatesUSUSAt2010-01-22 19:42:33.0000006^)AUnited KingdomGBGBRt2010-01-22 19:42:33.000000<]5AUnited Arab EmiratesAEAREt2010-01-22 19:42:33.000000/\AUkraineUAUKRt2010-01-22 19:42:33.000000.[AUgandaUGUGAt2010-01-22 19:42:33.000000.ZATuvaluTVTUVt2010-01-22 19:42:33.000000@Y=ATurks and Caicos IslandsTCTCAt2010-01-22 19:42:33.0000004X%ATurkmenistanTMTKMt2010-01-22 19:42:33.000000.WATurkeyTRTURt2010-01-22 19:42:33.000000/VATunisiaTNTUNt2010-01-22 19:42:33.000000;U3ATrinidad and TobagoTTTTOt2010-01-22 19:42:33.000000-TATongaTOTONt2010-01-22 19:42:33.000000/SATokelauTKTKLt2010-01-22 19:42:33.000000,RATogoTGTGOt2010-01-22 19:42:33.0000000QAThailandTHTHAt2010-01-22 19:42:32.000000DPEATanzania, United Republic ofTZTZAt2010-01-22 19:42:32.0000002O!ATajikistanTJTJKt2010-01-22 19:42:32.000000.NATaiwanTWTWNt2010-01-22 19:42:32.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 18:15:41.864193+PAQHAMHamburg2013-01-07 18:15:41.862792*OAQBREBremen2013-01-07 18:15:41.861412/N#AQBRGBrandenburg2013-01-07 18:15:41.860002*MAQBERBerlin2013-01-07 18:15:41.858735*LAQBAYBayern2013-01-07 18:15:41.8578708K5AQBAWBaden-Württemberg2013-01-07 18:15:41.8569991J'AQNDSNiedersachsen2013-01-07 18:15:41.8557902I+A&YTYukon Territory2013-01-07 18:15:41.854571/H%A&SKSaskatchewan2013-01-07 18:15:41.853362)GA&QCQuebec2013-01-07 18:15:41.8521277F5A&PEPrince Edward Island2013-01-07 18:15:41.850912*EA&ONOntario2013-01-07 18:15:41.849703*DA&NUNunavut2013-01-07 18:15:41.8484288C7A&NTNorthwest Territories2013-01-07 18:15:41.846847.B#A&NSNova Scotia2013-01-07 18:15:41.8459890A'A&NBNew Brunswick2013-01-07 18:15:41.845087/@%A&NFNewfoundland2013-01-07 18:15:41.843681+?A&MBManitoba2013-01-07 18:15:41.8422823>-A&BCBritish Columbia2013-01-07 18:15:41.840851*=A&ABAlberta2013-01-07 18:15:41.839431+<AWYWyoming2013-01-07 18:15:41.838092-;AWIWisconsin2013-01-07 18:15:41.8368451:'AWVWest Virginia2013-01-07 18:15:41.835587.9!AWAWashington2013-01-07 18:15:41.834231,8AVAVirginia2013-01-07 18:15:41.83281227)AVIVirgin Islands2013-01-07 18:15:41.831386+6AVTVermont2013-01-07 18:15:41.829971(5AUTUtah2013-01-07 18:15:41.828571)4ATXTexas2013-01-07 18:15:41.827330-3ATNTennessee2013-01-07 18:15:41.82610802%ASDSouth Dakota2013-01-07 18:15:41.82489021)ASCSouth Carolina2013-01-07 18:15:41.82361700%ARIRhode Island2013-01-07 18:15:41.822355//#APRPuerto Rico2013-01-07 18:15:41.8211130.%APAPennsylvania2013-01-07 18:15:41.819873)-APWPalau2013-01-07 18:15:41.818476*,AOROregon2013-01-07 18:15:41.817143,+AOKOklahoma2013-01-07 18:15:41.816240(*AOHOhio2013-01-07 18:15:41.815362<)=AMPNorthern Mariana Islands2013-01-07 18:15:41.8144910(%ANDNorth Dakota2013-01-07 18:15:41.8136252')ANCNorth Carolina2013-01-07 18:15:41.812749,&ANYNew York2013-01-07 18:15:41.811881.%!ANMNew Mexico2013-01-07 18:15:41.810801.$!ANJNew Jersey2013-01-07 18:15:41.8092411#'ANHNew Hampshire2013-01-07 18:15:41.807670*"ANVNevada2013-01-07 18:15:41.806231,!ANENebraska2013-01-07 18:15:41.804898+ AMTMontana2013-01-07 18:15:41.803587,AMOMissouri2013-01-07 18:15:41.802288/#AMSMississippi2013-01-07 18:15:41.801000-AMNMinnesota2013-01-07 18:15:41.799697,AMIMichigan2013-01-07 18:15:41.7983431'AMAMassachusetts2013-01-07 18:15:41.797028,AMDMaryland2013-01-07 18:15:41.7957254-AMHMarshall Islands2013-01-07 18:15:41.794385)AMEMaine2013-01-07 18:15:41.792884-ALALouisiana2013-01-07 18:15:41.791511,AKYKentucky2013-01-07 18:15:41.790120*AKSKansas2013-01-07 18:15:41.788534(AIAIowa2013-01-07 18:15:41.787175+AINIndiana2013-01-07 18:15:41.785764,AILIllinois2013-01-07 18:15:41.784405)AIDIdaho2013-01-07 18:15:41.783095*AHIHawaii2013-01-07 18:15:41.781776(AGUGuam2013-01-07 18:15:41.780475+AGAGeorgia2013-01-07 18:15:41.779165+ AFLFlorida2013-01-07 18:15:41.777757B IAFMFederated States Of Micronesia2013-01-07 18:15:41.7763748 5ADCDistrict of Columbia2013-01-07 18:15:41.774975, ADEDelaware2013-01-07 18:15:41.773663/ #ACTConnecticut2013-01-07 18:15:41.772328,ACOColorado2013-01-07 18:15:41.770994.!ACACalifornia2013-01-07 18:15:41.7696580%AAFArmed Forces2013-01-07 18:15:41.768315,AARArkansas2013-01-07 18:15:41.766957+AAZArizona2013-01-07 18:15:41.7655482)AASAmerican Samoa2013-01-07 18:15:41.764146*AAKAlaska2013-01-07 18:15:41.762753+AALAlabama2013-01-07 18:15:41.759888 OV(]4 j ;  M  R ( s D  V *}Q(](^)_(T#MP#c00 ANavarraNavarra2013-01-07 18:15:42.037715.AMurciaMurcia2013-01-07 18:15:42.0362920AMelillaMelilla2013-01-07 18:15:42.035044.AMalagaMalaga2013-01-07 18:15:42.033611.AMadridMadrid2013-01-07 18:15:42.032207*ALugoLugo2013-01-07 18:15:42.030781.ALleidaLleida2013-01-07 18:15:42.029361*ALeonLeon2013-01-07 18:15:42.0279346!!ALas PalmasLas Palmas2013-01-07 18:15:42.0265312ALa RiojaLa Rioja2013-01-07 18:15:42.025292*AJaenJaen2013-01-07 18:15:42.024428.AHuescaHuesca2013-01-07 18:15:42.023567.AHuelvaHuelva2013-01-07 18:15:42.0226514AGuipuzcoaGuipuzcoa2013-01-07 18:15:42.0217868##AGuadalajaraGuadalajara2013-01-07 18:15:42.0209200AGranadaGranada2013-01-07 18:15:42.020058.AGironaGirona2013-01-07 18:15:42.019181.ACuencaCuenca2013-01-07 18:15:42.0179710ACordobaCordoba2013-01-07 18:15:42.0167318 ##ACiudad RealCiudad Real2013-01-07 18:15:42.015484, ACeutaCeuta2013-01-07 18:15:42.0142344 ACastellonCastellon2013-01-07 18:15:42.0129994 ACantabriaCantabria2013-01-07 18:15:42.012009, ACadizCadiz2013-01-07 18:15:42.0111340ACaceresCaceres2013-01-07 18:15:42.010261.ABurgosBurgos2013-01-07 18:15:42.0093874ABarcelonaBarcelona2013-01-07 18:15:42.0082412ABalearesBaleares2013-01-07 18:15:42.0069540ABadajozBadajoz2013-01-07 18:15:42.005721,AAvilaAvila2013-01-07 18:15:42.0044612AAsturiasAsturias2013-01-07 18:15:42.0032120AAlmeriaAlmeria2013-01-07 18:15:42.0019852AAlicanteAlicante2013-01-07 18:15:42.0007412AAlbaceteAlbacete2013-01-07 18:15:41.999468,~AAlavaAlava2013-01-07 18:15:41.9983478}##AA CoruñaA Coruña2013-01-07 18:15:41.997113-|AZHZürich2013-01-07 18:15:41.996076'{AZGZug2013-01-07 18:15:41.995203*zAVSWallis2013-01-07 18:15:41.994321)yAVDWaadt2013-01-07 18:15:41.993330'xAURUri2013-01-07 18:15:41.991885*wATITessin2013-01-07 18:15:41.990391+vATGThurgau2013-01-07 18:15:41.988950*uASZSchwyz2013-01-07 18:15:41.987490-tASOSolothurn2013-01-07 18:15:41.9859600s%ASHSchaffhausen2013-01-07 18:15:41.984435.r!ASGSt. Gallen2013-01-07 18:15:41.982942,qAOWObwalden2013-01-07 18:15:41.981455-pANWNidwalden2013-01-07 18:15:41.980203-oANENeuenburg2013-01-07 18:15:41.979318*nALULuzern2013-01-07 18:15:41.978049(mAJUJura2013-01-07 18:15:41.8982551l'AJUGraubünden2013-01-07 18:15:41.897381*kAGLGlarus2013-01-07 18:15:41.896514(jAGEGenf2013-01-07 18:15:41.895633,iAFRFreiburg2013-01-07 18:15:41.894330/h#ABSBasel-Stadt2013-01-07 18:15:41.8929234g-ABLBasel-Landschaft2013-01-07 18:15:41.891507(fABEBern2013-01-07 18:15:41.890018:e9AARAppenzell Ausserrhoden2013-01-07 18:15:41.8885949d7AAIAppenzell Innerrhoden2013-01-07 18:15:41.887160*cAAGAargau2013-01-07 18:15:41.885715,bAVBVoralberg2013-01-07 18:15:41.884311-a!ABLBurgenland2013-01-07 18:15:41.882854(`ATITirol2013-01-07 18:15:41.881439-_!ASTSteiermark2013-01-07 18:15:41.880036-^!AKNKärnten2013-01-07 18:15:41.878839+]ASBSalzburg2013-01-07 18:15:41.8779574\/AOOOberösterreich2013-01-07 18:15:41.8770856[3ANONiederösterreich2013-01-07 18:15:41.875858'ZAWIWien2013-01-07 18:15:41.8746440Y%AQTHEThüringen2013-01-07 18:15:41.8734376X1AQSCNSchleswig-Holstein2013-01-07 18:15:41.8722172W)AQSACSachsen-Anhalt2013-01-07 18:15:41.871006+VAQSASSachsen2013-01-07 18:15:41.869790,UAQSARSaarland2013-01-07 18:15:41.8685343T+AQRHERheinland-Pfalz2013-01-07 18:15:41.8673117S3AQNRWNordrhein-Westfalen2013-01-07 18:15:41.866350:R9AQMECMecklenburg-Vorpommern2013-01-07 18:15:41.865463  _(qB t ;  20AZaragozaZaragoza2013-01-07 18:15:42.057945./AZamoraZamora2013-01-07 18:15:42.0570550.AVizcayaVizcaya2013-01-07 18:15:42.0561896-!!AValladolidValladolid2013-01-07 18:15:42.0550382,AValenciaValencia2013-01-07 18:15:42.053527.+AToledoToledo2013-01-07 18:15:42.052114.*ATeruelTeruel2013-01-07 18:15:42.0506944)ATarragonaTarragona2013-01-07 18:15:42.049291,(ASoriaSoria2013-01-07 18:15:42.0478700'ASevillaSevilla2013-01-07 18:15:42.0469350&ASegoviaSegovia2013-01-07 18:15:42.046034N%99ASanta Cruz de TenerifeSanta Cruz de Tenerife2013-01-07 18:15:42.0448584$ASalamancaSalamanca2013-01-07 18:15:42.0434566#!!APontevedraPontevedra2013-01-07 18:15:42.0420362"APalenciaPalencia2013-01-07 18:15:42.0405770!AOurenseOurense2013-01-07 18:15:42.039124 5yj> ]  | 1 P  o $ Cb6U t)Hg;ZyI5%AASecurityRole 2013-01-07 18:15:44.8142062013-01-07 18:15:44.814206I4%AASecurityRole 2013-01-07 18:15:44.8069992013-01-07 18:15:44.806999I3%AASecurityRole 2013-01-07 18:15:44.7998782013-01-07 18:15:44.799878I2%AASecurityRole 2013-01-07 18:15:44.7926482013-01-07 18:15:44.792648I1%AASecurityRole 2013-01-07 18:15:44.7853482013-01-07 18:15:44.785348I0%AASecurityRole 2013-01-07 18:15:44.7790392013-01-07 18:15:44.779039I/%AASecurityRole 2013-01-07 18:15:44.7727492013-01-07 18:15:44.772749I.%AASecurityRole 2013-01-07 18:15:44.7664522013-01-07 18:15:44.766452I-%AASecurityRole2013-01-07 18:15:44.7601312013-01-07 18:15:44.760131I,%AASecurityRole2013-01-07 18:15:44.7570122013-01-07 18:15:44.757012I+%AASecurityRole 2013-01-07 18:15:44.7538852013-01-07 18:15:44.753885I*%AASecurityRole 2013-01-07 18:15:44.7475712013-01-07 18:15:44.747571I)%AASecurityRole2013-01-07 18:15:44.7411492013-01-07 18:15:44.741149I(%AASecurityRole2013-01-07 18:15:44.7380702013-01-07 18:15:44.738070I'%AASecurityRole2013-01-07 18:15:44.7349212013-01-07 18:15:44.734921I&%AASecurityRole2013-01-07 18:15:44.7317872013-01-07 18:15:44.731787I%%AASecurityRole2013-01-07 18:15:44.7286862013-01-07 18:15:44.728686I$%AASecurityRole 2013-01-07 18:15:44.7254392013-01-07 18:15:44.725439I#%AASecurityRole 2013-01-07 18:15:44.7180492013-01-07 18:15:44.718049I"%AASecurityRole 2013-01-07 18:15:44.7104162013-01-07 18:15:44.710416I!%AASecurityRole 2013-01-07 18:15:44.7039682013-01-07 18:15:44.703968I %AASecurityRole 2013-01-07 18:15:44.6974232013-01-07 18:15:44.697423I%AASecurityRole2013-01-07 18:15:44.6908982013-01-07 18:15:44.690898I%AASecurityRole2013-01-07 18:15:44.6877352013-01-07 18:15:44.687735I%AASecurityRole2013-01-07 18:15:44.6845312013-01-07 18:15:44.684531I%AASecurityRole 2013-01-07 18:15:44.6813232013-01-07 18:15:44.681323I%AASecurityRole 2013-01-07 18:15:44.6747962013-01-07 18:15:44.674796I%AASecurityRole 2013-01-07 18:15:44.6681942013-01-07 18:15:44.668194I%AASecurityRole2013-01-07 18:15:44.6612982013-01-07 18:15:44.661298I%AASecurityRole 2013-01-07 18:15:44.6578682013-01-07 18:15:44.657868I%AASecurityRole 2013-01-07 18:15:44.5890442013-01-07 18:15:44.589044I%AASecurityRole 2013-01-07 18:15:44.5858872013-01-07 18:15:44.585887I%AASecurityRole 2013-01-07 18:15:44.5826072013-01-07 18:15:44.582607I%AASecurityRole 2013-01-07 18:15:44.5794392013-01-07 18:15:44.579439I%AASecurityRole 2013-01-07 18:15:44.5762482013-01-07 18:15:44.576248I%AASecurityRole 2013-01-07 18:15:44.5689882013-01-07 18:15:44.568988I%AASecurityRole 2013-01-07 18:15:44.5617002013-01-07 18:15:44.561700I%AASecurityRole 2013-01-07 18:15:44.5543502013-01-07 18:15:44.554350I%AASecurityRole 2013-01-07 18:15:44.5479182013-01-07 18:15:44.547918I%AASecurityRole 2013-01-07 18:15:44.5415142013-01-07 18:15:44.541514I %AASecurityRole2013-01-07 18:15:44.5348892013-01-07 18:15:44.534889I %AASecurityRole2013-01-07 18:15:44.5317002013-01-07 18:15:44.531700I %AASecurityRole2013-01-07 18:15:44.5283872013-01-07 18:15:44.528387I %AASecurityRole 2013-01-07 18:15:44.5251232013-01-07 18:15:44.525123I %AASecurityRole 2013-01-07 18:15:44.5173882013-01-07 18:15:44.517388I%AASecurityRole 2013-01-07 18:15:44.5107402013-01-07 18:15:44.510740I%AASecurityRole 2013-01-07 18:15:44.0844062013-01-07 18:15:44.084406I%AASecurityRole 2013-01-07 18:15:44.0779422013-01-07 18:15:44.077942I%AASecurityRole 2013-01-07 18:15:44.0746592013-01-07 18:15:44.074659I%AASecurityRole 2013-01-07 18:15:44.0664872013-01-07 18:15:44.066487I%AASecurityRole 2013-01-07 18:15:44.0622422013-01-07 18:15:44.062242I%AASecurityRole 2013-01-07 18:15:43.9912482013-01-07 18:15:43.991248I%AASecurityRole 2013-01-07 18:15:43.9821282013-01-07 18:15:43.982128 -j> ]  | 1 P  o $ Cb6U t)HgIb%AASecurityRole 02013-01-07 18:15:48.4291462013-01-07 18:15:48.429146Ia%AASecurityRole 2013-01-07 18:15:48.4256742013-01-07 18:15:48.425674I`%AASecurityRole 02013-01-07 18:15:48.4167782013-01-07 18:15:48.416778I_%AASecurityRole/2013-01-07 18:15:45.0687782013-01-07 18:15:45.068778I^%AASecurityRole /2013-01-07 18:15:45.0654162013-01-07 18:15:45.065416I]%AASecurityRole.2013-01-07 18:15:45.0575922013-01-07 18:15:45.057592I\%AASecurityRole-2013-01-07 18:15:45.0544152013-01-07 18:15:45.054415I[%AASecurityRole,2013-01-07 18:15:45.0512322013-01-07 18:15:45.051232IZ%AASecurityRole .2013-01-07 18:15:45.0479932013-01-07 18:15:45.047993IY%AASecurityRole -2013-01-07 18:15:45.0412502013-01-07 18:15:45.041250IX%AASecurityRole ,2013-01-07 18:15:45.0345242013-01-07 18:15:45.034524IW%AASecurityRole,2013-01-07 18:15:45.0313252013-01-07 18:15:45.031325IV%AASecurityRole+2013-01-07 18:15:45.0249262013-01-07 18:15:45.024926IU%AASecurityRole+2013-01-07 18:15:45.0217632013-01-07 18:15:45.021763IT%AASecurityRole +2013-01-07 18:15:45.0185612013-01-07 18:15:45.018561IS%AASecurityRole*2013-01-07 18:15:45.0119312013-01-07 18:15:45.011931IR%AASecurityRole)2013-01-07 18:15:45.0087612013-01-07 18:15:45.008761IQ%AASecurityRole(2013-01-07 18:15:45.0055532013-01-07 18:15:45.005553IP%AASecurityRole *2013-01-07 18:15:45.0023612013-01-07 18:15:45.002361IO%AASecurityRole )2013-01-07 18:15:44.9959242013-01-07 18:15:44.995924IN%AASecurityRole (2013-01-07 18:15:44.9885462013-01-07 18:15:44.988546IM%AASecurityRole(2013-01-07 18:15:44.9852542013-01-07 18:15:44.985254IL%AASecurityRole'2013-01-07 18:15:44.9787172013-01-07 18:15:44.978717IK%AASecurityRole'2013-01-07 18:15:44.9754742013-01-07 18:15:44.975474IJ%AASecurityRole '2013-01-07 18:15:44.9722522013-01-07 18:15:44.972252II%AASecurityRole&2013-01-07 18:15:44.9656242013-01-07 18:15:44.965624IH%AASecurityRole &2013-01-07 18:15:44.9622902013-01-07 18:15:44.962290IG%AASecurityRole%2013-01-07 18:15:44.8882192013-01-07 18:15:44.888219IF%AASecurityRole$2013-01-07 18:15:44.8850352013-01-07 18:15:44.885035IE%AASecurityRole#2013-01-07 18:15:44.8819232013-01-07 18:15:44.881923ID%AASecurityRole"2013-01-07 18:15:44.8787902013-01-07 18:15:44.878790IC%AASecurityRole!2013-01-07 18:15:44.8756502013-01-07 18:15:44.875650IB%AASecurityRole %2013-01-07 18:15:44.8724252013-01-07 18:15:44.872425IA%AASecurityRole $2013-01-07 18:15:44.8658842013-01-07 18:15:44.865884I@%AASecurityRole #2013-01-07 18:15:44.8594662013-01-07 18:15:44.859466I?%AASecurityRole "2013-01-07 18:15:44.8529492013-01-07 18:15:44.852949I>%AASecurityRole !2013-01-07 18:15:44.8463062013-01-07 18:15:44.846306I=%AASecurityRole 2013-01-07 18:15:44.8397442013-01-07 18:15:44.839744I<%AASecurityRole2013-01-07 18:15:44.8364852013-01-07 18:15:44.836485I;%AASecurityRole2013-01-07 18:15:44.8332512013-01-07 18:15:44.833251I:%AASecurityRole2013-01-07 18:15:44.8300262013-01-07 18:15:44.830026I9%AASecurityRole2013-01-07 18:15:44.8268742013-01-07 18:15:44.826874I8%AASecurityRole2013-01-07 18:15:44.8237322013-01-07 18:15:44.823732I7%AASecurityRole2013-01-07 18:15:44.8205642013-01-07 18:15:44.820564I6%AASecurityRole2013-01-07 18:15:44.8173362013-01-07 18:15:44.817336 *^ m X  U M 2 h 9YVB&^Awg* ;-AADelete GlobalImageAssetGlobalImageAsset2013-01-07 18:15:44.9986982013-01-07 18:15:44.998698g) ;-AAUpload GlobalImageAssetGlobalImageAsset2013-01-07 18:15:44.9921932013-01-07 18:15:44.992193e( 7-AAView GlobalImageAssetGlobalImageAsset2013-01-07 18:15:44.9814752013-01-07 18:15:44.981475a' 3)AAView SiteImageAssetSiteImageAsset2013-01-07 18:15:44.9684422013-01-07 18:15:44.968442O& !AAView ThemeTheme2013-01-07 18:15:44.9582722013-01-07 18:15:44.958272e% ;)AAUnsecure WebsiteNavItem WebsiteNavItem2013-01-07 18:15:44.8686882013-01-07 18:15:44.868688c$ 7)AASecure WebsiteNavItem WebsiteNavItem2013-01-07 18:15:44.8622212013-01-07 18:15:44.862221a# 3)AAEdit WebsiteNavItemWebsiteNavItem2013-01-07 18:15:44.8557232013-01-07 18:15:44.855723c" 7)AADelete WebsiteNavItemWebsiteNavItem2013-01-07 18:15:44.8491312013-01-07 18:15:44.849131c! 7)AACreate WebsiteNavItemWebsiteNavItem2013-01-07 18:15:44.8424932013-01-07 18:15:44.842493[ 5AAEdit Excerpt ContentContent2013-01-07 18:15:44.8105712013-01-07 18:15:44.810571X /AAEdit Html Content Content2013-01-07 18:15:44.8033682013-01-07 18:15:44.803368[ 5AAAdd Existing Content Content2013-01-07 18:15:44.7961902013-01-07 18:15:44.796190] 9AARevert Version Content Content2013-01-07 18:15:44.7889432013-01-07 18:15:44.788943V +AAPublish ContentContent2013-01-07 18:15:44.7817032013-01-07 18:15:44.781703S %AAEdit ContentContent2013-01-07 18:15:44.7754422013-01-07 18:15:44.775442U )AADelete ContentContent2013-01-07 18:15:44.7691632013-01-07 18:15:44.769163U )AACreate ContentContent2013-01-07 18:15:44.7627882013-01-07 18:15:44.762788m ?5AAEdit WebsiteSectionLayoutWebsiteSectionLayout2013-01-07 18:15:44.7502712013-01-07 18:15:44.750271o C5AACreate WebsiteSectionLayoutWebsiteSectionLayout2013-01-07 18:15:44.7438232013-01-07 18:15:44.743823e ;)AAUnsecure WebsiteSection WebsiteSection2013-01-07 18:15:44.7217542013-01-07 18:15:44.721754c 7)AASecure WebsiteSection WebsiteSection2013-01-07 18:15:44.7141282013-01-07 18:15:44.714128a 3)AAEdit WebsiteSectionWebsiteSection2013-01-07 18:15:44.7067052013-01-07 18:15:44.706705c 7)AADelete WebsiteSectionWebsiteSection2013-01-07 18:15:44.7002752013-01-07 18:15:44.700275c 7)AACreate WebsiteSectionWebsiteSection2013-01-07 18:15:44.6936322013-01-07 18:15:44.693632[ -#AAEdit WebsiteHostWebsiteHost2013-01-07 18:15:44.6775692013-01-07 18:15:44.677569] 1#AADelete WebsiteHostWebsiteHost2013-01-07 18:15:44.6710192013-01-07 18:15:44.671019] 1#AACreate WebsiteHostWebsiteHost2013-01-07 18:15:44.6640982013-01-07 18:15:44.664098W -AAActivate WebsiteWebsite2013-01-07 18:15:44.5725422013-01-07 18:15:44.572542V +AAPublish WebsiteWebsite2013-01-07 18:15:44.5652752013-01-07 18:15:44.565275U )AAImport WebsiteWebsite2013-01-07 18:15:44.5579862013-01-07 18:15:44.557986S %AAEdit WebsiteWebsite2013-01-07 18:15:44.5506462013-01-07 18:15:44.550646U )AADelete WebsiteWebsite2013-01-07 18:15:44.5442442013-01-07 18:15:44.544244U )AACreate WebsiteWebsite2013-01-07 18:15:44.5377042013-01-07 18:15:44.537704Y +!AAEdit WebsiteNavWebsiteNav2013-01-07 18:15:44.5213402013-01-07 18:15:44.521340[ /!AADelete WebsiteNavWebsiteNav2013-01-07 18:15:44.5136712013-01-07 18:15:44.513671[ /!AACreate WebsiteNavWebsiteNav2013-01-07 18:15:44.5058172013-01-07 18:15:44.505817O #AADelete NoteNote2013-01-07 18:15:44.0806952013-01-07 18:15:44.080695M AAView NoteNote2013-01-07 18:15:44.0706232013-01-07 18:15:44.070623O #AACreate NoteNote2013-01-07 18:15:43.9940722013-01-07 18:15:43.994072O #AADelete UserUser2013-01-07 18:15:43.9871242013-01-07 18:15:43.987124O #AACreate UserUser2013-01-07 18:15:43.9600132013-01-07 18:15:43.960013  :l M0 AAEdit NoteNote2013-01-07 18:15:48.4116672013-01-07 18:15:48.411667`/ 7#AADrag Item WebsiteTreeWebsiteTree2013-01-07 18:15:45.0615442013-01-07 18:15:45.061544e. 9+AADelete GlobalFileAssetGlobalFileAsset2013-01-07 18:15:45.0441192013-01-07 18:15:45.044119e- 9+AAUpload GlobalFileAssetGlobalFileAsset2013-01-07 18:15:45.0374502013-01-07 18:15:45.037450c, 5+AAView GlobalFileAssetGlobalFileAsset2013-01-07 18:15:45.0276312013-01-07 18:15:45.027631_+ 1'AAView SiteFileAssetSiteFileAsset2013-01-07 18:15:45.0146522013-01-07 18:15:45.014652  S%g)%IAAContact Form[{"xtype":"textfield","fieldLabel":"First Name","name":"first_name","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true},{"xtype":"textfield","fieldLabel":"Last Name","name":"last_name","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true},{"xtype":"textfield","fieldLabel":"Email","name":"email","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true,"validator_function":"validateEmail(v)"},{"xtype":"textarea","fieldLabel":"Message","name":"message","value":null,"allowBlank":false,"readOnly":false,"width":400,"height":200,"labelWidth":75,"display_in_grid":true}]WebsiteInquirycontact-formtsavetfqtipSubmitCancelThis is the default form used by Knitkit's Contact Us Widget for Website Inquiries. NOTE: The Contact Us Widget uses Knitkit's website configuration options for email behavior & not the Dynamic Forms Widget Action setting.2013-01-07 18:15:41.0867322013-01-07 18:15:41.086732 RR+#i#AATicket Form[{"xtype":"textfield","fieldLabel":"Title","name":"title","value":null,"allowBlank":false,"readOnly":false,"width":250,"height":null,"labelWidth":75,"display_in_grid":true},{"xtype":"combobox","fieldLabel":"Status","name":"status","value":null,"allowBlank":false,"readOnly":false,"width":175,"height":null,"labelWidth":75,"display_in_grid":true,"forceSelection":true,"store":[["Open","Open"],["Closed","Closed"]]},{"xtype":"combobox","fieldLabel":"Type","name":"type","value":null,"allowBlank":false,"readOnly":false,"width":175,"height":null,"labelWidth":75,"display_in_grid":true,"forceSelection":true,"store":[["Defect","Defect"],["Feature","Feature"],["Issue","Issue"],["Task","Task"]]},{"xtype":"combobox","fieldLabel":"Priority","name":"priority","value":null,"allowBlank":false,"readOnly":false,"width":175,"height":null,"labelWidth":75,"display_in_grid":true,"forceSelection":true,"store":[["High","High"],["Medium","Medium"],["Low","Low"]]},{"xtype":"combobox","fieldLabel":"Product","name":"product","value":null,"allowBlank":true,"readOnly":false,"width":270,"height":null,"labelWidth":75,"display_in_grid":true,"forceSelection":true,"store":[["compass_ae_console","compass_ae_console"],["compass_ae_starter_kit","compass_ae_starter_kit"],["data_migrator","data_migrator"],["erp_agreements","erp_agreements"],["erp_app","erp_app"],["erp_base_erp_svcs","erp_base_erp_svcs"],["erp_commerce","erp_commerce"],["erp_communication_events","erp_communication_events"],["erp_dev_svcs","erp_dev_svcs"],["erp_financial_accounting","erp_financial_accounting"],["erp_forms","erp_forms"],["erp_inventory","erp_inventory"],["erp_invoicing","erp_invoicing"],["erp_offers","erp_offers"],["erp_orders","erp_orders"],["erp_products","erp_products"],["erp_rules","erp_rules"],["erp_search","erp_search"],["erp_tech_svcs","erp_tech_svcs"],["erp_txns_and_accts","erp_txns_and_accts"],["erp_work_effort","erp_work_effort"],["erp_workflow","erp_workflow"],["knitkit","knitkit"],["master_data_management","master_data_management"],["prismpay","prismpay"],["rails_db_admin","rails_db_admin"],["tenancy","tenancy"],["timeshare","timeshare"]]},{"xtype":"combobox","fieldLabel":"Project","name":"project","value":null,"allowBlank":true,"readOnly":false,"width":175,"height":null,"labelWidth":75,"display_in_grid":true,"forceSelection":true,"store":[["None","None"]]},{"xtype":"related_combobox","fieldLabel":"Assigned To","name":"assigned_to_id","value":null,"allowBlank":true,"readOnly":false,"width":175,"height":null,"labelWidth":75,"display_in_grid":true,"displayField":"username","extraParams":{"model":"User","displayField":"username"},"fields":[{"name":"id"},{"name":"username"}],"forceSelection":true},{"xtype":"textarea","fieldLabel":"Body","name":"body","value":null,"allowBlank":false,"readOnly":false,"width":400,"height":300,"labelWidth":75,"display_in_grid":false}]Ticketticket-formtsavetfqtipSubmitCancel2013-01-07 18:15:48.2573902013-01-07 18:15:48.257390