try to run this code in query analyser:
Code:
--TO CHANGE DEFAULT VALUE OF SUMMONER
Use Muonline
GO
ALTER TABLE dbo.AccountCharacter
DROP CONSTRAINT DF_AccountCharacter_Summoner
GO
ALTER TABLE dbo.AccountCharacter ADD CONSTRAINT
DF_AccountCharacter_Summoner DEFAULT 1 FOR Summoner
GO
--TO UPDATE ALL ACCOUNTS TO NEW VALUE THAT ACCOUNTS CAN CREATE SUMMONER BEFORE THAT
update AccountCharacter set Summoner = 1
- - - Updated - - -
or in table AccountCharacter set default value 1 for summoner, and in you have accounts in db, run this code:
Code:
UPDATE AccountCharacter SET Summoner = 1