spec/dummy/db/development.sqlite3 in pulitzer-0.4.12 vs spec/dummy/db/development.sqlite3 in pulitzer-0.4.13
- old
+ new
@@ -1,10 +1,13 @@
-SQLite format 3 @ -
-
-0 //?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)??tablepulitzer_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, "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)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)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_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)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)=//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
+SQLite format 3 @ 7 * 7 -
+
eZSM{ )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)VMM tablepulitzer_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_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, "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_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_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)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)=//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:(tbP>, )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
- )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
-
+
|iVC0
+r_L9&
)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 AAAmarillo2016-06-13 18:26:47.2585912016-06-13 18:26:47.258591f@ AAazul2016-06-13 18:23:08.0768662016-06-13 18:23:08.076866f@ AApepe2016-06-13 18:23:03.2396832016-08-30 14:51:38.484112t@ AAJobs2016-06-09 21:46:57.5210562016-06-10 19:06:24.685015f
77nP 3pulitzer_post_types ? pulitzer_content_elements+] pulitzer_post_type_content_element_types pulitzer_posts)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 #AA Amarillounpublished2016-06-13 18:26:48.2359722016-08-30 14:42:47.258182amarillo2P #AAazulunpublished2016-06-13 18:23:08.8166002016-06-13 18:23:08.816600azulP #AApepeunpublished2016-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
R AA pepesafd2016-06-09 21:47:06.6046212016-06-09 21:47:13.978284Nonedd
H
+ AApepedd2016-06-09 21:47:06.3587022016-06-09 21:47:06.358702None
+
amarillo2azulpepe jobs24678
G = AA 2016-08-30 15:08:39.0565432016-08-30 15:08:39.056543= AA 2016-06-13 18:23:03.7147092016-08-30 15:08:38.664535< AA 2016-08-30 15:06:22.0662472016-08-30 15:06:22.149182< AA 2016-06-13 18:26:48.2479392016-06-13 18:26:48.247939< AA 2016-06-13 18:23:08.8184982016-06-13 18:23:08.818498< AA 2016-08-30 15:08:39.0565432016-08-30 15:08:39.143732; AA 2016-06-09 21:46:57.7157132016-06-09 21:46:57.715713
+
@ 6
eZ93 6.Q 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)VMM tablepulitzer_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")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_elementsCREATE 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_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_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)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)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
\ No newline at end of file