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/10/18 17:36] – [record] 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 18: | Line 22: | ||
This table associates external session IDs with internal ones; used for [[configuration: | This table associates external session IDs with internal ones; used for [[configuration: | ||
+ | |||
+ | ==== feedback ==== | ||
+ | |||
+ | This table can be optionally used to collect user feedback form responses. | ||
==== oai_resumption ==== | ==== oai_resumption ==== | ||
This table supports VuFind' | This table supports VuFind' | ||
+ | |||
+ | ==== ratings ==== | ||
+ | |||
+ | This table stores user ratings of records when the " | ||
==== record ==== | ==== record ==== | ||
Line 42: | Line 54: | ||
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 106: | ||
===== 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 ==== | ||
Line 123: | Line 161: | ||
* 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.txt · Last modified: 2024/06/06 17:43 by demiankatz