ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateBlogrCategories (20131102201151)  (0.1ms) begin transaction  (0.1ms) CREATE TABLE "blogr_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)  SQLite3::SQLException: table "blogr_categories" already exists: CREATE TABLE "blogr_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)  (0.0ms) rollback transaction  (2.2ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)   (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateBlogrPosts (20131016225633)  (0.1ms) begin transaction  (0.4ms) CREATE TABLE "blogr_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "permalink" varchar(255), "published" boolean DEFAULT 'f', "published_at" datetime, "created_at" datetime, "updated_at" datetime)  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131016225633"]]  (0.6ms) commit transaction Migrating to CreateSimpleblogPosts (20131016225900)  (2.3ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)   (0.8ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" Migrating to CreateBlogrPosts (20131016225633)  (0.1ms) begin transaction  (0.4ms) CREATE TABLE "blogr_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "permalink" varchar(255), "published" boolean DEFAULT 'f', "published_at" datetime, "created_at" datetime, "updated_at" datetime)  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131016225633"]]  (0.7ms) commit transaction Migrating to CreateBlogrImages (20131018222932)  (0.1ms) begin transaction  (0.3ms) CREATE TABLE "blogr_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "image" varchar(255), "created_at" datetime, "updated_at" datetime)   (0.1ms) CREATE INDEX "index_blogr_images_on_post_id" ON "blogr_images" ("post_id") SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131018222932"]]  (0.7ms) commit transaction Migrating to CreateBlogrCategories (20131102201151)  (0.1ms) begin transaction  (0.2ms) CREATE TABLE "blogr_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime) SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131102201151"]]  (0.8ms) commit transaction Migrating to AddCategoryIdToBlogrPosts (20131103162801)  (0.0ms) begin transaction  (0.6ms) ALTER TABLE "blogr_posts" ADD "category_id" integer  (0.1ms) CREATE INDEX "index_blogr_posts_on_category_id" ON "blogr_posts" ("category_id") SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131103162801"]]  (0.7ms) commit transaction Migrating to AddPermalinkToBlogrCategories (20131105160648)  (0.1ms) begin transaction  (0.2ms) ALTER TABLE "blogr_categories" ADD "permalink" varchar(255) SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131105160648"]]  (0.5ms) commit transaction Migrating to CreateBlogrTags (20131105161135)  (0.1ms) begin transaction  (0.2ms) CREATE TABLE "blogr_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131105161135"]]  (0.8ms) commit transaction Migrating to CreateBlogrTaggings (20131105161209)  (0.1ms) begin transaction  (0.3ms) CREATE TABLE "blogr_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)   (0.1ms) CREATE INDEX "index_blogr_taggings_on_tag_id" ON "blogr_taggings" ("tag_id")  (0.1ms) CREATE INDEX "index_blogr_taggings_on_post_id" ON "blogr_taggings" ("post_id") SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131105161209"]]  (0.6ms) commit transaction Migrating to CreateBlogrUsers (20131120191219)  (0.1ms) begin transaction  (0.3ms) CREATE TABLE "blogr_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "username" varchar(255), "email" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES (?) [["version", "20131120191219"]]  (0.7ms) commit transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.9ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.8ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.5ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.6ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Started GET "/blogr" for 127.0.0.1 at 2013-11-27 20:27:53 +0000 Processing by Blogr::DashboardController#index as HTML Redirected to http://www.example.com/blogr/login Filter chain halted as :authorize rendered or redirected Completed 302 Found in 15ms (ActiveRecord: 0.0ms) Started GET "/blogr/login" for 127.0.0.1 at 2013-11-27 20:27:53 +0000 Processing by Blogr::SessionsController#new as HTML Completed 500 Internal Server Error in 8ms  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Started GET "/blogr" for 127.0.0.1 at 2013-11-27 20:27:53 +0000 Processing by Blogr::DashboardController#index as HTML Redirected to http://www.example.com/blogr/login Filter chain halted as :authorize rendered or redirected Completed 302 Found in 0ms (ActiveRecord: 0.0ms) Started GET "/blogr/login" for 127.0.0.1 at 2013-11-27 20:27:53 +0000 Processing by Blogr::SessionsController#new as HTML Completed 500 Internal Server Error in 1ms  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.1ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.9ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.9ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.8ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.8ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.8ms) DELETE FROM "blogr_users";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.1ms) commit transaction  (0.1ms) begin transaction Started GET "/blogr" for 127.0.0.1 at 2013-11-27 20:28:22 +0000 Processing by Blogr::DashboardController#index as HTML Redirected to http://www.example.com/blogr/login Filter chain halted as :authorize rendered or redirected Completed 302 Found in 15ms (ActiveRecord: 0.0ms) Started GET "/blogr/login" for 127.0.0.1 at 2013-11-27 20:28:23 +0000 Processing by Blogr::SessionsController#new as HTML Completed 500 Internal Server Error in 8ms  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Started GET "/blogr" for 127.0.0.1 at 2013-11-27 20:28:23 +0000 Processing by Blogr::DashboardController#index as HTML Redirected to http://www.example.com/blogr/login Filter chain halted as :authorize rendered or redirected Completed 302 Found in 0ms (ActiveRecord: 0.0ms) Started GET "/blogr/login" for 127.0.0.1 at 2013-11-27 20:28:23 +0000 Processing by Blogr::SessionsController#new as HTML Completed 500 Internal Server Error in 1ms  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.3ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.2ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.7ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.9ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.9ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.2ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.7ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.9ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.8ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.6ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.1ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.7ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.2ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.8ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.6ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.4ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.9ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.8ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.1ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.9ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.9ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.6ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (3.7ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:31:56 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$f1pIMKEv1JV..JtPFlG4.uywsvVatfZZVb6qQYsEBAHUKqVvaDkVW"], ["updated_at", Wed, 27 Nov 2013 20:31:56 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.1ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.7ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.9ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.8ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.6ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:32:11 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$KZKkegnksbww.aHMZKuEKeRKKvOsUI6lnrZ8mfvnCzwp5BPiLsgoW"], ["updated_at", Wed, 27 Nov 2013 20:32:11 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.3ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.6ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.4ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:32:25 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$R/WtAapPHO5gjrmoUNk49.SQnfiI9uxvud6Gja0/CcJl3zqAhZvhG"], ["updated_at", Wed, 27 Nov 2013 20:32:25 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (2.1ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.6ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.4ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:32:43 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$BI8n3XH6SDYBHUAvzc1KbuZvaC.9vXZXGsZ.kxIdaD21FCryfPo6a"], ["updated_at", Wed, 27 Nov 2013 20:32:43 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.1ms) begin transaction  (0.1ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.1ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.8ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.6ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.6ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.4ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:32:51 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$.j3EUem4LtYezcPjEPaHIebWusSR.mU/.yFME4clnqJPzF6s/18hS"], ["updated_at", Wed, 27 Nov 2013 20:32:51 UTC +00:00], ["username", "susan"]]  (0.3ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.1ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.0ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.4ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:33:13 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$BAimDb/IQOcmVAnA/b1S8uy0WZmE5TYLLrKBHD88y9weUrAUV4mqe"], ["updated_at", Wed, 27 Nov 2013 20:33:13 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.0ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.7ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.6ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.8ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Started GET "/blogr" for 127.0.0.1 at 2013-11-27 20:33:27 +0000 Processing by Blogr::DashboardController#index as HTML Redirected to http://www.example.com/blogr/login Filter chain halted as :authorize rendered or redirected Completed 302 Found in 16ms (ActiveRecord: 0.0ms) Started GET "/blogr/login" for 127.0.0.1 at 2013-11-27 20:33:27 +0000 Processing by Blogr::SessionsController#new as HTML Completed 500 Internal Server Error in 7ms  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Started GET "/blogr" for 127.0.0.1 at 2013-11-27 20:33:27 +0000 Processing by Blogr::DashboardController#index as HTML Redirected to http://www.example.com/blogr/login Filter chain halted as :authorize rendered or redirected Completed 302 Found in 0ms (ActiveRecord: 0.0ms) Started GET "/blogr/login" for 127.0.0.1 at 2013-11-27 20:33:27 +0000 Processing by Blogr::SessionsController#new as HTML Completed 500 Internal Server Error in 1ms  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.9ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:33:27 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$RyWgG5r5w822dh03fMJKcejsW3jK.hG8NT4pui9lx.vqNbYvtSwW2"], ["updated_at", Wed, 27 Nov 2013 20:33:27 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.1ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.1ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.9ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.8ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.6ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (3.0ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:33:36 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$p/ziWsOvNYWSgb/OOhdD2utsfBz4Mw4fRunPNFfCdwhcE/m9FCIwW"], ["updated_at", Wed, 27 Nov 2013 20:33:36 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations"  (1.0ms) DELETE FROM "blogr_categories";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_categories';  (0.7ms) DELETE FROM "blogr_images";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_images';  (0.7ms) DELETE FROM "blogr_posts";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_posts';  (0.7ms) DELETE FROM "blogr_taggings";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_taggings';  (0.7ms) DELETE FROM "blogr_tags";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_tags';  (0.7ms) DELETE FROM "blogr_users";  (0.1ms) SELECT name FROM sqlite_master WHERE type='table' AND name='sqlite_sequence';  (0.1ms) DELETE FROM sqlite_sequence where name = 'blogr_users';  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction Binary data inserted for `string` type on column `password_digest` SQL (2.8ms) INSERT INTO "blogr_users" ("created_at", "email", "first_name", "last_name", "password_digest", "updated_at", "username") VALUES (?, ?, ?, ?, ?, ?, ?) [["created_at", Wed, 27 Nov 2013 20:39:31 UTC +00:00], ["email", "bob@bob.com"], ["first_name", "bob"], ["last_name", "geldof"], ["password_digest", "$2a$04$BVV6Pe8cvhcgtL.X6kuda.8Z8px4WWV7h07NpaqzwIHHk8/AwCJsi"], ["updated_at", Wed, 27 Nov 2013 20:39:31 UTC +00:00], ["username", "susan"]]  (0.4ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.1ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.0ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (0.0ms) begin transaction  (0.0ms) commit transaction  (0.0ms) begin transaction  (0.1ms) rollback transaction  (2.3ms) DROP TABLE "blogr_categories"  (0.9ms) CREATE TABLE "blogr_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime, "permalink" varchar(255))  (0.8ms) DROP TABLE "blogr_images"  (0.7ms) CREATE TABLE "blogr_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "image" varchar(255), "created_at" datetime, "updated_at" datetime)  (0.7ms) CREATE INDEX "index_blogr_images_on_post_id" ON "blogr_images" ("post_id")  (0.7ms) DROP TABLE "blogr_posts"  (0.8ms) CREATE TABLE "blogr_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "permalink" varchar(255), "published" boolean DEFAULT 'f', "published_at" datetime, "created_at" datetime, "updated_at" datetime, "category_id" integer)   (0.8ms) CREATE INDEX "index_blogr_posts_on_category_id" ON "blogr_posts" ("category_id")  (0.8ms) DROP TABLE "blogr_taggings"  (0.7ms) CREATE TABLE "blogr_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)  (0.8ms) CREATE INDEX "index_blogr_taggings_on_post_id" ON "blogr_taggings" ("post_id")  (0.7ms) CREATE INDEX "index_blogr_taggings_on_tag_id" ON "blogr_taggings" ("tag_id")  (0.8ms) DROP TABLE "blogr_tags"  (0.9ms) CREATE TABLE "blogr_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "created_at" datetime, "updated_at" datetime)  (0.7ms) DROP TABLE "blogr_users"  (0.9ms) CREATE TABLE "blogr_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "username" varchar(255), "email" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime)  (0.1ms) SELECT version FROM "schema_migrations"  (35.3ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (19.6ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (13.5ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (14.9ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (14.0ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (17.0ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (18.3ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (12.3ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (17.4ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (18.3ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (29.5ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (15.0ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209')  (13.9ms) DROP DATABASE IF EXISTS `blogr_test`  (0.5ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (22.7ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (18.6ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (22.6ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (10.5ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (32.3ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (10.0ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (17.6ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (17.8ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (15.2ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (19.4ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (10.0ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (24.9ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.4ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (12.0ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (12.4ms) SELECT DATABASE() as db  (1.6ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (6.8ms) TRUNCATE TABLE `blogr_categories`;  (4.7ms) TRUNCATE TABLE `blogr_images`;  (4.1ms) TRUNCATE TABLE `blogr_posts`;  (5.2ms) TRUNCATE TABLE `blogr_taggings`;  (3.6ms) TRUNCATE TABLE `blogr_tags`;  (3.0ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:03:06', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:03:06') Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (5.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:03:06', 'bob@bob.com', 'bob', 'geldof', '$2a$04$o.6Ah4hpXZY5xNLUlGlEWuPbBmpDGckq6uV2U76KGj0vvOVJvAiGu', '2013-11-27 21:03:06', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (10.5ms) DROP DATABASE IF EXISTS `blogr_test`  (0.3ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (21.6ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (18.0ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (11.7ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (13.0ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (21.8ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (18.0ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (21.6ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (18.2ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (22.5ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (15.2ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (15.5ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (16.6ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.6ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.6ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.4ms) TRUNCATE TABLE `blogr_categories`;  (4.4ms) TRUNCATE TABLE `blogr_images`;  (4.0ms) TRUNCATE TABLE `blogr_posts`;  (5.4ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (3.3ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:03:39', 'bob@bob.com', 'bob', 'geldof', '$2a$04$GikB2AwfE6ku8RyfzxI6l.PTffACF7nGu8a6CtwHmx0Do7dqCErw2', '2013-11-27 21:03:39', 'susan')  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (11.1ms) DROP DATABASE IF EXISTS `blogr_test`  (0.4ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (17.1ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (15.1ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (12.1ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (9.5ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (16.6ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (10.0ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (14.2ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (19.2ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (15.1ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (16.1ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (14.9ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (14.0ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.5ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.7ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (4.1ms) TRUNCATE TABLE `blogr_posts`;  (5.2ms) TRUNCATE TABLE `blogr_taggings`;  (3.0ms) TRUNCATE TABLE `blogr_tags`;  (2.7ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:03:56', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:03:56') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.9ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:03:56', 'bob@bob.com', 'bob', 'geldof', '$2a$04$TdzyAej6dLUFpdQrKI/E.OCwrGX6xXAIX4q8IowS5JjSRpV.70huK', '2013-11-27 21:03:56', 'susan')  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (11.6ms) DROP DATABASE IF EXISTS `blogr_test`  (0.4ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (20.3ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (18.0ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (20.4ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (9.5ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (21.2ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (10.1ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (23.5ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (13.1ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (15.4ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (11.6ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (19.0ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (19.1ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.5ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.7ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.4ms) TRUNCATE TABLE `blogr_categories`;  (4.4ms) TRUNCATE TABLE `blogr_images`;  (4.2ms) TRUNCATE TABLE `blogr_posts`;  (5.3ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (3.1ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:05:09', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:05:09') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:05:09', 'bob@bob.com', 'bob', 'geldof', '$2a$04$fwXvV3wL.kFclcKo55C..e8upKdvopL.wo9EiWBl4nGrQwyUnhb.e', '2013-11-27 21:05:09', 'susan')  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.2ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (11.1ms) DROP DATABASE IF EXISTS `blogr_test`  (0.3ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (17.5ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (15.6ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (13.6ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (15.5ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (16.7ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (10.3ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (13.8ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (19.1ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (17.9ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (11.7ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (9.1ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (19.1ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.6ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.7ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (4.1ms) TRUNCATE TABLE `blogr_posts`;  (5.1ms) TRUNCATE TABLE `blogr_taggings`;  (3.6ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.4ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:05:24', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:05:24') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:05:24', 'bob@bob.com', 'bob', 'geldof', '$2a$04$Vn5xdKpS3EZqWSWVzbcqv.VWicEch7ZU9mDOYbZNzGprFVWeXMVAq', '2013-11-27 21:05:24', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (11.3ms) DROP DATABASE IF EXISTS `blogr_test`  (0.3ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (18.9ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (18.2ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (15.9ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (14.1ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (25.1ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (14.8ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (40.5ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (18.5ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (18.5ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (12.2ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (15.3ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (15.8ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.3ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.7ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.7ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (4.3ms) TRUNCATE TABLE `blogr_posts`;  (5.1ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (3.0ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:06:40', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:06:40') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:06:40', 'bob@bob.com', 'bob', 'geldof', '$2a$04$.h7OS3B3LCSim1ILe.h8p.7dSxv0z4fskoW7pCxcsZPJwscJzwxem', '2013-11-27 21:06:40', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (11.3ms) DROP DATABASE IF EXISTS `blogr_test`  (0.3ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (24.6ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (16.0ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (18.9ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (16.6ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (23.6ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (13.8ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (13.5ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (19.6ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (12.9ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (12.1ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (19.4ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (27.7ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (2.8ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (4.0ms) TRUNCATE TABLE `blogr_categories`;  (4.6ms) TRUNCATE TABLE `blogr_images`;  (3.8ms) TRUNCATE TABLE `blogr_posts`;  (5.5ms) TRUNCATE TABLE `blogr_taggings`;  (3.3ms) TRUNCATE TABLE `blogr_tags`;  (3.1ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:07:47', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:07:47') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:07:47', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:07:47') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:07:47', 'bob@bob.com', 'bob', 'geldof', '$2a$04$vI92IrbAaWv4GPK5e9QTLO4qbMBnPoNPaStQNPNPGEVXBT8A0OSJC', '2013-11-27 21:07:47', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (10.9ms) DROP DATABASE IF EXISTS `blogr_test`  (0.6ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (25.1ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (27.8ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (17.6ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (10.7ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (17.2ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (15.5ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (16.7ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (19.0ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (19.8ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (11.7ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (11.1ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (13.9ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.2ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.4ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (4.5ms) TRUNCATE TABLE `blogr_posts`;  (5.3ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:08:05', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:08:05') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:08:05', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:08:05') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:08:05', 'bob@bob.com', 'bob', 'geldof', '$2a$04$KYcYukSMnO3qEcnyNlDMX.0k5dBPfR3zby4dB0nbvUN5jzxOourPi', '2013-11-27 21:08:05', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.3ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (2.0ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (24.8ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (4.1ms) TRUNCATE TABLE `blogr_posts`;  (5.3ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:09:28', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:09:28') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (2.3ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.2ms) TRUNCATE TABLE `blogr_images`;  (4.5ms) TRUNCATE TABLE `blogr_posts`;  (5.3ms) TRUNCATE TABLE `blogr_taggings`;  (3.3ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:09:45', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:09:45') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Hello World' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:09:45', 'blogs-title', '2013-11-10 10:00:00', 'Hello World', '2013-11-27 21:09:45')  (1.8ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.1ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.4ms) TRUNCATE TABLE `blogr_images`;  (4.2ms) TRUNCATE TABLE `blogr_posts`;  (5.4ms) TRUNCATE TABLE `blogr_taggings`;  (3.2ms) TRUNCATE TABLE `blogr_tags`;  (3.2ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:10:02', 'blog-s-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:10:02') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blog-s-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (1.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Hello World' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'hello-world' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:10:02', 'hello-world', '2013-11-10 10:00:00', 'Hello World', '2013-11-27 21:10:02')  (2.0ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (0.8ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.2ms) TRUNCATE TABLE `blogr_images`;  (4.2ms) TRUNCATE TABLE `blogr_posts`;  (5.3ms) TRUNCATE TABLE `blogr_taggings`;  (3.1ms) TRUNCATE TABLE `blogr_tags`;  (2.8ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:10:06', 'blog-s-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:10:06') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blog-s-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (1.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.5ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.1ms) TRUNCATE TABLE `blogr_images`;  (4.3ms) TRUNCATE TABLE `blogr_posts`;  (5.4ms) TRUNCATE TABLE `blogr_taggings`;  (3.5ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1 SQL (0.3ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:10:36', 'blog-s-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:10:36') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blog-s-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (1.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blog-s-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.3ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.2ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.5ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (5.8ms) TRUNCATE TABLE `blogr_posts`;  (5.5ms) TRUNCATE TABLE `blogr_taggings`;  (3.6ms) TRUNCATE TABLE `blogr_tags`;  (3.4ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:11:49', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:11:49') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.5ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.4ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.2ms) TRUNCATE TABLE `blogr_images`;  (4.2ms) TRUNCATE TABLE `blogr_posts`;  (5.4ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (3.0ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:12:19', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:12:19') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.3ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.5ms) TRUNCATE TABLE `blogr_images`;  (4.4ms) TRUNCATE TABLE `blogr_posts`;  (5.4ms) TRUNCATE TABLE `blogr_taggings`;  (3.2ms) TRUNCATE TABLE `blogr_tags`;  (2.8ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.4ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.3ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:13:11', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:13:11') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.9ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (1.4ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.5ms) TRUNCATE TABLE `blogr_categories`;  (3.9ms) TRUNCATE TABLE `blogr_images`;  (4.3ms) TRUNCATE TABLE `blogr_posts`;  (5.5ms) TRUNCATE TABLE `blogr_taggings`;  (3.2ms) TRUNCATE TABLE `blogr_tags`;  (3.4ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:13:44', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:13:44') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (8.9ms) DROP DATABASE IF EXISTS `blogr_test`  (0.3ms) CREATE DATABASE `blogr_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`  (22.7ms) CREATE TABLE `blogr_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime, `permalink` varchar(255)) ENGINE=InnoDB  (20.8ms) CREATE TABLE `blogr_images` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `image` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (12.5ms) CREATE INDEX `index_blogr_images_on_post_id` ON `blogr_images` (`post_id`)   (10.0ms) CREATE TABLE `blogr_posts` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `title` varchar(255), `content` text, `permalink` varchar(255), `published` tinyint(1) DEFAULT 0, `published_at` datetime, `created_at` datetime, `updated_at` datetime, `category_id` int(11)) ENGINE=InnoDB  (18.2ms) CREATE INDEX `index_blogr_posts_on_category_id` ON `blogr_posts` (`category_id`)   (20.7ms) CREATE TABLE `blogr_taggings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `tag_id` int(11), `post_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (18.7ms) CREATE INDEX `index_blogr_taggings_on_post_id` ON `blogr_taggings` (`post_id`)   (16.7ms) CREATE INDEX `index_blogr_taggings_on_tag_id` ON `blogr_taggings` (`tag_id`)  (12.4ms) CREATE TABLE `blogr_tags` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (21.9ms) CREATE TABLE `blogr_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `username` varchar(255), `email` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (13.9ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (13.6ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  (0.2ms) SELECT version FROM `schema_migrations`  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131120191219')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131016225633')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131018222932')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131102201151')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131103162801')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105160648')  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161135')  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20131105161209') ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (2.5ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.6ms) TRUNCATE TABLE `blogr_categories`;  (4.3ms) TRUNCATE TABLE `blogr_images`;  (4.2ms) TRUNCATE TABLE `blogr_posts`;  (5.2ms) TRUNCATE TABLE `blogr_taggings`;  (3.2ms) TRUNCATE TABLE `blogr_tags`;  (2.8ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-11-27 21:13:51', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-11-27 21:13:51') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-11-27 21:13:51', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-11-27 21:13:51') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.5ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-11-27 21:13:51', 'bob@bob.com', 'bob', 'geldof', '$2a$04$Co.Yho5KXgj.BI0aZp/wPeHluuzfGlFBd4s1T7cXRhz/dXSFWTdU2', '2013-11-27 21:13:51', 'susan')  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (26.4ms) SELECT `schema_migrations`.* FROM `schema_migrations` ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations` Migrating to CreateBlogrComments (20131204185931)  (48.8ms) CREATE TABLE `blogr_comments` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `post_id` int(11), `user_id` int(11), `content` text, `author_name` varchar(255), `author_email` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (26.4ms) CREATE INDEX `index_blogr_comments_on_post_id` ON `blogr_comments` (`post_id`)   (21.6ms) CREATE INDEX `index_blogr_comments_on_user_id` ON `blogr_comments` (`user_id`)  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131204185931')  (0.3ms) COMMIT ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations` ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (6.3ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (17.5ms) SELECT DATABASE() as db  (1.3ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (6.0ms) TRUNCATE TABLE `blogr_categories`;  (6.2ms) TRUNCATE TABLE `blogr_comments`;  (4.7ms) TRUNCATE TABLE `blogr_images`;  (4.8ms) TRUNCATE TABLE `blogr_posts`;  (5.6ms) TRUNCATE TABLE `blogr_taggings`;  (3.1ms) TRUNCATE TABLE `blogr_tags`;  (3.0ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-12-04 19:01:59', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-12-04 19:01:59') Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (16.8ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.2ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-12-04 19:01:59', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-12-04 19:01:59') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.7ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-12-04 19:01:59', 'bob@bob.com', 'bob', 'geldof', '$2a$04$YTIR.habCXAJ9GS6ATwOKuJWuBxmtLnT7aH306a2GUG.WJ1WtnqU6', '2013-12-04 19:01:59', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (2.4ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (3.7ms) TRUNCATE TABLE `blogr_categories`;  (5.5ms) TRUNCATE TABLE `blogr_comments`;  (4.3ms) TRUNCATE TABLE `blogr_images`;  (4.2ms) TRUNCATE TABLE `blogr_posts`;  (5.4ms) TRUNCATE TABLE `blogr_taggings`;  (3.4ms) TRUNCATE TABLE `blogr_tags`;  (2.4ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-12-04 19:02:23', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-12-04 19:02:23') Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.2ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-12-04 19:02:23', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-12-04 19:02:23') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-12-04 19:02:23', 'bob@bob.com', 'bob', 'geldof', '$2a$04$UIPcgbZbQ4oItmzhfn4JcOA4fT5V85icDpQic7Kc3tXPobMPspqZC', '2013-12-04 19:02:23', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (3.0ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (4.4ms) TRUNCATE TABLE `blogr_categories`;  (5.6ms) TRUNCATE TABLE `blogr_comments`;  (4.6ms) TRUNCATE TABLE `blogr_images`;  (3.9ms) TRUNCATE TABLE `blogr_posts`;  (5.0ms) TRUNCATE TABLE `blogr_taggings`;  (3.6ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-12-04 19:02:47', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-12-04 19:02:47') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (0.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.4ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-12-04 19:02:47', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-12-04 19:02:47') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-12-04 19:02:47', 'bob@bob.com', 'bob', 'geldof', '$2a$04$UtPZZt9Nui7Ij7/5VeR.w.SpUFYs7jIJpPOb5u.UqyKNJB3pN.M/G', '2013-12-04 19:02:47', 'susan')  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (6.6ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (21.0ms) TRUNCATE TABLE `blogr_categories`;  (6.6ms) TRUNCATE TABLE `blogr_comments`;  (5.2ms) TRUNCATE TABLE `blogr_images`;  (5.1ms) TRUNCATE TABLE `blogr_posts`;  (6.3ms) TRUNCATE TABLE `blogr_taggings`;  (4.1ms) TRUNCATE TABLE `blogr_tags`;  (4.2ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-12-04 19:15:43', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-12-04 19:15:43') Blogr::Category Exists (0.4ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (5.8ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.0ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-12-04 19:15:43', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-12-04 19:15:43') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-12-04 19:15:43', 'bob@bob.com', 'bob', 'geldof', '$2a$04$XoxxJUOeJdDVJzXgDHlzX.URqqdFO3Kmr6ivhWiAwO9IrUB6rksvC', '2013-12-04 19:15:43', 'susan')  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (2.2ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (4.0ms) TRUNCATE TABLE `blogr_categories`;  (5.5ms) TRUNCATE TABLE `blogr_comments`;  (4.4ms) TRUNCATE TABLE `blogr_images`;  (4.1ms) TRUNCATE TABLE `blogr_posts`;  (7.0ms) TRUNCATE TABLE `blogr_taggings`;  (3.8ms) TRUNCATE TABLE `blogr_tags`;  (2.9ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.3ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-12-04 19:16:37', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-12-04 19:16:37') Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (1.6ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.2ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-12-04 19:16:38', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-12-04 19:16:38') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-12-04 19:16:38', 'bob@bob.com', 'bob', 'geldof', '$2a$04$sh3yTG5dhAGxs.tDhyoLseET3L9WXzzSxlPCt69QCcAbyeRaq6jtu', '2013-12-04 19:16:38', 'susan')  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (0.1ms) SELECT DATABASE() as db  (6.5ms) select table_name from information_schema.views where table_schema = 'blogr_test'  (21.1ms) TRUNCATE TABLE `blogr_categories`;  (6.2ms) TRUNCATE TABLE `blogr_comments`;  (4.8ms) TRUNCATE TABLE `blogr_images`;  (5.0ms) TRUNCATE TABLE `blogr_posts`;  (6.3ms) TRUNCATE TABLE `blogr_taggings`;  (4.1ms) TRUNCATE TABLE `blogr_tags`;  (4.4ms) TRUNCATE TABLE `blogr_users`;  (0.1ms) SET FOREIGN_KEY_CHECKS = 1  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` = BINARY 'Rails' LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` = BINARY 'rails' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_categories` (`created_at`, `description`, `permalink`, `title`, `updated_at`) VALUES ('2013-12-04 19:17:59', 'Ruby on Rails is awesome', 'rails', 'Rails', '2013-12-04 19:17:59') Blogr::Category Exists (0.3ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`title` = BINARY 'Rails' AND `blogr_categories`.`id` != 1) LIMIT 1 Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE (`blogr_categories`.`permalink` = BINARY 'rails' AND `blogr_categories`.`id` != 1) LIMIT 1  (6.0ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Category Exists (0.2ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`title` IS NULL LIMIT 1 Blogr::Category Exists (0.1ms) SELECT 1 AS one FROM `blogr_categories` WHERE `blogr_categories`.`permalink` IS NULL LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.3ms) INSERT INTO `blogr_comments` (`author_email`, `author_name`, `content`, `created_at`, `post_id`, `updated_at`, `user_id`) VALUES ('MyString', 'MyString', 'MyText', '2013-12-04 19:17:59', 1, '2013-12-04 19:17:59', 1)  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.3ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1 SQL (0.2ms) INSERT INTO `blogr_posts` (`category_id`, `content`, `created_at`, `permalink`, `published_at`, `title`, `updated_at`) VALUES (1, 'something wrong happening there', '2013-12-04 19:17:59', 'blogs-title', '2013-11-10 10:00:00', 'Blog\'s title', '2013-12-04 19:17:59') Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`title` = BINARY 'Blog\'s title' AND `blogr_posts`.`id` != 1) LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE (`blogr_posts`.`permalink` = BINARY 'blogs-title' AND `blogr_posts`.`id` != 1) LIMIT 1  (0.3ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` IS NULL LIMIT 1 Blogr::Post Exists (0.1ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`title` = BINARY 'Blog\'s title' LIMIT 1 Blogr::Post Exists (0.2ms) SELECT 1 AS one FROM `blogr_posts` WHERE `blogr_posts`.`permalink` = BINARY 'blogs-title' LIMIT 1  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `blogr_users` (`created_at`, `email`, `first_name`, `last_name`, `password_digest`, `updated_at`, `username`) VALUES ('2013-12-04 19:17:59', 'bob@bob.com', 'bob', 'geldof', '$2a$04$nixKytR5IILNWgaLif6j6u.7zi.U8MPvpGTgvn9jwogruDzysk3vq', '2013-12-04 19:17:59', 'susan')  (0.4ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.0ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.1ms) BEGIN  (0.1ms) ROLLBACK