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

(-)a/installer/data/mysql/atomicupdate/bug_22577.perl (-1 / +4 lines)
Lines 3-8 if( CheckVersion( $DBversion ) ) { Link Here
3 
    $dbh->do( "ALTER TABLE `borrowers` MODIFY COLUMN `branchcode` VARCHAR(10) DEFAULT NULL");
 3 
    $dbh->do( "ALTER TABLE `borrowers` MODIFY COLUMN `branchcode` VARCHAR(10) DEFAULT NULL");
4 
    $dbh->do( "ALTER TABLE `borrowers` MODIFY COLUMN `categorycode` VARCHAR(10) DEFAULT NULL");
 4 
    $dbh->do( "ALTER TABLE `borrowers` MODIFY COLUMN `categorycode` VARCHAR(10) DEFAULT NULL");
5 
    $dbh->do( "INSERT INTO `borrowers` (borrowernumber, surname, firstname, flags) VALUES ('-1', 'CRON', 'CRON', 0)" );
 5 
    $dbh->do( "INSERT INTO `borrowers` (borrowernumber, surname, firstname, flags) VALUES ('-1', 'CRON', 'CRON', 0)" );
6 
    $dbh->do( "UPDATE `statistics` SET borrowernumber = '-1' WHERE borrowernumber = '0'" );
7 
    $dbh->do( "UPDATE `statistics` SET borrowernumber = '-1' WHERE borrowernumber = '0'" );
8 
    $dbh->do( "UPDATE `accountlines` SET manager_id = '-1' WHERE manager_id = '0'" );
9 
    $dbh->do( "UPDATE `action_logs` SET user = '-1' WHERE user = '0'" );
6
10
7 
    SetVersion( $DBversion );
 11 
    SetVersion( $DBversion );
8 
    print "Upgrade to $DBversion done (Bug 22577 - Add internal user for cron)\n";
 12 
    print "Upgrade to $DBversion done (Bug 22577 - Add internal user for cron)\n";
9 
-

Return to bug 22577