test/dummy_without_community/db/development.sqlite3 in inkwell-1.0.4 vs test/dummy_without_community/db/development.sqlite3 in inkwell-1.0.5
- old
+ new
@@ -1,4 +1,8 @@
-SQLite format 3 @
-
p p )20130120124015)20130120124014)20130120124013)20130120124012)20130120124011)20130120124010)20121202112556)20121202111750
- h {h )20130120124015)20130120124014)20130120124013)20130120124012)20130120124011)20130120124010)20121202112556)20121202111750
y y v 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")KutablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "user_id" integer, "created_at" datetime, "updated_at" datetime, "users_ids_who_favorite_it" text DEFAULT '[]', "users_ids_who_comment_it" text DEFAULT '[]', "users_ids_who_reblog_it" text DEFAULT '[]')P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)g-tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "nick" varchar(255), "created_at" datetime, "updated_at" datetime, "followers_ids" text DEFAULT '[]', "followings_ids" text DEFAULT '[]')
>99tableinkwell_timeline_itemsinkwell_timeline_itemsCREATE TABLE "inkwell_timeline_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "user_id" integer, "from_source" varchar(255), "has_many_sources" boolean DEFAULT 'f', "is_comment" boolean, "created_at" datetime, "updated_at" datetime)111tableinkwell_blog_itemsinkwell_blog_items
-CREATE TABLE "inkwell_blog_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "user_id" integer, "is_reblog" boolean, "is_comment" boolean, "created_at" datetime, "updated_at" datetime)z99tableinkwell_favorite_itemsinkwell_favorite_itemsCREATE TABLE "inkwell_favorite_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "user_id" integer, "is_comment" boolean, "created_at" datetime, "updated_at" datetime)
s --tableinkwell_commentsinkwell_commentsCREATE TABLE "inkwell_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "body" text, "parent_id" integer, "post_id" integer, "upper_comments_tree" text, "users_ids_who_favorite_it" text, "users_ids_who_comment_it" text, "users_ids_who_reblog_it" text, "created_at" datetime, "updated_at" datetime)
+SQLite format 3 @
+L p^L
+)20130208134750 )20130208134749)20130208134748)20130208134747)20130208134746)20130208134745)20130208134744)20130208134743)20121202112556)20121202111750
+
+B {hUB )20130208134750
+)20130208134749 )20130208134748)20130208134747)20130208134746)20130208134745)20130208134744)20130208134743)20121202112556)20121202111750
U U R 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")]tablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "users_ids_who_favorite_it" text DEFAULT '[]', "users_ids_who_comment_it" text DEFAULT '[]', "users_ids_who_reblog_it" text DEFAULT '[]')P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)yQtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "nick" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "followers_ids" text DEFAULT '[]', "followings_ids" text DEFAULT '[]')
B BQ 993tableinkwell_favorite_itemsinkwell_favorite_itemsCREATE TABLE "inkwell_favorite_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "user_id" integer, "is_comment" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL), --tableinkwell_commentsinkwell_commentsCREATE TABLE "inkwell_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "body" text, "parent_id" integer, "post_id" integer, "upper_comments_tree" text, "users_ids_who_favorite_it" text DEFAULT '[]', "users_ids_who_comment_it" text DEFAULT '[]', "users_ids_who_reblog_it" text DEFAULT '[]', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
r r U99Etableinkwell_timeline_itemsinkwell_timeline_itemsCREATE TABLE "inkwell_timeline_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "user_id" integer, "from_source" text DEFAULT '[]', "has_many_sources" boolean DEFAULT 'f', "is_comment" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/
+11 tableinkwell_blog_itemsinkwell_blog_items
+CREATE TABLE "inkwell_blog_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "is_reblog" boolean, "is_comment" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "owner_id" integer, "is_owner_user" boolean)
\ No newline at end of file