test/dummy_without_community/db/development.sqlite3 in inkwell-1.0.5 vs test/dummy_without_community/db/development.sqlite3 in inkwell-1.1.1
- old
+ new
@@ -1,8 +1,5 @@
-SQLite format 3 @
-L p^L
+SQLite format 3 @ .
p^L:(
)20130213115835 )20130213115834 )20130213115833
)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_items CREATE 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_comments CREATE 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 U 99Etableinkwell_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)
+
{hUB/ )20130213115835
)20130213115834 )20130213115833 )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 '[]')
! !Y 511tableinkwell_blog_itemsinkwell_blog_items
+CREATE TABLE "inkwell_blog_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "is_reblog" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "owner_id" integer, "item_type" varchar(255), "owner_type" varchar(255)),99stableinkwell_favorite_itemsinkwell_favorite_items CREATE TABLE "inkwell_favorite_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "owner_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "item_type" varchar(255), "owner_type" varchar(255))u99tableinkwell_timeline_itemsinkwell_timeline_itemsCREATE TABLE "inkwell_timeline_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "owner_id" integer, "from_source" text DEFAULT '[]', "has_many_sources" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "item_type" varchar(255), "owner_type" varchar(255))
) ) T--[tableinkwell_commentsinkwell_comments CREATE TABLE "inkwell_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "body" text, "parent_id" integer, "topmost_obj_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, "topmost_obj_type" varchar(255))
\ No newline at end of file