spec/dummy/db/development.sqlite3 in power_resource-0.0.1 vs spec/dummy/db/development.sqlite3 in power_resource-0.0.2
- old
+ new
@@ -1,2 +1,5 @@
-SQLite format 3 @ -(
O P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)1AtablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "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)
)20130722165046
- ) 20130722165046
= = A AAtesting2013-07-22 17:08:39.7343772013-07-22 17:08:39.734377B AATesttest2013-07-22 17:08:23.7576422013-07-22 17:08:23.757642:
AA2013-07-22 17:08:18.4508852013-07-22 17:08:18.450885
posts
+SQLite format 3 @
+ -(
+
)20130916180755)20130916174608)20130915095616
+ )20130916180755)20130916174608) 20130915095616
$ a$ ;
AA2013-09-18 09:41:22.5792722013-09-18 09:41:22.579272N )AAPost for cat 2test2013-09-16 18:04:34.3768562013-09-16 18:04:34.376856M )AAPost for cat 1test2013-09-16 18:02:39.6505402013-09-16 18:04:23.611522
comments posts!categories
l l1 ; H +AATest Category 22013-09-16 18:01:36.9625052013-09-16 18:01:36.962505H +AATest Category 12013-09-16 18:01:29.8424382013-09-16 18:01:29.842438
U U U 3AAComment for post #2Jari J2013-09-16 18:10:23.4585782013-09-16 18:10:23.458578R 3AAComment for post #1Jari2013-09-16 18:10:11.3067222013-09-16 18:10:11.306722
Y q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")HotablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "title" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)
+
/!!)tablecategoriescategoriesCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)N otablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "post_id" integer, "content" text, "author" varchar(255), "created_at" datetime, "updated_at" datetime)p? indexindex_comments_on_post_idcomments CREATE INDEX "index_comments_on_post_id" ON "comments" ("post_id")
\ No newline at end of file