Attachment #123536 for bug #28813

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    if ( column_exists('message_queue', 'delivery_note') ) {
        $dbh->do(q{
            ALTER TABLE message_queue CHANGE COLUMN delivery_note failure_code MEDIUMTEXT;
        });
    }

    if( !column_exists( 'message_queue', 'failure_code' ) ) {
        $dbh->do(q{
            ALTER TABLE message_queue ADD failure_code mediumtext AFTER content_type
        });
    }

    # Always end with this (adjust the bug info)
    NewVersion( $DBversion, 28813, "Update delivery_note to failure_code in message_queue");
}

Lines 3619-3625 CREATE TABLE `message_queue` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
3619	`from_address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3619	`from_address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3620	`reply_address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3620	`reply_address` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3621	`content_type` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3621	`content_type` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3622	`delivery_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,	3622	`failure_code` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
3623	PRIMARY KEY (`message_id`),	3623	PRIMARY KEY (`message_id`),
3624	KEY `borrowernumber` (`borrowernumber`),	3624	KEY `borrowernumber` (`borrowernumber`),
3625	KEY `message_transport_type` (`message_transport_type`),	3625	KEY `message_transport_type` (`message_transport_type`),
3626	-

Return to bug 28813

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_28813.perl (+17 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3	if ( column_exists('message_queue', 'delivery_note') ) {
	4	$dbh->do(q{
	5	ALTER TABLE message_queue CHANGE COLUMN delivery_note failure_code MEDIUMTEXT;
	6	});
	7	}
	8
	9	if( !column_exists( 'message_queue', 'failure_code' ) ) {
	10	$dbh->do(q{
	11	ALTER TABLE message_queue ADD failure_code mediumtext AFTER content_type
	12	});
	13	}
	14
	15	# Always end with this (adjust the bug info)
	16	NewVersion( $DBversion, 28813, "Update delivery_note to failure_code in message_queue");
	17	}