test/dummy_without_community/db/development.sqlite3 in inkwell-1.2.0 vs test/dummy_without_community/db/development.sqlite3 in inkwell-1.4.1
- old
+ new
@@ -1,5 +1,5 @@
-SQLite format 3 @ 0
p^L:( )20130219152806)20130219152805
)20130213115835 )20130213115834 )20130213115833
+SQLite format 3 @ 7
p^L:( )20130313083917)20130313083916)20130313083915)20130219152806)20130219152805
)20130213115835 )20130213115834 )20130213115833
)20130208134750 )20130208134749)20130208134748)20130208134747)20130208134746)20130208134745)20130208134744)20130208134743)20121202112556)20121202111750
- {hUB/ )20130219152806)20130219152805)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))
! ! \--ktableinkwell_commentsinkwell_comments CREATE TABLE "inkwell_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "body" text, "parent_comment_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))
+ {hUB/ )20130313083917)20130313083916)20130313083915)20130219152806)20130219152805)20130213115835
)20130213115834 )20130213115833 )20130208134750
+)20130208134749 )20130208134748)20130208134747)20130208134746)20130208134745)20130208134744)20130208134743)20121202112556)20121202111750
Q QN 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)
! !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))
. , . {UtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "nick" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "follower_count" integer DEFAULT 0, "following_count" integer DEFAULT 0)\--ktableinkwell_commentsinkwell_comments CREATE TABLE "inkwell_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "body" text, "parent_comment_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))r11tableinkwell_followingsinkwell_followingsCREATE TABLE "inkwell_followings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "follower_id" integer, "followed_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
\ No newline at end of file