SQLite format 3@  - 9 & e\QQktablevulgata_translation_state_versionsvulgata_translation_state_versionsCREATE TABLE "vulgata_translation_state_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vulgata_translation_state_id" integer, "user_id" integer, "user_type" varchar, "status" integer, "priority" integer, "translation_data" text, "word_count" integer, "comment" text, "created_at" datetime)tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar, "first_name" varchar, "last_name" varchar)aAindexindex_vulgata_translation_states_on_item_id_and_item_typevulgata_translation_statesCREATE INDEX "index_vulgata_translation_states_on_item_id_and_item_type" ON "vulgata_translation_states" ("item_id", "item_type")AAtablevulgata_translation_statesvulgata_translation_statesCREATE TABLE "vulgata_translation_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar, "item_id" integer, "status" integer, "user_id" integer, "user_type" varchar, "locale" varchar, "priority" integer, "locked" boolean, "comment" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)!W7Aindexindex_category_translations_on_localecategory_translationsCREATE INDEX "index_category_translations_on_locale" ON "category_translations" ("locale")0a7Uindexindex_category_translations_on_category_idcategory_translationsCREATE INDEX "index_category_translations_on_category_id" ON "category_translations" ("category_id") 77Otablecategory_translationscategory_translationsCREATE TABLE "category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar), !!#tablecategoriescategories CREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) U5=indexindex_comment_translations_on_localecomment_translations CREATE INDEX "index_comment_translations_on_locale" ON "comment_translations" ("locale")) ]5Mindexindex_comment_translations_on_comment_idcomment_translations CREATE INDEX "index_comment_translations_on_comment_id" ON "comment_translations" ("comment_id") 55Ktablecomment_translationscomment_translations CREATE TABLE "comment_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "comment_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "body" varchar)9Etablecommentscomments CREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)O/1indexindex_post_translations_on_localepost_translationsCREATE INDEX "index_post_translations_on_locale" ON "post_translations" ("locale")Q/5indexindex_post_translations_on_post_idpost_translationsCREATE INDEX "index_post_translations_on_post_id" ON "post_translations" ("post_id")//atablepost_translationspost_translationsCREATE TABLE "post_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title" varchar, "body" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)GmtablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT  ^p^ )20170506144446)20170505183302)20161201140803)20161120100653)20161027130002)20160919153852)20160919145231)20160919123306)20160919123258 V|iV)20170506144446 )20170505183302)20161201140803)20161120100653)20161027130002)20160919153852)20160919145231)20160919123306) 20160919123258                   > 9 & e\QQktablevulgata_translQQktablevulgata_translation_state_versionsvulgata_translation_state_versionsCREATE TABLE "vulgata_translation_state_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vulgata_translation_state_id" integer, "user_id" integer, "user_type" varchar, "status" integer, "priority" integer, "translation_data" text, "word_count" integer, "comment" text, "created_at" datetime)tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar, "first_name" varchar, "last_name" varchar)aAindexindex_vulgata_translation_states_on_item_id_and_item_typevulgata_translation_statesCREATE INDEX "index_vulgata_translation_states_on_item_id_and_item_type" ON "vulgata_translation_states" ("item_id", "item_type")AAtablevulgata_translation_statesvulgata_translation_statesCREATE TABLE "vulgata_translation_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar, "item_id" integer, "status" integer, "user_id" integer, "user_type" varchar, "locale" varchar, "priority" integer, "locked" boolean, "comment" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)!W7Aindexindex_category_translations_on_localecategory_translationsCREATE INDEX "index_category_translations_on_locale" ON "category_translations" ("locale")0a7Uindexindex_category_translations_on_category_idcategory_translationsCREATE INDEX "index_category_translations_on_category_id" ON "category_translations" ("category_id") 77Otablecategory_translationscategory_translationsCREATE TABLE "category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar), !!#tablecategoriescategories CREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) U5=indexindex_comment_translations_on_localecomment_translations CREATE INDEX "index_comment_translations_on_locale" ON "comment_translations" ("locale")) ]5Mindexindex_comment_translations_on_comment_idcomment_translations CREATE INDEX "index_comment_translations_on_comment_id" ON "comment_translations" ("comment_id") 55Ktablecomment_translationscomment_translations CREATE TABLE "comment_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "comment_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "body" varchar)9Etablecommentscomments CREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)O/1indexindex_post_translations_on_localepost_translationsCREATE INDEX "index_post_translations_on_locale" ON "post_translations" ("locale")Q/5indexindex_post_translations_on_post_idpost_translationsCREATE INDEX "index_post_translations_on_post_id" ON "post_translations" ("post_id")//atablepost_translationspost_translationsCREATE TABLE "post_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title" varchar, "body" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)GmtablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) 2  ! 4,-itIs5windexindex_vulgata_user_locales_on_user_id_and_user_typevulgata_user_localesCREATE INDEX "index_vulgata_user_locales_on_user_id_and_user_type" ON "vulgata_user_locales" ("user_id", "user_type")r55tablevulgata_user_localesvulgata_user_localesCREATE TABLE "vulgata_user_locales" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_type" varchar, "locale" varchar, "created_at" datetime, "updated_at" datetime)Ao1oindexindex_vulgata_user_roles_on_user_id_and_user_typevulgata_user_rolesCREATE INDEX "index_vulgata_user_roles_on_user_id_and_user_type" ON "vulgata_user_roles" ("user_id", "user_type")|11#tablevulgata_user_rolesvulgata_user_rolesCREATE TABLE "vulgata_user_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_type" varchar, "role" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)??tablevulgata_i18n_translationsvulgata_i18n_translationsCREATE TABLE "vulgata_i18n_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "locale" varchar, "key" text, "value" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)KQQindexvulgata_state_versions_on_state_idvulgata_translation_state_versionsCREATE INDEX "vulgata_state_versions_on_state_id" ON "vulgata_translation_state_versions" ("vulgata_translation_state_id")QQktablevulgata_translation_state_versionsvulgata_translation_state_versionsCREATE TABLE "vulgata_translation_state_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vulgata_translation_state_id" integer, "user_id" integer, "user_type" varchar, "status" integer, "priority" integer, "translation_data" text, "word_count" integer, "comment" text, "created_at" datetime)tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar, "first_name" varchar, "last_name" varchar)aAindexindex_vulgata_translation_states_on_item_id_and_item_typevulgata_translation_statesCREATE INDEX "index_vulgata_translation_states_on_item_id_and_item_type" ON "vulgata_translation_states" ("item_id", "item_type")AAtablevulgata_translation_statesvulgata_translation_statesCREATE TABLE "vulgata_translation_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar, "item_id" integer, "status" integer, "user_id" integer, "user_type" varchar, "locale" varchar, "priority" integer, "locked" boolean, "comment" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)!W7Aindexindex_category_translations_on_localecategory_translationsCREATE INDEX "index_category_translations_on_locale" ON "category_translations" ("locale")0a7Uindexindex_category_translations_on_category_idcategory_translationsCREATE INDEX "index_category_translations_on_category_id" ON "category_translations" ("category_id") 77Otablecategory_translationscategory_translationsCREATE TABLE "category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar)