Changes between Version 4 and Version 5 of RenameUsersScript


Ignore:
Timestamp:
Apr 1, 2007, 3:46:39 PM (9 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