spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre vs spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre2
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ -$ # ])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") [)Iindexindex_manifestations_on_carrier_type_idmanifestations CREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id")&
+SQLite format 3 @ # # -$ # ])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") [)Iindexindex_manifestations_on_carrier_type_idmanifestations CREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id")&
))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")xE indexindex_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 y ځm ҁb T H . q t _f MU >C *6 !
xqjc\UNG@.
zhVD2
~
l
Z
H
6
$
p ^ L : ( t b P > ,
@@ -149,12 +149,12 @@
-
>|
Y 6 s a
A`
?AA2012-01-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996` ?AA2012-01-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-01-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_
- ?AA
2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA 2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ AAA2010-09-14 15:00:00.000000 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:34:07.3630232007-09-07 16:34:25.103403_ ?AA2012-07-30 00:00:00 +0900 2007-09-07 16:19:02.2858502007-09-07 16:20:22.000026
I
$
+
>|
Y 6 s a
A`
?AA2012-01-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996` ?AA2012-01-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-01-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_
+ ?AA
2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA 2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ AAA2010-09-14 15:00:00.000000 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:39:03.2100812007-09-09 12:15:11.648996_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:34:07.3630232007-09-07 16:34:25.103403_ ?AA2012-07-31 00:00:00 +0900 2007-09-07 16:19:02.2858502007-09-07 16:20:22.000026
I
$
{rIIIIII " tablereservesreserves1CREATE 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))t6A indexindex_bookmarks_on_user_idbookmarks:CREATE INDEX "index_bookmarks_on_user_id" ON "bookmarks" ("user_id")"5 tablebookmarksbookmarks9CREATE 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) 4Q 5indexindex_produces_on_manifestation_idproduces8CREATE INDEX "index_produces_on_manifestation_id" ON "produces" ("manifestation_id")v3C indexindex_produces_on_patron_idproduces7CREATE INDEX "index_produces_on_patron_id" ON "produces" ("patron_id") Mtableproducesproduces6CREATE 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_idreserves5CREATE INDEX "index_reserves_on_request_status_type_id" ON "reserves" ("request_status_type_id") r? indexindex_reserves_on_item_idreserves4CREATE INDEX "index_reserves_on_item_id2 tableproducesproduces6CREATE 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_idcheckouts0CREATE 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)E indexindex_checkouts_on_basket_idcheckouts-CREATE INDEX "index_checkouts_on_basket_id" ON "checkouts" ("basket_id")t(A indexindex_checkouts_on_item_idcheckouts,CREATE INDEX "index_checkouts_on_item_id" ON "checkouts" ("item_id")t'A indexindex_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%C indexindex_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")p#? indexindex_checkins_on_item_idcheckins&CREATE INDEX "index_checkins_on_item_id" ON "checkins" ("item_id")o" 1tablecheckinscheckins%CREATE TABLE "checkins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "librarian_id" integer, "basket_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
@@ -167,12 +167,12 @@
P
(
x
6 F
o
- k AA A j AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-29 22:50:23 +0900requestedffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-29 22:50:23 +0900retainedffj
AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-27 22:50:23 +0900requestedffi AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-27 22:50:23 +0900retainedffh AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-27 22:50:23 +0900expiredff
- ?AA ? 2012-07-21 22:50:23 +09002007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-07-28 21:50:23 +0900completedffj AA ? 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-07-27 22:50:23 +0900requestedffh AA ? 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-07-21 22:50:23 +0900expiredffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-08-04 22:50:23 +0900requestedffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-08-04 22:50:23 +0900requestedffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-08-04 22:50:23 +0900requestedffj AA ? 2007-09-01 05:14:52.3568032007-09-02 08:51:54.8878492012-08-04 22:50:23 +0900requestedffj AA ? 2007-09-02 10:16:55.7148122007-09-02 10:16:55.7148122012-08-04 22:50:23 +0900requestedffj AA ? 2007-09-02 09:37:25.5760872007-09-02 09:37:25.5760872012-08-04 22:50:23 +0900requestedffj AA ? 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-08-04 22:50:23 +0900requestedff
+ k AA A j AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-30 04:25:36 +0900requestedffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-30 04:25:36 +0900retainedffj
AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-28 04:25:36 +0900requestedffi AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-28 04:25:36 +0900retainedffh AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-07-28 04:25:36 +0900expiredff
+ ?AA ? 2012-07-22 04:25:36 +09002007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-07-29 03:25:36 +0900completedffj AA ? 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-07-28 04:25:36 +0900requestedffh AA ? 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-07-22 04:25:36 +0900expiredffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-08-05 04:25:36 +0900requestedffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-08-05 04:25:36 +0900requestedffj AA ? 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542012-08-05 04:25:36 +0900requestedffj AA ? 2007-09-01 05:14:52.3568032007-09-02 08:51:54.8878492012-08-05 04:25:36 +0900requestedffj AA ? 2007-09-02 10:16:55.7148122007-09-02 10:16:55.7148122012-08-05 04:25:36 +0900requestedffj AA ? 2007-09-02 09:37:25.5760872007-09-02 09:37:25.5760872012-08-05 04:25:36 +0900requestedffj AA ? 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142012-08-05 04:25:36 +0900requestedff
@@ -187,29 +187,29 @@
g
y %
AA mitaMita Library三田108-8345MinatoTokyo| 2007-08-23 10:51:00.0000002007-08-30 15:18:20.043951 - %
% AA hachiojiHachioji 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-0000000d ) AA webWorld Wide WebWeb| 2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349
ngr
# A <gtableshelvesshelvesACREATE 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)W9 }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))C tableeventseventsHCREATE 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)B##MtablefrequenciesfrequenciesGCREATE 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_groupsDCREATE 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_typesCCREATE 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_idshelvesBCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") dtableshelvesshelvesACREATE 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)r;; indexindex_libraries_on_namelibraries@CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name"):S 9indexindex_libraries_on_library_group_idlibraries?CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")h89 indexindex_bookmarks_on_urlbookmarks<CREATE INDEX "index_bookmarks_on_url" ON "bookmarks" ("url")7S 9indexindex_bookmarks_on_manifestation_idbookmarks;CREATE INDEX "index_bookmarks_on_manifestation_id" ON "bookmarks" ("manifestation_id")
mita hachioji
-kamataweb
g L ## 33 third_shelfThird shelf 2012-07-28 13:50:242012-07-28 13:50:24fN %% 33 second_shelfSecond shelf 2012-07-28 13:50:242012-07-28 13:50:24fL ## 33 first_shelfFirst shelf 2012-07-28 13:50:242012-07-28 13:50:24fI - 33 webLibrary bookmark 2012-07-28 13:50:242012-07-28 13:50:24f
-
: X 7AADVDDVDDVDãO %AADVDDVDDVDです。2007-12-22 19:24:23.1514102007-12-22 19:24:23.151410R /AACDCD音楽CDです。2007-12-18 16:45:26.0406742007-12-18 16:45:26.040674S %AAprintprint本です。2007-11-20 06:47:03.6415302007-11-20 07:04:29.853828o aAAfilefileコンピュータのファイルです。2007-12-23 16:30:50.6374332007-12-23 16:30:50.637433
E W
AA FacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351Q
AA UserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548m f + +
AA (not specified)(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542
m m %-? 339enju_libraryja: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0f2012-07-28 13:50:242012-07-28 13:50:24fhttp://localhost:3000/
+kamataweb
g L ## 33 third_shelfThird shelf 2012-07-28 19:25:372012-07-28 19:25:37fN %% 33 second_shelfSecond shelf 2012-07-28 19:25:372012-07-28 19:25:37fL ## 33 first_shelfFirst shelf 2012-07-28 19:25:372012-07-28 19:25:37fI - 33 webLibrary bookmark 2012-07-28 19:25:372012-07-28 19:25:37f
+
: X 7AADVDDVDDVDãO %AADVDDVDDVDです。2007-12-22 19:24:23.1514102007-12-22 19:24:23.151410R /AACDCD音楽CDです。2007-12-18 16:45:26.0406742007-12-18 16:45:26.040674S %AAprintprint本です。2007-11-20 06:47:03.6415302007-11-20 07:04:29.853828o aAAfilefileコンピュータのファイルです。2007-12-23 16:30:50.6374332007-12-23 16:30:50.637433
E W
AA FacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351Q
AA UserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548m f + +
AA (not specified)(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542
m m %-? 339enju_libraryja: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0f2012-07-28 19:25:372012-07-28 19:25:37fhttp://localhost:3000/
E enju
5
l M AAmonthly隔月刊2007-12-31 12:40:31.2470812007-12-31 12:40:31.247081K AAbiweekly月刊2007-12-31 12:40:18.8036612007-12-31 12:40:18.803661L AAweekly隔週刊2007-12-31 12:40:11.1120402007-12-31 12:40:11.112040H AAdaily週刊2007-12-31 12:39:54.9807872007-12-31 12:39:54.980787P ' AAnot refularly日刊2007-12-31 12:39:45.7375312007-12-31 12:39:45.737531I AAyearly年刊2007-12-31 12:41:03.0047362007-12-31 12:41:03.004736G AAotherOther2007-12-31 12:40:31.2470812007-12-31 12:40:31.247081
$ U
` 2 $
AA AAtesttest2008-02-05 06:00:00.0000002008-02-05 06:00:00.000000ftest2008-02-05 12:00:53.9260502008-02-05 12:00:53.926050
AA AAtesttest2008-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
AA AAtest2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000ftest2008-02-05 11:41:50.5331642008-02-05 11:41:50.533164"
=AA AAテストなんとかかんとか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
AA 1AAミーティング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.
UAA AAテストテスト用のイベントです。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
^ ^U S +
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.188771[ ++
AA(not specified)(not specified)2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771
,
,
p8#MuT %J'' tablechecked_itemschecked_itemsPCREATE 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) U55_tablerequest_status_typesrequest_status_types[CREATE 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)UTw?indexindex_item_has_use_restrictions_on_use_restriction_iditem_has_use_restrictionsZCREATE INDEX "index_item_has_use_restrictions_on_use_restriction_id" ON "item_has_use_restrictions" ("use_restriction_id")4Sa?Uindexindex_item_has_use_restrictions_on_item_iditem_has_use_restrictionsYCREATE INDEX "index_item_has_use_restrictions_on_item_id" ON "item_has_use_restrictions" ("item_id") R??Gtableitem_has_use_restrictionsitem_has_use_restrictionsXCREATE 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)Q--Wtableuse_restrictionsuse_restrictionsWCREATE 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)lP=
indexindex_donates_on_item_iddonatesVCREATE INDEX "index_donates_on_item_id" ON "donates" ("item_id")rOAindexindex_donates_on_patron_iddonatesUCREATE INDEX "index_donates_on_patron_id" ON "donates" ("patron_id")]NtabledonatesdonatesTCREATE 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)sM!!1tablebookstoresbookstoresSCREATE 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)
LM'-indexindex_checked_items_on_basket_idchecked_itemsRCREATE INDEX "index_checked_items_on_basket_id" ON "checked_items" ("basket_id")KI'%indexindex_checked_items_on_item_idchecked_itemsQCREATE INDEX "index_checked_items_on_item_id" ON "checked_items" ("item_id")lI=
indexindex_baskets_on_user_idbasketsOCREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")nH3tablebasketsbasketsNCREATE 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) G''Qtableform_of_worksform_of_worksLCREATE 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)F--Wtableevent_categoriesevent_categoriesKCREATE 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)EO1indexindex_events_on_event_category_ideventsJCREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")qDAindexindex_events_on_library_ideventsICREATE INDEX "index_events_on_library_id" ON "events" ("library_id")
K CG
K = AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596=
AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596= AA 2008-01-21 08:21:58.5541462008-01-21 08:21:58.554146
-
j J I ?33 2012-08-04 22:50:23 +09002012-07-28 13:50:232012-07-28 13:50:23I ?33 2012-08-04 22:50:23 +09002012-07-28 13:50:232012-07-28 13:50:23I ?33 2012-08-04 22:50:23 +09002012-07-28 13:50:232012-07-28 13:50:23I ?33
-2012-08-04 22:50:23 +09002012-07-28 13:50:232012-07-28 13:50:23
+
j J I ?33 2012-08-05 04:25:36 +09002012-07-28 19:25:372012-07-28 19:25:37I ?33 2012-08-05 04:25:36 +09002012-07-28 19:25:372012-07-28 19:25:37I ?33 2012-08-05 04:25:36 +09002012-07-28 19:25:372012-07-28 19:25:37I ?33
+2012-08-05 04:25:36 +09002012-07-28 19:25:372012-07-28 19:25:37
k ~
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.840711I
AAunknown2008-02-10 02:14:57.6053292008-02-10 02:14:57.605329
F F < 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
-
26
Q X ]
;;
33User Signature RequiredUser Signature Required
2012-07-28 13:50:242012-07-28 13:50:24i GG
33Use Only In Controlled AccessUse Only In Controlled Access 2012-07-28 13:50:242012-07-28 13:50:24A
33Term LoanTerm Loan 2012-07-28 13:50:242012-07-28 13:50:24W
+
26
Q X ]
;;
33User Signature RequiredUser Signature Required
2012-07-28 19:25:372012-07-28 19:25:37i GG
33Use Only In Controlled AccessUse Only In Controlled Access 2012-07-28 19:25:372012-07-28 19:25:37A
33Term LoanTerm Loan 2012-07-28 19:25:372012-07-28 19:25:37W
55
33Supervision RequiredSupervision Required
-2012-07-28 13:50:242012-07-28 13:50:24[ 99
33Renewals Not PermittedRenewals Not Permitted 2012-07-28 13:50:242012-07-28 13:50:24K ))
33Overnight OnlyOvernight Only2012-07-28 13:50:242012-07-28 13:50:24G %%
33Not For LoanNot For Loan2012-07-28 13:50:242012-07-28 13:50:24M ++
33No ReproductionNo Reproduction2012-07-28 13:50:242012-07-28 13:50:24{ YY
33Limited Circulation, Short Loan PeriodLimited Circulation, Short Loan Period2012-07-28 13:50:242012-07-28 13:50:24} [[
33Limited Circulation, Normal Loan PeriodLimited Circulation, Normal Loan Period2012-07-28 13:50:242012-07-28 13:50:24U 33
33In Library Use OnlyIn Library Use Only2012-07-28 13:50:242012-07-28 13:50:24u SS
33Available For Supply Without ReturnAvailable For Supply Without Return2012-07-28 13:50:242012-07-28 13:50:24
FN < 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
+2012-07-28 19:25:372012-07-28 19:25:37[ 99
33Renewals Not PermittedRenewals Not Permitted 2012-07-28 19:25:372012-07-28 19:25:37K ))
33Overnight OnlyOvernight Only2012-07-28 19:25:372012-07-28 19:25:37G %%
33Not For LoanNot For Loan2012-07-28 19:25:372012-07-28 19:25:37M ++
33No ReproductionNo Reproduction2012-07-28 19:25:372012-07-28 19:25:37{ YY
33Limited Circulation, Short Loan PeriodLimited Circulation, Short Loan Period2012-07-28 19:25:372012-07-28 19:25:37} [[
33Limited Circulation, Normal Loan PeriodLimited Circulation, Normal Loan Period2012-07-28 19:25:372012-07-28 19:25:37U 33
33In Library Use OnlyIn Library Use Only2012-07-28 19:25:372012-07-28 19:25:37u SS
33Available For Supply Without ReturnAvailable For Supply Without Return2012-07-28 19:25:372012-07-28 19:25:37
FN < 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.878701i 99
AACannot Fulfill RequestCannot Fulfill Request2008-02-13 09:38:51.8157552008-02-13 09:38:51.815755e 55
AAAvailable For PickupAvailable For Pickup2008-02-13 09:38:38.5531142008-02-13 09:38:38.553114
a T
a c 33
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.151759M
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
Y s @
@@ -218,19 +218,19 @@
ja: 除籍済み2008-02-15 08:31:35.7864042008-02-15 08:31:35.786404 QQ
AAClaimed Returned Or Never BorrowedClaimed Returned Or Never Borrowed2008-02-15 08:31:35.7864042008-02-15 08:31:35.786404u EE
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.355304a 11
AAAvailable On ShelfAvailable On Shelf2008-02-15 08:31:18.9462982008-02-15 08:31:18.946298e 55
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.627987 UU
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
.
7 u e
?''33item_received_for_libraryItem receivedItem received
-ja2012-07-28 13:50:242012-07-28 13:50:24z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2012-07-28 13:50:242012-07-28 13:50:24k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2012-07-28 13:50:242012-07-28 13:50:24S ###33recall_itemRecall itemRecall itemja2012-07-28 13:50:242012-07-28 13:50:24z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2012-07-28 13:50:242012-07-28 13:50:24y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2012-07-28 13:50:242012-07-28 13:50:24w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2012-07-28 13:50:242012-07-28 13:50:24v I3333reservation_expired_for_patronReservation expiredReservation expiredja2012-07-28 13:50:242012-07-28 13:50:24d =''33item_received_for_patronItem receivedItem receivedja2012-07-28 13:50:242012-07-28 13:50:24y K5533reservation_accepted_for_patronReservation acceptedReservation acceptedja2012-07-28 13:50:242012-07-28 13:50:24
n R
T
z cK )inde W55 Z ktablemessagesmessagesaCREATE 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) V''Qtablerequest_typesrequest_types\CREATE 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) W55_tablecirculation_statusescirculation_statuses]CREATE 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)FX//;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 'en', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)YO/?indexindex_message_templates_on_statusmessage_templates`CREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status") H
tablemessagesmessagesaCREATE TABLE "messages" ("id" INTEGER PRa }tablerealizesrealizeshCREATE 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)v[C indexindex_messages_on_sender_idmessagesbCREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|\G !indexindex_messages_on_receiver_idmessagescCREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")]U =indexindex_messages_on_message_request_idmessagesdCREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")v^C indexindex_messages_on_parent_idmessageseCREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")W_--atablemessage_requestsmessage_requestsfCREATE 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)
+ja2012-07-28 19:25:372012-07-28 19:25:37z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2012-07-28 19:25:372012-07-28 19:25:37k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2012-07-28 19:25:372012-07-28 19:25:37S ###33recall_itemRecall itemRecall itemja2012-07-28 19:25:372012-07-28 19:25:37z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2012-07-28 19:25:372012-07-28 19:25:37y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2012-07-28 19:25:372012-07-28 19:25:37w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2012-07-28 19:25:372012-07-28 19:25:37v I3333reservation_expired_for_patronReservation expiredReservation expiredja2012-07-28 19:25:372012-07-28 19:25:37d =''33item_received_for_patronItem receivedItem receivedja2012-07-28 19:25:372012-07-28 19:25:37y K5533reservation_accepted_for_patronReservation acceptedReservation acceptedja2012-07-28 19:25:372012-07-28 19:25:37
n R
T
z cK )inde W55 Z ktablemessagesmessagesaCREATE 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) V''Qtablerequest_typesrequest_types\CREATE 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) W55_tablecirculation_statusescirculation_statuses]CREATE 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)FX//;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 'en', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)YO/?indexindex_message_templates_on_statusmessage_templates`CREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status") H
tablemessagesmessagesaCREATE TABLE "messages" ("id" INTEGER PRa }tablerealizesrealizeshCREATE 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)v[C indexindex_messages_on_sender_idmessagesbCREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|\G !indexindex_messages_on_receiver_idmessagescCREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")]U =indexindex_messages_on_message_request_idmessagesdCREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")v^C indexindex_messages_on_parent_idmessageseCREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")W_--atablemessage_requestsmessage_requestsfCREATE 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_requestsgCREATE INDEX "index_message_requests_on_state" ON "message_requests" ("state") GtablerealizesrealizeshCREATE 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)vbC indexindex_realizes_on_patron_idrealizesiCREATE INDEX "index_realizes_on_patron_id" ON "realizes" ("patron_id")cK )indexindex_realizes_on_expression_idrealizesjCREATE INDEX "index_realizes_on_expression_id" ON "realizes" ("expression_id")d##OtableexemplifiesexemplifieskCREATE 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)eW#Aindexindex_exemplifies_on_manifestation_idexemplifieslCREATE INDEX "index_exemplifies_on_manifestation_id" ON "exemplifies" ("manifestation_id")fE#+indexindex_exemplifies_on_item_idexemplifiesmCREATE UNIQUE INDEX "index_exemplifies_on_item_id" ON "exemplifies" ("item_id")
/Tx ?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#Kreservation_accepted_for_patron
G } G \ 1 A3 Dad!He is suchU 1 33 Dad!He is sucha dork.unread2012-07-26 13:50:232012-07-28 13:50:24k )I 33 Second MessageCatie, you get the 2nd messageunread2012-07-27 13:50:232012-07-28 13:50:24p /M 33 RE: First MessageThanks Dad! You are the coolest!unread2012-07-26 13:50:232012-07-28 13:50:24 3'K 73 2012-07-25 13:50:23First MessageAbby, you get the first messageunread2007-07-04 12:10:47.02012-07-28 13:50:24
+$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#Kreservation_accepted_for_patron
G } G \ 1 A3 Dad!He is suchU 1 33 Dad!He is sucha dork.unread2012-07-26 19:25:362012-07-28 19:25:37k )I 33 Second MessageCatie, you get the 2nd messageunread2012-07-27 19:25:362012-07-28 19:25:37p /M 33 RE: First MessageThanks Dad! You are the coolest!unread2012-07-26 19:25:362012-07-28 19:25:37 3'K 73 2012-07-25 19:25:36First MessageAbby, you get the first messageunread2007-07-04 12:10:47.02012-07-28 19:25:37
-
~ ~ ;f 33pending2012-07-28 13:50:242012-07-28 13:50:24;Ӳr 33pending2012-07-28 13:50:242012-07-28 13:50:24
+
~ ~ ;f 33pending2012-07-28 19:25:372012-07-28 19:25:37;Ӳr 33pending2012-07-28 19:25:372012-07-28 19:25:37
pendingʊfpending:l
v ~=z9
v ?
AA 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? AA 2008-01-10 17:40:40.3167422008-01-10 17:40:40.316742? AA 2008-01-10 17:40:24.0382762008-01-10 17:40:24.038276? AA 2008-01-11 14:35:36.4675842008-01-11 14:35:36.467584? AA 2008-01-10 17:34:32.3522232008-01-10 17:34:32.352223? AA 2008-01-10 17:34:20.1839622008-01-10 17:34:20.183962? AA 2008-01-11 14:32:03.7014252008-01-11 14:32:03.701425? AA 2008-01-11 14:28:57.0681912008-01-11 14:28:57.068191? AA 2008-01-11 14:28:19.2771102008-01-11 14:28:19.277110
@@ -246,11 +246,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
v |v
v |v
-
3 x3 C !! 33ConferenceConference2012-07-28 13:50:242012-07-28 13:50:24I '' 33CorporateBodyCorporateBody2012-07-28 13:50:242012-07-28 13:50:24; 33PersonPerson2012-07-28 13:50:242012-07-28 13:50:24
s Q-g [;
{ A A9
Y ;
+
3 x3 C !! 33ConferenceConference2012-07-28 19:25:372012-07-28 19:25:37I '' 33CorporateBodyCorporateBody2012-07-28 19:25:372012-07-28 19:25:37; 33PersonPerson2012-07-28 19:25:372012-07-28 19:25:37
s Q-g [;
{ A A9
Y ;
S
c -c] ic{
1 K7U
c
@@ -669,74 +669,74 @@
(
ie3
R!
x =+ srd che kikUell9mripcha khmTdeu8monotsn catkazSkat7molnmyakasRlug6tso kauQglg5ton san bulful4brekanPsag tir mahmbosbod fra3smo rus marlfin2bistha XXXron tel glvktat kalObenroh mltjjavNtam malique fij1jpnMtgk pli msahfao0mlggitaLpor fat/belmkdfgleKpol ipkJeusewe.ltzezul ikuIlubdest-zha tah bakileHbamtgl epo,yor inaGfas azeswe eng+yid indFaymssw dzo*xho pus panave
swa nld)wol oss~ava sun litcdiv(fry orm}asm spa linbcym iboEhye
nbl limawln ori|idoDsot lav`oji{som lat_dan'ocizislClao^ces&nnoyhunBkua]arg hrv%vol nobxhmoAkur\aracre$vie hin@kor[amhslv cos#ven her?konZsqislk cor"uzb heb>akasin chv!urd hau=norwsnd chu ukr hat<smevafrzho uig ndeuaariii komYnya twi neptabksna tuk ndoshbs runXtur navrguj;srp kirWnauqgrn:gla kinV unknown
: : n ' AA)# Manifestation2007-12-22 04:47:41.4868072012-06-02 16:09:42.770935test_00001.jpgimage/x-png 1t AAE Patron2007-12-22 06:06:30.4649302007-12-22 06:06:30.464930overlay_spinner_geometry.gifimage/giftj AA3 Shelf2007-12-22 06:06:30.4649302007-12-22 06:06:30.464930overlay_spinner.gifimage/gifty ' AA;# Manifestation2007-12-22 05:06:10.8703932007-12-22 05:06:40.293209test_00001_geometry.jpgimage/pjpeghg AA)# Shelf2007-12-22 04:47:41.4868072007-12-22 07:53:25.166728test_00001.jpgimage/x-png 1
- 'Manifestation Patron Shelf'Manifestation Shelf
V R 33 pendingMyStringtext/csv2012-07-28 13:50:242012-07-28 13:50:24R 33 pendingMyStringtext/csv2012-07-28 13:50:242012-07-28 13:50:24T 33 completedMyStringtext/csv2012-07-28 13:50:242012-07-28 13:50:24
+ 'Manifestation Patron Shelf'Manifestation Shelf
V R 33 pendingMyStringtext/csv2012-07-28 19:25:372012-07-28 19:25:37R 33 pendingMyStringtext/csv2012-07-28 19:25:372012-07-28 19:25:37T 33 completedMyStringtext/csv2012-07-28 19:25:372012-07-28 19:25:37
- ~ } pending pending
completed
V R 33 pendingMyStringtext/csv2012-07-28 13:50:242012-07-28 13:50:24R 33 pendingMyStringtext/csv2012-07-28 13:50:242012-07-28 13:50:24T 33 completedMyStringtext/csv2012-07-28 13:50:242012-07-28 13:50:24
+ ~ } pending pending
completed
V R 33 pendingMyStringtext/csv2012-07-28 19:25:372012-07-28 19:25:37R 33 pendingMyStringtext/csv2012-07-28 19:25:372012-07-28 19:25:37T 33 completedMyStringtext/csv2012-07-28 19:25:372012-07-28 19:25:37
pending pending
completed
g g i
n m
^IIIII
VH113tableevent_import_filesevent_import_files CREATE 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)WuG}indexindex_user_group_has_checkout_types_on_user_group_iduser_group_has_checkout_types CREATE INDEX "index_user_group_has_checkout_types_on_user_group_id" ON "user_group_has_checkout_types" ("user_group_id")DGGtableuser_group_has_checkout_typesuser_group_has_checkout_types CREATE 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_types CREATE INDEX "index_checkout_types_on_name" ON "checkout_types"
M+-indexindex_inventory_files_on_user_idinventory_files CREATE INDEX "index_inventory_files_on_user_id" ON "inventory_files" ("user_id")m ## tableinventoriesinventories CREATE TABLE "inventories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "inventory_file_id" integer, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)} E# indexindex_inventories_on_item_idinventories CREATE INDEX "index_inventories_on_item_id" ON "inventories" ("item_id")
Y#Eindexindex_inventories_on_inventory_file_idinventories CREATE INDEX "index_inventories_on_inventory_file_id" ON "inventories" ("inventory_file_id")bMM5tablecheckout_stat_has_manifestationscheckout_stat_has_manifestations CREATE TABLE "checkout_stat_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_checkout_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "checkouts_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){M1indexindex_checkout_stat_has_manifestations_on_checkout_stat_idcheckout_stat_has_manifestations CREATE INDEX "index_checkout_stat_has_manifestations_on_checkout_stat_id" ON "checkout_stat_has_manifestations" ("manifestation_checkout_stat_id")mMindexindex_checkout_stat_has_manifestations_on_manifestation_idcheckout_stat_has_manifestations CREATE INDEX "index_checkout_stat_has_manifestations_on_manifestation_id" ON "checkout_stat_has_manifestations" ("manifestation_id")bEEEtablemanifestation_checkout_statsmanifestation_checkout_stats CREATE TABLE "manifestation_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)8)))tablebookmark_statsbookmark_stats CREATE TABLE "bookmark_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "started_at" datetime, "completed_at" datetime, "note" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
-
U U 3 33cdcd2012-07-28 13:50:232012-07-28 13:50:23; 33serialserial2012-07-28 13:50:232012-07-28 13:50:237 33bookbook2012-07-28 13:50:232012-07-28 13:50:23
+
U U 3 33cdcd2012-07-28 19:25:372012-07-28 19:25:37; 33serialserial2012-07-28 19:25:372012-07-28 19:25:377 33bookbook2012-07-28 19:25:372012-07-28 19:25:37
cd
serialbook
dz,
L AA t2007-12-22 18:13:46.3127512007-12-22 18:13:46.312751L AA t2007-12-22 18:13:46.3127512007-12-22 18:13:46.312751L AA f2007-12-22 18:13:46.3127512007-12-22 18:13:46.312751L AA f2007-12-22 18:13:37.4404622007-12-22 18:13:37.440462L AA f2007-12-22 18:13:29.8805382007-12-22 18:13:29.880538L AA f2007-12-22 18:13:23.4168562007-12-22 18:13:23.416856L AA f2007-12-22 18:13:15.6201432007-12-22 18:13:15.620143L AA f2007-12-22 18:13:08.1070222007-12-22 18:13:08.107022
-
X X 6 33MyText2012-07-28 13:50:232012-07-28 13:50:236 33MyText2012-07-28 13:50:232012-07-28 13:50:236 33MyText2012-07-28 13:50:232012-07-28 13:50:23
+
X X 6 33MyText2012-07-28 19:25:372012-07-28 19:25:376 33MyText2012-07-28 19:25:372012-07-28 19:25:376 33MyText2012-07-28 19:25:372012-07-28 19:25:37
( (4 [
m i
Uy VKK!tablecarrier_type_has_checkout_typescarrier_type- ++tableinventory_filesinventory_files CREATE TABLE "inventory_files" ("id" INTEGER PRIMARY KEY AUG)!indexindex_bookmark_stats_on_statebookmark_stats CREATE INDEX "index_bookmark_stats_on_state" ON "bookmark_stats" ("state")TMMtablebookmark_stat_has_manifestationsbookmark_stat_has_manifestations CREATE TABLE "bookmark_stat_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOTG)!indexindex_bookmark_stats_on_statebookmark_stats CREATE INDEX "index_bookmark_stats_on_state" ON "bookmark_stats" ("state")TMMtablebookmark_stat_has_manifestationsbookmark_stat_has_manifestations CREATE TABLE "bookmark_stat_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "bookmark_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "bookmarks_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mMindexindex_bookmark_stat_has_manifestations_on_bookmark_stat_idbookmark_stat_has_manifestations CREATE INDEX "index_bookmark_stat_has_manifestations_on_bookmark_stat_id" ON "bookmark_stat_has_manifestations" ("bookmark_stat_id")mMindexindex_bookmark_stat_has_manifestations_on_manifestation_idbookmark_stat_has_manifestations CREATE INDEX "index_bookmark_stat_has_manifestations_on_manifestation_id" ON "bookmark_stat_has_manifestations" ("manifestation_id")G333tableuser_checkout_statsuser_checkout_stats CREATE 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_users CREATE 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_users CREATE 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_users CREATE INDEX "index_checkout_stat_has_users_on_user_id" ON "checkout_stat_has_users" ("user_id")]KK/tablereserve_stat_has_manifestationsreserve_stat_has_manifestations CREATE 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)x K-indexindex_reserve_stat_has_manifestations_on_m_reserve_stat_idreserve_stat_has_manifestations CREATE INDEX "index_reserve_stat_has_manifestations_on_m_reserve_stat_id" ON "reserve_stat_has_manifestations" ("manifestation_reserve_stat_id")h Kindexindex_reserve_stat_has_manifestations_on_manifestation_idreserve_stat_has_manifestations CREATE INDEX "index_reserve_stat_has_manifestations_on_manifestation_id" ON "reserve_stat_has_manifestations" ("manifestation_id")_ CCCtablemanifestation_reserve_statsmanifestation_reserve_stats CREATE 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)D 111tableuser_reserve_statsuser_reserve_stats CREATE 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)
-
( p( F 33 2012-07-28 13:50:232012-07-28 13:50:23MyStringtext/csvF 33 2012-07-28 13:50:232012-07-28 13:50:23MyStringtext/csvF 33 2012-07-28 13:50:232012-07-28 13:50:23MyStringtext/csv
+
( p( F 33 2012-07-28 19:25:372012-07-28 19:25:37MyStringtext/csvF 33 2012-07-28 19:25:372012-07-28 19:25:37MyStringtext/csvF 33 2012-07-28 19:25:372012-07-28 19:25:37MyStringtext/csv
-
0f 332012-07-28 13:50:232012-07-28 13:50:230Ӳr 332012-07-28 13:50:232012-07-28 13:50:23
+
0f 332012-07-28 19:25:372012-07-28 19:25:370Ӳr 332012-07-28 19:25:372012-07-28 19:25:37
ʊf:l
ʊf:l
6 6 q
AA33 2008-12-12 17:00c
- 3333 2008-12-12 17:00:382008-12-13 17:00:38MyTextpending2012-07-28 13:50:242012-07-28 13:50:24c
- 3333 2008-12-12 17:00:382008-12-13 17:00:38MyTextpending2012-07-28 13:50:242012-07-28 13:50:24
+ 3333 2008-12-12 17:00:382008-12-13 17:00:38MyTextpending2012-07-28 19:25:372012-07-28 19:25:37c
+ 3333 2008-12-12 17:00:382008-12-13 17:00:38MyTextpending2012-07-28 19:25:372012-07-28 19:25:37
6 6 q
AA33 2008-12-15 18:43c
- 3333 2008-12-15 18:43:022008-12-16 18:43:02MyTextpending2012-07-28 13:50:242012-07-28 13:50:24c
- 3333 2008-12-15 18:43:022008-12-16 18:43:02MyTextpending2012-07-28 13:50:242012-07-28 13:50:24
q qy&X `
+ 3333 2008-12-15 18:43:022008-12-16 18:43:02MyTextpending2012-07-28 19:25:372012-07-28 19:25:37c
+ 3333 2008-12-15 18:43:022008-12-16 18:43:02MyTextpending2012-07-28 19:25:372012-07-28 19:25:37
q qy&X `
P/ _ CCCtablemanifestation_reserve_statsmanifestation_reserve_stats CREATE 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" datetimeTMMtablebookmark_stat_has_man0 99ytablereserve_stat_has_usersreserve_stat_has_users CREATE TABLE "reserve_stat_has_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_reserve_stat_id" integer NOT NULL, "user_id" integer 0 99ytablereserve_stat_has_usersreserve_stat_has_users CREATE 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)P!u9}indexindex_reserve_stat_has_users_on_user_reserve_stat_idreserve_stat_has_users CREATE INDEX "index_reserve_stat_has_users_on_user_reserve_stat_id" ON "reserve_stat_has_users" ("user_reserve_stat_id"))"[9Iindexindex_reserve_stat_has_users_on_user_idreserve_stat_has_users CREATE INDEX "index_reserve_stat_has_users_on_user_id" ON "reserve_stat_has_users" ("user_id")#Q35indexindex_user_checkout_stats_on_stateuser_checkout_stats CREATE INDEX "index_user_checkout_stats_on_state" ON "user_checkout_stats" ("state")$O11indexindex_user_reserve_stats_on_stateuser_reserve_stats CREATE INDEX "index_user_reserve_stats_on_state" ON "user_reserve_stats" ("state");%cEYindexindex_manifestation_checkout_stats_on_statemanifestation_checkout_stats CREATE INDEX "index_manifestation_checkout_stats_on_state" ON "manifestation_checkout_stats" ("state")7&aCUindexindex_manifestation_reserve_stats_on_statemanifestation_reserve_stats CREATE INDEX "index_manifestation_reserve_stats_on_state" ON "manifestation_reserve_stats" ("state")'%%Etableparticipatesparticipates CREATE 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_idparticipates CREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id"))K%)indexindex_participates_on_patron_idparticipates CREATE INDEX "index_participates_on_patron_id" ON "participates" ("patron_id")x*Etableextentsextents CREATE 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_performances CREATE 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_types CREATE 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_types CREATE 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_policies CREATE 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" decimal DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
0f 332012-07-28 13:50:232012-07-28 13:50:230Ӳr 332012-07-28 13:50:232012-07-28 13:50:23
+,''Qtablecontent_typescontent_types CREATE 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_types CREATE 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_policies CREATE 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" decimal DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
0f 332012-07-28 19:25:372012-07-28 19:25:370Ӳr 332012-07-28 19:25:372012-07-28 19:25:37
ʊf:l
- ʊf:l
0f 332012-07-28 13:50:242012-07-28 13:50:240Ӳr 332012-07-28 13:50:242012-07-28 13:50:24
+ ʊf:l
0f 332012-07-28 19:25:372012-07-28 19:25:370Ӳr 332012-07-28 19:25:372012-07-28 19:25:37
ʊf:l
ʊf:l
6 6 q
AA33 2008-12-17 04:07c
- 3333 2008-12-17 04:07:242008-12-18 04:07:24MyTextpending2012-07-28 13:50:242012-07-28 13:50:24c
- 3333 2008-12-17 04:07:242008-12-18 04:07:24MyTextpending2012-07-28 13:50:242012-07-28 13:50:24
6 6 q
+ 3333 2008-12-17 04:07:242008-12-18 04:07:24MyTextpending2012-07-28 19:25:372012-07-28 19:25:37c
+ 3333 2008-12-17 04:07:242008-12-18 04:07:24MyTextpending2012-07-28 19:25:372012-07-28 19:25:37
6 6 q
AA33 2008-12-20 11:36c
- 3333 2008-12-20 11:36:282008-12-21 11:36:28MyTextpending2012-07-28 13:50:242012-07-28 13:50:24c
- 3333 2008-12-20 11:36:282008-12-21 11:36:28MyTextpending2012-07-28 13:50:242012-07-28 13:50:24
0f 332012-07-28 13:50:242012-07-28 13:50:240Ӳr 332012-07-28 13:50:242012-07-28 13:50:24
+ 3333 2008-12-20 11:36:282008-12-21 11:36:28MyTextpending2012-07-28 19:25:372012-07-28 19:25:37c
+ 3333 2008-12-20 11:36:282008-12-21 11:36:28MyTextpending2012-07-28 19:25:372012-07-28 19:25:37
0f 332012-07-28 19:25:372012-07-28 19:25:370Ӳr 332012-07-28 19:25:372012-07-28 19:25:37
ʊf:l
ʊf:l
pending pending
pending pending
pending pending
pending pending
] 4
F
+ M/s-indexindex_lending_policies_on_item_id_and_user_group_idlending_policies CREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")=0))5tablemanifestationsmanifestations CREATE TAM/s-indexindex_lending_policies_on_item_id_and_user_group_idlending_policies CREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")
))5tablemanifestationsmanifestations CREATE TABLE "manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text NOT NULL, "title_alternative" text, "tH%%Ctabledelayed_jobsdelayed_jobs CREATE 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))M/s-indexindex_lending_policies_on_item_id_and_user_group_idlending_policies CREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")< Wtablelicenseslicenses CREATE 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)= [tableversionsversions CREATE 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)>[ Gindexindex_versions_on_item_type_and_item_idversions CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")KACCtablemanifestation_relationshipsmanifestation_relationships CREATE 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)CBiCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationships CREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")@CgCaindexindex_manifestation_relationships_on_child_idmanifestation_relationships CREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")SDtabletagstags CREATE 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)E mtabletaggingstaggings CREATE 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)nF=
indexindex_taggings_on_tag_idtaggings CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")VG indexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggings CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context") o%%tabledelayed_jobsdelayed_jobs CREATE 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)
-
{ { D 33MicrofilmMyTextMyText2012-07-28 13:50:232012-07-28 13:50:23= 33CDMyTextMyText2012-07-28 13:50:232012-07-28 13:50:23
b b K ##33AccompaniedAccompaniedMyText2012-07-28 13:50:242012-07-28 13:50:24O ''33UnaccompaniedUnaccompaniedMyText2012-07-28 13:50:242012-07-28 13:50:24
b Y 1133Cartographic ImageCartographic ImageMyText2012-07-28 13:50:232012-07-28 13:50:23] 5533Cartographic DatasetCartographic DatasetMyText2012-07-28 13:50:232012-07-28 13:50:23= 33texttextMyText2012-07-28 13:50:232012-07-28 13:50:23
G G 9 33ChildChild2012-07-28 13:50:242012-07-28 13:50:24; 33MemberMember2012-07-28 13:50:242012-07-28 13:50:24? 33See alsoSee also2012-07-28 13:50:242012-07-28 13:50:24
&5
xi 7U 33
-2012-07-28 13:50:242012-07-28 13:50:24>H 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24>U 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24>Ⱥi 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24> 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24>_ 33
+
{ { D 33MicrofilmMyTextMyText2012-07-28 19:25:372012-07-28 19:25:37= 33CDMyTextMyText2012-07-28 19:25:372012-07-28 19:25:37
b b K ##33AccompaniedAccompaniedMyText2012-07-28 19:25:372012-07-28 19:25:37O ''33UnaccompaniedUnaccompaniedMyText2012-07-28 19:25:372012-07-28 19:25:37
b Y 1133Cartographic ImageCartographic ImageMyText2012-07-28 19:25:372012-07-28 19:25:37] 5533Cartographic DatasetCartographic DatasetMyText2012-07-28 19:25:372012-07-28 19:25:37= 33texttextMyText2012-07-28 19:25:372012-07-28 19:25:37
G G 9 33ChildChild2012-07-28 19:25:372012-07-28 19:25:37; 33MemberMember2012-07-28 19:25:372012-07-28 19:25:37? 33See alsoSee also2012-07-28 19:25:372012-07-28 19:25:37
&5
xi 7U 33
+2012-07-28 19:25:372012-07-28 19:25:37>H 33
+MyText2012-07-28 19:25:372012-07-28 19:25:37>U 33
+MyText2012-07-28 19:25:372012-07-28 19:25:37>Ⱥi 33
+MyText2012-07-28 19:25:372012-07-28 19:25:37> 33
+MyText2012-07-28 19:25:372012-07-28 19:25:37>_ 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24>ڑL 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24>p 33
-MyText2012-07-28 13:50:242012-07-28 13:50:24
+MyText2012-07-28 19:25:372012-07-28 19:25:37>ڑL 33
+MyText2012-07-28 19:25:372012-07-28 19:25:37>p 33
+MyText2012-07-28 19:25:372012-07-28 19:25:37
ca
|H
7L
. i
@@ -751,49 +751,49 @@
h
H
(
h H ( hH(hH(hH(hH(hH(hH((hhHH( A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-16 02:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-01 07:14:18.000000 A2010-03-01 07:14:18.000000 A2010-03-01 07:14:18.000000 A2010-03-15 07:14:18.000000 A2010-03-15 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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.000000} A2010-03-01 07:14:18.000000| A2010-03-01 07:14:18.000000{ A2010-03-01 07:14:18.000000z A2010-03-01 07:14:18.000000y A2010-03-01 07:14:18.000000x A2010-03-01 07:14:18.000000w A2010-03-01 07:14:18.000000v A2010-03-01 07:14:18.000000u A2010-03-01 07:14:18.000000t A2010-03-01 07:14:18.000000s A2010-03-01 07:14:18.000000r A2010-03-01 07:14:18.000000q A2010-03-01 07:14:18.000000p A2010-03-01 07:14:18.000000o A2010-03-01 07:14:18.000000n A2010-03-01 07:14:18.000000m A2010-03-01 07:14:18.000000l A2010-03-01 07:14:18.000000k A2010-03-01 07:14:18.000000j A2010-03-01 07:14:18.000000i A2010-03-01 07:14:18.000000h A2010-03-01 07:14:18.000000g A2010-03-01 07:14:18.000000f A2010-03-01 07:14:18.000000e A2008-04-16 15:34:01.000000 A2007-11-19 07:59:21.799724 A2007-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.463333 A2007-11-19 07:59:06.892741 A2007-11-19 07:59:05.255684 A2007-11-19 07:59:04.333183 A2007-11-19 07:59:03.275738 A2007-11-19 07:59:02.618359 A2007-11-19 07:59:01.99 A2010-03-01 07:14:18.000000
8 33mitMITMIT2012-07-28 13:50:242012-07-28 13:50:24D 33unknownunknownunknown2012-07-28 13:50:242012-07-28 13:50:24
-
# m# HH + 33 テスト雑誌2012-07-28 13:50:242012-07-28 13:50:24tP 33 title22012-07-28 13:50:242012-07-28 13:50:24テスト09135707t? 33 title12012-07-28 13:50:242012-07-28 13:50:24f
Ex# I
+ A2007-11-19 07:59:08.166195 A2007-11-19 07:59:07.463333 A2007-11-19 07:59:06.892741 A2007-11-19 07:59:05.255684 A2007-11-19 07:59:04.333183 A2007-11-19 07:59:03.275738 A2007-11-19 07:59:02.618359 A2007-11-19 07:59:01.99 A2010-03-01 07:14:18.000000
8 33mitMITMIT2012-07-28 19:25:372012-07-28 19:25:37D 33unknownunknownunknown2012-07-28 19:25:372012-07-28 19:25:37
+
# m# HH + 33 テスト雑誌2012-07-28 19:25:372012-07-28 19:25:37tP 33 title22012-07-28 19:25:372012-07-28 19:25:37テスト09135707t? 33 title12012-07-28 19:25:372012-07-28 19:25:37f
Ex# I
*
z
O |I7%'indexdelayed_jobs_prioritydelayed_jobs CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")/J55tablepatron_relationshipspatron_relationships CREATE 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)'K[5Iindexindex_patron_relationships_on_parent_idpatron_relationships CREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("parent_id")$LY5Eindexindex_patron_relationships_on_child_idpatron_relationships CREATE INDEX "index_patron_relationships_on_child_id" ON "patron_relationships" ("child_id")CMMMwtablemanifestation_relationship_typesmanifestation_relationship_types CREATE TABLE "manifestation_relationship_types"|I7%'indexdelayed_jobs_prioritydelayed_jobs CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")/J55tablepatron_relationshipspatron_relationships CREATE 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)'K[5Iindexindex_patron_relationships_on_parent_idpatron_relationships CREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("parent_id")$LY5Eindexindex_patron_relationships_on_child_idpatron_relationships CREATE INDEX "index_patron_relationships_on_child_id" ON "patron_relationships" ("child_id")CMMMwtablemanifestation_relationship_typesmanifestation_relationship_types CREATE 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)3N;;{tableresource_import_resultsresource_import_results CREATE 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)]O};
indexindex_resource_import_results_on_resource_import_file_idresource_import_results CREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id")HPo;qindexindex_resource_import_results_on_manifestation_idresource_import_results CREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")-Q];Mindexindex_resource_import_results_on_item_idresource_import_results CREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")$R77etablepatron_import_resultspatron_import_results CREATE 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) S559tableevent_import_resultsevent_import_results CREATE 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) T))utablelibrary_groupslibrary_groupsECREATE 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/')
-
Y Y 3ӓ_ 33 2012-07-28 13:50:242012-07-28 13:50:241f 33 2012-07-28 13:50:242012-07-28 13:50:241Ӳr 33 2012-07-28 13:50:242012-07-28 13:50:24
+
Y Y 3ӓ_ 33 2012-07-28 19:25:372012-07-28 19:25:371f 33 2012-07-28 19:25:372012-07-28 19:25:371Ӳr 33 2012-07-28 19:25:372012-07-28 19:25:37
tʊf:l
tʊf:l
-
1f 33 2012-07-28 13:50:242012-07-28 13:50:241Ӳr 33 2012-07-28 13:50:242012-07-28 13:50:24
+
1f 33 2012-07-28 19:25:372012-07-28 19:25:371Ӳr 33 2012-07-28 19:25:372012-07-28 19:25:37
ʊf:l
- ʊf:l
7 33copycopy2012-07-28 13:50:242012-07-28 13:50:24A 33successorsuccessor2012-07-28 13:50:242012-07-28 13:50:24
7 33MyText2012-07-28 13:50:242012-07-28 13:50:247 33MyText2012-07-28 13:50:242012-07-28 13:50:24
+ ʊf:l
7 33copycopy2012-07-28 19:25:372012-07-28 19:25:37A 33successorsuccessor2012-07-28 19:25:372012-07-28 19:25:37
7 33MyText2012-07-28 19:25:372012-07-28 19:25:377 33MyText2012-07-28 19:25:372012-07-28 19:25:37
&
# V +
"O, J))Gtablemanifestationsmanifestations 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), "seriUQ)5indexindex_library_groups_on_short_namelibrary_groupsFCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")tVCindexindex_items_on_bookstore_iditems CREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")W Ytablereservesreserves1CREATE 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')pX? indexindex_reserves_on_user_idreserves2CREATE INDEX "index_reserves_on_user_id" ON "reserves" ("user_id") YQ 5indexindex_reserves_on_manifestation_idreserves3CREATE INDEX "index_reserves_on_manifestation_id" ON "reserves" ("manifestation_id")pZ? indexindex_reserves_on_item_idreserves4CREATE INDEX "index_reserves_on_item_id" ON "reserves" ("item_id") [] Mindexindex_reserves_on_request_status_type_idreserves5CREATE INDEX "index_reserves_on_request_status_type_id" ON "reserves" ("request_status_type_id")y\EEstableseries_statement_merge_listsseries_statement_merge_lists CREATE TABLE "series_statement_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/];;stableseries_statement_mergesseries_statement_merges CREATE TABLE "series_statement_merges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "series_statement_id" integer NOT NULL, "series_statement_merge_list_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Q^u;}indexindex_series_statement_merges_on_series_statement_idseries_statement_merges CREATE INDEX "index_series_statement_merges_on_series_statement_id" ON "series_statement_merges" ("series_statement_id")s_ ;)indexindex_series_statement_merges_on_series_statement_merge_list_idseries_statement_merges CREATE INDEX "index_series_statement_merges_on_series_statement_merge_list_id" ON "series_statement_merges" ("series_statement_merge_list_id"))`??_tableseries_has_manifestationsseries_has_manifestations CREATE TABLE "series_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "series_statement_id" integer, "manifestation_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Yay?indexindex_series_has_manifestations_on_series_statement_idseries_has_manifestations CREATE INDEX "index_series_has_manifestations_on_series_statement_id" ON "series_has_manifestations" ("series_statement_id")Pbs?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestations CREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")
-
7 33MyText2012-07-28 13:50:242012-07-28 13:50:247 33MyText2012-07-28 13:50:242012-07-28 13:50:24
+
7 33MyText2012-07-28 19:25:372012-07-28 19:25:377 33MyText2012-07-28 19:25:372012-07-28 19:25:37
| |
h i
Aj Q Otableusersusers CREATE 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_pas c))utablemanifestationsmanifestations CREATE TABLE "manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text NOT c))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) d[)Iindexindex_manifestations_on_carrier_type_idmanifestations CREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id")#e])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id")fE) indexindex_manifestations_on_isbnmanifestationsCREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")|gC)indexindex_manifestations_on_nbnmanifestationsCREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")hE) indexindex_manifestations_on_lccnmanifestationsCREATE INDEX "index_manifestations_on_lccn" ON "manifestations" ("lccn")iS)9indexindex_manifestations_on_oclc_numbermanifestationsCREATE INDEX "index_manifestations_on_oclc_number" ON "manifestations" ("oclc_number")jE) indexindex_manifestations_on_issnmanifestationsCREATE INDEX "index_manifestations_on_issn" ON "manifestations" ("issn") kY)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")lU)=indexindex_manifestations_on_frequency_idmanifestationsCREATE INDEX "index_manifestations_on_frequency_id" ON "manifestations" ("frequency_id");mm)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")
> > ? AA 2008-01-11 14:32:03.7014252008-01-11 14:32:03.701425? AA 2008-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
f X #I 33illustratoren: Illustrator
-ja: 作画者2012-07-28 13:50:232012-07-28 13:50:23S !A 33translatoren: Translator
-ja: 訳者2012-07-28 13:50:232012-07-28 13:50:23K 9 33editoren: Editor
-ja: 編者2012-07-28 13:50:232012-07-28 13:50:23K 9 33authoren: Author
-ja: 著者2012-07-28 13:50:232012-07-28 13:50:23
^ X #I 33illustratoren: Illustrator
-ja: 作画者2012-07-28 13:50:242012-07-28 13:50:24S !A 33translatoren: Translator
-ja: 訳者2012-07-28 13:50:242012-07-28 13:50:24K 9 33editoren: Editor
-ja: 編者2012-07-28 13:50:242012-07-28 13:50:24
Z Z N ? 33selleren: Seller
-ja: 販売者2012-07-28 13:50:242012-07-28 13:50:24T E 33publisheren: Publisher
-ja: 出版者2012-07-28 13:50:242012-07-28 13:50:24
L H '' 33AdministratorAdministrator2012-07-28 13:50:242012-07-28 13:50:24@ 33LibrarianLibrarian2012-07-28 13:50:242012-07-28 13:50:246 33UserUser2012-07-28 13:50:242012-07-28 13:50:248 33GuestGuest2012-07-28 13:50:242012-07-28 13:50:24
I
i
- 0y 4 ' AA1 admin_2user_number_22012-06-02 15:49:06.2801082012-06-02 15:49:06.280108admin_2@example.jp$2a$04$S/sKa7PPUXYZVjyUGKomFO6T59j7CY9KRBlUr5KPlXKBzyjMWpCCO f4 ' AA1 admin_1user_number_12012-06-02 15:48:59.9245952012-06-02 15:48:59.924595admin_1@example.jp$2a$04$mLnKhoZjAF0ZKaT4/Pi1HO6CCFZEOozCoIs1is3S.4jaWSqDV9ITS ?AAA
user4ja000072012-07-27 22:50:23 +09002007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 fy AAA
user3ja000062007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 f. AA= user2ja2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca f= ! AAG librarian2ja000042008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2@library.example.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS f] AAA ] user1ja000032007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW te3e0277cbba03183c3a12d2b740f3eabebd7df0dS ! AAK 5 librarian1ja000022007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS fAVRjefcBcey6f1WyYXDl^ AAC ] adminja000012007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi t577830b08ecf9c4c4333d599a57a6f44a7fe76c0
F^
+ja: 作画者2012-07-28 19:25:372012-07-28 19:25:37S !A 33translatoren: Translator
+ja: 訳者2012-07-28 19:25:372012-07-28 19:25:37K 9 33editoren: Editor
+ja: 編者2012-07-28 19:25:372012-07-28 19:25:37K 9 33authoren: Author
+ja: 著者2012-07-28 19:25:372012-07-28 19:25:37
^ X #I 33illustratoren: Illustrator
+ja: 作画者2012-07-28 19:25:372012-07-28 19:25:37S !A 33translatoren: Translator
+ja: 訳者2012-07-28 19:25:372012-07-28 19:25:37K 9 33editoren: Editor
+ja: 編者2012-07-28 19:25:372012-07-28 19:25:37
Z Z N ? 33selleren: Seller
+ja: 販売者2012-07-28 19:25:372012-07-28 19:25:37T E 33publisheren: Publisher
+ja: 出版者2012-07-28 19:25:372012-07-28 19:25:37
L H '' 33AdministratorAdministrator2012-07-28 19:25:372012-07-28 19:25:37@ 33LibrarianLibrarian2012-07-28 19:25:372012-07-28 19:25:376 33UserUser2012-07-28 19:25:372012-07-28 19:25:378 33GuestGuest2012-07-28 19:25:372012-07-28 19:25:37
I
i
+ 0y 4 ' AA1 admin_2user_number_22012-06-02 15:49:06.2801082012-06-02 15:49:06.280108admin_2@example.jp$2a$04$S/sKa7PPUXYZVjyUGKomFO6T59j7CY9KRBlUr5KPlXKBzyjMWpCCO f4 ' AA1 admin_1user_number_12012-06-02 15:48:59.9245952012-06-02 15:48:59.924595admin_1@example.jp$2a$04$mLnKhoZjAF0ZKaT4/Pi1HO6CCFZEOozCoIs1is3S.4jaWSqDV9ITS ?AAA
user4ja000072012-07-28 04:25:36 +09002007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 fy AAA
user3ja000062007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 f. AA= user2ja2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca f= ! AAG librarian2ja000042008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2@library.example.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS f] AAA ] user1ja000032007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW te3e0277cbba03183c3a12d2b740f3eabebd7df0dS ! AAK 5 librarian1ja000022007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS fAVRjefcBcey6f1WyYXDl^ AAC ] adminja000012007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi t577830b08ecf9c4c4333d599a57a6f44a7fe76c0
F^
%
o//Utableseries_statementsseries_statements CREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text, "numbering" text, "title_subseries" text, "numbering_subseries" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "issn" varchar(255), "periodical" boolean, "root_manifestation_id" integer, "note" text, "title_subseries_transcription" text)5pc/cindexindex_series_statements_on_manifestation_idseries_statements CREATE nQ)5indexindex_manifestations_on_updated_atmanifestations CREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at")o//Utableseries_statementsseries_statements CREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text, "numbering" text, "title_subseries" text, "numbering_subseries" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "issn" varchar(255), "periodical" boolean, "root_manifestation_id" integer, "note" text, "title_subseries_transcription" text)5pc/cindexindex_series_statements_on_manifestation_idseries_statements CREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("root_manifestation_id")Qqy/indexindex_series_statements_on_series_statement_identifierseries_statements CREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")~r%%=tablecreate_typescreate_types CREATE 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)s''?tablerealize_typesrealize_types CREATE 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)t''?tableproduce_typesproduce_types CREATE 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)iu/tablerolesroles CREATE 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)<vUtableusersusers CREATE 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)^w5}indexindex_users_on_emailusers CREATE INDEX "index_users_on_email" ON "users" ("email")xSGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")_y))wtableuser_has_rolesuser_has_roles CREATE 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)
{^? ? 1admin_2@example.jp 1admin_1@example.jp Auser4@kamata.lib.teu.ac.jp Auser3@kamata.lib.teu.ac.jp =user2@library.example.jp!Glibrarian2@library.example.jp Auser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jp Ctanabe@kamata.lib.teu.ac.jp
-
f3U <_ AA 2012-06-02 15:49:06.2820562012-06-02 15:49:06.282056<^ AA2012-06-02 15:48:59.9276822012-06-02 15:48:59.927682.] 332012-07-28 13:50:242012-07-28 13:50:24.z 332012-07-28 13:50:242012-07-28 13:50:24.o 332012-07-28 13:50:242012-07-28 13:50:24.U 332012-07-28 13:50:242012-07-28 13:50:24.ƊW 332012-07-28 13:50:242012-07-28 13:50:24.q 332012-07-28 13:50:242012-07-28 13:50:24.x 332012-07-28 13:50:242012-07-28 13:50:24
- y ~y ,]e3e0277cbba03183c3a12d2b740f3eabebd7df0d5AVRjefcBcey6f1WyYXDl,]577830b08ecf9c4c4333d599a57a6f44a7fe76c0
x x ? 33DonationDonation2012-07-28 13:50:232012-07-28 13:50:23E ## 33Public fundPublic fund2012-07-28 13:50:232012-07-28 13:50:23
+
f3U <_ AA 2012-06-02 15:49:06.2820562012-06-02 15:49:06.282056<^ AA2012-06-02 15:48:59.9276822012-06-02 15:48:59.927682.] 332012-07-28 19:25:372012-07-28 19:25:37.z 332012-07-28 19:25:372012-07-28 19:25:37.o 332012-07-28 19:25:372012-07-28 19:25:37.U 332012-07-28 19:25:372012-07-28 19:25:37.ƊW 332012-07-28 19:25:372012-07-28 19:25:37.q 332012-07-28 19:25:372012-07-28 19:25:37.x 332012-07-28 19:25:372012-07-28 19:25:37
+ y ~y ,]e3e0277cbba03183c3a12d2b740f3eabebd7df0d5AVRjefcBcey6f1WyYXDl,]577830b08ecf9c4c4333d599a57a6f44a7fe76c0
x x ? 33DonationDonation2012-07-28 19:25:372012-07-28 19:25:37E ## 33Public fundPublic fund2012-07-28 19:25:372012-07-28 19:25:37
i i l
V Q`
^x c ++atableimport_requestsimport_requ(
_+Qindexindex_import_requests_on_manifestation_idimport_requests CREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")m~=
indexindex_accepts_on_item_idaccepts CREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")v77 tableresource_import_filesresource_import_files CREATE TABLE "resource_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "filename" varchar(255), "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)+ ]7Mindexindex_resource_import_files_on_parent_idresource_import_files CREATE INDEX "index_resource_impo z[Windexindex_users_on_checkout_icalendar_tokenusers CREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")~{%%=tablebudget_typesbudget_types CREATE 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)d| tableacceptsaccepts CREATE TABLE "accepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s}Aindexindex_accepts_on_basket_idaccepts CREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")m~=
indexindex_accepts_on_item_idaccepts CREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")v77 tableresource_import_filesresource_import_files CREATE TABLE "resource_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "filename" varchar(255), "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)+ ]7Mindexindex_resource_import_files_on_parent_idresource_import_files CREATE INDEX "index_resource_import_files_on_parent_id" ON "resource_import_files" ("parent_id")%Y7Eindexindex_resource_import_files_on_user_idresource_import_files CREATE INDEX "index_resource_import_files_on_user_id" ON "resource_import_files" ("user_id") U7=indexindex_resource_import_files_on_stateresource_import_files CREATE INDEX "index_resource_import_files_on_state" ON "resource_import_files" ("state")e33qtablepatron_import_filespatron_import_files}CREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "filename" varchar(255), "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))"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_filesCREATE INDEX "index_patron_import_files_on_user_id" ON "patron_import_files" ("user_id")
_ ]e 6Tz0Tv:z'Cs 2Nl L x
.
@@ -1097,10 +1097,10 @@
@ ` @ `
@
`
@` @``@ hH(hH(hH(hH(hH((hhHH( A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-16 02:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-01 07:14:18.000000 A2010-03-01 07:14:18.000000 A2010-03-01 07:14:18.000000 A2010-03-15 07:14:18.000000 A2010-03-15 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.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.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.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.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.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.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.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.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.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.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. A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.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.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.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.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.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.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.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.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.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.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.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.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.000000 A2010-03-01 07:14:18.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-03 11:00:00.000000 A2010-03-15 07:14:18.000000 A2010-03-15 07:14:18.000000 A2010-03-16 02:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000 A2010-03-19 04:00:00.000000
)
#
D 8fUr ` @ `
@
`
@` @``@ ^A G AA BA ;A International Symposium Genes and Chromosomes Structure and Function2009-06-19 12:02:48 UTC2010-03-01 07:14:18.00000089f f[A G ;A Massachusetts acid rain monitoring project / Massachusetts acid rain monitoring project A.R.M2009-06-19 12:03:29 UTC2010-03-01 07:14:18.00000088f f%@ M ;A ! Indians of the Pacific Northwest2009-06-19 12:16:23 UTC2010-03-01 07:14:18.0000000000000129f f @ % ;A ! Genomic Perl2009-06-19 13:27:46 UTC2010-03-01 07:14:18.0000000000000128f f"@ W ;A CGI programming on the World Wide Web2009-06-19 13:45:14 UTC2010-03-01 07:14:18.00000087f f
~@ ' ;A Ruby Cookbook2009-06-29 12:44:11 UTC2010-03-01 07:14:18.00000086f f-}@ m ;A Ruby on Rails入門 : 優しいRailsの育て方2009-10-16 05:16:48 UTC2010-03-01 07:14:18.00000085f fQ|A 3 ;A まちづくり三鷹図書館（Ruby図書館情報システム デモサイト）2009-10-20 13:46:44 UTC2010-03-01 07:14:18.00000084f f/{@ q ;A Rubyでgroonga使って全文検索 - ラングバ2009-10-25 13:20:34 UTC2010-03-01 07:14:18.00000083f fz@ 1 ;A みんなのPython2010-01-30 06:17:32 UTC2010-03-01 07:14:18.00000082f f y@ ) ;A Django×Python2010-01-30 06:22:35 UTC2010-03-01 07:14:18.00000081f f1x@ K ;A ' ! Rubyプログラミング入門2010-02-16 04:29:59 UTC2010-03-01 07:14:18.0000009784274063855f f2000-10-01w@ - ;A ! Perl基礎講座2010-02-16 04:30:37 UTC2010-03-01 07:14:18.0000000000000119f f=v@ } ;A ! ナチ強制・絶滅収容所 : 18施設内の生と死2010-02-17 01:12:08 UTC2010-03-01 07:14:18.0000000000000118f f
-u@ ' ;A Perlの達人2010-02-18 10:23:27 UTC2010-03-01 07:14:18.00000079f fEt@ s ;A ' ! sed ＆ awkプログラミング : UNIX power tools2010-02-19 05:39:01 UTC2010-03-01 07:14:18.0000009784756100917f f1991-12-24s@ ! ;A 入門Perl2010-02-19 05:40:17 UTC2010-03-01 07:14:18.00000077f f<r@ a ;A ' ! Rubyを256倍使うための本. 魔道編2010-02-19 05:46:08 UTC2010-03-01 07:14:18.0000009784756137470f f2001-03-20[qA G ;A プログラミングは難しくない！ : ウェブではじめるJavaScript／Perl／Java2010-02-19 11:02:27 UTC2010-03-01 07:14:18.00000075f fSpA 7 ;A CGIのための実践入門Perl : 対話的・動きのあるWebページを作ろう2010-02-19 13:06:51 UTC2010-03-01 07:14:18.00000074f fo@ 3 ;A すぐわかるPerl2010-02-19 13:07:28 UTC2010-03-01 07:14:18.00000073f fTnA 9 ;A Ruby／GTKプログラミング入門 : Rubyで作って遊ぶGUIプログラミング2010-02-19 13:09:56 UTC2010-03-01 07:14:18.00000072f f
j j Ef )33978-4774141640pending2012-07-28 13:50:232012-07-28 13:50:23EӲr )33978-4774142043pending2012-07-28 13:50:232012-07-28 13:50:23
+u@ ' ;A Perlの達人2010-02-18 10:23:27 UTC2010-03-01 07:14:18.00000079f fEt@ s ;A ' ! sed ＆ awkプログラミング : UNIX power tools2010-02-19 05:39:01 UTC2010-03-01 07:14:18.0000009784756100917f f1991-12-24s@ ! ;A 入門Perl2010-02-19 05:40:17 UTC2010-03-01 07:14:18.00000077f f<r@ a ;A ' ! Rubyを256倍使うための本. 魔道編2010-02-19 05:46:08 UTC2010-03-01 07:14:18.0000009784756137470f f2001-03-20[qA G ;A プログラミングは難しくない！ : ウェブではじめるJavaScript／Perl／Java2010-02-19 11:02:27 UTC2010-03-01 07:14:18.00000075f fSpA 7 ;A CGIのための実践入門Perl : 対話的・動きのあるWebページを作ろう2010-02-19 13:06:51 UTC2010-03-01 07:14:18.00000074f fo@ 3 ;A すぐわかるPerl2010-02-19 13:07:28 UTC2010-03-01 07:14:18.00000073f fTnA 9 ;A Ruby／GTKプログラミング入門 : Rubyで作って遊ぶGUIプログラミング2010-02-19 13:09:56 UTC2010-03-01 07:14:18.00000072f f
j j Ef )33978-4774141640pending2012-07-28 19:25:372012-07-28 19:25:37EӲr )33978-4774142043pending2012-07-28 19:25:372012-07-28 19:25:37
)978-4774141640ʊf)978-4774142043:l
ʊf:l
ʊf:l
f J
!;o Q5indexindex_patrons_on_patron_identifierpatronsCREATE INDEX "index_patrons_on_patron_identifier" ON "patrons" ("patron_identifier")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_files CREATE 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_files CREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id") S19indexindex_event_import_files_on_user_idevent_import_files CREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id")
O11indexindex_event_import_files_on_stateevent_import_files CREATE INDEX "index_event_import_files_on_state" ON "event_import_files" ("state") ++atableimport_requestsimport_requests CREATE 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) G+!indexindex_import_requests_on_isbnimport_requests CREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")(
_+Qindexindex_import_requests_on_manifestation_idimport_requests CREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")
M+-indexindex_import_requests_on_user_idimport_requests CREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")
\ No newline at end of file