test/dummy/db/test.sqlite3 in forest_liana-2.5.2 vs test/dummy/db/test.sqlite3 in forest_liana-2.5.3
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ ? ? . 7
+SQLite format 3 @ @ @ . 7
dR080 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)')) tablehas_one_fieldshas_one_fieldsCREATE TABLE "has_one_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "checked" boolean, "status" integer DEFAULT 0)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:( )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 Doe2016-05-02 09:00:00.0000002017-06-28 08:00:00.000000G )AAArnaud Besnier2018-05-02 09:00:00.0000002018-06-28 08:00:00.000000E %AASandro Munda2017-05-30 09:00:00.0000002018-06-27 20:00:00.000000
~;{8
= AAFir2018-04-16 18:58:56.0000002018-04-16 18:58:56.000000A AASequoia2018-04-16 18:58:56.0000002018-04-16 18:58:56.000000> AAOak2018-04-16 18:58:56.0000002018-04-16 18:58:56.000000> AAOak2015-06-18 09:00:00.0000002015-06-18 09:00:00.000000> AAOak2016-06-18 09:00:00.0000002016-06-18 09:00:00.000000A AAMapple2013-04-11 12:00:00.0000002013-04-11 12:00:00.000000A AAMapple2011-02-15 21:00:00.0000002011-02-15 21:00:00.000000= AAOak2011-02-11 11:00:00.0000002011-02-11 11:00:00.000000
+
- p- A AAJohn Doe2016-05-02 09:00:00.0000002017-06-28 08:00:00.000000G )AAArnaud Besnier2018-05-02 09:00:00.0000002018-06-28 08:00:00.000000E %AASandro Munda2017-05-30 09:00:00.0000002018-06-27 20:00:00.000000
~;{8
= AAFir2018-05-09 14:31:28.0000002018-05-09 14:31:28.000000A AASequoia2018-05-09 14:31:28.0000002018-05-09 14:31:28.000000> AAOak2018-05-09 14:31:28.0000002018-05-09 14:31:28.000000> AAOak2015-06-18 09:00:00.0000002015-06-18 09:00:00.000000> AAOak2016-06-18 09:00:00.0000002016-06-18 09:00:00.000000A AAMapple2013-04-11 12:00:00.0000002013-04-11 12:00:00.000000A AAMapple2011-02-15 21:00:00.0000002011-02-15 21:00:00.000000= AAOak2011-02-11 11:00:00.0000002011-02-11 11:00:00.000000
7
dR08 C C 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) ;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)')) tablehas_one_fieldshas_one_fieldsCREATE TABLE "has_one_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "checked" boolean, "status" integer DEFAULT 0)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
~ 6q> --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)g; indexindex_trees_on_owner_idtreesCREATE INDEX "index_trees_on_owner_id" ON "trees" ("owner_id") \atabletreestreesCREATE TABLE "trees" ("id" INTEGER PRIMARY KEY AUTOINCREME /=tabletreestreesCREATE TABLE "trees" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "owner_id" integer, "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