From e607493b56605a9676c4944a20fa093dea1fab0f Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Tue, 16 Apr 2019 02:30:04 +0000 Subject: [PATCH] Bug 15516: (follow-up) Fixing modal view and more Fixing - modal view - missed changes from 'reserve group' to 'hold group' - updating atomic update to perl Signed-off-by: Michal Denar Signed-off-by: Michal Denar --- installer/data/mysql/atomicupdate/bug_15516.sql | 11 -------- .../atomicupdate/bug_15516_-_hold_group_table.perl | 15 +++++++++++ .../prog/en/includes/hold-group-modal.inc | 30 +++++++++++----------- .../prog/en/modules/circ/circulation.tt | 2 +- reserve/placerequest.pl | 2 +- 5 files changed, 32 insertions(+), 28 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_15516.sql create mode 100644 installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl diff --git a/installer/data/mysql/atomicupdate/bug_15516.sql b/installer/data/mysql/atomicupdate/bug_15516.sql deleted file mode 100644 index bc2c0598f3..0000000000 --- a/installer/data/mysql/atomicupdate/bug_15516.sql +++ /dev/null @@ -1,11 +0,0 @@ -DROP TABLE IF EXISTS hold_group; -CREATE TABLE hold_group ( - hold_group_id int unsigned NOT NULL AUTO_INCREMENT, - PRIMARY KEY (hold_group_id) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - -ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL; -ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_6 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE; - -ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL; -ALTER TABLE old_reserves ADD CONSTRAINT old_reserves_ibfk_5 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE; diff --git a/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl b/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl new file mode 100644 index 0000000000..a2871bec82 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_15516_-_hold_group_table.perl @@ -0,0 +1,15 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do(q{DROP TABLE IF EXISTS hold_group}); + $dbh->do(q{CREATE TABLE hold_group ( + hold_group_id int unsigned NOT NULL AUTO_INCREMENT, + PRIMARY KEY (hold_group_id) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci}); + $dbh->do(q{ALTER TABLE reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); + $dbh->do(q{ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_6 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}); + $dbh->do(q{ALTER TABLE old_reserves ADD COLUMN hold_group_id int unsigned NULL DEFAULT NULL}); + $dbh->do(q{ALTER TABLE old_reserves ADD CONSTRAINT old_reserves_ibfk_5 FOREIGN KEY (hold_group_id) REFERENCES hold_group (hold_group_id) ON DELETE SET NULL ON UPDATE CASCADE}); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 15516 - Adding hold group table)\n"; +} diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/hold-group-modal.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/hold-group-modal.inc index 28469c6063..97339bcd9e 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/includes/hold-group-modal.inc +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/hold-group-modal.inc @@ -1,16 +1,16 @@ -