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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +3 lines)
Lines 755-762 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
755
  `volume` mediumtext,
755
  `volume` mediumtext,
756
  `number` mediumtext,
756
  `number` mediumtext,
757
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
757
  `itemtype` varchar(10) default NULL, -- biblio level item type (MARC21 942$c)
758
  `isbn` varchar(30) default NULL, -- ISBN (MARC21 020$a)
758
  `isbn` mediumtext default NULL, -- ISBN (MARC21 020$a)
759
  `issn` varchar(9) default NULL, -- ISSN (MARC21 022$a)
759
  `issn` mediumtext default NULL, -- ISSN (MARC21 022$a)
760
  `ean` varchar(13) default NULL,
760
  `ean` varchar(13) default NULL,
761
  `publicationyear` text,
761
  `publicationyear` text,
762
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
762
  `publishercode` varchar(255) default NULL, -- publisher (MARC21 260$b)
Lines 788-794 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here
788
  KEY `bibinoidx` (`biblioitemnumber`),
788
  KEY `bibinoidx` (`biblioitemnumber`),
789
  KEY `bibnoidx` (`biblionumber`),
789
  KEY `bibnoidx` (`biblionumber`),
790
  KEY `itemtype_idx` (`itemtype`),
790
  KEY `itemtype_idx` (`itemtype`),
791
  KEY `isbn` (`isbn`),
791
  KEY `isbn` (`isbn`(255)),
792
  KEY `publishercode` (`publishercode`)
792
  KEY `publishercode` (`publishercode`)
793
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
793
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
794
794
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +11 lines)
Lines 7965-7970 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7965
              ADD INDEX isbn ( isbn ( 255 ) ),
7965
              ADD INDEX isbn ( isbn ( 255 ) ),
7966
              ADD INDEX issn ( issn ( 255 ) )
7966
              ADD INDEX issn ( issn ( 255 ) )
7967
    ");
7967
    ");
7968
7969
    $dbh->do("ALTER TABLE deletedbiblioitems DROP INDEX isbn");
7970
    $dbh->do("ALTER TABLE deletedbiblioitems DROP INDEX issn");
7971
    $dbh->do("ALTER TABLE deletedbiblioitems
7972
              CHANGE isbn isbn MEDIUMTEXT NULL DEFAULT NULL,
7973
              CHANGE issn issn MEDIUMTEXT NULL DEFAULT NULL
7974
    ");
7975
    $dbh->do("ALTER TABLE deletedbiblioitems 
7976
              ADD INDEX isbn ( isbn ( 255 ) )
7977
    ");
7978
7968
    print "Upgrade to $DBversion done (Bug 11268 - Biblioitems URL field is too small for some URLs)\n";
7979
    print "Upgrade to $DBversion done (Bug 11268 - Biblioitems URL field is too small for some URLs)\n";
7969
    SetVersion($DBversion);
7980
    SetVersion($DBversion);
7970
}
7981
}
7971
- 

Return to bug 5377