Attachment #51867 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 12599-12616 if ( CheckVersion($DBversion) ) { Link Here

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