spec/dummy/db/test.sqlite3 in enju_resource_merge-0.0.9 vs spec/dummy/db/test.sqlite3 in enju_resource_merge-0.0.10

- old
+ new

@@ -1,6 +1,6 @@ -SQLite format 3@ BG -5{}T +SQLite format 3@ "BG"-5{}T ))ctablemanifestationsmanifestations CREATE TABLE "manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text NOT NULL, "title_alternative" text, "title_transcription" text, "classification_number" varchar(255), "manifestation_identifier" varchar(255), "date_of_publication" datetime, "copyright_date" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "access_address" varchar(255), "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "extent_id" integer DEFAULT 1 NOT NULL, "start_page" integer, "end_page" integer, "height" decimal, "width" decimal, "depth" decimal, "isbn" varchar(255), "isbn10" varchar(255), "wrong_isbn" varchar(255), "nbn" varchar(255), "lccn" varchar(255), "oclc_number" varchar(255), "issn" varchar(255), "price" integer, "fulltext" text, "volume_number_list" varchar(255), "issue_number_list" varchar(255), "serial_number_list" varchar(255), "edition" integer, "note" text, "produces_count" integer DEFAULT 0 NOT NULL, "exemplifies_count" integer DEFAULT 0 NOT NULL, "embodies_count" integer DEFAULT 0 NOT NULL, "work_has_subjects_count" integer DEFAULT 0 NOT NULL, "repository_content" boolean DEFAULT 'f' NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "state" varchar(255), "required_score" integer DEFAULT 0 NOT NULL, "frequency_id" integer DEFAULT 1 NOT NULL, "subscription_master" boolean DEFAULT 'f' NOT NULL)r Aindexindex_patrons_on_full_namepatrons CREATE INDEX "index_patrons_on_full_name" ON "patrons" ("full_name")O1indexindex_patrons_on_required_role_idpatrons CREATE INDEX "index_patrons_on_required_role_id" ON "patrons" ("required_role_id")uCindexindex_patrons_on_country_idpatronsCREATE INDEX "index_patrons_on_country_id" ON "patrons" ("country_id")xEindexindex_patrons_on_language_idpatronsCREATE INDEX "index_patrons_on_language_id" ON "patrons" ("language_id")s=indexindex_patrons_on_user_idpatronsCREATE UNIQUE INDEX "index_patrons_on_user_id" ON "patrons" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MqtablepatronspatronsCREATE TABLE "patrons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "last_name" varchar(255), "middle_name" varchar(255), "first_name" varchar(255), "last_name_transcription" varchar(255), "middle_name_transcription" varchar(255), "first_name_transcription" varchar(255), "corporate_name" varchar(255), "corporate_name_transcription" varchar(255), "full_name" varchar(255), "full_name_transcription" text, "full_name_alternative" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "zip_code_1" varchar(255), "zip_code_2" varchar(255), "address_1" text, "address_2" text, "address_1_note" text, "address_2_note" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number_1" varchar(255), "fax_number_2" varchar(255), "other_designation" text, "place" text, "postal_code" varchar(255), "street" text, "locality" text, "region" text, "date_of_birth" datetime, "date_of_death" datetime, "language_id" integer DEFAULT 1 NOT NULL, "country_id" integer DEFAULT 1 NOT NULL, "patron_type_id" integer DEFAULT 1 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "note" text, "creates_count" integer DEFAULT 0 NOT NULL, "realizes_count" integer DEFAULT 0 NOT NULL, "produces_count" integer DEFAULT 0 NOT NULL, "owns_count" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "state" varchar(255), "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar%) p^L:()20120106093603)20120106093356)20111201163718)20111201155513)20111201155456)20111201121844)20111201115540)20111201115527)20110918162329)20110916103953)20110820131417 )20110627035057 )20110627034940 )20110618091240 )20110425133109 )20100321235924)20100223121519)20091214131723134133125651 wdQ>+)20120106093603)20120106093356)20111201163718)20111201155513)20111201155456)20111201121844)20111201115540)20111201115527)20110918162329)20110916103953)20110820131417)20110627035057 )20110627034940 )20110618091240 )20110425133109 @@ -83,21 +83,21 @@  FF<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    xek D   6+ otableusersusers4CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "required_role_id" integer, "username" varchar(255), "note" text, "locale" varchar(255), "created_at" datetime, "updated_at" datetime, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime)V/ tablerolesroles3CREATE 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)E.]tableproducesproduces2CREATE TABLE "produces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_id" integer, "patron_id" integer, "created_at" datetime, "updated_at" datetime)9-Itablecreatescreates1CREATE TABLE "creates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "work_id" integer, "patron_id" integer, "created_at" datetime, "updated_at" datetime)/,rAindexindex_donates_on_patron_iddonates CREATE INDEX "index_donates_on_patron_id" ON "donates" ("patron_id")l= indexindex_donates_on_item_iddonates!CREATE INDEX "index_donates_on_item_id" ON "donates" ("item_id")j''tablepatron_mergespatron_merges"CREATE 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) - M'-indexindex_patron_merges_on_patron_idpatron_merges#CREATE INDEX "index_patron_merges_on_patron_id" ON "patron_merges" ("patron_id")+!c'Yindexindex_patron_merges_on_patron_merge_list_idpatron_merges$CREATE INDEX "index_patron_merges_on_patron_merge_list_id" ON "patron_merges" ("patron_merge_list_id")H"11;tablepatron_merge_listspatron_merge_lists&CREATE TABLE "patron_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "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)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")f%EEOtableseries_statement_merge_listsseries_statement_merge_lists)CREATE TABLE "series_statement_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime, "updated_at" datetime)&;;Otableseries_statement_mergesseries_statement_merges*CREATE 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)P'u;}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")r( ;)indexindex_series_statement_merges_on_series_statement_merge_list_idseries_statement_merges,CREATE INDEX "index_series_statement_merges_on_series_statement_merge_list_id" ON "series_statement_merges" ("series_statement_merge_list_id"))??;tableseries_has_manifestationsseries_has_manifestations-CREATE 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) @@>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 CC=33title32012-05-28 14:38:362012-05-28 14:38:36=33title22012-05-28 14:38:362012-05-28 14:38:36=33title12012-05-28 14:38:362012-05-28 14:38:36 + M'-indexindex_patron_merges_on_patron_idpatron_merges#CREATE INDEX "index_patron_merges_on_patron_id" ON "patron_merges" ("patron_id")+!c'Yindexindex_patron_merges_on_patron_merge_list_idpatron_merges$CREATE INDEX "index_patron_merges_on_patron_merge_list_id" ON "patron_merges" ("patron_merge_list_id")H"11;tablepatron_merge_listspatron_merge_lists&CREATE TABLE "patron_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "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)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")f%EEOtableseries_statement_merge_listsseries_statement_merge_lists)CREATE TABLE "series_statement_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime, "updated_at" datetime)&;;Otableseries_statement_mergesseries_statement_merges*CREATE 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)P'u;}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")r( ;)indexindex_series_statement_merges_on_series_statement_merge_list_idseries_statement_merges,CREATE INDEX "index_series_statement_merges_on_series_statement_merge_list_id" ON "series_statement_merges" ("series_statement_merge_list_id"))??;tableseries_has_manifestationsseries_has_manifestations-CREATE 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) @@>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 CC=33title32012-05-30 12:41:562012-05-30 12:41:56=33title22012-05-30 12:41:562012-05-30 12:41:56=33title12012-05-30 12:41:562012-05-30 12:41:56  @@>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 FF<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   -   LH''33AdministratorAdministrator2012-05-28 14:38:362012-05-28 14:38:36@33LibrarianLibrarian2012-05-28 14:38:362012-05-28 14:38:36633UserUser2012-05-28 14:38:362012-05-28 14:38:36833GuestGuest2012-05-28 14:38:362012-05-28 14:38:36  +   LH''33AdministratorAdministrator2012-05-30 12:41:562012-05-30 12:41:56@33LibrarianLibrarian2012-05-30 12:41:562012-05-30 12:41:56633UserUser2012-05-30 12:41:562012-05-30 12:41:56833GuestGuest2012-05-30 12:41:562012-05-30 12:41:56  V f jAAA user42007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417jAAA user32007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 AA user22008-01-18 04:29:06.9227282008-05-31 03:42:44.711117$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca!AA librarian22008-01-18 03:24:04.2223442008-05-31 03:42:23.340575$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS&AAAuser12007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW0!AAKlibrarian12007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS'AACadmin2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi ;  | 8  =;05Ctableownsowns:CREATE TABLE "owns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "patron_id" integer, "created_at" datetime, "updated_at" datetime)B4Wtablerealizesrealizes9CREATE TABLE "realizes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "expression_id" integer, "patron_id" integer, "created_at" datetime, "updated_at" datetime)g0-tableusersusers4CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "required_role_id" integer, "username" varchar(255), "note" text, "locale" varchar(255), "created_at" datetime, "updated_at" datetime, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255))X*y?indexindex_series_has_manifestations_on_series_statement_idseries_has_manifestations.CREATE INDEX "index_series_has_manifestations_on_series_statement_id" ON "series_has_manifestations" ("series_statement_id")O+s?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestations/CREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")/,c/Yindexindex_series_statements_on_manifestation_idseries_statements0CREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("manifestation_id")9-Itablecreatescreates1CREATE TABLE "creates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "work_id" integer, "patron_id" integer, "created_at" datetime, "updated_at" datetime)E.]tableproducesproduces2CREATE TABLE "produces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_id" integer, "patron_id" integer, "created_at" datetime, "updated_at" datetime)V/ tablerolesroles3CREATE 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)d'tableusersusers4CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,L3))Stableuser_has_rolesuser_has_roles8CREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime, "updated_at" datetime)2SGindexindex_users_on_reset_password_tokenusers7CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")]15}indexindex_users_on_emailusers6CREATE INDEX "index_users_on_email" ON "users" ("email") UtUAuser4@kamata.lib.teu.ac.jpAuser3@kamata.lib.teu.ac.jp  Auser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jpCtanabe@kamata.lib.teu.ac.jp - f3.]332012-05-28 14:38:362012-05-28 14:38:36.z332012-05-28 14:38:362012-05-28 14:38:36.o332012-05-28 14:38:362012-05-28 14:38:36.U332012-05-28 14:38:362012-05-28 14:38:36.ƊW332012-05-28 14:38:362012-05-28 14:38:36.q332012-05-28 14:38:362012-05-28 14:38:36.x332012-05-28 14:38:362012-05-28 14:38:36   n0s Y ; + f3.]332012-05-30 12:41:562012-05-30 12:41:56.z332012-05-30 12:41:562012-05-30 12:41:56.o332012-05-30 12:41:562012-05-30 12:41:56.U332012-05-30 12:41:562012-05-30 12:41:56.ƊW332012-05-30 12:41:562012-05-30 12:41:56.q332012-05-30 12:41:562012-05-30 12:41:56.x332012-05-30 12:41:562012-05-30 12:41:56   n0s Y ; WeC;9n 1 P o ) H g  ! @ `  @`Hn/9AARuby／GTKプログラミング入門 : Rubyで作って遊ぶGUIプログラミング2010-02-19 13:09:56.0000002010-03-01 07:14:18.00000072ff!m.]AA!CGI／Perlパワープログラミング2010-02-20 17:26:08.0000002010-03-01 07:14:18.0000000000000109ff#l.aAA!Perl 5パワフルテクニック大全集2010-02-21 08:13:17.0000002010-03-01 07:14:18.0000000000000108ff5k/AAはじめてのPerlモジュール : 厳選実用モジュール集2010-02-21 09:59:01.0000002010-03-01 07:14:18.00000071ff}j.%AAPerl ＆ XML2010-02-21 10:45:48.0000002010-03-01 07:14:18.00000070ffi.7AA初めてのPerl. 続2010-02-21 10:48:14.0000002010-03-01 07:14:18.00000069ffh.GAAPerlクックブック. v．12010-02-21 10:51:33.0000002010-03-01 07:14:18.00000068ffg.GAAPerlクックブック. v．22010-02-21 10:51:48.0000002010-03-01 07:14:18.00000067ff/f/AACGIレスキュー実践Perlプログラミング : Web裏技2010-02-21 14:57:08.0000002010-03-01 07:14:18.00000066ff2e/ AACGI基礎講座 : Perl・プログラミング・日本語処理2010-02-21 15:47:09.0000002010-03-01 07:14:18.00000065ffO.AA[世界の美しい図書館集めてみた【第一弾】2007-11-19 07:58:58.7997242008-04-16 15:34:01.000000http://www.nicovideo.jp/watch/sm3015373ff6.IAA_YouTube - Open Source ILS Song2008-04-16 15:34:01.0000002007-11-19 07:59:21.799724http://jp.youtube.com/watch?v=BSHBzd9ftDEff? /AA!Webサービス完全構築ガイド2007-11-19 07:59:20.7997242007-11-19 07:59:20.7997244822281167ffS /9AA'Apache Lucene入門 : Java・オープンソース・全文検索システムの構築2007-11-19 07:59:09.7997242007-11-19 07:59:09.7997249784774127804ff .OAA!逐条解説不正競争防止法2007-11-19 07:59:08.1661952007-11-19 07:59:08.1661954641143331ff,.sAA!Webサービス完全解説2007-11-19 07:59:07.4633332007-11-19 07:59:07.4633334798101028ff.=AA!dictionary of e-business2007-11-19 07:59:06.8927412007-11-19 07:59:06.8927410470844701ff.=AA 仕組み革新の時代2007-11-19 07:59:05.2556842007-11-19 07:59:05.255684ff.gAA 顧客満足型マーケティングの構図2007-11-19 07:59:04.3331832007-11-19 07:59:04.333183ff.EAA!THE BIOTECH INVESTOR'S BIBLE2007-11-19 07:59:03.2757382007-11-19 07:59:03.2757380471412791ff`/#AAC!これからの生命科学研究者のためのバイオ特許入門講座2007-11-19 07:59:02.6183592007-11-19 07:59:02.618359http://www.slis.keio.ac.jp/4897063590ff:/ AA!情報通信ハンドブック20052007-11-19 07:59:01.9915122007-11-19 07:59:01.9915124915724824ffM//AA!よくわかる最新Webサービス技術2007-11-19 07:59:00.2933932007-11-19 07:59:00.293393d4798002062tf >hh  " A `   \ No newline at end of file