spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre19 vs spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre20

- old
+ new

@@ -1,6 +1,6 @@ -SQLite format 3@ -$| C)indexindex_manifestations_on_nbnmanifestations CREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn") E)indexindex_manifestations_on_isbnmanifestations CREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")& +SQLite format 3@ -$| C)indexindex_manifestations_on_nbnmanifestations CREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn") E)indexindex_manifestations_on_isbnmanifestations CREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")& ))tablemanifestationsmanifestations 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 NOT NULL, "updated_at" datetime NOT NULL, "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" integer, "width" integer, "depth" integer, "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, "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)07tablepatronspatronsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL, "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, "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_|݁rcYI7pzr\cJR>A(4  xqjc\UNG@. zhVD2  ~ l Z H 6 $  p ^ L : (   t b P > ,   @@ -142,12 +142,12 @@        - 3G+ n  Q 3^  A AA2012-08-27 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996^  A AA2012-08-27 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\  A AA2012-08-27 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] -  A AA 2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  A AA 2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  AAA2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\  AAA2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2010-09-14 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  AAA2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\  AAA2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  AAA2013-02-25 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996[  AAA2013-02-25 15:00:00.0000002007-09-07 16:34:07.3630232007-09-07 16:34:25.103403Z AAA2013-02-25 15:00:00.0000002007-09-07 16:19:02.2858502007-09-07 16:20:22.000026 + 3G+ n  Q 3^  A AA2012-08-28 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996^  A AA2012-08-28 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\  A AA2012-08-28 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] +  A AA 2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  A AA 2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  AAA2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\  AAA2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2010-09-14 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  AAA2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\  AAA2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]  AAA2013-02-26 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996[  AAA2013-02-26 15:00:00.0000002007-09-07 16:34:07.3630232007-09-07 16:34:25.103403Z AAA2013-02-26 15:00:00.0000002007-09-07 16:19:02.2858502007-09-07 16:20:22.000026           N t e ` EH#"tablereservesreserves.CREATE TABLE "reserves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "canceled_at" datetime, "expired_at" datetime, "deleted_at" datetime, "state" varchar(255), "expiration_notice_to_patron" boolean DEFAULT 'f', "expiration_notice_to_library" boolean DEFAULT 'f', "expire_date" varchar(255))4S9indexindex_bookmarks_on_manifestation_idbookmarks8CREATE INDEX "index_bookmarks_on_manifestation_id" ON "bookmarks" ("manifestation_id")t3Aindexindex_bookmarks_on_user_idbookmarks7CREATE INDEX "index_bookmarks_on_user_id" ON "bookmarks" ("user_id")"2tablebookmarksbookmarks6CREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer, "title" text, "url" varchar(255), "note" text, "shared" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 1Q5indexindex_produces_on_manifestation_idproduces5CREATE INDEX "index_produces_on_manifestation_id" ON "produces" ("manifestation_id")v0Cindexindex_produces_on_patron_idproduces4CREATE INDEX "index_produces_on_patron_id" ON "produces" ("patron_id")Mtableproducesproduces3CREATE TABLE "produces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]Mindexindex_reserves_on_request_status_type_idreserves2CREATE INDEX "index_reserves_on_request_status_type_id" ON "reserves" ("request_status_type_id")r?indexindex_reserves_on_item_idreserves1CREATE INDEX "index_reserves_on_item_id/tableproducesproduces3CREATE TABLE "produces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "produce_type_id" integer)})G!indexindex_checkouts_on_checkin_idcheckouts-CREATE INDEX "index_checkouts_on_checkin_id" ON "checkouts" ("checkin_id")(K)indexindex_checkouts_on_librarian_idcheckouts,CREATE INDEX "index_checkouts_on_librarian_id" ON "checkouts" ("librarian_id")$']Yindexindex_checkouts_on_item_id_and_basket_idcheckouts+CREATE UNIQUE INDEX "index_checkouts_on_item_id_and_basket_id" ON "checkouts" ("item_id", "basket_id")z&Eindexindex_checkouts_on_basket_idcheckouts*CREATE INDEX "index_checkouts_on_basket_id" ON "checkouts" ("basket_id")t%Aindexindex_checkouts_on_item_idcheckouts)CREATE INDEX "index_checkouts_on_item_id" ON "checkouts" ("item_id")t$Aindexindex_checkouts_on_user_idcheckouts'CREATE INDEX "index_checkouts_on_user_id" ON "checkouts" ("user_id")#otablecheckoutscheckouts&CREATE TABLE "checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "item_id" integer NOT NULL, "checkin_id" integer, "librarian_id" integer, "basket_id" integer, "due_date" datetime, "checkout_renewal_count" integer DEFAULT 0 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v"Cindexindex_checkins_on_basket_idcheckins%CREATE INDEX "index_checkins_on_basket_id" ON "checkins" ("basket_id")!I%indexindex_checkins_on_librarian_idcheckins$CREATE INDEX "index_checkins_on_librarian_id" ON "checkins" ("librarian_id")     @@ -159,12 +159,12 @@                         N ' t  / < -c kAAA 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-25 14:10:28.000000requestedffkAAA 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-25 14:10:28.000000retainedffk AAA 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-23 14:10:28.000000requestedffj AAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-23 14:10:28.000000retainedffi AAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-23 14:10:28.000000expiredff -AAAA2013-02-17 14:10:28.0000002007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-02-24 13:10:28.000000completedffk AAA2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-02-23 14:10:28.000000requestedffiAAA2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-02-17 14:10:28.000000expiredffkAAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-03-03 14:10:28.000000requestedffkAAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-03-03 14:10:28.000000requestedffkAAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-03-03 14:10:28.000000requestedffj AAA2007-09-01 05:14:52.3568032007-09-02 08:51:54.8878492013-03-03 14:10:28.000000requestedffkAAA2007-09-02 10:16:55.7148122007-09-02 10:16:55.7148122013-03-03 14:10:28.000000requestedffj AAA2007-09-02 09:37:25.5760872007-09-02 09:37:25.5760872013-03-03 14:10:28.000000requestedffkAAA2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-03-03 14:10:28.000000requestedff +c kAAA 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-26 04:59:03.000000requestedffkAAA 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-26 04:59:03.000000retainedffk AAA 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-24 04:59:03.000000requestedffj AAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-24 04:59:03.000000retainedffi AAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-02-24 04:59:03.000000expiredff +AAAA2013-02-18 04:59:03.0000002007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-02-25 03:59:03.000000completedffk AAA2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-02-24 04:59:03.000000requestedffiAAA2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-02-18 04:59:03.000000expiredffkAAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-03-04 04:59:03.000000requestedffkAAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-03-04 04:59:03.000000requestedffkAAA2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-03-04 04:59:03.000000requestedffj AAA2007-09-01 05:14:52.3568032007-09-02 08:51:54.8878492013-03-04 04:59:03.000000requestedffkAAA2007-09-02 10:16:55.7148122007-09-02 10:16:55.7148122013-03-04 04:59:03.000000requestedffj AAA2007-09-02 09:37:25.5760872007-09-02 09:37:25.5760872013-03-04 04:59:03.000000requestedffkAAA2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-03-04 04:59:03.000000requestedff                      @@ -179,29 +179,29 @@     q v%  AAmitaMita Library三田108-8345MinatoTokyo|2007-08-23 10:51:00.0000002007-08-30 15:18:20.043951-% %  AAhachiojiHachioji Library八王子192-0982HachiojiTokyo042-637-2033042-637-2116|2007-08-14 07:37:00.0000002007-08-30 15:18:16.188285 ))  AA!kamataKamata Library蒲田144-8535Tokyo81-3-3732-5111|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349JP-0000000`)   AAwebWorld Wide WebWeb|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349     mita hachioji -kamata web kK ##33third_shelfThird shelf2013-02-24 14:10:292013-02-24 14:10:29fM %%33second_shelfSecond shelf2013-02-24 14:10:292013-02-24 14:10:29fK ##33first_shelfFirst shelf2013-02-24 14:10:292013-02-24 14:10:29fF -  33webLibrary bookmark2013-02-24 14:10:292013-02-24 14:10:29f ,  sm`9gtableshelvesshelves=CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "closed" boolean DEFAULT 'f' NOT NULL)W6}tablelibrarieslibraries:CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "isil" varchar(255))qAAindexindex_events_on_library_ideventsFCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")@ tableeventseventsECREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_id" integer DEFAULT 1 NOT NULL, "event_category_id" integer DEFAULT 1 NOT NULL, "name" varchar(255), "note" text, "start_at" datetime, "end_at" datetime, "all_day" boolean DEFAULT 'f' NOT NULL, "deleted_at" datetime, "display_name" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?##MtablefrequenciesfrequenciesDCREATE TABLE "frequencies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)3<##-tableuser_groupsuser_groupsACREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "string" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime, "number_of_day_to_notify_overdue" integer DEFAULT 1 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 7 NOT NULL, "number_of_time_to_notify_overdue" integer DEFAULT 3 NOT NULL) ;''Qtablecarrier_typescarrier_types@CREATE TABLE "carrier_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u:Cindexindex_shelves_on_library_idshelves?CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")dtableshelvesshelves=CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)r8;indexindex_libraries_on_namelibraries<CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")7S9indexindex_libraries_on_library_group_idlibraries;CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")h59indexindex_bookmarks_on_urlbookmarks9CREATE INDEX "index_bookmarks_on_url" ON "bookmarks" ("url") - ~;~X7AADVDDVDDVDです。2007-12-22 19:24:23.1514102007-12-22 19:24:23.151410aMAACDCD音楽CDです。2007-12-18 16:45:26.0406742007-12-18 16:45:26.040674R% AAprintprint本です。2007-11-20 06:47:03.6415302007-11-20 07:04:29.853828oaAAfilefileコンピュータのファイルです。2007-12-23 16:30:50.6374332007-12-23 16:30:50.637433 HV AA FacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351Q AAUserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548mc++ AA (not specified)(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542 mm%-?339enju_libraryja: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0f2013-02-24 14:10:292013-02-24 14:10:29fhttp://localhost:3000/ +kamata web kK ##33third_shelfThird shelf2013-02-25 04:59:052013-02-25 04:59:05fM %%33second_shelfSecond shelf2013-02-25 04:59:052013-02-25 04:59:05fK ##33first_shelfFirst shelf2013-02-25 04:59:052013-02-25 04:59:05fF -  33webLibrary bookmark2013-02-25 04:59:052013-02-25 04:59:05f ,  sm`9gtableshelvesshelves=CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "closed" boolean DEFAULT 'f' NOT NULL)W6}tablelibrarieslibraries:CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "isil" varchar(255))qAAindexindex_events_on_library_ideventsFCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")@ tableeventseventsECREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_id" integer DEFAULT 1 NOT NULL, "event_category_id" integer DEFAULT 1 NOT NULL, "name" varchar(255), "note" text, "start_at" datetime, "end_at" datetime, "all_day" boolean DEFAULT 'f' NOT NULL, "deleted_at" datetime, "display_name" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?##MtablefrequenciesfrequenciesDCREATE TABLE "frequencies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)3<##-tableuser_groupsuser_groupsACREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "string" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime, "number_of_day_to_notify_overdue" integer DEFAULT 1 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 7 NOT NULL, "number_of_time_to_notify_overdue" integer DEFAULT 3 NOT NULL) ;''Qtablecarrier_typescarrier_types@CREATE TABLE "carrier_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u:Cindexindex_shelves_on_library_idshelves?CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")dtableshelvesshelves=CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)r8;indexindex_libraries_on_namelibraries<CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")7S9indexindex_libraries_on_library_group_idlibraries;CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")h59indexindex_bookmarks_on_urlbookmarks9CREATE INDEX "index_bookmarks_on_url" ON "bookmarks" ("url") + ~;~X7AADVDDVDDVDです。2007-12-22 19:24:23.1514102007-12-22 19:24:23.151410aMAACDCD音楽CDです。2007-12-18 16:45:26.0406742007-12-18 16:45:26.040674R% AAprintprint本です。2007-11-20 06:47:03.6415302007-11-20 07:04:29.853828oaAAfilefileコンピュータのファイルです。2007-12-23 16:30:50.6374332007-12-23 16:30:50.637433 HV AA FacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351Q AAUserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548mc++ AA (not specified)(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542 mm%-?339enju_libraryja: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0f2013-02-25 04:59:042013-02-25 04:59:04fhttp://localhost:3000/ B enju  6 lMAAmonthly隔月刊2007-12-31 12:40:31.2470812007-12-31 12:40:31.247081KAAbiweekly月刊2007-12-31 12:40:18.8036612007-12-31 12:40:18.803661LAAweekly隔週刊2007-12-31 12:40:11.1120402007-12-31 12:40:11.112040HAAdaily週刊2007-12-31 12:39:54.9807872007-12-31 12:39:54.980787O' AAnot refularly日刊2007-12-31 12:39:45.7375312007-12-31 12:39:45.737531IAAyearly年刊2007-12-31 12:41:03.0047362007-12-31 12:41:03.004736GAAotherOther2007-12-31 12:40:31.2470812007-12-31 12:40:31.247081  *V b 6 *  AAAAtesttest2008-02-05 06:00:00.0000002008-02-05 06:00:00.000000ftest2008-02-05 12:00:53.9260502008-02-05 12:00:53.926050  AAAAtesttest2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000ftest2008-02-05 12:00:53.9260502008-02-05 12:00:53.926050( = AA=AAなんとかかんとか2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000fなんとかかんとか2008-02-05 11:50:26.6513712008-02-05 14:52:06.315285   AAAAtest2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000ftest2008-02-05 11:41:50.5331642008-02-05 11:41:50.533164" =AAAAテストなんとかかんとか2008-02-04 15:00:00.0000002008-02-05 15:00:00.000000fテスト2008-02-05 06:43:42.6176702008-02-05 06:43:42.617670  1 AA1AAミーティング2008-01-12 15:00:00.0000002008-02-04 15:00:00.000000fミーティング2008-01-12 17:51:10.6423952008-02-05 11:00:35.319131. UAAAAテストテスト用のイベントです。2008-01-12 17:54:00.0000002008-01-13 17:54:00.000000fテスト2008-01-01 11:54:25.8032012008-01-12 17:54:21.134175'  %=AA%AA仕事始めなんとかかんとか2008-01-12 17:54:00.0000002008-01-13 17:54:00.000000f仕事始め2008-01-01 07:20:54.3727292008-01-12 17:54:43.764011        __UR+ AAunknown(not specified)2008-01-01 07:17:12.5495652008-01-01 07:24:17.869192O AA講演会講演会2008-01-01 07:25:04.2511412008-01-01 07:25:04.251141O AA上映会上映会2008-01-01 07:18:08.8686802008-01-01 07:24:55.261682[++ AAおはなし会おはなし会2008-01-01 07:17:45.4154872008-01-01 07:24:45.267241L AAclosed休館日2008-01-01 07:17:34.6424332008-01-01 07:24:32.561469 ]E AAtesttest2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771E AAideaidea2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771Z++ AA(not specified)(not specified)2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771 @UaRW Z :  1 P84 S''Qtablerequest_typesrequest_typesYCREATE TABLE "request_types" ("id" INTEGER PR%G'' tablechecked_itemschecked_itemsMCREATE TABLE "checked_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "basket_id" integer NOT NULL, "due_date" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "librarian_id" integer)BO1indexindex_events_on_event_category_ideventsGCREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")C--Wtableevent_categoriesevent_categoriesHCREATE TABLE "event_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) D''Qtableform_of_worksform_of_worksICREATE TABLE "form_of_works" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)nE3tablebasketsbasketsKCREATE TABLE "baskets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)lF= indexindex_baskets_on_user_idbasketsLCREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")''Ytablechecked_itemschecked_itemsMCREATE TABLE "checked_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "basket_id" integer NOT NULL, "due_date" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)HI'%indexindex_checked_items_on_item_idchecked_itemsNCREATE INDEX "index_checked_items_on_item_id" ON "checked_items" ("item_id") IM'-indexindex_checked_items_on_basket_idchecked_itemsOCREATE INDEX "index_checked_items_on_basket_id" ON "checked_items" ("basket_id")sJ!!1tablebookstoresbookstoresPCREATE TABLE "bookstores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" text NOT NULL, "zip_code" varchar(255), "address" text, "note" text, "telephone_number" varchar(255), "fax_number" varchar(255), "url" varchar(255), "position" integer, "deleted_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]KtabledonatesdonatesQCREATE TABLE "donates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "item_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)rLAindexindex_donates_on_patron_iddonatesRCREATE INDEX "index_donates_on_patron_id" ON "donates" ("patron_id")lM= indexindex_donates_on_item_iddonatesSCREATE INDEX "index_donates_on_item_id" ON "donates" ("item_id")N--Wtableuse_restrictionsuse_restrictionsTCREATE TABLE "use_restrictions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)O??Gtableitem_has_use_restrictionsitem_has_use_restrictionsUCREATE TABLE "item_has_use_restrictions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "use_restriction_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)4Pa?Uindexindex_item_has_use_restrictions_on_item_iditem_has_use_restrictionsVCREATE INDEX "index_item_has_use_restrictions_on_item_id" ON "item_has_use_restrictions" ("item_id")UQw?indexindex_item_has_use_restrictions_on_use_restriction_iditem_has_use_restrictionsWCREATE INDEX "index_item_has_use_restrictions_on_use_restriction_id" ON "item_has_use_restrictions" ("use_restriction_id")R55_tablerequest_status_typesrequest_status_typesXCREATE TABLE "request_status_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) XG P X< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596; AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596; AA2008-01-21 08:21:58.5541462008-01-21 08:21:58.554146   -   iJA33 2013-03-03 14:10:28.0000002013-02-24 14:10:282013-02-24 14:10:28JA33 2013-03-03 14:10:28.0000002013-02-24 14:10:282013-02-24 14:10:28JA332013-03-03 14:10:28.0000002013-02-24 14:10:282013-02-24 14:10:28I A33 -2013-03-03 14:10:28.0000002013-02-24 14:10:282013-02-24 14:10:28 +   iJA33 2013-03-04 04:59:03.0000002013-02-25 04:59:042013-02-25 04:59:04JA33 2013-03-04 04:59:03.0000002013-02-25 04:59:042013-02-25 04:59:04JA332013-03-04 04:59:03.0000002013-02-25 04:59:042013-02-25 04:59:04I A33 +2013-03-04 04:59:03.0000002013-02-25 04:59:042013-02-25 04:59:04      l O ' AAExample store2008-02-10 03:15:54.5585172008-02-10 03:16:25.906073] C AA図書館流通センター2008-02-10 03:15:54.5585172008-02-10 03:16:25.906073H  AA丸善2008-02-10 03:15:44.9237582008-02-10 03:16:17.990285T 1 AA紀伊國屋書店2008-02-10 02:16:22.5656602008-02-10 03:16:07.726445K  AA有隣堂2008-02-10 02:16:11.5852842008-02-10 03:15:33.555463H  AA寄贈2008-02-10 02:16:02.5988442008-02-10 03:15:14.840711H  AAunknown2008-02-10 02:14:57.6053292008-02-10 02:14:57.605329 HH<AA2008-02-10 04:24:14.7934312008-02-10 04:24:14.793431; AA2008-02-10 04:24:14.7934312008-02-10 04:24:14.793431; AA2008-02-10 04:24:14.7934312008-02-10 04:24:14.793431   -  37 R Y ] ;; 33User Signature RequiredUser Signature Required 2013-02-24 14:10:292013-02-24 14:10:29i GG 33Use Only In Controlled AccessUse Only In Controlled Access 2013-02-24 14:10:292013-02-24 14:10:29A  33Term LoanTerm Loan 2013-02-24 14:10:292013-02-24 14:10:29W +  37 R Y ] ;; 33User Signature RequiredUser Signature Required 2013-02-25 04:59:052013-02-25 04:59:05i GG 33Use Only In Controlled AccessUse Only In Controlled Access 2013-02-25 04:59:052013-02-25 04:59:05A  33Term LoanTerm Loan 2013-02-25 04:59:052013-02-25 04:59:05W 55 33Supervision RequiredSupervision Required -2013-02-24 14:10:292013-02-24 14:10:29[ 99 33Renewals Not PermittedRenewals Not Permitted 2013-02-24 14:10:292013-02-24 14:10:29K)) 33Overnight OnlyOvernight Only2013-02-24 14:10:292013-02-24 14:10:29G%% 33Not For LoanNot For Loan2013-02-24 14:10:292013-02-24 14:10:29M++ 33No ReproductionNo Reproduction2013-02-24 14:10:292013-02-24 14:10:29{YY 33Limited Circulation, Short Loan PeriodLimited Circulation, Short Loan Period2013-02-24 14:10:292013-02-24 14:10:29}[[ 33Limited Circulation, Normal Loan PeriodLimited Circulation, Normal Loan Period2013-02-24 14:10:292013-02-24 14:10:29U33 33In Library Use OnlyIn Library Use Only2013-02-24 14:10:292013-02-24 14:10:29tSS 33Available For Supply Without ReturnAvailable For Supply Without Return2013-02-24 14:10:292013-02-24 14:10:29 G O<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA 2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 08:58:49.4900862008-02-13 08:58:49.490086<AA2008-02-13 08:58:37.5275562008-02-13 08:58:37.527556; AA +2013-02-25 04:59:052013-02-25 04:59:05[ 99 33Renewals Not PermittedRenewals Not Permitted 2013-02-25 04:59:052013-02-25 04:59:05K)) 33Overnight OnlyOvernight Only2013-02-25 04:59:052013-02-25 04:59:05G%% 33Not For LoanNot For Loan2013-02-25 04:59:052013-02-25 04:59:05M++ 33No ReproductionNo Reproduction2013-02-25 04:59:052013-02-25 04:59:05{YY 33Limited Circulation, Short Loan PeriodLimited Circulation, Short Loan Period2013-02-25 04:59:052013-02-25 04:59:05}[[ 33Limited Circulation, Normal Loan PeriodLimited Circulation, Normal Loan Period2013-02-25 04:59:052013-02-25 04:59:05U33 33In Library Use OnlyIn Library Use Only2013-02-25 04:59:052013-02-25 04:59:05tSS 33Available For Supply Without ReturnAvailable For Supply Without Return2013-02-25 04:59:052013-02-25 04:59:05 G O<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA 2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448<AA2008-02-13 08:58:49.4900862008-02-13 08:58:49.490086<AA2008-02-13 08:58:37.5275562008-02-13 08:58:37.527556; AA 2008-02-13 03:29:36.0134482008-02-13 03:29:36.013448     / _// AARequested Via ILLRequested Via ILL2008-02-13 09:39:29.3828442008-02-13 09:39:29.382844o?? AANeed to Accept ConditionsNeed to Accept Conditions2008-02-13 09:39:19.0683902008-02-13 09:39:19.068390Q!! AAIn ProcessIn Process2008-02-13 09:39:10.0101402008-02-13 09:39:10.010140K AAExpiredExpired2008-02-13 09:39:00.8787012008-02-13 09:39:00.878701i99 AACannot Fulfill RequestCannot Fulfill Request2008-02-13 09:38:51.8157552008-02-13 09:38:51.815755d55 AAAvailable For PickupAvailable For Pickup2008-02-13 09:38:38.5531142008-02-13 09:38:38.553114 bUbc33 AANon-Returnable CopyNon-Returnable Copy2008-02-13 09:44:00.8708932008-02-13 09:44:00.870893E AALoanLoan2008-02-13 09:43:51.9403152008-02-13 09:43:51.940315E AAHoldHold2008-02-13 09:43:42.1517592008-02-13 09:43:42.151759L AAEstimateEstimate2008-02-13 09:43:33.7108102008-02-13 09:43:33.710810[++ AAStack RetrievalStack Retrieval2008-02-13 09:44:10.1457392008-02-13 09:44:10.145739  Z t A @@ -210,19 +210,19 @@ ja: 除籍済み2008-02-15 08:31:35.7864042008-02-15 08:31:35.786404QQ AAClaimed Returned Or Never BorrowedClaimed Returned Or Never Borrowed2008-02-15 08:31:35.7864042008-02-15 08:31:35.786404uEE AACirculation Status UndefinedCirculation Status Undefined2008-02-15 08:31:26.5647692008-02-15 08:31:26.564769k;; AAWaiting To Be ReshelvedWaiting To Be Reshelved2008-02-15 08:32:59.0787502008-02-15 08:32:59.078750M  AARecalledRecalled 2008-02-15 08:32:48.3553042008-02-15 08:32:48.355304a11 AAAvailable On ShelfAvailable On Shelf2008-02-15 08:31:18.9462982008-02-15 08:31:18.946298d55 AAAvailable For PickupAvailable For Pickup2008-02-15 08:31:10.5885242008-02-15 08:31:10.588524] -- AAPending TransferPending Transfer 2008-02-15 08:32:39.3950002008-02-15 08:32:39.395000M  AAOn OrderOn Order 2008-02-15 08:32:30.6757352008-02-15 08:32:30.675735W '' AANot AvailableNot Available 2008-02-15 08:32:15.4540672008-02-15 08:32:15.454067K  AAOn LoanOn Loan 2008-02-15 08:32:22.9698962008-02-15 08:32:22.969896K AAMissingMissing2008-02-15 08:32:07.0065412008-02-15 08:32:07.006541E AALostLost2008-02-15 08:31:58.6279872008-02-15 08:31:58.627987UU AAIn Transit Between Library LocationsIn Transit Between Library Locations2008-02-15 08:31:51.2270562008-02-15 08:31:51.227056Q!! AAIn ProcessIn Process2008-02-15 08:31:42.4226762008-02-15 08:31:42.422676  / 8 v e ?''33item_received_for_libraryItem receivedItem received -ja2013-02-24 14:10:292013-02-24 14:10:29z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2013-02-24 14:10:292013-02-24 14:10:29k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2013-02-24 14:10:292013-02-24 14:10:29S ###33recall_itemRecall itemRecall itemja2013-02-24 14:10:292013-02-24 14:10:29z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2013-02-24 14:10:292013-02-24 14:10:29y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2013-02-24 14:10:292013-02-24 14:10:29w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2013-02-24 14:10:292013-02-24 14:10:29v I3333reservation_expired_for_patronReservation expiredReservation expiredja2013-02-24 14:10:292013-02-24 14:10:29d =''33item_received_for_patronItem receivedItem receivedja2013-02-24 14:10:292013-02-24 14:10:29x K55 33reservation_accepted_for_patronReservation acceptedReservation acceptedja2013-02-24 14:10:292013-02-24 14:10:29 n R T zkg; indexindex_countries_on_namecountriesnCREATE INDEX "index_countries_on_name" T55 Wktablemessagesmessages^CREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "read_at" datetime, "receiver_id" integer, "sender_id" integer, "subject" varchar(255) NOT NULL, "body" text, "message_request_id" integer, "state" varchar(255), "parent_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "lft" integer, "rgt" integer, "depth" integer) S''Qtablerequest_typesrequest_typesYCREATE TABLE "request_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)T55_tablecirculation_statusescirculation_statusesZCREATE TABLE "circulation_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)FU//;tablemessage_templatesmessage_templates[CREATE TABLE "message_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar(255) NOT NULL, "title" text NOT NULL, "body" text NOT NULL, "position" integer, "locale" varchar(255) DEFAULT 'ja', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)VO/?indexindex_message_templates_on_statusmessage_templates]CREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status") H tablemessagesmessages^CREATE TABLE "messages" ("id" INTEGER PR^}tablerealizesrealizeseCREATE TABLE "realizes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "expression_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "realize_type_id" integer)vXCindexindex_messages_on_sender_idmessages_CREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|YG!indexindex_messages_on_receiver_idmessages`CREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")ZU=indexindex_messages_on_message_request_idmessagesaCREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")v[Cindexindex_messages_on_parent_idmessagesbCREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")W\--atablemessage_requestsmessage_requestscCREATE TABLE "message_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "receiver_id" integer, "message_template_id" integer, "sent_at" datetime, "deleted_at" datetime, "body" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +ja2013-02-25 04:59:052013-02-25 04:59:05z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2013-02-25 04:59:052013-02-25 04:59:05k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2013-02-25 04:59:052013-02-25 04:59:05S ###33recall_itemRecall itemRecall itemja2013-02-25 04:59:052013-02-25 04:59:05z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2013-02-25 04:59:052013-02-25 04:59:05y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2013-02-25 04:59:052013-02-25 04:59:05w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2013-02-25 04:59:052013-02-25 04:59:05v I3333reservation_expired_for_patronReservation expiredReservation expiredja2013-02-25 04:59:052013-02-25 04:59:05d =''33item_received_for_patronItem receivedItem receivedja2013-02-25 04:59:052013-02-25 04:59:05x K55 33reservation_accepted_for_patronReservation acceptedReservation acceptedja2013-02-25 04:59:052013-02-25 04:59:05 n R T zkg; indexindex_countries_on_namecountriesnCREATE INDEX "index_countries_on_name" T55 Wktablemessagesmessages^CREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "read_at" datetime, "receiver_id" integer, "sender_id" integer, "subject" varchar(255) NOT NULL, "body" text, "message_request_id" integer, "state" varchar(255), "parent_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "lft" integer, "rgt" integer, "depth" integer) S''Qtablerequest_typesrequest_typesYCREATE TABLE "request_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)T55_tablecirculation_statusescirculation_statusesZCREATE TABLE "circulation_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)FU//;tablemessage_templatesmessage_templates[CREATE TABLE "message_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar(255) NOT NULL, "title" text NOT NULL, "body" text NOT NULL, "position" integer, "locale" varchar(255) DEFAULT 'ja', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)VO/?indexindex_message_templates_on_statusmessage_templates]CREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status") H tablemessagesmessages^CREATE TABLE "messages" ("id" INTEGER PR^}tablerealizesrealizeseCREATE TABLE "realizes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "expression_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "realize_type_id" integer)vXCindexindex_messages_on_sender_idmessages_CREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|YG!indexindex_messages_on_receiver_idmessages`CREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")ZU=indexindex_messages_on_message_request_idmessagesaCREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")v[Cindexindex_messages_on_parent_idmessagesbCREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")W\--atablemessage_requestsmessage_requestscCREATE TABLE "message_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "receiver_id" integer, "message_template_id" integer, "sent_at" datetime, "deleted_at" datetime, "body" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ]K-)indexindex_message_requests_on_statemessage_requestsdCREATE INDEX "index_message_requests_on_state" ON "message_requests" ("state")GtablerealizesrealizeseCREATE TABLE "realizes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "expression_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v_Cindexindex_realizes_on_patron_idrealizesfCREATE INDEX "index_realizes_on_patron_id" ON "realizes" ("patron_id")`K)indexindex_realizes_on_expression_idrealizesgCREATE INDEX "index_realizes_on_expression_id" ON "realizes" ("expression_id")a##OtableexemplifiesexemplifieshCREATE TABLE "exemplifies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)bW#Aindexindex_exemplifies_on_manifestation_idexemplifiesiCREATE INDEX "index_exemplifies_on_manifestation_id" ON "exemplifies" ("manifestation_id")cE#+indexindex_exemplifies_on_item_idexemplifiesjCREATE UNIQUE INDEX "index_exemplifies_on_item_id" ON "exemplifies" ("item_id")  0Uy?item_received_for_library -$Mreservation_accepted_for_library 3recall_overdue_item#recall_item$Mreservation_canceled_for_library#Kreservation_canceled_for_patron#Kreservation_expired_for_library"Ireservation_expired_for_patron=item_received_for_patron"K reservation_accepted_for_patron 'r'\1A3Dad!He is sucha dork.unread2013-02-22 14:10:28.0000002013-02-24 14:10:29r)IA3Second MessageCatie, you get the 2nd messageunread2013-02-23 14:10:28.0000002013-02-24 14:10:29w/MA3RE: First MessageThanks Dad! You are the coolest!unread2013-02-22 14:10:28.0000002013-02-24 14:10:29 A'KA3 2013-02-21 14:10:28.000000First MessageAbby, you get the first messageunread2007-07-04 12:10:47.0000002013-02-24 14:10:29 +$Mreservation_accepted_for_library 3recall_overdue_item#recall_item$Mreservation_canceled_for_library#Kreservation_canceled_for_patron#Kreservation_expired_for_library"Ireservation_expired_for_patron=item_received_for_patron"K reservation_accepted_for_patron 'r'\1A3Dad!He is sucha dork.unread2013-02-23 04:59:03.0000002013-02-25 04:59:05r)IA3Second MessageCatie, you get the 2nd messageunread2013-02-24 04:59:03.0000002013-02-25 04:59:05w/MA3RE: First MessageThanks Dad! You are the coolest!unread2013-02-23 04:59:03.0000002013-02-25 04:59:05 A'KA3 2013-02-22 04:59:03.000000First MessageAbby, you get the first messageunread2007-07-04 12:10:47.0000002013-02-25 04:59:05      - 8f 33pending2013-02-24 14:10:292013-02-24 14:10:298Ӳr 33pending2013-02-24 14:10:292013-02-24 14:10:29 + 8f 33pending2013-02-25 04:59:052013-02-25 04:59:058Ӳr 33pending2013-02-25 04:59:052013-02-25 04:59:05 pendingʊfpending:l AB >  AA2008-01-10 17:44:37.1357212008-01-10 17:44:37.135721? AA2008-01-10 17:40:55.6646042008-01-10 17:40:55.664604?AA2008-01-10 17:40:40.3167422008-01-10 17:40:40.316742> AA2008-01-10 17:40:24.0382762008-01-10 17:40:24.038276> AA2008-01-11 14:35:36.4675842008-01-11 14:35:36.467584> AA2008-01-10 17:34:32.3522232008-01-10 17:34:32.352223=  AA2008-01-10 17:34:20.1839622008-01-10 17:34:20.183962> 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   @@ -239,11 +239,11 @@ 2008-01-10 17:44:37.1357212008-01-10 17:44:37.135721= AA 2008-01-10 17:40:55.6646042008-01-10 17:40:55.664604=AA2008-01-10 17:40:40.3167422008-01-10 17:40:40.316742= AA2008-01-10 17:40:24.0382762008-01-10 17:40:24.038276=AA2008-01-11 14:35:36.4675842008-01-11 14:35:36.467584=AA2008-01-10 17:34:32.3522232008-01-10 17:34:32.352223= AA2008-01-10 17:34:20.1839622008-01-10 17:34:20.183962=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                 x~x    -  4y4C!!33ConferenceConference2013-02-24 14:10:292013-02-24 14:10:29I''33CorporateBodyCorporateBody2013-02-24 14:10:292013-02-24 14:10:29: 33PersonPerson2013-02-24 14:10:292013-02-24 14:10:29 t R.h\< | B B: Z  < +  4y4C!!33ConferenceConference2013-02-25 04:59:052013-02-25 04:59:05I''33CorporateBodyCorporateBody2013-02-25 04:59:052013-02-25 04:59:05: 33PersonPerson2013-02-25 04:59:052013-02-25 04:59:05 t R.h\< | B B: Z  < T  d .d^  jd| 2 L8V  d  t @@ -663,51 +663,51 @@ ) jf4 S" y >, srdchekikUell9mripchakhmTdeu8monotsncatkazSkat7molnmyakasRlug6tsokauQglg5tonsanbulful4brekanPsagtirmahmbosbodfra3smorusmarlfin2bisthaXXXrontelglvktatkalObenrohmltjjavNtammaliquefij1jpnMtgkplimsahfao0mlggitaLporfat/belmkdfgleKpolipkJeusewe.ltzezulikuIlubdest-zhatahbakileHbamtglepo,yorinaGfasazesweeng+yidindFaymsswdzo*xhopuspanave swanld)woloss~ava sunlitcdiv(fryorm}asm spalinbcymiboEhye nbllimawlnori|idoDsotlav`oji{somlat_dan'ocizislClao^ces&nnoyhunBkua]arg hrv%volnobxhmoAkur\aracre$viehin@kor[amhslvcos#venher?konZsqislkcor"uzbheb>akasinchv!urdhau=norwsndchu ukrhat<smevafrzhouigndeuaariiikomYnyatwineptabksnatukndoshbsrunXturnavrguj;srpkirWnauqgrn:glakinV  unknown A Ar AAEPatron2007-12-22 06:06:30.4649302007-12-22 06:06:30.464930overlay_spinner_geometry.gifimage/giftiAA3Shelf2007-12-22 06:06:30.4649302007-12-22 06:06:30.464930overlay_spinner.gifimage/giftw 'AA;#Manifestation2007-12-22 05:06:10.8703932007-12-22 05:06:40.293209test_00001_geometry.jpgimage/pjpeghe AA)#Shelf2007-12-22 04:47:41.4868072007-12-22 07:53:25.166728test_00001.jpgimage/x-png 1   Patron Shelf 'Manifestation - Shelf  \ O  33pendingMyStringtext/csv2013-02-24 14:10:292013-02-24 14:10:29O  33pendingMyStringtext/csv2013-02-24 14:10:292013-02-24 14:10:29Q  33completedMyStringtext/csv2013-02-24 14:10:292013-02-24 14:10:29 + Shelf  \ O  33pendingMyStringtext/csv2013-02-25 04:59:052013-02-25 04:59:05O  33pendingMyStringtext/csv2013-02-25 04:59:052013-02-25 04:59:05Q  33completedMyStringtext/csv2013-02-25 04:59:052013-02-25 04:59:05     - pending pending  completed  \ O  33pendingMyStringtext/csv2013-02-24 14:10:292013-02-24 14:10:29O  33pendingMyStringtext/csv2013-02-24 14:10:292013-02-24 14:10:29Q  33completedMyStringtext/csv2013-02-24 14:10:292013-02-24 14:10:29 + pending pending  completed  \ O  33pendingMyStringtext/csv2013-02-25 04:59:052013-02-25 04:59:05O  33pendingMyStringtext/csv2013-02-25 04:59:052013-02-25 04:59:05Q  33completedMyStringtext/csv2013-02-25 04:59:052013-02-25 04:59:05     ~ pending pending  completed  B ####Ez113tableevent_import_filesevent_import_filesCREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "imported_at" datetime, "state" varchar(255), "event_import_file_name" varchar(255), "event_import_content_type" varchar(255), "event_import_file_size" integer, "event_import_updated_at" datetime, "edit_mode" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "event_import_fingerprint" varchar(255), "error_message" text) _77Wtableresource_import_filesresource_import_files~CREATE TABLE "resource_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "imported_at" datetime, "state" varchar(255), "reW1Aindexindex_event_import_files_on_parent_idevent_import_filesCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id")S19indexindex_event_import_files_on_user_idevent_import_filesCREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id")O11indexindex_event_import_files_on_stateevent_import_filesCREATE INDEX "index_event_import_files_on_state" ON "event_import_files" ("state") ~))Stablecheckout_typescheckout_typesCREATE TABLE "checkout_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)E)indexindex_checkout_types_on_namecheckout_typesCREATE INDEX "index_checkout_types_on_name" ON "checkout_types" ("name")DGGtableuser_group_has_checkout_typesuser_group_has_checkout_typesCREATE TABLE "user_group_has_checkout_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer NOT NULL, "checkout_type_id" integer NOT NULL, "checkout_limit" integer DEFAULT 0 NOT NULL, "checkout_period" integer DEFAULT 0 NOT NULL, "checkout_renewal_limit" integer DEFAULT 0 NOT NULL, "reservation_limit" integer DEFAULT 0 NOT NULL, "reservation_expired_period" integer DEFAULT 7 NOT NULL, "set_due_date_before_closing_day" boolean DEFAULT 'f' NOT NULL, "fixed_due_date" datetime, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "current_checkout_count" integer)WuG}indexindex_user_group_has_checkout_types_on_user_group_iduser_group_has_checkout_typesCREATE INDEX "index_user_group_has_checkout_types_on_user_group_id" ON "user_group_has_checkout_types" ("user_group_id")`{G indexindex_user_group_has_checkout_types_on_checkout_type_iduser_group_has_checkout_typesCREATE INDEX "index_user_group_has_checkout_types_on_checkout_type_id" ON "user_group_has_checkout_types" ("checkout_type_id")VKK!tablecarrier_type_has_checkout_typescarrier_type_has_checkout_typesCREATE TABLE "carrier_type_has_checkout_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "carrier_type_id" integer NOT NULL, "checkout_type_id" integer NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)YqKindexindex_carrier_type_has_checkout_types_on_m_form_idcarrier_type_has_checkout_typesCREATE INDEX "index_carrier_type_has_checkout_types_on_m_form_id" ON "carrier_type_has_checkout_types" ("carrier_type_id")    - VV333cdcd2013-02-24 14:10:282013-02-24 14:10:28;33serialserial2013-02-24 14:10:282013-02-24 14:10:286 33bookbook2013-02-24 14:10:282013-02-24 14:10:28 + VV333cdcd2013-02-25 04:59:042013-02-25 04:59:04;33serialserial2013-02-25 04:59:042013-02-25 04:59:046 33bookbook2013-02-25 04:59:042013-02-25 04:59:04 cd serial book  j8 J  AAt2007-12-22 18:13:46.3127512007-12-22 18:13:46.312751K AAt2007-12-22 18:13:46.3127512007-12-22 18:13:46.312751K AAf2007-12-22 18:13:46.3127512007-12-22 18:13:46.312751J  AAf2007-12-22 18:13:37.4404622007-12-22 18:13:37.440462K AAf2007-12-22 18:13:29.8805382007-12-22 18:13:29.880538J  AAf2007-12-22 18:13:23.4168562007-12-22 18:13:23.416856J  AA f2007-12-22 18:13:15.6201432007-12-22 18:13:15.620143H  AAf2007-12-22 18:13:08.1070222007-12-22 18:13:08.107022    -   \\5 33MyText2013-02-24 14:10:282013-02-24 14:10:285 33MyText2013-02-24 14:10:282013-02-24 14:10:284 33MyText2013-02-24 14:10:282013-02-24 14:10:28 +   \\5 33MyText2013-02-25 04:59:042013-02-25 04:59:045 33MyText2013-02-25 04:59:042013-02-25 04:59:044 33MyText2013-02-25 04:59:042013-02-25 04:59:04   -  .t.D 33 2013-02-24 14:10:282013-02-24 14:10:28MyStringtext/csvD 33 2013-02-24 14:10:282013-02-24 14:10:28MyStringtext/csvD 33 2013-02-24 14:10:282013-02-24 14:10:28MyStringtext/csv ,xS e +  .t.D 33 2013-02-25 04:59:042013-02-25 04:59:04MyStringtext/csvD 33 2013-02-25 04:59:042013-02-25 04:59:04MyStringtext/csvD 33 2013-02-25 04:59:042013-02-25 04:59:04MyStringtext/csv ,xS e a M , "++ytableinventory_filesinventory_filesCREATE TABLE "inventory_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "filename"-++tableinventory_filesinventory_filesCREAThKindexindex_carrier_type_has_checkout_types_on_checkout_type_idcarrier_type_has_checkout_typesCREATE INDEX "index_carrier_type_has_checkout_types_on_checkout_type_id" ON "carrier_type_has_checkout_types" ("checkout_type_id")-++tableinventory_filesinventory_filesCREATE TABLE "inventory_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "filename" varchar(255), "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "created_at" datetimmMindexindex_bookmark_stat_has_manifestations_on_manifestation_idbookmark_stat_has_manifestationsCREATE INDEX "index_bookmark_stat_has_manifestations_on_manifestation_id" ON "bookmark_stat_has_manifestations" ("manifestation_id")G333tableuser_checkout_statsuser_checkout_statsCREATE TABLE "user_checkout_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime)H;;%tablecheckout_stat_has_userscheckout_stat_has_usersCREATE TABLE "checkout_stat_has_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_checkout_stat_id" integer NOT NULL, "user_id" integer NOT NULL, "checkouts_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Wy;indexindex_checkout_stat_has_users_on_user_checkout_stat_idcheckout_stat_has_usersCREATE INDEX "index_checkout_stat_has_users_on_user_checkout_stat_id" ON "checkout_stat_has_users" ("user_checkout_stat_id")-];Mindexindex_checkout_stat_has_users_on_user_idcheckout_stat_has_usersCREATE INDEX "index_checkout_stat_has_users_on_user_id" ON "checkout_stat_has_users" ("user_id")]KK/tablereserve_stat_has_manifestationsreserve_stat_has_manifestationsCREATE TABLE "reserve_stat_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_reserve_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "reserves_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)xK-indexindex_reserve_stat_has_manifestations_on_m_reserve_stat_idreserve_stat_has_manifestationsCREATE INDEX "index_reserve_stat_has_manifestations_on_m_reserve_stat_id" ON "reserve_stat_has_manifestations" ("manifestation_reserve_stat_id")hKindexindex_reserve_stat_has_manifestations_on_manifestation_idreserve_stat_has_manifestationsCREATE INDEX "index_reserve_stat_has_manifestations_on_manifestation_id" ON "reserve_stat_has_manifestations" ("manifestation_id")_CCCtablemanifestation_reserve_statsmanifestation_reserve_statsCREATE TABLE "manifestation_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime)D111tableuser_reserve_statsuser_reserve_statsCREATE TABLE "user_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime)099ytablereserve_stat_has_usersreserve_stat_has_usersCREATE TABLE "reserve_stat_has_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_reserve_stat_id" integer NOT NULL, "user_id" integer NOT NULL, "reserves_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Pu9}indexindex_reserve_stat_has_users_on_user_reserve_stat_idreserve_stat_has_usersCREATE INDEX "index_reserve_stat_has_users_on_user_reserve_stat_id" ON "reserve_stat_has_users" ("user_reserve_stat_id")      - .f 332013-02-24 14:10:282013-02-24 14:10:28-Ӳr 332013-02-24 14:10:282013-02-24 14:10:28 + .f 332013-02-25 04:59:042013-02-25 04:59:04-Ӳr 332013-02-25 04:59:042013-02-25 04:59:04 ʊf :l  ʊf :l q -AA332008-12-12 17:00:38.0000002008-12-13 17:00:38.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29q -AA332008-12-12 17:00:38.0000002008-12-13 17:00:38.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29  +AA332008-12-12 17:00:38.0000002008-12-13 17:00:38.000000MyTextpending2013-02-25 04:59:042013-02-25 04:59:04q +AA332008-12-12 17:00:38.0000002008-12-13 17:00:38.000000MyTextpending2013-02-25 04:59:042013-02-25 04:59:04      q -AA332008-12-15 18:43:02.0000002008-12-16 18:43:02.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29q -AA332008-12-15 18:43:02.0000002008-12-16 18:43:02.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29 .f 332013-02-24 14:10:282013-02-24 14:10:28-Ӳr 332013-02-24 14:10:282013-02-24 14:10:28 +AA332008-12-15 18:43:02.0000002008-12-16 18:43:02.000000MyTextpending2013-02-25 04:59:052013-02-25 04:59:05q +AA332008-12-15 18:43:02.0000002008-12-16 18:43:02.000000MyTextpending2013-02-25 04:59:052013-02-25 04:59:05 .f 332013-02-25 04:59:042013-02-25 04:59:04-Ӳr 332013-02-25 04:59:042013-02-25 04:59:04 ʊf :l CC"*  )[9Iindexindex_reserve_stat_has_users_on_user_idreserve_stat_has_usersCREATE INDEX "index_reserve_stat_has_users_on_user_id" ON "reserve_stat_has_users" ("user_id") Q35indexindex_user_checkout_stats_on_stateuser_checkout_statsCREATE INDEX "index_user_checkout_stats_on_state" ON "user_checkout_stats" ("state")!O11indexindex_user_reserve_stats_on_stateuser_reserve_statsCREATE INDEX "index_user_reserve_stats_on_state" ON "user_reserve_stats" ("state");"cEYindexindex_manifestation_checkout_stats_on_statemanifestation_checkout_statsCREATE INDEX "index_manifestation_checkout_stats_on_state" ON "manifestation_checkout_stats" ("state")7#aCUindexindex_manifestation_reserve_stats_on_statemanifestation_reserve_statsCREATE INDEX "index_manifestation_reserve_stats_on_state" ON "manifestation_reserve_stats" ("state")$%%EtableparticipatesparticipatesCREATE TABLE "participates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "event_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%I%%indexindex_participates_on_event_idparticipatesCREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id")&K%)indexindex_participates_on_patron_idparticipatesCREATE INDEX "index_participates_on_patron_id" ON "participates" ("patron_id")x'EtableextentsextentsCREATE TABLE "extents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%(99ctablemedium_of_performancesmedium_of_performancesCREATE TABLE "medium_of_performances" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) )''Qtablecontent_typescontent_typesCREATE TABLE "content_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL).*??itablepatron_relationship_typespatron_relationship_typesCREATE TABLE "patron_relationship_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL),+-- tablelending_policieslending_policiesCREATE TABLE "lending_policies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "user_group_id" integer NOT NULL, "loan_period" integer DEFAULT 0 NOT NULL, "fixed_due_date" datetime, "renewal" integer DEFAULT 0 NOT NULL, "fine" integer DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M,s-indexindex_lending_policies_on_item_id_and_user_group_idlending_policiesCREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")Um)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")Q)5indexindex_manifestations_on_updated_atmanifestationsCREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at")6WtablelicenseslicensesCREATE TABLE "licenses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" varchar(255), "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)7[tableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime) - ʊf :l .f 332013-02-24 14:10:292013-02-24 14:10:29-Ӳr 332013-02-24 14:10:292013-02-24 14:10:29 + ʊf :l .f 332013-02-25 04:59:052013-02-25 04:59:05-Ӳr 332013-02-25 04:59:052013-02-25 04:59:05 ʊf :l  ʊf :l q -AA332008-12-17 04:07:24.0000002008-12-18 04:07:24.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29q -AA332008-12-17 04:07:24.0000002008-12-18 04:07:24.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29 q -AA332008-12-20 11:36:28.0000002008-12-21 11:36:28.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29q -AA332008-12-20 11:36:28.0000002008-12-21 11:36:28.000000MyTextpending2013-02-24 14:10:292013-02-24 14:10:29 .f  332013-02-24 14:10:292013-02-24 14:10:29-Ӳr 332013-02-24 14:10:292013-02-24 14:10:29 +AA332008-12-17 04:07:24.0000002008-12-18 04:07:24.000000MyTextpending2013-02-25 04:59:042013-02-25 04:59:04q +AA332008-12-17 04:07:24.0000002008-12-18 04:07:24.000000MyTextpending2013-02-25 04:59:042013-02-25 04:59:04 q +AA332008-12-20 11:36:28.0000002008-12-21 11:36:28.000000MyTextpending2013-02-25 04:59:052013-02-25 04:59:05q +AA332008-12-20 11:36:28.0000002008-12-21 11:36:28.000000MyTextpending2013-02-25 04:59:052013-02-25 04:59:05 .f  332013-02-25 04:59:052013-02-25 04:59:05-Ӳr 332013-02-25 04:59:052013-02-25 04:59:05  ʊf :l ʊf :l  pending  pending  pending @@ -718,39 +718,39 @@  pending    1bH  _ z //tableseries_statementsseries_statementsCREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AG%%Ctabledelayed_jobsdelayed_jobsCREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "queue" varchar(255))/I55tablepatron_relationshipspatron_relationshipsCREATE TABLE "patron_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "patron_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer)|H7%'indexdelayed_jobs_prioritydelayed_jobsCREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at") o%%tabledelayed_jobsdelayed_jobsCREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)VFindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")nE= indexindex_taggings_on_tag_idtaggingsCREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")DmtabletaggingstaggingsCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(255), "created_at" datetime)SCtabletagstagsCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "name_transcription" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)@BgCaindexindex_manifestation_relationships_on_child_idmanifestation_relationshipsCREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")CAiCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationshipsCREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")K@CCtablemanifestation_relationshipsmanifestation_relationshipsCREATE TABLE "manifestation_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "manifestation_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer)y/indexindex_series_statements_on_series_statement_identifierseries_statementsCREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier") =M+-indexindex_import_requests_on_user_idimport_requestsCREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")(<_+Qindexindex_import_requests_on_manifestation_idimport_requestsCREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id");G+!indexindex_import_requests_on_isbnimport_requestsCREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn"):++atableimport_requestsimport_requestsCREATE TABLE "import_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "isbn" varchar(255), "state" varchar(255), "manifestation_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)8[Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id") DGGtableuser_group_has_checkout_typesuser_group_has_checkout_typesCREATE TABLE "user_group_has_checkout_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer NOT NULL, "checkout_type_id" integer NOT NULL, "checkout_limit" integer DEFAULT 0 NOT NULL, "checkout_period" integer DEFAULT 0 NOT NULL, "checkout_renewal_limit" integer DEFAULT 0 NOT NULL, "reservation_limit" integer DEFAULT 0 NOT NULL, "reservation_expired_period" integer DEFAULT 7 NOT NULL, "set_due_date_before_closing_day" boolean DEFAULT 'f' NOT NULL, "fixed_due_date" datetime, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "current_checkout_count" integer)E)indexindex_checkout_types_on_namecheckout_typesCREATE INDEX "index_checkout_types_on_name" ON "checkout_types" ("name")GGAtableuser_group_has_checkout_typesuser_group_has_checkout_typesCREATE TABLE "user_group_has_checkout_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer NOT NULL, "checkout_type_id" integer NOT NULL, "checkout_limit" integer DEFAULT 0 NOT NULL, "checkout_period" integer DEFAULT 0 NOT NULL, "checkout_renewal_limit" integer DEFAULT 0 NOT NULL, "reservation_limit" integer DEFAULT 0 NOT NULL, "reservation_expired_period" integer DEFAULT 7 NOT NULL, "set_due_date_before_closing_day" boolean DEFAULT 'f' NOT NULL, "fixed_due_date" datetime, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)WuG}indexindex_user_group_has_checkout_types_on_user_group_iduser_group_has_checkout_typesCREATE INDEX "index_user_group_has_checkout_types_on_user_group_id" ON "user_group_has_checkout_types" ("user_group_id")`{G indexindex_user_group_has_checkout_types_on_checkout_type_iduser_group_has_checkout_typesCREATE INDEX "index_user_group_has_checkout_types_on_checkout_type_id" ON "user_group_has_checkout_types" ("checkout_type_id")VKK!tablecarrier_type_has_checkout_typescarrier_type_has_checkout_typesCREATE TABLE "carrier_type_has_checkout_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "carrier_type_id" integer NOT NULL, "checkout_type_id" integer NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)YqKindexindex_carrier_type_has_checkout_types_on_m_form_idcarrier_type_has_checkout_typesCREATE INDEX "index_carrier_type_hashgfe  -  ||D33MicrofilmMyTextMyText2013-02-24 14:10:282013-02-24 14:10:28< 33CDMyTextMyText2013-02-24 14:10:282013-02-24 14:10:28 ccK##33AccompaniedAccompaniedMyText2013-02-24 14:10:292013-02-24 14:10:29N'' 33UnaccompaniedUnaccompaniedMyText2013-02-24 14:10:292013-02-24 14:10:29 cY1133Cartographic ImageCartographic ImageMyText2013-02-24 14:10:282013-02-24 14:10:28]5533Cartographic DatasetCartographic DatasetMyText2013-02-24 14:10:282013-02-24 14:10:28< 33texttextMyText2013-02-24 14:10:282013-02-24 14:10:28 HH933ChildChild2013-02-24 14:10:292013-02-24 14:10:29;33MemberMember2013-02-24 14:10:292013-02-24 14:10:29> 33See alsoSee also2013-02-24 14:10:292013-02-24 14:10:29 @@5U  33  -2013-02-24 14:10:292013-02-24 14:10:29:H   33 -MyText2013-02-24 14:10:292013-02-24 14:10:29:U   33 -MyText2013-02-24 14:10:292013-02-24 14:10:29;Ⱥi   33 -MyText2013-02-24 14:10:292013-02-24 14:10:29:   33 -MyText2013-02-24 14:10:292013-02-24 14:10:29;_   33 +  ||D33MicrofilmMyTextMyText2013-02-25 04:59:042013-02-25 04:59:04< 33CDMyTextMyText2013-02-25 04:59:042013-02-25 04:59:04 ccK##33AccompaniedAccompaniedMyText2013-02-25 04:59:052013-02-25 04:59:05N'' 33UnaccompaniedUnaccompaniedMyText2013-02-25 04:59:052013-02-25 04:59:05 cY1133Cartographic ImageCartographic ImageMyText2013-02-25 04:59:042013-02-25 04:59:04]5533Cartographic DatasetCartographic DatasetMyText2013-02-25 04:59:042013-02-25 04:59:04< 33texttextMyText2013-02-25 04:59:042013-02-25 04:59:04 HH933ChildChild2013-02-25 04:59:052013-02-25 04:59:05;33MemberMember2013-02-25 04:59:052013-02-25 04:59:05> 33See alsoSee also2013-02-25 04:59:052013-02-25 04:59:05 @@5U  33  +2013-02-25 04:59:042013-02-25 04:59:04:H   33 +MyText2013-02-25 04:59:042013-02-25 04:59:04:U   33 +MyText2013-02-25 04:59:042013-02-25 04:59:04;Ⱥi   33 +MyText2013-02-25 04:59:042013-02-25 04:59:04:   33 +MyText2013-02-25 04:59:042013-02-25 04:59:04;_   33  -MyText2013-02-24 14:10:292013-02-24 14:10:29;ڑL  33 -MyText2013-02-24 14:10:292013-02-24 14:10:299p  33 -MyText2013-02-24 14:10:292013-02-24 14:10:29 +MyText2013-02-25 04:59:042013-02-25 04:59:04;ڑL  33 +MyText2013-02-25 04:59:042013-02-25 04:59:049p  33 +MyText2013-02-25 04:59:042013-02-25 04:59:04   ca  |H   7L .i  .  -_  0 )p CnG W x _'J[5Iindexindex_patron_relationships_on_parent_idpatron_relationshipsCREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("p'J[5Iindexindex_patron_relationships_on_parent_idpatron_relationshipsCREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("parent_id")$KY5Eindexindex_patron_relationships_on_child_idpatron_relationshipsCREATE INDEX "index_patron_relationships_on_child_id" ON "patron_relationships" ("child_id")CLMMwtablemanifestation_relationship_typesmanifestation_relationship_typesCREATE TABLE "manifestation_relationship_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)3M;;{tableresource_import_resultsresource_import_resultsCREATE TABLE "resource_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_import_file_id" integer, "manifestation_id" integer, "item_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]N}; indexindex_resource_import_results_on_resource_import_file_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id")HOo;qindexindex_resource_import_results_on_manifestation_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")-P];Mindexindex_resource_import_results_on_item_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")$Q77etablepatron_import_resultspatron_import_resultsCREATE TABLE "patron_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_import_file_id" integer, "patron_id" integer, "user_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) R559tableevent_import_resultsevent_import_resultsCREATE TABLE "event_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_import_file_id" integer, "event_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S))utablelibrary_groupslibrary_groupsBCREATE TABLE "library_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_name" varchar(255) NOT NULL, "email" varchar(255), "my_networks" text, "use_dsbl" boolean DEFAULT 'f' NOT NULL, "dsbl_list" text, "login_banner" text, "note" text, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "allow_bookmark_external_url" boolean DEFAULT 'f' NOT NULL, "url" varchar(255) DEFAULT 'http://localhost:3000/')TQ)5indexindex_library_groups_on_short_namelibrary_groupsCCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")tUCindexindex_items_on_bookstore_iditemsCREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")VYtablereservesreserves.CREATE TABLE "reserves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "canceled_at" datetime, "expired_at" datetime, "deleted_at" datetime, "state" varchar(255), "expiration_notice_to_patron" boolean DEFAULT 'f', "expiration_notice_to_library" boolean DEFAULT 'f')pW?indexindex_reserves_on_user_idreserves/CREATE INDEX "index_reserves_on_user_id" ON "reserves" ("user_id") XQ5indexindex_reserves_on_manifestation_idreserves0CREATE INDEX "index_reserves_on_manifestation_id" ON "reserves" ("manifestation_id")pY?indexindex_reserves_on_item_idreserves1CREATE INDEX "index_reserves_on_item_id" ON "reserves" ("item_id") 833mitMITMIT2013-02-24 14:10:292013-02-24 14:10:29C 33unknownunknownunknown2013-02-24 14:10:292013-02-24 14:10:29  - "n"J+33テスト雑誌2013-02-24 14:10:292013-02-24 14:10:29tP33title22013-02-24 14:10:292013-02-24 14:10:29テスト09135707t> 33title12013-02-24 14:10:292013-02-24 14:10:29f mmDf) 33978-4774141640pending2013-02-24 14:10:282013-02-24 14:10:28CӲr) 33978-4774142043pending2013-02-24 14:10:282013-02-24 14:10:28 +_  0 )p CnG W x _'J[5Iindexindex_patron_relationships_on_parent_idpatron_relationshipsCREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("p'J[5Iindexindex_patron_relationships_on_parent_idpatron_relationshipsCREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("parent_id")$KY5Eindexindex_patron_relationships_on_child_idpatron_relationshipsCREATE INDEX "index_patron_relationships_on_child_id" ON "patron_relationships" ("child_id")CLMMwtablemanifestation_relationship_typesmanifestation_relationship_typesCREATE TABLE "manifestation_relationship_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)3M;;{tableresource_import_resultsresource_import_resultsCREATE TABLE "resource_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_import_file_id" integer, "manifestation_id" integer, "item_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]N}; indexindex_resource_import_results_on_resource_import_file_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id")HOo;qindexindex_resource_import_results_on_manifestation_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")-P];Mindexindex_resource_import_results_on_item_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")$Q77etablepatron_import_resultspatron_import_resultsCREATE TABLE "patron_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_import_file_id" integer, "patron_id" integer, "user_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) R559tableevent_import_resultsevent_import_resultsCREATE TABLE "event_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_import_file_id" integer, "event_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S))utablelibrary_groupslibrary_groupsBCREATE TABLE "library_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_name" varchar(255) NOT NULL, "email" varchar(255), "my_networks" text, "use_dsbl" boolean DEFAULT 'f' NOT NULL, "dsbl_list" text, "login_banner" text, "note" text, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "allow_bookmark_external_url" boolean DEFAULT 'f' NOT NULL, "url" varchar(255) DEFAULT 'http://localhost:3000/')TQ)5indexindex_library_groups_on_short_namelibrary_groupsCCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")tUCindexindex_items_on_bookstore_iditemsCREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")VYtablereservesreserves.CREATE TABLE "reserves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "canceled_at" datetime, "expired_at" datetime, "deleted_at" datetime, "state" varchar(255), "expiration_notice_to_patron" boolean DEFAULT 'f', "expiration_notice_to_library" boolean DEFAULT 'f')pW?indexindex_reserves_on_user_idreserves/CREATE INDEX "index_reserves_on_user_id" ON "reserves" ("user_id") XQ5indexindex_reserves_on_manifestation_idreserves0CREATE INDEX "index_reserves_on_manifestation_id" ON "reserves" ("manifestation_id")pY?indexindex_reserves_on_item_idreserves1CREATE INDEX "index_reserves_on_item_id" ON "reserves" ("item_id") 833mitMITMIT2013-02-25 04:59:042013-02-25 04:59:04C 33unknownunknownunknown2013-02-25 04:59:042013-02-25 04:59:04  + "n"J+33テスト雑誌2013-02-25 04:59:052013-02-25 04:59:05tP33title22013-02-25 04:59:052013-02-25 04:59:05テスト09135707t> 33title12013-02-25 04:59:052013-02-25 04:59:05f mmDf) 33978-4774141640pending2013-02-25 04:59:042013-02-25 04:59:04CӲr) 33978-4774142043pending2013-02-25 04:59:042013-02-25 04:59:04 2_b / Z c 6 Y2Mb))Utablemanifestationsmanifestations 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, "date_copyrighted" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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" integer, "width" integer, "depth" integer, "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_string" varchar(255), "issue_number_string" varchar(255), "serial_number_string" varchar(255), "edition" integer, "note" text, "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, "attachment_file_name" varchar(255), "attachment_content_type" varchar(255), "attachment_file_size" integer, "attachment_updated_at" datetime, "title_alternative_transcription" text, "description" text, "abstract" text, "available_at" datetime, "valid_until" datetime, "date_submitted" datetime, "date_accepted" datetime, "date_caputured" datetime, "pub_date" varchar(255), "edition_string" varchar(255), "volume_number" integer, "issue_number" integer, "serial_number" integer, "ndc" varchar(255), "content_type_id" integer DEFAULT 1, "year_of_publication" integer, "attachment_meta" text, "month_of_publication" integer, "fulltext_content" boolean, "doi" varchar(255))cE)indexindex_manifestations_on_isbnmanifestations CREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")Pas?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestationsCREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")Y`y?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 NOT NULL, "updated_at" datetime NOT NULL)s^ ;)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")Q]u;}indexindex_series_statement_merges_on_series_statement_idseries_statement_mergesCREATE INDEX "index_series_statement_merges_on_series_statement_id" ON "series_statement_merges" ("series_statement_id")/\;;stableseries_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 NOT NULL, "updated_at" datetime NOT NULL)y[EEstableseries_statement_merge_listsseries_statement_merge_listsCREATE TABLE "series_statement_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Z]Mindexindex_reserves_on_request_status_type_idreserves2CREATE INDEX "index_reserves_on_request_status_type_id" ON "reserves" ("request_status_type_id") )978-4774141640ʊf)978-4774142043:l ʊf :l  ʊf :l - ]]2ӓ_ 332013-02-24 14:10:292013-02-24 14:10:290f 332013-02-24 14:10:292013-02-24 14:10:29/Ӳr  332013-02-24 14:10:292013-02-24 14:10:29 + ]]2ӓ_ 332013-02-25 04:59:042013-02-25 04:59:040f 332013-02-25 04:59:042013-02-25 04:59:04/Ӳr  332013-02-25 04:59:042013-02-25 04:59:04  tʊf :l  tʊf:l      - 0f 332013-02-24 14:10:292013-02-24 14:10:29/Ӳr  332013-02-24 14:10:292013-02-24 14:10:29 + 0f 332013-02-25 04:59:052013-02-25 04:59:05/Ӳr  332013-02-25 04:59:052013-02-25 04:59:05 ʊf :l -ʊf:l 733copycopy2013-02-24 14:10:292013-02-24 14:10:29@ 33successorsuccessor2013-02-24 14:10:292013-02-24 14:10:29 4 33MyText2013-02-24 14:10:292013-02-24 14:10:294 33MyText2013-02-24 14:10:292013-02-24 14:10:29fG( nO0 v W 8  ~ _ @ !  g H ) +ʊf:l 733copycopy2013-02-25 04:59:042013-02-25 04:59:04@ 33successorsuccessor2013-02-25 04:59:042013-02-25 04:59:04 4 33MyText2013-02-25 04:59:052013-02-25 04:59:054 33MyText2013-02-25 04:59:052013-02-25 04:59:05fG( nO0 v W 8  ~ _ @ !  g H ) i @@ -758,32 +758,32 @@ ) i I ) iI) iI) iI) iI) iI) iI) ) iiII) har(255), "creaA2010-03-19 04:00:00.000000A2010-03-19 04:00:00.000000A2010-03-16 02:00:00.000000A2010-03-03 11:00:00.000000A2010-03-03 11:00:00.000000A2010-03-03 11:00:00.000000A2010-03-03 11:00:00.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-15 07:14:18.000000A2010-03-15 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000A2010-03-01 07:14:18.000000~A2010-03-01 07:14:18.000000}A2010-03-01 07:14:18.000000|A2010-03-01 07:14:18.000000{A2010-03-01 07:14:18.000000zA2010-03-01 07:14:18.000000yA2010-03-01 07:14:18.000000xA2010-03-01 07:14:18.000000wA2010-03-01 07:14:18.000000vA2010-03-01 07:14:18.000000uA2010-03-01 07:14:18.000000tA2010-03-01 07:14:18.000000sA2010-03-01 07:14:18.000000rA2010-03-01 07:14:18.000000qA2010-03-01 07:14:18.000000pA2010-03-01 07:14:18.000000oA2010-03-01 07:14:18.000000nA2010-03-01 07:14:18.000000mA2010-03-01 07:14:18.000000lA2010-03-01 07:14:18.000000kA2010-03-01 07:14:18.000000jA2010-03-01 07:14:18.000000iA2010-03-01 07:14:18.000000hA2010-03-01 07:14:18.000000gA2010-03-01 07:14:18.000000fA2010-03-01 07:14:18.000000eA2008-04-16 15:34:01.000000A2007-11-19 07:59:21.799724A2007-11-19 07:59:20.799724 A2007-11-19 07:59:09.799724 A2007-11-19 07:59:08.166195 A2007-11-19 07:59:07.463333A2007-11-19 07:59:06.892741A2007-11-19 07:59:05.255684A2007-11-19 07:59:04.333183A2007-11-19 07:59:03.275738A2007-11-19 07:59:02.618359A2007-11-19 07:59:01.9A2010-03-01 07:14:18.000000     -  4 33MyText2013-02-24 14:10:292013-02-24 14:10:294 33MyText2013-02-24 14:10:292013-02-24 14:10:29  +  4 33MyText2013-02-25 04:59:052013-02-25 04:59:054 33MyText2013-02-25 04:59:052013-02-25 04:59:05           zv 9 !rtableusersusersCREATE TABLE "users" ("id" I|dC)indexindex_manifestations_on_nbnmanifestations CREATE INDEX "index_manifestations_on_nb|dC)indexindex_manifestations_on_nbnmanifestations CREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")eE)indexindex_manifestations_on_lccnmanifestationsCREATE INDEX "index_manifestations_on_lccn" ON "manifestations" ("lccn")fS)9indexindex_manifestations_on_oclc_numbermanifestationsCREATE INDEX "index_manifestations_on_oclc_number" ON "manifestations" ("oclc_number")gE)indexindex_manifestations_on_issnmanifestationsCREATE INDEX "index_manifestations_on_issn" ON "manifestations" ("issn")hY)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address");im)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")jQ)5indexindex_manifestations_on_updated_atmanifestationsCREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at"))k//tableseries_statementsseries_statementsCREATE 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 NOT NULL, "updated_at" datetime NOT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "issn" varchar(255), "periodical" boolean DEFAULT 'f' NOT NULL, "root_manifestation_id" integer, "note" text, "title_subseries_transcription" text)5lc/cindexindex_series_statements_on_manifestation_idseries_statementsCREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("root_manifestation_id")Qmy/indexindex_series_statements_on_series_statement_identifierseries_statementsCREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")~n%%=tablecreate_typescreate_typesCREATE TABLE "create_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)o''?tablerealize_typesrealize_typesCREATE TABLE "realize_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)p''?tableproduce_typesproduce_typesCREATE TABLE "produce_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)iq/tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)<rUtableusersusersCREATE 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), "user_number" varchar(255), "library_id" integer, "locked_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) 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), "save_checkout_history" boolean DEFAULT 'f' NOT NULL, "checkout_icalendar_token" varchar(255), "share_bookmarks" boolean)  CC> 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    gX#I33illustratoren: Illustrator -ja: 作画者2013-02-24 14:10:282013-02-24 14:10:28S!A33translatoren: Translator -ja: 訳者2013-02-24 14:10:282013-02-24 14:10:28K933editoren: Editor -ja: 編者2013-02-24 14:10:282013-02-24 14:10:28J9 33authoren: Author -ja: 著者2013-02-24 14:10:282013-02-24 14:10:28 _X#I33illustratoren: Illustrator -ja: 作画者2013-02-24 14:10:292013-02-24 14:10:29S!A33translatoren: Translator -ja: 訳者2013-02-24 14:10:292013-02-24 14:10:29J9 33editoren: Editor -ja: 編者2013-02-24 14:10:292013-02-24 14:10:29 [[N?33selleren: Seller -ja: 販売者2013-02-24 14:10:292013-02-24 14:10:29SE 33publisheren: Publisher -ja: 出版者2013-02-24 14:10:292013-02-24 14:10:29 LH''33AdministratorAdministrator2013-02-24 14:10:292013-02-24 14:10:29@33LibrarianLibrarian2013-02-24 14:10:292013-02-24 14:10:29633UserUser2013-02-24 14:10:292013-02-24 14:10:29833GuestGuest2013-02-24 14:10:292013-02-24 14:10:29   N p   AAAA user4ja000072013-02-23 14:10:28.0000002007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417fw AAA user3ja000062007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417f+  AA=user2ja2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9caf: !AAGlibrarian2ja000042008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2@library.example.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpSf[ AAA]user1ja000032007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uWte3e0277cbba03183c3a12d2b740f3eabebd7df0dO ! AAK5librarian1ja000022007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzSfAVRjefcBcey6f1WyYXDl]AAC]adminja000012007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJit577830b08ecf9c4c4333d599a57a6f44a7fe76c0 +ja: 作画者2013-02-25 04:59:042013-02-25 04:59:04S!A33translatoren: Translator +ja: 訳者2013-02-25 04:59:042013-02-25 04:59:04K933editoren: Editor +ja: 編者2013-02-25 04:59:042013-02-25 04:59:04J9 33authoren: Author +ja: 著者2013-02-25 04:59:042013-02-25 04:59:04 _X#I33illustratoren: Illustrator +ja: 作画者2013-02-25 04:59:052013-02-25 04:59:05S!A33translatoren: Translator +ja: 訳者2013-02-25 04:59:052013-02-25 04:59:05J9 33editoren: Editor +ja: 編者2013-02-25 04:59:052013-02-25 04:59:05 [[N?33selleren: Seller +ja: 販売者2013-02-25 04:59:052013-02-25 04:59:05SE 33publisheren: Publisher +ja: 出版者2013-02-25 04:59:052013-02-25 04:59:05 LH''33AdministratorAdministrator2013-02-25 04:59:052013-02-25 04:59:05@33LibrarianLibrarian2013-02-25 04:59:052013-02-25 04:59:05633UserUser2013-02-25 04:59:052013-02-25 04:59:05833GuestGuest2013-02-25 04:59:052013-02-25 04:59:05   N p   AAAA user4ja000072013-02-24 04:59:03.0000002007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417fw AAA user3ja000062007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417f+  AA=user2ja2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9caf: !AAGlibrarian2ja000042008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2@library.example.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpSf[ AAA]user1ja000032007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uWte3e0277cbba03183c3a12d2b740f3eabebd7df0dO ! AAK5librarian1ja000022007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzSfAVRjefcBcey6f1WyYXDl]AAC]adminja000012007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJit577830b08ecf9c4c4333d599a57a6f44a7fe76c0 !|_@!Auser4@kamata.lib.teu.ac.jpAuser3@kamata.lib.teu.ac.jp=user2@library.example.jp!Glibrarian2@library.example.jpAuser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jpC tanabe@kamata.lib.teu.ac.jp - g4.]332013-02-24 14:10:292013-02-24 14:10:29.z332013-02-24 14:10:292013-02-24 14:10:29.o332013-02-24 14:10:292013-02-24 14:10:29.U332013-02-24 14:10:292013-02-24 14:10:29.ƊW332013-02-24 14:10:292013-02-24 14:10:29.q332013-02-24 14:10:292013-02-24 14:10:29-x 332013-02-24 14:10:292013-02-24 14:10:29 + g4.]332013-02-25 04:59:052013-02-25 04:59:05.z332013-02-25 04:59:052013-02-25 04:59:05.o332013-02-25 04:59:052013-02-25 04:59:05.U332013-02-25 04:59:052013-02-25 04:59:05.ƊW332013-02-25 04:59:052013-02-25 04:59:05.q332013-02-25 04:59:052013-02-25 04:59:05-x 332013-02-25 04:59:052013-02-25 04:59:05 zz,]e3e0277cbba03183c3a12d2b740f3eabebd7df0d5AVRjefcBcey6f1WyYXDl+] 577830b08ecf9c4c4333d599a57a6f44a7fe76c0 Qn p ~ ' - F )itSGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")_u))wtableuser_has_rolesuser_has_rolesCREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v[Windexindex_users_on_checkout_icalendar_tokenusersCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")~w%%=tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)\x77Wtableresource_import_filesresource_imL|33?tablepatron_import_filespatron_import_fileszCREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "patron_import_file_name" varchar(255), "patron_import_content_type" varchar(255), "patron_import_file_size" integer, "patron_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "patron_import_fingerprint" varchar(255), "error_message" text, "edit_mode" varchar(255))^s5}indexindex_users_on_emailusersCREATE INDEX "index_users_on_email" ON "users" ("email")tSGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")_u))wtableuser_has_rolesuser_has_rolesCREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v[Windexindex_users_on_checkout_icalendar_tokenusersCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")~w%%=tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)\x77Wtableresource_import_filesresource_import_files~CREATE TABLE "resource_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "resource_import_file_name" varchar(255), "resource_import_content_type" varchar(255), "resource_import_file_size" integer, "resource_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "edit_mode" varchar(255), "resource_import_fingerprint" varchar(255), "error_message" text)*y]7Mindexindex_resource_import_files_on_parent_idresource_import_filesCREATE INDEX "index_resource_import_files_on_parent_id" ON "resource_import_files" ("parent_id")%zY7Eindexindex_resource_import_files_on_user_idresource_import_filesCREATE INDEX "index_resource_import_files_on_user_id" ON "resource_import_files" ("user_id"){U7=indexindex_resource_import_files_on_stateresource_import_filesCREATE INDEX "index_resource_import_files_on_state" ON "resource_import_files" ("state")633 tablepatron_import_filespatron_import_fileszCREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "patron_import_file_name" varchar(255), "patron_import_content_type" varchar(255), "patron_import_file_size" integer, "patron_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "patron_import_fingerprint" varchar(255), "error_message" text) yy?33DonationDonation2013-02-24 14:10:282013-02-24 14:10:28D## 33Public fundPublic fund2013-02-24 14:10:282013-02-24 14:10:28 + F )itSGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")_u))wtableuser_has_rolesuser_has_rolesCREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v[Windexindex_users_on_checkout_icalendar_tokenusersCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")~w%%=tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)\x77Wtableresource_import_filesresource_imL|33?tablepatron_import_filespatron_import_fileszCREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "patron_import_file_name" varchar(255), "patron_import_content_type" varchar(255), "patron_import_file_size" integer, "patron_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "patron_import_fingerprint" varchar(255), "error_message" text, "edit_mode" varchar(255))^s5}indexindex_users_on_emailusersCREATE INDEX "index_users_on_email" ON "users" ("email")tSGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")_u))wtableuser_has_rolesuser_has_rolesCREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)v[Windexindex_users_on_checkout_icalendar_tokenusersCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")~w%%=tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)\x77Wtableresource_import_filesresource_import_files~CREATE TABLE "resource_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "resource_import_file_name" varchar(255), "resource_import_content_type" varchar(255), "resource_import_file_size" integer, "resource_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "edit_mode" varchar(255), "resource_import_fingerprint" varchar(255), "error_message" text)*y]7Mindexindex_resource_import_files_on_parent_idresource_import_filesCREATE INDEX "index_resource_import_files_on_parent_id" ON "resource_import_files" ("parent_id")%zY7Eindexindex_resource_import_files_on_user_idresource_import_filesCREATE INDEX "index_resource_import_files_on_user_id" ON "resource_import_files" ("user_id"){U7=indexindex_resource_import_files_on_stateresource_import_filesCREATE INDEX "index_resource_import_files_on_state" ON "resource_import_files" ("state")633 tablepatron_import_filespatron_import_fileszCREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "patron_import_file_name" varchar(255), "patron_import_content_type" varchar(255), "patron_import_file_size" integer, "patron_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "patron_import_fingerprint" varchar(255), "error_message" text) yy?33DonationDonation2013-02-25 04:59:042013-02-25 04:59:04D## 33Public fundPublic fund2013-02-25 04:59:042013-02-25 04:59:04  q  Q =qG}C)indexindex_manifestations_on_doimanifestationsCREATE INDEX "index_manifestations_on_doi" ON "manifestations" ("doi")&IIEtableseries_statement_relationshipsseries_statement_relationshipsCREATE TABLE "series_statement_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"}Y3Eindexindex_patron_import_files_on_parent_idpatron_import_files{CREATE INDEX "index_patron_import_files_on_parent_id" ON "patron_import_files" ("parent_id")~U3=indexindex_patron_import_files_on_user_idpatron_import_files|CREATE INDEX "index_patron_import_files_on_user_id" ON "patron_import_files" ("user_id")Q35indexindex_patron_import_files_on_statepatron_import_files}CREATE INDEX "index_patron_import_files_on_state" ON "patron_import_files" ("state")E113tableevent_import_filesevent_import_filesCREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "event_import_file_name" varchar(255), "event_import_content_type" varchar(255), "event_import_file_size" integer, "event_import_updated_at" datetime, "edit_mode" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "event_import_fingerprint" varchar(255), "error_message" text)W1Aindexindex_event_import_files_on_parent_idevent_import_filesCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id")S19indexindex_event_import_files_on_user_idevent_import_filesCREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id")O11indexindex_event_import_files_on_stateevent_import_filesCREATE INDEX "index_event_import_files_on_state" ON "event_import_files" ("state") Q5indexindex_patrons_on_patron_identifierpatronsCREATE INDEX "index_patrons_on_patron_identifier" ON "patrons" ("patron_identifier")   /zupkfa\WRMHC>93-'! ysmga[UOIC=71+%  } w q k e _ Y S M G A ; 5 /~}|{zyxwvutsrqponmlkjihgfe    _^f 6Tz0Tv:z(Dt2Nl L x \ No newline at end of file