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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 181-187 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
181
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
181
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
182
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
182
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
183
  `totalissues` int(10),
183
  `totalissues` int(10),
184
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
184
  `marcxml` longtext, -- full bibliographic MARC record in MARCXML
185
  PRIMARY KEY  (`biblioitemnumber`),
185
  PRIMARY KEY  (`biblioitemnumber`),
186
  KEY `bibinoidx` (`biblioitemnumber`),
186
  KEY `bibinoidx` (`biblioitemnumber`),
187
  KEY `bibnoidx` (`biblionumber`),
187
  KEY `bibnoidx` (`biblionumber`),
Lines 812-818 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
812
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
812
  `cn_sort` varchar(255) default NULL, -- normalized version of the call number used for sorting
813
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
813
  `agerestriction` varchar(255) default NULL, -- target audience/age restriction from the bib record (MARC21 521$a)
814
  `totalissues` int(10),
814
  `totalissues` int(10),
815
  `marcxml` longtext NOT NULL, -- full bibliographic MARC record in MARCXML
815
  `marcxml` longtext, -- full bibliographic MARC record in MARCXML
816
  PRIMARY KEY  (`biblioitemnumber`),
816
  PRIMARY KEY  (`biblioitemnumber`),
817
  KEY `bibinoidx` (`biblioitemnumber`),
817
  KEY `bibinoidx` (`biblioitemnumber`),
818
  KEY `bibnoidx` (`biblionumber`),
818
  KEY `bibnoidx` (`biblionumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
Lines 9773-9778 if ( CheckVersion($DBversion) ) { Link Here
9773
    SetVersion ($DBversion);
9773
    SetVersion ($DBversion);
9774
}
9774
}
9775
9775
9776
$DBversion = "3.19.00.XXX";
9777
if(CheckVersion($DBversion)) {
9778
    $dbh->do(q{
9779
        ALTER TABLE biblioitems MODIFY COLUMN marcxml longtext
9780
    });
9781
9782
    $dbh->do(q{
9783
        ALTER TABLE deletedbiblioitems MODIFY COLUMN marcxml longtext
9784
    });
9785
9786
    print "Upgrade to $DBversion done (Bug 13523 - Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)\n";
9787
    SetVersion($DBversion);
9788
}
9789
9776
=head1 FUNCTIONS
9790
=head1 FUNCTIONS
9777
9791
9778
=head2 TableExists($table)
9792
=head2 TableExists($table)
9779
- 

Return to bug 13523