SQLite format 3@ rr-!  )20141222224905)20141210234057)20141117214323)20141115022230)20141114235359)20141108222616 )20141222224905)20141210234057)20141117214323)20141115022230)20141114235359)20141108222616  R+   GG?{l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")V))gtableproclaim_postsproclaim_postsCREATE TABLE "proclaim_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "title" varchar DEFAULT '' NOT NULL, "body" text DEFAULT '' NOT NULL, "state" varchar DEFAULT 'draft' NOT NULL, "published_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)O)1indexindex_proclaim_posts_on_author_idproclaim_postsCREATE INDEX "index_proclaim_posts_on_author_id" ON "proclaim_posts" ("author_id")G)!indexindex_proclaim_posts_on_stateproclaim_postsCREATE INDEX "index_proclaim_posts_on_state" ON "proclaim_posts" ("state")  nD//?tableproclaim_commentsproclaim_comments CREATE TABLE "proclaim_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "parent_id" integer, "author" varchar, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Q/5indexindex_proclaim_comments_on_post_idproclaim_comments CREATE INDEX "index_proclaim_comments_on_post_id" ON "proclaim_comments" ("post_id")S EE)tableproclaim_comment_hierarchiesproclaim_comment_hierarchies CREATE TABLE "proclaim_comment_hierarchies" ("ancestor_id" integer NOT NULL, "descendant_id" integer NOT NULL, "generations" integer NOT NULL)9 5Eindexcomment_anc_desc_udxproclaim_comment_hierarchies CREATE UNIQUE INDEX "comment_anc_desc_udx" ON "proclaim_comment_hierarchies" ("ancestor_id", "descendant_id", "generations")      ^U -E3indexcomment_desc_idxproclaim_comment_hierarchiesCREATE INDEX "comment_desc_idx" ON "proclaim_comment_hierarchies" ("descendant_id")H otableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar, "last_name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)t 99tableproclaim_subscriptionsproclaim_subscriptionsCREATE TABLE "proclaim_subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "email" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)([9Iindexindex_proclaim_subscriptions_on_post_idproclaim_subscriptionsCREATE INDEX "index_proclaim_subscriptions_on_post_id" ON "proclaim_subscriptions" ("post_id")     O M+-indexindex_proclaim_images_on_post_idproclaim_imagesCREATE INDEX "index_proclaim_images_on_post_id" ON "proclaim_images" ("post_id")Lo9}indexindex_proclaim_subscriptions_on_post_id_and_emailproclaim_subscriptionsCREATE UNIQUE INDEX "index_proclaim_subscriptions_on_post_id_and_email" ON "proclaim_subscriptions" ("post_id", "email")_++utableproclaim_imagesproclaim_imagesCREATE TABLE "proclaim_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "image" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)