SQLite format 3@ P6P.@) {tn VMMtablepulitzer_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)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY p^L:(tbP>, )20170508145431)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)20170518145318)20170518144515)20170518144449)20170518144418)20170518142411 |iVC0 r_L9& )20170508145431)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)20170518145318)20170518144515)20170518144449)20170518144418) 20170518142411 H#AAenvironmenttest2017-05-22 18:06:16.2039382017-05-22 18:06:16.203938 # environment n M /AAExternal Articles2017-05-23 16:54:53.4762642017-05-23 16:54:53.476264tK+AATravel Articles2017-05-23 16:54:53.4666792017-05-23 16:54:53.466679tI'AATravel Guides2017-05-23 16:54:53.4534262017-05-23 16:54:53.453426tCAAWelcome2017-05-23 16:54:53.1107932017-05-23 16:54:53.110793t P 8 Cpulitzer_free_f C Cpulitze Cpulitzer_free_fo Cpulitzer_free_form_sections )pulitzer_posts3pulitzer_post_types /pulitzer_versions-]pulitzer_post_type_content_element_types?pulitzer_content_elements $Mpulitzer_free_form_section_typesP1pulitzer_post_tags"Ipulitzer_content_element_types{ AA>{AAVideo2017-05-23 16:54:53.1413072017-05-23 16:54:53.141307>zAAImage2017-05-23 16:54:53.1380772017-05-23 16:54:53.138077=yAAText2017-05-23 16:54:53.1341192017-05-23 16:54:53.134119 11u 9#AA9Why visit Breckenridgeunpublished2017-05-23 16:54:53.4808692017-05-23 16:54:53.480869why-visit-breckenridgeq5#AA5Ski Jump Competitionunpublished2017-05-23 16:54:53.4715252017-05-23 16:54:53.471525ski-jump-competitionI#AAIComplete Guide to Breckenridgeunpublished2017-05-23 16:54:53.4613582017-05-23 16:54:53.461358complete-guide-to-breckenridgeW#AAWelcomeunpublished2017-05-23 16:54:53.3323992017-05-23 16:54:53.332399welcome q|4n :  c X As55AAMetadata descriptionMetadata descriptiony2017-05-23 16:54:53.4241692017-05-23 16:54:53.679647ddc %%AAHero Title 1Hero Title 1y2017-05-23 16:54:53.3681672017-05-23 16:54:53.655014dd\ /AAMetadata keywordsy2017-05-23 16:54:53.4320262017-05-23 16:54:53.618940dd_5AAMetadata descriptiony2017-05-23 16:54:53.4241692017-05-23 16:54:53.609032ddY)AAMetadata titley2017-05-23 16:54:53.4174672017-05-23 16:54:53.598392ddV#AAFooter Texty2017-05-23 16:54:53.4105062017-05-23 16:54:53.588141ddW%AAFooter Titley2017-05-23 16:54:53.4037712017-05-23 16:54:53.578325ddU!AAGuest Texty2017-05-23 16:54:53.3975222017-05-23 16:54:53.568928ddV#AAGuest Titley2017-05-23 16:54:53.3902302017-05-23 16:54:53.558740ddW%AAHero Title 3y2017-05-23 16:54:53.3827992017-05-23 16:54:53.548343ddW%AAHero Title 2y2017-05-23 16:54:53.3750872017-05-23 16:54:53.538991ddW%AAHero Title 1y2017-05-23 16:54:53.3681672017-05-23 16:54:53.528047ddY/AAMetadata keywordsy2017-05-23 16:54:53.4320262017-05-23 16:54:53.43m//AAMetadata keywordsMetadata keywordsy2017-05-23 16:54:53.4320262017-05-23 16:54:53.682838ddg))AAMetadata titleMetadata titley2017-05-23 16:54:53.4174672017-05-23 16:54:53.676368dda##AAFooter TextFooter Texty2017-05-23 16:54:53.4105062017-05-23 16:54:53.673271ddc%%AAFooter TitleFooter Titley2017-05-23 16:54:53.4037712017-05-23 16:54:53.670223dd_!!AAGuest TextGuest Texty2017-05-23 16:54:53.3975222017-05-23 16:54:53.667363dda##AAGuest TitleGuest Titley2017-05-23 16:54:53.3902302017-05-23 16:54:53.664578ddc%%AAHero Title 3Hero Title 3y2017-05-23 16:54:53.3827992017-05-23 16:54:53.661721ddc%%AAHero Title 2Hero Title 2y2017-05-23 16:54:53.3750872017-05-23 16:54:53.658695dd   rMB 3 r\ /AAyMetadata keywordsdd2017-05-23 16:54:53.2068672017-05-23 16:54:53.206867false _ 5AAyMetadata descriptiondd2017-05-23 16:54:53.2039072017-05-23 16:54:53.203907false Y )AAyMetadata titledd2017-05-23 16:54:53.2007052017-05-23 16:54:53.200705falseV #AAyFooter Textdd2017-05-23 16:54:53.1974982017-05-23 16:54:53.197498falseW %AAyFooter Titledd2017-05-23 16:54:53.1943192017-05-23 16:54:53.194319falseU !AAyGuest Textdd2017-05-23 16:54:53.1909022017-05-23 16:54:53.190902falseV #AAyGuest Titledd2017-05-23 16:54:53.1869982017-05-23 16:54:53.186998falseW %AAyHero Title 3dd2017-05-23 16:54:53.1835962017-05-23 16:54:53.183596falseW %AAyHero Title 2dd2017-05-23 16:54:53.1794712017-05-23 16:54:53.179471falseV %AA yHero Title 1dd2017-05-23 16:54:53.1754892017-05-23 16:54:53.175489false 9why-visit-breckenridge5ski-jump-competition#Icomplete-guide-to-breckenridge welcome @>=HAA2017-05-23 16:54:53.5059202017-05-23 16:54:53.645582=GAA2017-05-23 16:54:53.4829842017-05-23 16:54:53.482984=FAA2017-05-23 16:54:53.4739192017-05-23 16:54:53.473919=EAA2017-05-23 16:54:53.4641112017-05-23 16:54:53.464111=D AA2017-05-23 16:54:53.3427452017-05-23 16:54:53.491177   P-Handpicked Homes O%Main Content  -PHandpicked Homes%OMain Content-PHandpicked Homes%OMain Content  Cr) {tn VMMtablepulitzer_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)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)   ] n  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)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) 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)??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")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)