SQLite format 3@ **-% l l ; W  =//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q //tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)!## tableblogr_usersblogr_users 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)I!!]tableblogr_tagsblogr_tags CREATE TABLE "blogr_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "created_at" datetime, "updated_at" datetime)I)%indexindex_blogr_taggings_on_tag_idblogr_taggings CREATE INDEX "index_blogr_taggings_on_tag_id" ON "blogr_taggings" ("tag_id")K))indexindex_blogr_taggings_on_post_idblogr_taggings CREATE INDEX "index_blogr_taggings_on_post_id" ON "blogr_taggings" ("post_id")K))Qtableblogr_taggingsblogr_taggingsCREATE TABLE "blogr_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)M#-indexindex_blogr_posts_on_category_idblogr_postsCREATE INDEX "index_blogr_posts_on_category_id" ON "blogr_posts" ("category_id").###tableblogr_postsblogr_postsCREATE 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)G%!indexindex_blogr_images_on_post_idblogr_imagesCREATE INDEX "index_blogr_images_on_post_id" ON "blogr_images" ("post_id")I%%Utableblogr_imagesblogr_imagesCREATE TABLE "blogr_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "image" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)p--tableblogr_categoriesblogr_categoriesCREATE TABLE "blogr_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime, "permalink" varchar(255))             pp)20131105161209)20131105161135)20131105160648)20131103162801)20131102201151)20131018222932)20131016225633)20131120191219 i|i)20131105161209)20131105161135)20131105160648)20131103162801)20131102201151)20131018222932)20131016225633) 20131120191219