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/09/11 16:55] – demiankatz | development:architecture:database_schema [2022/07/14 17:48] – [Release 7.1] demiankatz | ||
---|---|---|---|
Line 5: | Line 5: | ||
===== Tables ===== | ===== Tables ===== | ||
- | 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 90: | Line 98: | ||
===== Changelog ===== | ===== Changelog ===== | ||
- | VuFind' | + | VuFind' |
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 9.0 ==== | ||
+ | * Added feedback table. | ||
+ | * Added an additional index to the search table to improve expiration performance. | ||
+ | |||
+ | ==== Release 7.1 ==== | ||
+ | * Changed constraint/ | ||
+ | |||
+ | ==== 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, | ||
+ | * 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 ==== | ||
* The resource table now includes an extra_metadata field that can be populated with a JSON document containing extra record details (currently used for storing Summon bookmarks, to deal with changing IDs). | * The resource table now includes an extra_metadata field that can be populated with a JSON document containing extra record details (currently used for storing Summon bookmarks, to deal with changing IDs). | ||
+ | * The field sizes for storing catalog passwords have been increased to accommodate longer strings. | ||
==== Release 5.0 ==== | ==== Release 5.0 ==== |
development/architecture/database_schema.txt · Last modified: 2024/06/06 17:43 by demiankatz