spec/dummy/db/development.sqlite3 in pulitzer-0.14.2 vs spec/dummy/db/development.sqlite3 in pulitzer-0.14.3

- old
+ new

@@ -1,28 +1,12 @@ -SQLite format 3@ T7T.@ -{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  $ xp^L:(tbP>, x$)20170508145431#)20170518145318")20170518144515!)20170518144449 )20170518144418)20170518142411)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 -$ U|iVC0 -r_L9& U { h)20170508145431$)20170518145318#)20170518144515")20170518144449!)20170518144418 )20170518142411)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 p#M/AAExternal Articles2017-05-23 18:19:18.4467502017-05-23 18:19:18.446750tK+AATravel Articles2017-05-23 18:19:18.4342512017-05-23 18:19:18.434251tI'AATravel Guides2017-05-23 18:19:18.4176502017-05-23 18:19:18.417650tCAAWelcome2017-05-23 18:19:17.9746902017-05-23 18:19:17.974690t  a;$ Cpulitzer_free_form_sections?pulitzer_content_elements - pulitzer_vers -/pulitzer_versions$Mpulitzer_free_form_section_types,]pulitzer_post_type_content_element_types - puli )pulitzer_posts3pulitzer_post_types1pulitzer_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 :":t9#AA9Why visit Breckenridgeunpublished2017-05-23 18:19:18.4520992017-05-23 18:19:18.452099why-visit-breckenridgep5#AA5Ski Jump Competitionunpublished2017-05-23 18:19:18.4418282017-05-23 18:19:18.441828ski-jump-competitionI#AAIComplete Guide to Breckenridgeunpublished2017-05-23 18:19:18.4266512017-05-23 18:19:18.426651complete-guide-to-breckenridgeU #AAWelcomeunpublished2017-05-23 18:19:18.2595472017-05-23 18:19:18.259547welcome -  D>! ] o 55 AAMetadata descriptionMetadata description 2017-05-23 18:19:18.3890862017-05-23 18:19:18.589929dd^%% AAHero Title 1Hero Title 12017-05-23 18:19:18.3303542017-05-23 18:19:18.555799ddL/ AAMetadata keywords -2017-05-23 18:19:18.3946362017-05-23 18:i -// AAMetadata keywordsMetadata keywords -2017-05-23 18:19:18.3946362017-05-23 18:19:18.593604ddc)) AAMetadata titleMetadata title2017-05-23 18:19:18.3788912017-05-23 18:19:18.585462dd]## AAFooter TextFooter Text2017-05-23 18:19:18.3728172017-05-23 18:19:18.581351dd_%% AAFooter TitleFooter Title2017-05-23 18:19:18.3645022017-05-23 18:19:18.577280dd[!! AAGuest TextGuest Text2017-05-23 18:19:18.3561722017-05-23 18:19:18.573480dd]## AAGuest TitleGuest Title2017-05-23 18:19:18.3487562017-05-23 18:19:18.570203dd_%% AAHero Title 3Hero Title 32017-05-23 18:19:18.3422752017-05-23 18:19:18.566928dd_%% AAHero Title 2Hero Title 22017-05-23 18:19:18.3364322017-05-23 18:19:18.563807dd   - UV S Y - /AAMetadata keywordsdd2017-05-23 18:19:18.1091252017-05-23 18:19:18.109125false -\ 5AAMetadata descriptiondd2017-05-23 18:19:18.1056362017-05-23 18:19:18.105636false V )AAMetadata titledd2017-05-23 18:19:18.1020292017-05-23 18:19:18.102029falseS #AAFooter Textdd2017-05-23 18:19:18.0986142017-05-23 18:19:18.098614falseT %AAFooter Titledd2017-05-23 18:19:18.0947612017-05-23 18:19:18.094761falseR !AAGuest Textdd2017-05-23 18:19:18.0910592017-05-23 18:19:18.091059falseS #AAGuest Titledd2017-05-23 18:19:18.0875212017-05-23 18:19:18.087521falseT %AAHero Title 3dd2017-05-23 18:19:18.0798452017-05-23 18:19:18.079845falseT %AAHero Title 2dd2017-05-23 18:19:18.0761702017-05-23 18:19:18.076170falseS %AA Hero Title 1dd2017-05-23 18:19:18.0706322017-05-23 18:19:18.070632false -9why-visit-breckenridge5ski-jump-competition"Icomplete-guide-to-breckenridge - welcome G < AA2017-05-23 18:19:18.4955642017-05-23 18:19:18.495564<AA2017-05-23 18:19:18.4544302017-05-23 18:19:18.454430<AA2017-05-23 18:19:18.4441712017-05-23 18:19:18.444171<AA2017-05-23 18:19:18.4291772017-05-23 18:19:18.429177; AA2017-05-23 18:19:18.2742202017-05-23 18:19:18.464119  -  -Handpicked Homes  %Main Content  -Handpicked Homes %Main Content  _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)  x - - ]Tky 99-tablepulitzer_partial_typespulitzer_partial_typesCREATE TABLE "pulitzer_partial_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "free_form_section_type_id" integer, "label" varchar, "sort_order" integer, "layout_id" integer, "post_type_id" integer)iCCYtablepulitzer_arrangement_stylespulitzer_arrangement_stylesCREATE TABLE "pulitzer_arrangement_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "view_file_name" varchar)oGG]tablepulitzer_sequence_flow_stylespulitzer_sequence_flow_stylesCREATE TABLE "pulitzer_sequence_flow_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)oGG]tablepulitzer_justification_stylespulitzer_justification_stylesCREATE TABLE "pulitzer_justification_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)fAAWtablepulitzer_background_stylespulitzer_background_stylesCREATE TABLE "pulitzer_background_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)??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)&--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)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)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")x//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, "background_style_id" integer, "justification_style_id" integer, "sequence_flow_style_id" integer, "arrangement_style_id" 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)       +SQLite format 3@ .@ + /BPDphO !tablepulitzer_post_type_content_element_type_custom_option_listspulitzer_post_type_content_element_type_custom_option_listsCREATE TABLE "pulitzer_post_type_content_element_type_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_content_element_type_id" integer, "custom_option_list_id" integer) 113tablepulitzer_post_tagspulitzer_post_tagsCREATE 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)x //tablepulitzer_partialspulitzer_partials CREATE 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, "background_style_id" integer, "justification_style_id" integer, "sequence_flow_style_id" integer, "arrangement_style_id" integer) 99-tablepulitzer_partial_typespulitzer_partial_types CREATE TABLE "pulitzer_partial_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "free_form_section_type_id" integer, "label" varchar, "sort_order" integer, "layout_id" integer, "post_type_id" integer)o +GG]tablepulitzer_justification_stylespulitzer_justification_styles CREATE TABLE "pulitzer_justification_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)j CC[tablepulitzer_free_form_sectionspulitzer_free_form_sections +CREATE TABLE "pulitzer_free_form_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer, "free_form_section_type_id" integer, "name" varchar)lMMKtablepulitzer_free_form_section_typespulitzer_free_form_section_types CREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar, "sort_order" integer)X;;Gtablepulitzer_custom_optionspulitzer_custom_optionsCREATE TABLE "pulitzer_custom_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "custom_option_list_id" integer, "display" varchar, "value" varchar)2EEgtablepulitzer_custom_option_listspulitzer_custom_option_listsCREATE TABLE "pulitzer_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)-??itablepulitzer_content_elementspulitzer_content_elementsCREATE 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, "partial_id" integer, "style_id" integer, "custom_option_id" integer)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)fAAWtablepulitzer_background_stylespulitzer_background_stylesCREATE TABLE "pulitzer_background_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)iCCYtablepulitzer_arrangement_stylespulitzer_arrangement_stylesCREATE TABLE "pulitzer_arrangement_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "view_file_name" var                 + /BPDphO !tablepulitzer_post_type_content_element_type_custom_option_listspulitzer_post_type_content_element_type_custom_option_listsCREATE TABLE "pulitzer_post_type_content_element_type_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_content_element_type_id" integer, "custom_option_list_id" integer) 113tablepulitzer_post_tagspulitzer_post_tagsCREATE 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)x //tablepulitzer_partialspulitzer_partials CREATE 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, "background_style_id" integer, "justification_style_id" integer, "sequence_flow_style_id" integer, "arrangement_style_id" integer) 99-tablepulitzer_partial_typespulitzer_partial_types CREATE TABLE "pulitzer_partial_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "free_form_section_type_id" integer, "label" varchar, "sort_order" integer, "layout_id" integer, "post_type_id" integer)o +GG]tablepulitzer_justification_stylespulitzer_justification_styles CREATE TABLE "pulitzer_justification_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)j CC[tablepulitzer_free_form_sectionspulitzer_free_form_sections +CREATE TABLE "pulitzer_free_form_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer, "free_form_section_type_id" integer, "name" varchar)lMMKtablepulitzer_free_form_section_typespulitzer_free_form_section_types CREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "name" varchar, "sort_order" integer)X;;Gtablepulitzer_custom_optionspulitzer_custom_optionsCREATE TABLE "pulitzer_custom_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "custom_option_list_id" integer, "display" varchar, "value" varchar)2EEgtablepulitzer_custom_option_listspulitzer_custom_option_listsCREATE TABLE "pulitzer_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)-??itablepulitzer_content_elementspulitzer_content_elementsCREATE 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, "partial_id" integer, "style_id" integer, "custom_option_id" integer)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)fAAWtablepulitzer_background_stylespulitzer_background_stylesCREATE TABLE "pulitzer_background_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)iCCYtablepulitzer_arrangement_stylespulitzer_arrangement_stylesCREATE TABLE "pulitzer_arrangement_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "view_file_name" varchar) 7 +. u7x//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations //=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" text)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")''Mtablepulitzer_tagspulitzer_tagsCREATE 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)Z++ktablepulitzer_stylespulitzer_stylesCREATE TABLE "pulitzer_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_content_element_type_id" integer, "display_name" varchar, "css_class_name" varchar)oGG]tablepulitzer_sequence_flow_stylespulitzer_sequence_flow_stylesCREATE TABLE "pulitzer_sequence_flow_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "display_name" varchar, "css_class_name" varchar)E)+indexindex_pulitzer_posts_on_slugpulitzer_postsCREATE UNIQUE INDEX "index_pulitzer_posts_on_slug" ON "pulitzer_posts" ("slug")))mtablepulitzer_postspulitzer_postsCREATE 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)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) ]]itablepulitzer_post_type_content_element_typespulitzer_post_type_content_element_typesCREATE 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 'f', "sort_order" integer, "clickable_kind" varchar DEFAULT 'any' NOT NULL)O !tablepulitzer_post_type_content_element_type_custom_option_listspulitzer_post_type_content_element_type_custom_option_listsCREATE TABLE "pulitzer_post_type_content_element_type_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_content_element_type_id" integer, "custom_option_list_id" integer)f113tablepulitzer_post_tagspulitzer_post_tagsCREATE 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)x //tablepulitzer_partialspulitzer_partials CREATE 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, "background_style_id" integer, "justification_style_id" integer, "sequence_flow_style_id" integer, "arrangement_style_id" integer) 99-tablepulitzer_partial_typespulitzer_partial_types CREATE TABLE "pulitzer_partial_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "free_form_section_type_id" integer, "label" varchar, "sort_order" integer, "layN55?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)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata   +    +  )20170601195822)20170531164349)20170530164044)20170530145657)20170526212330)20170526212313)20170602204900 +||)20170601195822)20170531164349)20170530164044)20170530145657)20170526212330)20170526212313) 20170602204900 O##AAenvironmentdevelopment2017-06-05 15:46:18.1835712017-06-05 15:46:18.183571 +# environment \ No newline at end of file