Attachment 95499 Details for Bug 22784 – Bug 22784: DB Changes

[patch] Bug 22784: DB Changes

Bug-22784-DB-Changes.patch (text/plain), 2.59 KB, created by Jonathan Druart on 2019-11-18 11:09:02 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2019-11-18 11:09:02 UTC

Size: 2.59 KB

patch

obsolete

>From 6e3c61e9fb30bb630a4a8e9a95fcef1b9746f32d Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 13 Nov 2019 15:06:23 +0100
>Subject: [PATCH] Bug 22784: DB Changes
>
>Sponsored-by: BULAC - http://www.bulac.fr/
>---
> 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 f049f8966c..56a9235978 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 0000000000..ca7a68a08d
>--- /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 c83fb338b1..97dfca32aa 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.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 22784: 95499 | 95500 | 95501 | 95502 | 95510 | 95511 | 95512 | 95513 | 95533 | 95534 | 95535 | 95536 | 95537 | 95538 | 96900 | 96901 | 96902 | 96903 | 96904 | 96905 | 100806 | 100807 | 100808 | 100809 | 100810 | 100811 | 100854 | 100855 | 100856 | 100857 | 100858 | 100859 | 101948 | 102779 | 102780 | 102781 | 102782 | 102783 | 102784 | 102785 | 102786 | 102944