No subject
Mon Jul 7 17:18:21 NZST 2008
CREATE TABLE categoryitem (
categorycode char(2) DEFAULT '' NOT NULL,
itemtype varchar(4) DEFAULT '' NOT NULL,
restrictedtype tinyint(1),
rentaldiscount decimal(28,6),
reservecharge decimal(28,6),
fine decimal(28,6),
firstremind int(11),
chargeperiod int(11),
accountsent int(11),
chargename varchar(100)
);
That was the old categoryitem table, (from the database.mysql file
2002-06-22) .
And I just checked issuingrules, the column is still there,
CREATE TABLE `issuingrules` (
`categorycode` varchar(10) NOT NULL default '',
`itemtype` varchar(10) NOT NULL default '',
`restrictedtype` tinyint(1) default NULL,
`rentaldiscount` decimal(28,6) default NULL,
`reservecharge` decimal(28,6) default NULL,
`fine` decimal(28,6) default NULL,
`firstremind` int(11) default NULL,
`chargeperiod` int(11) default NULL,
`accountsent` int(11) default NULL,
`chargename` varchar(100) default NULL,
`maxissueqty` int(4) default NULL,
`issuelength` int(4) default NULL,
`branchcode` varchar(10) NOT NULL default '',
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),
KEY `categorycode` (`categorycode`),
KEY `itemtype` (`itemtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
So it might be just the code is no longer respecting it.
Chris
More information about the Koha
mailing list