Postado originalmente por
Erick-Master
@Renato
Para evitar futuros problemas com alteração no banco de dados, segue dica:
Código:
USE [MUOnline]
GO
UPDATE [dbo].[Character] SET PkCount = 0 WHERE PkCount IS NULL
GO
ALTER TABLE [dbo].[Character] ALTER COLUMN [PkCount] int NOT NULL
GO
IF((SELECT default_object_id FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'PkCount') = 0)
BEGIN
ALTER TABLE [dbo].[Character] ADD CONSTRAINT DF_Character_PkCount DEFAULT(0) FOR [PkCount]
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'PkCountDay'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [PkCountDay] int NOT NULL CONSTRAINT DF_Character_PkCountDay DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'PkCountWeek'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [PkCountWeek] int NOT NULL CONSTRAINT DF_Character_PkCountWeek DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'PkCountMonth'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [PkCountMonth] int NOT NULL CONSTRAINT DF_Character_PkCountMonth DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'PkCountTotal'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [PkCountTotal] int NOT NULL CONSTRAINT DF_Character_PkCountTotal DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'HeroCount'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [HeroCount] int NOT NULL CONSTRAINT DF_Character_HeroCount DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'HeroCountDay'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [HeroCountDay] int NOT NULL CONSTRAINT DF_Character_HeroCountDay DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'HeroCountWeek'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [HeroCountWeek] int NOT NULL CONSTRAINT DF_Character_HeroCountWeek DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'HeroCountMonth'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [HeroCountMonth] int NOT NULL CONSTRAINT DF_Character_HeroCountMonth DEFAULT(0)
END
GO
IF(NOT EXISTS(SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('Character') AND name = 'HeroCountTotal'))
BEGIN
ALTER TABLE [dbo].[Character] ADD [HeroCountTotal] int NOT NULL CONSTRAINT DF_Character_HeroCountTotal DEFAULT(0)
END
GO
[]'s