Attachment #111450 for bug #26145

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

Lines 17-20 if( CheckVersion( $DBversion ) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx.perl (+9 lines)
17	}	17	}
18		18
19	NewVersion( $DBversion, 'XXXXX', "Add the biblioimages.itemnumber column");	19	NewVersion( $DBversion, 'XXXXX', "Add the biblioimages.itemnumber column");
		20
		21	if( !TableExists('cover_images') ) {
		22	$dbh->do(q\|
		23	ALTER TABLE biblioimages RENAME cover_images
		24	\|);
		25	}
		26
		27	# Always end with this (adjust the bug info)
		28	NewVersion( $DBversion, "XXXXX", "Rename table biblioimages with cover_images");
20	}	29	}




) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Table structure for table `cover_images`
--

DROP TABLE IF EXISTS `cover_images`;

CREATE TABLE `cover_images` ( -- local cover images
 `imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image
 `biblionumber` int(11) DEFAULT NULL, -- foreign key from biblio table to link to biblionumber
 `itemnumber` int(11) DEFAULT NULL, -- foreign key from item table to link to itemnumber
- 

Return to bug 26145

Lines 3367-3378 CREATE TABLE transport_cost ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
3367	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	3367	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3368		3368
3369	--	3369	--
3370	-- Table structure for table `biblioimages`	3370	-- Table structure for table `cover_images`
3371	--	3371	--
3372		3372
3373	DROP TABLE IF EXISTS `biblioimages`;	3373	DROP TABLE IF EXISTS `cover_images`;
3374		3374
3375	CREATE TABLE `biblioimages` ( -- local cover images	3375	CREATE TABLE `cover_images` ( -- local cover images
3376	`imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image	3376	`imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image
3377	`biblionumber` int(11) DEFAULT NULL, -- foreign key from biblio table to link to biblionumber	3377	`biblionumber` int(11) DEFAULT NULL, -- foreign key from biblio table to link to biblionumber
3378	`itemnumber` int(11) DEFAULT NULL, -- foreign key from item table to link to itemnumber	3378	`itemnumber` int(11) DEFAULT NULL, -- foreign key from item table to link to itemnumber
3379	-