Try this
Code:
USE [ACCOUNT_DBF]
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD votepoints int NOT NULL CONSTRAINT [DF_ACCOUNT_TBL_votepoints] DEFAULT (0),
lastvote1 DATETIME,
lastvote2 DATETIME,
lastvote3 DATETIME
GO
For new createt Accounts
Code:
USE [ACCOUNT_DBF]
GO
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD CONSTRAINT [DF_ACCOUNT_TBL_votepoints] DEFAULT (0) FOR [votepoints]
GO
For already existet Accounts
Code:
Use [ACCOUNT_DBF]
GO
update [ACCOUNT_TBL] set votepoints = '0'
GO
Original Thread