SQLite format 3@ )Ca)-$6(2mguCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")a tableshelvesshelvesCREATE 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") S9indexindex_libraries_on_library_group_idlibraries CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")B Stablelibrarieslibraries CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)n ?indexindex_agents_on_full_nameagents CREATE INDEX "index_agents_on_full_name" ON "agents" ("full_name")M-indexindex_agents_on_required_role_idagents CREATE INDEX "index_agents_on_required_role_id" ON "agents" ("required_role_id")qAindexindex_agents_on_country_idagentsCREATE INDEX "index_agents_on_country_id" ON "agents" ("country_id")tCindexindex_agents_on_language_idagentsCREATE INDEX "index_agents_on_language_id" ON "agents" ("language_id")o;indexindex_agents_on_user_idagentsCREATE UNIQUE INDEX "index_agents_on_user_id" ON "agents" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq),3tableagentsagentsCREATE TABLE "agents" ("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, "agent_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 "schema_migrations" ("version" varchar%0 & q_M;)ucQ?- &)20130412083556%)20130221154434$)20120510140958#)20120319173203")20120129014038!)20120125050502 )20120105074911)20111201163718)20111201155456)20111201121844)20111201121636)20111020063828)20110913115320)20110318183304)20110301121550)20110222073537)20100527113752)20100314190054)20100222124420)20100211105551)20091202124834)20081025083323)20081023092436)20081006093246)20081006090811 )20080905191442 )20080819181903 154 149 131130124120807769591 & vcP=*lYF3  )20130412083556&)20130221154434%)20120510140958$)20120319173203#)20120129014038")20120125050502!)20120105074911 )20111201163718)20111201155456)20111201121844)20111201121636)20111020063828)20110913115320)20110318183304)20110301121550)20110222073537)20100527113752)20100314190054)20100222124420)20100211105551)20091202124834)20081025083323)20081023092436)20081006093246)20081006090811)20080905191442 )20080819181903 154 149 131 13012412080776959 1 lve e Y M M 3KljJ/AA  Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396oI/%AA  オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396rh/+AA  試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396rg/+AA  作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396uf/1AA  出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396 e/++7AA !  テスト名字テスト名前テスト正式名称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01x /AA !  User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 /##AA !  New agent 5New agent 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 /##AA !  New agent 4New agent 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/##AA !  New agent 3New agent 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/##AA !  New agent 2New agent 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/##AA !  New agent 1New agent 12007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01y/AA ! User2User22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/!!AA!  Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-01/'AA! KosukeTanabeKosuke Tanabe2007-12-04 07:25:01.5236182007-12-04 07:25:01.5236182000-01-01/!!AA ! Librarian1Librarian12007-11-19 08:06:07.7245172007-11-21 13:02:10.3597932000-01-01/ ''AA !  AdministratorAdministrator2007-11-19 08:06:06.5072372007-11-21 13:01:56.1374092000-01-01 Uw`U users )user_has_roles<;q#user_groups roles messages/message_templates -message_requests:l) library_groups libraries agents hgfe       h g f e                 h g f e                 h g f e           ue[A* Ruby社%オーム社+試験用会社h+作者ダミーg1出版社テストf7テスト正式名称e User3 #New agent 5 #New agent 4 #New agent 3#New agent 2#New agent 1 User2!Librarian2'Kosuke Tanabe!Librarian1' Administrator   h y%  AAmitaMita Library三田108-8345MinatoTokyo|2007-08-23 10:51:00.0000002007-08-30 15:18:20.043951-% %  AAhachiojiHachioji Library八王子192-0982HachiojiTokyo042-637-2033042-637-2116|2007-08-14 07:37:00.0000002007-08-30 15:18:16.188285))  AA!kamataKamata Library蒲田144-8535Tokyo81-3-3732-5111|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349JP-0000000c)   AAwebWorld Wide WebWeb|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349     mita hachioji kamata web   WN  AAFacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351H  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 W LelWjk qtablelibrarieslibraries CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "opening_hour" text, "isil" varchar(255), "latitude" float, "longitude" float) gtableshelvesshelvesCREATE 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)r ;indexindex_libraries_on_namelibraries CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name") S9indexindex_libraries_on_library_group_idlibraries CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")n ?indexindex_agents_on_full_nameagents CREATE INDEX "index_agents_on_full_name" ON "agents" ("full_name")M-indexindex_agents_on_required_role_idagents CREATE INDEX "index_agents_on_required_role_id" ON "agents" ("required_role_id")qAindexindex_agents_on_country_idagentsCREATE INDEX "index_agents_on_country_id" ON "agents" ("country_id")tCindexindex_agents_on_language_idagentsCREATE INDEX "index_agents_on_language_id" ON "agents" ("language_id")o;indexindex_agents_on_user_idagentsCREATE UNIQUE INDEX "index_agents_on_user_id" ON "agents" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)btableagentsagentsCREATE TABLE "agents" ("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, "agent_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, "birth_date" varchar(255), "death_date" varchar(255))=//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) XX%%-?' 339enju_libraryen: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0*Next-L Enju*2013-07-11 04:00:232013-07-11 04:00:230.0.0.0/0fhttp://localhost:3000/ ?w  s{ItablemessagesmessagesCREATE TABLE "`##tableuser_groupsuser_groupsCREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varcuCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")`##tableuser_groupsuser_groupsCREATE 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, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime)n3tablebasketsbasketsCREATE 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)l= indexindex_baskets_on_user_idbasketsCREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")s!!1tablebookstoresbookstoresCREATE TABLE "bookstores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" text NOT NULL, "zip_code" varchar(255), "address" text, "note" text, "telephone_number" varchar(255), "fax_number" varchar(255), "url" varchar(255), "position" integer, "deleted_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)55_tablerequest_status_typesrequest_status_typesCREATE TABLE "request_status_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ''Qtablerequest_typesrequest_typesCREATE TABLE "request_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)F//;tablemessage_templatesmessage_templatesCREATE TABLE "message_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar(255) NOT NULL, "title" text NOT NULL, "body" text NOT NULL, "position" integer, "locale" varchar(255) DEFAULT 'en', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)O/?indexindex_message_templates_on_statusmessage_templatesCREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status") ktablemessagesmessagesCREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "read_at" datetime, "receiver_id" integer, "sender_id" integer, "subject" varchar(255) NOT NULL, "body" text, "message_request_id" integer, "state" varchar(255), "parent_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "lft" integer, "rgt" integer, "depth" integer)vCindexindex_messages_on_sender_idmessagesCREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|G!indexindex_messages_on_receiver_idmessagesCREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")U=indexindex_messages_on_message_request_idmessagesCREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")vCindexindex_messages_on_parent_idmessages CREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")W--atablemessage_requestsmessage_requests!CREATE TABLE "message_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "receiver_id" integer, "message_template_id" integer, "sent_at" datetime, "deleted_at" datetime, "body" text, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) K-)indexindex_message_requests_on_statemessage_requests"CREATE INDEX "index_message_requests_on_state" ON "message_requests" ("state")  enju       / 8 v  } O7733reservation_postponed_for_libraryReservation postponedReservation postponed ja2013-07-11 04:00:232013-07-11 04:00:23| M7733reservation_postponed_for_patronReservation postponedReservation postponed ja2013-07-11 04:00:232013-07-11 04:00:23e ?''33item_received_for_libraryItem receivedItem received ja2013-07-11 04:00:232013-07-11 04:00:23z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2013-07-11 04:00:232013-07-11 04:00:23k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2013-07-11 04:00:232013-07-11 04:00:23S ###33recall_itemRecall itemRecall itemja2013-07-11 04:00:232013-07-11 04:00:23z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2013-07-11 04:00:232013-07-11 04:00:23y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2013-07-11 04:00:232013-07-11 04:00:23w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2013-07-11 04:00:232013-07-11 04:00:23v I3333reservation_expired_for_patronReservation expiredReservation expiredja2013-07-11 04:00:232013-07-11 04:00:23d =''33item_received_for_patronItem receivedItem receivedja2013-07-11 04:00:232013-07-11 04:00:23x K55 33reservation_accepted_for_patronReservation acceptedReservation acceptedja2013-07-11 04:00:232013-07-11 04:00:23 z 0Uyz%Oreservation_postponed_for_library $Mreservation_postponed_for_patron ?item_received_for_library $Mreservation_accepted_for_library 3recall_overdue_item#recall_item$Mreservation_canceled_for_library#Kreservation_canceled_for_patron#Kreservation_expired_for_library"Ireservation_expired_for_patron=item_received_for_patron"K reservation_accepted_for_patron 'r'\1A3Dad!He is sucha dork.unread2013-07-09 04:00:23.0000002013-07-11 04:00:23r)IA3Second MessageCatie, you get the 2nd messageunread2013-07-10 04:00:23.0000002013-07-11 04:00:23w/MA3RE: First MessageThanks Dad! You are the coolest!unread2013-07-09 04:00:23.0000002013-07-11 04:00:23 A'KA3 2013-07-08 04:00:23.000000First MessageAbby, you get the first messageunread2007-07-04 12:10:47.0000002013-07-11 04:00:23       8f 33pending2013-07-11 04:00:232013-07-11 04:00:238Ӳr 33pending2013-07-11 04:00:232013-07-11 04:00:23 pendingʊfpending:l   QQW, s zf{07%'indexdelayed_jobs_prioritydelayed_jobs4CREATE INDEX "delayed2Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")K!''Utablesubscriptionssubscriptions$CREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" text NOT NULL, "note" text, "user_id" integer, "order_list_id" integer, "deleted_at" datetime, "subscribes_count" integer DEFAULT 0 NOT N ##Mtableagent_typesagent_types#CREATE TABLE "agent_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)K!''Utablesubscriptionssubscriptions$CREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" text NOT NULL, "note" text, "user_id" integer, "order_list_id" integer, "deleted_at" datetime, "subscribes_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"I'%indexindex_subscriptions_on_user_idsubscriptions&CREATE INDEX "index_subscriptions_on_user_id" ON "subscriptions" ("user_id")#U'=indexindex_subscriptions_on_order_list_idsubscriptions'CREATE INDEX "index_subscriptions_on_order_list_id" ON "subscriptions" ("order_list_id")&$!!tablesubscribessubscribes(CREATE TABLE "subscribes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subscription_id" integer NOT NULL, "work_id" integer NOT NULL, "start_at" datetime NOT NULL, "end_at" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%S!9indexindex_subscribes_on_subscription_idsubscribes)CREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id")x&C!indexindex_subscribes_on_work_idsubscribes*CREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id")'))gtablesearch_enginessearch_engines+CREATE TABLE "search_engines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "url" varchar(255) NOT NULL, "base_url" text NOT NULL, "http_method" text NOT NULL, "query_param" text NOT NULL, "additional_param" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)(]tablecountriescountries,CREATE 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_namecountries-CREATE INDEX "index_countries_on_name" ON "countries" ("name")t*Aindexindex_countries_on_alpha_2countries.CREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")t+Aindexindex_countries_on_alpha_3countries/CREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")z,Eindexindex_countries_on_numeric_3countries0CREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")-[tableversionsversions1CREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime).[Gindexindex_versions_on_item_type_and_item_idversions2CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")j/%%tabledelayed_jobsdelayed_jobs3CREATE 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){07%'indexdelayed_jobs_prioritydelayed_jobs4CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")                 ,<1 [ W 88 s ~b#tableusersusers8CREATE TABLE "users" ("id" INTEGER PRIMARY K$5'tableusersusers8CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT 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), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "username" varchar(255), "user_number" varchar(255), "state" varchar(255), "locale" varchar(255), "deleted_at" datetime, "expired_at" datetime, "library_id" integer DEFAULT 1 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "user_group_id" integer DEFAULT 1 NOT NULL, "note" text, "keyword_list" text, "failed_attempts" integer, "unlock_token" varchar(255), "locked_at" datetime, "confirmed_at" datetime) 1))Utablelibrary_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, "country_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "admin_networks" text, "allow_bookmark_external_url" boolean DEFAULT 'f' NOT NULL, "url" varchar(255) DEFAULT 'http://localhost:3000/')2Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")^3 tablelanguageslanguages5CREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)h4/tablerolesroles7CREATE 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)bWtableusersusers8CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "z@C'indexindex_users_on_unlock_tokenusersCCREATE UNIQUE INDEX "index_users_on_unlock_token" ON "users" ("unlock_token")w?A#indexindex_users_on_user_numberusersBCREATE UNIQUE INDEX "index_users_on_user_number" ON "users" ("user_number")v>Eindexindex_users_on_user_group_idusersACREATE INDEX "index_users_on_user_group_id" ON "users" ("user_group_id")n=;indexindex_users_on_usernameusers@CREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")e65 indexindex_users_on_emailusers9CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")7SGindexindex_users_on_reset_password_tokenusers:CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")^8))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)}9%%=tablebudget_typesbudget_typesCREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")l<= indexindex_accepts_on_item_idaccepts?CREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id") LH''33AdministratorAdministrator2013-07-11 04:00:232013-07-11 04:00:23@33LibrarianLibrarian2013-07-11 04:00:232013-07-11 04:00:23633UserUser2013-07-11 04:00:232013-07-11 04:00:23833GuestGuest2013-07-11 04:00:232013-07-11 04:00:23  M ( w rA AA  user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4rA AA  user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3.AAA  user2@kamata.lib.teu.ac.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user27KAA! librarian2@kamata.lib.teu.ac.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS2008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2.AAA  user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW2007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user17KAA! librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS2007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian10CAA tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731admin z[<Auser4@kamata.lib.teu.ac.jpAuser3@kamata.lib.teu.ac.jpAuser2@kamata.lib.teu.ac.jp#Klibrarian2@kamata.lib.teu.ac.jpAuser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jpC tanabe@kamata.lib.teu.ac.jp  g4.]332013-07-11 04:00:232013-07-11 04:00:23.z332013-07-11 04:00:232013-07-11 04:00:23.o332013-07-11 04:00:232013-07-11 04:00:23.U332013-07-11 04:00:232013-07-11 04:00:23.ƊW332013-07-11 04:00:232013-07-11 04:00:23.q332013-07-11 04:00:232013-07-11 04:00:23-x 332013-07-11 04:00:232013-07-11 04:00:23      user4 user3 user2!librarian2 user1!librarian1 admin