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

(-)a/installer/data/mysql/atomicupdate/bug_28813.perl (+17 lines)
Line 0 Link Here
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
}
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3619-3625 CREATE TABLE `message_queue` ( Link Here
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