ALTER TABLE RoleData
ADD mirrorcoin [int] NOT NULL CONSTRAINT [DF_RoleData_mirrorcoin] DEFAULT ((0)),
phantom [int] NOT NULL CONSTRAINT [DF_RoleData_phantom] DEFAULT ((0)),
weekinstance varbinary(1) NULL,
weekinstday [int] NOT NULL CONSTRAINT [DF_RoleData_weekinstday] DEFAULT ((0)),
weekresetcount [int] NOT NULL CONSTRAINT [DF_RoleData_weekresetcount] DEFAULT ((0))
GO
UPDATE [ROM_World].[dbo].[RoleData]
set weekinstance = CONVERT(BINARY,'')
alter table dbo.Roledata alter column Buff varbinary(2248);
alter table dbo.Roledata alter column phantom varchar(1) NOT NULL;