spec/dummy/db/development.sqlite3 in pulitzer-0.3.7 vs spec/dummy/db/development.sqlite3 in pulitzer-0.3.8
- old
+ new
@@ -1,202 +1,405 @@
+SQLite format 3 @ -
+
+0 ??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)p//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_postsCREATE UNIQUE INDEX "index_pulitzer_posts_on_slug" ON "pulitzer_posts" ("slug")$
+]]tablepulitzer_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)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:( )20151118032759)20151116162913)20151113220908)20151029221444)20151029221443
)20151026204453)20150902213853)20150901153531
+)20150724152813 )20150716214850)20150716214849)20150716214848)20150716214847)20150716214846)20150716214845)20150716214844)20150716214843)20150716214842
+ |iVC0
+ )20151118032759)20151116162913)20151113220908)20151029221444)20151029221443)20151026204453
)20150902213853)20150901153531)20150724152813
+)20150716214850 )20150716214849)20150716214848)20150716214847)20150716214846)20150716214845)20150716214844)20150716214843) 20150716214842
m z4m C AAMy work2016-03-02 16:16:21.2323072016-03-02 16:16:21.232307f@
+ AApepe2015-12-17 12:40:09.0822762015-12-17 12:40:09.082276f> AAva2015-12-06 18:56:05.0092422015-12-06 18:56:05.009242fD AAExplore2015-11-20 22:21:24.8717252015-11-20 22:21:24.871725tA AAtest2015-11-20 02:52:21.6005532015-11-20 02:52:21.600553fA AAjobs2015-11-18 19:05:29.1288162015-11-18 21:57:11.819791f
S !@d ,]pulitzer_post_type_content_element_typesS pulitzer_3pulitzer_post_types?pulitzer_content_elements|'pulitzer_tags| pulitzer_pos1pulitzer_post_tags pu,]pulitzer_post_type_content_element_typesq/pulitzer_versions)pulitzer_posts"Ipulitzer_content_element_types
A A > AAVideo2015-11-18 19:04:27.1668022015-11-18 19:04:27.166802> AAImage2015-11-18 19:04:27.1659092015-11-18 19:04:27.165909= AAText2015-11-18 19:04:27.1639132015-11-18 19:04:27.163913
]J
V #AAMy workunpublished2016-03-02 16:16:22.5359032016-03-02 16:16:22.535903my-workP
+ #AApepe
+unpublished2015-12-17 12:40:11.3680262015-12-17 12:40:11.368026pepeq #AA[va unpublished2015-12-06 18:56:05.0250552015-12-06 18:56:05.025055va-2056568a-4651-44d3-a537-47451ef463bfL #AAvaunpublished2015-11-20 22:22:07.1915092015-11-20 22:22:07.191509vaP #AAtestunpublished2015-11-20 02:52:21.6246152015-11-20 02:52:21.624615testO #AAjobsunpublished2015-11-18 19:05:29.5910412015-11-18 19:05:29.591041jobs
O)_
+
+D (iCy^+e1a b) 7 AA Slide 4 row 2 image 1$2015-11-20 22:22:07.7508892015-11-20 22:22:07.750889Nonedd_( 3 AA Slide 4 row 2 title#2015-11-20 22:22:07.7430862015-11-20 22:22:07.743086Nonedd`' 5 AA Slide 4 row 1 link 3"2015-11-20 22:22:07.7373322015-11-20 22:22:07.737332Noneddl& ; AA' Slide 4 row 1 content 3!2015-11-20 22:22:07.7305722015-11-20 22:22:07.730572Simple editorddb% 7 AA Slide 4 row 1 image 3 2015-11-20 22:22:07.7228132015-11-20 22:22:07.722813Nonedd`$ 5 AA Slide 4 row 1 link 22015-11-20 22:22:07.7160552015-11-20 22:22:07.716055Noneddl# ; AA' Slide 4 row 1 content 22015-11-20 22:22:07.7086552015-11-20 22:22:07.708655Simple editorddb" 7 AA Slide 4 row 1 image 22015-11-20 22:22:07.7000752015-11-20 22:22:07.700075Nonedd`! 5 AA Slide 4 row 1 link 12015-11-20 22:22:07.6941722015-11-20 22:22:07.694172Noneddl ; AA' Slide 4 row 1 content 12015-11-20 22:22:07.6881072015-11-20 22:22:07.688107Simple editorddb 7 AA Slide 4 row 1 image 12015-11-20 22:22:07.6809992015-11-20 22:22:07.680999Nonedd_ 3 AA Slide 4 row 1 title2015-11-20 22:22:07.6754362015-11-20 22:22:07.675436Noneddd + AA' Slide 4 content2015-11-20 22:22:07.6686812015-11-20 22:22:07.668681Simple editorddY '