From 53183f7b8cd7e85f6b137a5ce8ea59a04d3e99f8 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Wed, 8 Oct 2025 15:23:25 +0000 Subject: [PATCH] Bug 15516: (follow-up) DBRev nneds to include everything from the kohastructure --- installer/data/mysql/db_revs/250600012.pl | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/db_revs/250600012.pl b/installer/data/mysql/db_revs/250600012.pl index a6d61dbdac6..d860fbb8aaf 100755 --- a/installer/data/mysql/db_revs/250600012.pl +++ b/installer/data/mysql/db_revs/250600012.pl @@ -18,7 +18,8 @@ return { unless ( column_exists( 'reserves', 'hold_group_id' ) ) { $dbh->do( - q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL AFTER non_priority}); + q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked' AFTER non_priority} + ); $dbh->do(q{ALTER TABLE reserves ADD KEY reserves_ibfk_hg (hold_group_id)}); $dbh->do( q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_hg FOREIGN KEY (hold_group_id) REFERENCES hold_groups (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE} @@ -27,7 +28,8 @@ return { unless ( column_exists( 'old_reserves', 'hold_group_id' ) ) { $dbh->do( - q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL AFTER non_priority}); + q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL COMMENT 'The id of a group of titles reservations fulfilled when one title is picked' AFTER non_priority} + ); $dbh->do(q{ALTER TABLE old_reserves ADD KEY old_reserves_ibfk_hg (hold_group_id)}); $dbh->do( q{ALTER TABLE old_reserves ADD CONSTRAINT old_reserves_ibfk_hg FOREIGN KEY (hold_group_id) REFERENCES hold_groups (hold_group_id) ON DELETE SET NULL ON UPDATE SET NULL} -- 2.39.5