`overduenoticerequired` tinyint(1) default NULL,
`issuelimit` smallint(6) default NULL,
`reservefee` decimal(28,6) default NULL,
+ `hidelostitems` tinyint(1) NOT NULL default '0',
`category_type` varchar(1) NOT NULL default 'A',
PRIMARY KEY (`categorycode`),
UNIQUE KEY `categorycode` (`categorycode`)
`currency` varchar(10) NOT NULL default '',
`symbol` varchar(5) default NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- `rate` float(7,5) default NULL,
+ `rate` float(15,5) default NULL,
`active` tinyint(1) default NULL,
PRIMARY KEY (`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
`uri` varchar(255) default NULL,
`itype` varchar(10) default NULL,
`more_subfields_xml` longtext default NULL,
- `enumchron` varchar(80) default NULL,
+ `enumchron` text default NULL,
`copynumber` varchar(32) default NULL,
`stocknumber` varchar(32) default NULL,
`marc` longblob,
`chargename` varchar(100) default NULL,
`maxissueqty` int(4) default NULL,
`issuelength` int(4) default NULL,
+ `hardduedate` date default NULL,
+ `hardduedatecompare` tinyint NOT NULL default "0",
`renewalsallowed` smallint(6) NOT NULL default "0",
`reservesallowed` smallint(6) NOT NULL default "0",
`branchcode` varchar(10) NOT NULL default '',
`uri` varchar(255) default NULL,
`itype` varchar(10) default NULL,
`more_subfields_xml` longtext default NULL,
- `enumchron` varchar(80) default NULL,
+ `enumchron` text default NULL,
`copynumber` varchar(32) default NULL,
`stocknumber` varchar(32) default NULL,
PRIMARY KEY (`itemnumber`),
UNIQUE KEY `itembarcodeidx` (`barcode`),
- UNIQUE KEY `itemstocknumberidx` (`stocknumber`),
+ KEY `itemstocknumberidx` (`stocknumber`),
KEY `itembinoidx` (`biblioitemnumber`),
KEY `itembibnoidx` (`biblionumber`),
KEY `homebranch` (`homebranch`),
`name` varchar(50) default NULL,
`closed` tinyint(1) default NULL,
`booksellerid` int(11) NOT NULL,
+ `deliveryplace` varchar(10) default NULL,
+ `deliverycomment` varchar(255) default NULL,
+ `billingplace` varchar(10) default NULL,
PRIMARY KEY (`id`),
KEY `booksellerid` (`booksellerid`),
CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE