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

(-)a/installer/data/mysql/kohastructure.sql (-35 / +34 lines)
Lines 146-184 CREATE TABLE `biblio_framework` ( Link Here
146
--
146
--
147
147
148
DROP TABLE IF EXISTS `biblioitems`;
148
DROP TABLE IF EXISTS `biblioitems`;
149
CREATE TABLE `biblioitems` (
149
CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Koha
150
  `biblioitemnumber` int(11) NOT NULL auto_increment,
150
  `biblioitemnumber` int(11) NOT NULL auto_increment, -- primary key, unique identifier assigned by Koha
151
  `biblionumber` int(11) NOT NULL default 0,
151
  `biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
152
  `volume` mediumtext,
152
  `volume` mediumtext,
153
  `number` mediumtext,
153
  `number` mediumtext,
154
  `itemtype` varchar(10) default NULL,
154
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
155
  `isbn` varchar(30) default NULL,
155
  `isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a)
156
  `issn` varchar(9) default NULL,
156
  `issn` varchar(9) default NULL, -- ISSN (MARC21 022$a)
157
  `publicationyear` text,
157
  `publicationyear` text,
158
  `publishercode` varchar(255) default NULL,
158
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
159
  `volumedate` date default NULL,
159
  `volumedate` date default NULL,
160
  `volumedesc` text,
160
  `volumedesc` text, -- volume information (MARC21 362$a)
161
  `collectiontitle` mediumtext default NULL,
161
  `collectiontitle` mediumtext default NULL,
162
  `collectionissn` text default NULL,
162
  `collectionissn` text default NULL,
163
  `collectionvolume` mediumtext default NULL,
163
  `collectionvolume` mediumtext default NULL,
164
  `editionstatement` text default NULL,
164
  `editionstatement` text default NULL,
165
  `editionresponsibility` text default NULL,
165
  `editionresponsibility` text default NULL,
166
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
166
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
167
  `illus` varchar(255) default NULL,
167
  `illus` varchar(255) default NULL, -- illustrations (MARC21 300$b)
168
  `pages` varchar(255) default NULL,
168
  `pages` varchar(255) default NULL, -- number of pages (MARC21 300$c)
169
  `notes` mediumtext,
169
  `notes` mediumtext,
170
  `size` varchar(255) default NULL,
170
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
171
  `place` varchar(255) default NULL,
171
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
172
  `lccn` varchar(25) default NULL,
172
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
173
  `marc` longblob,
173
  `marc` longblob, -- full bibliographic MARC record
174
  `url` varchar(255) default NULL,
174
  `url` varchar(255) default NULL, -- url (MARC21 856$u)
175
  `cn_source` varchar(10) default NULL,
175
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
176
  `cn_class` varchar(30) default NULL,
176
  `cn_class` varchar(30) default NULL,
177
  `cn_item` varchar(10) default NULL,
177
  `cn_item` varchar(10) default NULL,
178
  `cn_suffix` varchar(10) default NULL,
178
  `cn_suffix` varchar(10) default NULL,
179
  `cn_sort` varchar(30) default NULL,
179
  `cn_sort` varchar(30) default NULL,
180
  `totalissues` int(10),
180
  `totalissues` int(10),
181
  `marcxml` longtext NOT NULL,
181
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
182
  PRIMARY KEY  (`biblioitemnumber`),
182
  PRIMARY KEY  (`biblioitemnumber`),
183
  KEY `bibinoidx` (`biblioitemnumber`),
183
  KEY `bibinoidx` (`biblioitemnumber`),
184
  KEY `bibnoidx` (`biblionumber`),
184
  KEY `bibnoidx` (`biblionumber`),
Lines 610-648 CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records Link Here
610
--
610
--
611
611
612
DROP TABLE IF EXISTS `deletedbiblioitems`;
612
DROP TABLE IF EXISTS `deletedbiblioitems`;
613
CREATE TABLE `deletedbiblioitems` (
613
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records that have been deleted
614
  `biblioitemnumber` int(11) NOT NULL default 0,
614
  `biblioitemnumber` int(11) NOT NULL default 0, -- primary key, unique identifier assigned by Koha
615
  `biblionumber` int(11) NOT NULL default 0,
615
  `biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
616
  `volume` mediumtext,
616
  `volume` mediumtext,
617
  `number` mediumtext,
617
  `number` mediumtext,
618
  `itemtype` varchar(10) default NULL,
618
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
619
  `isbn` varchar(30) default NULL,
619
  `isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a)
620
  `issn` varchar(9) default NULL,
620
  `issn` varchar(9) default NULL, -- ISSN (MARC21 022$a)
621
  `publicationyear` text,
621
  `publicationyear` text,
622
  `publishercode` varchar(255) default NULL,
622
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
623
  `volumedate` date default NULL,
623
  `volumedate` date default NULL,
624
  `volumedesc` text,
624
  `volumedesc` text, -- volume information (MARC21 362$a)
625
  `collectiontitle` mediumtext default NULL,
625
  `collectiontitle` mediumtext default NULL,
626
  `collectionissn` text default NULL,
626
  `collectionissn` text default NULL,
627
  `collectionvolume` mediumtext default NULL,
627
  `collectionvolume` mediumtext default NULL,
628
  `editionstatement` text default NULL,
628
  `editionstatement` text default NULL,
629
  `editionresponsibility` text default NULL,
629
  `editionresponsibility` text default NULL,
630
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
630
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
631
  `illus` varchar(255) default NULL,
631
  `illus` varchar(255) default NULL, -- illustrations (MARC21 300$b)
632
  `pages` varchar(255) default NULL,
632
  `pages` varchar(255) default NULL, -- number of pages (MARC21 300$c)
633
  `notes` mediumtext,
633
  `notes` mediumtext,
634
  `size` varchar(255) default NULL,
634
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
635
  `place` varchar(255) default NULL,
635
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
636
  `lccn` varchar(25) default NULL,
636
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
637
  `marc` longblob,
637
  `marc` longblob, -- full bibliographic MARC record
638
  `url` varchar(255) default NULL,
638
  `url` varchar(255) default NULL, -- url (MARC21 856$u)
639
  `cn_source` varchar(10) default NULL,
639
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
640
  `cn_class` varchar(30) default NULL,
640
  `cn_class` varchar(30) default NULL,
641
  `cn_item` varchar(10) default NULL,
641
  `cn_item` varchar(10) default NULL,
642
  `cn_suffix` varchar(10) default NULL,
642
  `cn_suffix` varchar(10) default NULL,
643
  `cn_sort` varchar(30) default NULL,
643
  `cn_sort` varchar(30) default NULL,
644
  `totalissues` int(10),
644
  `totalissues` int(10),
645
  `marcxml` longtext NOT NULL,
645
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
646
  PRIMARY KEY  (`biblioitemnumber`),
646
  PRIMARY KEY  (`biblioitemnumber`),
647
  KEY `bibinoidx` (`biblioitemnumber`),
647
  KEY `bibinoidx` (`biblioitemnumber`),
648
  KEY `bibnoidx` (`biblionumber`),
648
  KEY `bibnoidx` (`biblionumber`),
649
- 

Return to bug 6716