development.sqlite3 in pulitzer-0.15.21

- old
+ new
@@ -1,18 +1,15 @@
-SQLite format 3@  "0".@ûû)
×ÜÀ
-¶	†{PM-[ÅH„r??ˆstablepulitzer_content_elementspulitzer_content_elements
-CREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar DEFAULT NULL, "title" varchar DEFAULT NULL, "body" text DEFAULT NULL, "image" varchar DEFAULT NULL, "version_id" integer DEFAULT NULL, "post_type_content_element_type_id" integer DEFAULT NULL, "content_element_type_id" integer DEFAULT NULL, "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_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")O//‚Mtablepulitzer_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)‚33ƒatablepulitzer_post_typespulitzer_post_typesCREATE TABLE "pulitzer_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "plural" boolean DEFAULT NULL, "kind" integer DEFAULT 0)‚+11„tablepulitzer_post_tagspulitzer_post_tagsCREATE TABLE "pulitzer_post_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer DEFAULT NULL, "label_id" integer DEFAULT NULL, "label_type" varchar DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚//ƒ?tablepulitzer_versionspulitzer_versionsCREATE 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_postsCREATE 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)xII‚ktablepulitzer_content_element_typespulitzer_content_element_typesCREATE 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_sequenceCREATE TABLE sqlite_sequence(name,seq)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataN55‚?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)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY
 
ÀîÜÊ¸¦”‚p^L:(òàÎ¼ª˜†tbP>,
ö
ä
Ò
À )20170515230633)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)20150619213436)20150619204708)20150619204615)20150618225402)20150618224344
- 
¡îÛÈµ¢|iVC0
-÷äÑ¾«˜…r_L9&
í
Ú
Ç
´
¡)20170515230633 )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)20150619213436)20150619204708)20150619204615)20150618225402)	20150618224344

-

ÜÅ§3pulitzer_post_types?pulitzer_content_elements1pulitzer_post_tags"Ipulitzer_content_element_types
AÁA>AAVideo2017-09-18 16:02:38.7535222017-09-18 16:02:38.753522>AAImage2017-09-18 16:02:38.7507062017-09-18 16:02:38.750706=AAText2017-09-18 16:02:38.7473172017-09-18 16:02:38.747317





+SQLite format 3@  ".@ûûÎ
+ž	é	*0™’@8‚O	ƒ!tablepulitzer_post_type_content_element_type_custom_option_listspulitzer_post_type_content_element_type_custom_option_listsCREATE 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)‚
11ƒ3tablepulitzer_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_partialspulitzer_partials
CREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_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_version_id" integer)w
+GG‚mtablepulitzer_justification_stylespulitzer_justification_stylesCREATE TABLE "pulitzer_justification_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_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)tMM‚[tablepulitzer_free_form_section_typespulitzer_free_form_section_types	CREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "name" varchar, "sort_order" integer)X;;‚Gtablepulitzer_custom_optionspulitzer_custom_optionsCREATE TABLE "pulitzer_custom_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "custom_option_list_id" integer, "display" varchar, "value" varchar)2EEgtablepulitzer_custom_option_listspulitzer_custom_option_listsCREATE TABLE "pulitzer_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)„-??‡itablepulitzer_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, "partial_id" integer, "style_id" integer, "custom_option_id" integer)xII‚ktablepulitzer_content_element_typespulitzer_content_element_typesCREATE TABLE "pulitzer_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)nAA‚gtablepulitzer_background_stylespulitzer_background_stylesCREATE TABLE "pulitzer_background_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "display_name" varchar, "css_class_name" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)qCC‚itablepulitzer_arrangement_stylespulitzer_arrangement_stylesCREATE TABLE "pulitzer_arrangement_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "display_name" varchar, "view_file_name" var















