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
Next revisionBoth sides next revision
development:architecture:database_schema [2019/11/11 18:54] – [Release 6.1] demiankatzdevelopment:architecture:database_schema [2020/08/14 20:36] – 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.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 ==== ==== 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.
development/architecture/database_schema.txt · Last modified: 2024/01/19 14:21 by demiankatz