http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6199
--- Comment #9 from Robin Sheat <[email protected]> 2011-05-30 23:48:44 UTC --- You don't say if you got any errors when you ran it. Also, can you put the output of: show create table items; here. Mine is: CREATE TABLE `items` ( `itemnumber` int(11) NOT NULL AUTO_INCREMENT, `biblionumber` int(11) NOT NULL DEFAULT '0', `biblioitemnumber` int(11) NOT NULL DEFAULT '0', `barcode` varchar(20) DEFAULT NULL, `dateaccessioned` date DEFAULT NULL, `booksellerid` mediumtext, `homebranch` varchar(10) DEFAULT NULL, `price` decimal(8,2) DEFAULT NULL, `replacementprice` decimal(8,2) DEFAULT NULL, `replacementpricedate` date DEFAULT NULL, `datelastborrowed` date DEFAULT NULL, `datelastseen` date DEFAULT NULL, `stack` tinyint(1) DEFAULT NULL, `notforloan` tinyint(1) NOT NULL DEFAULT '0', `damaged` tinyint(1) NOT NULL DEFAULT '0', `itemlost` tinyint(1) NOT NULL DEFAULT '0', `wthdrawn` tinyint(1) NOT NULL DEFAULT '0', `itemcallnumber` varchar(255) DEFAULT NULL, `issues` smallint(6) DEFAULT NULL, `renewals` smallint(6) DEFAULT NULL, `reserves` smallint(6) DEFAULT NULL, `restricted` tinyint(1) DEFAULT NULL, `itemnotes` mediumtext, `holdingbranch` varchar(10) DEFAULT NULL, `paidfor` mediumtext, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `location` varchar(80) DEFAULT NULL, `permanent_location` varchar(80) DEFAULT NULL, `onloan` date DEFAULT NULL, `cn_source` varchar(10) DEFAULT NULL, `cn_sort` varchar(30) DEFAULT NULL, `ccode` varchar(10) DEFAULT NULL, `materials` varchar(10) DEFAULT NULL, `uri` varchar(255) DEFAULT NULL, `itype` varchar(10) DEFAULT NULL, `more_subfields_xml` longtext, `enumchron` text, `copynumber` varchar(32) DEFAULT NULL, `stocknumber` varchar(32) DEFAULT NULL COMMENT 'stores the inventory number', PRIMARY KEY (`itemnumber`), UNIQUE KEY `itembarcodeidx` (`barcode`), KEY `itembinoidx` (`biblioitemnumber`), KEY `itembibnoidx` (`biblionumber`), KEY `homebranch` (`homebranch`), KEY `holdingbranch` (`holdingbranch`), KEY `itemstocknumberidx` (`stocknumber`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
