test/dummy/db/test.sqlite3 in pulitzer-0.0.4 vs test/dummy/db/test.sqlite3 in pulitzer-0.0.5
- old
+ new
@@ -1,10 +1 @@
-SQLite format 3 @
- -
;
4 0
- 3; =//indexunique_schema_migrationsschema_migrations CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l
-//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)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)E)+indexindex_pulitzer_posts_on_slugpulitzer_posts CREATE UNIQUE INDEX "index_pulitzer_posts_on_slug" ON "pulitzer_posts" ("slug")))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)}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, "template" boolean)
]]mtablepulitzer_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)11-tablepulitzer_post_tagspulitzer_post_tagsCREATE TABLE "pulitzer_post_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "label_id" integer, "label_type" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|??tablepulitzer_content_elementspulitzer_content_elementsCREATE TABLE "pulitzer_content_elements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar, "title" varchar, "body" text, "image" varchar, "post_id" integer, "post_type_content_element_type_id" integer, "content_element_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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^L:( )20150724150230)20150702150819)20150629195832)20150619215914)20150619213457)20150619213436)20150619204708
)20150619204615 )20150618225402 )20150618224344
-)20150716214850 )20150716214849)20150716214848)20150716214847)20150716214846)20150716214845)20150716214844)20150716214843)20150716214842)20150724152813
- 0
-|iVC )20150724150230)20150702150819)20150629195832)20150619215914)20150619213457)20150619213436)20150619204708)20150619204615
)20150618225402 )20150618224344 )20150716214850
-)20150716214849 )20150716214848)20150716214847)20150716214846)20150716214845)20150716214844)20150716214843)20150716214842) 20150724152813
\ No newline at end of file