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/04/26 14:57] – [Release 5.0] demiankatz | development:architecture:database_schema [2020/03/02 20:48] – 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 94: | Line 102: | ||
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 5.0 === | + | ==== 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 ==== | ||
+ | * 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 ==== | ||
* The comments table now allows anonymous comments; user_id may now be null, and foreign key behavior has changed. | * The comments table now allows anonymous comments; user_id may now be null, and foreign key behavior has changed. | ||
- | * The last_login and auth_method columns were added to the user table. | + | * The last_login and auth_method columns were added to the user table (to track last login date and method). |
+ | * The data column of the session table has been changed to type mediumtext to allow room for larger session data objects. | ||
==== Release 4.0 ==== | ==== Release 4.0 ==== |
development/architecture/database_schema.txt · Last modified: 2024/06/06 17:43 by demiankatz