View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 177-184 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
177
  `cn_class` varchar(30) default NULL,
177
  `cn_class` varchar(30) default NULL,
178
  `cn_item` varchar(10) default NULL,
178
  `cn_item` varchar(10) default NULL,
179
  `cn_suffix` varchar(10) default NULL,
179
  `cn_suffix` varchar(10) default NULL,
180
  `cn_sort` varchar(30) default NULL,
180
  `cn_sort` varchar(30) default NULL, -- normalized version of the call number used for sorting
181
  `agerestriction` varchar(255) default NULL,
181
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
182
  `totalissues` int(10),
182
  `totalissues` int(10),
183
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
183
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
184
  PRIMARY KEY  (`biblioitemnumber`),
184
  PRIMARY KEY  (`biblioitemnumber`),
Lines 650-657 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
650
  `cn_class` varchar(30) default NULL,
650
  `cn_class` varchar(30) default NULL,
651
  `cn_item` varchar(10) default NULL,
651
  `cn_item` varchar(10) default NULL,
652
  `cn_suffix` varchar(10) default NULL,
652
  `cn_suffix` varchar(10) default NULL,
653
  `cn_sort` varchar(30) default NULL,
653
  `cn_sort` varchar(30) default NULL, -- normalized version of the call number used for sorting
654
  `agerestriction` varchar(255) default NULL,
654
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
655
  `totalissues` int(10),
655
  `totalissues` int(10),
656
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
656
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
657
  PRIMARY KEY  (`biblioitemnumber`),
657
  PRIMARY KEY  (`biblioitemnumber`),
658
- 

Return to bug 6716