Attachment #117585 for bug #26057

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {

    if( !column_exists( 'branchtransfers', 'datecancelled' ) ) {
        $dbh->do( "ALTER TABLE `branchtransfers` ADD COLUMN `datecancelled` datetime default NULL AFTER `datearrived`" );
    }

    if( !column_exists( 'branchtransfers', 'cancellation_reason' ) ) {
        $dbh->do( "ALTER TABLE `branchtransfers` ADD COLUMN `cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve') DEFAULT NULL AFTER `reason`" );
    }

    NewVersion( $DBversion, 26057, "Add datecancelled field to branchtransfers");
}




  `datesent` datetime DEFAULT NULL COMMENT 'the date the transfer was initialized',
  `frombranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer is coming from',
  `datearrived` datetime DEFAULT NULL COMMENT 'the date the transfer arrived at its destination',
  `datecancelled` datetime default NULL COMMENT 'the date the transfer was cancelled',
  `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
  `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
  `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
  `cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve') default NULL COMMENT 'what triggered the transfer cancellation',
  PRIMARY KEY (`branchtransfer_id`),
  KEY `frombranch` (`frombranch`),
  KEY `tobranch` (`tobranch`),
- 

Return to bug 26057

Lines 1527-1535 CREATE TABLE `branchtransfers` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
1527	`datesent` datetime DEFAULT NULL COMMENT 'the date the transfer was initialized',	1527	`datesent` datetime DEFAULT NULL COMMENT 'the date the transfer was initialized',
1528	`frombranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer is coming from',	1528	`frombranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer is coming from',
1529	`datearrived` datetime DEFAULT NULL COMMENT 'the date the transfer arrived at its destination',	1529	`datearrived` datetime DEFAULT NULL COMMENT 'the date the transfer arrived at its destination',
		1530	`datecancelled` datetime default NULL COMMENT 'the date the transfer was cancelled',
1530	`tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',	1531	`tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',
1531	`comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',	1532	`comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',
1532	`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',	1533	`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer',
		1534	`cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve') default NULL COMMENT 'what triggered the transfer cancellation',
1533	PRIMARY KEY (`branchtransfer_id`),	1535	PRIMARY KEY (`branchtransfer_id`),
1534	KEY `frombranch` (`frombranch`),	1536	KEY `frombranch` (`frombranch`),
1535	KEY `tobranch` (`tobranch`),	1537	KEY `tobranch` (`tobranch`),
1536	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_26057.perl (+13 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	if( !column_exists( 'branchtransfers', 'datecancelled' ) ) {
	5	$dbh->do( "ALTER TABLE `branchtransfers` ADD COLUMN `datecancelled` datetime default NULL AFTER `datearrived`" );
	6	}
	7
	8	if( !column_exists( 'branchtransfers', 'cancellation_reason' ) ) {
	9	$dbh->do( "ALTER TABLE `branchtransfers` ADD COLUMN `cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve') DEFAULT NULL AFTER `reason`" );
	10	}
	11
	12	NewVersion( $DBversion, 26057, "Add datecancelled field to branchtransfers");
	13	}