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 609-647 CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records Link Here
609
--
609
--
610
610
611
DROP TABLE IF EXISTS `deletedbiblioitems`;
611
DROP TABLE IF EXISTS `deletedbiblioitems`;
612
CREATE TABLE `deletedbiblioitems` (
612
CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records that have been deleted
613
  `biblioitemnumber` int(11) NOT NULL default 0,
613
  `biblioitemnumber` int(11) NOT NULL default 0, -- primary key, unique identifier assigned by Koha
614
  `biblionumber` int(11) NOT NULL default 0,
614
  `biblionumber` int(11) NOT NULL default 0, -- foreign key linking this table to the biblio table
615
  `volume` mediumtext,
615
  `volume` mediumtext,
616
  `number` mediumtext,
616
  `number` mediumtext,
617
  `itemtype` varchar(10) default NULL,
617
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
618
  `isbn` varchar(30) default NULL,
618
  `isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a)
619
  `issn` varchar(9) default NULL,
619
  `issn` varchar(9) default NULL, -- ISSN (MARC21 022$a)
620
  `publicationyear` text,
620
  `publicationyear` text,
621
  `publishercode` varchar(255) default NULL,
621
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
622
  `volumedate` date default NULL,
622
  `volumedate` date default NULL,
623
  `volumedesc` text,
623
  `volumedesc` text, -- volume information (MARC21 362$a)
624
  `collectiontitle` mediumtext default NULL,
624
  `collectiontitle` mediumtext default NULL,
625
  `collectionissn` text default NULL,
625
  `collectionissn` text default NULL,
626
  `collectionvolume` mediumtext default NULL,
626
  `collectionvolume` mediumtext default NULL,
627
  `editionstatement` text default NULL,
627
  `editionstatement` text default NULL,
628
  `editionresponsibility` text default NULL,
628
  `editionresponsibility` text default NULL,
629
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
629
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
630
  `illus` varchar(255) default NULL,
630
  `illus` varchar(255) default NULL, -- illustrations (MARC21 300$b)
631
  `pages` varchar(255) default NULL,
631
  `pages` varchar(255) default NULL, -- number of pages (MARC21 300$c)
632
  `notes` mediumtext,
632
  `notes` mediumtext,
633
  `size` varchar(255) default NULL,
633
  `size` varchar(255) default NULL, -- material size (MARC21 300$c)
634
  `place` varchar(255) default NULL,
634
  `place` varchar(255) default NULL, -- publication place (MARC21 260$a)
635
  `lccn` varchar(25) default NULL,
635
  `lccn` varchar(25) default NULL, -- library of congress control number (MARC21 010$a)
636
  `marc` longblob,
636
  `marc` longblob, -- full bibliographic MARC record
637
  `url` varchar(255) default NULL,
637
  `url` varchar(255) default NULL, -- url (MARC21 856$u)
638
  `cn_source` varchar(10) default NULL,
638
  `cn_source` varchar(10) default NULL, -- classification source (MARC21 942$2)
639
  `cn_class` varchar(30) default NULL,
639
  `cn_class` varchar(30) default NULL,
640
  `cn_item` varchar(10) default NULL,
640
  `cn_item` varchar(10) default NULL,
641
  `cn_suffix` varchar(10) default NULL,
641
  `cn_suffix` varchar(10) default NULL,
642
  `cn_sort` varchar(30) default NULL,
642
  `cn_sort` varchar(30) default NULL,
643
  `totalissues` int(10),
643
  `totalissues` int(10),
644
  `marcxml` longtext NOT NULL,
644
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
645
  PRIMARY KEY  (`biblioitemnumber`),
645
  PRIMARY KEY  (`biblioitemnumber`),
646
  KEY `bibinoidx` (`biblioitemnumber`),
646
  KEY `bibinoidx` (`biblioitemnumber`),
647
  KEY `bibnoidx` (`biblionumber`),
647
  KEY `bibnoidx` (`biblionumber`),
648
- 

Return to bug 6716