Attachment #25492 for bug #5377

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

Lines 755-762 CREATE TABLE `deletedbiblioitems` ( -- information about bibliographic records t Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 / +3 lines)
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




              ADD INDEX isbn ( isbn ( 255 ) ),
              ADD INDEX issn ( issn ( 255 ) )
    ");

    $dbh->do("ALTER TABLE deletedbiblioitems DROP INDEX isbn");
    $dbh->do("ALTER TABLE deletedbiblioitems DROP INDEX issn");
    $dbh->do("ALTER TABLE deletedbiblioitems
              CHANGE isbn isbn MEDIUMTEXT NULL DEFAULT NULL,
              CHANGE issn issn MEDIUMTEXT NULL DEFAULT NULL
    ");
    $dbh->do("ALTER TABLE deletedbiblioitems 
              ADD INDEX isbn ( isbn ( 255 ) )
    ");

    print "Upgrade to $DBversion done (Bug 11268 - Biblioitems URL field is too small for some URLs)\n";
    SetVersion($DBversion);
}
- 

Return to bug 5377

Lines 7965-7970 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +11 lines)
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	-