development.sqlite3 in pulitzer-0.5.4

- old
+ new
@@ -1,15 +1,10 @@
-SQLite format 3@  Z+Z-æ
-ûû
»Ÿ•	î	eZËSM{åò)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)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)„??‡=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_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ƒ-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)‚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_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)=//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:(òàÎ¼ª˜†tbP>,
ö)20160927160910)20160609214139)20160519181030)20160517182500)20160517181706)20160516150237)20160513153214)20160513153209)20160512214545)20160511201527)20160511192041)20160122204201)20151118031237)20151116162508)20151113183344)20151029220558
)20151029194354)20151026180630)20150902212741
+SQLite format 3@  -æ
+
ã
Ç’¶
»Ÿ×
+0	§ÖÇÒÜÖ‚//ƒ?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)„??‡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)‚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)‚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_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)N--‚Otablesearch_locationssearch_locations
CREATE TABLE "search_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)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)E''‚Itablepulitzer_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)‚))ƒ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)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
ªîÜÊ¸¦”‚p^L:(òàÎ¼ª)20160122204201)20151118031237)20151116162508)20151113183344)20151029220558)20151029194354
)20151026180630)20150902212741)20150901153531
 )20150724150230	)20150702150819)20150629195832)20150619215914)20150619213457)20150619213436)20150619204708)20150619204615)20150618225402)20150618224344
-
ÚîÛÈµ¢|iVC0
-÷äÑ¾«˜…r_L9&
í
Ú)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
ô¾|:ôDAAAmarillo2016-06-13 18:26:47.2585912016-09-28 21:34:03.282205t@AAazul2016-06-13 18:23:08.0768662016-06-13 18:23:08.076866f@AApepe2016-06-13 18:23:03.2396832016-08-30 14:51:38.484112t@AAJobs2016-06-09 21:46:57.5210562016-06-10 19:06:24.685015f
P7Ü7±Åƒd3pulitzer_post_types	pulitzer_conten?pulitzer_content_elements	,]pulitzer_post_type_content_element_types)pulitzer_posts/pulitzer_versions	"Ipulitzer_content_element_types
AÁA>AAVideo2016-06-09 21:44:44.4375202016-06-09 21:44:44.437520>AAImage2016-06-09 21:44:44.4351992016-06-09 21:44:44.435199=AAText2016-06-09 21:44:44.4331202016-06-09 21:44:44.433120
´ªX´Y#AAP#AAJobsunpublished2016-06-13 18:26:48.2359722016-09-28 21:34:22.223842jobsP#AAazulunpublished2016-06-13 18:23:08.8166002016-06-13 18:23:08.816600azulP#AApepeunpublished2016-06-13 18:23:03.7001442016-06-13 18:23:03.700144pepeT	#AAJobsunpublished2016-06-09 21:46:57.7034572016-06-13 15:19:06.966024jobs24678

	õ¬šø<
Ýº
 Tõ]	/	AAan optional field	2016-09-27 16:49:39.3630972016-09-29 21:18:32.350551Noneddd-	AAa required fieldasdfasdf	2016-09-27 16:34:21.3713642016-09-29 21:18:32.309243Noneddd-	AAa required fieldasdfasdf2016-09-27 16:34:21.3713642016-09-29 21:17:09.137597Nonedd]/	AAan optional field2016-09-27 16:49:39.3630972016-09-27 22:00:09.000596NoneddW^/	AAan optional field2016-09-27 16:49:39.3630972016-09-27 22:00:09.000596Nonedd]/	AAan optional field2016-09-27 16:49:39.3630972016-09-27 21:58:17.088697Nonedd\-	AAa required field2016-09-27 16:34:21.3713642016-09-27 21:58:17.059189Nonedd\-	AAa required field2016-09-27 16:34:21.3713642016-09-27 16:49:48.297687Nonedd]/	AAan optional field2016-09-27 16:49:39.3630972016-09-27 16:49:39.363097NoneddU	AAnew one2016-09-27 16:34:21.3713642016-09-27 16:34:21.371364NoneddR			AApepesafd2016-06-09 21:47:06.6046212016-06-09 21:47:13.978284Nonedd


f¯¶¯W	-AAa required fielddd2016-09-27 16:34:21.3001112016-09-27 16:49:47.891791Nonet\	/AAan optional fielddd2016-09-27 16:49:38.6657752016-09-27 16:49:38.665775NonefalseP	AAnew onedd2016-09-27 16:34:21.3001112016-09-27 16:34:35.505500NonetH
-		AApepedd2016-06-09 21:47:06.3587022016-06-09 21:47:06.358702None
-ØáØóê
ajobsazulpepe	jobs24678
	
ÐÃŒGË…
Ð	N=	AA2016-09-29 21:18:30.8559722016-09-29 21:18:30.855972=AA2016-09-27 21:58:16.6832252016-09-29 21:18:30.816062=AA2016-06-13 18:26:48.2479392016-09-27 22:00:08.955207<	AA2016-09-29 21:18:30.8559722016-09-29 21:18:32.373414=AA2016-06-13 18:23:03.7147092016-08-30 15:08:38.664535<AA2016-08-30 15:06:22.0662472016-08-30 15:06:22.149182<	AA2016-09-27 22:00:08.9619892016-09-29 21:18:30.069862<AA2016-06-13 18:23:08.8184982016-06-13 18:23:08.818498<AA2016-08-30 15:08:39.0565432016-08-30 15:08:39.143732;	AA2016-06-09 21:46:57.7157132016-06-09 21:46:57.715713

-



@
-9’¶
»Ÿ•	eZ96Ä×.QQ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)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)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE 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)‚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)	îO??‡=tablepu„??‡tablepulitzer_content_elementspulitzer_content_elemeƒH
-]]…ctablepulitzer_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')‚
//ƒ?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)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
ôú
l“¦
-ýô„??‡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_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)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)S'9indexindex_pulitzer_tags_on_hierarchicalpulitzer_tagsCREATE INDEX "index_pulitzer_tags_on_hierarchical" ON "pulitzer_tags" ("hierarchical")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)‚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)
+˜îÛÈµ¢|iVC0
+÷äÑ¾«˜)20160122204201)20151118031237)20151116162508)20151113183344)20151029220558)20151029194354)20151026180630
)20150902212741)20150901153531)20150724150230
+)20150702150819	)20150629195832)20150619215914)20150619213457)20150619213436)20150619204708)20150619204615)20150618225402)	20150618224344

ÜÜ"Ipulitzer_content_element_types
AÁA>AAVideo2016-05-11 18:39:29.7508112016-05-11 18:39:29.750811>AAImage2016-05-11 18:39:29.7491782016-05-11 18:39:29.749178=AAText2016-05-11 18:39:29.7464422016-05-11 18:39:29.746442





+


\ No newline at end of file