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 9779-9784 if ( CheckVersion($DBversion) ) { Link Here
9779
    SetVersion ($DBversion);
9779
    SetVersion ($DBversion);
9780
}
9780
}
9781
9781
9782
$DBversion = "3.19.00.XXX";
9783
if(CheckVersion($DBversion)) {
9784
    $dbh->do(q{
9785
        ALTER TABLE biblioitems MODIFY COLUMN marcxml longtext
9786
    });
9787
9788
    $dbh->do(q{
9789
        ALTER TABLE deletedbiblioitems MODIFY COLUMN marcxml longtext
9790
    });
9791
9792
    print "Upgrade to $DBversion done (Bug 13523 - Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)\n";
9793
    SetVersion($DBversion);
9794
}
9795
9782
=head1 FUNCTIONS
9796
=head1 FUNCTIONS
9783
9797
9784
=head2 TableExists($table)
9798
=head2 TableExists($table)
9785
- 

Return to bug 13523