Bug 36687: Update itemtypes.notforloan to not allow NULL values and change to tinyint(1)
[koha.git] / installer / data / mysql / kohastructure.sql
2024-05-08 Lucas GassBug 36687: Update itemtypes.notforloan to not allow...
2024-05-07 Jonathan DruartBug 36396: DB changes
2024-05-03 Martin RenvoizeBug 36120: Ensure pickup_library_id is NOT NULL
2024-05-03 Martin RenvoizeBug 36120: Add pickup_library_id to bookings table
2024-05-02 Kyle M HallBug 25159: DB Update
2024-05-02 Martin RenvoizeBug 35657: Add assignee_id to tickets and ticket_updates
2024-04-30 Katrin FischerBug 32610: Add borrower_attribute_types.is_date to...
2024-04-30 Marcel de RooyBug 36002: Database revision for aqorders.purchaseorder...
2024-04-30 Martin RenvoizeBug 35628: Add status to tickets
2024-04-29 Mark HofstetterBug 31652: Add geo-search
2024-04-26 Aleisha AmohiaBug 33478: Save notice format settings
2024-04-26 Tomas Cohen AraziBug 35919: DB changes
2024-04-26 Lucas GassBug 16122: Add localuse column to items and deleteditems
2024-04-22 Martin RenvoizeBug 35616: Add source field to tickets table
2024-04-19 Emmi TakkinenBug 32132: Do not allow NULL value in column aqbudgets...
2024-04-19 Martin RenvoizeBug 35724: Sync database update and kohasctructure...
2024-04-19 Alex BuckleyBug 35724: Database changes
2024-04-12 Aleisha AmohiaBug 6796: Add library_hours table and set opening hours...
2024-04-04 Jonathan DruartBug 35610: Add FK on old_reserves.branchcode
2024-03-22 Fridolin SomersBug 36033: Add more indexes to table pseudonymized_tran...
2023-12-27 Nick ClemensBug 31297: Allow null value for description in subscrip...
2023-11-30 Tomas Cohen Arazi23.11.00: Update kohastructure.sql
2023-11-09 Nick ClemensBug 34517: DB updates
2023-11-08 Lucas GassBug 34438: Database update
2023-11-03 Emily LamancusaBug 35190: Set default NULL for authorised_value_catego...
2023-11-03 Martin RenvoizeBug 29002: Add bookable state to items
2023-11-03 Martin RenvoizeBug 29002: Add bookings table
2023-11-01 Tomas Cohen AraziBug 18203: Rename column
2023-11-01 Pedro AmorimBug 18203: DB specific and atomicupdate
2023-11-01 Magnus EngerBug 26170: Database update
2023-10-31 Pedro AmorimBug 34587: Move YOP to mus/yus instead of erm_usage_titles
2023-10-31 Pedro AmorimBug 34587: Add proprietary_id and platform to erm_usage...
2023-10-31 Pedro AmorimBug 34587: Update database columns length
2023-10-31 Matt BlenkinsopBug 34587: Remove counter files from API embedding...
2023-10-31 Matt BlenkinsopBug 34587: Update field lengths to 255 characters
2023-10-31 Pedro AmorimBug 34587: Remove begin_date and end_date as usage_data...
2023-10-31 Matt BlenkinsopBug 34587: Add default report capability to reports...
2023-10-31 Pedro AmorimBug 34587: SUSHI COUNTER Harvester
2023-10-31 Matt BlenkinsopBug 34587: SQL structure and atomic update file
2023-10-31 Katrin FischerBug 35180: Fix 246 to 264 in COMMENT of deletedbiblioit...
2023-10-31 Katrin FischerBug 34520: Fix FK for item_groups in reserves for new...
2023-10-25 Pedro AmorimBug 33970: Update DB
2023-10-25 Thibaud GuillotBug 10762: (follow-up) Update test plan, add kohastruct...
2023-10-25 Marcel de RooyBug 31503: Change patron_consent.type
2023-10-24 Nick ClemensBug 27153: Adjust kohastructure for new primary key
2023-10-24 Nick ClemensBug 27153: DB Updates
2023-10-23 Jonathan DruartBug 33547: Add print slip
2023-10-20 Tomas Cohen AraziBug 31383: Fix kohastructure.sql
2023-10-20 Jonathan DruartBug 31383: Restore updated_on for individual content
2023-10-20 Jonathan DruartBug 31383: DB changes
2023-10-19 Martin RenvoizeBug 32721: (QA follow-up) Drop fields from API response
2023-10-19 Matt BlenkinsopBug 32721: Database update to add userjs and usercss...
2023-10-18 Jonathan DruartBug 30708: Allow attributes to be multivalued
2023-10-18 Jonathan DruartBug 30708: Add user_train_item_id
2023-10-18 Jonathan DruartBug 30708: DB changes
2023-10-17 Tomas Cohen AraziBug 30719: (QA follow-up) Pick better column names...
2023-10-17 Pedro AmorimBug 30719: (QA follow-up) Squash:
2023-10-17 Pedro AmorimBug 30719: DB and API
2023-10-11 Tomas Cohen AraziBug 16223: (QA follow-up) Adjust DB changes
2023-10-10 Martin RenvoizeBug 12532: (QA follow-up) Add cc_address to message_queue
2023-10-04 Emmi TakkinenBug 9525: Add ft_local_float_group column
2023-09-18 Matt BlenkinsopBug 34789: Database and API update
2023-08-15 Kyle M HallBug 34494: Table tmp_holdsqueue fails to be created...
2023-08-15 Katrin FischerBug 30451: Update FK constraint on aqorders.subscriptionid
2023-07-26 Kyle M HallBug 28966: (QA follow-up) Fix failing unit tests
2023-07-20 Marcel de RooyBug 33379: Remove virtualshelfcontents.flags
2023-07-20 Marcel de RooyBug 33105: (QA follow-up) Small changes in dbrev
2023-07-20 Jonathan DruartBug 33105: DB changes
2023-07-14 Kyle HallBug 33039: Add ability to specify a template for serial...
2023-06-29 Tomas Cohen AraziBug 34029: (QA follow-up) Fix slipped broken char
2023-06-26 Katrin FischerBug 34029: Extend datatypes of biblioitems.columns...
2023-06-06 Tomas Cohen AraziBug 21983: DB update
2023-05-31 Tomas Cohen Arazi23.05.00: Update kohastructure.sql
2023-05-17 Matt BlenkinsopBug 32450: Update db to add noissuescharge flag and...
2023-05-16 Julian MauriceBug 11844: Use additional fields for order lines
2023-05-15 Alex BuckleyBug 30418: Database changes
2023-05-15 Kyle HallBug 30649: Vendor EDI account passwords should be encry...
2023-05-12 Tomas Cohen AraziBug 33488: (QA follow-up) Fix index name
2023-05-12 Nick ClemensBug 33488: Add fromBranch index to branch_transfer_limits
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
next