spec/dummy/log/development.log in has_vcards-1.0.0.rc0 vs spec/dummy/log/development.log in has_vcards-1.0.0
- old
+ new
@@ -1,2513 +1,229 @@
- [1m[36m (7.1ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (0.2ms)[0m select sqlite_version(*)
- [1m[36m (5.2ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.3ms)[0m SELECT "schema_migrations".* FROM "schema_migrations"
-Migrating to CreateVcardTables (0)
- [1m[36m (0.2ms)[0m [1mbegin transaction[0m
- [1m[35m (0.9ms)[0m CREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255))
- [1m[36m (0.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (0.5ms)[0m CREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255))
- [1m[36m (0.4ms)[0m [1mCREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (0.5ms)[0m [1mCREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (0.2ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (0.4ms)[0m CREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")
- [1m[36m (0.6ms)[0m [1mCREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255)) [0m
- [1m[35m (0.4ms)[0m CREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")
- [1m[36mSQL (0.5ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES (?)[0m [["version", "0"]]
- [1m[35m (5.0ms)[0m commit transaction
-Migrating to AddIndexToVcards (20120119091225)
- [1m[36m (0.2ms)[0m [1mbegin transaction[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (0.7ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35mSQL (0.4ms)[0m INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20120119091225"]]
- [1m[36m (4.8ms)[0m [1mcommit transaction[0m
-Migrating to AddTimeStampsToHasVcardsTables (20120813065226)
- [1m[35m (0.2ms)[0m begin transaction
- [1m[36m (0.9ms)[0m [1mALTER TABLE "addresses" ADD "created_at" datetime[0m
- [1m[35m (0.6ms)[0m ALTER TABLE "addresses" ADD "updated_at" datetime
- [1m[36m (0.6ms)[0m [1mALTER TABLE "phone_numbers" ADD "created_at" datetime[0m
- [1m[35m (0.7ms)[0m ALTER TABLE "phone_numbers" ADD "updated_at" datetime
- [1m[36m (0.7ms)[0m [1mALTER TABLE "vcards" ADD "created_at" datetime[0m
- [1m[35m (0.6ms)[0m ALTER TABLE "vcards" ADD "updated_at" datetime
- [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES (?)[0m [["version", "20120813065226"]]
- [1m[35m (6.1ms)[0m commit transaction
-Migrating to CreateHonorificPrefixesTable (20121113120000)
- [1m[36m (0.2ms)[0m [1mbegin transaction[0m
- [1m[35m (0.5ms)[0m ALTER TABLE "honorific_prefixes" ADD "sex" integer
-SQLite3::SQLException: no such table: honorific_prefixes: ALTER TABLE "honorific_prefixes" ADD "sex" integer
- [1m[36m (0.2ms)[0m [1mrollback transaction[0m
- [1m[36mActiveRecord::SchemaMigration Load (0.4ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
-Migrating to CreateHonorificPrefixesTable (20121113120000)
- [1m[35m (0.2ms)[0m begin transaction
- [1m[36m (1.0ms)[0m [1mCREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer) [0m
- [1m[35mSQL (0.5ms)[0m INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20121113120000"]]
- [1m[36m (6.4ms)[0m [1mcommit transaction[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.5ms)[0m SELECT "schema_migrations".* FROM "schema_migrations"
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='addresses_vcard_id_index' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='addresses_vcard_id_index' AND type='index'
-[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='phone_numbers_vcard_id_index' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='phone_numbers_vcard_id_index' AND type='index'
-
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (6.6ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (5.7ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.6ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (5.6ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.4ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (8.4ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.3ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.4ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (5.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (5.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (7.4ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (7.1ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (5.5ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (6.2ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (5.3ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.4ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (7.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (6.5ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (5.7ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.3ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (5.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36mVcard Load (0.5ms)[0m [1mSELECT "vcards".* FROM "vcards" ORDER BY "vcards"."id" ASC LIMIT 1[0m
- [1m[36m (5.9ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (5.0ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.4ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.3ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.2ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.2ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.3ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (5.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (5.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (6.1ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (5.3ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.1ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.1ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (5.5ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (6.6ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (5.7ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.3ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (7.2ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.5ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (5.0ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (5.2ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (6.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (6.7ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (5.3ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (5.5ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.6ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (5.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (6.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (24.1ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (12.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (15.0ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (13.2ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.6ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (21.8ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (13.7ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (13.8ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (29.2ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (13.7ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (28.9ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (32.0ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.5ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (15.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (15.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (6.8ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (6.1ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.7ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.5ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (5.1ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.6ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.5ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (6.1ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.5ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.3ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (5.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (7.3ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.3ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.5ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.9ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (5.2ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.9ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (6.0ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (7.3ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.4ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (6.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (14.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (8.1ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.5ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.7ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (12.1ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (6.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (6.9ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.5ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.1ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (6.3ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.2ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.3ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (8.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (8.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (5.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (9.4ms)[0m [1mCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "addresses" ("vcard_id")[0m
- [1m[35m (4.7ms)[0m CREATE TABLE "honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.8ms)[0m [1mCREATE TABLE "phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (5.1ms)[0m CREATE INDEX "index_phone_numbers_on_object_id_and_object_type" ON "phone_numbers" ("object_id", "object_type")
- [1m[36m (0.2ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (4.5ms)[0m CREATE INDEX "index_phone_numbers_on_phone_number_type" ON "phone_numbers" ("phone_number_type")
- [1m[36m (0.1ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "phone_numbers" ("vcard_id")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "index_vcards_on_active" ON "vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_vcards_on_active' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_vcards_on_object_id_and_object_type" ON "vcards" ("object_id", "object_type")[0m
- [1m[35m (5.3ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (4.8ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.1ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.4ms)[0m [1mCREATE TABLE `addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (37.9ms)[0m CREATE INDEX `addresses_vcard_id_index` ON `addresses` (`vcard_id`)
- [1m[36m (6.0ms)[0m [1mCREATE TABLE `honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB[0m
- [1m[35m (5.7ms)[0m CREATE TABLE `phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (32.9ms)[0m [1mCREATE INDEX `index_phone_numbers_on_object_id_and_object_type` ON `phone_numbers` (`object_id`, `object_type`) [0m
- [1m[35m (34.6ms)[0m CREATE INDEX `index_phone_numbers_on_phone_number_type` ON `phone_numbers` (`phone_number_type`)
- [1m[36m (31.8ms)[0m [1mCREATE INDEX `phone_numbers_vcard_id_index` ON `phone_numbers` (`vcard_id`) [0m
- [1m[35m (5.8ms)[0m CREATE TABLE `vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (33.6ms)[0m [1mCREATE INDEX `index_vcards_on_active` ON `vcards` (`active`) [0m
- [1m[35m (33.0ms)[0m CREATE INDEX `index_vcards_on_object_id_and_object_type` ON `vcards` (`object_id`, `object_type`)
- [1m[36m (5.6ms)[0m [1mCREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB[0m
- [1m[35m (35.0ms)[0m CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)
- [1m[36m (0.6ms)[0m [1mSELECT version FROM `schema_migrations`[0m
- [1m[35m (3.3ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20121113120000')
- [1m[36m (2.3ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('20120813065226')[0m
- [1m[35m (1.3ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20120119091225')
- [1m[36m (2.4ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('0')[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.6ms)[0m SELECT `schema_migrations`.* FROM `schema_migrations`
- [1m[36mActiveRecord::SchemaMigration Load (0.3ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
-Migrating to RenameTablesForNamespacing (20140617113710)
- [1m[35m (10.8ms)[0m RENAME TABLE `addresses` TO `has_vcards_addresses`
- [1m[36m (1.0ms)[0m [1mRENAME TABLE `honorific_prefix` TO `has_vcards_honorific_prefix`[0m
-Mysql2::Error: Can't find file: './has_vcard_test/honorific_prefix.frm' (errno: 2): RENAME TABLE `honorific_prefix` TO `has_vcards_honorific_prefix`
- [1m[36m (21.3ms)[0m [1mDROP DATABASE IF EXISTS `has_vcard_test`[0m
- [1m[35m (0.7ms)[0m CREATE DATABASE `has_vcard_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`
- [1m[36m (6.5ms)[0m [1mCREATE TABLE `addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (34.6ms)[0m CREATE INDEX `addresses_vcard_id_index` ON `addresses` (`vcard_id`)
- [1m[36m (5.2ms)[0m [1mCREATE TABLE `honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB[0m
- [1m[35m (5.2ms)[0m CREATE TABLE `phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (37.1ms)[0m [1mCREATE INDEX `index_phone_numbers_on_object_id_and_object_type` ON `phone_numbers` (`object_id`, `object_type`) [0m
- [1m[35m (37.0ms)[0m CREATE INDEX `index_phone_numbers_on_phone_number_type` ON `phone_numbers` (`phone_number_type`)
- [1m[36m (37.3ms)[0m [1mCREATE INDEX `phone_numbers_vcard_id_index` ON `phone_numbers` (`vcard_id`) [0m
- [1m[35m (6.1ms)[0m CREATE TABLE `vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (37.5ms)[0m [1mCREATE INDEX `index_vcards_on_active` ON `vcards` (`active`) [0m
- [1m[35m (35.8ms)[0m CREATE INDEX `index_vcards_on_object_id_and_object_type` ON `vcards` (`object_id`, `object_type`)
- [1m[36m (5.4ms)[0m [1mCREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB[0m
- [1m[35m (34.7ms)[0m CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)
- [1m[36m (0.6ms)[0m [1mSELECT version FROM `schema_migrations`[0m
- [1m[35m (2.8ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20121113120000')
- [1m[36m (2.1ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('20120813065226')[0m
- [1m[35m (1.3ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20120119091225')
- [1m[36m (2.4ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('0')[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.7ms)[0m SELECT `schema_migrations`.* FROM `schema_migrations`
- [1m[36m (4.7ms)[0m [1mDROP TABLE `addresses`[0m
- [1m[35m (11.3ms)[0m CREATE TABLE `addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (34.3ms)[0m [1mCREATE INDEX `addresses_vcard_id_index` ON `addresses` (`vcard_id`) [0m
- [1m[35m (3.7ms)[0m DROP TABLE `honorific_prefixes`
- [1m[36m (5.1ms)[0m [1mCREATE TABLE `honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB[0m
- [1m[35m (3.4ms)[0m DROP TABLE `phone_numbers`
- [1m[36m (7.3ms)[0m [1mCREATE TABLE `phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (35.3ms)[0m CREATE INDEX `index_phone_numbers_on_object_id_and_object_type` ON `phone_numbers` (`object_id`, `object_type`)
- [1m[36m (43.6ms)[0m [1mCREATE INDEX `index_phone_numbers_on_phone_number_type` ON `phone_numbers` (`phone_number_type`) [0m
- [1m[35m (35.8ms)[0m CREATE INDEX `phone_numbers_vcard_id_index` ON `phone_numbers` (`vcard_id`)
- [1m[36m (9.6ms)[0m [1mDROP TABLE `vcards`[0m
- [1m[35m (6.6ms)[0m CREATE TABLE `vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (53.0ms)[0m [1mCREATE INDEX `index_vcards_on_active` ON `vcards` (`active`) [0m
- [1m[35m (40.1ms)[0m CREATE INDEX `index_vcards_on_object_id_and_object_type` ON `vcards` (`object_id`, `object_type`)
- [1m[36m (0.5ms)[0m [1mSELECT version FROM `schema_migrations`[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.2ms)[0m SELECT `schema_migrations`.* FROM `schema_migrations`
-Migrating to RenameTablesForNamespacing (20140617113710)
- [1m[36m (11.2ms)[0m [1mRENAME TABLE `addresses` TO `has_vcards_addresses`[0m
- [1m[35m (0.8ms)[0m RENAME TABLE `honorific_prefix` TO `has_vcards_honorific_prefix`
-Mysql2::Error: Can't find file: './has_vcard_test/honorific_prefix.frm' (errno: 2): RENAME TABLE `honorific_prefix` TO `has_vcards_honorific_prefix`
- [1m[36mActiveRecord::SchemaMigration Load (0.3ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
-Migrating to RenameTablesForNamespacing (20140617113710)
- [1m[35m (0.9ms)[0m RENAME TABLE `addresses` TO `has_vcards_addresses`
-Mysql2::Error: Table 'has_vcards_addresses' already exists: RENAME TABLE `addresses` TO `has_vcards_addresses`
- [1m[36m (9.9ms)[0m [1mCREATE TABLE `addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (37.0ms)[0m CREATE INDEX `addresses_vcard_id_index` ON `addresses` (`vcard_id`)
- [1m[36m (3.7ms)[0m [1mDROP TABLE `honorific_prefixes`[0m
- [1m[35m (5.1ms)[0m CREATE TABLE `honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB
- [1m[36m (3.3ms)[0m [1mDROP TABLE `phone_numbers`[0m
- [1m[35m (5.7ms)[0m CREATE TABLE `phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (35.0ms)[0m [1mCREATE INDEX `index_phone_numbers_on_object_id_and_object_type` ON `phone_numbers` (`object_id`, `object_type`) [0m
- [1m[35m (34.6ms)[0m CREATE INDEX `index_phone_numbers_on_phone_number_type` ON `phone_numbers` (`phone_number_type`)
- [1m[36m (34.8ms)[0m [1mCREATE INDEX `phone_numbers_vcard_id_index` ON `phone_numbers` (`vcard_id`) [0m
- [1m[35m (3.6ms)[0m DROP TABLE `vcards`
- [1m[36m (5.4ms)[0m [1mCREATE TABLE `vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (39.0ms)[0m CREATE INDEX `index_vcards_on_active` ON `vcards` (`active`)
- [1m[36m (35.0ms)[0m [1mCREATE INDEX `index_vcards_on_object_id_and_object_type` ON `vcards` (`object_id`, `object_type`) [0m
- [1m[35m (0.2ms)[0m SELECT version FROM `schema_migrations`
- [1m[36mActiveRecord::SchemaMigration Load (0.2ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
- [1m[36m (7.7ms)[0m [1mDROP TABLE `addresses`[0m
- [1m[35m (6.8ms)[0m CREATE TABLE `addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (34.9ms)[0m [1mCREATE INDEX `addresses_vcard_id_index` ON `addresses` (`vcard_id`) [0m
- [1m[35m (3.8ms)[0m DROP TABLE `honorific_prefixes`
- [1m[36m (4.9ms)[0m [1mCREATE TABLE `honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB[0m
- [1m[35m (3.4ms)[0m DROP TABLE `phone_numbers`
- [1m[36m (6.9ms)[0m [1mCREATE TABLE `phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (33.8ms)[0m CREATE INDEX `index_phone_numbers_on_object_id_and_object_type` ON `phone_numbers` (`object_id`, `object_type`)
- [1m[36m (36.0ms)[0m [1mCREATE INDEX `index_phone_numbers_on_phone_number_type` ON `phone_numbers` (`phone_number_type`) [0m
- [1m[35m (40.1ms)[0m CREATE INDEX `phone_numbers_vcard_id_index` ON `phone_numbers` (`vcard_id`)
- [1m[36m (4.3ms)[0m [1mDROP TABLE `vcards`[0m
- [1m[35m (7.2ms)[0m CREATE TABLE `vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (36.2ms)[0m [1mCREATE INDEX `index_vcards_on_active` ON `vcards` (`active`) [0m
- [1m[35m (39.2ms)[0m CREATE INDEX `index_vcards_on_object_id_and_object_type` ON `vcards` (`object_id`, `object_type`)
- [1m[36m (0.3ms)[0m [1mSELECT version FROM `schema_migrations`[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.3ms)[0m SELECT `schema_migrations`.* FROM `schema_migrations`
-Migrating to RenameTablesForNamespacing (20140617113710)
- [1m[36m (0.8ms)[0m [1mRENAME TABLE `addresses` TO `has_vcards_addresses`[0m
-Mysql2::Error: Table 'has_vcards_addresses' already exists: RENAME TABLE `addresses` TO `has_vcards_addresses`
- [1m[36m (23.1ms)[0m [1mDROP DATABASE IF EXISTS `has_vcard_test`[0m
- [1m[35m (0.5ms)[0m CREATE DATABASE `has_vcard_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`
- [1m[36m (6.4ms)[0m [1mCREATE TABLE `addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (34.9ms)[0m CREATE INDEX `addresses_vcard_id_index` ON `addresses` (`vcard_id`)
- [1m[36m (5.1ms)[0m [1mCREATE TABLE `honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB[0m
- [1m[35m (5.2ms)[0m CREATE TABLE `phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (31.4ms)[0m [1mCREATE INDEX `index_phone_numbers_on_object_id_and_object_type` ON `phone_numbers` (`object_id`, `object_type`) [0m
- [1m[35m (53.5ms)[0m CREATE INDEX `index_phone_numbers_on_phone_number_type` ON `phone_numbers` (`phone_number_type`)
- [1m[36m (43.3ms)[0m [1mCREATE INDEX `phone_numbers_vcard_id_index` ON `phone_numbers` (`vcard_id`) [0m
- [1m[35m (19.9ms)[0m CREATE TABLE `vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (43.5ms)[0m [1mCREATE INDEX `index_vcards_on_active` ON `vcards` (`active`) [0m
- [1m[35m (43.4ms)[0m CREATE INDEX `index_vcards_on_object_id_and_object_type` ON `vcards` (`object_id`, `object_type`)
- [1m[36m (11.8ms)[0m [1mCREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB[0m
- [1m[35m (36.8ms)[0m CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)
- [1m[36m (0.6ms)[0m [1mSELECT version FROM `schema_migrations`[0m
- [1m[35m (2.8ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20121113120000')
- [1m[36m (1.1ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('20120813065226')[0m
- [1m[35m (2.4ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20120119091225')
- [1m[36m (1.2ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('0')[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.5ms)[0m SELECT `schema_migrations`.* FROM `schema_migrations`
- [1m[36mActiveRecord::SchemaMigration Load (0.3ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
-Migrating to RenameTablesForNamespacing (20140617113710)
- [1m[35m (8.5ms)[0m RENAME TABLE `addresses` TO `has_vcards_addresses`
- [1m[36m (3.1ms)[0m [1mRENAME TABLE `honorific_prefixes` TO `has_vcards_honorific_prefixes`[0m
- [1m[35m (3.1ms)[0m RENAME TABLE `phone_numbers` TO `has_vcards_phone_numbers`
- [1m[36m (34.3ms)[0m [1mCREATE INDEX `index_has_vcards_phone_numbers_on_object_id_and_object_type` ON `has_vcards_phone_numbers` (`object_id`, `object_type`) [0m
- [1m[35m (7.4ms)[0m DROP INDEX `index_phone_numbers_on_object_id_and_object_type` ON `has_vcards_phone_numbers`
- [1m[36m (34.4ms)[0m [1mCREATE INDEX `index_has_vcards_phone_numbers_on_phone_number_type` ON `has_vcards_phone_numbers` (`phone_number_type`) [0m
- [1m[35m (9.2ms)[0m DROP INDEX `index_phone_numbers_on_phone_number_type` ON `has_vcards_phone_numbers`
- [1m[36m (3.8ms)[0m [1mRENAME TABLE `vcards` TO `has_vcards_vcards`[0m
- [1m[35m (42.0ms)[0m CREATE INDEX `index_has_vcards_vcards_on_active` ON `has_vcards_vcards` (`active`)
- [1m[36m (8.7ms)[0m [1mDROP INDEX `index_vcards_on_active` ON `has_vcards_vcards`[0m
- [1m[35m (34.0ms)[0m CREATE INDEX `index_has_vcards_vcards_on_object_id_and_object_type` ON `has_vcards_vcards` (`object_id`, `object_type`)
- [1m[36m (14.0ms)[0m [1mDROP INDEX `index_vcards_on_object_id_and_object_type` ON `has_vcards_vcards`[0m
- [1m[35m (0.3ms)[0m BEGIN
- [1m[36mSQL (0.5ms)[0m [1mINSERT INTO `schema_migrations` (`version`) VALUES ('20140617113710')[0m
- [1m[35m (2.5ms)[0m COMMIT
- [1m[36mActiveRecord::SchemaMigration Load (0.5ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
- [1m[36m (10.7ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.9ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.0ms)[0m CREATE TABLE "has_vcards_honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.3ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (5.9ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_object_id_and_object_type" ON "has_vcards_phone_numbers" ("object_id", "object_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.1ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.9ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_object_id_and_object_type" ON "has_vcards_vcards" ("object_id", "object_type")[0m
- [1m[35m (7.1ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.3ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.4ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
- [1m[36m (10.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "has_vcards_honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.2ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.4ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_object_id_and_object_type" ON "has_vcards_phone_numbers" ("object_id", "object_type")
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.2ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.5ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.9ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_object_id_and_object_type" ON "has_vcards_vcards" ("object_id", "object_type")[0m
- [1m[35m (6.5ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.4ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.8ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (5.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (6.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
- [1m[36m (12.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "has_vcards_honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.5ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.3ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_object_id_and_object_type" ON "has_vcards_phone_numbers" ("object_id", "object_type")
- [1m[36m (0.5ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (5.5ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (7.0ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_object_id_and_object_type" ON "has_vcards_vcards" ("object_id", "object_type")[0m
- [1m[35m (6.9ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.1ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.3ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (6.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (6.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
- [1m[36m (6.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
- [1m[36m (12.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.3ms)[0m CREATE TABLE "has_vcards_honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.8ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.2ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_object_id_and_object_type" ON "has_vcards_phone_numbers" ("object_id", "object_type")
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.0ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.8ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_object_id_and_object_type" ON "has_vcards_vcards" ("object_id", "object_type")[0m
- [1m[35m (6.3ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (6.5ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.4ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (6.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
- [1m[36m (5.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
- [1m[36m (31.4ms)[0m [1mDROP DATABASE IF EXISTS `has_vcard_test`[0m
- [1m[35m (0.6ms)[0m CREATE DATABASE `has_vcard_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`
- [1m[36m (6.9ms)[0m [1mCREATE TABLE `has_vcards_addresses` (`id` int(11) auto_increment PRIMARY KEY, `post_office_box` varchar(50), `extended_address` varchar(50), `street_address` varchar(50), `locality` varchar(50), `region` varchar(50), `postal_code` varchar(50), `country_name` varchar(50), `vcard_id` int(11), `address_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB[0m
- [1m[35m (58.3ms)[0m CREATE INDEX `addresses_vcard_id_index` USING btree ON `has_vcards_addresses` (`vcard_id`)
- [1m[36m (12.4ms)[0m [1mCREATE TABLE `has_vcards_honorific_prefixes` (`id` int(11) auto_increment PRIMARY KEY, `sex` int(11), `name` varchar(255), `position` int(11)) ENGINE=InnoDB[0m
- [1m[35m (21.6ms)[0m CREATE TABLE `has_vcards_phone_numbers` (`id` int(11) auto_increment PRIMARY KEY, `number` varchar(50), `phone_number_type` varchar(50), `vcard_id` int(11), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (45.6ms)[0m [1mCREATE INDEX `index_has_vcards_phone_numbers_on_object_id_and_object_type` USING btree ON `has_vcards_phone_numbers` (`object_id`, `object_type`) [0m
- [1m[35m (50.7ms)[0m CREATE INDEX `index_has_vcards_phone_numbers_on_phone_number_type` USING btree ON `has_vcards_phone_numbers` (`phone_number_type`)
- [1m[36m (42.5ms)[0m [1mCREATE INDEX `phone_numbers_vcard_id_index` USING btree ON `has_vcards_phone_numbers` (`vcard_id`) [0m
- [1m[35m (22.7ms)[0m CREATE TABLE `has_vcards_vcards` (`id` int(11) auto_increment PRIMARY KEY, `full_name` varchar(50), `nickname` varchar(50), `family_name` varchar(50), `given_name` varchar(50), `additional_name` varchar(50), `honorific_prefix` varchar(50), `honorific_suffix` varchar(50), `active` tinyint(1) DEFAULT 1, `type` varchar(255), `object_id` int(11), `object_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
- [1m[36m (50.3ms)[0m [1mCREATE INDEX `index_has_vcards_vcards_on_active` USING btree ON `has_vcards_vcards` (`active`) [0m
- [1m[35m (40.5ms)[0m CREATE INDEX `index_has_vcards_vcards_on_object_id_and_object_type` USING btree ON `has_vcards_vcards` (`object_id`, `object_type`)
- [1m[36m (12.2ms)[0m [1mCREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB[0m
- [1m[35m (42.2ms)[0m CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)
- [1m[36m (0.6ms)[0m [1mSELECT version FROM `schema_migrations`[0m
- [1m[35m (2.7ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20140617113710')
- [1m[36m (2.0ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('20121113120000')[0m
- [1m[35m (1.2ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('20120813065226')
- [1m[36m (2.1ms)[0m [1mINSERT INTO `schema_migrations` (version) VALUES ('20120119091225')[0m
- [1m[35m (1.4ms)[0m INSERT INTO `schema_migrations` (version) VALUES ('0')
- [1m[36mActiveRecord::SchemaMigration Load (0.6ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
[1m[36m (11.6ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.4ms)[0m select sqlite_version(*)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.7ms)[0m CREATE TABLE "has_vcards_honorific_prefixes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sex" integer, "name" varchar(255), "position" integer)
- [1m[36m (5.0ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (6.3ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_object_id_and_object_type" ON "has_vcards_phone_numbers" ("object_id", "object_type")
- [1m[36m (0.4ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-[0m
- [1m[35m (6.0ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")
- [1m[36m (0.3ms)[0m [1m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_object_id_and_object_type' AND type='index'
-
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "object_id" integer, "object_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_object_id_and_object_type" ON "has_vcards_vcards" ("object_id", "object_type")[0m
- [1m[35m (14.5ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (22.0ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.4ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (30.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (22.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (28.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
- [1m[36m (6.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
- [1m[36m (13.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.8ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.3ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (5.2ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.1ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (9.5ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.1ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.3ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (4.9ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.1ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (4.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (3.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (3.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (9.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (9.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (13.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (12.6ms)[0m CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
- [1m[36m (13.4ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
- [1m[35m (0.2ms)[0m SELECT version FROM "schema_migrations"
- [1m[36m (13.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (15.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (14.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (18.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36mActiveRecord::SchemaMigration Load (0.3ms)[0m [1mSELECT `schema_migrations`.* FROM `schema_migrations`[0m
-Migrating to RemoveObjectFromPhoneNumber (20140619101337)
- [1m[35m (12.6ms)[0m ALTER TABLE `has_vcards_phone_numbers` DROP `object_id`
- [1m[36m (9.4ms)[0m [1mALTER TABLE `has_vcards_phone_numbers` DROP `object_type`[0m
- [1m[35m (0.2ms)[0m BEGIN
- [1m[36mSQL (0.3ms)[0m [1mINSERT INTO `schema_migrations` (`version`) VALUES ('20140619101337')[0m
- [1m[35m (2.4ms)[0m COMMIT
-Migrating to RenameVcardObjectToReference (20140619102041)
- [1m[36m (10.0ms)[0m [1mALTER TABLE `has_vcards_vcards` CHANGE `object_id` `reference_id` int(11) DEFAULT NULL[0m
- [1m[35m (31.0ms)[0m CREATE INDEX `index_has_vcards_vcards_on_reference_id_and_object_type` ON `has_vcards_vcards` (`reference_id`, `object_type`)
- [1m[36m (6.2ms)[0m [1mDROP INDEX `index_has_vcards_vcards_on_object_id_and_object_type` ON `has_vcards_vcards`[0m
- [1m[35m (12.6ms)[0m ALTER TABLE `has_vcards_vcards` CHANGE `object_type` `reference_type` varchar(255) DEFAULT NULL
- [1m[36m (27.8ms)[0m [1mCREATE INDEX `index_has_vcards_vcards_on_reference_id_and_reference_type` ON `has_vcards_vcards` (`reference_id`, `reference_type`) [0m
- [1m[35m (6.1ms)[0m DROP INDEX `index_has_vcards_vcards_on_reference_id_and_object_type` ON `has_vcards_vcards`
- [1m[36m (0.2ms)[0m [1mBEGIN[0m
- [1m[35mSQL (0.2ms)[0m INSERT INTO `schema_migrations` (`version`) VALUES ('20140619102041')
- [1m[36m (1.8ms)[0m [1mCOMMIT[0m
-Migrating to RefactorHonorificPrefix (20140619121756)
- [1m[35m (3.0ms)[0m DROP TABLE `has_vcards_honorific_prefixes`
- [1m[36m (0.1ms)[0m [1mBEGIN[0m
- [1m[35mSQL (0.3ms)[0m INSERT INTO `schema_migrations` (`version`) VALUES ('20140619121756')
- [1m[36m (2.3ms)[0m [1mCOMMIT[0m
-Migrating to CreateSomethings (20140620151641)
- [1m[35m (4.3ms)[0m CREATE TABLE `somethings` (`id` int(11) auto_increment PRIMARY KEY, `title` varchar(255)) ENGINE=InnoDB
- [1m[36m (0.1ms)[0m [1mBEGIN[0m
- [1m[35mSQL (0.1ms)[0m INSERT INTO `schema_migrations` (`version`) VALUES ('20140620151641')
- [1m[36m (2.0ms)[0m [1mCOMMIT[0m
- [1m[35mActiveRecord::SchemaMigration Load (0.1ms)[0m SELECT `schema_migrations`.* FROM `schema_migrations`
- [1m[36m (5.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.4ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.8ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.7ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
+ [1m[35m (0.3ms)[0m select sqlite_version(*)
[1m[36m (4.9ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
[1m[35m (5.6ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.0ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (6.1ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.3ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.3ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (3.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (3.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (32.4ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
+ [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
[1m[35m (0.3ms)[0m SELECT sql
FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (6.1ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (6.8ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.1ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.3ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (6.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.0ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.1ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
UNION ALL
SELECT sql
FROM sqlite_temp_master
WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (6.0ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (6.0ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (22.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.8ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.7ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.1ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.9ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.2ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (4.7ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.1ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.2ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.3ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.0ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.4ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.2ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.1ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (13.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (28.2ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (19.1ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (3.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (4.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.0ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.6ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.0ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (19.9ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (13.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (15.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (12.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (32.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (13.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.0ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.2ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.5ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (8.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.3ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.2ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
+ [1m[36m (6.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
[1m[35m (5.7ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
+ [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
[1m[35m (0.3ms)[0m SELECT sql
FROM sqlite_master
WHERE name='index_has_vcards_vcards_on_active' AND type='index'
UNION ALL
SELECT sql
FROM sqlite_temp_master
WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- [1m[36m (12.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (27.8ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (13.7ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (23.2ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.5ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (15.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (16.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (22.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (6.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (19.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (15.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.6ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.6ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.6ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (6.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.4ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (8.1ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.7ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (9.3ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.5ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (6.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (6.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (6.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (7.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (6.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (6.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.4ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.3ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (6.2ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (6.5ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (8.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (7.3ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.9ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (7.0ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (6.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (7.3ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (6.7ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (6.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (6.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (6.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (23.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (13.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (33.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (6.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.6ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.4ms)[0m select sqlite_version(*)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.0ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (6.6ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.0ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36m (6.1ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
+ [1m[35m (6.0ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
+ [1m[36m (5.8ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
+ [1m[35m (5.8ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
[1m[36m (0.3ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (6.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (6.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (7.1ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (7.8ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (7.7ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.9ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.8ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.1ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.9ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
[1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (6.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.7ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (16.6ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (22.1ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (13.5ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (7.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (12.9ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (29.0ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (29.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (17.3ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (12.8ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (32.3ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.4ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (13.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (6.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (6.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (6.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
+ [1m[36m (5.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
[1m[35m (6.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.2ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.2ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (3.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.1ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.0ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (13.3ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.6ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.9ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.2ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.2ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.2ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (6.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (10.4ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
+ [1m[36m (6.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
+ [1m[35m (7.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
+ [1m[36m (6.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
+ [1m[35m (6.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619121756')
+ [1m[36m (6.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
+ [1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
+ [1m[36m (9.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
+ [1m[35m (0.3ms)[0m select sqlite_version(*)
+ [1m[36m (6.8ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
[1m[35m (4.8ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
[1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.7ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.8ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.5ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (3.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (3.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (6.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (9.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.8ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.8ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (34.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.7ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (28.6ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (25.0ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.2ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (11.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (3.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.5ms)[0m select sqlite_version(*)
- [1m[36m (7.1ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.9ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.4ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (8.0ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.5ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (6.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (6.1ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.3ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (7.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (9.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (3.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (3.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (6.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.3ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.2ms)[0m select sqlite_version(*)
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.5ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.8ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.2ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (6.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (6.4ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.5ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
[1m[35m (0.3ms)[0m SELECT sql
FROM sqlite_master
WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
UNION ALL
SELECT sql
FROM sqlite_temp_master
WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.7ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.0ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.7ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (11.5ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.1ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.9ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.9ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.2ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (3.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (6.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (10.6ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.6ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.3ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.0ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.3ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.6ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (6.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (7.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (9.8ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.5ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (6.1ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.5ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.9ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (3.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (7.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (6.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (3.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.5ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (6.4ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.2ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.0ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.0ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.5ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (6.3ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.2ms)[0m select sqlite_version(*)
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.1ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.9ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.8ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.3ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (3.9ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (18.0ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.7ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.0ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
[1m[36m (5.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
+ [1m[35m (6.8ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
+ [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
+ [1m[35m (0.3ms)[0m SELECT sql
FROM sqlite_master
WHERE name='index_has_vcards_vcards_on_active' AND type='index'
UNION ALL
SELECT sql
FROM sqlite_temp_master
WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- [1m[36m (5.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.7ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.3ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.2ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (5.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36mHasVcards::PhoneNumber Exists (0.9ms)[0m [1mSELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'Tel. geschäft' LIMIT 1[0m
- [1m[35mHasVcards::PhoneNumber Exists (0.7ms)[0m SELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'Tel. privat' LIMIT 1
- [1m[36mHasVcards::PhoneNumber Exists (0.5ms)[0m [1mSELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'Handy' LIMIT 1[0m
- [1m[35mHasVcards::PhoneNumber Exists (0.7ms)[0m SELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'E-Mail' LIMIT 1
- [1m[36mHasVcards::PhoneNumber Exists (0.4ms)[0m [1mSELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'Tel. geschäft' LIMIT 1[0m
- [1m[35mHasVcards::PhoneNumber Exists (0.4ms)[0m SELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'Tel. privat' LIMIT 1
- [1m[36mHasVcards::PhoneNumber Exists (0.3ms)[0m [1mSELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'Handy' LIMIT 1[0m
- [1m[35mHasVcards::PhoneNumber Exists (0.4ms)[0m SELECT 1 AS one FROM `has_vcards_phone_numbers` WHERE `has_vcards_phone_numbers`.`vcard_id` = NULL AND `has_vcards_phone_numbers`.`phone_number_type` = 'E-Mail' LIMIT 1
- [1m[36m (13.5ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.7ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.0ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.0ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.4ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (3.8ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (4.6ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.5ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (4.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.7ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (14.3ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (13.1ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (4.3ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (6.1ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.6ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.3ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (11.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.9ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (6.1ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.1ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.6ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.1ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.4ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.9ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.2ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (5.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (3.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (5.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (4.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.2ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.3ms)[0m select sqlite_version(*)
- [1m[36m (6.1ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.8ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.2ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (6.0ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (4.7ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (4.8ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.7ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (4.7ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.1ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (5.1ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.3ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (4.3ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (3.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (4.2ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (3.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
- [1m[36m (5.7ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_office_box" varchar(50), "extended_address" varchar(50), "street_address" varchar(50), "locality" varchar(50), "region" varchar(50), "postal_code" varchar(50), "country_name" varchar(50), "vcard_id" integer, "address_type" varchar(255), "created_at" datetime, "updated_at" datetime) [0m
- [1m[35m (0.1ms)[0m select sqlite_version(*)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" ("vcard_id")[0m
- [1m[35m (6.4ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(50), "phone_number_type" varchar(50), "vcard_id" integer, "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.9ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" ("phone_number_type")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_phone_numbers_on_phone_number_type' AND type='index'
-
- [1m[36m (5.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" ("vcard_id")[0m
- [1m[35m (5.8ms)[0m CREATE TABLE "has_vcards_vcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "full_name" varchar(50), "nickname" varchar(50), "family_name" varchar(50), "given_name" varchar(50), "additional_name" varchar(50), "honorific_prefix" varchar(50), "honorific_suffix" varchar(50), "active" boolean DEFAULT 't', "type" varchar(255), "reference_id" integer, "reference_type" varchar(255), "created_at" datetime, "updated_at" datetime)
- [1m[36m (4.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" ("active")[0m
- [1m[35m (0.1ms)[0m SELECT sql
- FROM sqlite_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
- UNION ALL
- SELECT sql
- FROM sqlite_temp_master
- WHERE name='index_has_vcards_vcards_on_active' AND type='index'
-
- [1m[36m (5.6ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
- [1m[35m (4.5ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
- [1m[36m (5.0ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
- [1m[35m (5.7ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
- [1m[36m (0.2ms)[0m [1mSELECT version FROM "schema_migrations"[0m
- [1m[35m (4.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
- [1m[36m (6.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
- [1m[35m (5.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
- [1m[36m (3.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
- [1m[35m (4.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
- [1m[36m (3.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
- [1m[35m (4.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
- [1m[36m (5.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
- [1m[35m (5.8ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
+ [1m[36m (7.2ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" ("reference_id", "reference_type")[0m
+ [1m[35m (5.7ms)[0m CREATE TABLE "somethings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
+ [1m[36m (7.0ms)[0m [1mCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) [0m
+ [1m[35m (5.8ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36m (0.3ms)[0m [1mSELECT version FROM "schema_migrations"[0m
+ [1m[35m (7.1ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140620151641')
+ [1m[36m (6.7ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120119091225')[0m
+ [1m[35m (7.0ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140617113710')
+ [1m[36m (6.0ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619101337')[0m
+ [1m[35m (6.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619102041')
+ [1m[36m (6.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20120813065226')[0m
+ [1m[35m (7.2ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619121756')
+ [1m[36m (6.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('0')[0m
+ [1m[35m (5.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20121113120000')
+ [1m[36m (0.2ms)[0m [1mDROP DATABASE IF EXISTS "has_vcard_test"[0m
+ [1m[35m (365.1ms)[0m CREATE DATABASE "has_vcard_test" ENCODING = 'utf8'
+ [1m[36m (27.1ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" serial primary key, "post_office_box" character varying(50), "extended_address" character varying(50), "street_address" character varying(50), "locality" character varying(50), "region" character varying(50), "postal_code" character varying(50), "country_name" character varying(50), "vcard_id" integer, "address_type" character varying(255), "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.5ms)[0m CREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" USING btree ("vcard_id")
+ [1m[36m (6.0ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" serial primary key, "number" character varying(50), "phone_number_type" character varying(50), "vcard_id" integer, "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.8ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" USING btree ("phone_number_type")
+ [1m[36m (2.3ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" USING btree ("vcard_id")[0m
+ [1m[35m (12.0ms)[0m CREATE TABLE "has_vcards_vcards" ("id" serial primary key, "full_name" character varying(50), "nickname" character varying(50), "family_name" character varying(50), "given_name" character varying(50), "additional_name" character varying(50), "honorific_prefix" character varying(50), "honorific_suffix" character varying(50), "active" boolean DEFAULT 't', "type" character varying(255), "reference_id" integer, "reference_type" character varying(255), "created_at" timestamp, "updated_at" timestamp)
+ [1m[36m (3.1ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" USING btree ("active")[0m
+ [1m[35m (3.1ms)[0m CREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" USING btree ("reference_id", "reference_type")
+ [1m[36m (6.4ms)[0m [1mCREATE TABLE "somethings" ("id" serial primary key, "title" character varying(255)) [0m
+ [1m[35m (2.9ms)[0m CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
+ [1m[36m (2.6ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
+ [1m[35m (0.5ms)[0m SELECT version FROM "schema_migrations"
+ [1m[36m (0.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140620151641')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619101337')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619102041')[0m
+ [1m[35m (0.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
+ [1m[36m (117.4ms)[0m [1mDROP DATABASE IF EXISTS "has_vcard_test"[0m
+ [1m[35m (374.3ms)[0m CREATE DATABASE "has_vcard_test" ENCODING = 'utf8'
+ [1m[36m (16.3ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" serial primary key, "post_office_box" character varying(50), "extended_address" character varying(50), "street_address" character varying(50), "locality" character varying(50), "region" character varying(50), "postal_code" character varying(50), "country_name" character varying(50), "vcard_id" integer, "address_type" character varying(255), "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.6ms)[0m CREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" USING btree ("vcard_id")
+ [1m[36m (7.0ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" serial primary key, "number" character varying(50), "phone_number_type" character varying(50), "vcard_id" integer, "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (3.5ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" USING btree ("phone_number_type")
+ [1m[36m (2.9ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" USING btree ("vcard_id")[0m
+ [1m[35m (11.7ms)[0m CREATE TABLE "has_vcards_vcards" ("id" serial primary key, "full_name" character varying(50), "nickname" character varying(50), "family_name" character varying(50), "given_name" character varying(50), "additional_name" character varying(50), "honorific_prefix" character varying(50), "honorific_suffix" character varying(50), "active" boolean DEFAULT 't', "type" character varying(255), "reference_id" integer, "reference_type" character varying(255), "created_at" timestamp, "updated_at" timestamp)
+ [1m[36m (3.3ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" USING btree ("active")[0m
+ [1m[35m (3.3ms)[0m CREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" USING btree ("reference_id", "reference_type")
+ [1m[36m (6.6ms)[0m [1mCREATE TABLE "somethings" ("id" serial primary key, "title" character varying(255)) [0m
+ [1m[35m (2.6ms)[0m CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
+ [1m[36m (2.5ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
+ [1m[35m (0.5ms)[0m SELECT version FROM "schema_migrations"
+ [1m[36m (0.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140620151641')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619101337')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619102041')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
+ [1m[35m (0.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
+ [1m[36m (115.7ms)[0m [1mDROP DATABASE IF EXISTS "has_vcard_test"[0m
+ [1m[35m (387.0ms)[0m CREATE DATABASE "has_vcard_test" ENCODING = 'utf8'
+ [1m[36m (15.1ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" serial primary key, "post_office_box" character varying(50), "extended_address" character varying(50), "street_address" character varying(50), "locality" character varying(50), "region" character varying(50), "postal_code" character varying(50), "country_name" character varying(50), "vcard_id" integer, "address_type" character varying(255), "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.6ms)[0m CREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" USING btree ("vcard_id")
+ [1m[36m (5.5ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" serial primary key, "number" character varying(50), "phone_number_type" character varying(50), "vcard_id" integer, "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.9ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" USING btree ("phone_number_type")
+ [1m[36m (2.4ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" USING btree ("vcard_id")[0m
+ [1m[35m (8.2ms)[0m CREATE TABLE "has_vcards_vcards" ("id" serial primary key, "full_name" character varying(50), "nickname" character varying(50), "family_name" character varying(50), "given_name" character varying(50), "additional_name" character varying(50), "honorific_prefix" character varying(50), "honorific_suffix" character varying(50), "active" boolean DEFAULT 't', "type" character varying(255), "reference_id" integer, "reference_type" character varying(255), "created_at" timestamp, "updated_at" timestamp)
+ [1m[36m (2.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" USING btree ("active")[0m
+ [1m[35m (3.2ms)[0m CREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" USING btree ("reference_id", "reference_type")
+ [1m[36m (6.3ms)[0m [1mCREATE TABLE "somethings" ("id" serial primary key, "title" character varying(255)) [0m
+ [1m[35m (2.5ms)[0m CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
+ [1m[36m (2.6ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
+ [1m[35m (0.5ms)[0m SELECT version FROM "schema_migrations"
+ [1m[36m (0.9ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140620151641')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
+ [1m[35m (0.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619101337')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619102041')[0m
+ [1m[35m (0.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
+ [1m[36m (120.5ms)[0m [1mDROP DATABASE IF EXISTS "has_vcard_test"[0m
+ [1m[35m (383.7ms)[0m CREATE DATABASE "has_vcard_test" ENCODING = 'utf8'
+ [1m[36m (25.1ms)[0m [1mCREATE TABLE "has_vcards_addresses" ("id" serial primary key, "post_office_box" character varying(50), "extended_address" character varying(50), "street_address" character varying(50), "locality" character varying(50), "region" character varying(50), "postal_code" character varying(50), "country_name" character varying(50), "vcard_id" integer, "address_type" character varying(255), "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.6ms)[0m CREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" USING btree ("vcard_id")
+ [1m[36m (6.9ms)[0m [1mCREATE TABLE "has_vcards_phone_numbers" ("id" serial primary key, "number" character varying(50), "phone_number_type" character varying(50), "vcard_id" integer, "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (3.0ms)[0m CREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" USING btree ("phone_number_type")
+ [1m[36m (3.1ms)[0m [1mCREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" USING btree ("vcard_id")[0m
+ [1m[35m (9.1ms)[0m CREATE TABLE "has_vcards_vcards" ("id" serial primary key, "full_name" character varying(50), "nickname" character varying(50), "family_name" character varying(50), "given_name" character varying(50), "additional_name" character varying(50), "honorific_prefix" character varying(50), "honorific_suffix" character varying(50), "active" boolean DEFAULT 't', "type" character varying(255), "reference_id" integer, "reference_type" character varying(255), "created_at" timestamp, "updated_at" timestamp)
+ [1m[36m (2.7ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" USING btree ("active")[0m
+ [1m[35m (2.7ms)[0m CREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" USING btree ("reference_id", "reference_type")
+ [1m[36m (6.7ms)[0m [1mCREATE TABLE "somethings" ("id" serial primary key, "title" character varying(255)) [0m
+ [1m[35m (2.8ms)[0m CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
+ [1m[36m (2.4ms)[0m [1mCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")[0m
+ [1m[35m (0.5ms)[0m SELECT version FROM "schema_migrations"
+ [1m[36m (0.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140620151641')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
+ [1m[35m (0.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619101337')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619102041')[0m
+ [1m[35m (0.4ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
+ [1m[36m (0.4ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
+ [1m[35m (0.5ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
+ [1m[36m (0.5ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m
+ [1m[36mActiveRecord::SchemaMigration Load (0.7ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+Migrating to DropLenghLimits (20141107181915)
+ [1m[35m (0.2ms)[0m BEGIN
+ [1m[36m (15.0ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "post_office_box" TYPE character varying(255)[0m
+ [1m[35m (14.2ms)[0m ALTER TABLE "has_vcards_addresses" ALTER COLUMN "extended_address" TYPE character varying(255)
+ [1m[36m (9.5ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "street_address" TYPE character varying(255)[0m
+ [1m[35m (9.1ms)[0m ALTER TABLE "has_vcards_addresses" ALTER COLUMN "locality" TYPE character varying(255)
+ [1m[36m (9.8ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "region" TYPE character varying(255)[0m
+ [1m[35m (14.3ms)[0m ALTER TABLE "has_vcards_addresses" ALTER COLUMN "postal_code" TYPE character varying(255)
+ [1m[36m (10.0ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "country_name" TYPE character varying(255)[0m
+ [1m[35m (33.6ms)[0m ALTER TABLE "has_vcards_phone_number" ALTER COLUMN "number" TYPE character varying(255)
+PG::UndefinedTable: ERROR: relation "has_vcards_phone_number" does not exist
+: ALTER TABLE "has_vcards_phone_number" ALTER COLUMN "number" TYPE character varying(255)
+ [1m[36m (2.0ms)[0m [1mROLLBACK[0m
+ [1m[36mActiveRecord::SchemaMigration Load (1.3ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+Migrating to DropLenghLimits (20141107181915)
+ [1m[35m (0.3ms)[0m BEGIN
+ [1m[36m (11.5ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "post_office_box" TYPE character varying(255)[0m
+ [1m[35m (16.9ms)[0m ALTER TABLE "has_vcards_addresses" ALTER COLUMN "extended_address" TYPE character varying(255)
+ [1m[36m (15.7ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "street_address" TYPE character varying(255)[0m
+ [1m[35m (9.3ms)[0m ALTER TABLE "has_vcards_addresses" ALTER COLUMN "locality" TYPE character varying(255)
+ [1m[36m (10.8ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "region" TYPE character varying(255)[0m
+ [1m[35m (10.2ms)[0m ALTER TABLE "has_vcards_addresses" ALTER COLUMN "postal_code" TYPE character varying(255)
+ [1m[36m (8.9ms)[0m [1mALTER TABLE "has_vcards_addresses" ALTER COLUMN "country_name" TYPE character varying(255)[0m
+ [1m[35m (8.6ms)[0m ALTER TABLE "has_vcards_phone_numbers" ALTER COLUMN "number" TYPE character varying(255)
+ [1m[36m (19.3ms)[0m [1mALTER TABLE "has_vcards_phone_numbers" ALTER COLUMN "phone_number_type" TYPE character varying(255)[0m
+ [1m[35m (14.5ms)[0m ALTER TABLE "has_vcards_vcards" ALTER COLUMN "full_name" TYPE character varying(255)
+ [1m[36m (12.2ms)[0m [1mALTER TABLE "has_vcards_vcards" ALTER COLUMN "nickname" TYPE character varying(255)[0m
+ [1m[35m (11.1ms)[0m ALTER TABLE "has_vcards_vcards" ALTER COLUMN "family_name" TYPE character varying(255)
+ [1m[36m (13.5ms)[0m [1mALTER TABLE "has_vcards_vcards" ALTER COLUMN "given_name" TYPE character varying(255)[0m
+ [1m[35m (16.2ms)[0m ALTER TABLE "has_vcards_vcards" ALTER COLUMN "additional_name" TYPE character varying(255)
+ [1m[36m (15.8ms)[0m [1mALTER TABLE "has_vcards_vcards" ALTER COLUMN "honorific_prefix" TYPE character varying(255)[0m
+ [1m[35m (11.1ms)[0m ALTER TABLE "has_vcards_vcards" ALTER COLUMN "honorific_suffix" TYPE character varying(255)
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "schema_migrations" ("version") VALUES ($1)[0m [["version", "20141107181915"]]
+ [1m[35m (53.3ms)[0m COMMIT
+ [1m[36mActiveRecord::SchemaMigration Load (0.3ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m
+ [1m[36m (125.3ms)[0m [1mDROP DATABASE IF EXISTS "has_vcard_test"[0m
+ [1m[35m (390.4ms)[0m CREATE DATABASE "has_vcard_test" ENCODING = 'utf8'
+ [1m[36mSQL (1.1ms)[0m [1mCREATE EXTENSION IF NOT EXISTS "plpgsql"[0m
+ [1m[35m (14.7ms)[0m CREATE TABLE "has_vcards_addresses" ("id" serial primary key, "post_office_box" character varying(255), "extended_address" character varying(255), "street_address" character varying(255), "locality" character varying(255), "region" character varying(255), "postal_code" character varying(255), "country_name" character varying(255), "vcard_id" integer, "address_type" character varying(255), "created_at" timestamp, "updated_at" timestamp)
+ [1m[36m (4.2ms)[0m [1mCREATE INDEX "addresses_vcard_id_index" ON "has_vcards_addresses" USING btree ("vcard_id")[0m
+ [1m[35m (11.1ms)[0m CREATE TABLE "has_vcards_phone_numbers" ("id" serial primary key, "number" character varying(255), "phone_number_type" character varying(255), "vcard_id" integer, "created_at" timestamp, "updated_at" timestamp)
+ [1m[36m (3.5ms)[0m [1mCREATE INDEX "index_has_vcards_phone_numbers_on_phone_number_type" ON "has_vcards_phone_numbers" USING btree ("phone_number_type")[0m
+ [1m[35m (2.8ms)[0m CREATE INDEX "phone_numbers_vcard_id_index" ON "has_vcards_phone_numbers" USING btree ("vcard_id")
+ [1m[36m (9.5ms)[0m [1mCREATE TABLE "has_vcards_vcards" ("id" serial primary key, "full_name" character varying(255), "nickname" character varying(255), "family_name" character varying(255), "given_name" character varying(255), "additional_name" character varying(255), "honorific_prefix" character varying(255), "honorific_suffix" character varying(255), "active" boolean DEFAULT 't', "type" character varying(255), "reference_id" integer, "reference_type" character varying(255), "created_at" timestamp, "updated_at" timestamp) [0m
+ [1m[35m (2.5ms)[0m CREATE INDEX "index_has_vcards_vcards_on_active" ON "has_vcards_vcards" USING btree ("active")
+ [1m[36m (2.5ms)[0m [1mCREATE INDEX "index_has_vcards_vcards_on_reference_id_and_reference_type" ON "has_vcards_vcards" USING btree ("reference_id", "reference_type")[0m
+ [1m[35m (4.6ms)[0m CREATE TABLE "somethings" ("id" serial primary key, "title" character varying(255))
+ [1m[36m (3.0ms)[0m [1mCREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL) [0m
+ [1m[35m (2.4ms)[0m CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
+ [1m[36m (0.5ms)[0m [1mSELECT version FROM "schema_migrations"[0m
+ [1m[35m (0.9ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20141107181915')
+ [1m[36m (0.8ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140620151641')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120119091225')
+ [1m[36m (0.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140617113710')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20140619101337')
+ [1m[36m (0.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619102041')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('20120813065226')
+ [1m[36m (0.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20140619121756')[0m
+ [1m[35m (0.6ms)[0m INSERT INTO "schema_migrations" (version) VALUES ('0')
+ [1m[36m (0.6ms)[0m [1mINSERT INTO "schema_migrations" (version) VALUES ('20121113120000')[0m