Attachment 124622 Details for Bug 28959 – Bug 28959: Move category => public

[patch] Bug 28959: Move category => public

Bug-28959-Move-category--public.patch (text/plain), 2.74 KB, created by Tomás Cohen Arazi (tcohen) on 2021-09-07 16:39:41 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2021-09-07 16:39:41 UTC

Size: 2.74 KB

patch

obsolete

>From 2181a50d2b2c73ef87352fa3a477a4dc59b9c1e3 Mon Sep 17 00:00:00 2001
>From: Tomas Cohen Arazi <tomascohen@theke.io>
>Date: Tue, 7 Sep 2021 08:06:59 -0300
>Subject: [PATCH] Bug 28959: Move category => public
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> .../data/mysql/atomicupdate/bug_28959.pl      | 30 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  2 +-
> 2 files changed, 31 insertions(+), 1 deletion(-)
> create mode 100755 installer/data/mysql/atomicupdate/bug_28959.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_28959.pl b/installer/data/mysql/atomicupdate/bug_28959.pl
>new file mode 100755
>index 0000000000..f3061d99bf
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_28959.pl
>@@ -0,0 +1,30 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "28959",
>+    description => "virtualshelves.category is really a boolean",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh) = @$args{qw(dbh)};
>+
>+        unless( column_exists( 'virtualshelves', 'public' ) ) {
>+            # Add column
>+            $dbh->do(q{
>+                ALTER TABLE virtualshelves
>+                    ADD COLUMN `public` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'If the list is public'
>+                    AFTER `owner`;
>+            });
>+            # Set public lists
>+            $dbh->do(q{
>+                UPDATE virtualshelves
>+                SET public = 1
>+                WHERE category = 2;
>+            });
>+            # Drop old column
>+            $dbh->do(q{
>+                ALTER TABLE virtualshelves
>+                    DROP COLUMN `category`;
>+            });
>+        }
>+    },
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 02cf864ddd..86bd4a152c 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -5271,7 +5271,7 @@ CREATE TABLE `virtualshelves` (
>   `shelfnumber` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier assigned by Koha',
>   `shelfname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'name of the list',
>   `owner` int(11) DEFAULT NULL COMMENT 'foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int)',
>-  `category` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'type of list (private [1], public [2])',
>+  `public` TINYINT(1) NOT NULL DEFAULT 0 COMMENT 'If the list is public',
>   `sortfield` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT 'title' COMMENT 'the field this list is sorted on',
>   `lastmodified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time the list was last modified',
>   `created_on` datetime NOT NULL COMMENT 'creation time',
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 28959: 124619 | 124620 | 124621 | 124622 | 124623 | 124624 | 124625 | 124663 | 124788 | 124799 | 124800 | 124801 | 124802 | 124803 | 124807 | 124808 | 124809 | 124810 | 124811 | 127046 | 127047 | 127048 | 127049 | 127050 | 127059 | 127060 | 127062 | 127142 | 127206 | 128036