Changes between Version 4 and Version 5 of RenameUsersScript

Show
Ignore:
Author:
anonymous (IP: 82.67.28.79)
Timestamp:
04/01/07 08:46:39 (7 months ago)
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RenameUsersScript

    v4 v5  
    2626UPDATE "ticket" SET reporter='$NEWNAME' WHERE reporter='$OLDNAME'; 
    2727UPDATE "ticket_change" SET author='$NEWNAME' WHERE author='$OLDNAME'; 
    28 UPDATE "ticket_change" SET newvalue='$NEWNAME' WHERE newvalue='$OLDNAME' AND (field='qa_contact' OR fie 
    29 ld='owner' OR field='reporter'); 
    30 UPDATE "ticket_change" SET oldvalue='$NEWNAME' WHERE oldvalue='$OLDNAME' AND (field='qa_contact' OR fie 
    31 ld='owner'); 
     28UPDATE "ticket_change" SET newvalue='$NEWNAME' WHERE newvalue='$OLDNAME' AND (field='qa_contact' OR field='owner' OR field='reporter'); 
     29UPDATE "ticket_change" SET oldvalue='$NEWNAME' WHERE oldvalue='$OLDNAME' AND (field='qa_contact' OR field='owner'); 
    3230UPDATE "component" SET owner='$NEWNAME' WHERE owner='$OLDNAME'; 
    3331EOF