spec/dummy/db/test.sqlite3 in enju_message-0.1.14.pre14 vs spec/dummy/db/test.sqlite3 in enju_message-0.1.14.pre15

- old
+ new

@@ -1,18 +1,15 @@ -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 +SQLite format 3@ 6Tw6-%F&_##itableuser_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)u Cindexindex_shelves_on_library_idshelvesCREATE 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") +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_idagentsCREATE 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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) tableagentsagentsCREATE TABLE "agents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "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" va6A#1 3 q_M;)ucQ?- y g U C 1  3)201408110311452)201407201707351)201407201707140)20140709113905/)20140709113413.)20140628072217-)20140610123439,)20140524074813+)20140518135713*)20140518111006))20140122054321()20140110131010')20140110122216&)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  -  +3 vcP=*lYF3  u b O < )   )201408110311453)201407201707352)201407201707141)201407091139050)20140709113413/)20140628072217.)20140610123439-)20140524074813,)20140518135713+)20140518111006*)20140122054321))20140110131010()20140110122216')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 wj n d Z + +] E_iJ.AA  Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396nI.%AA  オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396qh.+AA  試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396qg.+AA  作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396tf.1AA  出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396e.++7AA !  テスト名字テスト名前テスト正式名称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01v .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-01w.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 GziRG users +)user_has_roles<;q #user_groups roles profiles messages/message_templates -message_requests:l) library_groups libraries agents    h g f e                 h g f e                 h g f e    @@ -20,46 +17,58 @@ 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  -  Y N  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[ '+ AAnot_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*2014-07-05 08:51:022014-07-05 08:51:020.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  +  Y N  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[ '+ AAnot_specified(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542 XX%%-?' 339enju_libraryen: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0*Next-L Enju*2014-08-16 08:25:052014-08-16 08:25:050.0.0.0/0fhttp://localhost:3000/ d _vdzx 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)u Cindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") gtableshelvesshelves 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)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_idagentsCREATE 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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)OytableagentsagentsCREATE TABLE "agents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "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) f R +f + \ h dO/?indexindex_message_templates_on_statusmessage_teetav?tablemessagesmes`##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")v?tablemessagesmessagesCREATE 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, "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_idmessagesCREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")A--5tablemessage_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)##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) + enju       / 8 v  -} O7733reservation_postponed_for_libraryReservation postponedReservation postponed ja2014-07-05 08:51:022014-07-05 08:51:02| M7733reservation_postponed_for_patronReservation postponedReservation postponed ja2014-07-05 08:51:022014-07-05 08:51:02e +} O7733reservation_postponed_for_libraryReservation postponedReservation postponed ja2014-08-16 08:25:052014-08-16 08:25:05| M7733reservation_postponed_for_patronReservation postponedReservation postponed ja2014-08-16 08:25:052014-08-16 08:25:05e ?''33item_received_for_libraryItem receivedItem received -ja2014-07-05 08:51:022014-07-05 08:51:02z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2014-07-05 08:51:022014-07-05 08:51:02k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2014-07-05 08:51:022014-07-05 08:51:02S ###33recall_itemRecall itemRecall itemja2014-07-05 08:51:022014-07-05 08:51:02z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2014-07-05 08:51:022014-07-05 08:51:02y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2014-07-05 08:51:022014-07-05 08:51:02w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2014-07-05 08:51:022014-07-05 08:51:02v I3333reservation_expired_for_patronReservation expiredReservation expiredja2014-07-05 08:51:022014-07-05 08:51:02d =''33item_received_for_patronItem receivedItem receivedja2014-07-05 08:51:022014-07-05 08:51:02x K55 33reservation_accepted_for_patronReservation acceptedReservation acceptedja2014-07-05 08:51:022014-07-05 08:51:02 +ja2014-08-16 08:25:052014-08-16 08:25:05z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2014-08-16 08:25:052014-08-16 08:25:05k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2014-08-16 08:25:052014-08-16 08:25:05S ###33recall_itemRecall itemRecall itemja2014-08-16 08:25:052014-08-16 08:25:05z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2014-08-16 08:25:052014-08-16 08:25:05y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2014-08-16 08:25:052014-08-16 08:25:05w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2014-08-16 08:25:052014-08-16 08:25:05v I3333reservation_expired_for_patronReservation expiredReservation expiredja2014-08-16 08:25:052014-08-16 08:25:05d =''33item_received_for_patronItem receivedItem receivedja2014-08-16 08:25:052014-08-16 08:25:05x K55 33reservation_accepted_for_patronReservation acceptedReservation acceptedja2014-08-16 08:25:052014-08-16 08:25:05 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.unread2014-07-03 08:51:02.0000002014-07-05 08:51:02r)IA3Second MessageCatie, you get the 2nd messageunread2014-07-04 08:51:02.0000002014-07-05 08:51:02w/MA3RE: First MessageThanks Dad! You are the coolest!unread2014-07-03 08:51:02.0000002014-07-05 08:51:02 A'KA3 2014-07-02 08:51:02.000000First MessageAbby, you get the first messageunread2007-07-04 12:10:47.0000002014-07-05 08:51:02 +$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 CyCU1A3Dad!He is sucha dork.2014-08-14 08:25:05.0000002014-08-16 08:25:05k)IA3Second MessageCatie, you get the 2nd message2014-08-15 08:25:05.0000002014-08-16 08:25:05p/MA3RE: First MessageThanks Dad! You are the coolest!2014-08-14 08:25:05.0000002014-08-16 08:25:05A'KA3 2014-08-13 08:25:05.000000First MessageAbby, you get the first message2007-07-04 12:10:47.0000002014-08-16 08:25:05      - 8f 33pending2014-07-05 08:51:022014-07-05 08:51:028Ӳr 33pending2014-07-05 08:51:022014-07-05 08:51:02 -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") + 0f + 332014-08-16 08:25:052014-08-16 08:25:050Ӳr + 332014-08-16 08:25:052014-08-16 08:25:05   '||n u + ~  8h2/tablerolesroles4CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "na 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_3countries.CREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")+[tableversionsversions/CREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime),[Gindexindex_versions_on_item_type_and_item_idversions0CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")j-%%tabledelayed_jobsdelayed_jobs1CREATE 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){.7%'indexdelayed_jobs_prioritydelayed_jobs2CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at") /))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/')0Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")^1 tablelanguageslanguages3CREATE 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)               -  ,<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_types<CREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)c:tableacceptsaccepts=CREATE TABLE "accepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)r;Aindexindex_accepts_on_basket_idaccepts>CREATE 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''33AdministratorAdministrator2014-07-05 08:51:022014-07-05 08:51:02@33LibrarianLibrarian2014-07-05 08:51:022014-07-05 08:51:02633UserUser2014-07-05 08:51:022014-07-05 08:51:02833GuestGuest2014-07-05 08:51:022014-07-05 08:51:02  -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.]332014-07-05 08:51:022014-07-05 08:51:02.z332014-07-05 08:51:022014-07-05 08:51:02.o332014-07-05 08:51:022014-07-05 08:51:02.U332014-07-05 08:51:022014-07-05 08:51:02.ƊW332014-07-05 08:51:022014-07-05 08:51:02.q332014-07-05 08:51:022014-07-05 08:51:02-x 332014-07-05 08:51:022014-07-05 08:51:02   +  LH''33AdministratorAdministrator2014-08-16 08:25:052014-08-16 08:25:05@33LibrarianLibrarian2014-08-16 08:25:052014-08-16 08:25:05633UserUser2014-08-16 08:25:052014-08-16 08:25:05833GuestGuest2014-08-16 08:25:052014-08-16 08:25:05  +O -  +A AA ;user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user42014-08-15 08:25:05 UTCqA AA user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3+=AA user2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user25GAA! librarian2@library.example.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.337474librarian1.CAA tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731admin | n + 0HS +|AWtableprofilesprofilesDCREATE TABLE "profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_group_id" integer, "library_id" integer, "locale" varchar(255), "user_number" varchar(255), "full_name" text, "note" text, "keyword_list" text, "required_role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "expired_at" datetime)@333tableuser_import_resultsuser_import_resultsCCREATE TABLE "user_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_import_file_id" integer, "user_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)F?//;tableuser_import_filesuser_import_filesBCREATE TABLE "user_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "executed_at" datetime, "user_import_file_name" varchar(255), "user_import_content_type" varchar(255), "user_import_file_size" varchar(255), "user_import_updated_at" datetime, "user_import_fingerprint" varchar(255), "edit_mode" varchar(255), "error_message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_encoding" varchar(255), "default_library_id" integer, "default_user_group_id" integer)z>C'indexindex_users_on_unlock_tokenusersACREATE UNIQUE INDEX "index_users_on_unlock_token" ON "users" ("unlock_token")w=A#indexindex_users_on_user_numberusers@CREATE UNIQUE INDEX "index_users_on_user_number" ON "users" ("user_number")v<Eindexindex_users_on_user_group_idusers?CREATE 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")l:= indexindex_accepts_on_item_idaccepts=CREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")r9Aindexindex_accepts_on_basket_idaccepts<CREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")c8tableacceptsaccepts;CREATE TABLE "accepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)}7%%=tablebudget_typesbudget_types:CREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)^6))wtableuser_has_rolesuser_has_roles9CREATE 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)5SGindexindex_users_on_reset_password_tokenusers8CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")$3'tableusersusers5CREATE 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)h2/tablerolesroles4CREATE 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) +!|_@!Auser4@kamata.lib.teu.ac.jpAuser3@kamata.lib.teu.ac.jp=user2@library.example.jp!Glibrarian2@library.example.jpAuser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jpC tanabe@kamata.lib.teu.ac.jp + g4.]332014-08-16 08:25:052014-08-16 08:25:05.z332014-08-16 08:25:052014-08-16 08:25:05.o332014-08-16 08:25:052014-08-16 08:25:05.U332014-08-16 08:25:052014-08-16 08:25:05.ƊW332014-08-16 08:25:052014-08-16 08:25:05.q332014-08-16 08:25:052014-08-16 08:25:05-x 332014-08-16 08:25:052014-08-16 08:25:05      user4 user3 user2!librarian2 user1!librarian1 admin -        +        - +    f5 L AAja000072007-11-19 07:58:34.6374132008-05-31 04:02:25.101261L AAja000062007-11-19 07:58:34.6374132008-05-31 04:02:25.101261F AAja2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117K  AAja000042008-01-18 03:24:04.2223442008-05-31 03:42:23.340575L AAja000032007-11-19 07:58:34.6374132008-05-31 04:02:25.101261J  AAja000022007-11-19 07:58:33.1724412008-05-31 03:41:16.337474L AAja000012007-11-19 07:58:32.1119412008-05-31 04:16:30.163731 + w( +   ` 1LOEEtableuser_export_file_transitionsuser_export_file_transitionsRCREATE TABLE "user_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_szQE9indexindex_user_export_file_transitions_on_sort_key_and_file_iduser_export_file_transitionsTCREATE UNIQUE INDEX "index_user_export_file_transitions_on_sort_key_and_file_id" ON "user_export_file_transitions" ("sort_key", "user_export_file_id")pB?indexindex_profiles_on_user_idprofilesECREATE INDEX "index_profiles_on_user_id" ON "profiles" ("user_id")CG/indexindex_profiles_on_user_numberprofilesGCREATE UNIQUE INDEX "index_profiles_on_user_number" ON "profiles" ("user_number")(D33wtablemessage_transitionsmessage_transitionsHCREATE TABLE "message_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "message_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%E[3Iindexindex_message_transitions_on_message_idmessage_transitionsICREATE INDEX "index_message_transitions_on_message_id" ON "message_transitions" ("message_id")RFu3 indexindex_message_transitions_on_sort_key_and_message_idmessage_transitionsJCREATE UNIQUE INDEX "index_message_transitions_on_sort_key_and_message_id" ON "message_transitions" ("sort_key", "message_id")HGCCtablemessage_request_transitionsmessage_request_transitionsKCREATE TABLE "message_request_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "message_request_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]H{C indexindex_message_request_transitions_on_message_request_idmessage_request_transitionsLCREATE INDEX "index_message_request_transitions_on_message_request_id" ON "message_request_transitions" ("message_request_id"){IC9indexindex_message_request_transitions_on_sort_key_and_request_idmessage_request_transitionsMCREATE UNIQUE INDEX "index_message_request_transitions_on_sort_key_and_request_id" ON "message_request_transitions" ("sort_key", "message_request_id")LJEEtableuser_import_file_transitionsuser_import_file_transitionsNCREATE TABLE "user_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_import_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)dKEindexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitionsOCREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id")zLE9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitionsPCREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")]M5}indexindex_users_on_emailusers7CREATE INDEX "index_users_on_email" ON "users" ("email")N//-tableuser_export_filesuser_export_filesQCREATE TABLE "user_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_export_file_name" varchar(255), "user_export_content_type" varchar(255), "user_export_file_size" integer, "user_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)LOEEtableuser_export_file_transitionsuser_export_file_transitionsRCREATE TABLE "user_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)LPgEyindexindex_user_export_file_transitions_on_file_iduser_export_file_transitionsSCREATE INDEX "index_user_export_file_transitions_on_file_id" ON "user_export_file_transitions" ("user_export_file_id") + 00007 00006 00004 00003 00002 00001  + +  + +  + +   + + \ No newline at end of file