spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre32 vs spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre33
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ -$ |C)indexindex_manifestations_on_nbnmanifestations
CREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")E)indexindex_manifestations_on_isbnmanifestationsCREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")&
+SQLite format 3 @ -$ |C)indexindex_manifestations_on_nbnmanifestations
CREATE INDEX "index_manifestations_on_nbn" ON "manifestations" ("nbn")E)indexindex_manifestations_on_isbnmanifestationsCREATE INDEX "index_manifestations_on_isbn" ON "manifestations" ("isbn")&
))tablemanifestationsmanifestationsCREATE TABLE "manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text NOT NULL, "title_alternative" text, "title_transcription" text, "classification_number" varchar(255), "manifestation_identifier" varchar(255), "date_of_publication" datetime, "copyright_date" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "access_address" varchar(255), "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "extent_id" integer DEFAULT 1 NOT NULL, "start_page" integer, "end_page" integer, "height" integer, "width" integer, "depth" integer, "isbn" varchar(255), "isbn10" varchar(255), "wrong_isbn" varchar(255), "nbn" varchar(255), "lccn" varchar(255), "oclc_number" varchar(255), "issn" varchar(255), "price" integer, "fulltext" text, "volume_number_list" varchar(255), "issue_number_list" varchar(255), "serial_number_list" varchar(255), "edition" integer, "note" text, "repository_content" boolean DEFAULT 'f' NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "state" varchar(255), "required_score" integer DEFAULT 0 NOT NULL, "frequency_id" integer DEFAULT 1 NOT NULL, "subscription_master" boolean DEFAULT 'f' NOT NULL)r Aindexindex_patrons_on_full_namepatrons
CREATE INDEX "index_patrons_on_full_name" ON "patrons" ("full_name")O1indexindex_patrons_on_required_role_idpatrons CREATE INDEX "index_patrons_on_required_role_id" ON "patrons" ("required_role_id")uCindexindex_patrons_on_country_idpatronsCREATE INDEX "index_patrons_on_country_id" ON "patrons" ("country_id")xEindexindex_patrons_on_language_idpatronsCREATE INDEX "index_patrons_on_language_id" ON "patrons" ("language_id")s=indexindex_patrons_on_user_idpatronsCREATE UNIQUE INDEX "index_patrons_on_user_id" ON "patrons" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)07tablepatronspatronsCREATE TABLE "patrons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "last_name" varchar(255), "middle_name" varchar(255), "first_name" varchar(255), "last_name_transcription" varchar(255), "middle_name_transcription" varchar(255), "first_name_transcription" varchar(255), "corporate_name" varchar(255), "corporate_name_transcription" varchar(255), "full_name" varchar(255), "full_name_transcription" text, "full_name_alternative" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "zip_code_1" varchar(255), "zip_code_2" varchar(255), "address_1" text, "address_2" text, "address_1_note" text, "address_2_note" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number_1" varchar(255), "fax_number_2" varchar(255), "other_designation" text, "place" text, "postal_code" varchar(255), "street" text, "locality" text, "region" text, "date_of_birth" datetime, "date_of_death" datetime, "language_id" integer DEFAULT 1 NOT NULL, "country_id" integer DEFAULT 1 NOT NULL, "patron_type_id" integer DEFAULT 1 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "note" text, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "state" varchar(255), "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migra v yj _ Q D , $ vw af NT =D )4 !
xqjc\UNG@.
zhVD2
~
l
Z
H
6
$
p^L:(tbP>,
@@ -95,16 +95,21 @@
sOj //tableseries_statementsseries_statements CREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text, "numbering" text, "title_subseries" text, "numbering_subseries" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "issn" varchar(255), "periodical" boolean DEFAULT 'f' NOT NULL, "manifestation_id" integer)VDindexindex_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")nC=
indexindex_taggings_on_tag_idtaggings CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")Bmtabletaggingstaggings 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)SAtabletagstags 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)@@gCaindexindex_manifestation_relationships_on_child_idmanifestation_relationships CREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")C?iCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationships CREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")K>CCtablemanifestation_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) y/indexindex_series_statements_on_series_statement_identifierseries_statements CREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")
;M+-indexindex_import_requests_on_user_idimport_requests CREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")(:_+Qindexindex_import_requests_on_manifestation_idimport_requests CREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")9G+!indexindex_import_requests_on_isbnimport_requests CREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")8++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)6[Gindexindex_versions_on_item_type_and_item_idversions CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")5[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)4Wtablelicenseslicenses 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)
A AEx# I
*
4
F
4Wtablelicenseslicenses 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)5[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,E%%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))|F7%'indexdelayed_jobs_prioritydelayed_jobs CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")/G55tablepatron_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)'H[5Iindexindex_patron_relationships_on_parent_idpatron_relationships CREATE INDEX "index_patron_relationships_on_parent_id" ON "patron_relationships" ("parent_id")$IY5Eindexindex_patron_relationships_on_child_idpatron_relationships CREATE INDEX "index_patron_relationships_on_child_id" ON "patron_relationships" ("child_id")CJMMwtablemanifestation_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)3K;;{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)]L};
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")HMo;qindexindex_resource_import_results_on_manifestation_idresource_import_results CREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")-N];Mindexindex_resource_import_results_on_item_idresource_import_results CREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")$O77etablepatron_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)P559tableevent_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)Q))utablelibrary_groupslibrary_groups@CREATE 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/')
&
#V+
"O,
|F7%'indexdelayed_jobs_prioritydelayed_jobs CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")/G55tablepatron_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, "updat4T;tablereservesreserves,CREATE TABLE "reserves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "canceled_at" datetime, "expired_at" datetime, "deleted_at" datetime, "state" varchar(255), "expiration_notice_to_patron" boolean DEFAULT 'f', "expiration_notice_to_library" boolean DEFAULT 'f', "retained_at" datetime, "postponed_at" datetime)RQ)5indexindex_library_groups_on_short_namelibrary_groupsACREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")tSCindexindex_items_on_bookstore_iditems CREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id") Ytablereservesreserves,CREATE TABLE "reserves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "canceled_at" datetime, "expired_at" datetime, "deleted_at" datetime, "state" varchar(255), "expiration_notice_to_patron" boolean DEFAULT 'f', "expiration_notice_to_library" boolean DEFAULT 'f')pU?indexindex_reserves_on_user_idreserves-CREATE INDEX "index_reserves_on_user_id" ON "reserves" ("user_id")VQ5indexindex_reserves_on_manifestation_idreserves.CREATE INDEX "index_reserves_on_manifestation_id" ON "reserves" ("manifestation_id")pW?indexindex_reserves_on_item_idreserves/CREATE INDEX "index_reserves_on_item_id" ON "reserves" ("item_id")X]Mindexindex_reserves_on_request_status_type_idreserves0CREATE INDEX "index_reserves_on_request_status_type_id" ON "reserves" ("request_status_type_id")yYEEstableseries_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)/Z;;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)Y^y?indexindex_series_has_manifestations_on_series_statement_idseries_has_manifestations CREATE INDEX "index_series_has_manifestations_on_series_statement_id" ON "series_has_manifestations" ("series_statement_id")P_s?yindexindex_series_has_manifestations_on_manifestation_idseries_has_manifestations CREATE INDEX "index_series_has_manifestations_on_manifestation_id" ON "series_has_manifestations" ("manifestation_id")
4 4 6;:+ T
%
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")b MM5tablecheckout_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)G)!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")
\
-f
p
y'1
-
-
-; E Q AA 000232007-08-24 14:46:20.4848132007-08-24 14:46:20.484813fP AA 000222007-08-24 14:46:20.4848132007-08-24 14:46:20.484813fP AA 000212007-08-24 14:46:20.4848132007-08-24 14:46:20.484813fP AA 000202007-08-24 14:46:19.4848132007-08-24 14:46:19.484813fP AA 000192007-08-24 14:46:18.4848132007-08-24 14:46:18.484813fP AA 000182007-08-24 14:46:17.4848132007-08-24 14:46:17.484813fP AA 000172007-08-24 14:46:16.4848132007-08-24 14:46:16.484813fP AA 000162007-08-24 14:46:15.4848132007-08-24 14:46:15.484813tP AA 000152007-08-24 14:46:14.4848132007-08-24 14:46:14.484813fP AA 000142007-08-24 14:46:13.4848132007-08-24 14:46:13.484813fP
AA 000132007-08-24 14:46:12.4848132007-08-24 14:46:12.484813fP AA 000122007-08-24 14:46:11.4848132007-08-24 14:46:11.484813fP AA 000112007-08-24 14:46:10.4848132007-08-24 14:46:10.484813fP
- AA 000102007-08-24 14:46:09.6242812007-08-24 14:46:09.624281fQ AA 000092007-08-24 14:46:08.6070812007-08-24 14:46:08.607081fP AA 000082007-08-24 14:46:07.5899092007-08-24 14:46:07.589909tP AA 000072007-08-24 14:46:06.5726312007-08-24 14:46:06.572631fP AA 000062007-08-24 14:46:05.5553532007-08-24 14:46:05.555353tP AA 000052007-08-24 14:46:04.5380732007-08-24 14:46:04.538073fP AA 000042007-08-24 14:46:03.5207812007-08-24 14:46:03.520781tP AA 000032007-08-24 14:46:02.5025692007-08-24 14:46:02.502569fP AA 000022007-08-24 14:46:01.6414132007-08-24 14:46:01.641413fP AA 000012007-08-24 14:46:00.4848132007-08-24 14:46:00.484813f
+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)G)!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")
\ d
l
t!|)
+
+
+0 7 R AA 000232007-08-24 14:46:20.4848132007-08-24 14:46:20.484813fQ AA 000222007-08-24 14:46:20.4848132007-08-24 14:46:20.484813fQ AA 000212007-08-24 14:46:20.4848132007-08-24 14:46:20.484813fQ AA 000202007-08-24 14:46:19.4848132007-08-24 14:46:19.484813f
Q AA 000192007-08-24 14:46:18.4848132007-08-24 14:46:18.484813fQ AA 000182007-08-24 14:46:17.4848132007-08-24 14:46:17.484813f
+Q AA 000172007-08-24 14:46:16.4848132007-08-24 14:46:16.484813f
+Q AA 000162007-08-24 14:46:15.4848132007-08-24 14:46:15.484813t
+Q AA 000152007-08-24 14:46:14.4848132007-08-24 14:46:14.484813f
+Q AA 000142007-08-24 14:46:13.4848132007-08-24 14:46:13.484813f
+P
AA 000132007-08-24 14:46:12.4848132007-08-24 14:46:12.484813f
+Q AA 000122007-08-24 14:46:11.4848132007-08-24 14:46:11.484813fP AA 000112007-08-24 14:46:10.4848132007-08-24 14:46:10.484813fQ
+ AA 000102007-08-24 14:46:09.6242812007-08-24 14:46:09.624281fQ AA 000092007-08-24 14:46:08.6070812007-08-24 14:46:08.607081fQ AA 000082007-08-24 14:46:07.5899092007-08-24 14:46:07.589909tP AA 000072007-08-24 14:46:06.5726312007-08-24 14:46:06.572631fQ AA 000062007-08-24 14:46:05.5553532007-08-24 14:46:05.555353tQ AA 000052007-08-24 14:46:04.5380732007-08-24 14:46:04.538073fP AA 000042007-08-24 14:46:03.5207812007-08-24 14:46:03.520781tQ AA 000032007-08-24 14:46:02.5025692007-08-24 14:46:02.502569fP AA 000022007-08-24 14:46:01.6414132007-08-24 14:46:01.641413fP AA 000012007-08-24 14:46:00.4848132007-08-24 14:46:00.484813f
ukaWMC9/% 00023 00022 00021 00020 00019 00018 00017 00016 00015 00014 00013
00012 00011 00010
00009 00008 00007 00006 00005 00004 00003 00002 00001
@@ -123,12 +128,12 @@
-
3 G+
n
Q3 ^
A AA2012-10-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996^ A AA2012-10-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\ A AA2012-10-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]
- A AA
2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] A AA 2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\ AAA2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2010-09-14 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\ AAA2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2013-04-18 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996[ AAA2013-04-18 15:00:00.0000002007-09-07 16:34:07.3630232007-09-07 16:34:25.103403Z AAA2013-04-18 15:00:00.0000002007-09-07 16:19:02.2858502007-09-07 16:20:22.000026
+
3 G+
n
Q3 ^
A AA2012-10-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996^ A AA2012-10-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\ A AA2012-10-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996]
+ A AA
2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] A AA 2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\ AAA2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2010-09-14 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996\ AAA2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996] AAA2013-04-19 15:00:00.0000002007-09-07 16:39:03.2100812007-09-09 12:15:11.648996[ AAA2013-04-19 15:00:00.0000002007-09-07 16:34:07.3630232007-09-07 16:34:25.103403Z AAA2013-04-19 15:00:00.0000002007-09-07 16:19:02.2858502007-09-07 16:20:22.000026
@@ -138,12 +143,12 @@
k F
#
h&
-I k m AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-17 23:42:53.000000requestedffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-17 23:42:53.000000retainedffm
AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-15 23:42:53.000000requestedffl AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-15 23:42:53.000000retainedffk AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-15 23:42:53.000000expiredff
- AAA A 2013-04-09 23:42:53.0000002007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-16 22:42:53.000000completedffm AA A 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-15 23:42:53.000000requestedffk AA A 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-09 23:42:53.000000expiredffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-23 23:42:53.000000requestedffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-23 23:42:53.000000requestedffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-23 23:42:53.000000requestedffl AA A 2007-09-01 05:14:52.3568032007-09-02 08:51:54.8878492013-04-23 23:42:53.000000requestedffm AA A 2007-09-02 10:16:55.7148122007-09-02 10:16:55.7148122013-04-23 23:42:53.000000requestedffl AA A 2007-09-02 09:37:25.5760872007-09-02 09:37:25.5760872013-04-23 23:42:53.000000requestedffm AA A 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-23 23:42:53.000000requestedff
+I k m AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-19 07:07:33.000000requestedffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-19 07:07:33.000000retainedffm
AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-17 07:07:33.000000requestedffl AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-17 07:07:33.000000retainedffk AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-17 07:07:33.000000expiredff
+ AAA A 2013-04-11 07:07:33.0000002007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-18 06:07:33.000000completedffm AA A 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-17 07:07:33.000000requestedffk AA A 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-11 07:07:33.000000expiredffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-25 07:07:33.000000requestedffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-25 07:07:33.000000requestedffm AA A 2007-09-01 05:20:05.5308542007-09-01 05:20:05.5308542013-04-25 07:07:33.000000requestedffl AA A 2007-09-01 05:14:52.3568032007-09-02 08:51:54.8878492013-04-25 07:07:33.000000requestedffm AA A 2007-09-02 10:16:55.7148122007-09-02 10:16:55.7148122013-04-25 07:07:33.000000requestedffl AA A 2007-09-02 09:37:25.5760872007-09-02 09:37:25.5760872013-04-25 07:07:33.000000requestedffm AA A 2007-09-02 08:46:52.7916142007-09-02 08:46:52.7916142013-04-25 07:07:33.000000requestedff
@@ -158,28 +163,28 @@
q
v %
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-0000000` ) AA webWorld Wide WebWeb|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349
mitahachioji
-kamata web
k K ## 33 third_shelfThird shelf2013-04-16 23:42:532013-04-16 23:42:53fM %% 33 second_shelfSecond shelf2013-04-16 23:42:532013-04-16 23:42:53fK ## 33 first_shelfFirst shelf2013-04-16 23:42:532013-04-16 23:42:53fF - 33 webLibrary bookmark2013-04-16 23:42:532013-04-16 23:42:53f
-
% ~ n ~
thw 7gtableshelvesshelves;CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "closed" boolean DEFAULT 'f' NOT NULL)lD=
indexindex_baskets_on_user_idbasketsICREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")nC3tablebasketsbasketsHCREATE 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) B''Qtableform_of_worksform_of_worksGCREATE 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)A--Wtableevent_categoriesevent_categoriesFCREATE 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)@O1indexindex_events_on_event_category_ideventsECREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")q?Aindexindex_events_on_library_ideventsDCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")> tableeventseventsCCREATE 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)=##MtablefrequenciesfrequenciesBCREATE 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)
Q)5indexindex_library_groups_on_short_namelibrary_groupsACREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name") Z))itablelibrary_groupslibrary3:##-tableuser_groupsuser_groups?CREATE 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) 9''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)u8Cindexindex_shelves_on_library_idshelves<CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") dtableshelvesshelves;CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)r6;indexindex_libraries_on_namelibraries:CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")5S9indexindex_libraries_on_library_group_idlibraries9CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")
~ ;~ X 7AADVDDVDDVDã§ãã2007-12-22 19:24:23.1514102007-12-22 19:24:23.151410a MAACDCDé³æ¥½CDã§ãã2007-12-18 16:45:26.0406742007-12-18 16:45:26.040674R % AAprintprint本です。2007-11-20 06:47:03.6415302007-11-20 07:04:29.853828o aAAfilefileコンピュータのファイルです。2007-12-23 16:30:50.6374332007-12-23 16:30:50.637433
H V
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.836548mc + +
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/0f2013-04-16 23:42:532013-04-16 23:42:53fhttp://localhost:3000/
+kamata web
k K ## 33 third_shelfThird shelf2013-04-18 07:07:332013-04-18 07:07:33fM %% 33 second_shelfSecond shelf2013-04-18 07:07:332013-04-18 07:07:33fK ## 33 first_shelfFirst shelf2013-04-18 07:07:332013-04-18 07:07:33fF - 33 webLibrary bookmark2013-04-18 07:07:332013-04-18 07:07:33f
+
% ~ n ~
thw 7gtableshelvesshelves;CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "closed" boolean DEFAULT 'f' NOT NULL)lD=
indexindex_baskets_on_user_idbasketsICREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")nC3tablebasketsbasketsHCREATE 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) B''Qtableform_of_worksform_of_worksGCREATE 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)A--Wtableevent_categoriesevent_categoriesFCREATE 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)@O1indexindex_events_on_event_category_ideventsECREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")q?Aindexindex_events_on_library_ideventsDCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")> tableeventseventsCCREATE 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)=##MtablefrequenciesfrequenciesBCREATE 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)
Q)5indexindex_library_groups_on_short_namelibrary_groupsACREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name") Z))itablelibrary_groupslibrary3:##-tableuser_groupsuser_groups?CREATE 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) 9''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)u8Cindexindex_shelves_on_library_idshelves<CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") dtableshelvesshelves;CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)r6;indexindex_libraries_on_namelibraries:CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")5S9indexindex_libraries_on_library_group_idlibraries9CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")
~ ;~ X 7AADVDDVDDVDã§ãã2007-12-22 19:24:23.1514102007-12-22 19:24:23.151410a MAACDCDé³æ¥½CDã§ãã2007-12-18 16:45:26.0406742007-12-18 16:45:26.040674R % AAprintprint本です。2007-11-20 06:47:03.6415302007-11-20 07:04:29.853828o aAAfilefileコンピュータのファイルです。2007-12-23 16:30:50.6374332007-12-23 16:30:50.637433
H V
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.836548mc + +
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/0f2013-04-18 07:07:332013-04-18 07:07:33fhttp://localhost:3000/
@ enju
6
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.980787O ' 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
* V
b6*
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 R +
AAunknown(not specified)2008-01-01 07:17:12.5495652008-01-01 07:24:17.869192O
AA講演会講演会2008-01-01 07:25:04.2511412008-01-01 07:25:04.251141O
AA上映会上映会2008-01-01 07:18:08.8686802008-01-01 07:24:55.261682[ ++
AAおはなし会おはなし会2008-01-01 07:17:45.4154872008-01-01 07:24:45.267241L
AAclosed休館日2008-01-01 07:17:34.6424332008-01-01 07:24:32.561469
] E
AAtesttest2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771E
AAideaidea2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771Z ++
AA(not specified)(not specified)2008-01-08 06:35:55.1887712008-01-08 06:35:55.188771
X G P
X < AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596<
AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596; AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596< AA2008-01-21 08:26:14.5855962008-01-21 08:26:14.585596; AA2008-01-21 08:21:58.5541462008-01-21 08:21:58.554146
-
i J A33 2013-04-23 23:42:52.0000002013-04-16 23:42:532013-04-16 23:42:53J A33 2013-04-23 23:42:52.0000002013-04-16 23:42:532013-04-16 23:42:53J A33 2013-04-23 23:42:52.0000002013-04-16 23:42:532013-04-16 23:42:53I A33
-2013-04-23 23:42:52.0000002013-04-16 23:42:532013-04-16 23:42:53
+
i J A33 2013-04-25 07:07:33.0000002013-04-18 07:07:332013-04-18 07:07:33J A33 2013-04-25 07:07:33.0000002013-04-18 07:07:332013-04-18 07:07:33J A33 2013-04-25 07:07:33.0000002013-04-18 07:07:332013-04-18 07:07:33I A33
+2013-04-25 07:07:33.0000002013-04-18 07:07:332013-04-18 07:07:33
l
O
'