spec/dummy/db/test.sqlite3 in enju_event-0.1.10 vs spec/dummy/db/test.sqlite3 in enju_event-0.1.11
- old
+ new
@@ -1,14 +1,45 @@
-SQLite format 3 @ # 9 K # - %Ziku_ r
; indexindex_libraries_on_namelibrariesCREATE 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") E +indexindex_libraries_on_patron_idlibraries CREATE UNIQUE INDEX "index_libraries_on_patron_id" ON "libraries" ("patron_id")s
- 5tablelibrarieslibraries CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer, "patron_type" varchar(255), "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)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)_tablepatronspatronsCREATE 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, "creates_count" integer DEFAULT 0 NOT NULL, "realizes_count" integer DEFAULT 0 NOT NULL, "produces_count" integer DEFAULT 0 NOT NULL, "owns_count" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "state" varchar(255), "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) (
a o]K9'sa )20120415060342)20120413170734)20120413051535)20120105074911)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752
)20100222124420 )20100211105551 )20090519203307
-)20081028093607 )20081025083905)20081025083323)200809051914421141138069591
- F vcP=*lYF )20120415060342)20120413170734)20120413051535)20120105074911)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752)20100222124420
)20100211105551 )20090519203307 )20081028093607
-)20081025083905 )20081025083323)200809051914421141138069591
iB
* n
-
-F vJ1 AA
Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396 {I1 % AA
オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396 ~h1 + AA
試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396 ~g1 + AA
作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396 f1 1 AA
出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396 ,e1 + + 7 AA
! テスト名字テスト名前テスト正式名称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01 1 AA
! User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01
-1 % % AA
! New patron 5New patron 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 4New patron 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 3New patron 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 2New patron 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 1New patron 12007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 AA
! User2User22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 ! ! AA ! Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-01 1 ' AA ! KosukeTanabeKosuke Tanabe2007-12-04 07:25:01.5236182007-12-04 07:25:01.5236182000-01-01 1 ! ! AA
! Librarian1Librarian12007-11-19 08:06:07.7245172007-11-21 13:02:10.3597932000-01-01 1 ' ' AA
! AdministratorAdministrator2007-11-19 08:06:06.5072372007-11-21 13:01:56.1374092000-01-01
zfQ?1& users)user_has_roles<;q#user_groups
shelves roles patrons
+SQLite format 3 @ e # e -
+ # ])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_migrationsschema_migrationsCREATE TABLE " d Z a Oq 9Z B )0 !
+
_
+ n\J8&r`N<*
v
d
R
@
.
+ z h V D 2 ~ l Z H 6 $
+
+
+
+
+
+
+
+p
+^
+L
+:
+(
+
+ _)20091202124834^)20120602141129])20120418081407\)20120415164821[)20120415060342Z)20120415060323Y)20120415060308X)20120413170734W)20120413170720V)20120413170705U)20120413161403T)20120413161340S)20120413100352R)20120413072700Q)20120413051535P)20120410104851O)20120319120638N)20120129020544M)20120125152919L)20120105074911K)20111201163718J)20111201163342I)20111201155513H)20111201155456G)20111201121844F)20111124112131E)20111124110355D)20111124110319C)20111124110059B)20111020063828A)20111009183423@)20110918162329?)20110918161853>)20110916103953=)20110916091020<)20110916053430;)20110820131417:)201106270350579)201106270349408)201106201735257)201106190648076)201106180912405)201104251331094)201103011215503)201103010351232)201102220735371)201101150223290)20101212070145/)20100925074639.)20100925074559-)20100925043847,)20100814091104+)20100607044753*)20100606073747))20100527113752()20100525124311')20100321235924&)20100223121519%)20100222124420$)20100211105551#)20100129142347")20091214131723!)20091025080447 )20091012101112 )20090812151902 )20090720091429 )20090720091106 )20090719201843)20090705212043)20090705133942)20090519203307)20081028093607)20081028083208)20081028083142)20081027150907)20081025083905)20081025083323)20080905191442)20080830172106)20080830154109125117
114 113 112
+80 736959471512651
+ _ o\I6#xeR? ,
n
[
H
5
"
w d Q > + m Z G 4 !
+
+
+
+
+
+
+
+v
+c
+P
+=
+*
+
+ )20091202124834_)20120602141129^)20120418081407])20120415164821\)20120415060342[)20120415060323Z)20120415060308Y)20120413170734X)20120413170720W)20120413170705V)20120413161403U)20120413161340T)20120413100352S)20120413072700R)20120413051535Q)20120410104851P)20120319120638O)20120129020544N)20120125152919M)20120105074911L)20111201163718K)20111201163342J)20111201155513I)20111201155456H)20111201121844G)20111124112131F)20111124110355E)20111124110319D)20111124110059C)20111020063828B)20111009183423A)20110918162329@)20110918161853?)20110916103953>)20110916091020=)20110916053430<)20110820131417;)20110627035057:)201106270349409)201106201735258)201106190648077)201106180912406)201104251331095)201103011215504)201103010351233)201102220735372)201101150223291)201012120701450)20100925074639/)20100925074559.)20100925043847-)20100814091104,)20100607044753+)20100606073747*)20100527113752))20100525124311()20100321235924')20100223121519&)20100222124420%)20100211105551$)20100129142347#)20091214131723")20091025080447!)20091012101112 )20090812151902 )20090720091429 )20090720091106 )20090719201843 )20090705212043)20090705133942)20090519203307)20081028093607)20081028083208)20081028083142)20081027150907)20081025083905)20081025083323)20080905191442)20080830172106)20080830154109125117114
113 112 80
+73 6959471512651
nQ
D &
+y NUa qJ0 AA
Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396 vI0 % AA
オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396 yh0 + AA
試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396 yg0 + AA
作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396 |f0 1 AA
出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396 'e0 + + 7 AA
! テスト名字テスト名前テスト正式名称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01 0 AA
! User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01
+0 % % AA
! New patron 5New patron 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0 % % AA
! New patron 4New patron 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0 % % AA
! New patron 3New patron 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0 % % AA
! New patron 2New patron 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0 % % AA
! New patron 1New patron 12007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0 AA
! User2User22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0 ! ! AA ! Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-01 0 ' AA ! KosukeTanabeKosuke Tanabe2007-12-04 07:25:01.5236182007-12-04 07:25:01.5236182000-01-01 0 ! ! AA
! Librarian1Librarian12007-11-19 08:06:07.7245172007-11-21 13:02:10.3597932000-01-01 0 ' ' AA
! AdministratorAdministrator2007-11-19 08:06:06.5072372007-11-21 13:01:56.1374092000-01-01
zfQ?1& users)user_has_roles<;q#user_groups
shelves roles patrons
%patron_types %participates:l)library_groups
libraries languages
events5event_import_results:l1event_import_files-event_categories countries
h g f e
hgfe
@@ -16,32 +47,59 @@
hgfe
hgfe
p_U;$ Ruby社 %オーム社 +試験用会社h+作者ダミーg1出版社テストf7テスト正式名称e User3 %New patron 5
-%New patron 4 %New patron 3%New patron 2%New patron 1 User2!Librarian2'Kosuke Tanabe!Librarian1'Administrator
^
| %
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-0000000g ) AA webWorld Wide WebWeb| 2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349
+%New patron 4 %New patron 3%New patron 2%New patron 1 User2!Librarian2'Kosuke Tanabe!Librarian1'Administrator
+
+
+
Y Y Rcb h ))Atablemanifestationsmanifestations CREATE TABLE "manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text NOT NULL, "title_alternative" text, "title_transcription" text, "classification_number" varchar{tablepatronspatronsCREATE 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, "full_name_alternative_transcription" text, "birth_date" varchar(255), "death_date" varchar(255))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) _tablepatronspatronsCREATE 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, "full_name_alternative_transcription" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
+
K s s
+
v u
`
= # ])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_rol# ])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_man [)Iindexindex_manifestations_on_carrier_type_idmanifestations CREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id") ])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") E) indexindex_manifestations_on_isbnmanifestationsCREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn") ~C)indexindex_manifestations_on_nbnmanifestationsCREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn") E) indexindex_manifestaGmtableitemsitemsCREATE TABLE "items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "call_number" varchar(255), "item_identifier" varchar(255), "circulation_status_id" integer DEFAULT 5 NOT NULL, "checkout_type_id" integer DEFAULT 1 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "shelf_id" integer DEFAULT 1 NOT NULL, "include_supplements" boolean DEFAULT 'f' NOT NULL, "note" text, "url" varchar(255), "price" integer, "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, "acquired_at" datetime, "bookstore_id" integer, "budget_type_id" integer) mtablecreatescreates"CREATE TABLE "creates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "work_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "create_type_id" integer)*9tableitemsitemsCREATE TABLE "items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "call_number" varchar(255), "item_identifier" varchar(255), "circulation_status_id" integer DEFAULT 5 NOT NULL, "checkout_type_id" integer DEFAULT 1 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "shelf_id" integer DEFAULT 1 NOT NULL, "include_supplements" boolean DEFAULT 'f' NOT NULL, "note" text, "url" varchar(255), "price" integer, "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, "acquired_at" datetime, "bookstore_id" integer)U=indexindex_items_on_circulation_status_iditemsCREATE INDEX "index_items_on_circulation_status_id" ON "items" ("circulation_status_id")K)indexindex_items_on_checkout_type_iditemsCREATE INDEX "index_items_on_checkout_type_id" ON "items" ("checkout_type_id")g; indexindex_items_on_shelf_iditems CREATE INDEX "index_items_on_shelf_id" ON "items" ("shelf_id")|I%indexindex_items_on_item_identifieritems CREATE INDEX "index_items_on_item_identifier" ON "items" ("item_identifier")K)indexindex_items_on_required_role_iditems CREATE INDEX "index_items_on_required_role_id" ON "items" ("required_role_id")h 3tableownsowns CREATE TABLE "owns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "item_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)f ; indexindex_owns_on_patron_idowns CREATE INDEX "index_owns_on_patron_id" ON "owns" ("patron_id")` 7indexindex_owns_on_item_idowns!CREATE INDEX "index_owns_on_item_id" ON "owns" ("item_id") 9tablecreatescreates"CREATE TABLE "creates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "work_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)r Aindexindex_creates_on_patron_idcreates#CREATE INDEX "index_creates_on_patron_id" ON "creates" ("patron_id")l!=
indexindex_creates_on_work_idcreates$CREATE INDEX "index_creates_on_work_id" ON "creates" ("work_id")
+
+
+
+
+
p pn l
+
!+^n 7 }tablerealizesrealizes<CREATE 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)zFE indexindex_languages_on_iso_639_2languagesKCREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")zEE indexindex_languages_on_iso_639_1languagesJCREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")rD; indexindex_languages_on_namelanguagesICREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")'C tablelan1O1indexindex_events_on_event_category_idevents5CREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")2--Wtableevent_categoriesevent_categories6CREATE 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) 3''Qtableform_of_worksform_of_works7CREATE 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)]4tabledonatesdonates8CREATE 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)r5Aindexindex_donates_on_patron_iddonates:CREATE INDEX "index_donates_on_patron_id" ON "donates" ("patron_id")l6=
indexindex_donates_on_item_iddonates;CREATE INDEX "index_donates_on_item_id" ON "donates" ("item_id")7 }tablerealizesrealizes<CREATE 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)v8C indexindex_realizes_on_patron_idrealizes=CREATE INDEX "index_realizes_on_patron_id" ON "realizes" ("patron_id")9K )indexindex_realizes_on_expression_idrealizes>CREATE INDEX "index_realizes_on_expression_id" ON "realizes" ("expression_id"):##Otableexemplifiesexemplifies?CREATE 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);W#Aindexindex_exemplifies_on_manifestation_idexemplifies@CREATE INDEX "index_exemplifies_on_manifestation_id" ON "exemplifies" ("manifestation_id")<E#+indexindex_exemplifies_on_item_idexemplifiesACREATE UNIQUE INDEX "index_exemplifies_on_item_id" ON "exemplifies" ("item_id")=%%Otablepatron_typespatron_typesBCREATE TABLE "patron_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)> ]tablecountriescountriesCCREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "alpha_2" varchar(255), "alpha_3" varchar(255), "numeric_3" varchar(255), "note" text, "position" integer)k?; indexindex_countries_on_namecountriesDCREATE INDEX "index_countries_on_name" ON "countries" ("name")t@A indexindex_countries_on_alpha_2countriesECREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")tAA indexindex_countries_on_alpha_3countriesFCREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")zBE indexindex_countries_on_numeric_3countriesGCREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")
+
+
+
+
+
+
+
+
+
+
+
+
^
| %
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-0000000g ) AA webWorld Wide WebWeb| 2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349
P m
P
[ U
+
+z nh[ % _tablelibrarieslibraries(CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer, "patron_type" varchar(255), "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))q0Aindexindex_events_on_library_idevents4CREATE INDEX "index_events_on_library_id" ON "events" ("library_id")/ tableeventsevents3CREATE 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).##Mtablefrequenciesfrequencies2CREATE 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) +''Qtablecarrier_typescarrier_types/CREATE TABLE "carrier_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u*Cindexindex_shelves_on_library_idshelves.CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")a)tableshelvesshelves-CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)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")&E +indexindex_libraries_on_patron_idlibraries*CREATE UNIQUE INDEX "index_libraries_on_patron_id" ON "libraries" ("patron_id") $Q 5indexindex_produces_on_manifestation_idproduces'CREATE INDEX "index_produces_on_manifestation_id" ON "produces" ("manifestation_id")v#C indexindex_produces_on_patron_idproduces&CREATE INDEX "index_produces_on_patron_id" ON "produces" ("patron_id")" tableproducesproduces%CREATE 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)
mita hachioji
-kamataweb
k J ## 33 third_shelfThird shelf 2012-06-02 16:42:562012-06-02 16:42:56L %% 33 second_shelfSecond shelf 2012-06-02 16:42:562012-06-02 16:42:56J ## 33 first_shelfFirst shelf 2012-06-02 16:42:562012-06-02 16:42:56G - 33 webLibrary bookmark 2012-06-02 16:42:562012-06-02 16:42:56
r r oQ
-
( q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")_tablepatronspatronsCREATE 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, "creates_count" integer DEFAULT 0 NOT NULL, "realizes_count" integer DEFAULT 0 NOT NULL, "produces_count" integer DEFAULT 0 NOT NULL, "owns_count" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "state" varchar(255), "email" text, "url" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)s=indexindex_patrons_on_user_idpatronsCREATE UNIQUE INDEX "index_patrons_on_user_id" ON "patrons" ("user_id")xE indexindex_patrons_on_language_idpatronsCREATE INDEX "index_patrons_on_language_id" ON "patrons" ("language_id")uCindexindex_patrons_on_country_idpatronsCREATE INDEX "index_patrons_on_country_id" ON "patrons" ("country_id")O1indexindex_patrons_on_required_role_idpatrons CREATE INDEX "index_patrons_on_required_role_id" ON "patrons" ("required_role_id")r Aindexindex_patrons_on_full_namepatrons
-CREATE INDEX "index_patrons_on_full_name" ON "patrons" ("full_name")
- _tablelibrarieslibraries CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer, "patron_type" varchar(255), "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)) E +indexindex_libraries_on_patron_idlibraries CREATE UNIQUE INDEX "index_libraries_on_patron_id" ON "libraries" ("patron_id") S 9indexindex_libraries_on_library_group_idlibraries
CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")r
; indexindex_libraries_on_namelibrariesCREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")atableshelvesshelvesCREATE 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)
-
d duq| n
-
- G113tableevent_import_filesevent_import_files$CREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" inteuCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") tableeventseventsCREATE 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)qAindexindex_events_on_library_ideventsCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")O1indexindex_events_on_event_category_ideventsCREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")--Wtableevent_categoriesevent_categoriesCREATE 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)%%Otablepatron_typespatron_typesCREATE TABLE "patron_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) ]tablecountriescountriesCREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "alpha_2" varchar(255), "alpha_3" varchar(255), "numeric_3" varchar(255), "note" text, "position" integer)k; indexindex_countries_on_namecountriesCREATE INDEX "index_countries_on_name" ON "countries" ("name")tA indexindex_countries_on_alpha_2countries CREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")tA indexindex_countries_on_alpha_3countries CREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")zE indexindex_countries_on_numeric_3countries CREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")' tablelanguageslanguages CREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "native_name" varchar(255), "display_name" text, "iso_639_1" varchar(255), "iso_639_2" varchar(255), "iso_639_3" varchar(255), "note" text, "position" integer)r ; indexindex_languages_on_namelanguages CREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")z E indexindex_languages_on_iso_639_1languages!CREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")z E indexindex_languages_on_iso_639_2languages"CREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")z E indexindex_languages_on_iso_639_3languages#CREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3")%%%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")j(%%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)
t t ? 33 9unknownunknownunknownnext-l@library.example.jp0.0.0.0/0mf2012-06-02 16:42:562012-06-02 16:42:56fhttp://localhost:3000/
- unknown
$ 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
+kamataweb
k J ## 33 third_shelfThird shelf 2012-06-19 01:59:012012-06-19 01:59:01L %% 33 second_shelfSecond shelf 2012-06-19 01:59:012012-06-19 01:59:01J ## 33 first_shelfFirst shelf 2012-06-19 01:59:012012-06-19 01:59:01G - 33 webLibrary bookmark 2012-06-19 01:59:012012-06-19 01:59:01
+
t t ? 33 9unknownunknownunknownnext-l@library.example.jp0.0.0.0/0mf2012-06-19 01:59:012012-06-19 01:59:01fhttp://localhost:3000/
+ 0 unknown
$ 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
3 x3 C !! 33ConferenceConference2012-06-02 16:42:562012-06-02 16:42:56I '' 33CorporateBodyCorporateBody2012-06-02 16:42:562012-06-02 16:42:56; 33PersonPerson2012-06-02 16:42:562012-06-02 16:42:56 7s Q-g [;
{ A A9
Y ;
+
^ ^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
V
DG113tableevent_import_filesevent_import_filesXCREATE 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)TS19indexindex_event_import_files_on_user_idevent_import_filesZCREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id") SW1Aindexindex_event_import_files_on_parent_idevent_import_filesYCREATE INDE'C tablelanguageslanguagesHCREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "native_name" varchar(255), "display_name" text, "iso_639_1" varchar(255), "iso_639_2" varchar(255), "iso_639_3" varchar(255), "note" text, "position" integer)rD; indexindex_languages_on_namelanguagesICREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")zEE indexindex_languages_on_iso_639_1languagesJCREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")zFE indexindex_languages_on_iso_639_2languagesKCREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")zGE indexindex_languages_on_iso_639_3languagesLCREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3")H''etablepicture_filespicture_filesMCREATE TABLE "picture_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "picture_attachable_id" integer, "picture_attachable_type" varchar(255), "content_type" varchar(255), "title" text, "thumbnail" varchar(255), "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "picture_file_name" varchar(255), "picture_content_type" varchar(255), "picture_file_size" integer, "picture_updated_at" datetime, "picture_meta" text, "picture_fingerprint" varchar(255))[Iw'%indexindex_picture_files_on_picture_attachable_id_and_typepicture_filesNCREATE INDEX "index_picture_files_on_picture_attachable_id_and_type" ON "picture_files" ("picture_attachable_id", "picture_attachable_type") W1Aindexindex_event_import_files_on_parent_idevent_import_filesYCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id") S19indexindex_event_import_files_on_user_idevent_import_filesZCREATE 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")V%%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)WI%%indexindex_participates_on_event_idparticipates]CREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id")XK%)indexindex_participates_on_patron_idparticipates^CREATE INDEX "index_participates_on_patron_id" ON "participates" ("patron_id")wYEtableextentsextents_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)$Z99ctablemedium_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)
+
+
+
+
+
+
3 x3 C !! 33ConferenceConference2012-06-19 01:59:012012-06-19 01:59:01I '' 33CorporateBodyCorporateBody2012-06-19 01:59:012012-06-19 01:59:01; 33PersonPerson2012-06-19 01:59:012012-06-19 01:59:01 s Q-g [;
{ A A9
Y ;
S
c -c] ic{
1 K7U
c
s
%u +Q
: EcuadorEcuadorECECU218: ? SudanSudanSDSDN736 '
- !! MozambiqueMozambiqueMZMOZ508 $S GuatemalaGuatemalaGTGTM320S69 11 Dominican RepublicDominican RepublicDODOM2149%[ VenezuelaVenezuelaVEVEN862 #$ PortugalPortugalPTPRT620 ! MoroccoMoroccoMAMAR504 R GuamGuamGUGUM316R"8 DominicaDominicaDMDMA2128!Z VanuatuVanuatuVUVUT548 %> Sri LankaSri LankaLKLKA144 # PolandPolandPLPOL616 &Q !! GuadeloupeGuadeloupeGPGLP312Q"7 DjiboutiDjiboutiDJDJI2627 BrazilBrazilBRBRA062 'Y !! UzbekistanUzbekistanUZUZB860 #" PitcairnPitcairnPNPCN612 ' !! MontserratMontserratMSMSR500 &m !! KyrgyzstanKyrgyzstanKGKGZ417m 6 DenmarkDenmarkDKDNK2086" BotswanaBotswanaBWBWA058 !X UruguayUruguayUYURY858 )! ## PhilippinesPhilippinesPHPHL608 # MongoliaMongoliaMNMNG496 P GrenadaGrenadaGDGRD308P.5 )) Czech RepublicCzech RepublicCZCZE2035> 99 Bosnia and HerzegovinaBosnia and HerzegovinaBABIH056-W '' United StatesUnited StatesUSUSA840 PeruPeruPEPER604 MonacoMonacoMCMCO492 l KuwaitKuwaitKWKWT414l 4 CyprusCyprusCYCYP1964 BoliviaBoliviaBOBOL068/V )) United KingdomUnited KingdomGBGBR826 ; 55 Moldova, Republic ofMoldova, Republic ofMDMDA498 6k 11 Korea, Republic ofKorea, Republic ofKRKOR410k3 CubaCubaCUCUB1923 BhutanBhutanBTBTN052;U 55 United Arab EmiratesUnited Arab EmiratesAEARE784 Q KK Micronesia, Federated States ofMicronesia, Federated States ofFMFSM583 `j [[ Korea, Democratic People\'s Republic ofKorea, Democratic People\'s Republic ofKPPRK408j BermudaBermudaBMBMU048!T UkraineUkraineUAUKR804 MexicoMexicoMXMEX484 "i KiribatiKiribatiKIKIR296i 2 CroatiaCroatiaHRHRV1912 BeninBeninBJBEN204 S UgandaUgandaUGUGA800 % MauritiusMauritiusMUMUS480 h KenyaKenyaKEKEN404h R TuvaluTuvaluTVTUV798 &g !! KazakhstanKazakhstanKZKAZ398g BelizeBelizeBZBLZ084 f JordanJordanJOJOR400f BelgiumBelgiumBEBEL046 e JapanJapanJPJPN392e BelarusBelarusBYBLR112 d JamaicaJamaicaJMJAM388d c ItalyItalyITITA380c+3 %% Saudi ArabiaSaudi ArabiaSASAU682 b IsraelIsraelILISR376b=2 77 Sao Tome and PrincipeSao Tome and PrincipeSTSTP678 a IrelandIrelandIEIRL372a'1 !! San MarinoSan MarinoSMSMR674 ` IraqIraqIQIRQ368` 0 SamoaSamoaWSWSM882 D_ ?? Iran, Islamic Republic ofIran, Islamic Republic ofIRIRN364_ E FranceFranceFRFRA250ES/ MM Saint Vincent and the GrenadinesSaint Vincent and the GrenadinesVCVCT670 ! NigeriaNigeriaNGNGA566 $^ IndonesiaIndonesiaIDIDN360^ D FinlandFinlandFIFIN246DE. ?? Saint Pierre and MiquelonSaint Pierre and MiquelonPMSPM666 NigerNigerNENER562 ] IndiaIndiaININD356]C FijiFijiFJFJI242C)- ## Saint LuciaSaint LuciaLCLCA662 % NicaraguaNicaraguaNINIC558 \ IcelandIcelandISISL352\,B '' Faroe IslandsFaroe IslandsFOFRO234B#c ZimbabweZimbabweZWZWE716 =, 77 Saint Kitts and NevisSaint Kitts and NevisKNKNA659 ) ## New ZealandNew ZealandNZNZL554 HA CC Falkland Islands (Malvinas)Falkland Islands (Malvinas)FKFLK238AB' == Central African RepublicCentral African RepublicCFCAF140' b ZambiaZambiaZMZMB894 - '' New CaledoniaNew CaledoniaNCNCL540 w MacaoMacaoMOMAC446w [ HungaryHungaryHUHUN348["@ EthiopiaEthiopiaETETH231@.& )) Cayman IslandsCayman IslandsKYCYM136&++ %% Saint HelenaSaint HelenaSHSHN654 ! unknownunknow 61 5_
+ !! MozambiqueMozambiqueMZMOZ508 $S GuatemalaGuatemalaGTGTM320S69 11 Dominican RepublicDominican RepublicDODOM2149%[ VenezuelaVenezuelaVEVEN862 #$ PortugalPortugalPTPRT620 ! MoroccoMoroccoMAMAR504 R GuamGuamGUGUM316R"8 DominicaDominicaDMDMA2128!Z VanuatuVanuatuVUVUT548 %> Sri LankaSri LankaLKLKA144 # PolandPolandPLPOL616 &Q !! GuadeloupeGuadeloupeGPGLP312Q"7 DjiboutiDjiboutiDJDJI2627 BrazilBrazilBRBRA062 'Y !! UzbekistanUzbekistanUZUZB860 #" PitcairnPitcairnPNPCN612 ' !! MontserratMontserratMSMSR500 &m !! KyrgyzstanKyrgyzstanKGKGZ417m 6 DenmarkDenmarkDKDNK2086" BotswanaBotswanaBWBWA058 !X UruguayUruguayUYURY858 )! ## PhilippinesPhilippinesPHPHL608 # MongoliaMongoliaMNMNG496 P GrenadaGrenadaGDGRD308P.5 )) Czech RepublicCzech RepublicCZCZE2035> 99 Bosnia and HerzegovinaBosnia and HerzegovinaBABIH056-W '' United StatesUnited StatesUSUSA840 PeruPeruPEPER604 MonacoMonacoMCMCO492 l KuwaitKuwaitKWKWT414l 4 CyprusCyprusCYCYP1964 BoliviaBoliviaBOBOL068/V )) United KingdomUnited KingdomGBGBR826 ; 55 Moldova, Republic ofMoldova, Republic ofMDMDA498 6k 11 Korea, Republic ofKorea, Republic ofKRKOR410k3 CubaCubaCUCUB1923 BhutanBhutanBTBTN052;U 55 United Arab EmiratesUnited Arab EmiratesAEARE784 Q KK Micronesia, Federated States ofMicronesia, Federated States ofFMFSM583 `j [[ Korea, Democratic People\'s Republic ofKorea, Democratic People\'s Republic ofKPPRK408j BermudaBermudaBMBMU048!T UkraineUkraineUAUKR804 MexicoMexicoMXMEX484 "i KiribatiKiribatiKIKIR296i 2 CroatiaCroatiaHRHRV1912 BeninBeninBJBEN204 S UgandaUgandaUGUGA800 % MauritiusMauritiusMUMUS480 h KenyaKenyaKEKEN404h R TuvaluTuvaluTVTUV798 &g !! KazakhstanKazakhstanKZKAZ398g BelizeBelizeBZBLZ084 f JordanJordanJOJOR400f BelgiumBelgiumBEBEL046 e JapanJapanJPJPN392e BelarusBelarusBYBLR112 d JamaicaJamaicaJMJAM388d c ItalyItalyITITA380c+3 %% Saudi ArabiaSaudi ArabiaSASAU682 b IsraelIsraelILISR376b=2 77 Sao Tome and PrincipeSao Tome and PrincipeSTSTP678 a IrelandIrelandIEIRL372a'1 !! San MarinoSan MarinoSMSMR674 ` IraqIraqIQIRQ368` 0 SamoaSamoaWSWSM882 D_ ?? Iran, Islamic Republic ofIran, Islamic Republic ofIRIRN364_ E FranceFranceFRFRA250ES/ MM Saint Vincent and the GrenadinesSaint Vincent and the GrenadinesVCVCT670 ! NigeriaNigeriaNGNGA566 $^ IndonesiaIndonesiaIDIDN360^ D FinlandFinlandFIFIN246DE. ?? Saint Pierre and MiquelonSaint Pierre and MiquelonPMSPM666 NigerNigerNENER562 ] IndiaIndiaININD356]C FijiFijiFJFJI242C)- ## Saint LuciaSaint LuciaLCLCA662 % NicaraguaNicaraguaNINIC558 \ IcelandIcelandISISL352\,B '' Faroe IslandsFaroe IslandsFOFRO234B#c ZimbabweZimbabweZWZWE716 =, 77 Saint Kitts and NevisSaint Kitts and NevisKNKNA659 ) ## New ZealandNew ZealandNZNZL554 HA CC Falkland Islands (Malvinas)Falkland Islands (Malvinas)FKFLK238AB' == Central African RepublicCentral African RepublicCFCAF140' b ZambiaZambiaZMZMB894 - '' New CaledoniaNew CaledoniaNCNCL540 w MacaoMacaoMOMAC446w [ HungaryHungaryHUHUN348["@ EthiopiaEthiopiaETETH231@.& )) Cayman IslandsCayman IslandsKYCYM136&++ %% Saint HelenaSaint HelenaSHSHN654 ! unknownunknow 1 _
X$z?f
o
% q e Bm-p6ZF
h Y
v
A
]!PCH;g>
@@ -188,11 +246,11 @@
@
& w
v \ K B 0 i1 7
}S
n
646 530 233?132%344Z442v887 732 528 440u232>124$876 524 438t226=120#028 850 520 434s222<116"660092 516 430r108!020704 426q854 016422p100 014428o096 010418n008004724 710 706 090 304O705 600 300N703 598 292M702 591 288L694 585 276K3841690 586 478 268J1880796 686 512 474 270I184/795 578 584266H180.792 580 470~258G178-042788 574 466}254F174,040780 570 462|170+048776 458{156*036772 454z152)025768 450y148(032764 807x030
834 533 041 026
-762 158 760 756 340Y752 643 336X748 642 332W744 638 328V634 624U818;740 630 104 324T218:736 508 320S2149862 620 504 316R2128548 144 616 312Q2627062 860 612 500 417m2086058 858 608 496 308P2035056840 604 492 414l1964068826 498 410k1923052784 583 408j048804 484 296i1912204800 480 404h798 398g084400f046392e112388d380c682 376b678 372a674 368`882 364_250E670 566 360^246D666 562 356]242C662 558 352\234B716 659 554 238A140'894 540 446w348[231@136&654 000 9 #
+762 158 760 756 340Y752 643 336X748 642 332W744 638 328V634 624U818;740 630 104 324T218:736 508 320S2149862 620 504 316R2128548 144 616 312Q2627062 860 612 500 417m2086058 858 608 496 308P2035056840 604 492 414l1964068826 498 410k1923052784 583 408j048804 484 296i1912204800 480 404h798 398g084400f046392e112388d380c682 376b678 372a674 368`882 364_250E670 566 360^246D666 562 356]242C662 558 352\234B716 659 554 238A140'894 540 446w348[231@136&654 000 #
eq1
$ J y
( ZI>=
l %H
BL*c{
f 0jh a>b
V
@@ -304,11 +362,11 @@
NauruNaurunanaunauq#:
GuaraníGuaranígngrngrn:2
+ + Scottish GaelicScottish Gaelicgdglagla )V
# # KinyarwandaKinyarwandarwkinkinV<
7 unknownen:unknown
-ja:不明unknownunknownunk 8b
+ja:不明unknownunknownunk b
)
c
T
y
] u h6o5
n
m $
@@ -448,22 +506,57 @@
(
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
X Q 33 pendingMyStringtext/csv2012-06-02 16:42:562012-06-02 16:42:56Q 33 pendingMyStringtext/csv2012-06-02 16:42:562012-06-02 16:42:56S 33 completedMyStringtext/csv2012-06-02 16:42:562012-06-02 16:42:56
BPdO
- F
$
|C51 z1##;tableuser_groupsuser_groups3CREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT N6O11indexindex_event_import_files_on_stateevent_import_files(CREATE INDEX "index_event_import_files_on_state" ON "event_import_files" ("state")5S19indexindex_event_import_files_on_user_idevent_import_files'CREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id") 4W1Aindexindex_event_import_files_on_parent_idevent_import_files&CREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id"){)7%'indexdelayed_jobs_prioritydelayed_jobs-CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at") *559tableevent_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)}+))5tablelibrary_groupslibrary_groupsCREATE 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, "login_banner" text, "note" text, "valid_period_for_new_user" integer DEFAULT 365 NOT NULL, "post_to_union_catalog" boolean DEFAULT 'f' NOT NULL, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "admin_networks" text, "allow_bookmark_external_url" boolean DEFAULT 'f' NOT NULL, "position" integer, "url" varchar(255) DEFAULT 'http://localhost:3000/'),Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")h-/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). tableusersusers0CREATE 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), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255))]/5}indexindex_users_on_emailusers1CREATE INDEX "index_users_on_email" ON "users" ("email")0SGindexindex_users_on_reset_password_tokenusers2CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")z1##;tableuser_groupsuser_groups3CREATE TABLE "user_groups" ("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)^2))wtableuser_has_rolesuser_has_roles4CREATE 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)D3113tableevent_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)
-
-
- & $ pending pending
completed
0f 332012-06-02 16:42:562012-06-02 16:42:560Ӳr 332012-06-02 16:42:562012-06-02 16:42:56
+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
+
+
z$X L//etableseries_statementsseries_statementsfCREATE 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, "manifestation_id" integer)JqCCtablemanifestation_relationshipsmanifestation_relationshipslCREATE TABLE "manifestation_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "manifestation_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer) y/indexindex_series_statements_on_series_statement_identifierseries_statementskCREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier") nM+-indexindex_import_requests_on_user_idimport_requestsjCREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")'m_+Qindexindex_import_requests_on_manifestation_idimport_requestsiCREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")lG+!indexindex_import_requests_on_isbnimport_requestshCREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")k++atableimport_requestsimport_requestsgCREATE 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)i WtablelicenseslicenseseCREATE TABLE "licenses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" varchar(255), [''Qtablecontent_typescontent_typesbCREATE 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_typescCREATE 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)i WtablelicenseslicenseseCREATE 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)k++atableimport_requestsimport_requestsgCREATE 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)lG+!indexindex_import_requests_on_isbnimport_requestshCREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")'m_+Qindexindex_import_requests_on_manifestation_idimport_requestsiCREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id") nM+-indexindex_import_requests_on_user_idimport_requestsjCREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")JqCCtablemanifestation_relationshipsmanifestation_relationshipslCREATE 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)
+
+
+ R Q P
+
+
+ V U T
X Q 33 pendingMyStringtext/csv2012-06-19 01:59:012012-06-19 01:59:01Q 33 pendingMyStringtext/csv2012-06-19 01:59:012012-06-19 01:59:01S 33 completedMyStringtext/csv2012-06-19 01:59:012012-06-19 01:59:01
+
+
+% ))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) [)Iindexindex_manifestations_on_carrier_type_idmanifestations CREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id")Ps?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestations CREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")Yy?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"))??_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)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")Pu;}indexindex_series_statement_merges_on_series_statement_idseries_statement_mergesCREATE INDEX "index_series_statement_merges_on_series_statement_id" ON "series_statement_merges" ("series_statement_id").;;stableseries_statement_mergesseries_statement_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)
+ Y X
0f 332012-06-19 01:59:012012-06-19 01:59:010Ӳr 332012-06-19 01:59:012012-06-19 01:59:01
ʊf:l
- ʊf:l
-
5f 33MyText2012-06-02 16:42:562012-06-02 16:42:565Ӳr 33MyText2012-06-02 16:42:562012-06-02 16:42:56
L H '' 33AdministratorAdministrator2012-06-02 16:42:562012-06-02 16:42:56@ 33LibrarianLibrarian2012-06-02 16:42:562012-06-02 16:42:566 33UserUser2012-06-02 16:42:562012-06-02 16:42:568 33GuestGuest2012-06-02 16:42:562012-06-02 16:42:56
- U
b
- k AAA
user42007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 k AAA
user32007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417
AA
user22008-01-18 04:29:06.9227282008-05-31 03:42:44.711117$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca ! AA
librarian22008-01-18 03:24:04.2223442008-05-31 03:42:23.340575$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS ' AAA user12007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW 1 ! AAK librarian12007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS ( AAC admin2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi
+ ʊf:l
\ 9
+
+ Z
4?sgCaindexindex_manifecS)?sgCaindexBriCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationshipsmCREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")?sgCaindexindex_manifestation_relationships_on_child_idmanifestation_relationshipsnCREATE INDEX "index_mBriCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationshipsmCREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")?sgCaindexindex_manifestation_relationships_on_child_idmanifestation_relationshipsnCREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")jt%%tabledelayed_jobsdelayed_jobsoCREATE 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){u7%'indexdelayed_jobs_prioritydelayed_jobspCREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at").v55tablepatron_relationshipspatron_relationshipsqCREATE 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)&w[5Iindexindex_patron_relationships_on_parent_idpatron_relationshipsrCREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("parent_id")#xY5Eindexindex_patron_relationships_on_child_idpatron_relationshipstCREATE INDEX "index_patron_relationships_on_child_id" ON "patron_relationships" ("child_id")ByMMwtablemanifestation_relationship_typesmanifestation_relationship_typesuCREATE 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)2z;;{tableresource_import_resultsresource_import_resultsvCREATE 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)\{};
indexindex_resource_import_results_on_resource_import_file_idresource_import_resultswCREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id")G|o;qindexindex_resource_import_results_on_manifestation_idresource_import_resultsxCREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id"),}];Mindexindex_resource_import_results_on_item_idresource_import_resultsyCREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")#~77etablepatron_import_resultspatron_import_resultszCREATE 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) 559tableevent_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)s Cindexindex_items_on_bookstore_iditems|CREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")xEEstableseries_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)
p p2UD
+[ i .;;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)Pu;}indexindex_series_statement_merges_on_series_statement_idseries_stat#
+])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") E) indexindex_manifestations_on_isbnmanifestationsCREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")| C)indexindex_manifestations_on_nbnmanifestationsCREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")
E) indexindex_manifestations_on_lccnmanifestationsCREATE INDEX "index_manifestations_on_lccn" ON "manifestations" ("lccn")S)9indexindex_manifestations_on_oclc_numbermanifestationsCREATE INDEX "index_manifestations_on_oclc_number" ON "manifestations" ("oclc_number")E) indexindex_manifestations_on_issnmanifestationsCREATE INDEX "index_manifestations_on_issn" ON "manifestations" ("issn") Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")U)=indexindex_manifestations_on_frequency_idmanifestationsCREATE INDEX "index_manifestations_on_frequency_id" ON "manifestations" ("frequency_id");m)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")Q)5indexindex_manifestations_on_updated_atmanifestationssCREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at")//Utableseries_statementsseries_statementsfCREATE 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)5c/cindexindex_series_statements_on_manifestation_idseries_statements CREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("root_manifestation_id")Py/indexindex_series_statements_on_series_statement_identifierseries_statementskCREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")}))5tablelibrary_groupslibrary_groups0CREATE 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, "login_banner" text, "note" text, "valid_period_for_new_user" integer DEFAULT 365 NOT NULL, "post_to_union_catalog" boolean DEFAULT 'f' NOT NULL, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "admin_networks" text, "allow_bookmark_external_url" boolean DEFAULT 'f' NOT NULL, "position" integer, "url" varchar(255) DEFAULT 'http://localhost:3000/')Q)5indexindex_library_groups_on_short_namelibrary_groups1CREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")~%%=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)
+
+
+
+ f
+
+
+
+
+
ndexindex_U)=indexindex_manifestations_on_frequency_idmanifestationsCREATE INDEX "index_manifestations_on_frequency_id" ON "manifestations" ("frequency_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)Yy?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")Ps?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestations CREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")A))=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, "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_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, "frQ)5indexindex_manifestations_on_updated_atmanifestations CREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at") K[)Iindexindex_manifestations_on_carrier_type_idmanifestations CREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id") ])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") E) indexindex_manifestations_on_isbnmanifestationsCREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")| C)indexindex_manifestations_on_nbnmanifestationsCREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")
E) indexindex_manifestations_on_lccnmanifestationsCREATE INDEX "index_manifestations_on_lccn" ON "manifestations" ("lccn")S)9indexindex_manifestations_on_oclc_numbermanifestationsCREATE INDEX "index_manifestations_on_oclc_number" ON "manifestations" ("oclc_number")E) indexindex_manifestations_on_issnmanifestationsCREATE INDEX "index_manifestations_on_issn" ON "manifestations" ("issn") Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")U)=indexindex_manifestations_on_frequency_idmanifestationsCREATE INDEX "index_manifestations_on_frequency_id" ON "manifestations" ("frequency_id");m)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")
+
+
+
+
5f 33MyText2012-06-19 01:59:012012-06-19 01:59:015Ӳr 33MyText2012-06-19 01:59:012012-06-19 01:59:01
+
+
+
+
5 5:?,
+ A
Q
+ _
Etableusersusers 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), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypte| C)indexindex_manifestations_on_nbnmanifestationsCREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")
E) indexindex_manifestations_on_lccnmanifestationsCREATE INDEX "index_manifestations_on_lccn" ON "manifestations" ("lccn")S)9indexindex_manifestations_on_oclc_numbermanifestationsCREATE INDEX "index_manifestations_on_oclc_number" ON "manifestations" ("oclc_number")E) indexindex_manifestations_on_issnmanifestationsCREATE INDEX "index_manifestations_on_issn" ON "manifestations" ("issn") Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestatio''?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)''?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)i /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)0 =tableusersusers 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), "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), "password_salt" varchar(255), "confirmation_token" varchar(255), "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar(255), "failed_attempts" integer DEFAULT 0, "unlock_token" varchar(255), "locked_at" datetime, "authentication_token" varchar(255))^ 5}indexindex_users_on_emailusers CREATE INDEX "index_users_on_email" ON "users" ("email") SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token"){ ##;tableuser_groupsuser_groups CREATE TABLE "user_groups" ("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)_!))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)B"77#tableresource_import_filesresource_import_filesTCREATE TABLE "resource_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "resource_import_file_name" varchar(255), "resource_import_content_type" varchar(255), "resource_import_file_size" integer, "resource_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "resource_import_fingerprint" varchar(255), "error_message" text)
+
+
L H '' 33AdministratorAdministrator2012-06-19 01:59:012012-06-19 01:59:01@ 33LibrarianLibrarian2012-06-19 01:59:012012-06-19 01:59:016 33UserUser2012-06-19 01:59:012012-06-19 01:59:018 33GuestGuest2012-06-19 01:59:012012-06-19 01:59:01
+ K
:
+ u AAA
user42007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 u AAA
user32007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c417 AA
user22008-01-18 04:29:06.9227282008-05-31 03:42:44.711117$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca ! AA
librarian22008-01-18 03:24:04.2223442008-05-31 03:42:23.340575$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS 1 AAA user12007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW ; ! AAK librarian12007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS 2 AAC admin2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi
X ~
l
+
+1 1 - )Q35indexindex_patron_import_files_on_statepatron_import_filesSCREATE INDEX "index_patron_import_files_on_state" ON "patron_import_files" ("state") (U3=indexindex_patron_import_files_on_user_idpatron_import_filesRCREATE INDEX "index_patron_import_files_on_user_id" ON "patron_import_files" ("user_id")"'Y3Eindexindex_patron_import_files_on_parent_idpatron_import_filesQCREATE INDEX "index_patron_import_files_on_parent_id" ON "patron_import_files" ("parent_id")i /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)0 =tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "required_rL&33?tablepatron_import_filespatron_import_filesPCREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "state" varchar(255), "patron_import_file_name" varchar(255), "patron_import_content_type" varchar(255), "patron_import_file_size" integer, "patron_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "patron_import_fingerprint" varchar(255), "error_message" text, "edit_mode" varchar(255))-O11indexindex_event_import_files_on_stateevent_import_files CREATE INDEX "index_event_import_files_on_state" ON "event_import_files" ("state"),S19indexindex_event_import_files_on_user_idevent_import_files[CREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id") +W1Aindexindex_event_import_files_on_parent_idevent_import_filesYCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id")*#]7Mindexindex_resource_import_files_on_parent_idresource_import_filesUCREATE INDEX "index_resource_import_files_on_parent_id" ON "resource_import_files" ("parent_id")$$Y7Eindexindex_resource_import_files_on_user_idresource_import_filesVCREATE INDEX "index_resource_import_files_on_user_id" ON "resource_import_files" ("user_id") %U7=indexindex_resource_import_files_on_stateresource_import_filesWCREATE INDEX "index_resource_import_files_on_state" ON "resource_import_files" ("state") 33 tablepatron_import_filespatron_import_filesPCREATE TABLE "patron_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pa/[ Gindexindex_versions_on_item_type_and_item_idversions CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id"). [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)"'Y3Eindexindex_patron_import_files_on_parent_idpatron_import_filesQCREATE INDEX "index_patron_import_files_on_parent_id" ON "patron_import_files" ("parent_id") (U3=indexindex_patron_import_files_on_user_idpatron_import_filesRCREATE INDEX "index_patron_import_files_on_user_id" ON "patron_import_files" ("user_id"))Q35indexindex_patron_import_files_on_statepatron_import_filesSCREATE INDEX "index_patron_import_files_on_state" ON "patron_import_files" ("state")D*113tableevent_import_filesevent_import_filesXCREATE 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)
U tU Auser4@kamata.lib.teu.ac.jp Auser3@kamata.lib.teu.ac.jp
Auser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jp Ctanabe@kamata.lib.teu.ac.jp
-
\ K
AAFacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351E
AAUserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548[ ++
AA(not specified)(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542
f3 .] 332012-06-02 16:42:562012-06-02 16:42:56.z 332012-06-02 16:42:562012-06-02 16:42:56.o 332012-06-02 16:42:562012-06-02 16:42:56.U 332012-06-02 16:42:562012-06-02 16:42:56.ƊW 332012-06-02 16:42:562012-06-02 16:42:56.q 332012-06-02 16:42:562012-06-02 16:42:56.x 332012-06-02 16:42:562012-06-02 16:42:56
_ ]e 6Tz0Tv:z'Cs 2Nl L x
+
\ K
AAFacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351E
AAUserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548[ ++
AA(not specified)(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542
f3 .] 332012-06-19 01:59:012012-06-19 01:59:01.z 332012-06-19 01:59:012012-06-19 01:59:01.o 332012-06-19 01:59:012012-06-19 01:59:01.U 332012-06-19 01:59:012012-06-19 01:59:01.ƊW 332012-06-19 01:59:012012-06-19 01:59:01.q 332012-06-19 01:59:012012-06-19 01:59:01.x 332012-06-19 01:59:012012-06-19 01:59:01
+ pending pending
completed
_ ]e 6Tz0Tv:z'Cs 2Nl L x
.
^
@@ -726,6 +819,7 @@
WalloonWalloonwawlnwln 5
WelshWelshcywelcym 26
+ + Western FrisianWestern Frisianfyfryfry 7
WolofWolofwowolwol 8
XhosaXhosaxhxhoxho "9
- YiddishYiddishyiyidyid
+ YiddishYiddishyiyidyid
+
\ No newline at end of file