From 7417c68e4cd9b8c202dd1192bc43aa673c667e2c Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 11 Mar 2022 15:05:23 +0000 Subject: [PATCH] Bug 30275: Add checkout_renewals table This patch adds the new checkout_renewals table using an atomicupdate --- .../data/mysql/atomicupdate/bug_30275.pl | 26 +++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_30275.pl diff --git a/installer/data/mysql/atomicupdate/bug_30275.pl b/installer/data/mysql/atomicupdate/bug_30275.pl new file mode 100755 index 0000000000..b567dfb852 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_30275.pl @@ -0,0 +1,26 @@ +use Modern::Perl; + +return { + bug_number => "30275", + description => "Add a checkout_renewals table", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + unless ( TableExists('checkout_renewals') ) { + $dbh->do(q{ + CREATE TABLE `checkout_renewals` ( + `id` int(11) NOT NULL auto_increment, + `issue_id` int(11) DEFAULT NULL COMMENT 'the id of the issue this renewal pertains to', + `renewer_id` int(11) DEFAULT NULL COMMENT 'the id of the user who processed the renewal', + `seen` tinyint(1) DEFAULT 0 COMMENT 'boolean denoting whether the item was present or not', + `interface` varchar(16) NOT NULL COMMENT 'the interface this renewal took place on', + `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'the date and time the renewal took place', + PRIMARY KEY(`id`), + KEY `renewer_id` (`renewer_id`), + CONSTRAINT `renewals_renewer_id` FOREIGN KEY (`renewer_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + }); + say $out "Added new table 'checkout_renewals'"; + } + }, +} -- 2.20.1