spec/dummy/db/test.sqlite3 in enju_message-0.1.14.pre11 vs spec/dummy/db/test.sqlite3 in enju_message-0.1.14.pre12
- old
+ new
@@ -1,8 +1,8 @@
-SQLite format 3 @ ) C a ) -$ 6(2mg uCindexindex_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") S 9indexindex_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 @ - C a - -% 8:D9 ##Etableuser_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, "updated_at" datetime, "deleted_at" datetime)uCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")O
utableshelvesshelvesCREATE 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, "updated_at" datetime, "deleted_at" datetime)r ; indexindex_libraries_on_namelibraries
CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name") S 9indexindex_libraries_on_library_group_idlibraries CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")0
+ /tablelibrarieslibraries CREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime, "updated_at" datetime, "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)tableagentsagentsCREATE 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, "updated_at" datetime, "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 %/
&
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
l ve
e Y M
M 3Kl jJ/ 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/ 1 AA
出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396 e/ + + 7 AA
! テスト名字テスト名前テスト正式名称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
@@ -20,44 +20,41 @@
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 %
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-0000000c ) AA webWorld Wide WebWeb|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349
mita hachioji
kamata web
-
W N
AA FacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351H
AA UserUser2007-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") S 9indexindex_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)b tableagentsagentsCREATE 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)
X X % %-? ' 33 9enju_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 { Itablemessagesmessages CREATE 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") ktablemessagesmessages CREATE 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)vC indexindex_messages_on_sender_idmessages CREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|G !indexindex_messages_on_receiver_idmessages CREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id") U =indexindex_messages_on_message_request_idmessages CREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")v C indexindex_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
AA FacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351H
AA UserUser2007-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
X X % %-? ' 33 9enju_libraryen: Enju Libraryenjunext-l@library.example.jp0.0.0.0/0*Next-L Enju*2014-01-27 17:41:412014-01-27 17:41:410.0.0.0/0fhttp://localhost:3000/
^w~|
+ Mtablelibrarieslibraries 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, "updated_at" datetime, "deleted_at" datetime, "opening_hour" text, "isil" varchar(255), "latitude" float, "longitude" float)uCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")v
CtableshelvesshelvesCREATE 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, "updated_at" datetime, "deleted_at" datetime, "closed" boolean DEFAULT 'f' NOT NULL)r ; indexindex_libraries_on_namelibraries
CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name") S 9indexindex_libraries_on_library_group_idlibraries CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")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)P{tableagentsagentsCREATE 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, "updated_at" datetime, "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)
o = . o 5 +
7 g z Gtablemessagesmessages CREATE 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, "updated_at" datetime, "lft" integer, "rgt" integer, "depth" integer)N##ctableuser_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, "updated_at" datetime, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime)\tablebasketsbasketsCREATE TABLE "baskets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime, "updated_at" datetime)l=
indexindex_baskets_on_user_idbasketsCREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")a!!
tablebookstoresbookstoresCREATE 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, "updated_at" datetime) 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, "updated_at" datetime)w''-tablerequest_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, "updated_at" datetime)4//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, "updated_at" datetime)O/?indexindex_message_templates_on_statusmessage_templatesCREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status") l %tablemessagesmessages CREATE 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, "updated_at" datetime, "lft" integer, "rgt" integer)vC indexindex_messages_on_sender_idmessages CREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|G !indexindex_messages_on_receiver_idmessages CREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id") U =indexindex_messages_on_message_request_idmessages CREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")v C indexindex_messages_on_parent_idmessages CREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")E --=tablemessage_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, "updated_at" datetime)
+ K-)indexindex_message_requests_on_statemessage_requests"CREATE INDEX "index_message_requests_on_state" ON "message_requests" ("state")q ##)tableagent_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, "updated_at" datetime)
+ 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
+ } O7733reservation_postponed_for_libraryReservation postponedReservation postponed ja2014-01-27 17:41:412014-01-27 17:41:41| M7733reservation_postponed_for_patronReservation postponedReservation postponed ja2014-01-27 17:41:412014-01-27 17:41:41e
?''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
+ja2014-01-27 17:41:412014-01-27 17:41:41z M5533reservation_accepted_for_libraryReservation acceptedReservation accepted ja2014-01-27 17:41:412014-01-27 17:41:41k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2014-01-27 17:41:412014-01-27 17:41:41S ###33recall_itemRecall itemRecall itemja2014-01-27 17:41:412014-01-27 17:41:41z M5533reservation_canceled_for_libraryReservation canceledReservation canceledja2014-01-27 17:41:412014-01-27 17:41:41y K5533reservation_canceled_for_patronReservation canceledReservation canceledja2014-01-27 17:41:412014-01-27 17:41:41w K3333reservation_expired_for_libraryReservation expiredReservation expiredja2014-01-27 17:41:412014-01-27 17:41:41v I3333reservation_expired_for_patronReservation expiredReservation expiredja2014-01-27 17:41:412014-01-27 17:41:41d =''33item_received_for_patronItem receivedItem receivedja2014-01-27 17:41:412014-01-27 17:41:41x K55 33reservation_accepted_for_patronReservation acceptedReservation acceptedja2014-01-27 17:41:412014-01-27 17:41:41
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' \ 1 A3 Dad!He is sucha dork.unread2013-07-09 04:00:23.0000002013-07-11 04:00:23r )I A3 Second MessageCatie, you get the 2nd messageunread2013-07-10 04:00:23.0000002013-07-11 04:00:23w /M A3 RE: First MessageThanks Dad! You are the coolest!unread2013-07-09 04:00:23.0000002013-07-11 04:00:23 A'K A3 2013-07-08 04:00:23.000000First MessageAbby, you get the first messageunread2007-07-04 12:10:47.0000002013-07-11 04:00:23
+$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' \ 1 A3 Dad!He is sucha dork.unread2014-01-25 17:41:41.0000002014-01-27 17:41:41r )I A3 Second MessageCatie, you get the 2nd messageunread2014-01-26 17:41:41.0000002014-01-27 17:41:41w /M A3 RE: First MessageThanks Dad! You are the coolest!unread2014-01-25 17:41:41.0000002014-01-27 17:41:41 A'K A3 2014-01-24 17:41:41.000000First MessageAbby, you get the first messageunread2007-07-04 12:10:47.0000002014-01-27 17:41:41
-
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
Q QW,
- s
z f {07%'indexdelayed_jobs_prioritydelayed_jobs4CREATE INDEX "delayed 2Q)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*A indexindex_countries_on_alpha_2countries.CREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")t+A indexindex_countries_on_alpha_3countries/CREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")z,E indexindex_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")
+
8f 33pending2014-01-27 17:41:412014-01-27 17:41:418Ӳr 33pending2014-01-27 17:41:412014-01-27 17:41:41
+ pendingʊfpending:l
Xx"
+# -
'= f b z,E indexindex_countries_on_numeric_3countries0CREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")t+A indexindex_ L3 gtablelanguageslanguages5CREATE TABLE "languages" ("id" IN $!!stablesubscribessubscribes(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, "updated_at" datetime)%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")'))Ctablesearch_enginessearch_engines+CREATE TABLE "search_engines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "url" va9!''1tablesubscriptionssubscriptions$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, "updated_at" datetime)"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")$!!stablesubscribessubscribes(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, "updated_at" datetime)%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")'))Ctablesearch_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, "updated_at" datetime)( ]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*A indexindex_countries_on_alpha_2countries.CREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")t+A indexindex_countries_on_alpha_3countries/CREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")z,E indexindex_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")X/%%stabledelayed_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, "updated_at" datetime)
-
,<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>E indexindex_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")
L H '' 33AdministratorAdministrator2013-07-11 04:00:232013-07-11 04:00:23@ 33LibrarianLibrarian2013-07-11 04:00:232013-07-11 04:00:236 33UserUser2013-07-11 04:00:232013-07-11 04:00:238 33GuestGuest2013-07-11 04:00:232013-07-11 04:00:23
+
L H '' 33AdministratorAdministrator2014-01-27 17:41:412014-01-27 17:41:41@ 33LibrarianLibrarian2014-01-27 17:41:412014-01-27 17:41:416 33UserUser2014-01-27 17:41:412014-01-27 17:41:418 33GuestGuest2014-01-27 17:41:412014-01-27 17:41:41
M
( w
- r A
AA user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4r A
AA user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3. A AA user2@kamata.lib.teu.ac.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user27 K AA! librarian2@kamata.lib.teu.ac.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS2008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2. A AA user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW2007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user17 K AA! librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS2007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian10 C AA tanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731admin
+ r A
AA user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user4r A
AA user3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3. A AA user2@kamata.lib.teu.ac.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user27 K AA! librarian2@kamata.lib.teu.ac.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS2008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2. A AA user1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW2007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user17 K AA! librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS2007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian10 C AA 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 L
/ jDb# 5tableusersusers7CREATE 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, "updated_at" datetime, "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)l<=
indexindex_accepts_on_item_idaccepts?CREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")r;Aindexindex_accepts_on_basket_idaccepts>CREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")Q:ytableacceptsaccepts=CREATE TABLE "accepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime, "updated_at" datetime)k9%%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, "updated_at" datetime)L8))Stableuser_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, "updated_at" datetime)7SGindexindex_users_on_reset_password_tokenusers:CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e65 indexindex_users_on_emailusers9CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email"){07%'indexdelayed_jobs_prioritydelayed_jobs4CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at"){1))1tablelibrary_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, "updated_at" datetime, "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")L3 gtablelanguageslanguages5CREATE 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, "updated_at" datetime)V4 tablerolesroles6CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime) Itableusersusers7Cz@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>E indexindex_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")
z[< Auser4@kamata.lib.teu.ac.jp Auser3@kamata.lib.teu.ac.jp Auser2@kamata.lib.teu.ac.jp#Klibrarian2@kamata.lib.teu.ac.jp Auser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jp C tanabe@kamata.lib.teu.ac.jp
-
g4 .] 332013-07-11 04:00:232013-07-11 04:00:23.z 332013-07-11 04:00:232013-07-11 04:00:23.o 332013-07-11 04:00:232013-07-11 04:00:23.U 332013-07-11 04:00:232013-07-11 04:00:23.ƊW 332013-07-11 04:00:232013-07-11 04:00:23.q 332013-07-11 04:00:232013-07-11 04:00:23-x 332013-07-11 04:00:232013-07-11 04:00:23
+
g4 .] 332014-01-27 17:41:412014-01-27 17:41:41.z 332014-01-27 17:41:412014-01-27 17:41:41.o 332014-01-27 17:41:412014-01-27 17:41:41.U 332014-01-27 17:41:412014-01-27 17:41:41.ƊW 332014-01-27 17:41:412014-01-27 17:41:41.q 332014-01-27 17:41:412014-01-27 17:41:41-x 332014-01-27 17:41:412014-01-27 17:41:41
user4 user3 user2!librarian2 user1!librarian1 admin
\ No newline at end of file