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 [2016/04/01 18:36] – [Release 3.0] demiankatz | development:architecture:database_schema [2018/06/27 11:38] – [Release 5.0] demiankatz | ||
---|---|---|---|
Line 14: | Line 14: | ||
This table stores user comments on records. | This table stores user comments on records. | ||
+ | |||
+ | ==== external_session ==== | ||
+ | |||
+ | This table associates external session IDs with internal ones; used for [[configuration: | ||
==== oai_resumption ==== | ==== oai_resumption ==== | ||
Line 89: | Line 93: | ||
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 === | ||
+ | * 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 (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 ==== | ||
+ | * Added external_session table. | ||
+ | * Added cat_id field to user table. | ||
+ | |||
+ | ==== Release 3.1 ==== | ||
+ | * Changed the collation of the tags table to utf8_bin to fix strange case sensitivity behavior (only affects MySQL; see [[https:// | ||
==== Release 3.0 ==== | ==== Release 3.0 ==== |
development/architecture/database_schema.txt · Last modified: 2024/06/06 17:43 by demiankatz