SQLite format 3@ oo-$  @  8  :# DY''qtablealmanac_postsalmanac_postsCREATE TABLE "almanac_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "published" boolean DEFAULT 'f', "blog_id" integer, "author_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "excerpt" text, "written_at" date, "slug" varchar(255))z''3tablealmanac_blogsalmanac_blogs CREATE TABLE "almanac_blogs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "author_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "background_uid" varchar(255), "logo_uid" varchar(255), "description" text, "twitter" varchar(255), "google_analytics" varchar(255), "rakismet_key" varchar(255), "rakismet_url" varchar(255), "background_tile" boolean DEFAULT 't', "background_blur" integer DEFAULT 0, "footer" text)U indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context") mtabletaggingstaggings CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(128), "created_at" datetime)p2'' tablealmanac_blogsalmanac_blogs CREAp3--tablealmanac_commentsalmanac_commentsCREATE TABLE "almanac_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "author_email" varchar(255), "author_name" varchar(255), "post_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "spam" boolean DEFAULT 'f')''!tablealmG''Gtablealmanac_postsalmanac_postsCREATE TABLE "almanac_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "published" boolean DEFAULT 'f', "blogC''indexindex_almanac_posts_on_slugalmanac_postsCREATE UNIQUE INDEX "index_almanac_posts_on_slug" ON "almanac_posts" ("slug")m = indexindex_taggings_on_tag_idtaggings CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")o Atabletagstags CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) ))9tablealmanac_imagesalmanac_images CREATE TABLE "almanac_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_uid" varchar(255), "thumb_uid" varchar(255), "post_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)mtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) p^L:()20121116195111)20121116192008)20121114185269)20121114185268)20121114185267 )20121114185266 )20121114185265 )20121114185264 )20121114185263 )20121114185262)20121114185261)20121114185260)20121114185259)20121114185258)20121114185257)20121114185256)20121114185255)20121106220325 |iVC0 )20121116195111)20121116192008)20121114185269)20121114185268)20121114185267)20121114185266 )20121114185265 )20121114185264 )20121114185263 )20121114185262 )20121114185261)20121114185260)20121114185259)20121114185258)20121114185257)20121114185256)20121114185255) 20121106220325