Bug 32357: Set borrower_message_preferences.days_in_advance default to NULL
[koha.git] / installer / data / mysql / kohastructure.sql
2023-05-12 Lari TaskulaBug 32357: Set borrower_message_preferences.days_in_adv...
2023-05-12 Nick ClemensBug 33489: Add indices to default patron search fields
2023-05-12 Lucas GassBug 31212: Change datelastseen from date to datetime...
2023-05-10 Jonathan DruartBug 28328: Extend biblioitems.lccn to longtext
2023-05-10 Aleisha AmohiaBug 30928: (QA follow-up) DB updates
2023-05-05 Kyle HallBug 33053: Remove default value for tables item_groups...
2023-05-05 Jonathan DruartBug 33104: Rename interfaces.id with interface_id
2023-05-05 Jonathan DruartBug 33104: DB changes
2023-05-05 Katrin FischerBug 33262: Add deleted_biblionumber column to aqorders...
2023-05-05 Tomas Cohen AraziBug 22440: Add missing foreign key
2023-04-20 Aleisha AmohiaBug 12029: Adding messages.patron_read_date column
2023-04-20 Jonathan DruartBug 33103: DB changes
2023-04-06 Jonathan DruartBug 33368: Extends borrowers.flags to bigint
2023-03-31 Nick ClemensBug 32437: Add Objects for ImportAuths
2023-03-14 Kyle HallBug 32057: Add optional stack trace to action logs
2023-03-06 Jonathan DruartBug 25655: DB changes
2023-03-06 Martin RenvoizeBug 31028: Add `tickets` and `ticket_updates` tables
2023-02-24 Matt BlenkinsopBug 22428: Change datatype of field_value to text
2023-02-10 Matt BlenkinsopBug 30642: (follow-up) Change sql and adapt for transla...
2023-02-10 Matt BlenkinsopBug 30642: Record renewal type
2023-02-07 Katrin FischerBug 28674: Fix typo 'hlpd' in schema comments
2023-02-02 Kyle M HallBug 20256: Update database
2023-01-31 Kyle HallBug 27424: Add ability to specify an SMTP server in...
2022-12-16 Fridolin SomersBug 32330: Add indexes to table background_jobs
2022-11-25 Tomas Cohen Arazi22.11.00: Update kohastructure.sql
2022-11-11 Pedro AmorimBug 32154: Missing primary key on erm_user_roles table
2022-11-11 Jonathan DruartBug 32162: Add primar key to erm_eholdings_packages_agr...
2022-11-10 Tomas Cohen AraziBug 24606: (QA follow-up) borrowernumber => patron_id
2022-11-10 Kyle HallBug 24606: Update database, add new schema file
2022-11-08 Tomas Cohen AraziBug 31378: (follow-up) MySQL 8 doens't allow default...
2022-11-08 Agustin MoyanoBug 31378: Rename Auth Provider to Identity Provider...
2022-11-08 Agustin MoyanoBug 31378: DB changes
2022-11-08 Pedro AmorimBug 32030: Add users to licenses - DB
2022-11-08 Pedro AmorimBug 32030: Add document to license - DB
2022-11-08 Pedro AmorimBug 32030: Add Notes field to erm_eholdings_packages...
2022-11-08 Jonathan DruartBug 32030: ERM - Add vendor to license
2022-11-08 Jonathan DruartBug 32030: Unique - DB
2022-11-08 Jonathan DruartBug 32030: Link external packages with agreements
2022-11-08 Jonathan DruartBug 32030: Proxy with HoldingsIQ
2022-11-08 Jonathan DruartBug 32030: Create a local bibliographic record for...
2022-11-08 Jonathan DruartBug 32030: Add title.external_id
2022-11-08 Jonathan DruartBug 32030: Rename Package|Resource|Title
2022-11-08 Jonathan DruartBug 32030: Add eholdings.vendor_id
2022-11-08 Jonathan DruartBug 32030: ERM - eHoldings - DB
2022-11-08 Jonathan DruartBug 32030: ERM - Agreement documents - DB
2022-11-08 Jonathan DruartBug 32030: ERM - related agreements - DB
2022-11-08 Jonathan DruartBug 32030: license DB
2022-11-08 Jonathan DruartBug 32030: ERM - License - DB
2022-11-08 Jonathan DruartBug 32030: ERM - Users - DB table erm_agreement_users
2022-11-08 Jonathan DruartBug 32030: ERM - Periods - DB table erm_agreement_periods
2022-11-08 Jonathan DruartBug 32030: ERM - DB
2022-11-04 Kyle M HallBug 24860: Add reserves.item_group_it
2022-10-28 Katrin FischerBug 31948: Add timestamp to tmp_holdsqueue table
2022-10-21 Tomas Cohen AraziBug 17170: (QA follow-up) DB changes
2022-10-21 Nick ClemensBug 17170: DB Updates
2022-10-18 Tomas Cohen AraziBug 31626: (QA follow-up) Make db_rev robust
2022-10-18 Kyle HallBug 31626: Add letter id to the message queue table
2022-10-17 Nick ClemensBug 31569: DB update and objects
2022-10-03 Lucas GassBug 10950: (follow-up) fix typo in kohastructure.sql
2022-10-03 Lucas GassBug 10950: Database update
2022-10-03 Aleisha AmohiaBug 30944: Fix cancel recalls actions
2022-10-03 Katrin FischerBug 30571: (QA follow-up) Update marc to MARC in docs
2022-10-03 Marcel de RooyBug 30571: Table z3950servers: Make host, syntax and...
2022-09-22 Tomas Cohen AraziBug 7021: (QA follow-up) Fix typo
2022-09-22 Kyle M HallBug 7021: (QA follow-up) Add comment to new database...
2022-09-22 Martin RenvoizeBug 7021: Terminology - usercode -> categorycode
2022-09-22 Olli-Antti KivilahtiBug 7021: Patron category in the statistics table
2022-09-22 Marcel de RooyBug 30490: Adjust constraint itemtypes.itemtypes_ibfk_1
2022-09-16 Marcel de RooyBug 30472: Make borrower_relationships.guarantor_id...
2022-09-16 Tomas Cohen AraziBug 15348: (QA follow-up) DB update fixes
2022-09-16 Aleisha AmohiaBug 15348: Add estimated delivery date field to individ...
2022-09-16 Marcel de RooyBug 29144: Copy and remove branches.opac_info (dbrev)
2022-09-12 Marcel de RooyBug 30483: Make issues.borrowernumber and itemnumber...
2022-09-07 Lucas GassBug 31374: (follow-up) change private note to staff_not...
2022-09-07 Lucas GassBug 31374: Database/Schema update
2022-08-25 Tomas Cohen AraziBug 23681: (QA follow-up) debarment_types => restrictio...
2022-08-25 Martin RenvoizeBug 23681: (QA follow-up) Proper handling of default...
2022-08-25 Emmi TakkinenBug 23681: Fix QA issues
2022-08-25 Martin RenvoizeBug 23681: (QA follow-up) Rename columns
2022-08-25 Andrew IsherwoodBug 23681: Add debarment_types table
2022-08-19 Nick ClemensBug 31017: Update field name to 'type'
2022-08-19 Nick ClemensBug 31017: DB Updates
2022-08-01 Tomas Cohen AraziBug 30392: (QA follow-up) Correct COMMENT
2022-08-01 Jonathan DruartBug 30392: DB changes
2022-08-01 Kyle HallBug 30984: (QA follow-up) Switch from mediumtext to...
2022-08-01 Kyle HallBug 30984: Action logs should log the cronjob script...
2022-07-29 Tomas Cohen AraziBug 22456: Add cancellation request table
2022-07-29 Jonathan DruartBug 30650: DB - Add policy.enable_waiting_holds_only
2022-07-29 Jonathan DruartBug 30650: Adjust atomic update
2022-07-29 Jonathan DruartBug 30650: DB changes
2022-07-22 Martin RenvoizeBug 31086: (QA follow-up) Remove DEFAULT from column
2022-07-22 Nick ClemensBug 31086: DB update
2022-07-18 Tomas Cohen AraziBug 29632: (QA follow-up) Add ENUM value to kohastructu...
2022-07-13 Martin RenvoizeBug 28854: (follow-up) Replace unique constraint in...
2022-07-13 Martin RenvoizeBug 28854: Drop unique index on issue_id in return...
2022-07-13 Martin RenvoizeBug 28854: Database update
2022-07-08 Nick ClemensBug 24857: Database updates
2022-07-05 Tomas Cohen AraziBug 24010: (QA follow-up) Correct COMMENT syntax
2022-07-05 Jonathan DruartBug 24010: DB Changes
2022-07-05 Tomas Cohen AraziBug 30275: (QA follow-up) Rename columns to match API
next