Attachment #100631 for bug #23092

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




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

    unless ( column_exists('branchtransfers', 'daterequested') ) {
        $dbh->do(
            qq{
                ALTER TABLE branchtransfers
                ADD
                  `daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP
                AFTER
                  `itemnumber`
              }
        );
    }

    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 23092 - Add 'daterequested' field to transfers table)\n";
}

Lines 901-906 DROP TABLE IF EXISTS `branchtransfers`; Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
901	CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches	901	CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
902	`branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key	902	`branchtransfer_id` int(12) NOT NULL auto_increment, -- primary key
903	`itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)	903	`itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
		904	`daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date the transfer was requested
904	`datesent` datetime default NULL, -- the date the transfer was initialized	905	`datesent` datetime default NULL, -- the date the transfer was initialized
905	`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from	906	`frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
906	`datearrived` datetime default NULL, -- the date the transfer arrived at its destination	907	`datearrived` datetime default NULL, -- the date the transfer arrived at its destination
907	-

Return to bug 23092

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23092.perl (+18 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	unless ( column_exists('branchtransfers', 'daterequested') ) {
	5	$dbh->do(
	6	qq{
	7	ALTER TABLE branchtransfers
	8	ADD
	9	`daterequested` timestamp NOT NULL default CURRENT_TIMESTAMP
	10	AFTER
	11	`itemnumber`
	12	}
	13	);
	14	}
	15
	16	SetVersion( $DBversion );
	17	print "Upgrade to $DBversion done (Bug 23092 - Add 'daterequested' field to transfers table)\n";
	18	}