test/dummy/db/development.sqlite3 in paper_trail-2.0.2 vs test/dummy/db/development.sqlite3 in paper_trail-2.1.0
- old
+ new
@@ -1,43 +1,7 @@
-SQLite format 3 @ û û;®TÄ- ¸ ´ s
-Etablebooksbooks CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255)) {tablearticlesarticles
-CREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" varchar(255))
qtablefluxorsfluxors CREATE TABLE "fluxors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "widget_id" integer, "name" varchar(255));‚MtablewotsitswotsitsCREATE TABLE "wotsits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "widget_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime)[ Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")ƒ
- …gtableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "answer" integer, "action" varchar(255), "question" varchar(255), "article_id" integer, "ip" varchar(255), "user_agent" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)‚s…=tablewidgetswidgetsCREATE TABLE "widgets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "a_text" text, "an_integer" integer, "a_float" float, "a_decimal" decimal, "a_datetime" datetime, "a_time" time, "a_date" date, "a_boolean" boolean, "created_at" datetime, "updated_at" datetime, "sacrificial_column" varchar(255), "type" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT
î î )20110208155312
- í í )20110208155312
º º D AA f2011-02-08 16:54:09.9452932011-02-08 16:54:09.945293
å óå versions
- widgets
o ɸ¦o 5
- A Widgetcreate2011-02-08 16:54:09.959649‚ ƒ=A Widgetdestroy---
-name: g
-sacrificial_column:
-created_at: 2011-02-08 16:25:52.890539 Z
-an_integer:
-a_boolean:
-updated_at: 2011-02-08 16:26:09.217998 Z
-a_time:
-a_text:
-id: 3
-a_date:
-type:
-a_datetime:
-a_float:
-a_decimal:
-2011-02-08 16:26:17.392684‚ ƒ=A Widgetupdate---
-name: f
-sacrificial_column:
-created_at: 2011-02-08 16:25:52.890539 Z
-an_integer:
-a_boolean:
-updated_at: 2011-02-08 16:25:52.890539 Z
-a_time:
-a_text:
-id: 3
-a_date:
-type:
-a_datetime:
-a_float:
-a_decimal:
-2011-02-08 16:26:09.2201005 A Widgetcreate2011-02-08 16:25:52.894850
- Ì óæÙÌ Widget
- Widget Widget Widget
® ®!«!sp ÊZñfq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")‚s…=tablewidgetswidgetsCREATE TABLE "widgets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "a_text" text, "an_integer" integer, "a_float" float, "a_decimal" decimal, "a_datetime" datetime, "a_time" time, "a_date" date, "a_boolean" boolean, "created_at" datetime, "updated_at" datetime, "sacrificial_column" varchar(255), "type" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ƒ
- …gtableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")‚s…=tablewidgetswidgetsCREATE TABLE "widgets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "a_text" text, "an_integer" integer, "a_float" float, "a_decimal" decimal, "a_datetime" datetime, "a_time" time, "a_date" date, "a_boolean" boolean, "created_at" datetime, "updated_at" datetime, "sacrificial_column" varchar(255), "type" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)ƒ
- …gtableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "answer" integer, "action" varchar(255), "question" varchar(255), "article_id" integer, "ip" varchar(255), "user_agent" varchar(255))
ü „ lÆVíbõ„ o
=tablesongssongsCREATE TABLE "songs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "length" integer)u EtablepeoplepeopleCREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))[ Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id");‚MtablewotsitswotsitsCREATE TABLE "wotsits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "widget_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime)
qtablefluxorsfluxors CREATE TABLE "fluxors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "widget_id" integer, "name" varchar(255)) {tablearticlesarticles
-CREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" varchar(255))s
-Etablebooksbooks CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255)) ##utableauthorshipsauthorships CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "book_id" integer, "person_id" integer)
+SQLite format 3 @ -â ñ ûöñ
î î )20110208155312
+ í í )20110208155312
; ;®8® 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")‚s…=tablewidgetswidgetsCREATE TABLE "widgets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "a_text" text, "an_integer" integer, "a_float" float, "a_decimal" decimal, "a_datetime" datetime, "a_time" time, "a_date" date, "a_boolean" boolean, "created_at" datetime, "updated_at" datetime, "sacrificial_column" varchar(255), "type" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)
“ “ ¼ ƒ
+ …gtableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "answer" integer, "action" varchar(255), "question" varchar(255), "article_id" integer, "ip" varchar(255), "user_agent" varchar(255))[ Gindexindex_versions_on_item_type_and_item_idversions CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")‚A''„Atablepost_versionspost_versions
+CREATE TABLE "post_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "ip" varchar(255), "user_agent" varchar(255))
+
+
R RÀP -e'[indexindex_post_versions_on_item_type_and_item_idpost_versions CREATE INDEX "index_post_versions_on_item_type_and_item_id" ON "post_versions" ("item_type", "item_id"); ‚Mtablewotsitswotsits
CREATE TABLE "wotsits" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "widget_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime)
+qtablefluxorsfluxorsCREATE TABLE "fluxors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "widget_id" integer, "name" varchar(255))- ‚-tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" varchar(255), "abstract" varchar(255))
{ zï‰ { utablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" varchar(255))o=tablesongssongsCREATE TABLE "songs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "length" integer)s EtablebooksbooksCREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
##utableauthorshipsauthorshipsCREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "book_id" integer, "person_id" integer)uEtablepeoplepeopleCREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))
\ No newline at end of file