33 lines
No EOL
1.5 KiB
SQL
33 lines
No EOL
1.5 KiB
SQL
-- Liga Tausch user_id 74 <-> 81
|
|
-- Liga Tausch user_id 97 <-> 46
|
|
|
|
update leagues_members set user_id=1000 where league_id>28 and user_id=74;
|
|
update leagues_members set user_id=74 where league_id>28 and user_id=81;
|
|
update leagues_members set user_id=81 where league_id>28 and user_id=1000;
|
|
|
|
update leagues_members set user_id=1000 where league_id>28 and user_id=97;
|
|
update leagues_members set user_id=97 where league_id>28 and user_id=46;
|
|
update leagues_members set user_id=46 where league_id>28 and user_id=1000;
|
|
|
|
|
|
|
|
|
|
-- Match Tausch 74 <-> 81
|
|
-- Match Tausch 97 <-> 46
|
|
|
|
update leagues_matches set user1_id=1000 where league_id>28 and user1_id=74;
|
|
update leagues_matches set user1_id=74 where league_id>28 and user1_id=81;
|
|
update leagues_matches set user1_id=81 where league_id>28 and user1_id=1000;
|
|
|
|
update leagues_matches set user2_id=1000 where league_id>28 and user2_id=74;
|
|
update leagues_matches set user2_id=74 where league_id>28 and user2_id=81;
|
|
update leagues_matches set user2_id=81 where league_id>28 and user2_id=1000;
|
|
|
|
|
|
update leagues_matches set user1_id=1000 where league_id>28 and user1_id=97;
|
|
update leagues_matches set user1_id=97 where league_id>28 and user1_id=46;
|
|
update leagues_matches set user1_id=46 where league_id>28 and user1_id=1000;
|
|
|
|
update leagues_matches set user2_id=1000 where league_id>28 and user2_id=97;
|
|
update leagues_matches set user2_id=97 where league_id>28 and user2_id=46;
|
|
update leagues_matches set user2_id=46 where league_id>28 and user2_id=1000; |