SQLite format 3@ -$-~ytoje`[UOIC=71+%ׁ+с(́#ǁ |xtokg{bt^nXiSeO`L^H[GVDQAL=I9D7@3=07.1),$& !  (p^L:( )20120429130430 )20120427000446 )20120411151848 )20120325123722)20120320182253)20120316152543)20111117183144)20110913145329)20110530193446)20080805000096)20080805000020)20080805000010 |iVC0)20120429130430 )20120427000446 )20120411151848 )20120325123722 )20120320182253)20120316152543)20111117183144)20110913145329)20110530193446)20080805000096)20080805000020) 20080805000010  vq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") }YtableusersusersCREATE 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)   (lP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")n;indexindex_users_on_usernameusers CREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")k%'indexactivity_idxusers CREATE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")M-indexindex_users_on_remember_me_tokenusers CREATE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token") S9indexindex_users_on_reset_password_tokenusers CREATE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") K)indexindex_users_on_activation_tokenusersCREATE INDEX "index_users_on_activation_token" ON "users" ("activation_token")         0 $ 'tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)W tablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)y Eindexindex_sessions_on_session_idsessionsCREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")     zj!!tableaudit_logsaudit_logsCREATE TABLE "audit_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "application" varchar(255), "description" varchar(255), "party_id" integer, "additional_info" text, "audit_log_type_id" integer, "event_record_id" integer, "event_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){E!indexindex_audit_logs_on_party_idaudit_logsCREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")1!Aindexevent_record_indexaudit_logsCREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type")    )++ tableaudit_log_typesaudit_log_typesCREATE TABLE "audit_log_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "error_code" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)6++#tableaudit_log_itemsaudit_log_itemsCREATE TABLE "audit_log_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "audit_log_id" integer, "audit_log_item_type_id" integer, "audit_log_item_value" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   GGu55]tableaudit_log_item_typesaudit_log_item_typesCREATE TABLE "audit_log_item_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "description" varchar(255), "comments" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)y))-tablesecured_modelssecured_modelsCREATE TABLE "secured_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "secured_record_id" integer, "secured_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)1)Qindexsecured_record_idxsecured_modelsCREATE INDEX "secured_record_idx" ON "secured_models" ("secured_record_id", "secured_record_type")553tableroles_secured_modelsroles_secured_modelsCREATE TABLE "roles_secured_models" ("secured_model_id" integer, "role_id" integer)     vv4;i5eindexindex_roles_secured_models_on_secured_model_idroles_secured_models CREATE INDEX "index_roles_secured_models_on_secured_model_id" ON "roles_secured_models" ("secured_model_id") W5Aindexindex_roles_secured_models_on_role_idroles_secured_models"CREATE INDEX "index_roles_secured_models_on_role_id" ON "roles_secured_models" ("role_id")1##)tablefile_assetsfile_assets#CREATE TABLE "file_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_asset_holder_id" integer, "file_asset_holder_type" varchar(255), "type" varchar(255), "name" varchar(255), "directory" varchar(255), "data_file_name" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "data_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s?#indexindex_file_assets_on_typefile_assets$CREATE INDEX "index_file_assets_on_type" ON "file_assets" ("type")     nn{7#]indexfile_asset_holder_idxfile_assets%CREATE INDEX "file_asset_holder_idx" ON "file_assets" ("file_asset_holder_id", "file_asset_holder_type")s?#indexindex_file_assets_on_namefile_assets'CREATE INDEX "index_file_assets_on_name" ON "file_assets" ("name")I#%indexindex_file_assets_on_directoryfile_assets(CREATE INDEX "index_file_assets_on_directory" ON "file_assets" ("directory")%%Ctabledelayed_jobsdelayed_jobs)CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "queue" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){ 7%'indexdelayed_jobs_prioritydelayed_jobs*CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")      aai!))Etablecapable_modelscapable_models+CREATE TABLE "capable_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "capable_model_record_id" integer, "capable_model_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)'"=)uindexcapable_model_record_idxcapable_models-CREATE INDEX "capable_model_record_idx" ON "capable_models" ("capable_model_record_id", "capable_model_record_type")~#--/tablecapability_typescapability_types.CREATE TABLE "capability_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i$%%tablecapabilitiescapabilities/CREATE TABLE "capabilities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource" varchar(255), "capability_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)     ++uO !%]%Mindexindex_capabilities_on_capability_type_idcapabilities0CREATE INDEX "index_capabilities_on_capability_type_id" ON "capabilities" ("capability_type_id")#&CCMtablecapabilities_capable_modelscapabilities_capable_models2CREATE TABLE "capabilities_capable_models" ("capable_model_id" integer, "capability_id" integer)W'wCindexindex_capabilities_capable_models_on_capable_model_idcapabilities_capable_models3CREATE INDEX "index_capabilities_capable_models_on_capable_model_id" ON "capabilities_capable_models" ("capable_model_id")N(qCuindexindex_capabilities_capable_models_on_capability_idcapabilities_capable_models4CREATE INDEX "index_capabilities_capable_models_on_capability_id" ON "capabilities_capable_models" ("capability_id")])55]tablecompass_ae_instancescompass_ae_instances5CREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)      LLrD*_tablepartiesparties6CREATE 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_1parties8CREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")p,##'tableparty_rolesparty_roles9CREATE 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_typesCREATE TABLE "relationship_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "valid_from_role_type_id" integer, "valid_to_role_type_id" integer, "name" varchar(255), "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   aa,H1s1yindexindex_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")B2o1qindexindex_relationship_types_on_valid_to_role_type_idrelationship_typesACREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id") 333?tableparty_relationshipsparty_relationshipsBCREATE 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)    H14c3Yindexindex_party_relationships_on_status_type_idparty_relationshipsCCREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id")75g3aindexindex_party_relationships_on_priority_type_idparty_relationshipsECREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")C6o3qindexindex_party_relationships_on_relationship_type_idparty_relationshipsFCREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationships" ("relationship_type_id")o7''tableorganizationsorganizationsGCREATE 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)     >>>8##CtableindividualsindividualsHCREATE 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)9G#!indexindex_individuals_on_party_idindividualsJCREATE INDEX "index_individuals_on_party_id" ON "individuals" ("party_id")   BBuH:ctablecontactscontactsKCREATE 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)s;Aindexindex_contacts_on_party_idcontactsMCREATE INDEX "index_contacts_on_party_id" ON "contacts" ("party_id")q<9indexbesi_2contactsNCREATE INDEX "besi_2" ON "contacts" ("contact_mechanism_id", "contact_mechanism_type")=''Otablecontact_typescontact_typesOCREATE TABLE "contact_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)     4a >M'-indexindex_contact_types_on_parent_idcontact_typesPCREATE INDEX "index_contact_types_on_parent_id" ON "contact_types" ("parent_id")?--Utablecontact_purposescontact_purposesRCREATE 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_purposesSCREATE INDEX "index_contact_purposes_on_parent_id" ON "contact_purposes" ("parent_id")A??Gtablecontact_purposes_contactscontact_purposes_contactsTCREATE TABLE "contact_purposes_contacts" ("contact_id" integer, "contact_purpose_id" integer)     X7BK?qindexcontact_purposes_contacts_indexcontact_purposes_contactsUCREATE INDEX "contact_purposes_contacts_index" ON "contact_purposes_contacts" ("contact_id", "contact_purpose_id") C--stablepostal_addressespostal_addressesWCREATE 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)%D]-Mindexindex_postal_addresses_on_geo_country_idpostal_addressesXCREATE INDEX "index_postal_addresses_on_geo_country_id" ON "postal_addresses" ("geo_country_id")     xxEW-Aindexindex_postal_addresses_on_geo_zone_idpostal_addressesYCREATE INDEX "index_postal_addresses_on_geo_zone_id" ON "postal_addresses" ("geo_zone_id")uF++!tableemail_addressesemail_addressesZCREATE 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)nG''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)   ==@H11+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)  sa`Itablemoneymoney_CREATE TABLE "money" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "amount" float, "currency_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)pJAindexindex_money_on_currency_idmoneyaCREATE INDEX "index_money_on_currency_id" ON "money" ("currency_id")kK!!!tablecurrenciescurrenciesbCREATE 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)L[!Iindexindex_currencies_on_internal_identifiercurrenciescCREATE INDEX "index_currencies_on_internal_identifier" ON "currencies" ("internal_identifier")     bb0M!!+tablecategoriescategoriesdCREATE 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) N5!Qindexcategory_polymorphiccategoriesfCREATE INDEX "category_polymorphic" ON "categories" ("category_record_id", "category_record_type")XO==Ctablecategory_classificationscategory_classificationsgCREATE 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)    [[^3PA=uindexclassification_polymorphiccategory_classificationshCREATE INDEX "classification_polymorphic" ON "category_classifications" ("classification_id", "classification_type") Q11ktabledescriptive_assetsdescriptive_assetsjCREATE 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)'R]1Mindexindex_descriptive_assets_on_view_type_iddescriptive_assetskCREATE INDEX "index_descriptive_assets_on_view_type_id" ON "descriptive_assets" ("view_type_id")S51eindexdescribed_record_idxdescriptive_assetslCREATE INDEX "described_record_idx" ON "descriptive_assets" ("described_record_id", "described_record_type")     %lT!!#tableview_typesview_typesmCREATE 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) U''Ytablegeo_countriesgeo_countriesoCREATE 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){VC'indexindex_geo_countries_on_namegeo_countriespCREATE INDEX "index_geo_countries_on_name" ON "geo_countries" ("name") WO'1indexindex_geo_countries_on_iso_code_2geo_countriesqCREATE INDEX "index_geo_countries_on_iso_code_2" ON "geo_countries" ("iso_code_2")XXtablegeo_zonesgeo_zonesrCREATE 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)      ))1 YO1indexindex_geo_zones_on_geo_country_idgeo_zonessCREATE INDEX "index_geo_zones_on_geo_country_id" ON "geo_zones" ("geo_country_id")zZEindexindex_geo_zones_on_zone_namegeo_zonesuCREATE INDEX "index_geo_zones_on_zone_name" ON "geo_zones" ("zone_name")z[Eindexindex_geo_zones_on_zone_codegeo_zonesvCREATE INDEX "index_geo_zones_on_zone_code" ON "geo_zones" ("zone_code")\tablenotesnoteswCREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_by_id" integer, "content" text, "noted_record_id" integer, "noted_record_type" varchar(255), "note_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=]u{indexindex_notes_on_noted_record_id_and_noted_record_typenotesxCREATE INDEX "index_notes_on_noted_record_id_and_noted_record_type" ON "notes" ("noted_record_id", "noted_record_type")s^Cindexindex_notes_on_note_type_idnotesyCREATE INDEX "index_notes_on_note_type_id" ON "notes" ("note_type_id")       AADv_Eindexindex_notes_on_created_by_idnoteszCREATE 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)a5!Uindexnote_type_record_idxnote_types}CREATE INDEX "note_type_record_idx" ON "note_types" ("note_type_record_id", "note_type_record_type")'b--tablevalid_note_typesvalid_note_types~CREATE 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)     nn$_3cA-indexvalid_note_type_record_idxvalid_note_typesCREATE INDEX "valid_note_type_record_idx" ON "valid_note_types" ("valid_note_type_record_id", "valid_note_type_record_type") dY-Eindexindex_valid_note_types_on_note_type_idvalid_note_typesCREATE INDEX "index_valid_note_types_on_note_type_id" ON "valid_note_types" ("note_type_id")ne##!tablepreferencespreferencesCREATE 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)$f_#Qindexindex_preferences_on_preference_option_idpreferencesCREATE INDEX "index_preferences_on_preference_option_id" ON "preferences" ("preference_option_id")g[#Iindexindex_preferences_on_preference_type_idpreferencesCREATE INDEX "index_preferences_on_preference_type_id" ON "preferences" ("preference_type_id")      55Y8!h--stablepreference_typespreference_typesCREATE 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)>im-mindexindex_preference_types_on_default_pref_option_idpreference_typesCREATE INDEX "index_preference_types_on_default_pref_option_id" ON "preference_types" ("default_pref_option_id")j11_tablepreference_optionspreference_optionsCREATE 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)EkSSotablepreference_options_preference_typespreference_options_preference_typesCREATE TABLE "preference_options_preference_types" ("preference_type_id" integer, "preference_option_id" integer)     <<FlSSqindexpref_opt_pref_type_pref_type_id_idxpreference_options_preference_typesCREATE INDEX "pref_opt_pref_type_pref_type_id_idx" ON "preference_options_preference_types" ("preference_type_id")FmQSsindexpref_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")xn99 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))4o--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)      ZpO-1indexindex_user_preferences_on_user_iduser_preferencesCREATE INDEX "index_user_preferences_on_user_id" ON "user_preferences" ("user_id")#q[-Iindexindex_user_preferences_on_preference_iduser_preferencesCREATE INDEX "index_user_preferences_on_preference_id" ON "user_preferences" ("preference_id");rk-iindexindex_user_preferences_on_preferenced_record_iduser_preferencesCREATE INDEX "index_user_preferences_on_preferenced_record_id" ON "user_preferences" ("preferenced_record_id")Aso-qindexindex_user_preferences_on_preferenced_record_typeuser_preferencesCREATE INDEX "index_user_preferences_on_preferenced_record_type" ON "user_preferences" ("preferenced_record_type")!t)){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)      ZX uK))indexindex_app_containers_on_user_idapp_containersCREATE INDEX "index_app_containers_on_user_id" ON "app_containers" ("user_id")vE)indexindex_app_containers_on_typeapp_containersCREATE INDEX "index_app_containers_on_type" ON "app_containers" ("type")xw%%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)%xCCOtableapp_containers_applicationsapp_containers_applicationsCREATE TABLE "app_containers_applications" ("app_container_id" integer, "application_id" integer)     btRysCyindexindex_app_containers_applications_on_application_idapp_containers_applicationsCREATE INDEX "index_app_containers_applications_on_application_id" ON "app_containers_applications" ("application_id")XzwCindexindex_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)     55Y6}e5]indexindex_applications_widgets_on_application_idapplications_widgetsCREATE INDEX "index_applications_widgets_on_application_id" ON "applications_widgets" ("application_id")'~[5Iindexindex_applications_widgets_on_widget_idapplications_widgetsCREATE INDEX "index_applications_widgets_on_widget_id" ON "applications_widgets" ("widget_id")>33!tabletree_menu_node_defstree_menu_node_defsCREATE TABLE "tree_menu_node_defs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "node_type" varchar(255), "parent_id" integer, "lft" integer, "rgt" integer, "menu_short_name" varchar(255), "menu_description" varchar(255), "text" varchar(255), "icon_url" varchar(255), "target_url" varchar(255), "resource_class" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)#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")     22d@.))tableconfigurationsconfigurationsCREATE TABLE "configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "active" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "is_template" boolean DEFAULT 'f')*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")     hhU/-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")Mu3}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)D A[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")     SS43] ?[+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")    b1_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)KI_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")KG_{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")     z\c33ktabledynamic_form_modelsdynamic_form_modelsCREATE TABLE "dynamic_form_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "model_name" varchar(255), "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)Sw9indexindex_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")     M ''Qtabledynamic_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, "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")     ,T 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")     ;l($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%9indexindex_dynamic_data_on_updated_by_iddynamic_dataCREATE INDEX "index_dynamic_data_on_updated_by_id" ON "dynamic_data" ("updated_by_id")'U%=indexindex_dynamic_data_on_reference_typedynamic_dataCREATE INDEX "index_dynamic_data_on_reference_type" ON "dynamic_data" ("reference_type")(Q%5indexindex_dynamic_data_on_reference_iddynamic_dataCREATE INDEX "index_dynamic_data_on_reference_id" ON "dynamic_data" ("reference_id")      6)++atableattribute_typesattribute_typesCREATE TABLE "attribute_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "data_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) *=+5index:attribute_types_iid_idxattribute_typesCREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")9+--#tableattribute_valuesattribute_valuesCREATE TABLE "attribute_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attributed_record_id" integer, "attributed_record_type" varchar(255), "attribute_type_id" integer, "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)     [.A-indexattribute_values_value_idxattribute_valuesCREATE INDEX "attribute_values_value_idx" ON "attribute_values" ("value")B,Y- indexattribute_values_attributed_record_idxattribute_valuesCREATE INDEX "attribute_values_attributed_record_idx" ON "attribute_values" ("attributed_record_id", "attributed_record_type")!-U-Kindexattribute_values_attributed_type_idxattribute_valuesCREATE INDEX "attribute_values_attributed_type_idx" ON "attribute_values" ("attribute_type_id")