About Features Downloads Getting Started Documentation Events Support GitHub

Love VuFind®? Consider becoming a financial supporter. Your support helps build a better VuFind®!

Site Tools


Warning: This page has not been updated in over over a year and may be outdated or deprecated.
development:architecture:database_schema

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
development:architecture:database_schema [2020/03/02 20:48] demiankatzdevelopment:architecture:database_schema [2024/01/19 14:21] (current) demiankatz
Line 5: Line 5:
 ===== Tables ===== ===== Tables =====
  
-The latest VuFind database definitions can be found [[https://github.com/vufind-org/vufind/tree/master/module/VuFind/sql|here]]. This page provides some documentation and clarification on the various tables used by the system.+The latest VuFind database definitions can be found [[https://github.com/vufind-org/vufind/tree/dev/module/VuFind/sql|here]]. This page provides some documentation and clarification on the various tables used by the system.
  
 ==== auth_hash ==== ==== auth_hash ====
Line 22: Line 22:
  
 This table associates external session IDs with internal ones; used for [[configuration:shibboleth|Shibboleth]] single log-out. This table associates external session IDs with internal ones; used for [[configuration:shibboleth|Shibboleth]] single log-out.
 +
 +==== feedback ====
 +
 +This table can be optionally used to collect user feedback form responses.
 +
 +==== login_token ====
 +
 +This table is used to manage [[configuration:authentication#persistent_login|persistent logins]].
  
 ==== oai_resumption ==== ==== oai_resumption ====
  
 This table supports VuFind's [[indexing:tracking_record_changes#oai-pmh_server_functionality|OAI-PMH Server functionality]]. This table supports VuFind's [[indexing:tracking_record_changes#oai-pmh_server_functionality|OAI-PMH Server functionality]].
 +
 +==== ratings ====
 +
 +This table stores user ratings of records when the "rating" setting is turned on in the [Social] section of config.ini (introduced in VuFind 9.0).
  
 ==== record ==== ==== record ====
Line 98: Line 110:
 ===== Changelog ===== ===== Changelog =====
  
-VuFind's database schema is sometimes adjusted between releases. If you use a MySQL database backend, these changes are automatically applied when you run VuFind's web-based upgrade tool (see [[installation:migration_notes|migration notes]]). If you use PostgreSQL, you will currently have to apply migrations using scripts provided in the [[https://github.com/vufind-org/vufind/tree/master/module/VuFind/sql/migrations/pgsql|migrations directory]] of the code.+VuFind's database schema is sometimes adjusted between releases. If you use a MySQL database backend, these changes are automatically applied when you run VuFind's web-based upgrade tool (see [[installation:migration_notes|migration notes]]). If you use PostgreSQL, you will currently have to apply migrations using scripts provided in the [[https://github.com/vufind-org/vufind/tree/dev/module/VuFind/sql/migrations/pgsql|migrations directory]] of the code.
  
 Note that this changelog only goes back as far as release 2.5. Not every release includes database changes. Note that this changelog only goes back as far as release 2.5. Not every release includes database changes.
 +
 +==== Release 10.0 ====
 +  * Added login_token table.
 +
 +==== Release 9.0 ====
 +  * Added feedback table.
 +  * Added ratings table.
 +  * Added an additional index to the search table to improve expiration performance.
 +  * Changed the saved column of the search table to use a more appropriate type for Boolean values.
 +  * Changed the public column of the user_list table to use a more appropriate type for Boolean values.
 +  * Removed the unused folder_id column from the search table.
 +==== Release 7.1 ====
 +  * Changed constraint/default of resource_id column in resource_tags table to support user list tagging.
  
 ==== Release 7.0 ==== ==== Release 7.0 ====
Line 146: Line 171:
   * Increased size of username and email columns in user table.   * Increased size of username and email columns in user table.
 ---- struct data ---- ---- struct data ----
 +properties.Page Owner : 
 ---- ----
  
development/architecture/database_schema.1583182101.txt.gz · Last modified: 2020/03/02 20:48 by demiankatz