Connecting to database specified by database.yml
Connecting to database specified by database.yml
   (0.1ms)  select sqlite_version(*)
   (2.1ms)  CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) 
   (0.1ms)  PRAGMA index_list("schema_migrations")
   (1.6ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
   (0.1ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" 
Migrating to BaseTechServices (20080805000010)
   (0.0ms)  begin transaction
   (0.7ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("users")
   (0.4ms)  CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")
   (0.0ms)  PRAGMA index_list("users")
   (0.0ms)  PRAGMA index_info('index_users_on_email')
   (0.2ms)  CREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")
   (0.0ms)  PRAGMA index_list("users")
   (0.0ms)  PRAGMA index_info('index_users_on_username')
   (0.0ms)  PRAGMA index_info('index_users_on_email')
   (0.1ms)  CREATE INDEX "activity_idx" ON "users" ("last_logout_at", "last_activity_at")
   (0.0ms)  PRAGMA index_list("users")
   (0.0ms)  PRAGMA index_info('activity_idx')
   (0.0ms)  PRAGMA index_info('index_users_on_username')
   (0.0ms)  PRAGMA index_info('index_users_on_email')
   (0.1ms)  CREATE INDEX "index_users_on_remember_me_token" ON "users" ("remember_me_token")
   (0.0ms)  PRAGMA index_list("users")
   (0.0ms)  PRAGMA index_info('index_users_on_remember_me_token')
   (0.0ms)  PRAGMA index_info('activity_idx')
   (0.0ms)  PRAGMA index_info('index_users_on_username')
   (0.0ms)  PRAGMA index_info('index_users_on_email')
   (0.1ms)  CREATE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")
   (0.0ms)  PRAGMA index_list("users")
   (0.0ms)  PRAGMA index_info('index_users_on_reset_password_token')
   (0.0ms)  PRAGMA index_info('index_users_on_remember_me_token')
   (0.0ms)  PRAGMA index_info('activity_idx')
   (0.0ms)  PRAGMA index_info('index_users_on_username')
   (0.0ms)  PRAGMA index_info('index_users_on_email')
   (0.1ms)  CREATE INDEX "index_users_on_activation_token" ON "users" ("activation_token")
   (0.2ms)  CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.1ms)  CREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("sessions")
   (0.1ms)  CREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")
   (0.0ms)  PRAGMA index_list("sessions")
   (0.0ms)  PRAGMA index_info('index_sessions_on_session_id')
   (0.1ms)  CREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("audit_logs")
   (0.1ms)  CREATE INDEX "index_audit_logs_on_party_id" ON "audit_logs" ("party_id")
   (0.0ms)  PRAGMA index_list("audit_logs")
   (0.0ms)  PRAGMA index_info('index_audit_logs_on_party_id')
   (0.1ms)  CREATE INDEX "event_record_index" ON "audit_logs" ("event_record_id", "event_record_type")
   (0.2ms)  CREATE 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) 
   (0.2ms)  CREATE 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) 
   (0.2ms)  CREATE 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) 
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("secured_models")
   (0.1ms)  CREATE INDEX "secured_record_idx" ON "secured_models" ("secured_record_id", "secured_record_type")
   (0.2ms)  CREATE TABLE "roles_secured_models" ("secured_model_id" integer, "role_id" integer) 
   (0.0ms)  PRAGMA index_list("roles_secured_models")
   (0.2ms)  CREATE INDEX "index_roles_secured_models_on_secured_model_id" ON "roles_secured_models" ("secured_model_id")
   (0.0ms)  PRAGMA index_list("roles_secured_models")
   (0.0ms)  PRAGMA index_info('index_roles_secured_models_on_secured_model_id')
   (0.1ms)  CREATE INDEX "index_roles_secured_models_on_role_id" ON "roles_secured_models" ("role_id")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("file_assets")
   (0.1ms)  CREATE INDEX "index_file_assets_on_type" ON "file_assets" ("type")
   (0.0ms)  PRAGMA index_list("file_assets")
   (0.0ms)  PRAGMA index_info('index_file_assets_on_type')
   (0.2ms)  CREATE INDEX "file_asset_holder_idx" ON "file_assets" ("file_asset_holder_id", "file_asset_holder_type")
   (0.0ms)  PRAGMA index_list("file_assets")
   (0.0ms)  PRAGMA index_info('file_asset_holder_idx')
   (0.0ms)  PRAGMA index_info('index_file_assets_on_type')
   (0.1ms)  CREATE INDEX "index_file_assets_on_name" ON "file_assets" ("name")
   (0.0ms)  PRAGMA index_list("file_assets")
   (0.0ms)  PRAGMA index_info('index_file_assets_on_name')
   (0.0ms)  PRAGMA index_info('file_asset_holder_idx')
   (0.0ms)  PRAGMA index_info('index_file_assets_on_type')
   (0.2ms)  CREATE INDEX "index_file_assets_on_directory" ON "file_assets" ("directory")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("delayed_jobs")
   (0.2ms)  CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("capable_models")
   (0.1ms)  CREATE INDEX "capable_model_record_idx" ON "capable_models" ("capable_model_record_id", "capable_model_record_type")
   (0.2ms)  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) 
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("capabilities")
   (0.2ms)  CREATE INDEX "index_capabilities_on_capability_type_id" ON "capabilities" ("capability_type_id")
   (0.1ms)  CREATE TABLE "capabilities_capable_models" ("capable_model_id" integer, "capability_id" integer) 
   (0.0ms)  PRAGMA index_list("capabilities_capable_models")
   (0.2ms)  CREATE INDEX "index_capabilities_capable_models_on_capable_model_id" ON "capabilities_capable_models" ("capable_model_id")
   (0.0ms)  PRAGMA index_list("capabilities_capable_models")
   (0.0ms)  PRAGMA index_info('index_capabilities_capable_models_on_capable_model_id')
   (0.1ms)  CREATE INDEX "index_capabilities_capable_models_on_capability_id" ON "capabilities_capable_models" ("capability_id")
   (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20080805000010')
   (2.7ms)  commit transaction
Migrating to BaseErpServices (20080805000020)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TABLE "compass_ae_instances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" decimal, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.2ms)  CREATE TABLE "parties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "business_party_id" integer, "business_party_type" varchar(255), "list_view_image_id" integer, "enterprise_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("parties")
   (0.2ms)  CREATE INDEX "besi_1" ON "parties" ("business_party_id", "business_party_type")
   (0.2ms)  CREATE TABLE "party_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "party_id" integer, "role_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("party_roles")
   (0.2ms)  CREATE INDEX "index_party_roles_on_party_id" ON "party_roles" ("party_id")
   (0.0ms)  PRAGMA index_list("party_roles")
   (0.1ms)  PRAGMA index_info('index_party_roles_on_party_id')
   (0.1ms)  CREATE INDEX "index_party_roles_on_role_type_id" ON "party_roles" ("role_type_id")
   (0.2ms)  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) 
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("relationship_types")
   (0.2ms)  CREATE INDEX "index_relationship_types_on_valid_from_role_type_id" ON "relationship_types" ("valid_from_role_type_id")
   (0.0ms)  PRAGMA index_list("relationship_types")
   (0.0ms)  PRAGMA index_info('index_relationship_types_on_valid_from_role_type_id')
   (0.2ms)  CREATE INDEX "index_relationship_types_on_valid_to_role_type_id" ON "relationship_types" ("valid_to_role_type_id")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("party_relationships")
   (0.2ms)  CREATE INDEX "index_party_relationships_on_status_type_id" ON "party_relationships" ("status_type_id")
   (0.0ms)  PRAGMA index_list("party_relationships")
   (0.0ms)  PRAGMA index_info('index_party_relationships_on_status_type_id')
   (0.2ms)  CREATE INDEX "index_party_relationships_on_priority_type_id" ON "party_relationships" ("priority_type_id")
   (0.0ms)  PRAGMA index_list("party_relationships")
   (0.0ms)  PRAGMA index_info('index_party_relationships_on_priority_type_id')
   (0.0ms)  PRAGMA index_info('index_party_relationships_on_status_type_id')
   (0.2ms)  CREATE INDEX "index_party_relationships_on_relationship_type_id" ON "party_relationships" ("relationship_type_id")
   (0.2ms)  CREATE 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) 
   (0.3ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("individuals")
   (0.2ms)  CREATE INDEX "index_individuals_on_party_id" ON "individuals" ("party_id")
   (0.2ms)  CREATE TABLE "contacts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "party_id" integer, "contact_mechanism_id" integer, "contact_mechanism_type" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("contacts")
   (0.2ms)  CREATE INDEX "index_contacts_on_party_id" ON "contacts" ("party_id")
   (0.0ms)  PRAGMA index_list("contacts")
   (0.0ms)  PRAGMA index_info('index_contacts_on_party_id')
   (0.2ms)  CREATE INDEX "besi_2" ON "contacts" ("contact_mechanism_id", "contact_mechanism_type")
   (0.2ms)  CREATE TABLE "contact_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("contact_types")
   (0.2ms)  CREATE INDEX "index_contact_types_on_parent_id" ON "contact_types" ("parent_id")
   (0.2ms)  CREATE TABLE "contact_purposes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "comments" varchar(255), "internal_identifier" varchar(255), "external_identifier" varchar(255), "external_id_source" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("contact_purposes")
   (0.2ms)  CREATE INDEX "index_contact_purposes_on_parent_id" ON "contact_purposes" ("parent_id")
   (0.2ms)  CREATE TABLE "contact_purposes_contacts" ("contact_id" integer, "contact_purpose_id" integer) 
   (0.0ms)  PRAGMA index_list("contact_purposes_contacts")
   (0.2ms)  CREATE INDEX "contact_purposes_contacts_index" ON "contact_purposes_contacts" ("contact_id", "contact_purpose_id")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("postal_addresses")
   (0.2ms)  CREATE INDEX "index_postal_addresses_on_geo_country_id" ON "postal_addresses" ("geo_country_id")
   (0.0ms)  PRAGMA index_list("postal_addresses")
   (0.0ms)  PRAGMA index_info('index_postal_addresses_on_geo_country_id')
   (0.2ms)  CREATE INDEX "index_postal_addresses_on_geo_zone_id" ON "postal_addresses" ("geo_zone_id")
   (0.2ms)  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) 
   (0.2ms)  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) 
   (0.3ms)  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) 
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("money")
   (0.2ms)  CREATE INDEX "index_money_on_currency_id" ON "money" ("currency_id")
   (0.3ms)  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) 
   (0.0ms)  PRAGMA index_list("currencies")
   (0.2ms)  CREATE INDEX "index_currencies_on_internal_identifier" ON "currencies" ("internal_identifier")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("categories")
   (0.2ms)  CREATE INDEX "category_polymorphic" ON "categories" ("category_record_id", "category_record_type")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("category_classifications")
   (0.2ms)  CREATE INDEX "classification_polymorphic" ON "category_classifications" ("classification_id", "classification_type")
   (0.2ms)  CREATE TABLE "descriptive_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "view_type_id" integer, "internal_identifier" varchar(255), "description" text, "external_identifier" varchar(255), "external_id_source" varchar(255), "described_record_id" integer, "described_record_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("descriptive_assets")
   (0.2ms)  CREATE INDEX "index_descriptive_assets_on_view_type_id" ON "descriptive_assets" ("view_type_id")
   (0.0ms)  PRAGMA index_list("descriptive_assets")
   (0.0ms)  PRAGMA index_info('index_descriptive_assets_on_view_type_id')
   (0.2ms)  CREATE INDEX "described_record_idx" ON "descriptive_assets" ("described_record_id", "described_record_type")
   (0.2ms)  CREATE TABLE "view_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "internal_identifier" varchar(255), "description" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.2ms)  CREATE TABLE "geo_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "iso_code_2" varchar(255), "iso_code_3" varchar(255), "display" boolean DEFAULT 't', "external_id" integer, "created_at" datetime) 
   (0.0ms)  PRAGMA index_list("geo_countries")
   (0.2ms)  CREATE INDEX "index_geo_countries_on_name" ON "geo_countries" ("name")
   (0.0ms)  PRAGMA index_list("geo_countries")
   (0.0ms)  PRAGMA index_info('index_geo_countries_on_name')
   (0.2ms)  CREATE INDEX "index_geo_countries_on_iso_code_2" ON "geo_countries" ("iso_code_2")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("geo_zones")
   (0.2ms)  CREATE INDEX "index_geo_zones_on_geo_country_id" ON "geo_zones" ("geo_country_id")
   (0.0ms)  PRAGMA index_list("geo_zones")
   (0.0ms)  PRAGMA index_info('index_geo_zones_on_geo_country_id')
   (0.1ms)  CREATE INDEX "index_geo_zones_on_zone_name" ON "geo_zones" ("zone_name")
   (0.0ms)  PRAGMA index_list("geo_zones")
   (0.0ms)  PRAGMA index_info('index_geo_zones_on_zone_name')
   (0.0ms)  PRAGMA index_info('index_geo_zones_on_geo_country_id')
   (0.2ms)  CREATE INDEX "index_geo_zones_on_zone_code" ON "geo_zones" ("zone_code")
   (0.2ms)  CREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_by_id" integer, "content" text, "noted_record_id" integer, "noted_record_type" varchar(255), "note_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("notes")
   (0.2ms)  CREATE INDEX "index_notes_on_noted_record_id_and_noted_record_type" ON "notes" ("noted_record_id", "noted_record_type")
   (0.0ms)  PRAGMA index_list("notes")
   (0.0ms)  PRAGMA index_info('index_notes_on_noted_record_id_and_noted_record_type')
   (0.2ms)  CREATE INDEX "index_notes_on_note_type_id" ON "notes" ("note_type_id")
   (0.0ms)  PRAGMA index_list("notes")
   (0.0ms)  PRAGMA index_info('index_notes_on_note_type_id')
   (0.0ms)  PRAGMA index_info('index_notes_on_noted_record_id_and_noted_record_type')
   (0.2ms)  CREATE INDEX "index_notes_on_created_by_id" ON "notes" ("created_by_id")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("note_types")
   (0.2ms)  CREATE INDEX "note_type_record_idx" ON "note_types" ("note_type_record_id", "note_type_record_type")
   (0.2ms)  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) 
   (0.0ms)  PRAGMA index_list("valid_note_types")
   (0.2ms)  CREATE INDEX "valid_note_type_record_idx" ON "valid_note_types" ("valid_note_type_record_id", "valid_note_type_record_type")
   (0.0ms)  PRAGMA index_list("valid_note_types")
   (0.0ms)  PRAGMA index_info('valid_note_type_record_idx')
   (0.2ms)  CREATE INDEX "index_valid_note_types_on_note_type_id" ON "valid_note_types" ("note_type_id")
   (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20080805000020')
   (4.3ms)  commit transaction
Migrating to BaseAppFramework (20080805000096)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("preferences")
   (0.2ms)  CREATE INDEX "index_preferences_on_preference_option_id" ON "preferences" ("preference_option_id")
   (0.0ms)  PRAGMA index_list("preferences")
   (0.0ms)  PRAGMA index_info('index_preferences_on_preference_option_id')
   (0.2ms)  CREATE INDEX "index_preferences_on_preference_type_id" ON "preferences" ("preference_type_id")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("preference_types")
   (0.2ms)  CREATE INDEX "index_preference_types_on_default_pref_option_id" ON "preference_types" ("default_pref_option_id")
   (0.2ms)  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) 
   (0.2ms)  CREATE TABLE "preference_options_preference_types" ("preference_type_id" integer, "preference_option_id" integer) 
   (0.0ms)  PRAGMA index_list("preference_options_preference_types")
   (0.2ms)  CREATE INDEX "pref_opt_pref_type_pref_type_id_idx" ON "preference_options_preference_types" ("preference_type_id")
   (0.0ms)  PRAGMA index_list("preference_options_preference_types")
   (0.0ms)  PRAGMA index_info('pref_opt_pref_type_pref_type_id_idx')
   (0.2ms)  CREATE INDEX "pref_opt_pref_type_pref_opt_id_idx" ON "preference_options_preference_types" ("preference_option_id")
   (0.2ms)  CREATE TABLE "valid_preference_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "preference_type_id" integer, "preferenced_record_id" integer, "preferenced_record_type" varchar(255)) 
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("user_preferences")
   (0.2ms)  CREATE INDEX "index_user_preferences_on_user_id" ON "user_preferences" ("user_id")
   (0.0ms)  PRAGMA index_list("user_preferences")
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_user_id')
   (0.2ms)  CREATE INDEX "index_user_preferences_on_preference_id" ON "user_preferences" ("preference_id")
   (0.0ms)  PRAGMA index_list("user_preferences")
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_preference_id')
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_user_id')
   (0.2ms)  CREATE INDEX "index_user_preferences_on_preferenced_record_id" ON "user_preferences" ("preferenced_record_id")
   (0.0ms)  PRAGMA index_list("user_preferences")
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_preferenced_record_id')
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_preference_id')
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_user_id')
   (0.2ms)  CREATE INDEX "index_user_preferences_on_preferenced_record_type" ON "user_preferences" ("preferenced_record_type")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("app_containers")
   (0.2ms)  CREATE INDEX "index_app_containers_on_user_id" ON "app_containers" ("user_id")
   (0.0ms)  PRAGMA index_list("app_containers")
   (0.0ms)  PRAGMA index_info('index_app_containers_on_user_id')
   (0.2ms)  CREATE INDEX "index_app_containers_on_type" ON "app_containers" ("type")
   (0.2ms)  CREATE 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) 
   (0.2ms)  CREATE TABLE "app_containers_applications" ("app_container_id" integer, "application_id" integer) 
   (0.0ms)  PRAGMA index_list("app_containers_applications")
   (0.2ms)  CREATE INDEX "index_app_containers_applications_on_application_id" ON "app_containers_applications" ("application_id")
   (0.0ms)  PRAGMA index_list("app_containers_applications")
   (0.0ms)  PRAGMA index_info('index_app_containers_applications_on_application_id')
   (0.2ms)  CREATE INDEX "index_app_containers_applications_on_app_container_id" ON "app_containers_applications" ("app_container_id")
   (0.2ms)  CREATE 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) 
   (0.2ms)  CREATE TABLE "applications_widgets" ("application_id" integer, "widget_id" integer) 
   (0.0ms)  PRAGMA index_list("applications_widgets")
   (0.2ms)  CREATE INDEX "index_applications_widgets_on_application_id" ON "applications_widgets" ("application_id")
   (0.0ms)  PRAGMA index_list("applications_widgets")
   (0.0ms)  PRAGMA index_info('index_applications_widgets_on_application_id')
   (0.2ms)  CREATE INDEX "index_applications_widgets_on_widget_id" ON "applications_widgets" ("widget_id")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("tree_menu_node_defs")
   (0.2ms)  CREATE INDEX "index_tree_menu_node_defs_on_parent_id" ON "tree_menu_node_defs" ("parent_id")
   (0.2ms)  CREATE 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) 
   (0.2ms)  CREATE TABLE "valid_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "configured_item_id" integer, "configured_item_type" varchar(255), "configuration_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("valid_configurations")
   (0.2ms)  CREATE INDEX "configured_item_poly_idx" ON "valid_configurations" ("configured_item_id", "configured_item_type")
   (0.0ms)  PRAGMA index_list("valid_configurations")
   (0.0ms)  PRAGMA index_info('configured_item_poly_idx')
   (0.2ms)  CREATE INDEX "index_valid_configurations_on_configuration_id" ON "valid_configurations" ("configuration_id")
   (0.2ms)  CREATE TABLE "configuration_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "configuration_id" integer, "configuration_item_type_id" integer, "configuration_option_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.0ms)  PRAGMA index_list("configuration_items")
   (0.2ms)  CREATE INDEX "index_configuration_items_on_configuration_id" ON "configuration_items" ("configuration_id")
   (0.0ms)  PRAGMA index_list("configuration_items")
   (0.0ms)  PRAGMA index_info('index_configuration_items_on_configuration_id')
   (0.2ms)  CREATE INDEX "index_configuration_items_on_configuration_item_type_id" ON "configuration_items" ("configuration_item_type_id")
   (0.0ms)  PRAGMA index_list("configuration_items")
   (0.0ms)  PRAGMA index_info('index_configuration_items_on_configuration_item_type_id')
   (0.0ms)  PRAGMA index_info('index_configuration_items_on_configuration_id')
   (0.2ms)  CREATE INDEX "index_configuration_items_on_configuration_option_id" ON "configuration_items" ("configuration_option_id")
   (0.2ms)  CREATE TABLE "configuration_item_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "lft" integer, "rgt" integer, "description" varchar(255), "internal_identifier" varchar(255), "allow_user_defined_options" boolean DEFAULT 'f', "is_multi_optional" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 
   (0.2ms)  CREATE TABLE "configuration_item_types_configurations" ("configuration_item_type_id" integer, "configuration_id" integer) 
   (0.0ms)  PRAGMA index_list("configuration_item_types_configurations")
   (0.2ms)  CREATE INDEX "conf_conf_type_id_item_idx" ON "configuration_item_types_configurations" ("configuration_item_type_id")
   (0.0ms)  PRAGMA index_list("configuration_item_types_configurations")
   (0.0ms)  PRAGMA index_info('conf_conf_type_id_item_idx')
   (0.2ms)  CREATE INDEX "conf_id_idx" ON "configuration_item_types_configurations" ("configuration_id")
   (0.0ms)  PRAGMA index_list("configuration_item_types_configurations")
   (0.0ms)  PRAGMA index_info('conf_id_idx')
   (0.0ms)  PRAGMA index_info('conf_conf_type_id_item_idx')
   (0.6ms)  CREATE UNIQUE INDEX "conf_config_type_uniq_idx" ON "configuration_item_types_configurations" ("configuration_item_type_id", "configuration_id")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("configuration_options")
   (0.2ms)  CREATE INDEX "index_configuration_options_on_value" ON "configuration_options" ("value")
   (0.0ms)  PRAGMA index_list("configuration_options")
   (0.0ms)  PRAGMA index_info('index_configuration_options_on_value')
   (0.2ms)  CREATE INDEX "index_configuration_options_on_internal_identifier" ON "configuration_options" ("internal_identifier")
   (0.0ms)  PRAGMA index_list("configuration_options")
   (0.0ms)  PRAGMA index_info('index_configuration_options_on_internal_identifier')
   (0.0ms)  PRAGMA index_info('index_configuration_options_on_value')
   (0.2ms)  CREATE INDEX "index_configuration_options_on_user_defined" ON "configuration_options" ("user_defined")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("configuration_item_types_configuration_options")
   (0.2ms)  CREATE INDEX "conf_item_type_conf_opt_id_item_idx" ON "configuration_item_types_configuration_options" ("configuration_item_type_id")
   (0.0ms)  PRAGMA index_list("configuration_item_types_configuration_options")
   (0.0ms)  PRAGMA index_info('conf_item_type_conf_opt_id_item_idx')
   (0.2ms)  CREATE INDEX "conf_item_type_conf_opt_id_opt_idx" ON "configuration_item_types_configuration_options" ("configuration_option_id")
   (0.2ms)  CREATE TABLE "configuration_items_configuration_options" ("configuration_item_id" integer, "configuration_option_id" integer) 
   (0.0ms)  PRAGMA index_list("configuration_items_configuration_options")
   (0.2ms)  CREATE INDEX "conf_item_conf_opt_id_item_idx" ON "configuration_items_configuration_options" ("configuration_item_id")
   (0.0ms)  PRAGMA index_list("configuration_items_configuration_options")
   (0.0ms)  PRAGMA index_info('conf_item_conf_opt_id_item_idx')
   (0.2ms)  CREATE INDEX "conf_item_conf_opt_id_opt_idx" ON "configuration_items_configuration_options" ("configuration_option_id")
   (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20080805000096')
   (3.8ms)  commit transaction
Migrating to DynamicForms (20110530193446)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE 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) 
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("dynamic_form_documents")
   (0.2ms)  CREATE INDEX "index_dynamic_form_documents_on_dynamic_form_model_id" ON "dynamic_form_documents" ("dynamic_form_model_id")
   (0.0ms)  PRAGMA index_list("dynamic_form_documents")
   (0.0ms)  PRAGMA index_info('index_dynamic_form_documents_on_dynamic_form_model_id')
   (0.2ms)  CREATE INDEX "index_dynamic_form_documents_on_type" ON "dynamic_form_documents" ("type")
   (0.3ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("dynamic_forms")
   (0.2ms)  CREATE INDEX "index_dynamic_forms_on_created_by_id" ON "dynamic_forms" ("created_by_id")
   (0.0ms)  PRAGMA index_list("dynamic_forms")
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_created_by_id')
   (0.2ms)  CREATE INDEX "index_dynamic_forms_on_updated_by_id" ON "dynamic_forms" ("updated_by_id")
   (0.1ms)  PRAGMA index_list("dynamic_forms")
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_updated_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_created_by_id')
   (0.2ms)  CREATE INDEX "index_dynamic_forms_on_dynamic_form_model_id" ON "dynamic_forms" ("dynamic_form_model_id")
   (0.0ms)  PRAGMA index_list("dynamic_forms")
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_dynamic_form_model_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_updated_by_id')
   (0.1ms)  PRAGMA index_info('index_dynamic_forms_on_created_by_id')
   (0.2ms)  CREATE INDEX "index_dynamic_forms_on_model_name" ON "dynamic_forms" ("model_name")
   (0.1ms)  PRAGMA index_list("dynamic_forms")
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_model_name')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_dynamic_form_model_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_updated_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_created_by_id')
   (0.2ms)  CREATE INDEX "index_dynamic_forms_on_internal_identifier" ON "dynamic_forms" ("internal_identifier")
   (0.3ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("dynamic_data")
   (0.2ms)  CREATE INDEX "index_dynamic_data_on_created_with_form_id" ON "dynamic_data" ("created_with_form_id")
   (0.0ms)  PRAGMA index_list("dynamic_data")
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_with_form_id')
   (0.2ms)  CREATE INDEX "index_dynamic_data_on_updated_with_form_id" ON "dynamic_data" ("updated_with_form_id")
   (0.0ms)  PRAGMA index_list("dynamic_data")
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_with_form_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_with_form_id')
   (0.2ms)  CREATE INDEX "index_dynamic_data_on_created_by_id" ON "dynamic_data" ("created_by_id")
   (0.1ms)  PRAGMA index_list("dynamic_data")
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_with_form_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_with_form_id')
   (0.2ms)  CREATE INDEX "index_dynamic_data_on_updated_by_id" ON "dynamic_data" ("updated_by_id")
   (0.0ms)  PRAGMA index_list("dynamic_data")
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_with_form_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_with_form_id')
   (0.2ms)  CREATE INDEX "index_dynamic_data_on_reference_type" ON "dynamic_data" ("reference_type")
   (0.0ms)  PRAGMA index_list("dynamic_data")
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_reference_type')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_with_form_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_with_form_id')
   (0.2ms)  CREATE INDEX "index_dynamic_data_on_reference_id" ON "dynamic_data" ("reference_id")
   (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20110530193446')
   (3.0ms)  commit transaction
Migrating to CreateCompassAeInstance (20110913145329)
   (0.1ms)  begin transaction
   (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20110913145329')
   (1.4ms)  commit transaction
Migrating to CreateHasAttributeTables (20111117183144)
   (0.0ms)  begin transaction
   (0.5ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("attribute_types")
   (0.2ms)  CREATE INDEX ":attribute_types_iid_idx" ON "attribute_types" ("internal_identifier")
   (0.2ms)  CREATE 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) 
   (0.0ms)  PRAGMA index_list("attribute_values")
   (0.2ms)  CREATE INDEX "attribute_values_attributed_record_idx" ON "attribute_values" ("attributed_record_id", "attributed_record_type")
   (0.0ms)  PRAGMA index_list("attribute_values")
   (0.0ms)  PRAGMA index_info('attribute_values_attributed_record_idx')
   (0.2ms)  CREATE INDEX "attribute_values_attributed_type_idx" ON "attribute_values" ("attribute_type_id")
   (0.0ms)  PRAGMA index_list("attribute_values")
   (0.0ms)  PRAGMA index_info('attribute_values_attributed_type_idx')
   (0.0ms)  PRAGMA index_info('attribute_values_attributed_record_idx')
   (0.2ms)  CREATE INDEX "attribute_values_value_idx" ON "attribute_values" ("value")
   (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20111117183144')
   (2.9ms)  commit transaction
Migrating to AddIsTemplateToConfigurations (20120316152543)
   (0.1ms)  begin transaction
   (0.8ms)  ALTER TABLE "configurations" ADD "is_template" boolean DEFAULT 'f'
   (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20120316152543')
   (2.2ms)  commit transaction
Migrating to UpdateAppContainer (20120320182253)
   (0.1ms)  begin transaction
   (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20120320182253')
   (1.7ms)  commit transaction
Migrating to RemoveFileSystemLoaderColumn (20120325123722)
   (0.1ms)  begin transaction
   (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20120325123722')
   (1.7ms)  commit transaction
Migrating to AddBaseUrlToApplication (20120411151848)
   (0.1ms)  begin transaction
   (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20120411151848')
   (1.7ms)  commit transaction
Migrating to AddUserDefinedToConfigOption (20120427000446)
   (0.1ms)  begin transaction
   (0.4ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20120427000446')
   (1.7ms)  commit transaction
Migrating to UpdateConfigurationJoinTables (20120429130430)
   (0.1ms)  begin transaction
   (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES ('20120429130430')
   (1.5ms)  commit transaction
   (3.3ms)  select sqlite_version(*)
   (0.1ms)  SELECT "schema_migrations"."version" FROM "schema_migrations" 
   (0.0ms)  PRAGMA index_list("app_containers")
   (0.0ms)  PRAGMA index_info('index_app_containers_on_type')
   (0.0ms)  PRAGMA index_info('index_app_containers_on_user_id')
   (0.0ms)  PRAGMA index_list("app_containers_applications")
   (0.0ms)  PRAGMA index_info('index_app_containers_applications_on_app_container_id')
   (0.0ms)  PRAGMA index_info('index_app_containers_applications_on_application_id')
   (0.1ms)  PRAGMA index_list("applications")
   (0.0ms)  PRAGMA index_list("applications_widgets")
   (0.0ms)  PRAGMA index_info('index_applications_widgets_on_widget_id')
   (0.0ms)  PRAGMA index_info('index_applications_widgets_on_application_id')
   (0.0ms)  PRAGMA index_list("attribute_types")
   (0.0ms)  PRAGMA index_info(':attribute_types_iid_idx')
   (0.0ms)  PRAGMA index_list("attribute_values")
   (0.0ms)  PRAGMA index_info('attribute_values_value_idx')
   (0.0ms)  PRAGMA index_info('attribute_values_attributed_type_idx')
   (0.0ms)  PRAGMA index_info('attribute_values_attributed_record_idx')
   (0.0ms)  PRAGMA index_list("audit_log_item_types")
   (0.0ms)  PRAGMA index_list("audit_log_items")
   (0.0ms)  PRAGMA index_list("audit_log_types")
   (0.0ms)  PRAGMA index_list("audit_logs")
   (0.0ms)  PRAGMA index_info('event_record_index')
   (0.0ms)  PRAGMA index_info('index_audit_logs_on_party_id')
   (0.0ms)  PRAGMA index_list("capabilities")
   (0.0ms)  PRAGMA index_info('index_capabilities_on_capability_type_id')
   (0.0ms)  PRAGMA index_list("capabilities_capable_models")
   (0.0ms)  PRAGMA index_info('index_capabilities_capable_models_on_capability_id')
   (0.0ms)  PRAGMA index_info('index_capabilities_capable_models_on_capable_model_id')
   (0.0ms)  PRAGMA index_list("capability_types")
   (0.0ms)  PRAGMA index_list("capable_models")
   (0.0ms)  PRAGMA index_info('capable_model_record_idx')
   (0.0ms)  PRAGMA index_list("categories")
   (0.0ms)  PRAGMA index_info('category_polymorphic')
   (0.0ms)  PRAGMA index_list("category_classifications")
   (0.0ms)  PRAGMA index_info('classification_polymorphic')
   (0.0ms)  PRAGMA index_list("compass_ae_instances")
   (0.0ms)  PRAGMA index_list("configuration_item_types")
   (0.0ms)  PRAGMA index_list("configuration_item_types_configuration_options")
   (0.0ms)  PRAGMA index_info('conf_item_type_conf_opt_id_opt_idx')
   (0.0ms)  PRAGMA index_info('conf_item_type_conf_opt_id_item_idx')
   (0.0ms)  PRAGMA index_list("configuration_item_types_configurations")
   (0.0ms)  PRAGMA index_info('conf_config_type_uniq_idx')
   (0.0ms)  PRAGMA index_info('conf_id_idx')
   (0.0ms)  PRAGMA index_info('conf_conf_type_id_item_idx')
   (0.0ms)  PRAGMA index_list("configuration_items")
   (0.0ms)  PRAGMA index_info('index_configuration_items_on_configuration_option_id')
   (0.0ms)  PRAGMA index_info('index_configuration_items_on_configuration_item_type_id')
   (0.0ms)  PRAGMA index_info('index_configuration_items_on_configuration_id')
   (0.0ms)  PRAGMA index_list("configuration_items_configuration_options")
   (0.0ms)  PRAGMA index_info('conf_item_conf_opt_id_opt_idx')
   (0.0ms)  PRAGMA index_info('conf_item_conf_opt_id_item_idx')
   (0.0ms)  PRAGMA index_list("configuration_options")
   (0.0ms)  PRAGMA index_info('index_configuration_options_on_user_defined')
   (0.0ms)  PRAGMA index_info('index_configuration_options_on_internal_identifier')
   (0.0ms)  PRAGMA index_info('index_configuration_options_on_value')
   (0.0ms)  PRAGMA index_list("configurations")
   (0.0ms)  PRAGMA index_list("contact_purposes")
   (0.0ms)  PRAGMA index_info('index_contact_purposes_on_parent_id')
   (0.0ms)  PRAGMA index_list("contact_purposes_contacts")
   (0.0ms)  PRAGMA index_info('contact_purposes_contacts_index')
   (0.0ms)  PRAGMA index_list("contact_types")
   (0.0ms)  PRAGMA index_info('index_contact_types_on_parent_id')
   (0.0ms)  PRAGMA index_list("contacts")
   (0.0ms)  PRAGMA index_info('besi_2')
   (0.0ms)  PRAGMA index_info('index_contacts_on_party_id')
   (0.0ms)  PRAGMA index_list("currencies")
   (0.0ms)  PRAGMA index_info('index_currencies_on_internal_identifier')
   (0.0ms)  PRAGMA index_list("delayed_jobs")
   (0.0ms)  PRAGMA index_info('delayed_jobs_priority')
   (0.0ms)  PRAGMA index_list("descriptive_assets")
   (0.0ms)  PRAGMA index_info('described_record_idx')
   (0.0ms)  PRAGMA index_info('index_descriptive_assets_on_view_type_id')
   (0.1ms)  PRAGMA index_list("dynamic_data")
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_reference_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_reference_type')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_updated_with_form_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_data_on_created_with_form_id')
   (0.0ms)  PRAGMA index_list("dynamic_form_documents")
   (0.0ms)  PRAGMA index_info('index_dynamic_form_documents_on_type')
   (0.0ms)  PRAGMA index_info('index_dynamic_form_documents_on_dynamic_form_model_id')
   (0.0ms)  PRAGMA index_list("dynamic_form_models")
   (0.0ms)  PRAGMA index_list("dynamic_forms")
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_internal_identifier')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_model_name')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_dynamic_form_model_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_updated_by_id')
   (0.0ms)  PRAGMA index_info('index_dynamic_forms_on_created_by_id')
   (0.0ms)  PRAGMA index_list("email_addresses")
   (0.0ms)  PRAGMA index_list("file_assets")
   (0.0ms)  PRAGMA index_info('index_file_assets_on_directory')
   (0.0ms)  PRAGMA index_info('index_file_assets_on_name')
   (0.0ms)  PRAGMA index_info('file_asset_holder_idx')
   (0.0ms)  PRAGMA index_info('index_file_assets_on_type')
   (0.0ms)  PRAGMA index_list("geo_countries")
   (0.0ms)  PRAGMA index_info('index_geo_countries_on_iso_code_2')
   (0.0ms)  PRAGMA index_info('index_geo_countries_on_name')
   (0.0ms)  PRAGMA index_list("geo_zones")
   (0.0ms)  PRAGMA index_info('index_geo_zones_on_zone_code')
   (0.0ms)  PRAGMA index_info('index_geo_zones_on_zone_name')
   (0.0ms)  PRAGMA index_info('index_geo_zones_on_geo_country_id')
   (0.1ms)  PRAGMA index_list("individuals")
   (0.0ms)  PRAGMA index_info('index_individuals_on_party_id')
   (0.0ms)  PRAGMA index_list("money")
   (0.0ms)  PRAGMA index_info('index_money_on_currency_id')
   (0.0ms)  PRAGMA index_list("note_types")
   (0.0ms)  PRAGMA index_info('note_type_record_idx')
   (0.0ms)  PRAGMA index_list("notes")
   (0.0ms)  PRAGMA index_info('index_notes_on_created_by_id')
   (0.0ms)  PRAGMA index_info('index_notes_on_note_type_id')
   (0.0ms)  PRAGMA index_info('index_notes_on_noted_record_id_and_noted_record_type')
   (0.0ms)  PRAGMA index_list("organizations")
   (0.0ms)  PRAGMA index_list("parties")
   (0.0ms)  PRAGMA index_info('besi_1')
   (0.0ms)  PRAGMA index_list("party_relationships")
   (0.0ms)  PRAGMA index_info('index_party_relationships_on_relationship_type_id')
   (0.0ms)  PRAGMA index_info('index_party_relationships_on_priority_type_id')
   (0.0ms)  PRAGMA index_info('index_party_relationships_on_status_type_id')
   (0.0ms)  PRAGMA index_list("party_roles")
   (0.0ms)  PRAGMA index_info('index_party_roles_on_role_type_id')
   (0.0ms)  PRAGMA index_info('index_party_roles_on_party_id')
   (0.0ms)  PRAGMA index_list("party_search_facts")
   (0.0ms)  PRAGMA index_list("phone_numbers")
   (0.0ms)  PRAGMA index_list("postal_addresses")
   (0.0ms)  PRAGMA index_info('index_postal_addresses_on_geo_zone_id')
   (0.0ms)  PRAGMA index_info('index_postal_addresses_on_geo_country_id')
   (0.0ms)  PRAGMA index_list("preference_options")
   (0.0ms)  PRAGMA index_list("preference_options_preference_types")
   (0.0ms)  PRAGMA index_info('pref_opt_pref_type_pref_opt_id_idx')
   (0.0ms)  PRAGMA index_info('pref_opt_pref_type_pref_type_id_idx')
   (0.0ms)  PRAGMA index_list("preference_types")
   (0.0ms)  PRAGMA index_info('index_preference_types_on_default_pref_option_id')
   (0.0ms)  PRAGMA index_list("preferences")
   (0.0ms)  PRAGMA index_info('index_preferences_on_preference_type_id')
   (0.0ms)  PRAGMA index_info('index_preferences_on_preference_option_id')
   (0.0ms)  PRAGMA index_list("relationship_types")
   (0.0ms)  PRAGMA index_info('index_relationship_types_on_valid_to_role_type_id')
   (0.0ms)  PRAGMA index_info('index_relationship_types_on_valid_from_role_type_id')
   (0.0ms)  PRAGMA index_list("role_types")
   (0.0ms)  PRAGMA index_list("roles")
   (0.0ms)  PRAGMA index_list("roles_secured_models")
   (0.0ms)  PRAGMA index_info('index_roles_secured_models_on_role_id')
   (0.0ms)  PRAGMA index_info('index_roles_secured_models_on_secured_model_id')
   (0.0ms)  PRAGMA index_list("secured_models")
   (0.0ms)  PRAGMA index_info('secured_record_idx')
   (0.0ms)  PRAGMA index_list("sessions")
   (0.0ms)  PRAGMA index_info('index_sessions_on_updated_at')
   (0.0ms)  PRAGMA index_info('index_sessions_on_session_id')
   (0.0ms)  PRAGMA index_list("tree_menu_node_defs")
   (0.0ms)  PRAGMA index_info('index_tree_menu_node_defs_on_parent_id')
   (0.0ms)  PRAGMA index_list("user_preferences")
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_preferenced_record_type')
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_preferenced_record_id')
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_preference_id')
   (0.0ms)  PRAGMA index_info('index_user_preferences_on_user_id')
   (0.1ms)  PRAGMA index_list("users")
   (0.0ms)  PRAGMA index_info('index_users_on_activation_token')
   (0.0ms)  PRAGMA index_info('index_users_on_reset_password_token')
   (0.0ms)  PRAGMA index_info('index_users_on_remember_me_token')
   (0.0ms)  PRAGMA index_info('activity_idx')
   (0.0ms)  PRAGMA index_info('index_users_on_username')
   (0.0ms)  PRAGMA index_info('index_users_on_email')
   (0.0ms)  PRAGMA index_list("valid_configurations")
   (0.0ms)  PRAGMA index_info('index_valid_configurations_on_configuration_id')
   (0.0ms)  PRAGMA index_info('configured_item_poly_idx')
   (0.0ms)  PRAGMA index_list("valid_note_types")
   (0.0ms)  PRAGMA index_info('index_valid_note_types_on_note_type_id')
   (0.0ms)  PRAGMA index_info('valid_note_type_record_idx')
   (0.0ms)  PRAGMA index_list("valid_preference_types")
   (0.0ms)  PRAGMA index_list("view_types")
   (0.0ms)  PRAGMA index_list("widgets")
   (5.2ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  SAVEPOINT active_record_1
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  DynamicFormModel Load (0.2ms)  SELECT "dynamic_form_models".* FROM "dynamic_form_models" WHERE "dynamic_form_models"."model_name" = 'DynamicFormDocument' LIMIT 1
   (0.1ms)  rollback transaction
   (0.2ms)  begin transaction
   (0.1ms)  SAVEPOINT active_record_1
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  DynamicFormModel Load (0.2ms)  SELECT "dynamic_form_models".* FROM "dynamic_form_models" WHERE "dynamic_form_models"."model_name" = 'DynamicFormDocument' LIMIT 1
   (0.1ms)  SAVEPOINT active_record_1
  SQL (8.4ms)  INSERT INTO "dynamic_form_documents" ("created_at", "dynamic_form_model_id", "type", "updated_at") VALUES (?, ?, ?, ?)  [["created_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00], ["dynamic_form_model_id", nil], ["type", nil], ["updated_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00]]
  SQL (0.7ms)  INSERT INTO "dynamic_data" ("created_at", "created_by_id", "created_with_form_id", "dynamic_attributes", "reference_id", "reference_type", "updated_at", "updated_by_id", "updated_with_form_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)  [["created_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00], ["created_by_id", nil], ["created_with_form_id", nil], ["dynamic_attributes", "--- {}\n"], ["reference_id", 1], ["reference_type", "DynamicFormDocument"], ["updated_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00], ["updated_by_id", nil], ["updated_with_form_id", nil]]
   (0.5ms)  UPDATE "dynamic_data" SET "updated_at" = '2012-06-06 14:37:59.468822', "dynamic_attributes" = '--- {}
' WHERE "dynamic_data"."id" = 1
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (1.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.7ms)  INSERT INTO "dynamic_form_models" ("created_at", "model_name", "updated_at") VALUES (?, ?, ?)  [["created_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00], ["model_name", nil], ["updated_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.7ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  DynamicForm Exists (0.2ms)  SELECT 1 FROM "dynamic_forms" WHERE ("dynamic_forms"."internal_identifier" IS NULL AND "dynamic_forms"."model_name" IS NULL) LIMIT 1
  SQL (0.8ms)  INSERT INTO "dynamic_forms" ("created_at", "created_by_id", "default", "definition", "description", "dynamic_form_model_id", "internal_identifier", "model_name", "updated_at", "updated_by_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  [["created_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00], ["created_by_id", nil], ["default", nil], ["definition", nil], ["description", nil], ["dynamic_form_model_id", nil], ["internal_identifier", nil], ["model_name", nil], ["updated_at", Wed, 06 Jun 2012 14:37:59 UTC +00:00], ["updated_by_id", nil]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.7ms)  rollback transaction