Attachment #51809 for bug #10459

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql (+8 lines)
	1	ALTER TABLE borrowers
	2	ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
	3	ON UPDATE CURRENT_TIMESTAMP
	4	AFTER privacy_guarantor_checkouts;
	5	ALTER TABLE deletedborrowers
	6	ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
	7	ON UPDATE CURRENT_TIMESTAMP
	8	AFTER privacy_guarantor_checkouts;




    SetVersion($DBversion);
}

$DBversion = "3.23.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q|
ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
    |);
    $dbh->do(q|
ALTER TABLE deletedborrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
    |);
    print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
    SetVersion($DBversion);
}


# DEVELOPER PROCESS, search for anything to execute in the db_update directory
# SEE bug 13068
- 

Return to bug 10459

Lines 12593-12610 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-13 lines)
12593	SetVersion($DBversion);	12593	SetVersion($DBversion);
12594	}	12594	}
12595		12595
12596	$DBversion = "3.23.00.XXX";
12597	if ( CheckVersion($DBversion) ) {
12598	$dbh->do(q\|
12599	ALTER TABLE borrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12600	\|);
12601	$dbh->do(q\|
12602	ALTER TABLE deletedborrowers ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER privacy;
12603	\|);
12604	print "Upgrade to $DBversion done (Bug 10459: Borrowers should have a timestamp)\n";
12605	SetVersion($DBversion);
12606	}
12607
12608		12596
12609	# DEVELOPER PROCESS, search for anything to execute in the db_update directory	12597	# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12610	# SEE bug 13068	12598	# SEE bug 13068
12611	-