Guild score bug

Hello guys, I got again a problem :D
When someone is making a war and after winning score is not 1 but is -99. How can I solve this?

Code:

---

ALTER TABLE Guild ALTER COLUMN G_Score DEFAULT 0;
UPDATE Guild SET G_Score = 0 WHERE G_Score < 0;

---

Quote:

---

Originally Posted by [RCZ]ShadowKing

Code:

---

ALTER TABLE Guild ALTER COLUMN G_Score DEFAULT 0;
UPDATE Guild SET G_Score = 0 WHERE G_Score < 0;

---

---

Quote:

---

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'DEFAULT'.

---

:)::):

Do by hand: go to MuOnline DB, select Guild table, right click -> design table, select G_Score column and down you will get few variable to set and put "Default value" to 0.
Then run this query

Code:

---

UPDATE Guild SET G_Score = 0 WHERE G_Score < 0;

---