spec/dummy/db/test.sqlite3 in enju_resource_merge-0.0.6 vs spec/dummy/db/test.sqlite3 in enju_resource_merge-0.0.7
- old
+ new
@@ -1,33 +1,33 @@
-SQLite format 3 @ D B G D - ;
+SQLite format 3 @ F B G F - ;
'U VtablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)V//[tableseries_statementsseries_statements CREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text, "numbering" text, "title_subseries" text, "numbering_subseries" text, "position" integer, "created_at" datetime, "updated_at" datetime, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "issn" varchar(255), "periodical" boolean, "manifestation_id" integer, "note" text)/c/Yindexindex_series_statements_on_manifestation_idseries_statementsCREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("manifestation_id")Os?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestationsCREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")Xy?indexindex_series_has_manifestations_on_series_statement_idseries_has_manifestationsCREATE INDEX "index_series_has_manifestations_on_series_statement_id" ON "series_has_manifestations" ("series_statement_id")??;tableseries_has_manifestationsseries_has_manifestationsCREATE TABLE "series_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "series_statement_id" integer, "manifestation_id" integer, "position" integer, "created_at" datetime, "updated_at" datetime)r
;)indexindex_series_statement_merges_on_series_statement_merge_list_idseries_statement_mergesCREATE INDEX "index_series_statement_merges_on_series_statement_merge_list_id" ON "series_statement_merges" ("series_statement_merge_list_id")Pu;}indexindex_series_statement_merges_on_series_statement_idseries_statement_merges
CREATE INDEX "index_series_statement_merges_on_series_statement_id" ON "series_statement_merges" ("series_statement_id");;Otableseries_statement_mergesseries_statement_mergesCREATE TABLE "series_statement_merges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "series_statement_id" integer NOT NULL, "series_statement_merge_list_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)f
EEOtableseries_statement_merge_listsseries_statement_merge_listsCREATE TABLE "series_statement_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime, "updated_at" datetime)P y/indexindex_series_statements_on_series_statement_identifierseries_statements
CREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")H11;tablepatron_merge_listspatron_merge_listsCREATE TABLE "patron_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime, "updated_at" datetime)+c'Yindexindex_patron_merges_on_patron_merge_list_idpatron_mergesCREATE INDEX "index_patron_merges_on_patron_merge_list_id" ON "patron_merges" ("patron_merge_list_id")
M'-indexindex_patron_merges_on_patron_idpatron_mergesCREATE INDEX "index_patron_merges_on_patron_id" ON "patron_merges" ("patron_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)j''tablepatron_mergespatron_mergesCREATE TABLE "patron_merges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "patron_merge_list_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar %%
tbP>, 125)201201060936036)20120106093356)20111201115540)2011120111552715)20111201163718)20111201155513)20111201155456
)20111201121844)20110918162329)20110916103953
)20110820131417 )20110627035057)20110627034940)20110618091240)20110425133109)20100321235924)20100223121519)20091214131723134133
~kXE2 125)201201060936036)20120106093356)20111201115540)2011120111552715)20111201163718)20111201155513)20111201155456)20111201121844
)20110918162329)20110916103953)20110820131417
)20110627035057 )20110627034940)20110618091240)20110425133109)20100321235924)20100223121519)20091214131723134133
F F < AA2008-02-17 10:19:19.2655572008-02-17 10:19:19.265557< AA2008-02-17 10:10:36.2828142008-02-17 10:14:03.461761< AA2008-02-17 09:51:36.7760092008-02-17 09:51:36.776009
kTI1 patrons
'patron_merges 1patron_merge_lists users)user_has_roles<;q;series_statement_merges Eseries_statement_merge_lists?series_has_manifestations roles)manifestations /series_statements
-
@ @ > AAtest32008-02-18 07:13:14.9631162008-02-18 07:13:14.963116> AAtest22008-02-18 07:13:10.7434372008-02-18 07:13:10.743437> AAtest12008-02-18 04:36:49.8357742008-02-18 04:36:49.835774
C C = 33 title32012-04-13 19:46:052012-04-13 19:46:05= 33 title22012-04-13 19:46:052012-04-13 19:46:05= 33 title12012-04-13 19:46:052012-04-13 19:46:05
+
@ @ > AAtest32008-02-18 07:13:14.9631162008-02-18 07:13:14.963116> AAtest22008-02-18 07:13:10.7434372008-02-18 07:13:10.743437> AAtest12008-02-18 04:36:49.8357742008-02-18 04:36:49.835774
C C = 33 title32012-05-08 20:48:172012-05-08 20:48:17= 33 title22012-05-08 20:48:172012-05-08 20:48:17= 33 title12012-05-08 20:48:172012-05-08 20:48:17
@ @ > AAtest32008-02-18 07:13:14.9631162008-02-18 07:13:14.963116> AAtest22008-02-18 07:13:10.7434372008-02-18 07:13:10.743437> AAtest12008-02-18 04:36:49.8357742008-02-18 04:36:49.835774
F F < AA2008-02-17 10:19:19.2655572008-02-17 10:19:19.265557< AA2008-02-17 10:10:36.2828142008-02-17 10:14:03.461761< AA2008-02-17 09:51:36.7760092008-02-17 09:51:36.776009
@ @ > AA2008-01-11 14:32:03.7014252008-01-11 14:32:03.701425> AA2008-01-11 14:28:57.0681912008-01-11 14:28:57.068191> AA2008-01-11 14:28:19.2771102008-01-11 14:28:19.277110
-
L H ''