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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +4 lines)
Lines 153-160 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
153
  `volume` mediumtext,
153
  `volume` mediumtext,
154
  `number` mediumtext,
154
  `number` mediumtext,
155
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
155
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
156
  `isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a)
156
  `isbn` mediumtext, -- ISBN (MARC21 020$a)
157
  `issn` varchar(9) default NULL, -- ISSN (MARC21 022$a)
157
  `issn` mediumtext, -- ISSN (MARC21 022$a)
158
  `ean` varchar(13) default NULL,
158
  `ean` varchar(13) default NULL,
159
  `publicationyear` text,
159
  `publicationyear` text,
160
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
160
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
Lines 186-193 CREATE TABLE `biblioitems` ( -- information related to bibliographic records in Link Here
186
  KEY `bibinoidx` (`biblioitemnumber`),
186
  KEY `bibinoidx` (`biblioitemnumber`),
187
  KEY `bibnoidx` (`biblionumber`),
187
  KEY `bibnoidx` (`biblionumber`),
188
  KEY `itemtype_idx` (`itemtype`),
188
  KEY `itemtype_idx` (`itemtype`),
189
  KEY `isbn` (`isbn`),
189
  KEY `isbn` (`isbn`(255)),
190
  KEY `issn` (`issn`),
190
  KEY `issn` (`issn`(255)),
191
  KEY `publishercode` (`publishercode`),
191
  KEY `publishercode` (`publishercode`),
192
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
192
  CONSTRAINT `biblioitems_ibfk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
193
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
193
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +16 lines)
Lines 7953-7958 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7953
    SetVersion($DBversion);
7953
    SetVersion($DBversion);
7954
}
7954
}
7955
7955
7956
$DBversion = "3.15.00.XXX";
7957
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
7958
    $dbh->do("ALTER TABLE biblioitems DROP INDEX isbn");
7959
    $dbh->do("ALTER TABLE biblioitems DROP INDEX issn");
7960
    $dbh->do("ALTER TABLE biblioitems
7961
              CHANGE isbn isbn MEDIUMTEXT NULL DEFAULT NULL,
7962
              CHANGE issn issn MEDIUMTEXT NULL DEFAULT NULL
7963
    ");
7964
    $dbh->do("ALTER TABLE biblioitems
7965
              ADD INDEX isbn ( isbn ( 255 ) ),
7966
              ADD INDEX issn ( issn ( 255 ) )
7967
    ");
7968
    print "Upgrade to $DBversion done (Bug 11268 - Biblioitems URL field is too small for some URLs)\n";
7969
    SetVersion($DBversion);
7970
}
7971
7956
=head1 FUNCTIONS
7972
=head1 FUNCTIONS
7957
7973
7958
=head2 TableExists($table)
7974
=head2 TableExists($table)
7959
- 

Return to bug 5377