SQLite format 3@ -:K--%6 Fnqn3tablebasketsbasketsCREATE 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)Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")o))tablelibrary_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, "my_networks" text, "login_banner" text, "note" text, "country_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ##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_idshelves CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")a tableshelvesshelves CREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)r ;indexindex_libraries_on_namelibraries CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name") S9indexindex_libraries_on_library_group_idlibraries CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")BStablelibrarieslibraries 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) utablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" varchar(255), "note" text, "created_at" datetime, "updated_at" datetime, "score" integer DEFAULT 0 NOT NULL, "position" integer)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)mtableusersusersCREATE 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)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar&* ' ygUC1 }kYG5# ')20140811031145&)20140720170735%)20140720170714$)20140709113905#)20140709113413")20140628072217!)20140610123439 )20140524074813)20140122054321)20140110131010)20140110122216)20130412083556)20130221154434)20120510140958)20120319173203)20120129014038)20120105074911)20110318183304)20110222073537)20110220103937)20100606065209)20100314190054)20100211105551)20091202124834)20090126071155)20081031033632 )20081023092436 )20081006093246 )20081006090811 131 13012412080776959412 ' lYF3  ubO<) )20140811031145')20140720170735&)20140720170714%)20140709113905$)20140709113413#)20140628072217")20140610123439!)20140524074813 )20140122054321)20140110131010)20140110122216)20130412083556)20130221154434)20120510140958)20120319173203)20120129014038)20120105074911)20110318183304)20110222073537)20110220103937)20100606065209)20100314190054)20100211105551)20091202124834)20090126071155)20081031033632)20081023092436 )20081006093246 )20081006090811 131 130 1241208077695941 2  W M A AA;user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user42014-08-17 05:36:53 UTCiA AAuser3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user3#=AAuser2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117user2-GAA!librarian2@library.example.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS2008-01-18 03:24:04.2223442008-05-31 03:42:23.340575librarian2%AAAuser1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW2007-11-19 07:58:34.6374132008-05-31 04:02:25.101261user1/KAA!librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS2007-11-19 07:58:33.1724412008-05-31 03:41:16.337474librarian1&CAAtanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731admin  users)user_has_roles<;q#user_groups roles!news_posts!news_feeds) library_groups libraries !|_@!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  II ''33AdministratorAdministrator2014-08-18 05:36:532014-08-18 05:36:53A 33LibrarianLibrarian2014-08-18 05:36:532014-08-18 05:36:537 33UserUser2014-08-18 05:36:532014-08-18 05:36:539 33GuestGuest2014-08-18 05:36:532014-08-18 05:36:53   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   WP  AAFacultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351J  AAUserUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548m[ '+ AAnot_specified(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542 s%-339enju_libraryen: Enju Libraryenju0.0.0.0/02014-08-18 05:36:532014-08-18 05:36:53http://localhost:3000/  enju    g  i h BBq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")?]tableusersusersCREATE 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), "deleted_at" datetime, "expired_at" datetime, "failed_attempts" integer DEFAULT 0, "unlock_token" varchar(255), "locked_at" datetime, "confirmed_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)g5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") utablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" varchar(255), "note" text, "created_at" datetime, "updated_at" datetime, "score" integer DEFAULT 0 NOT NULL, "position" integer)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) S9indexindex_libraries_on_library_group_idlibraries CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")r ;indexindex_libraries_on_namelibraries CREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name") 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)u Cindexindex_shelves_on_library_idshelves CREATE 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);))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, "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, "url" varchar(255) DEFAULT 'http://localhost:3000/')  m o  1 >ms!!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),Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")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= indexQ)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")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)K''UtablesubscriptionssubscriptionsCREATE 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_idsubscriptionsCREATE INDEX "index_subscriptions_on_user_id" ON "subscriptions" ("user_id")U'=indexindex_subscriptions_on_order_list_idsubscriptionsCREATE INDEX "index_subscriptions_on_order_list_id" ON "subscriptions" ("order_list_id")&!!tablesubscribessubscribesCREATE 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_idsubscribesCREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id")xC!indexindex_subscribes_on_work_idsubscribesCREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id")))gtablesearch_enginessearch_enginesCREATE 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)&!!tablenews_feedsnews_feedsCREATE TABLE "news_feeds" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "title" varchar(255), "url" varchar(255), "body" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)          II[ %K33invalid feedhttp://example.com/invalid_feed2014-08-18 05:36:532014-08-18 05:36:53X Y 33NDLhttp://iss.ndl.go.jp/information/feed/2014-08-18 05:36:532014-08-18 05:36:53 OOW%7 33お知らせお知らせの内容f2014-08-18 05:36:532014-08-18 05:36:53V%7 33お知らせお知らせの内容f2014-08-18 05:36:532014-08-18 05:36:53     g4.]332014-08-18 05:36:532014-08-18 05:36:53.z332014-08-18 05:36:532014-08-18 05:36:53.o332014-08-18 05:36:532014-08-18 05:36:53.U332014-08-18 05:36:532014-08-18 05:36:53.ƊW332014-08-18 05:36:532014-08-18 05:36:53.q332014-08-18 05:36:532014-08-18 05:36:53-x 332014-08-18 05:36:532014-08-18 05:36:53 <;q"_zX  QWq  x pLi J ` ` F ( pcd0Eindexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitions4CREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id")L/EEtableuser_import_file_transitionsuser_import_file_transitions3CREATE TABLE "user_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sortF*//;tableuser_import_filesuser_import_files.CREATE 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)!!ktablenews_postsnews_posts CREATE TABLE "news_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" text, "body" text, "user_id" integer, "start_date" datetime, "end_date" datetime, "required_role_id" integer DEFAULT 1 NOT NULL, "note" text, "position" integer, "draft" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "url" varchar(255))xC!indexindex_news_posts_on_user_idnews_posts!CREATE INDEX "index_news_posts_on_user_id" ON "news_posts" ("user_id")[tableversionsversions"CREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime) [Gindexindex_versions_on_item_type_and_item_idversions#CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")^!))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)"K))indexindex_user_has_roles_on_user_iduser_has_roles%CREATE INDEX "index_user_has_roles_on_user_id" ON "user_has_roles" ("user_id")#K))indexindex_user_has_roles_on_role_iduser_has_roles'CREATE INDEX "index_user_has_roles_on_role_id" ON "user_has_roles" ("role_id")}$%%=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")n(;indexindex_users_on_usernameusers,CREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")z)C'indexindex_users_on_unlock_tokenusers-CREATE UNIQUE INDEX "index_users_on_unlock_token" ON "users" ("unlock_token")//tableuser_import_filesuser_import_files.CREATE 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) <;q"_zX  QWq x      user4 user3 user2!librarian2 user1!librarian1 admin          g  ^ G }._b,Wtableprofilesprofiles0CREATE 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)z6E9indexindex_user_export_file_transitions_on_sort_key_and_file_iduser_export_file_transitions:CREATE UNIQUE INDEX "index_user_export_file_transitions_on_sort_key_and_file_id" ON "user_export_file_transitions" ("sort_key", "user_export_file_id")L5gEyindexindex_user_export_file_transitions_on_file_iduser_export_file_transitions9CREATE INDEX "index_user_export_file_transitions_on_file_id" ON "user_export_file_transitions" ("user_export_file_id")L4EEtableuser_export_file_transitionsuser_export_file_transitions8CREATE 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)3//-tableuser_export_filesuser_export_files7CREATE 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)]25}indexindex_users_on_emailusersCREATE INDEX "index_users_on_email" ON "users" ("email")+333tableuser_import_resultsuser_import_results/CREATE 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)n)tableprofilesprofiles0CREATE 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)p-?indexindex_profiles_on_user_idprofiles1CREATE INDEX "index_profiles_on_user_id" ON "profiles" ("user_id").G/indexindex_profiles_on_user_numberprofiles2CREATE UNIQUE INDEX "index_profiles_on_user_number" ON "profiles" ("user_number")L/EEtableuser_import_file_transitionsuser_import_file_transitions3CREATE 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)d0Eindexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitions4CREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id")z1E9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitions5CREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")