Różnice między wybraną wersją a wersją aktualną.
| Both sides previous revision Poprzednia wersja Nowa wersja | Poprzednia wersja | ||
|
pl:dydaktyka:ztb:2011:projekty:trener:projekt_logiczny [2011/06/19 20:41] ztb2011 |
pl:dydaktyka:ztb:2011:projekty:trener:projekt_logiczny [2019/06/27 15:50] (aktualna) |
||
|---|---|---|---|
| Linia 154: | Linia 154: | ||
| ==== Usuwanie meczu ==== | ==== Usuwanie meczu ==== | ||
| update fth_players set pl_matches = pl_matches - 1, pl_goals = pl_goals - ( | update fth_players set pl_matches = pl_matches - 1, pl_goals = pl_goals - ( | ||
| + | | ||
| select count(*) from fth_stats | select count(*) from fth_stats | ||
| where sts_match = 1 | where sts_match = 1 | ||
| Linia 168: | Linia 169: | ||
| AND sts_player = 79 | AND sts_player = 79 | ||
| AND sts_event ='R') where pl_id =79; | AND sts_event ='R') where pl_id =79; | ||
| + | | ||
| delete from fth_match_set where mset_match = 1; | delete from fth_match_set where mset_match = 1; | ||
| + | | ||
| delete from fth_stats where sts_match = 1; | delete from fth_stats where sts_match = 1; | ||
| + | | ||
| delete from fth_matches where mts_id = 1; | delete from fth_matches where mts_id = 1; | ||
