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