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
Next revisionBoth sides next revision
development:architecture:database_schema [2019/10/18 15:23] – [Release 6.1] demiankatzdevelopment:architecture:database_schema [2020/03/02 20:48] demiankatz
Line 6: Line 6:
  
 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/master/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 97: Line 101:
  
 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 7.0 ====
 +  * Added hash column to shortlinks table.
  
 ==== Release 6.1 ==== ==== 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 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 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.   * The id fields of search, session and external_session were switched to the bigint type to allow more growth.
  
development/architecture/database_schema.txt · Last modified: 2024/01/19 14:21 by demiankatz