Changes between Version 4 and Version 5 of RenameUsersScript


Ignore:
Timestamp:
Apr 1, 2007 3:46:39 PM (7 years ago)
Author:
anonymous
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