test/dummy/db/test.sqlite3 in forest_liana-1.7.7 vs test/dummy/db/test.sqlite3 in forest_liana-1.7.8
- old
+ new
@@ -1,13 +1,13 @@
-SQLite format 3 @ ! ! - -p 7
+SQLite format 3 @ E E .@ 7
dG `h` atabletreestreesCREATE TABLE "trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer)p;tableownersownersCREATE TABLE "owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar);;=tablehas_many_through_fieldshas_many_through_fieldsCREATE TABLE "has_many_through_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL) AACtablehas_many_class_name_fieldshas_many_class_name_fieldsCREATE TABLE "has_many_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)3e1]indexindex_polymorphic_fields_on_has_one_field_idpolymorphic_fieldsCREATE INDEX "index_polymorphic_fields_on_has_one_field_id" ON "polymorphic_fields" ("has_one_field_id") 11ktablepolymorphic_fieldspolymorphic_fieldsCREATE TABLE "polymorphic_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_one_field_id" integer)(IIKtablehas_and_belongs_to_many_fieldshas_and_belongs_to_many_fieldsCREATE TABLE "has_and_belongs_to_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)=eE]indexindex_belongs_to_class_name_fields_on_foo_idbelongs_to_class_name_fieldsCREATE INDEX "index_belongs_to_class_name_fields_on_foo_id" ON "belongs_to_class_name_fields" ("foo_id")4EEktablebelongs_to_class_name_fieldsbelongs_to_class_name_fieldsCREATE TABLE "belongs_to_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "foo_id" integer)Bq+uindexindex_has_many_fields_on_has_many_through_field_idhas_many_fieldsCREATE INDEX "index_has_many_fields_on_has_many_through_field_id" ON "has_many_fields" ("has_many_through_field_id") ++wtablehas_many_fieldshas_many_fieldsCREATE TABLE "has_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_many_through_field_id" integer)x))+tablehas_one_fieldshas_one_fieldsCREATE TABLE "has_one_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)2
e/]indexindex_belongs_to_fields_on_has_many_field_idbelongs_to_fieldsCREATE INDEX "index_belongs_to_fields_on_has_many_field_id" ON "belongs_to_fields" ("has_many_field_id")S {/ indexindex_belongs_to_fields_on_has_many_class_name_field_idbelongs_to_fields
CREATE INDEX "index_belongs_to_fields_on_has_many_class_name_field_id" ON "belongs_to_fields" ("has_many_class_name_field_id")/ c/Yindexindex_belongs_to_fields_on_has_one_field_idbelongs_to_fields CREATE INDEX "index_belongs_to_fields_on_has_one_field_id" ON "belongs_to_fields" ("has_one_field_id")b
//stablebelongs_to_fieldsbelongs_to_fields CREATE TABLE "belongs_to_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_one_field_id" integer, "has_many_class_name_field_id" integer, "has_many_field_id" integer) ''Ktablestring_fieldsstring_fields
-CREATE TABLE "string_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar) ))Mtableboolean_fieldsboolean_fields CREATE TABLE "boolean_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" boolean)%%Etablefloat_fieldsfloat_fieldsCREATE TABLE "float_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" float) ))Mtabledecimal_fieldsdecimal_fieldsCREATE TABLE "decimal_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" decimal) ))Mtableinteger_fieldsinteger_fieldsCREATE TABLE "integer_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}##Atabledate_fieldsdate_fieldsCREATE TABLE "date_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" date)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT
p^L:( )20170615120421)20170614141921)20160628173505)20160627172951)20160627172810)20150814081918
)20150623115554 )20150616150629 )20150612112520
+CREATE TABLE "string_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar) ))Mtableboolean_fieldsboolean_fields CREATE TABLE "boolean_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" boolean)%%Etablefloat_fieldsfloat_fieldsCREATE TABLE "float_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" float) ))Mtabledecimal_fieldsdecimal_fieldsCREATE TABLE "decimal_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" decimal) ))Mtableinteger_fieldsinteger_fieldsCREATE TABLE "integer_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}##Atabledate_fieldsdate_fieldsCREATE TABLE "date_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" date)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT
p^L:( )20170614141921)20160628173505)20160627172951)20160627172810)20150814081918
)20150623115554 )20150616150629 )20150612112520
)20150609114636 )20150608150016)20150608133044)20150608133038)20150608132621)20150608132159)20150608131610)20150608131603)20150608131430)20150608130516
|iVC0
- )20170615120421)20170614141921)20160628173505)20160627172951)20160627172810)20150814081918)20150623115554
)20150616150629 )20150612112520 )20150609114636
-)20150608150016 )20150608133044)20150608133038)20150608132621)20150608132159)20150608131610)20150608131603)20150608131430) 20150608130516
c yc> # Kserialize_and_belongs_to_fields-serialize_fields trees'string_fields
+ )20170614141921)20160628173505)20160627172951)20160627172810)20150814081918)20150623115554
)20150616150629 )20150612112520 )20150609114636
+)20150608150016 )20150608133044)20150608133038)20150608132621)20150608132159)20150608131610)20150608131603)20150608131430) 20150608130516
c nc trees'string_fields -serialize_fields
owners)has_one_fields ;has_many_through_fields
+has_many_fields
/belongs_to_fields
ymaUI=1%
Test 30
Test 29
@@ -53,17 +53,16 @@
-
- p- A AAJohn Doe2015-05-02 09:00:00.0000002016-06-28 08:00:00.000000G )AAArnaud Besnier2017-05-02 09:00:00.0000002017-06-28 08:00:00.000000E %AASandro Munda2016-05-30 09:00:00.0000002017-06-27 20:00:00.000000
~;{8
= AAFir2017-08-23 20:03:02.0000002017-08-23 20:03:02.000000A AASequoia2017-08-23 20:03:02.0000002017-08-23 20:03:02.000000> AAOak2017-08-23 20:03:02.0000002017-08-23 20:03:02.000000> AAOak2014-06-18 09:00:00.0000002014-06-18 09:00:00.000000> AAOak2015-06-18 09:00:00.0000002015-06-18 09:00:00.000000A AAMapple2012-04-11 12:00:00.0000002012-04-11 12:00:00.000000A AAMapple2010-02-15 21:00:00.0000002010-02-15 21:00:00.000000= AAOak2010-02-11 11:00:00.0000002010-02-11 11:00:00.000000
+
- p- A AAJohn Doe2015-05-02 09:00:00.0000002016-06-28 08:00:00.000000G )AAArnaud Besnier2017-05-02 09:00:00.0000002017-06-28 08:00:00.000000E %AASandro Munda2016-05-30 09:00:00.0000002017-06-27 20:00:00.000000
~;{8
= AAFir2017-09-05 14:11:22.0000002017-09-05 14:11:22.000000A AASequoia2017-09-05 14:11:22.0000002017-09-05 14:11:22.000000> AAOak2017-09-05 14:11:22.0000002017-09-05 14:11:22.000000> AAOak2014-06-18 09:00:00.0000002014-06-18 09:00:00.000000> AAOak2015-06-18 09:00:00.0000002015-06-18 09:00:00.000000A AAMapple2012-04-11 12:00:00.0000002012-04-11 12:00:00.000000A AAMapple2010-02-15 21:00:00.0000002010-02-15 21:00:00.000000= AAOak2010-02-11 11:00:00.0000002010-02-11 11:00:00.000000
7
dG `h D tableownersownersCREATE TABLE "owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime)g; indexindex_trees_on_owner_idtreesCREATE INDEX "index_trees_on_owner_id" ON "trees" ("owner_id") atabletreestreesCREATE TABLE "trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer);;=tablehas_many_through_fieldshas_many_through_fieldsCREATE TABLE "has_many_through_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL) AACtablehas_many_class_name_fieldshas_many_class_name_fieldsCREATE TABLE "has_many_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)3e1]indexindex_polymorphic_fields_on_has_one_field_idpolymorphic_fieldsCREATE INDEX "index_polymorphic_fields_on_has_one_field_id" ON "polymorphic_fields" ("has_one_field_id") 11ktablepolymorphic_fieldspolymorphic_fieldsCREATE TABLE "polymorphic_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_one_field_id" integer)(IIKtablehas_and_belongs_to_many_fieldshas_and_belongs_to_many_fieldsCREATE TABLE "has_and_belongs_to_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)=eE]indexindex_belongs_to_class_name_fields_on_foo_idbelongs_to_class_name_fieldsCREATE INDEX "index_belongs_to_class_name_fields_on_foo_id" ON "belongs_to_class_name_fields" ("foo_id")4EEktablebelongs_to_class_name_fieldsbelongs_to_class_name_fieldsCREATE TABLE "belongs_to_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "foo_id" integer)Bq+uindexindex_has_many_fields_on_has_many_through_field_idhas_many_fieldsCREATE INDEX "index_has_many_fields_on_has_many_through_field_id" ON "has_many_fields" ("has_many_through_field_id") ++wtablehas_many_fieldshas_many_fieldsCREATE TABLE "has_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_many_through_field_id" integer)x))+tablehas_one_fieldshas_one_fieldsCREATE TABLE "has_one_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)2
e/]indexindex_belongs_to_fields_on_has_many_field_idbelongs_to_fieldsCREATE INDEX "index_belongs_to_fields_on_has_many_field_id" ON "belongs_to_fields" ("has_many_field_id")S {/ indexindex_belongs_to_fields_on_has_many_class_name_field_idbelongs_to_fields
CREATE INDEX "index_belongs_to_fields_on_has_many_class_name_field_id" ON "belongs_to_fields" ("has_many_class_name_field_id")/ c/Yindexindex_belongs_to_fields_on_has_one_field_idbelongs_to_fields CREATE INDEX "index_belongs_to_fields_on_has_one_field_id" ON "belongs_to_fields" ("has_one_field_id")b
//stablebelongs_to_fieldsbelongs_to_fields CREATE TABLE "belongs_to_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_one_field_id" integer, "has_many_class_name_field_id" integer, "has_many_field_id" integer) ''Ktablestring_fieldsstring_fields
-CREATE TABLE "string_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar) ))Mtableboolean_fieldsboolean_fields CREATE TABLE "boolean_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" boolean)%%Etablefloat_fieldsfloat_fieldsCREATE TABLE "float_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" float) ))Mtabledecimal_fieldsdecimal_fieldsCREATE TABLE "decimal_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" decimal) ))Mtableinteger_fieldsinteger_fieldsCREATE TABLE "integer_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}##Atabledate_fieldsdate_fieldsCREATE TABLE "date_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" date)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
]
! v
-~ GC k Kindexindex_serialize_and_belongs_to_fields_on_has_many_field_idserialize_and_belongs_to_fields!CREATE INDEX "index_serialize_and_belongs_to_fields_on_has_many_field_id" ON "serialize_and_belongs_to_fields" ("has_many_field_id")Kindexindex_serializg Kindexindex_serialize_and_belongs_to_fields_on_has_one_field_idserialize_and_belongs_to_fields CREATE INDEX "index_serialize_and_belongs_to_fields_on_has_one_field_id" ON "serialize_and_belongs_to_fields" ("has_one_field_id") KK'tableserialize_and_belongs_to_fieldsserialize_and_belongs_to_fields CREATE TABLE "serialize_and_belongs_to_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar, "has_one_field_id" integer)/=tabletreestreesCREATE TABLE "trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer, "created_at" datetime, "updated_at" datetime)g; indexindex_trees_on_owner_idtreesCREATE INDEX "index_trees_on_owner_id" ON "trees" ("owner_id") --Qtableserialize_fieldsserialize_fields CREATE TABLE "serialize_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar) tableownersownersCREATE TABLE "owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime);;=tablehas_many_through_fieldshas_many_through_fieldsCREATE TABLE "has_many_through_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL) AACtablehas_many_class_name_fieldshas_many_class_name_fieldsCREATE TABLE "has_many_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)3e1]indexindex_polymorphic_fields_on_has_one_field_idpolymorphic_fieldsCREATE INDEX "index_polymorphic_fields_on_has_one_field_id" ON "polymorphic_fields" ("has_one_field_id") 11ktablepolymorphic_fieldspolymorphic_fieldsCREATE TABLE "polymorphic_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_one_field_id" integer)(IIKtablehas_and_belongs_to_many_fieldshas_and_belongs_to_many_fieldsCREATE TABLE "has_and_belongs_to_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)=eE]indexindex_belongs_to_class_name_fields_on_foo_idbelongs_to_class_name_fieldsCREATE INDEX "index_belongs_to_class_name_fields_on_foo_id" ON "belongs_to_class_name_fields" ("foo_id")4EEktablebelongs_to_class_name_fieldsbelongs_to_class_name_fieldsCREATE TABLE "belongs_to_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "foo_id" integer)Bq+uindexindex_has_many_fields_on_has_many_through_field_idhas_many_fieldsCREATE INDEX "index_has_many_fields_on_has_many_through_field_id" ON "has_many_fields" ("has_many_through_field_id") ++wtablehas_many_fieldshas_many_fieldsCREATE TABLE "has_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_many_through_field_id" integer)
+CREATE TABLE "string_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar) ))Mtableboolean_fieldsboolean_fields CREATE TABLE "boolean_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" boolean)%%Etablefloat_fieldsfloat_fieldsCREATE TABLE "float_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" float) ))Mtabledecimal_fieldsdecimal_fieldsCREATE TABLE "decimal_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" decimal) ))Mtableinteger_fieldsinteger_fieldsCREATE TABLE "integer_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}##Atabledate_fieldsdate_fieldsCREATE TABLE "date_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" date)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
]
! v
+~ GC /=tabletreestreesCREATE TABLE "trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer, "created_at" datetime, "updated_at" datetime)g; indexindex_trees_on_owner_idtreesCREATE INDEX "index_trees_on_owner_id" ON "trees" ("owner_id") --Qtableserialize_fieldsserialize_fields CREATE TABLE "serialize_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "field" varchar) tableownersownersCREATE TABLE "owners" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime);;=tablehas_many_through_fieldshas_many_through_fieldsCREATE TABLE "has_many_through_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL) AACtablehas_many_class_name_fieldshas_many_class_name_fieldsCREATE TABLE "has_many_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)3e1]indexindex_polymorphic_fields_on_has_one_field_idpolymorphic_fieldsCREATE INDEX "index_polymorphic_fields_on_has_one_field_id" ON "polymorphic_fields" ("has_one_field_id") 11ktablepolymorphic_fieldspolymorphic_fieldsCREATE TABLE "polymorphic_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_one_field_id" integer)(IIKtablehas_and_belongs_to_many_fieldshas_and_belongs_to_many_fieldsCREATE TABLE "has_and_belongs_to_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL)=eE]indexindex_belongs_to_class_name_fields_on_foo_idbelongs_to_class_name_fieldsCREATE INDEX "index_belongs_to_class_name_fields_on_foo_id" ON "belongs_to_class_name_fields" ("foo_id")4EEktablebelongs_to_class_name_fieldsbelongs_to_class_name_fieldsCREATE TABLE "belongs_to_class_name_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "foo_id" integer)Bq+uindexindex_has_many_fields_on_has_many_through_field_idhas_many_fieldsCREATE INDEX "index_has_many_fields_on_has_many_through_field_id" ON "has_many_fields" ("has_many_through_field_id") ++wtablehas_many_fieldshas_many_fieldsCREATE TABLE "has_many_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "has_many_through_field_id" integer)
value 5
value 4
value 3
value 2
- value 1
value 6 value 6 value 5 value 4 value 3 value 2
[[value 1
-
+ value 1
\ No newline at end of file