SQLite format 3@ ".".@ {K@93aVMMtablepulitzer_free_form_section_typespulitzer_free_form_section_typesCREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar)??=tablepulitzer_content_elementspulitzer_content_elements CREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar, "title" varchar, "body" text, "image" varchar, "version_id" integer, "post_type_content_element_type_id" integer, "content_element_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "sort_order" integer, "kind" integer DEFAULT 0, "partial_id" integer)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")O//Mtablepulitzer_partialspulitzer_partialsCREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "free_form_section_id" integer, "sort_order" integer)33-tablepulitzer_post_typespulitzer_post_typesCREATE TABLE "pulitzer_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "plural" boolean, "kind" integer DEFAULT 0)113tablepulitzer_post_tagspulitzer_post_tags CREATE TABLE "pulitzer_post_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer, "label_id" integer, "label_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)//?tablepulitzer_versionspulitzer_versionsCREATE TABLE "pulitzer_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" integer DEFAULT 0, "post_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "cloning_errors" jsonb) E)+indexindex_pulitzer_posts_on_slugpulitzer_postsCREATE UNIQUE INDEX "index_pulitzer_posts_on_slug" ON "pulitzer_posts" ("slug")$ ]]tablepulitzer_post_type_content_element_typespulitzer_post_type_content_element_types CREATE TABLE "pulitzer_post_type_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "content_element_type_id" integer, "label" varchar, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar) ''Mtablepulitzer_tagspulitzer_tags CREATE TABLE "pulitzer_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "parent_id" integer, "hierarchical" boolean DEFAULT 'f' NOT NULL)))mtablepulitzer_postspulitzer_posts CREATE TABLE "pulitzer_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "post_type_id" integer, "status" varchar DEFAULT 'unpublished', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "slug" varchar)xIIktablepulitzer_content_element_typespulitzer_content_element_typesCREATE TABLE "pulitzer_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "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^L:(tbP>, )20170502210827)20160927160910)20160609214139)20160519181030)20160517182500)20160517181706)20160516150237)20160513153214)20160513153209)20160512214545)20160511201527)20160511192041)20160122204201)20151118031237)20151116162508)20151113183344)20151029220558 )20151029194354 )20151026180630 )20150902212741 )20150724150230 )20150702150819)20150629195832)20150619215914)20150619213457)20150619213436)20150619204708)20150619204615)20150618225402)20150618224344  |iVC0 r_L9& )20170502210827)20160927160910)20160609214139)20160519181030)20160517182500)20160517181706)20160516150237)20160513153214)20160513153209)20160512214545)20160511201527)20160511192041)20160122204201)20151118031237)20151116162508)20151113183344)20151029220558)20151029194354 )20151026180630 )20150902212741 )20150724150230 )20150702150819 )20150629195832)20150619215914)20150619213457)20150619213436)20150619204708)20150619204615)20150618225402) 20150618224344 O##AAenvironmentdevelopment2017-05-03 21:52:18.4188272017-05-03 21:52:18.418827 # environment  3pulitzer_post_types?pulitzer_content_elements1pulitzer_post_tags"Ipulitzer_content_element_types AA>AAVideo2017-05-03 22:00:53.6162942017-05-03 22:00:53.616294>AAImage2017-05-03 22:00:53.6149972017-05-03 22:00:53.614997=AAText2017-05-03 22:00:53.6129802017-05-03 22:00:53.612980             _7 {_K@93aVMMtablepulitzer_frVMMtablepulitzer_free_form_section_typespulitzer_free_form_section_typesCREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar)??=tablepulitzer_content_elementspulitzer_content_elements CREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar, "title" varchar, "body" text, "image" varchar, "version_id" integer, "post_type_content_element_type_id" integer, "content_element_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "sort_order" integer, "kind" integer DEFAULT 0, "partial_id" integer)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")O//Mtablepulitzer_partialspulitzer_partialsCREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "free_form_section_id" integer, "sort_order" integer)33-tablepulitzer_post_typespulitzer_p^ ]]tablepulitzer_post_type_content_element_typespulitzer_post_type_content_element_types CREATE TABLE "pulitzer_post_type_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "content_element_type_id" integer, "label" varchar, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar, "required" boolean DEFAULT 'false', "sort_order" integer)//?tablepulitzer_versionspulitzer_versionsCREATE TABLE "pulitzer_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" integer DEFAULT 0, "post_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "cloning_errors" jsonb) E)+indexindex_pulitzer_posts_on_slugpulitzer_postsCREATE UNIQUE INDEX "index_pulitzer_posts_on_slug" ON "pulitzer_posts" ("slug")]]tablepulitzer_post_type_content_element_typespulitzer_post_type_content_element_types CREATE TABLE "pulitzer_post_type_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "content_element_type_id" integer, "label" varchar, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar) ''Mtablepulitzer_tagspulitzer_tags CREATE TABLE "pulitzer_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "parent_id" integer, "hierarchical" boolean DEFAULT 'f' NOT NULL)))mtablepulitzer_postspulitzer_posts CREATE TABLE "pulitzer_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "post_type_id" integer, "status" varchar DEFAULT 'unpublished', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "slug" varchar)xIIktablepulitzer_content_element_typespulitzer_content_element_typesCREATE TABLE "pulitzer_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "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)   q lMMKtablepulitzer_free_form_section_typespulitzer_free_form_section_typesCREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar, "sort_order" integer)u//tablepulitzer_partialspulitzer_partialsCREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "free_form_section_id" integer, "sort_order" integer, "layout_id" integer, "label" varchar)&--tablepulitzer_layoutspulitzer_layoutsCREATE TABLE "pulitzer_layouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar)jCC[tablepulitzer_free_form_sectionspulitzer_free_form_sectionsCREATE TABLE "pulitzer_free_form_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer, "free_form_section_type_id" integer, "name" varchar) MMtablepulitzer_free_form_section_typespulitzer_free_form_section_typesCREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical") //Mtablepulitzer_partialspulitzer_partialsCREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "free_form_section_id" integer, "sort_order" 33-tablepulitzer_post_typespulitzer_post_typesCREATE TABLE "pulitzer_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "plural" boolean, "kind" integer DEFAULT 0)113tablepulitzer_post_tagspulitzer_post_tags CREATE TABLE "pulitzer_post_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer, "label_id" integer, "label_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)??=tablepu??tablepulitzer_content_elementspulitzer_content_elements CREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar, "body" text, "image" varchar, "version_id" integer, "post_type_content_element_type_id" integer, "content_element_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "sort_order" integer, "kind" integer DEFAULT 0, "partial_id" integer)