From cf8882e3c1f5a5d78e58489a93ffc1c2aca35ce3 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 25 Jul 2022 09:48:16 +0200 Subject: [PATCH] bug 30392: DB changes --- .../data/mysql/atomicupdate/bug_30392.pl | 24 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 2 ++ 2 files changed, 26 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_30392.pl diff --git a/installer/data/mysql/atomicupdate/bug_30392.pl b/installer/data/mysql/atomicupdate/bug_30392.pl new file mode 100755 index 00000000000..b5e2a32d575 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_30392.pl @@ -0,0 +1,24 @@ +use Modern::Perl; + +return { + bug_number => "30392", + description => "Add deleteditems.deleted_on", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + unless ( column_exists('items', 'deleted_on') ) { + $dbh->do(q{ + ALTER TABLE items + ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion' + AFTER timestamp + }); + } + unless ( column_exists('deleteditems', 'deleted_on') ) { + $dbh->do(q{ + ALTER TABLE deleteditems + ADD COLUMN deleted_on DATETIME DEFAULT NULL COMMENT 'date of the deletion' + AFTER timestamp + }); + } + }, +}; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 6f43bdb954d..d14b6158b1e 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2578,6 +2578,7 @@ CREATE TABLE `deleteditems` ( `itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)', `holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)', `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered', + `deleted_on` DATETIME DEFAULT NULL COMMENT 'date of the deletion', `location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', `permanent_location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', `onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', @@ -3139,6 +3140,7 @@ CREATE TABLE `items` ( `itemnotes_nonpublic` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public notes on this item (MARC21 952$x)', `holdingbranch` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)', `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this item was last altered', + `deleted_on` DATETIME DEFAULT NULL COMMENT 'date of the deletion', `location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', `permanent_location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'linked to the CART and PROC temporary locations feature, stores the permanent shelving location', `onloan` date DEFAULT NULL COMMENT 'defines if item is checked out (NULL for not checked out, and due date for checked out)', -- 2.25.1