[Koha-bugs] [Bug 13624] Remove columns branchcode, categorytype from table overduerules_transport_types

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Mar 4 02:45:30 CET 2016


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13624

Nick Clemens <nick at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nick at bywatersolutions.com

--- Comment #44 from Nick Clemens <nick at bywatersolutions.com> ---
On a fresh DB I am having issues with the loss of the 'letternumber' column 

overdue_notices.pl throws errors for unknown column, I can't save triggers 

I think the last line below was an accidental deletion?

diff --git a/installer/data/mysql/kohastructure.sql
b/installer/data/mysql/kohastructure.sql
...
@@ -2568,12 +2569,10 @@ CREATE TABLE `message_transport_types` (
 DROP TABLE IF EXISTS `overduerules_transport_types`;
 CREATE TABLE overduerules_transport_types(
     `id` INT(11) NOT NULL AUTO_INCREMENT,
-    `branchcode` varchar(10) NOT NULL DEFAULT '',
-    `categorycode` VARCHAR(10) NOT NULL DEFAULT '',
-    `letternumber` INT(1) NOT NULL DEFAULT 1,

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list