diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2006-10-11 18:12:39 +0000 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2006-10-11 18:12:39 +0000 |
commit | 183851b06bd6c52f3cae5375f433da720d410447 (patch) | |
tree | a477257decbf3360127f6739c2f9d0ec57a03d39 /maintenance/changeuser.sql |
MediaWiki 1.7.1 wiederhergestellt
Diffstat (limited to 'maintenance/changeuser.sql')
-rw-r--r-- | maintenance/changeuser.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/maintenance/changeuser.sql b/maintenance/changeuser.sql new file mode 100644 index 00000000..ad1c6da6 --- /dev/null +++ b/maintenance/changeuser.sql @@ -0,0 +1,12 @@ +set @oldname = 'At18'; +set @newname = 'Alfio'; + +update low_priority /*$wgDBprefix*/user set user_name=@newname where user_name=@oldname; +update low_priority /*$wgDBprefix*/user_newtalk set user_ip=@newname where user_ip=@oldname; +update low_priority /*$wgDBprefix*/cur set cur_user_text=@newname where cur_user_text=@oldname; +update low_priority /*$wgDBprefix*/old set old_user_text=@newname where old_user_text=@oldname; +update low_priority /*$wgDBprefix*/archive set ar_user_text=@newname where ar_user_text=@oldname; +update low_priority /*$wgDBprefix*/ipblocks set ipb_address=@newname where ipb_address=@oldname; +update low_priority /*$wgDBprefix*/oldimage set oi_user_text=@newname where oi_user_text=@oldname; +update low_priority /*$wgDBprefix*/recentchanges set rc_user_text=@newname where rc_user_text=@oldname; + |