test/dummy/db/development.sqlite3 in slug-engine-0.0.3 vs test/dummy/db/development.sqlite3 in slug-engine-0.1.0
- old
+ new
@@ -1,2 +1,2 @@
-SQLite format 3 @
[ [ :StableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime)1AtablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)b!!tablepermalinkspermalinksCREATE TABLE "permalinks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "content_id" integer, "content_type" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
)20111108195947)20111108195813)20111108194929
- )20111108195947)20111108195813)20111108194929
U 7AAslug/with/nested/pathPost2011-11-08 21:30:32.0966302011-11-13 21:25:18.652696
users!permalinks posts
F AATitlecontent2011-11-08 21:19:58.4458412011-11-08 21:19:58.445841
L )AAjohnjohn@localhost2011-11-13 22:03:11.9955982011-11-13 22:03:11.995598
+SQLite format 3 @ -
[ [ :StableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime)1AtablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)b!!tablepermalinkspermalinksCREATE TABLE "permalinks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "content_id" integer, "content_type" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
)20111108195947)20111108195813)20111108194929
+ )20111108195947)20111108195813)20111108194929
W7AAslug/G AAmy-postPost2012-05-27 14:34:22.2247292012-05-27 14:34:22.224729
users!permalinks posts
M )AAPost!This is a post2012-05-27 14:34:22.2230252012-05-27 14:34:22.223025
L )AAjohnjohn@localhost2011-11-13 22:03:11.9955982011-11-13 22:03:11.995598
\ No newline at end of file