From b1194c60da694b85e91f3b5a03389929abf1fc46 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 7 Jul 2023 06:41:27 +0000 Subject: [PATCH] Bug 33105: (QA follow-up) Small changes in dbrev Similar edit in kohastructure added. Signed-off-by: Marcel de Rooy Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/atomicupdate/bug_33105.pl | 5 ++--- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 3 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_33105.pl b/installer/data/mysql/atomicupdate/bug_33105.pl index 96b73cb142..462aa2cfa8 100755 --- a/installer/data/mysql/atomicupdate/bug_33105.pl +++ b/installer/data/mysql/atomicupdate/bug_33105.pl @@ -2,17 +2,16 @@ use Modern::Perl; return { bug_number => "33105", - description => "A vendor issues", + description => "Add vendor issues", up => sub { my ($args) = @_; my ($dbh, $out) = @$args{qw(dbh out)}; - # Do you stuffs here unless (TableExists('aqbookseller_issues')) { $dbh->do(q{ CREATE TABLE `aqbookseller_issues` ( `issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', - `type` varchar(80) DEFAULT NULL COMMENT "type of the issue, authorised value VENDOR_ISSUE_TYPE", + `type` varchar(80) DEFAULT NULL COMMENT 'type of the issue, authorised value VENDOR_ISSUE_TYPE', `started_on` date DEFAULT NULL COMMENT 'start of the issue', `ended_on` date DEFAULT NULL COMMENT 'end of the issue', `notes` longtext DEFAULT NULL COMMENT 'notes', diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 83c647698b..26552e76cd 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -476,7 +476,7 @@ DROP TABLE IF EXISTS `aqbookseller_issues`; CREATE TABLE `aqbookseller_issues` ( `issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key and unique identifier assigned by Koha', `vendor_id` int(11) NOT NULL COMMENT 'link to the vendor', - `type` varchar(80) DEFAULT NULL COMMENT "type of the issue, authorised value VENDOR_ISSUE_TYPE", + `type` varchar(80) DEFAULT NULL COMMENT 'type of the issue, authorised value VENDOR_ISSUE_TYPE', `started_on` date DEFAULT NULL COMMENT 'start of the issue', `ended_on` date DEFAULT NULL COMMENT 'end of the issue', `notes` longtext DEFAULT NULL COMMENT 'notes', -- 2.39.5