@º
ÉÎ
+ž	é	*0™’@8‚O	ƒ!tablepulitzer_post_type_content_element_type_custom_option_listspulitzer_post_type_content_element_type_custom_option_listsCREATE 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)‚
11ƒ3tablepulitzer_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_partialspulitzer_partials
CREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_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_version_id" integer)w
+GG‚mtablepulitzer_justification_stylespulitzer_justification_stylesCREATE TABLE "pulitzer_justification_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_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)tMM‚[tablepulitzer_free_form_section_typespulitzer_free_form_section_types	CREATE TABLE "pulitzer_free_form_section_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "name" varchar, "sort_order" integer)X;;‚Gtablepulitzer_custom_optionspulitzer_custom_optionsCREATE TABLE "pulitzer_custom_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "custom_option_list_id" integer, "display" varchar, "value" varchar)2EEgtablepulitzer_custom_option_listspulitzer_custom_option_listsCREATE TABLE "pulitzer_custom_option_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)„-??‡itablepulitzer_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, "partial_id" integer, "style_id" integer, "custom_option_id" integer)xII‚ktablepulitzer_content_element_typespulitzer_content_element_typesCREATE TABLE "pulitzer_content_element_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)nAA‚gtablepulitzer_background_stylespulitzer_background_stylesCREATE TABLE "pulitzer_background_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "display_name" varchar, "css_class_name" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)qCC‚itablepulitzer_arrangement_stylespulitzer_arrangement_stylesCREATE TABLE "pulitzer_arrangement_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "display_name" varchar, "view_file_name" varchar)
+âìôB¹¿âö`
V‘
o@
+_‰Z++‚ktablepulitzer_stylespulitzer_stylesCREATE TABLE "pulitzer_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_content_element_type_id" integer, "display_name" varchar, "css_class_name" varchar)wGG‚mtablepulitzer_sequence_flow_stylespulitzer_sequence_flow_stylesCREATE TABLE "pulitzer_sequence_flow_styles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_version_id" integer, "display_name" varchar, "css_class_name" varchar)E)+indexindex_pulitzer_posts_on_slugpulitzer_postsCREATE UNIQUE INDEX "index_pulitzer_posts_on_slug" ON "pulitzer_posts" ("slug")/e)]indexindex_pulitzer_posts_on_post_type_version_idpulitzer_postsCREATE INDEX "index_pulitzer_posts_on_post_type_version_id" ON "pulitzer_posts" ("post_type_version_id")‚!))ƒ}tablepulitzer_postspulitzer_postsCREATE TABLE "pulitzer_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "status" varchar DEFAULT 'unpublished', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "slug" varchar, "post_type_version_id" integer)‚33ƒ-tablepulitzer_post_typespulitzer_post_typesCREATE 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)KoCqindexindex_pulitzer_post_type_versions_on_post_type_idpulitzer_post_type_versionsCREATE INDEX "index_pulitzer_post_type_versions_on_post_type_id" ON "pulitzer_post_type_versions" ("post_type_id")‚CCƒ)tablepulitzer_post_type_versionspulitzer_post_type_versionsCREATE TABLE "pulitzer_post_type_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "version_number" integer DEFAULT 1 NOT NULL, "status" varchar DEFAULT 'preview' NOT NULL)„]]†ytablepulitzer_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_version_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)‰Iƒ!tablepulitzer_post_type_content_element_type_custom_option_li‚
77ƒ9tablepulitzer_partial_tagspulitzer_partial_tags"CREATE TABLE "pulitzer_partial_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "partial_id" integer, "label_id" integer, "label_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)N55‚?tablear_internal_metadataar_internal_metadata CREATE 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!
Nx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations‚//ƒ=tablepulitzer_versionspulitzer_versionsCREATE 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_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")‚''ƒ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)

 


-

	š†Cr)
×ÜÀ
-¶š†{PM-[ÅwoVMM‚tablepulitzer_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)+??ˆstablepulitzer_content_elementspulitzer_content_elements
-CREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar DEFAULT NULL, "title" varchar DEFAULT NULL, "body" text DEFAULT NULL, "image" varchar DEFAULT NULL, "version_id" integer DEFAULT NULL, "post_type_content_element_type_id" integer DEFAULT NULL, "content_element_type_id" integer DEFAULT NULL, "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_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")O//‚Mtablepulitzer_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)‚33ƒatablepulitzer_post_typespulitzer_post_typesCREATE TABLE "pulitzer_post_types" ("id" INTEGER PRIMARƒ^]]†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_versionsCREATE 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_postsCREATE 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)xII‚ktablepulitzer_content_element_typespulitzer_content_element_typesCREATE 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_sequenceCREATE TABLE sqlite_sequence(name,seq)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataN55‚?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)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)

üÙ]=n	ÕfðÙ	‚CCƒ/tablepulitzer_post_type_versionspulitzer_post_type_versionsCREATE TABLE "pulitzer_post_type_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "version_number" integer DEFAULT 1 NOT NULL, "status" varchar DEFAULT 'incomplete' NOT NULL)„{??‰tablepulitzer_content_elementspulitzer_content_elements
-CREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar DEFAULT NULL, "body" text DEFAULT NULL, "image" varchar DEFAULT NULL, "version_id" integer DEFAULT NULL, "post_type_content_element_type_id" integer DEFAULT NULL, "content_element_type_id" integer DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "text_editor" varchar DEFAULT NULL, "height" integer DEFAULT 100, "width" integer DEFAULT 100, "sort_order" integer DEFAULT NULL, "kind" integer DEFAULT 0, "partial_id" integer DEFAULT NULL)u//ƒ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)&--tablepulitzer_layoutspulitzer_layoutsCREATE TABLE "pulitzer_layouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "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)
-kMM‚tKoCqindexindex_pulitzer_post_type_versions_on_post_type_idpulitzer_post_type_versionsCREATE INDEX "index_pulitzer_post_type_versions_on_post_type_id" ON "pulitzer_post_type_versions" ("post_type_id")S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")
‹Ò//‚Mtablepulitzer_partialspulitzer_partialsCREATE TABLE "pulitzer_partials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_type_id" integer, "free_form_section_id" integer, "sort_order" ‚33ƒatablepulitzer_post_typespulitzer_post_typesCREATE TABLE "pulitzer_post_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "plural" boolean DEFAULT NULL, "kind" integer DEFAULT 0)‚+11„tablepulitzer_post_tagspulitzer_post_tagsCREATE TABLE "pulitzer_post_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_id" integer DEFAULT NULL, "label_id" integer DEFAULT NULL, "label_type" varchar DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)z??ˆstablepulitzer_content_elementspulitzer_content_elements
-CREATE TABLE "pulitzer_content_elements" ("id" INTEGER P‚	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)lMM‚Ktablepulitzer_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)



-
+
+



+

ÜîÜ)20170913214214)20170602204900
+ÛîÛ)20170913214214)	20170602204900
¯¯O##AAenvironmentdevelopment2017-09-19 19:05:46.0151082017-09-19 19:05:46.015108
+ññ#	environment

\ No newline at end of file