From c9df54f049f0bb0ca94507da13864710f81dbc89 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 13 Nov 2019 15:06:23 +0100 Subject: [PATCH] Bug 22784: DB Changes MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Sponsored-by: BULAC - http://www.bulac.fr/ Signed-off-by: Séverine QUEUNE --- Koha/Schema/Result/Suggestion.pm | 4 +++- installer/data/mysql/atomicupdate/bug_22784.perl | 11 +++++++++++ installer/data/mysql/kohastructure.sql | 1 + 3 files changed, 15 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_22784.perl diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm index f049f89..56a9235 100644 --- a/Koha/Schema/Result/Suggestion.pm +++ b/Koha/Schema/Result/Suggestion.pm @@ -479,6 +479,8 @@ __PACKAGE__->belongs_to( # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-11-14 15:44:38 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qZuiiZgd+ry97OSngYckSA +__PACKAGE__->add_columns( + '+archived' => { is_boolean => 1 }, +); -# You can replace this text with custom content, and it will be preserved on regeneration 1; diff --git a/installer/data/mysql/atomicupdate/bug_22784.perl b/installer/data/mysql/atomicupdate/bug_22784.perl new file mode 100644 index 0000000..ca7a68a --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_22784.perl @@ -0,0 +1,11 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + if( !column_exists( 'suggestions', 'archived' ) ) { + $dbh->do(q| + ALTER TABLE suggestions ADD COLUMN archived INT(1) NOT NULL DEFAULT 0 AFTER `STATUS`; + |); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 22784 - Add a new suggestions.archived column)\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index c83fb33..97dfca3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3029,6 +3029,7 @@ CREATE TABLE `suggestions` ( -- purchase suggestions lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time lastmodificationdate date default NULL, -- date of the last modification `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) + `archived` INT(1) NOT NULL DEFAULT 0, -- is the suggestion archived? `note` LONGTEXT, -- note entered on the suggestion `author` varchar(80) default NULL, -- author of the suggested item `title` varchar(255) default NULL, -- title of the suggested item -- 2.1.4