SQLite format 3@ %%.8T}fxrl`Z~TN SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")\ tableusersusers CREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "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, "last_sign_in_ip" varchar, "created_at" datetime, "updated_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_idagents CREATE 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, "middle_name" varchar, "first_name" varchar, "last_name_transcription" varchar, "middle_name_transcription" varchar, "first_name_transcription" varchar, "corporate_name" varchar, "corporate_name_transcription" varchar, "full_name" varchar, "full_name_transcription" text, "full_name_alternative" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "zip_code_1" varchar, "zip_code_2" varchar, "address_1" text, "address_2" text, "address_1_note" text, "address_2_note" text, "telephone_number_1" varchar, "telephone_number_2" varchar, "fax_number_1" varchar, "fax_number_2" varchar, "other_designation" text, "place" text, "postal_code" varchar, "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, "email" text, "url" text)N55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschem~yH\VK@@+7yExeGpj Ddlہ[ȁKC3v0q$t|g?SH1F?d|ung`YRKD=6/(! ucQ?- y g U C 1  } k Y G 5 #  o ] K 9 '   s a O = +   w e S A /  vcP=*lYF3  ubO<)~kXE2 taN;(}jWD1 s`M:'^)20151126005552])20151125004028\)20150925092505[)20150924115059Z)20150923173139Y)20150506105356X)20150421023923W)20150221063719V)20150117111136U)20150106001709T)20141020120523S)20141014065831R)20141003182825Q)20141003181336P)20140823095740O)20140823094847N)20140823083524M)20140822114527L)20140821151023K)20140814070854J)20140813182425I)20140812153137H)20140812152348G)20140812093836F)20140811031145E)20140810091417D)20140810091231C)20140810061942B)20140802082007A)20140721151416@)20140720192418?)20140720170735>)20140720170714=)20140720140916<)20140709113905;)20140709113413:)201406280735359)201406280735248)201406280722177)201406280717196)201406141415005)201406140654044)201406101234393)201405280456172)201405280456001)201405280455390)20140528045518/)20140524135607.)20140524074813-)20140524020735,)20140523171309+)20140519171220*)20140519170214))20140518135713()20140518111006')20140518050147&)20140122054321%)20140110131010$)20140110122216#)20130519065837")20130519065638!)20130509185724 )20130506175834)20130506175303)20130504195916)20130504143515)20130504133816)20130429020822)20130421164124)20130421155019)20130421093852)20130416054135)20130412083556)20130304015019)20130303124821)20130221154434)20121116031206)20120602141129)20120511072422)20120510140958)20120424103932 )20120418081407 )20120415164821 )20120415060342 )20120413170734 )20120413170720)20120413170705)20120413161403)20120413161340)20120413100431)20120413100352)20120413072700)20120413051535)20120410104851)20120406020752)20120319173203~)20120319120638})20120129020544|)20120129014038{)20120125152919z)20120125050502y)20120105074911x)20111218002349w)20111217234412v)20111129044509u)20111124112131t)20111124110355s)20111124110319r)20111124110059q)20110918162329p)20110916103953o)20110916091020n)20110913120629m)20110913115320l)20110627122938k)20110627035057j)20110627034940i)20110621093332h)20110620173525g)20110619064807f)20110603184217e)20110328130826d)20110318183304c)20110301134521b)20110301121550a)20110301035123`)20110222073537_)20101212070145^)20100925074639])20100925074559\)20100925043847[)20100814091104Z)20100607044753Y)20100606073747X)20100606065209W)20100525171356V)20100525124311U)20100321235924T)20100314190054S)20100223121519R)20100222124420Q)20100211105551P)20100129142347O)20091214131723N)20091202124834M)20091025080447L)20091012101112K)20090831220301J)20090812151902I)20090720091429H)20090720091106G)20090706125521F)20090705212043E)20090705133942D)20090519203307C)20090321130448B)20081220034117A)20081220023628@)20081216190724?)20081216190517>)20081215094955=)20081215094302<)20081212151820;)20081212151614:)200812120800389)200812120755548)200811171434557)200811171431566)200810300236155)200810300235184)200810300234123)200810280936072)200810280832081)200810280831420)20081027150907/)20081025083905.)20081025083323-)20081023092436,)20081006093246+)20081006090811*)20080905191442))20080830154109()20080819181903'154&149%146$145#144"142!134 1331321311301291271251241211201171141131128077736959 55 47 41 35 333229151265c^Vog_WOG?7/'mZG4! v c P = *    l Y F 3 u b O < )   ~ k X E 2  t a N ; (  }jWC/{gS?+wcO;'s_K7#o[G3 kWC/{gS?+)20141020120523)20141014065831)20141003182825)20141003181336)20140823095740)20140823094847)20140823083524)20140822114527)20140821151023)20140814070854)20140813182425)20140812153137)20140812152348)20140812093836)20140811031145)20140810091417)20140810091231)20140810061942)20140802082007)20140721151416)20140720192418)20140720170735)20140720170714)20140720140916)20140709113905)20140709113413)20140628073535)20140628073524)20140628072217)20140628071719)20140614141500)20140614065404)20140610123439)20140528045617)20140528045600)20140528045539)20140528045518)20140524135607)20140524074813)20140524020735)20140523171309)20140519171220)20140519170214)20140518135713)20140518111006)20140518050147)20140122054321)20140110131010)20140110122216)20130519065837)20130519065638)20130509185724)20130506175834)20130506175303)20130504195916)20130504143515)20130504133816)20130429020822)20130421164124)20130421155019)20130421093852)20130416054135)20130412083556)20130304015019)20130303124821)20130221154434)20121116031206)20120602141129)20120511072422)20120510140958)20120424103932)20120418081407)20120415164821)20120415060342)20120413170734)20120413170720)20120413170705)20120413161403)20120413161340)20120413100431)20120413100352)20120413072700)20120413051535)20120410104851)20120406020752)20120319173203)20120319120638~)20120129020544})20120129014038|)20120125152919{)20120125050502z)20120105074911y)20111218002349x)20111217234412w)20111129044509v)20111124112131u)20111124110355t)20111124110319s)20111124110059r)20110918162329q)20110916103953p)20110916091020o)20110913120629n)20110913115320m)20110627122938l)20110627035057k)20110627034940j)20110621093332i)20110620173525h)20110619064807g)20110603184217f)20110328130826e)20110318183304d)20110301134521c)20110301121550b)20110301035123a)20110222073537`)20101212070145_)20100925074639^)20100925074559])20100925043847\)20100814091104[)20100607044753Z)20100606073747Y)20100606065209X)20100525171356W)20100525124311V)20100321235924U)20100314190054T)20100223121519S)20100222124420R)20100211105551Q)20100129142347P)20091214131723O)20091202124834N)20091025080447M)20091012101112L)20090831220301K)20090812151902J)20090720091429I)20090720091106H)20090706125521G)20090705212043F)20090705133942E)20090519203307D)20090321130448C)20081220034117B)20081220023628A)20081216190724@)20081216190517?)20081215094955>)20081215094302=)20081212151820<)20081212151614;)20081212080038:)200812120755549)200811171434558)200811171431567)200810300236156)200810300235185)200810300234124)200810280936073)200810280832082)200810280831421)200810271509070)20081025083905/)20081025083323.)20081023092436-)20081006093246,)20081006090811+)20080905191442*)20080830154109))20080819181903(154'149&146%145$144#142"134!133 132131130129127125124121120117114113112807773695955 47 41 35 33 32291512U)20120319120638~ H#AAenvironmenttest2019-07-28 16:12:42.4419912019-07-28 16:12:42.441991 # environment           bCr)3:b5]x Otableusersusers CREATE TABLE "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "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, "last_sign_in_ip" varchar, "created_at" datetime, "updated_at" datetime, "save_checkout_history" boolean DEFAULT 0 NOT NULL, "checkout_icalendar_token" varchar, "username" varchar, "deleted_at" datetime, "expired_at" datetime, "failed_attempts" integer DEFAULT 0, "unlock_token" varchar, "locked_at" datetime, "confirmed_at" datetime, "profile_id" integer)U tableownsownsCREATE TABLE "owns" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "item_id" integer NOT NULL, "position" integer, "created_at" datetime, "updated_at" datetime) SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")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_idagents CREATE 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)+1tableagentsagentsCREATE TABLE "agents" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "last_name" varchar, "middle_name" varchar, "first_name" varchar, "last_name_transcription" varchar, "middle_name_transcription" varchar, "first_name_transcription" varchar, "corporate_name" varchar, "corporate_name_transcription" varchar, "full_name" varchar, "full_name_transcription" text, "full_name_alternative" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "zip_code_1" varchar, "zip_code_2" varchar, "address_1" text, "address_2" text, "address_1_note" text, "address_2_note" text, "telephone_number_1" varchar, "telephone_number_2" varchar, "fax_number_1" varchar, "fax_number_2" varchar, "other_designation" text, "place" text, "postal_code" varchar, "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, "email" text, "url" text, "full_name_alternative_transcription" text, "birth_date" varchar, "death_date" varchar, "agent_identifier" varchar, "profile_id" integer)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)  ; t l  #> r ;K)indexindex_checkouts_on_librarian_idcheckouts/CREATE INDEX "index_checkouts_on_librarian_id" ON "checkouts" ("librarian_id") ;|G!indexindex_checkouts_on_checkin_idcheckouts.CREATE INDEX "index_checkouts_on_checkin_id" ON "checkouts" ("checkin_id") ;Aindexindex_checkouts_on_item_idcheckouts-CREATE INDEX "index_checkouts_on_item_id" ON "checkouts" ("item_id") ;Aindexindex_checkouts_on_user_idcheckouts,CREATE INDEX "index_checkouts_on_user_id" ON "checkouts" ("user_id") ;5tablecheckoutscheckouts+CREATE TABLE "checkouts" ("id" integer PRIMARY KEY AUTOINCREMENw?''-tablecarrier_typescarrier_typesDCREATE TABLE "carrier_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime, "attachment_file_name" varchar, "attachment_content_type" varchar, "attachment_file_size" integer, "attachment_updated_at" datetime)8S9indexindex_bookmarks_on_manifestation_idbookmarks  B     U p ] @ */0sAMindexindex_import_request_transitions_parent_most_recentimport_request_transitionsoCREATE UNIQUE INDEX "index_import_request_transitions_parent_most_recent" ON "import_request_transitions" ("import_request_id", "most_recent") WHERE most_recentwA3indexindex_import_request_transitions_on_sort_key_and_request_idimport_request_transitionsCREATE UNIQUE INDEX "index_import_request_transitions_on_sort_key_and_request_id" ON "import_request_transitions" ("sort_key", "import_request_id")WwAindexindex_import_request_transitions_on_import_request_idimport_request_transitionsCREATE INDEX "index_import_request_transitions_on_import_request_id" ON "import_request_transitions" ("import_request_id")xG?indexindex_agent_import_file_transitions_on_sort_key_and_file_idagent_import_file_transitions!CREATE UNIQUE INDEX "index_agent_import_file_transitions_on_sort_key_and_file_id" ON "agent_import_file_transitions" ("sort_key", "agent_import_file_id")AA tableimport_request_transitionsimport_request_transitionsCREATE TABLE "import_request_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "import_request_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)Mqindexindex_resource_export_file_transitions_parent_most_recentresource_export_file_transitionsnCREATE UNIQUE INDEX "index_resource_export_file_transitions_parent_most_recent" ON "resource_export_file_transitions" ("resource_export_file_id", "most_recent") WHERE most_recent MQindexindex_resource_export_file_transitions_on_sort_key_and_file_idresource_export_file_transitions9CREATE UNIQUE INDEX "index_resource_export_file_transitions_on_sort_key_and_file_id" ON "resource_export_file_transitions" ("sort_key", "resource_export_file_id")aoMindexindex_resource_export_file_transitions_on_file_idresource_export_file_transitions8CREATE INDEX "index_resource_export_file_transitions_on_file_id" ON "resource_export_file_transitions" ("resource_export_file_id")~MM#tableresource_export_file_transitionsresource_export_file_transitions6CREATE TABLE "resource_export_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "resource_export_file_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)}Mqindexindex_resource_import_file_transitions_parent_most_recentresource_import_file_transitionsmCREATE UNIQUE INDEX "index_resource_import_file_transitions_parent_most_recent" ON "resource_import_file_transitions" ("resource_import_file_id", "most_recent") WHERE most_recent| MQindexindex_resource_import_file_transitions_on_sort_key_and_file_idresource_import_file_transitionsCREATE UNIQUE INDEX "index_resource_import_file_transitions_on_sort_key_and_file_id" ON "resource_import_file_transitions" ("sort_key", "resource_import_file_id")a{oMindexindex_resource_import_file_transitions_on_file_idresource_import_file_transitionsCREATE INDEX "index_resource_import_file_transitions_on_file_id" ON "resource_import_file_transitions" ("resource_import_file_id")zMM#tableresource_import_file_transitionsresource_import_file_transitionsCREATE TABLE "resource_import_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "resource_import_file_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL) yyG_indexindex_agent_import_file_transitions_parent_most_recentagent_import_file_transitionskCREATE UNIQUE INDEX "index_agent_import_file_transitions_parent_most_recent" ON "agent_import_file_transitions" ("agent_import_file_id", "most_recent") WHERE most_recent        N  A@> Z fXK''otablechecked_itemschecked_itemsPCREATE TABLE "checked_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "basket_id" integer NOT NULL, "librarian_id" integer, "due_date" datetime NOT NULL, "created_at" datetime, "updated_at" datetime, "user_id" integer, CONSTRAINT "fk_rails_0a55ff4187" FOREIGN KEY ("item_id") REFERENCES "items" ("id") , CONSTRAINT "fk_rails_5f4cea06ac" FOREIGN KEY ("basket_id") REFERENCES "baskets" ("id") )UVw?indexindex_item_has_use_restrictions_on_use_restriction_iditem_has_use_restrictions\CREATE INDEX "index_item_has_use_restrictions_on_use_restriction_id" ON "item_has_use_restrictions" ("use_restriction_id"){G--)tableevent_categoriesevent_categoriesLCREATE TABLE "event_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)tablebasketsbasketsNCREATE 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)rH''#tableform_of_worksform_of_worksMCREATE TABLE "form_of_works" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)4Ua?Uindexindex_item_has_use_restrictions_on_item_iditem_has_use_restrictions[CREATE INDEX "index_item_has_use_restrictions_on_item_id" ON "item_has_use_restrictions" ("item_id")NT??+tableitem_has_use_restrictionsitem_has_use_restrictionsZCREATE TABLE "item_has_use_restrictions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "use_restriction_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime, CONSTRAINT "fk_rails_55699b8e85" FOREIGN KEY ("item_id") REFERENCES "items" ("id") , CONSTRAINT "fk_rails_cebd572a19" FOREIGN KEY ("use_restriction_id") REFERENCES "use_restrictions" ("id") ){S--)tableuse_restrictionsuse_restrictionsYCREATE TABLE "use_restrictions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)lR= indexindex_donates_on_item_iddonatesXCREATE INDEX "index_donates_on_item_id" ON "donates" ("item_id")oQ?indexindex_donates_on_agent_iddonatesWCREATE INDEX "index_donates_on_agent_id" ON "donates" ("agent_id")JPktabledonatesdonatesVCREATE TABLE "donates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "item_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)MO!!etablebookstoresbookstoresUCREATE TABLE "bookstores" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" text NOT NULL, "zip_code" varchar, "address" text, "note" text, "telephone_number" varchar, "fax_number" varchar, "url" varchar, "position" integer, "deleted_at" datetime, "created_at" datetime, "updated_at" datetime)NS'9indexindex_checked_items_on_librarian_idchecked_itemsTCREATE INDEX "index_checked_items_on_librarian_id" ON "checked_items" ("librarian_id") MM'-indexindex_checked_items_on_basket_idchecked_itemsSCREATE INDEX "index_checked_items_on_basket_id" ON "checked_items" ("basket_id")LI'%indexindex_checked_items_on_item_idchecked_itemsRCREATE INDEX "index_checked_items_on_item_id" ON "checked_items" ("item_id")n= indexindex_baskets_on_user_idbasketsOCREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")           { M : $v2{G!));tablesearch_enginessearch_enginesCREATE TABLE "search_engines" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "url" varchar NOT NULL, "base_url" text NOT NULL, "http_method" text NOT NULL, "query_param" text NOT NULL, "additional_param" text DEFAULT NULL, +V''tablerequest_typesrequest_types^CREATE TABLE "request_types" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "note" text DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)LM-indexindex_colors_on_library_group_idcolorsMCREATE INDEX "index_colors_on_library_group_id" ON "colors" ("library_group_id")@U55#tablerequest_status_typesrequest_status_types]CREATE TABLE "request_status_types" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "note" text DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)TE)+indexindex_library_groups_on_namelibrary_groupswCREATE UNIQUE INDEX "index_library_groups_on_name" ON "library_groups" ("name") SK))indexindex_library_groups_on_user_idlibrary_groupstCREATE INDEX "index_library_groups_on_user_id" ON "library_groups" ("user_id")RQ)5indexindex_library_groups_on_short_namelibrary_groupsfCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")Q))utablelibrary_groupslibrary_groupsFCREATE TABLE "library_groups" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "short_name" varchar NOT NULL, "my_networks" text DEFAULT NULL, "old_login_banner" text DEFAULT NULL, "note" text DEFAULT NULL, "country_id" integer DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "admin_networks" text DEFAULT NULL, "allow_bookmark_external_url" boolean DEFAULT 0 NOT NULL, "url" varchar DEFAULT 'http://localhost:3000/', "settings" text DEFAULT NULL, "html_snippet" text DEFAULT NULL, "book_jacket_source" varchar DEFAULT NULL, "max_number_of_results" integer DEFAULT 500, "family_name_first" boolean DEFAULT 1, "screenshot_generator" varchar DEFAULT NULL, "pub_year_facet_range_interval" integer DEFAULT 10, "user_id" integer DEFAULT NULL, "csv_charset_conversion" boolean DEFAULT 0 NOT NULL, "header_logo_file_name" varchar DEFAULT NULL, "header_logo_content_type" varchar DEFAULT NULL, "header_logo_file_size" integer DEFAULT NULL, "header_logo_updated_at" datetime DEFAULT NULL, "header_logo_meta" text DEFAULT NULL)rP;indexindex_libraries_on_namelibrariesQCREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")}OG!indexindex_libraries_on_country_idlibrariesACREATE INDEX "index_libraries_on_country_id" ON "libraries" ("country_id")NS9indexindex_libraries_on_library_group_idlibraries@CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")/M-tablelibrarieslibraries>CREATE TABLE "libraries" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "short_display_name" varchar NOT NULL, "zip_code" varchar DEFAULT NULL, "street" text DEFAULT NULL, "locality" text DEFAULT NULL, "region" text DEFAULT NULL, "telephone_number_1" varchar DEFAULT NULL, "telephone_number_2" varchar DEFAULT NULL, "fax_number" varchar DEFAULT NULL, "note" text DEFAULT NULL, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar DEFAULT '|' NOT NULL, "library_group_id" integer NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer DEFAULT 1 NOT NULL, "country_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "opening_hour" text DEFAULT NULL, "isil" varchar DEFAULT NULL, "latitude" float DEFAULT NULL, "longitude" float DEFAULT NULL)       [ZZ g hm^++tableclassificationsclassificationseCREATE TABLE "classifications" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "category" varchar NOT NULL, "note" text, "classification_type_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime, "lft" integer, "rgt" integer, "manifestation_id" integer, "url" varchar, "label" varchar)_gtablemessagesmessagesnCREATE TABLE "messages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "read_at" datetime, "receiver_id" integer, "sender_id" integer, "subject" varchar NOT NULL, "body" text, "message_request_id" integer, "parent_id" integer, "created_at" datetime, "updated_at" datetime, "lft" integer, "rgt" integer, "depth" integer)fO/?indexindex_message_templates_on_statusmessage_templatesmCREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status")551tablerequest_status_typesrequest_status_types]CREATE TABLE "request_status_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)rX''#tablerequest_typesrequest_types^CREATE TABLE "request_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime) c773tablesubject_heading_typessubject_heading_typesjCREATE TABLE "subject_heading_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)b551tableclassification_typesclassification_typesiCREATE TABLE "classification_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)9ak+iindexindex_classifications_on_classification_type_idclassificationshCREATE INDEX "index_classifications_on_classification_type_id" ON "classifications" ("classification_type_id")`O+1indexindex_classifications_on_categoryclassificationsgCREATE INDEX "index_classifications_on_category" ON "classifications" ("category")_Q+5indexindex_classifications_on_parent_idclassificationsfCREATE INDEX "index_classifications_on_parent_id" ON "classifications" ("parent_id")@]///tableagent_merge_listsagent_merge_listsdCREATE TABLE "agent_merge_lists" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "created_at" datetime, "updated_at" datetime)$\_%Qindexindex_agent_merges_on_agent_merge_list_idagent_mergesbCREATE INDEX "index_agent_merges_on_agent_merge_list_id" ON "agent_merges" ("agent_merge_list_id")[I%%indexindex_agent_merges_on_agent_idagent_mergesaCREATE INDEX "index_agent_merges_on_agent_id" ON "agent_merges" ("agent_id")eZ%% tableagent_mergesagent_merges`CREATE TABLE "agent_merges" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "agent_merge_list_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)Y551tablecirculation_statusescirculation_statuses_CREATE TABLE "circulation_statuses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)*e//tablemessage_templatesmessage_templateslCREATE TABLE "message_templates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar NOT NULL, "title" text NOT NULL, "body" text NOT NULL, "position" integer, "locale" varchar DEFAULT 'en', "created_at" datetime, "updated_at" datetime)rd''#tablesubject_typessubject_typeskCREATE TABLE "subject_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)                 tv D ` q}  4 Eindexindex_languages_on_iso_639_2languagesCREATE INDEX "index_languages_on_iso_639ktablelanmWtablerealizesrealizesuCREATE TABLE "realizes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "expression_id" integer NOT NULL, "position" integer, "created_at" datetime, "updated_at" datetime, "realize_type_id" integer)u{Aindexindex_countries_on_alpha_3countriesCREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")uzAindexindex_countries_on_alpha_2countriesCREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")ly; indexindex_countries_on_namecountriesCREATE INDEX "index_countries_on_name" ON "countries" ("name")vhCindexindex_messages_on_sender_idmessagesoCREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")tx5tablecountriescountriesCREATE TABLE "countries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "alpha_2" varchar, "alpha_3" varchar, "numeric_3" varchar, "note" text, "position" integer) Z))/tablesearch_enginessearch_enginesCREATE TABLE "search_engines" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "url" varchar 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) ZC!indexindex_subscribes_on_work_idsubscribes~CREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id") ZS!9indexindex_subscribes_on_subscription_idsubscribes}CREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id") Z!!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)sU'=indexindex_subscriptions_on_order_list_idsubscriptions{CREATE INDEX "index_subscriptions_on_order_list_id" ON "subscriptions" ("order_list_id") ZI'%indexindex_subscriptions_on_user_idsubscriptionszCREATE INDEX "index_subscriptions_on_user_id" ON "subscriptions" ("user_id") Z<''1tablesubscriptionssubscriptionsyCREATE 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)lp##tableagent_typesagent_typesxCREATE TABLE "agent_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)oK)indexindex_realizes_on_expression_idrealizeswCREATE INDEX "index_realizes_on_expression_id" ON "realizes" ("expression_id")snAindexindex_realizes_on_agent_idrealizesvCREATE INDEX "index_realizes_on_agent_id" ON "realizes" ("agent_id")m!tablerealizesrealizesuCREATE TABLE "realizes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "ag{|Eindexindex_countries_on_numeric_3countriesCREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")/l--tablemessage_requestsmessage_requestssCREATE 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, "updated_at" datetime)vkCindexindex_messages_on_parent_idmessagesrCREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")jU=indexindex_messages_on_message_request_idmessagesqCREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")|iG!indexindex_messages_on_receiver_idmessagespCREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")       zy   }|             y ~ 8 KI  ''ktablepicture_filespicture_filesCREATE TABLE "picture_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "picture_attachable_id" integer, "picture_attachable_type" varchar, "content_type" varchar, "title" text, "thumbnail" varchar, "position" integer, "created_at" datetime, "updated_at" datetime, "picture_file_name" varchar, "picture_content_type" varchar, "picture_file_size" integer, "picture_updated_at" datetime, "picture_meta" text, "picture_fingerprint" varchar, "picture_width" integer, "picture_height" integer)11ctableagent_import_filesagent_import_filesCREATE TABLE "agent_import_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar, "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "agent_import_file_name" varchar, "agent_import_content_type" varchar, "agent_import_file_size" integer, "agent_import_updated_at" datetime, "created_at" datetime, "updated_at" datetime, "agent_import_fingerprint" varchar, "error_message" text, "edit_mode" varchar, "user_encoding" varchar) n77Utableresource_import_filesresource_import_filesCREATE TABLE "resource_import_files" ("id" integerQ77?tableresource_import_filesresource_import_filesCREATE TABLE "resource_import_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar, "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "resource_import_file_name" varchar, "resource_import_content_type" varchar, "resource_import_file_size" integer, "resource_import_updated_at" datetime, "created_at" datetime, "updated_at" datetime, "edit_mode" varchar, "resource_import_fingerprint" varchar, "error_message" text, "user_encoding" varchar, "default_shelf_id" integer)% Y7Eindexindex_resource_import_files_on_user_idresource_import_filesCREATE INDEX "index_resource_import_files_on_user_id" ON "resource_import_files" ("user_id")+]7Mindexindex_resource_import_files_on_parent_idresource_import_filesCREATE INDEX "index_resource_import_files_on_parent_id" ON "resource_import_files" ("parent_id")S19indexindex_agent_import_files_on_user_idagent_import_filesCREATE INDEX "index_agent_import_files_on_user_id" ON "agent_import_files" ("user_id")W1Aindexindex_agent_import_files_on_parent_idagent_import_filesCREATE INDEX "index_agent_import_files_on_parent_id" ON "agent_import_files" ("parent_id")\w'%indexindex_picture_files_on_picture_attachable_id_and_typepicture_filesCREATE INDEX "index_picture_files_on_picture_attachable_id_and_type" ON "picture_files" ("picture_attachable_id", "picture_attachable_type")''tablepicture_filespicture_filesCREATE TABLE "picture_files" ("id" integer PRIMARY KEY AUTOINCE)indexindex_checkout_types_on_namecheckout_typesCREATE INDEX "index_checkout_types_on_name" ON "checkout_types" ("name")v ))%tablecheckout_typescheckout_typesCREATE TABLE "checkout_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime){Eindexindex_languages_on_iso_639_3languagesCREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3"){Eindexindex_languages_on_iso_639_2languagesCREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2"){Eindexindex_languages_on_iso_639_1languagesCREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")s~;indexindex_languages_on_namelanguagesCREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")}ktablelanguageslanguagesCREATE TABLE "languages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "native_name" varchar, "display_name" text, "iso_639_1" varchar, "iso_639_2" varchar, "iso_639_3" varchar, "note" text, "position" integer)               ggn p (++tableinventory_filesinventory_filesCREATE TABLE "inventory_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "filename" varchar, "content_type" varchar, "size" integer, "user_id" integer, "note" text, "created_at" datetime, "updated_at" datetime, "inventory_file_name" varchar, "inventory_content_type" varchar, "inventory_file_size" integer, "inventory_updated_at" datetime, "inventory_fingerprint" varchar)WGBMMutablebookmark_stat_has_manifestationsbookmark_stat_has_manifestationsCREATE TABLE "bookmark_stat_has_manifestations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "bookmark_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "bookmarks_count" integer, "created_at" datetime, "updated_at" datetime)))Ytablebookmark_statsbookmark_statsCREATE TABLE "bookmark_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "started_at" datetime, "completed_at" datetime, "note" text, "created_at" datetime, "updated_at" datetime)Y#Eindexindex_inventories_on_inventory_file_idinventoriesCREATE INDEX "index_inventories_on_inventory_file_id" ON "inventories" ("inventory_file_id")}E#indexindex_inventories_on_item_idinventoriesCREATE INDEX "index_inventories_on_item_id" ON "inventories" ("item_id")[##{tableinventoriesinventoriesCREATE TABLE "inventories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer, "inventory_file_id" integer, "note" text, "created_at" datetime, "updated_at" datetime) M+-indexindex_inventory_files_on_user_idinventory_filesCREATE INDEX "index_inventory_files_on_user_id" ON "inventory_files" ("user_id") p++Ctableinventory_filesinventory_filesCREATE TABLE "inventory_files" ("id" integer PRIMARY KEY AUTOINC3==9tableagent_relationship_typesagent_relationship_typesCREATE TABLE "agent_relationship_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)s2''#tablecontent_typescontent_typesCREATE TABLE "content_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)1995tablemedium_of_performancesmedium_of_performancesCREATE TABLE "medium_of_performances" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)0I%%indexindex_participates_on_agent_idparticipatesCREATE INDEX "index_participates_on_agent_id" ON "participates" ("agent_id")/I%%indexindex_participates_on_event_idparticipatesCREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id")o.%%tableparticipatesparticipatesCREATE TABLE "participates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "event_id" integer NOT NULL, "position" integer, "created_at" datetime, "updated_at" datetime)311tableuser_reserve_statsuser_reserve_statsCREATE TABLE "user_reserve_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime, "updated_at" datetime, "started_at" datetime, "completed_at" datetime, "user_id" integer)m!Mindexindex_bookmark_stat_has_manifestations_on_manifestation_idbookmark_stat_has_manifestationsCREATE INDEX "index_bookmark_stat_has_manifestations_on_manifestation_id" ON "bookmark_stat_has_manifestations" ("manifestation_id")m Mindexindex_bookmark_stat_has_manifestations_on_bookmark_stat_idbookmark_stat_has_manifestationsCREATE INDEX "index_bookmark_stat_has_manifestations_on_bookmark_stat_id" ON "bookmark_stat_has_manifestations" ("bookmark_stat_id")             7 P ff=6 NlQtablewithdrawswithdraws[CREATE TABLE "withdraws" ("id" integer NOT NULL PRIMARY KEY, "basket_)%% tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text NOT NULL, M-indexindex_colors_on_library_group_idcolorsMCREATE INDEX "index_colors_on_library_group_id" ON "colors" ("library_group_id")GH!!YtablebookstoresbookstoresUCREATE TABLE "bookstores" ("id" integer NOT NULL PRIMARY KEY, "name" text NOT NULL, "zip_code" varchar DEFAULT NULL, "address" text DEFAULT NULL, "note" text DEFAULT NULL, "telephone_number" varchar DEFAULT NULL, "fax_number" varchar DEFAULT NULL, "url" varchar DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "deleted_at" datetime DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL) ?#ind!KtablecolorscolorsLCREATE TABLE "colors" ("id" integer NOT NULL PRIMARY KEY, "library_group_id" integer DEFAULT NULL, "property" varchar NOT NULL, "code" varchar NOT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)JA%#indexindex_budget_types_on_namebudget_types>CREATE UNIQUE INDEX "index_budget_types_on_name" ON "budget_types" ("name")%I%% tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text NOT NULL, "note" text DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)=K)indexindex_withdraws_on_librarian_idwithdraws^CREATE INDEX "index_withdraws_on_librarian_id" ON "withdraws" ("librarian_id")u<Aindexindex_withdraws_on_item_idwithdraws]CREATE INDEX "index_withdraws_on_item_id" ON "withdraws" ("item_id"){;Eindexindex_withdraws_on_basket_idwithdraws\CREATE INDEX "index_withdraws_on_basket_id" ON "withdraws" ("basket_id"):Qtablewithdrawswithdraws[CREATE TABLE "withdraws" ("id" integer NOT NULL PRIMARY KEY, "basket_id" integer DEFAULT NULL, "item_id" integer DEFAULT NULL, "librarian_id" bigint DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)9U3=indexindex_user_import_results_on_user_iduser_import_resultsCREATE INDEX "index_user_import_results_on_user_id" ON "user_import_results" ("user_id")A8m3mindexindex_user_import_results_on_user_import_file_iduser_import_resultsCREATE INDEX "index_user_import_results_on_user_import_file_id" ON "user_import_results" ("user_import_file_id")J7339tableuser_import_resultsuser_import_resultsCREATE TABLE "user_import_results" ("id" integer NOT NULL PRIMARY KEY, "user_import_file_id" bigint DEFAULT NULL, "user_id" integer DEFAULT NULL, "body" text DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "error_message" text DEFAULT NULL)6Q/5indexindex_user_export_files_on_user_iduser_export_files;CREATE INDEX "index_user_export_files_on_user_id" ON "user_export_files" ("user_id")=5//'tableuser_export_filesuser_export_files:CREATE TABLE "user_export_files" ("id" integer NOT NULL PRIMARY KEY, "user_id" bigint DEFAULT NULL, "user_export_file_name" varchar DEFAULT NULL, "user_export_content_type" varchar DEFAULT NULL, "user_export_file_size" integer DEFAULT NULL, "user_export_updated_at" datetime DEFAULT NULL, "executed_at" datetime DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)4wEYindexindex_user_export_file_transitions_parent_most_recentuser_export_file_transitionsiCREATE UNIQUE INDEX "index_user_export_file_transitions_parent_most_recent" ON "user_export_file_transitions" ("user_export_file_id", "most_recent") WHERE most_recent{3E9indexindex_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")   ?  l\ QEEtablemanifestation_checkout_statsmanifestation3==9tableagent_relationship_typesagent_relationship_typesCREATE TABLE "agent_relationship_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)33 tableuser_checkout_statsuser_checkout_statsCREATE TABLE "user_checkout_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime, "updated_at" datetime, "started_at" datetime, "completed_at" datetime, "user_id" integer)Sy;indexindex_checkout_stat_has_users_on_user_checkout_stat_idcheckout_stat/I%%indexindex_participates_on_event_idparticipatesCREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id")Y#Eindexindex_inventories_on_inventory_file_idinventoriesCREATE INDEX "index_inventories_on_inventory_file_id" ON "inventories" ("inventory_file_id")}E#indexindex_inventories_on_item_idinventoriesCREATE INDEX "index_inventories_on_item_id" ON "inventories" ("item_id") SI;;tablecheckout_stat_has_userscheckout_stat_has_usersCREATE TA0I%%indexindex_participates_on_agent_idparticipatesCREATE INDEX "index_participates_on_agent_id" ON "participates" ("agent_id")/*11tableuser_reserve_statsuser_reserve_statsCREATE TABLE "user_reserve_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime, "updated_at" datetime, "started_at" datetime, "completed_at" datetime, "user_id" integer)m!Mindexindex_bookmark_stat_has_manifestations_on_manifestation_idbookmark_stat_has_manifestationsCREATE INDEX "index_bookmark_stat_has_manifestations_on_manifestation_id" ON "bookmark_stat_has_manifestations" ("manifestation_id")m Mindexindex_bookmark_stat_has_manifestations_on_bookmark_stat_idbookmark_stat_has_manifestationsCREATE INDEX "index_bookmark_stat_has_manifestations_on_bookmark_stat_id" ON "bookmark_stat_has_manifestations" ("bookmark_stat_id")BMMutablebookmark_stat_has_manifestationsbookmark_stat_has_manifestationsCREATE TABLE "bookmark_stat_has_manifestations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "bookmark_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "bookmarks_count" integer, "created_at" datetime, "updated_at" datetime)))Ytablebookmark_statsbookmark_statsCREATE TABLE "bookmark_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "started_at" datetime, "completed_at" datetime, "note" text, "created_at" datetime, "updated_at" datetime)Mindexindex_checkout_stat_has_manifestations_on_manifestation_idcheckout_stat_has_manifestationsCREATE INDEX "index_checkout_stat_has_manifestations_on_manifestatios2''#tablecontent_typescontent_typesCREATE TABLE "content_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)1995tablemedium_of_performancesmedium_of_performancesCREATE TABLE "medium_of_performances" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)o.%%tableparticipatesparticipatesCREATE TABLE "participates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "event_id" integer NOT NULL, "position" integer, "created_at" datetime, "updated_at" datetime)                T g3NCCtablemanifestation_reserve_statsmanifestation_reserve_statsCREATE TABLE "manifestation_reserve_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime, "updated_at" datetime, "started_at" datetime, "completed_at" datetime, "user_id" integer)311tableuser_reserve_statsuser_reserve_statsCREATE TABLE "user_reserve_stats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime, "updated_at" datetime, "started_at" datetime, "completed_at" datetime, "user_id" integer) ''#tablecontent_typescontent_typesCREATE TABLE "content_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)1995tablemedium_of_performancesmedium_of_performancesCREATE TABLE "medium_of_performances" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datet3C//tableseries_statementsseries_statementsCREATE TABLE "series_statements" ("id" integer NOT NULL PRIMARY KEY, "original_title" text DEFAULT NULL, "numbering" text DEFAULT NULL, "title_subseries" text DEFAULT NULL, "numbering_subseries" text DEFAULT NULL, "position" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar, "manifestation_id" integer, "note" text, "title_subseries_transcription" text, "creator_string" text, "volume_number_string" text, "volume_number_transcription_string" text, "series_master" boolean, "root_manifestation_id" integer) BM+-indexindex_import_requests_on_user_idimport_requestsCREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")(A_+Qindexindex_import_requests_on_manifestation_idimport_requestsCREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")@G+!indexindex_import_requests_on_isbnimport_requestsCREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")i?++tableimport_requestsimport_requestsCREATE TABLE "import_requests" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "isbn" varchar, "manifestation_id" integer, "user_id" integer, "created_at" datetime, "updated_at" datetime)=[Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")v<=tableversionsversionsCREATE TABLE "versions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "event" varchar NOT NULL, "whodunnit" varchar, "object" text, "created_at" datetime)g;tablelicenseslicensesCREATE TABLE "licenses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" varchar, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)M5s-indexindex_lending_policies_on_item_id_and_user_group_idlending_policiesCREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")T4--Ytablelending_policieslending_policiesCREATE TABLE "lending_policies" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "user_group_id" integer NOT NULL, "loan_period" integer DEFAULT 0 NOT NULL, "fixed_due_date" datetime, "renewal" integer DEFAULT 0 NOT NULL, "fine" integer DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime, CONSTRAINT "fk_rails_92c366588a" FOREIGN KEY ("item_id") REFERENCES "items" ("id") , CONSTRAINT "fk_rails_93dd58a5e9" FOREIGN KEY ("user_group_id") REFERENCES "user_groups" ("id") )        \L##Ytableuser_groupsuser_groupsECREATE TABLE "user_groups" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT ))]tablelibrary_groupslibrary_groupsFCREATE TABLE "library_groups" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "short_name" varchar NOT NULL, "my_networks" text, "login_banner" text, "note" text, "country_id" integer, "position" integer, "created__gtablemessagesmessagesnCREATE TABLE "messages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "read_at" datetime, "receiver_id" integer, "sender_id" integer, "subject" varchar NOT NULL, "body" text, "message_request_id" integer, "parent_id" integer, "created_at" datetime, "updated_at" datetime, "lft" integer, "rgt" integer, "depth" integer)fO/?indexindex_message_templates_on_statusmessage_templatesmCREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status")*e//tablemessage_templatesmessage_templateslCREATE TABLE "message_templates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar NOT NULL, "title" text NOT NULL, "body" text NOT NULL, "position" integer, "locale" varchar DEFAULT 'en', "created_at" datetime, "updated_at" datetime)_''#tablesubject_typessubject_typeskCREATE TABLE "subject_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)j773tablesubject_heading_typessubject_heading_typesjCREATE TABLE "subject_heading_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)]551tableclassification_typesclassification_typesiCREATE TABLE "classification_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)Sk+iindexindex_classifications_on_classification_type_idclassificationshCREATE INDEX "index_classifications_on_classification_type_id" ON "classifications" ("classification_type_id")O+1indexindex_classifications_on_categoryclassificationsgCREATE INDEX "index_classifications_on_category" ON "classifications" ("category")Q+5indexindex_classifications_on_parent_idclassificationsfCREATE INDEX "index_classifications_on_parent_id" ON "classifications" ("parent_id")p++tableclassificationsclassificationseCREATE TABLE "classifications" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "category" varchar NOT NULL, "note" text, "classification_type_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime, "lft" integer, "rgt" integer, "manifestation_id" integer, "url" varchar, "label" varchar)@]///tableagent_merge_listsagent_merge_listsdCREATE TABLE "agent_merge_lists" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "created_at" datetime, "updated_at" datetime)$\_%Qindexindex_agent_merges_on_agent_merge_list_idagent_mergesbCREATE INDEX "index_agent_merges_on_agent_merge_list_id" ON "agent_merges" ("agent_merge_list_id")[I%%indexindex_agent_merges_on_agent_idagent_mergesaCREATE INDEX "index_agent_merges_on_agent_id" ON "agent_merges" ("agent_id")eZ%% tableagent_mergesagent_merges`CREATE TABLE "agent_merges" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "agent_merge_list_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)Y551tablecirculation_statusescirculation_statuses_CREATE TABLE "circulation_statuses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)       yX))ytablemanifestationsmanifestationsCREATE TABLE "manifestations" ("id" integer NOT NULL PRIMARY KEY, "original_title" text NOT NULL, "title_alternative" text DEFAULT NULL, "title_transcription" text DEFAULT NULL, "classification_number" varchar DEFAULT NULL, "manifestation_identifier" varchar DEFAULT NULL, "date_of_publication" datetime DEFAULT NULL, "date_copyrighted" datetime DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "access_address" varchar DEFAULT NULL, "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "start_page" integer DEFAULT3C//tableseries_statementsseries_statementsCREATE TABLE "series_statements" ("id" integer NOT NULL PRIMARY KEY, "original_title" text DEFAULT NULL, "numbering" text DEFAULT NULL, "title_subseries" text DEFAULT NULL, "numbering_subseries" text DEFAULT NULL, "position" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar, "manifestation_id" integer, "note" text, "title_subseries_transcription" text, "creator_string" text, "volume_number_string" text, "volume_number_transcription_string" text, "series_master" boolean, "root_manifestation_id" integer) BM+-indexindex_import_requests_on_user_idimport_requestsCREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")(A_+Qindexindex_import_requests_on_manifestation_idimport_requestsCREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")@G+!indexindex_import_requests_on_isbnimport_requestsCREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")i?++tableimport_requestsimport_requestsCREATE TABLE "import_requests" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "isbn" varchar, "manifestation_id" integer, "user_id" integer, "created_at" datetime, "updated_at" datetime)=[Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")M5s-indexindex_lending_policies_on_item_id_and_user_group_idlending_policiesCREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")T4--Ytablelending_policieslending_policiesCREATE TABLE "lending_policies" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "user_group_id" integer NOT NULL, "loan_period" integer DEFAULT 0 NOT NULL, "fixed_due_date" datetime, "renewal" integer DEFAULT 0 NOT NULL, "fine" integer DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime, CONSTRAINT "fk_rails_92c366588a" FOREIGN KEY ("item_id") REFERENCES "items" ("id") , CONSTRAINT "fk_rails_93dd58a5e9" FOREIGN KEY ("user_group_id") REFERENCES "user_groups" ("id") ) c)Yindexindex_manifestations_on_date_of_publicationmanifestationsCREATE INDEX "index_manifestations_on_date_of_publication" ON "manifestations" ("date_of_publication")3==9tableagent_relationship_typesagent_relationship_typesCREATE TABLE "agent_relationship_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)Q)5indexv<=tableversionsversionsCREATE TABLE "versions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "event" varchar NOT NULL, "whodunnit" varchar, "object" text, "created_at" datetime)g;tablelicenseslicensesCREATE TABLE "licenses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" varchar, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)     % .sp%R//Itableseries_statementsseries_statementsCREATE TABLE "series_statements" ("id" integer NOT NULL PRIMARY KEY, "original_title" text DEFAULT NULL, "numbering" text DEFAULT NULL, "title_subseries" text DEFAULT NULL, "numbering_subseries" text DEFAULT NULL, "position" integer DEFAULT NULL, " //tableseries_statementsseries_statementsCREATE TABLE "series_statements" ("id" integer NOT NULL PRIMARY KEY, "original_title" text DEFAULT NULL, "numbering" text DEFAULT NULL, "title_subseries" text DEFAULT NULL, "numbering_subseries" text DEFAULT NULL, "position" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar, "manifestation_id" integer, "note" text, "title_subseries_transcription" text, "creator_string" text, "volume_number_string" text, "volume_number_transcription_string" text, "series_master" boolean, "root_manifestation_id" integer)VKindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")nJ= indexindex_taggings_on_tag_idtaggingsCREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")IOtabletaggingstaggingsCREATE TABLE "taggings" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_type" varchar, "taggable_id" integer, "tagger_type" varchar, "tagger_id" integer, "context" varchar, "created_at" datetime)7HOtabletagstagsCREATE TABLE "tags" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "name_transcription" varchar, "created_at" datetime, "updated_at" datetime)@GgCaindexindex_manifestation_relationships_on_child_idmanifestation_relationshipsCREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")CFiCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationshipsCREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")9ECCwtablemanifestation_relationshipsmanifestation_relationshipsCREATE TABLE "manifestation_relationships" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "manifestation_relationship_type_id" integer, "created_at" datetime, "updated_at" datetime, "position" integer)QDy/indexindex_series_statements_on_series_statement_identifierseries_statementsCREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")5M+-indexindex_import_requests_on_user_idimport_requestsCREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")(A_+Qindexindex_import_requests_on_manifestation_idimport_requestsCREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id")@G+!indexindex_import_requests_on_isbnimport_requestsCREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")i?++tableimport_requestsimport_requestsCREATE TABLE "import_requests" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "isbn" varchar, "manifestation_id" integer, "user_id" integer, "created_at" datetime, "updated_at" datetime)=[Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")v<=tableversionsversionsCREATE TABLE "versions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar NOT NULL, "item_id" integer NOT NULL, "event" varchar NOT NULL, "whodunnit" varchar, "object" text, "created_at" datetime)g;tablelicenseslicensesCREATE TABLE "licenses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" varchar, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)                    p< hp 7R;;tableresource_import_resultsresource_import_resultsCREATE TABLE "resource_import_results" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_import_file_id" integer, "manifestation_id" integer, "item_id" integer, "body" text, "created_at" datetime, "updated_at" datetime, "error_message" text)cQ5indexindex_reserves_on_manifestation_idreserves4CREATE INDEX "index_reserves_on_manifestation_id" ON "reserves" ("manifestation_id")?indexindex_reserves_on_user_idreserves3CREATE INDEX "index_reserves_on_user_id" ON "reserves" ("user_id")tablereservesreserves2CREATE TABLE "reserves" ("id" integer NOT NULL PRIMARY KEY, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer DEFAULT NULL, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "canceled_at" datetime DEFAULT NULL, "expired_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "expiration_notice_to_patron" boolean DEFAULT 0, "expiration_notice_to_library" boolean DEFAULT 0, "pickup_location_id" integer, "retained_at" datetime, "postponed_at" datetime, "lock_version" integer DEFAULT 0 NOT NULL) L))Stableuser_has_rolesuser_has_rolesCREATE TABLE "user_has_roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "role_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime, CONSTRAINT "fk_rails_24f17d1e0b" FOREIGN KEY ("user_id") REFERENCES "users" ("id") , CONSTRAINT "fk_rails_ca7f31327f" FOREIGN KEY ("role_id") REFERENCES "roles" ("id") )3Mc)eindexindex_user_has_roles_on_user_id_and_role_iduser_has_rolesCREATE UNIQUE INDEX "index_user_has_roles_on_user_id_and_role_id" ON "user_has_roles" ("user_id", "role_id")wCindexindex_items_on_bookstore_iditemsCREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")zW55tableevent_import_resultsevent_import_resultsCREATE TABLE "event_import_results" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "event_import_file_id" integer, "event_id" integer, "body" text, "created_at" datetime, "updated_at" datetime)zV55tableagent_import_resultsagent_import_resultsCREATE TABLE "agent_import_results" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_import_file_id" integer, "agent_id" integer, "body" text, "created_at" datetime, "updated_at" datetime)-U];Mindexindex_resource_import_results_on_item_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")HTo;qindexindex_resource_import_results_on_manifestation_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")]S}; indexindex_resource_import_results_on_resource_import_file_idresource_import_resultsCREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id"),QMMItablemanifestation_relationship_typesmanifestation_relationship_typesCREATE TABLE "manifestation_relationship_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime) PW3Aindexindex_agent_relationships_on_child_idagent_relationshipsCREATE INDEX "index_agent_relationships_on_child_id" ON "agent_relationships" ("child_id")#OY3Eindexindex_agent_relationships_on_parent_idagent_relationshipsCREATE INDEX "index_agent_relationships_on_parent_id" ON "agent_relationships" ("parent_id")N33Wtableagent_relationshipsagent_relationshipsCREATE TABLE "agent_relationships" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "agent_relationship_type_id" integer, "created_at" datetime, "updated_at" datetime, "position" integer)             5 J \n5711Mtableevent_import_filesevent_import_filesCREATE TABLE "event_import_files" ("id" integer NOT NULL PRIMARY KEY, "parent_id" integer DEFAULT NULL, "content_type" varchar DEFAULT NUl11Stableevent_import_filesevent_import_filesCREATE TABLE "event_import_files" ("id" integer NOT NULL PRIMARY KEY, "parent_id" integer DEFAULT NULL, "content_type" varchar DEFAULT NULL, "size" integer DEFAULT NULL, "user_id" integer DEFAULT NULL, "note" text DEFAULT NULL, "executed_at" datetime DEFAULT NULL, "event_import_file_name" varchar DEFAULT NULL, "event_import_content_type" varchar DEFAULT NULL, "event_import_file_size" integer DEFAULT NULL, "event_import_updated_at" datetime DEFAULT NULL, "edit_mode" varchar DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "event_import_fingerprint" varchar DEFAULT NULL, "error_message" text DEFAULT NULL, "user_encoding" varchar, "default_library_id" integer, "default_event_category_id" integer)&G!indexindex_accepts_on_librarian_idacceptsCREATE INDEX "index_accepts_on_librarian_id" ON "accepts" ("librarian_id")= indexindex_accepts_on_item_idacceptsCREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")LAindexindex_accepts_on_basket_idacceptsCREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")ytableacceptsacceptsCREATE TABLE "accepts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime, "updated_at" datetime)gg%%tablebudget_typesbudget_typesCREATE TABLE "budget_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)f[Windexindex_users_on_checkout_icalendar_tokenusersCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")U=indexindex_reserves_on_pickup_location_idreservesCREATE INDEX "index_reserves_on_pickup_location_id" ON "reserves" ("pickup_location_id")jd''tableproduce_typesproduce_typesCREATE TABLE "produce_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)jc''tablerealize_typesrealize_typesCREATE TABLE "realize_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)gb%%tablecreate_typescreate_typesCREATE TABLE "create_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime)0ac/Yindexindex_series_statements_on_manifestation_idseries_statementsCREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("manifestation_id")D`];{indexindex_series_statement_merges_on_list_idseries_statement_mergesCREATE INDEX "index_series_statement_merges_on_list_id" ON "series_statement_merges" ("series_statement_merge_list_id")Q_u;}indexindex_series_statement_merges_on_series_statement_idseries_statement_mergesCREATE INDEX "index_series_statement_merges_on_series_statement_id" ON "series_statement_merges" ("series_statement_id")^;;Otableseries_statement_mergesseries_statement_mergesCREATE TABLE "series_statement_merges" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "series_statement_id" integer NOT NULL, "series_statement_merge_list_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)b]EEEtableseries_statement_merge_listsseries_statement_merge_listsCREATE TABLE "series_statement_merge_lists" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "created_at" datetime, "updated_at" datetime)s?indexindex_reserves_on_item_idreserves5CREATE INDEX "index_reserves_on_item_id" ON "reserves" ("item_id")             TSRP    cR b U0t <tableprofilesprofilesCREATE TABLE "profiles" ("33;tableuser_import_resultsuser_import_resultsCREATE TABLE "user_import_results" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_import_file_id" integer, "user_id" integer, "body" text, "created_at" datetime, "updated_at" datetime, "error_message" text)Wm3mindexindex_user_import_results_on_user_import_file_iduser_import_resultsCREATE INDEX "index_user_import_results_on_user_import_file_id" ON "user_import_results" ("user_import_file_id")33tableuser_import_resultsuser_import_resultsCREATE TABLE "user_import_results" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_import_file_id" integer, "user_id" integer, "body" text, "created_at" datetime, "updated_at" datetime)}Q/5indexindex_user_import_files_on_user_iduser_import_filesCREATE INDEX "index_user_import_files_on_user_id" ON "user_import_files" ("user_id")mW1Aindexindex_event_import_files_on_parent_idevent_import_filesCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id") L!|//[tableuser_import_filesuser_import_filesCREATE TABLE "user_import_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "executed_at" datetime, "user_import_file_name" varchar, "user_import_content_type" varchar, "user_import_file_size" integer, "user_import_updated_at" datetime, "user_import_fingerprint" varchar, "edit_mode" varchar, "error_message" text, "created_at" datetime, "updated_at" datetime, "user_encoding" varchar, "default_library_id" integer, "default_user_group_id" integer){W#Aindexindex_identifiers_on_manifestation_ididentifiersCREATE INDEX "index_identifiers_on_manifestation_id" ON "identifiers" ("manifestation_id")8zm#kindexindex_identifiers_on_body_and_identifier_type_ididentifiersCREATE INDEX "index_identifiers_on_body_and_identifier_type_id" ON "identifiers" ("body", "identifier_type_id")!y##tableidentifiersidentifiersCREATE TABLE "identifiers" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar NOT NULL, "identifier_type_id" integer NOT NULL, "manifestation_id" integer, "primary" boolean, "position" integer, "created_at" datetime, "updated_at" datetime)sx--tableidentifier_typesidentifier_typesCREATE TABLE "identifier_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_name" text, "note" text, "position" integer, "created_at" datetime, "updated_at" datetime) K<_+Qindexindex_classifications_on_manifestation_idclassificationsCREATE INDEX "index_classifications_on_manifestation_id" ON "classifications" ("manifestation_id") vQ5indexindex_subjects_on_manifestation_idsubjectsCREATE INDEX "index_subjects_on_manifestation_id" ON "subjects" ("manifestation_id")?um/mindexindex_series_statements_on_root_manifestation_idseries_statementsCREATE INDEX "index_series_statements_on_root_manifestation_id" ON "series_statements" ("root_manifestation_id")K)indexindex_items_on_checkout_type_iditemsCREATE INDEX "index_items_on_checkout_type_id" ON "items" ("checkout_type_id")U=indexindex_items_on_circulation_status_iditemsCREATE INDEX "index_items_on_circulation_status_id" ON "items" ("circulation_status_id"){rC'indexindex_users_on_unlock_tokenusersCREATE UNIQUE INDEX "index_users_on_unlock_token" ON "users" ("unlock_token")oq;indexindex_users_on_usernameusersCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")pM-indexindex_agents_on_agent_identifieragentsCREATE INDEX "index_agents_on_agent_identifier" ON "agents" ("agent_identifier")I'%indexindex_checked_items_on_user_idchecked_itemsCREATE INDEX "index_checked_items_on_user_id" ON "checked_items" ("user_id")nS19indexindex_event_import_files_on_user_idevent_import_filesCREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id")     %$#"! hgfe      Ac ~ k N <A EEtableuser_import_file_transitionsuser_import_file_transitions"CREATE TABLE "user_import_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "user_import_file_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL) "K))indexindex_library_groups_on_user_idlibrary_groupsfCREATE INDEX "index_library_groups_on_user_id" ON "library_groups" ("user_id") Q)5indexindex_library_groups_on_short_namelibrary_groupsGCREATE INDEX "index_library_groups_on_short_name" ON "library_grwA3indexindex_import_request_transitions_on_sort_key_and_request_idimport_request_transitionsCREATE UNIQUE INDEX "index_import_request_transitions_on_sort_key_and_request_id" ON "import_request_transitions" ("sort_key", "import_request_id")WwAindexindex_import_request_transitions_on_import_request_idimport_request_transitionsCREATE INDEX "index_import_request_transitions_on_import_request_id" ON "import_request_transitions" ("import_request_id")AA tableimport_request_transitionsimport_request_transitionsCREATE TABLE "import_request_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "import_request_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)Mqindexindex_resource_export_file_transitions_parent_most_recentresource_export_file_transitionsnCREATE UNIQUE INDEX "index_resource_export_file_transitions_parent_most_recent" ON "resource_export_file_transitions" ("resource_export_file_id", "most_recent") WHERE most_recent MQindexindex_resource_export_file_transitions_on_sort_key_and_file_idresource_export_file_transitions9CREATE UNIQUE INDEX "index_resource_export_file_transitions_on_sort_key_and_file_id" ON "resource_export_file_transitions" ("sort_key", "resource_export_file_id")aoMindexindex_resource_export_file_transitions_on_file_idresource_export_file_transitions8CREATE INDEX "index_resource_export_file_transitions_on_file_id" ON "resource_export_file_transitions" ("resource_export_file_id")~MM#tableresource_export_file_transitionsresource_export_file_transitions6CREATE TABLE "resource_export_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "resource_export_file_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)}Mqindexindex_resource_import_file_transitions_parent_most_recentresource_import_file_transitionsmCREATE UNIQUE INDEX "index_resource_import_file_transitions_parent_most_recent" ON "resource_import_file_transitions" ("resource_import_file_id", "most_recent") WHERE most_recent| MQindexindex_resource_import_file_transitions_on_sort_key_and_file_idresource_import_file_transitionsCREATE UNIQUE INDEX "index_resource_import_file_transitions_on_sort_key_and_file_id" ON "resource_import_file_transitions" ("sort_key", "resource_import_file_id")a{oMindexindex_resource_import_file_transitions_on_file_idresource_import_file_transitionsCREATE INDEX "index_resource_import_file_transitions_on_file_id" ON "resource_import_file_transitions" ("resource_import_file_id")zMM#tableresource_import_file_transitionsresource_import_file_transitionsCREATE TABLE "resource_import_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "resource_import_file_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)          qvv AAtableimport_request_transitionsimport_request_transitionsCREATE TABLE "import_request_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "import_request_id" integer, "created_at" datetime, "updated_at" datetime, "most_recent" boolean)ns?yindexindex_bookmark_stat_transitions_on_bookmark_stat_idbookmark_stat_transitions&CREATE INDEX "index_bookmark_stat_transitions_on_bookmark_stat_id" ON "bookmark_stat_transitions" ("bookmark_stat_id")ME G?indexindex_user_reserve_stat_transitions_on_sort_key_and_stat_iduser_reserve_stat_transitions.CREATE UNIQUE INDEX "index_:@GGqtableevent_export_file_transitionsevent_export_file_transitionsICREATE TABLE "event_export_file_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "event_export_file_id" integer, "created_at" datetime, "updated_at" datetime)k?11tableevent_export_filesevent_export_filesGCREATE TABLE "event_export_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "event_export_file_name" varchar, "event_export_content_type" varchar, "event_export_file_size" integer, "event_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime, "updated_at" datetime) acindexindex_profiles_on_checkout_icalendar_tokenprofilesFCREATE UNIQUE INDEX "index_profiles_on_checkout_icalendar_token" ON "profiles" ("checkout_icalendar_token") >S19indexindex_user_reserve_stats_on_user_iduser_reserve_statsCCREATE INDEX "index_user_reserve_stats_on_user_id" ON "user_reserve_stats" ("user_id") U3=indexindex_user_checkout_stats_on_user_iduser_checkout_statsBCREATE INDEX "index_user_checkout_stats_on_user_id" ON "user_checkout_stats" ("user_id").77tableresource_export_filesresource_export_files5CREATE TABLE "resource_export_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "resource_export_file_name" varchar, "resource_export_content_type" varchar, "resource_export_file_size" integer, "resource_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime, "updated_at" datetime)k {?'indexindex_bookmark_stat_transitions_on_sort_key_and_stat_idbookmark_stat_transitions'CREATE UNIQUE INDEX "index_bookmark_stat_transitions_on_sort_key_and_stat_id" ON "bookmark_stat_transitions" ("sort_key", "bookmark_stat_id")G?indexindex_event_import_file_transitions_on_sort_key_and_file_idevent_import_file_transitionsCREATE UNIQUE INDEX "index_event_import_file_transitions_on_sort_key_and_file_id" ON "event_import_file_transitions" ("sort_key", "event_import_file_id")mGindexindex_event_import_file_transitions_on_event_import_file_idevent_import_file_transitionsCREATE INDEX "index_event_import_file_transitions_on_event_import_file_id" ON "event_import_file_transitions" ("event_import_file_id"):GGqtableevent_import_file_transitionsevent_import_file_transitionsCREATE TABLE "event_import_file_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "event_import_file_id" integer, "created_at" datetime, "updated_at" datetime)A3indexindex_import_request_transitions_on_sort_key_and_request_idimport_request_transitionsCREATE UNIQUE INDEX "index_impo]-5}indexindex_users_on_emailusers CREATE INDEX "index_users_on_email" ON "users" ("email")Ps?yindexindex_bookmark_stat_transitions_on_bookmark_stat_idbookmark_stat_transitions&CREATE INDEX "index_bookmark_stat_transitions_on_bookmark_stat_id" ON "bookmark_stat_transitions" ("bookmark_stat_id")*??atablebookmark_stat_transitionsbookmark_stat_transitions%CREATE TABLE "bookmark_stat_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "bookmark_stat_id" integer, "created_at" datetime, "updated_at" datetime)                 o "Q$GGtableuser_reserve_stat_transitionsuser_reserve_stat_transitions,CREATE TABLE "user_reserve_stat_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "user_reserve_stat_id" integer, "created_at" datetime, "updated_at" datetime, "most_recent" boolean)5}indexindex_users_on_emailusers CREATE INDEX "index_users_on_email" ON "users" ("email"),Yaindexindex_manifestation_reserve_stat_transitions_on_transitionmanifestation_reserve_stat_transitions4CREATE UNIQUE INDEX "index_manifestation_reserve_stat_transitions_on_transition" ON "manifestation_reserve_stat_transitions" ("sort_key", "manifestation_reserve_stat_id")+{Y5indexindex_manifestation_reserve_stat_transitions_on_stat_idmanifestation_reserve_stat_transitions3CREATE INDEX "index_manifestation_reserve_stat_transitions_on_stat_id" ON "manifestation_reserve_stat_transitions" ("manifestation_reserve_stat_id")u*YYCtablemanifestation_reserve_stat_transitionsmanifestation_reserve_stat_transitions2CREATE TABLE "manifestation_reserve_stat_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "manifestation_reserve_stat_id" integer, "Ps?yindexindex_bookmark_stat_transitions_on_bookmark_stat_idbookmark_stat_transitions&CREATE INDEX "index_bookmark_stat_transitions_on_bookmark_stat_id" ON "bookmark_stat_transitions" ("bookmark_stat_id")*??atablebookmark_stat_transitionsbookmark_stat_transitions%CREATE TABLE "bookmark_stat_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "bookmark_stat_id" integer, "created_at" datetime, "updated_at" datetime)E9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitions$CREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")Eindexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitions#CREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id")&G?indexindex_user_reserve_stat_transitions_on_sort_key_and_stat_iduser_reserve_stat_transitions.CREATE UNIQUE INDEX "index_user_reserve_stat_transitions_on_sort_key_and_stat_id" ON "user_reserve_stat_transitions" ("sort_key", "user_reserve_stat_id")m%Gindexindex_user_reserve_stat_transitions_on_user_reserve_stat_iduser_reserve_stat_transitions-CREATE INDEX "index_user_reserve_stat_transitions_on_user_reserve_stat_id" ON "user_reserve_stat_transitions" ("user_reserve_stat_id")#IEindexindex_user_checkout_stat_transitions_on_sort_key_and_stat_iduser_checkout_stat_transitions+CREATE UNIQUE INDEX "index_user_checkout_stat_transitions_on_sort_key_and_stat_id" ON "user_checkout_stat_transitions" ("sort_key", "user_checkout_stat_id")t"I!indexindex_user_checkout_stat_transitions_on_user_checkout_stat_iduser_checkout_stat_transitions*CREATE INDEX "index_user_checkout_stat_transitions_on_user_checkout_stat_id" ON "user_checkout_stat_transitions" ("user_checkout_stat_id")U!II#tableuser_checkout_stat_transitionsuser_checkout_stat_transitions(CREATE TABLE "user_checkout_stat_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "user_checkout_stat_id" integer, "created_at" datetime, "updated_at" datetime, "most_recent" boolean)k {?'indexindex_bookmark_stat_transitions_on_sort_key_and_stat_idbookmark_stat_transitions'CREATE UNIQUE INDEX "index_bookmark_stat_transitions_on_sort_key_and_stat_id" ON "bookmark_stat_transitions" ("sort_key", "bookmark_stat_id")            S } y_QE))]tablemanifestationsmanifestationsCREATE TABLE "manifestations" ("id" integer NOT NULL PRIMARY KEY, "original_title" text NOT NULL, "title_alternative" text DEFAULT NULL, "title_transcription" text DEFAULT NULL, "classification_number" varchar DEFAULT NULL, "manifestation_identifier" varchar DEFAULT NULL, "date_of_publication" datetime DEFAULT NULL, "date_copyrighted" datetime DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "access_address" varchar DEFAULT NULL, "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "start_page" integer DEFAULT NULL, "end_page" integer DEFAULT NULL, "height" integer DEFAULT NULL, "width" integer DEFAULT NULL, "depth" integer DEFAULT NULL, "price" integer DEFAULT NULL, "fulltext" text DEFAULT NULL, "volume_number_string" varchar DEFAULT NULL, "issue_number_string" varchar DEFAULT NULL, "serial_number_string" varchar DEFAULT NULL, "edition" integer DEFAULT NULL, "note" text DEFAULT NULL, "repository_content" boolean DEFAULT 0 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "frequency_id" integer DEFAULT 1 NOT NULL, "subscription_master" boolean DEFAULT 0 NOT NULL, "attachment_file_name" varchar DEFAULT NULL, "attachment_content_type" varchar DEFAULT NULL, "attachment_file_size" integer DEFAULT NULL, "attachment_updated_at" datetime DEFAULT NULL, "title_alternative_transcription" text DEFAULT NULL, "description" text DEFAULT NULL, "abstract" text DEFAULT NULL, "available_at" datetime DEFAULT NULL, "valid_until" datetime DEFAULT NULL, "date_submitted" datetime DEFAULT NULL, "date_accepted" datetime DEFAULT NULL, "date_captured" datetime DEFAULT NULL, "pub_date" varchar DEFAULT NULL, "edition_string" varchar DEFAULT NULL, "volume_number" integer DEFAULT NULL, "issue_number" integer DEFAULT NULL, "serial_number" integer DEFAULT NULL, "content_type_id" integer DEFAULT 1, "year_of_publication" integer DEFAULT NULL, "attachment_meta" text DEFAULT NULL, "month_of_publication" integer DEFAULT NULL, "fulltext_content" boolean DEFAULT NULL, "serial" boolean DEFAULT NULL, "statement_of_responsibility" text DEFAULT NULL, "publication_place" text DEFAULT NULL, "extent" text DEFAULT NULL, "dimensions" text DEFAULT NULL)oM-indexindex_colors_on_library_group_idcolorsMCREATE INDEX "index_colors_on_library_group_id" ON "colors" ("library_group_id")tablecolorscolorsLCREATE TABLE "colors" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "library_group_id" integer, "property" varchar, "code" varchar, "position" integer, "created_at" datetime, "updated_at" datetime)BG?indexindex_event_export_file_transitions_on_sort_key_and_file_idevent_export_file_transitionsKCREATE UNIQUE INDEX "index_event_export_file_transitions_on_sort_key_and_file_id" ON "event_export_file_transitions" ("sort_key", "event_export_file_id")RAiGindexindex_event_export_file_transitions_on_file_idevent_export_file_transitionsJCREATE INDEX "index_event_export_file_transitions_on_file_id" ON "event_export_file_transitions" ("event_export_file_id"):@GGqtableevent_export_file_transitionsevent_export_file_transitionsICREATE TABLE "event_export_file_transitions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar, "metadata" text DEFAULT '{}', "sort_key" integer, "event_export_file_id" integer, "created_at" datetime, "updated_at" datetime)11tabl;Gm)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")FY)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")     r10/66666666:k?11tableevent_export_filesevent_export_filesGCREATE TABLE "event_export_files" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "event_export_file_name" varchar, "event_export_content_type" varchar, "event_export_file_size" integer, "event_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime, "updated_at" datetime)+>acindexindex_profiles_on_checkout_icalendar_tokenprofilesFCREATE UNIQUE INDEX "index_profiles_on_checkout_icalendar_token" ON "profiles" ("checkout_icalendar_token")==eC]indexindex_manifestation_reserve_stats_on_user_idmanifestation_reserve_statsECREATE INDEX "index_manifestation_reserve_stats_on_user_id" ON "manifestation_reserve_stats" ("user_id")A<gEaindexindex_manifestation_checkout_stats_on_user_idmanifestation_checkout_statsDCREATE INDEX "index_manifestation_checkout_stats_on_user_id" ON "manifestation_checkout_stats" ("user_id");S19indexindex_user_reserve_stats_on_user_iduser_reserve_statsCCREATE INDEX "index_user_reserve_stats_on_user_id" ON "user_reserve_stats" ("user_id"):U3=indexindex_user_checkout_stats_on_user_iduser_checkout_statsBCREATE INDEX "index_user_checkout_stats_on_user_id" ON "user_checkout_stats" ("user_id") # E9indexindex_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") gEyindexindex_user_export_file_transitions_on_file_iduser_export_file_transitions>CREATE INDEX "index_user_export_file_transitions_on_file_id" ON "user_export_file_transitions" ("user_export_file_id"):Eindexindex_user_export_file_transitions_on_user_export_file_iduser_export_file_transitions=CREATE INDEX "index_user_export_file_transitions_on_user_export_file_id" ON "user_export_file_transitions" ("user_export_file_id")QEEtableuser_export_file_transitionsuser_export_file_transitionsCREATE INDEX "index_user_export_file_transitions_on_file_id" ON "user_export_file_transitions" ("user_export_file_id")gEindexindex_user_export_file_transitions_on_user_export_file_iduser_export_file_transitions=CREATE INDEX "index_user_export_file_transitions_on_user_export_file_id" ON "user_export_file_transitions" ("user_export_file_id")~EEtableuser_export_file_transitionsuser_export_file_transitions >D; K))indexindex_library_groups_on_user_idlibrary_groupsfCREATE INDEX "index_library_groups_on_user_id" ON "library_groups" ("user_id")AAtablelibrary_group_translationslibrary_group_transl yyG_indexindex_agent_import_file_transitions_parent_most_recentagent_import_file_transitionskCREATE UNIQUE INDEX "index_agent_import_file_transitions_parent_most_recent" ON "agent_import_file_transitions" ("agent_import_file_id", "most_recent") WHERE most_recent6[aAUindexindex_library_group_translations_on_localelibrary_group_translationsbCREATE INDEX "index_library_group_translations_on_locale" ON "library_group_translations" ("locale")P!!otableidentitiesidentitiesWCREATE TABLE "identities" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "email" varchar, "password_digest" varchar, "profile_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "provider" varchar)rXAindexindex_agents_on_profile_idagents_CREATE INDEX "index_agents_on_profile_id" ON "agents" ("profile_id") lK)indeXue3#indexindex_reserve_transitions_parent_most_recentreserve_transitionsjCREATE UNIQUE INDEX "index_reserve_transitions_parent_most_recent" ON "reserve_transitions" ("reserve_id", "most_recent") WHERE most_recent u3 indexindex_reserve_transitions_on_sort_key_and_reserve_idreserve_transitionsCREATE UNIQUE INDEX "index_reserve_transitions_on_sort_key_and_reserve_id" ON "reserve_transitions" ("sort_key", "reserve_id") [3Iindexindex_reserve_transitions_on_reserve_idreserve_transitions CREATE INDEX "index_reserve_transitions_on_reserve_id" ON "reserve_transitions" ("reserve_id")sS?!indexindex_identities_on_emailidentitiesZCREATE INDEX "index_identities_on_email" ON "identities" ("email")pR=! indexindex_identities_on_nameidentitiesYCREATE INDEX "index_identities_on_name" ON "identities" ("name")QI!%indexindex_identities_on_profile_ididentitiesXCREATE INDEX "index_identities_on_profile_id" ON "identities" ("profile_id")TZuA}indexindex_library_group_translations_on_library_group_idlibrary_group_translationsaCREATE INDEX "index_library_group_translations_on_library_group_id" ON "library_group_translations" ("library_group_id")Cindexindex_demands_on_message_iddemandsTCREATE INDEX "index_demands_on_message_id" ON "demands" ("message_id")= indexindex_demands_on_item_iddemandsSCREATE INDEX "index_dxG?indexindex_agent_import_file_transitions_on_sort_key_and_file_idagent_import_file_transitions!CREATE UNIQUE INDEX "index_agent_import_file_transitions_on_sort_key_and_file_id" ON "agent_import_file_transitions" ("sort_key", "agent_import_file_id")mwGindexindex_agent_import_file_transitions_on_agent_import_file_idagent_import_file_transitions CREATE INDEX "index_agent_import_file_transitions_on_agent_import_file_id" ON "agent_import_file_transitions" ("agent_import_file_id") vGGtableagent_import_file_transitionsagent_import_file_transitionsCREATE TABLE "agent_import_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "agent_import_file_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)-Ic)Yindexindex_manifestations_on_date_of_publicationmanifestationsNCREATE INDEX "index_manifestations_on_date_of_publication" ON "manifestations" ("date_of_publication")HQ)5indexindex_manifestations_on_updated_atmanifestationsCREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at")m)mindexindeHYAAtablelibrary_group_translationslibrary_group_translations`CREATE TABLE "library_group_translations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "library_group_id" integer NOT NULL, "locale" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "login_banner" text, "footer_banner" text)    :       J S 1[gindexindex_manifestation_checkout_stat_transitions_on_transitionmanifestation_checkout_stat_transitions1CREATE UNI l= indexindex_baskets_on_user_idbasketsOCREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id")YtablebasketsbasketsNCREATE TABLE "baskets" ("id" integer NOT NULL PRIMARY KEY, "user_id" bigint DEFAULT NULL, "note" text DEFAULT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)|G!indexindex_accepts_on_librarian_idacceptsCREATE INDEX "index_accepts_on_librarian_id" ON "accepts" ("librarian_id")m= indexindex_accepts_on_item_idacceptsCREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")sAindexindex_accepts_on_basket_idacceptsCREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")]tableacceptsacceptsCREATE TABLE "accepts" ("id" integer NOT NULL PRIMARY KEY, "basket_id" integer DEFAULT NULL, "item_id" integer DEFAULT NULL, "librarian_id" bigint DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)2 Yindexindex_manifestation_reserve_stat_transitions_parent_most_recenmanifestation_reserve_stat_transitionssCREATE UNIQUE INDEX "index_manifestation_reserve_stat_transitions_parent_most_recen" ON "manifestation_reserve_stat_transitions" ("manifestation_reserve_stat_id", "most_recent") WHERE most_recent yG_indexindex_user_reserve_stat_transitions_parent_most_recentuser_reserve_stat_transitionsqCREATE UNIQUE INDEX "index_user_reserve_stat_transitions_parent_most_recent" ON "user_reserve_stat_transitions" ("user_reserve_stat_id", "most_recent") WHERE most_recent/G?indexindex_user_reserve_stat_transitions_on_sort_key_and_stat_iduser_reserve_stat_transitions.CREATE UNIQUE INDEX "index_user_reserve_stat_transitions_on_sort_key_and_stat_id" ON "user_reserve_stat_transitions" ("sort_keye+Eindexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitions#CREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id")*EEtableuser_import_file_transitionsuser_import_file_transitions"CREATE TABLE "user_import_file_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "user_import_file_id" bigint DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL))U'=indexindex_subscriptions_on_order_list_idsubscriptions{CREATE INDEX "index_subscriptions_on_order_list_id" ON "subscriptions" ("order_list_id")(I'%indexindex_subscriptions_on_user_idsubscriptionszCREATE INDEX "index_subscriptions_on_user_id" ON "subscriptions" ("user_id")x'''/tablesubscriptionssubscriptionsyCREATE TABLE "subscriptions" ("id" integer NOT NULL PRIMARY KEY, "title" text NOT NULL, "note" text DEFAULT NULL, "user_id" bigint DEFAULT NULL, "order_list_id" integer DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "subscribes_count" integer DEFAULT 0 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)x&C!indexindex_subscribes_on_work_idsubscribes~CREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id")%S!9indexindex_subscribes_on_subscription_idsubscribes}CREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id")$!! tablesubscribessubscribes|CREATE TABLE "subscribes" ("id" integer NOT NULL PRIMARY KEY, "subscription_id" integer NOT NULL, "work_id" bigint NOT NULL, "start_at" datetime NOT NULL, "end_at" datetime NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL){sAMindexindex_import_request_transitions_parent_most_recentimport_request_transitionsoCREATE UNIQUE INDEX "index_import_request_transitions_parent_most_recent" ON "import_request_transitions" ("import_request_id", "most_recent") WHERE most_recent    /<  2%w/:I%indexindex_checkins_on_librarian_idcheckins(CREATE INDEX "index_checkins_on_librarian_id" ON "checkins" ("librarian_id")pe?indexindex_checkins_on_item_idcheckins'CREATE INDEX "index_checkins_on_item_id" ON "checkins" ("item_id")Dd[tablecheckinscheckins&CREATE TABLE "checkins" ("id" integer NOT NULL PRIMARY KEY, "item_id" integer NOT NULL, "librarian_id" bigint DEFAULT NULL, "basket_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "checkout_id" integer)cI'%indexindex_checked_items_on_user_idchecked_itemsCREATE INDEX "index_checked_items_on_user_id" ON "checked_items" ("user_id")bS'9indexindex_checked_items_on_librarian_idchecked_itemsTCREATE INDEX "index_checked_items_on_librarian_id" ON "checked_items" ("librarian_id") aM'-indexindex_checked_items_on_basket_idchecked_itemsSCREATE INDEX "index_checked_items_on_basket_id" ON "checked_items" ("basket_id")`I'%indexindex_checked_items_on_item_idchecked_itemsRCREATE INDEX "index_checked_items_on_item_id" ON "checked_items" ("item_id")K_''Utablechecked_itemschecked_itemsPCREATE TABLE "checked_items" ("id" integer NOT NULL PRIMARY KEY, "item_id" integer NOT NULL, "basket_id" integer NOT NULL, "librarian_id" integer DEFAULT NULL, "due_date" datetime NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "user_id" bigint DEFAULT NULL)Y^qKindexindex_carrier_type_has_checkout_types_on_m_form_idcarrier_type_has_checkout_typesCREATE INDEX "index_carrier_type_has_checkout_types_on_m_form_id" ON "carrier_type_has_checkout_types" ("carrier_type_id")h]Kindexindex_carrier_type_has_checkout_types_on_checkout_type_idcarrier_type_has_checkout_typesCREATE INDEX "index_carrier_type_has_checkout_types_on_checkout_type_id" ON "carrier_type_has_checkout_types" ("checkout_type_id")i\KKGtablecarrier_type_has_checkout_typescarrier_type_has_checkout_typesCREATE TABLE "carrier_type_has_checkout_types" ("id" integer NOT NULL PRIMARY KEY, "carrier_type_id" integer NOT NULL, "checkout_type_id" bigint NOT NULL, "note" text DEFAULT NULL, "position" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL){[?#indexindex_user_groups_on_nameuser_groupsxCREATE UNIQUE INDEX "index_user_groups_on_name" ON "user_groups" ("name")aZ## tableuser_groupsuser_groupsECREATE TABLE "user_groups" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "note" text DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime DEFAULT NULL, "number_of_day_to_notify_overdue" integer DEFAULT 7 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 3 NOT NULL, "number_of_time_to_notify_overdue" integer DEFAULT 3 NOT NULL)uYCindexindex_shelves_on_library_idshelvesCCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")+X-tableshelvesshelvesBCREATE TABLE "shelves" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "note" text DEFAULT NULL, "library_id" integer NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "closed" boolean DEFAULT 0 NOT NULL)@W));tablesearch_enginessearch_enginesCREATE TABLE "search_engines" ("id" integer NOT NULL PRIMARY KEY, "name" varchar NOT NULL, "display_name" text DEFAULT NULL, "url" varchar NOT NULL, "base_url" text NOT NULL, "http_method" text NOT NULL, "query_param" text NOT NULL, "additional_param" text DEFAULT NULL, "note" text DEFAULT NULL, "position" integer DEFAULT 1 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)  j w W2 E   p= indexindex_demands_on_user_iddemandsRCREATE INDEX "index_demands_on_user_id" ON "demands" ("user_id")xxEtabledemandsdemandsQCREATE TABLE "demands" ("id" integer NOT NULL PRIMARY KEY, "user_id" integer DEFAULT NULL, "item_id" integer DEFAULT NULL, "message_id" bigint DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)~wG!indexindex_checkouts_on_library_idcheckoutsPCREATE INDEX "index_checkouts_on_library_id" ON "checkouts" ("library_id")$u]Yindexindex_checkouts_on_item_id_and_basket_idcheckouts1CREATE UNIQUE INDEX "index_checkouts_on_item_id_and_basket_id" ON "checkouts" ("item_id", "basket_id")ztEindexindex_checkouts_on_basket_idcheckouts0CREATE INDEX "index_checkouts_on_basket_id" ON "checkouts" ("basket_id")sK)indexindex_checkouts_on_librarian_idcheckouts/CREATE INDEX "index_checkouts_on_librarian_id" ON "checkouts" ("librarian_id")-n];Mindexindex_checkout_stat_has_users_on_user_idcheckout_stat_has_usersCREATE INDEX "index_checkout_stat_has_users_on_user_id" ON "checkout_stat_has_users" ("user_id")Wmy;indexindex_checkout_stat_has_users_on_user_checkout_stat_idcheckout_stat_has_usersCREATE INDEX "index_checkout_stat_has_users_on_user_checkout_stat_id" ON "checkout_stat_has_users" ("user_checkout_stat_id")Al;;tablecheckout_stat_has_userscheckout_stat_has_usersCREATE TABLE "checkout_stat_has_users" ("id" integer NOT NULL PRIMARY KEY, "user_checkout_stat_id" integer NOT NULL, "user_id" bigint NOT NULL, "checkouts_count" integer DEFAULT 0 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)mkMindexindex_checkout_stat_has_manifestations_on_manifestation_idcheckout_stat_has_manifestations{CREATE INDEX "index_checkout_stat_has_manifestations_on_manifestation_id" ON "checkout_stat_has_manifestations" ("manifestation_id"){jM1indexindex_checkout_stat_has_manifestations_on_checkout_stat_idcheckout_stat_has_manifestationsCREATE INDEX "index_checkout_stat_has_manifestations_on_checkout_stat_id" ON "checkout_stat_has_manifestations" ("manifestation_checkout_stat_id")hiMMAtablecheckout_stat_has_manifestationscheckout_stat_has_manifestationsCREATE TABLE "checkout_stat_has_manifestations" ("id" integer NOT NULL PRIMARY KEY, "manifestation_checkout_stat_id" integer NOT NULL, "manifestation_id" bigint NOT NULL, "checkouts_count" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)}hG!indexindex_checkins_on_checkout_idcheckinszCREATE INDEX "index_checkins_on_checkout_id" ON "checkins" ("checkout_id")vgCindexindex_checkins_on_basket_idcheckins)CREATE INDEX "index_checkins_on_basket_id" ON "checkins" ("basket_id") I%inxvCindexindex_checkouts_on_shelf_idcheckoutsOCREATE INDEX "index_checkouts_on_shelf_id" ON "checkouts" ("shelf_id")fI%indexindex_checkins_on_librarian_idcheckins(CREATE INDEX "index_checkins_on_librarian_id" ON "checkins" ("librarian_id")pe?indexindex_checkins_on_item_idcheckins'CREATE INDEX "index_checkins_on_item_id" ON "checkins" ("item_id")}rG!indexindex_checkouts_on_checkin_idcheckouts.CREATE INDEX "index_checkouts_on_checkin_id" ON "checkouts" ("checkin_id")tqAindexindex_checkouts_on_item_idcheckouts-CREATE INDEX "index_checkouts_on_item_id" ON "checkouts" ("item_id")tpAindexindex_checkouts_on_user_idcheckouts,CREATE INDEX "index_checkouts_on_user_id" ON "checkouts" ("user_id")oktablecheckoutscheckouts+CREATE TABLE "checkouts" ("id" integer NOT NULL PRIMARY KEY, "user_id" bigint DEFAULT NULL, "item_id" integer NOT NULL, "checkin_id" integer DEFAULT NULL, "librarian_id" integer DEFAULT NULL, "basket_id" integer DEFAULT NULL, "due_date" datetime DEFAULT NULL, "checkout_renewal_count" integer DEFAULT 0 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "shelf_id" integer DEFAULT NULL, "library_id" integer DEFAULT NULL)      K Q H Q H tablelibrarieslibraries>CREATE TABLE "libraries" ("id" integer NOT NULL PRIMARY KEe1Eindexindex_user_export_file_transitions_on_user_export_file_iduser_export_file_transitions=CREATE INDEX "index_user_export_file_transitions_on_user_export_file_id" ON "user_export_file_transitions" ("user_export_file_id")0EEtableuser_export_file_transitionsuser_export_file_transitions)20081215094302=)20081212151820<)20081212151614;)20081212080038:)200812120755549)200811171434558)200811171431567)200810300236156)200810300235185)200810300234124)200810280936073)200810280832082)200810280831421)200810271509070)20081025083905/)20081025083323.)20081023092436-)20081006093246,)20081006090811+)20080905191442*)20080830154109))20080819181903(154'149&146%145$144#142"134!133 132131130129127125124121120117114113112T8077736985955 *47 41 35 33 32291512 652 1 uaM9%q]I5! m Y E 1  } i U A -   y e Q = )   u a M 9 %  q ] I 5q]I5! mYE1 }iUA-yeQ=) . '   )20190512152331 )20190512134553 )20190512130927 )20190512092833 )20180107162048)20180107162029)20180107162009)20180107161951)20180107161410)20180107161347)20180107161331)20180107161311)20180107161035)20180107160740)20180107160726)20180102162311)20171126135238)20171126133835)20171119051258)20171014084528)20170305064014)20160820004638)20160814165332)20160813203039)20160813192542)20160813191820)20160813191733)20160813191647)20160813191533)20160811102604)20160801080643)20160801080637)20160801080619)20160801080612)20160703190209)20160703185015)20160703184805)20160703184747)20160703184723)20160703184650)20160703184619)20160627232316)20160627232219)20160610093229)20151213072705)20151213070943)20151126005552)20151125004028)20150925092505)20150924115059)20150923173139)20150506105356)20150421023923)20150221063719)201501171111368077736965955 547 41 35 33 3229)20150106001709)20141020120523)20141014065831)20141003182825)20141003181336)20140823095740)20140823094847)20140823083524)20140822114527)20140821151023)20140814070854)20140813182425)20140812153137)20140812152348)20140812093836)20140811031145)20140810091417)20140810091231)20140810061942)20140802082007)20140721151416)20140720192418)20140720170735)20140720170714)20140720140916)20140709113905)20140709113413)20140628073535)20140628073524)20140628072217)20140628071719)20140614141500)20140614065404)20140610123439)20140528045617)20140528045600)20140528045539)20140528045518)20140524135607)20140524074813)20140524020735)20140523171309)20140519171220)20140519170214)20140518135713)20140518111006)20140518050147)20140122054321)20140110131010)20140110122216)20130519065837)20130519065638)20130509185724)20130506175834)20130506175303)20130504195916)20130504143515)20130504133816)20130429020822)20130421164124)20130421155019)20130421093852)20130416054135)20130412083556)20130304015019)20130303124821)20130221154434)20121116031206)20120602141129)20120511072422)20120510140958)20120424103932)20120418081407)20120415164821)20120415060342)20120413170734)20120413170720)20120413170705)20120413161403)20120413161340)20120413100431)20120413100352)20120413072700)20120413051535)20120410104851)20120406020752)20120319173203        ]\[     |ung`YRKD=6/(! ucQ?- y g U C 1  } k Y G 5 #  o ] K 9 '   s a O = +   w e S A /  vcP=*lYF3  ubO<)~kXE2 taN;(}jWD1 s`M:'^)20151126005552])20151125004028\)20150925092505[)20150924115059Z)20150923173139Y)20150506105356X)20150421023923W)20150221063719V)20150117111136U)20150106001709T)20141020120523S)20141014065831R)20141003182825Q)20141003181336P)20140823095740O)20140823094847N)20140823083524M)20140822114527L)20140821151023K)20140814070854J)20140813182425I)20140812153137H)20140812152348G)20140812093836F)20140811031145E)20140810091417D)20140810091231C)20140810061942B)20140802082007A)20140721151416@)20140720192418?)20140720170735>)20140720170714=)20140720140916<)20140709113905;)20140709113413:)201406280735359)201406280735248)201406280722177)201406280717196)201406141415005)201406140654044)201406101234393)201405280456172)201405280456001)201405280455390)20140528045518/)20140524135607.)20140524074813-)20140524020735,)20140523171309+)20140519171220*)20140519170214))20140518135713()20140518111006')20140518050147&)20140122054321%)20140110131010$)20140110122216#)20130519065837")20130519065638!)20130509185724 )20130506175834)20130506175303)20130504195916)20130504143515)20130504133816)20130429020822)20130421164124)20130421155019)20130421093852)20130416054135)20130412083556)20130304015019)20130303124821)20130221154434)20121116031206)20120602141129)20120511072422)20120510140958)20120424103932 )20120418081407 )20120415164821 )20120415060342 )20120413170734 )20120413170720)20120413170705)20120413161403)20120413161340)20120413100431)20120413100352)20120413072700)20120413051535)20120410104851)20120406020752)20120319173203~)20120319120638})20120129020544|)20120129014038{)20120125152919z)20120125050502y)20120105074911x)20111218002349w)20111217234412v)20111129044509u)20111124112131t)20111124110355s)20111124110319r)20111124110059q)20110918162329p)20110916103953o)20110916091020n)20110913120629m)20110913115320l)20110627122938k)20110627035057j)20110627034940i)20110621093332h)20110620173525g)20110619064807f)20110603184217e)20110328130826d)20110318183304c)20110301134521b)20110301121550a)20110301035123`)20110222073537_)20101212070145^)20100925074639])20100925074559\)20100925043847[)20100814091104Z)20100607044753Y)20100606073747X)20100606065209W)20100525171356V)20100525124311U)20100321235924T)20100314190054S)20100223121519R)20100222124420Q)20100211105551P)20100129142347O)20091214131723N)20091202124834M)20091025080447L)20091012101112K)20090831220301J)20090812151902I)20090720091429H)20090720091106G)20090706125521F)20090705212043E)20090705133942D)20090519203307C)20090321130448B)20081220034117A)20081220023628@)20081216190724?)20081216190517>)20081215094955=)20081215094302<)20081212151820;)20081212151614:)200812120800389)200812120755548)200811171434557)200811171431566)200810300236155)200810300235184)200810300234123)200810280936072)200810280832081)200810280831420)20081027150907/)20081025083905.)20081025083323-)20081023092436,)20081006093246+)20081006090811*)20080905191442))20080830154109()20080819181903'154&149%146$145#144"142!134 1331321311301291271251241211201171141131128077736959 55 47 41 35 33322915126521 . {hUB/ q^K8% z g T A .    )20190512152331 )20190512134553 )20190512130927 )20190512092833)20180107162048)20180107162029)20180107162009)20180107161951)20180107161410)20180107161347)20180107161331)20180107161311)20180107161035)20180107160740~)20180107160726})20180102162311|)20171126135238{)20171126133835z)20171119051258y)20171014084528x)20170305064014w)20160820004638v)20160814165332u)20160813203039t)20160813192542s)20160813191820r)20160813191733q)20160813191647p)20160813191533o)20160811102604n)20160801080643m)20160801080637l)20160801080619k)20160801080612j)20160703190209i)20160703185015h)20160703184805g)20160703184747f)20160703184723e)20160703184650d)20160703184619c)20160627232316b)20160627232219a)20160610093229`)20151213072705_)20151213070943 q*&0q;Gm)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")FY)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")QE))]tablemanifestationsmanifestationsCREATE TABLE "manifestations" ("id" integer NOT NULL PRIMARY KEY, "original_title" text NOT NULL, "title_alternative" text DEFAULT NULL, "title_transcription" text DEFAULT NULL, "classification_number" varchar DEFAULT NULL, "manifestation_identifier" varchar DEFAULT NULL, "date_of_publication" datetime DEFAULT NULL, "date_copyrighted" datetime DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "access_address" varchar DEFAULT NULL, "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "start_page" integer DEFAULT NULL, "end_page" integer DEFAULT NULL, "height" integer DEFAULT NULL, "width" integer DEFAULT NULL, "depth" integer DEFAULT NULL, "price" integer DEFAULT NULL, "fulltext" text DEFAULT NULL, "volume_number_string" varchar DEFAULT NULL, "issue_number_string" varchar DEFAULT NULL, "serial_number_string" varchar DEFAULT NULL, "edition" integer DEFAULT NULL, "note" text DEFAULT NULL, "repository_content" boolean DEFAULT 0 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "frequency_id" integer DEFAULT 1 NOT NULL, "subscription_master" boolean DEFAULT 0 NOT NULL, "attachment_file_name" varchar DEFAULT NULL, "attachment_content_type" varchar DEFAULT NULL, "attachment_file_size" integer DEFAULT NULL, "attachment_updated_at" datetime DEFAULT NULL, "title_alternative_transcription" text DEFAULT NULL, "description" text DEFAULT NULL, "abstract" text DEFAULT NULL, "available_at" datetime DEFAULT NULL, "valid_until" datetime DEFAULT NULL, "date_submitted" datetime DEFAULT NULL, "date_accepted" datetime DEFAULT NULL, "date_captured" datetime DEFAULT NULL, "pub_date" varchar DEFAULT NULL, "edition_string" varchar DEFAULT NULL, "volume_number" integer DEFAULT NULL, "issue_number" integer DEFAULT NULL, "serial_number" integer DEFAULT NULL, "content_type_id" integer DEFAULT 1, "year_of_publication" integer DEFAULT NULL, "attachment_meta" text DEFAULT NULL, "month_of_publication" integer DEFAULT NULL, "fulltext_content" boolean DEFAULT NULL, "serial" boolean DEFAULT NULL, "statement_of_responsibility" text DEFAULT NULL, "publication_place" text DEFAULT NULL, "extent" text DEFAULT NULL, "dimensions" text DEFAULT NULL)BG?indexindex_event_export_file_transitions_on_sort_key_and_file_idevent_export_file_transitionsKCREATE UNIQUE INDEX "index_event_export_file_transitions_on_sort_key_and_file_id" ON "event_export_file_transitions" ("sort_key", "event_export_file_id")RAiGindexindex_event_export_file_transitions_on_file_idevent_export_file_transitionsJCREATE INDEX "index_event_export_file_transitions_on_file_id" ON "event_export_file_transitions" ("event_export_file_id") GF $#" g#" ?>=< rz F mMLC&rP"[gindexindex_manifestation_checkout_stat_transitions_on_transitionmanifestation_checkout_stat_transitions1CREATE UNIQUE INDEX "index_manifestation_checkout_stat_transitions_on_transition" ON "manifestation_checkout_stat_transitions" ("sort_key", "manifestation_checkout_stat_id") }[;indexindex_manifestation_checkout_stat_transitions_on_stat_idmanifestation_checkout_stat_transitions0CREATE INDEX "index_manifestation_checkout_stat_transitions_on_stat_id" ON "manifestation_checkout_stat_transitions" ("manifestation_checkout_stat_id")my= indexindex_demands_on_user_iddemandsRCREATE INDEX "index_demands_on_user_id" ON "demands" ("user_id")4[[=tablemanifestation_checkout_stat_transitionsmanifestation_checkout_stat_transitions/CREATE TABLE "manifestation_checkout_stat_transitions" ("id" integer NOT NULL PRIMARY KEY, "to_state" varchar DEFAULT NULL, "metadata" text DEFAULT '{}', "sort_key" integer DEFAULT NULL, "manifestation_checkout_stat_id" bigint DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "most_recent" boolean NOT NULL)K)indexindex_items_on_manifestation_iditemsACREATE INDEX "index_items_on_manifestation_id" ON "items" ("manifestation_id")YEindexindex_items_on_binding_item_identifieritemsCREATE INDEX "index_items_on_binding_item_identifier" ON "items" ("binding_item_identifier")K)indexindex_items_on_checkout_type_iditemsCREATE INDEX "index_items_on_checkout_type_id" ON "items" ("checkout_type_id")U=indexindex_items_on_circulation_status_iditemsCREATE INDEX "index_items_on_circulation_status_id" ON "items" ("circulation_status_id")sCindexindex_items_on_bookstore_iditems*CREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")K)indexindex_items_on_required_role_iditemsCREATE INDEX "index_items_on_required_role_id" ON "items" ("required_role_id")|I%indexindex_items_on_item_identifieritemsCREATE INDEX "index_items_on_item_identifier" ON "items" ("item_identifier")g; indexindex_items_on_shelf_iditemsCREATE INDEX "index_items_on_shelf_id" ON "items" ("shelf_id")2CtableitemsitemsCREATE TABLE "items" ("id" integer NOT NULL PRIMARY KEY, "call_number" varchar DEFAULT NULL, "item_identifier" varchar DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "shelf_id" integer DEFAULT 1 NOT NULL, "include_supplements" boolean DEFAULT 0 NOT NULL, "note" text DEFAULT NULL, "url" varchar DEFAULT NULL, "price" integer DEFAULT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "acquired_at" datetime DEFAULT NULL, "bookstore_id" integer DEFAULT NULL, "budget_type_id" integer DEFAULT NULL, "circulation_status_id" bigint DEFAULT 5 NOT NULL, "checkout_type_id" integer DEFAULT 1 NOT NULL, "binding_item_identifier" varchar DEFAULT NULL, "binding_call_number" varchar DEFAULT NULL, "binded_at" datetime DEFAULT NULL, "manifestation_id" integer NOT NULL)U~w?indexindex_item_has_use_restrictions_on_use_restriction_iditem_has_use_restrictionscCREATE INDEX "index_item_has_use_restrictions_on_use_restriction_id" ON "item_has_use_restrictions" ("use_restriction_id")4}a?Uindexindex_item_has_use_restrictions_on_item_iditem_has_use_restrictions[CREATE INDEX "index_item_has_use_restrictions_on_item_id" ON "item_has_use_restrictions" ("item_id")|??9tableitem_has_use_restrictionsitem_has_use_restrictionsZCREATE TABLE "item_has_use_restrictions" ("id" integer NOT NULL PRIMARY KEY, "item_id" integer NOT NULL, "use_restriction_id" bigint NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)v{Cindexindex_demands_on_message_iddemandsTCREATE INDEX "index_demands_on_message_id" ON "demands" ("message_id")mz= indexindex_demands_on_item_iddemandsSCREATE INDEX "index_demands_on_item_id" ON "demands" ("item_id") !  -,2 "U'=indexindex_sub  wE{,E9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitionsgCREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")x'''/tablesubscriptionssubscriptionsyCREATE TABLE "subscriptions" ("id" integer NOT NULL PRIMARY KEY, "title" text NOT NULL, "note" text DEFAULT NULL, "user_id" bigint DEFAULT NULL, "order_list_id" integer DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "subscribes_count" integer DEFAULT 0 NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)x&C!indexindex_subscribes_on_work_idsubscribes~CREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id")%S!9indexindex_subscribes_on_subscription_idsubscribes}CREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id")$!! tablesubscribessubscribes|CREATE TABLE "subscribes" ("id" integer NOT NULL PRIMARY KEY, "subscription_id" integer NOT NULL, "work_id" bigint NOT NULL, "start_at" datetime NOT NULL, "end_at" datetime NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL)]K))indexindex_library_groups_on_user_idlibrary_groupstCREATE INDEX "index_library_gre1Eindexindex_user_export_file_transitions_on_user_export_file_iduser_export_file_transitions=CREATE INDEX "index_user_export_file_transitions_on_user_export_file_id" ON "user_export_file_transitions" ("user_export_file_id")0EEtableuser_export_file_transitionsuser_export_file_transitions