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.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
development:architecture:database_schema [2018/10/18 15:44] – [Release 5.1] demiankatz | development:architecture:database_schema [2019/12/17 20:51] – demiankatz | ||
---|---|---|---|
Line 6: | Line 6: | ||
The latest VuFind database definitions can be found [[https:// | The latest VuFind database definitions can be found [[https:// | ||
+ | |||
+ | ==== auth_hash ==== | ||
+ | |||
+ | This is used to store authentication hashes used by the email authenticator introduced in VuFind 6.1. | ||
==== change_tracker ==== | ==== change_tracker ==== | ||
Line 42: | Line 46: | ||
This table stores session data when VuFind is configured for database session storage. It is unused when the session is stored on disk, in memcache, etc. | This table stores session data when VuFind is configured for database session storage. It is unused when the session is stored on disk, in memcache, etc. | ||
+ | |||
+ | ==== shortlinks ==== | ||
+ | |||
+ | When optional database-driven link shortening is turned on (see the url_shortener setting in [[configuration: | ||
==== tags ==== | ==== tags ==== | ||
Line 93: | 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 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, | ||
+ | * The id fields of search, session and external_session were switched to the bigint type to allow more growth. | ||
+ | |||
+ | ==== Release 6.0 ==== | ||
+ | * 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 ==== |
development/architecture/database_schema.txt · Last modified: 2024/06/06 17:43 by demiankatz