test/dummy/db/test.sqlite3 in forest_liana-1.8.0 vs test/dummy/db/test.sqlite3 in forest_liana-1.8.1
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ ! ! - -p 7
+SQLite format 3 @ ! ! - -p 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
)20150609114636 )20150608150016)20150608133044)20150608133038)20150608132621)20150608132159)20150608131610)20150608131603)20150608131430)20150608130516
|iVC0
@@ -53,10 +53,10 @@
-
- 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-19 20:00:44.0000002017-09-19 20:00:44.000000A AASequoia2017-09-19 20:00:44.0000002017-09-19 20:00:44.000000> AAOak2017-09-19 20:00:44.0000002017-09-19 20:00:44.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-26 17:28:07.0000002017-09-26 17:28:07.000000A AASequoia2017-09-26 17:28:07.0000002017-09-26 17:28:07.000000> AAOak2017-09-26 17:28:07.0000002017-09-26 17:28:07.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)
\ No newline at end of file