About Features Downloads Getting Started Documentation Events Support GitHub

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

VuFind Documentation

Site Tools

You are here: start » development » architecture » database_schema
Trace:
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 [2019/06/12 17:08] – 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 ==== 
 + 
 +This is used to store authentication hashes used by the email authenticator introduced in VuFind 6.1.
  
 ==== change_tracker ==== ==== change_tracker ====
Line 18: 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 94: 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 ====
 +  * Added hash column to shortlinks table.
 +
 +==== Release 6.1 ====
 +  * Added new auth_hash table.
 +  * The pending_email and user_provided_email fields were added to the user table to support email change functionality.
 +  * The last_language field was added to the user table to track user language preferences.
 +  * The notification_frequency, last_notification_sent and notification_base_url fields were added to the search table to support [[configuration:Email Alerts]].
 +  * The id fields of search, session and external_session were switched to the bigint type to allow more growth.
  
 ==== Release 6.0 ==== ==== Release 6.0 ====
   * The shortlinks table was added (used for the optional URL shortening mechanism).   * The shortlinks table was added (used for the optional URL shortening mechanism).
 +  * Added column email_verified to user table.
  
 ==== Release 5.1 ==== ==== Release 5.1 ====
Line 131: 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.1560359296.txt.gz · Last modified: 2019/06/12 17:08 by demiankatz