--alter table [dbo].[BUDDY_CustomerCardInfo]
--drop constraint [DF_BUDDY_CustomerCardInfo_LogDate]
ALTER TABLE [dbo].[BUDDY_CustomerCardInfo] ADD
CONSTRAINT [DF_BUDDY_CustomerCardInfo_LogDate] DEFAULT ( getdate()) FOR [LogDate]
--alter table [dbo].BUDDY_CustomerStock
--drop constraint [DF_BUDDY_CustomerCardInfo_LogDate]
ALTER TABLE [dbo].BUDDY_CustomerStock ADD
CONSTRAINT [DF_BUDDY_CustomerStock_LogDate] DEFAULT ( getdate()) FOR [LogDate]