15.06.2015, 13:05
1)
https://dev.mysql.com/doc/refman/5.6...eign-keys.html
Read about CASCADE.
2)
As long as user ID is unique index, you can use: https://dev.mysql.com/doc/refman/5.0...duplicate.html
so if a row exists with that user ID, update the jail and mute time in that row.
Actually Vince has written 2 tutorials that mentioned both of those things you asked for, I suggest you to read them!
https://dev.mysql.com/doc/refman/5.6...eign-keys.html
Read about CASCADE.
2)
As long as user ID is unique index, you can use: https://dev.mysql.com/doc/refman/5.0...duplicate.html
so if a row exists with that user ID, update the jail and mute time in that row.
Actually Vince has written 2 tutorials that mentioned both of those things you asked for, I suggest you to read them!