ALTER TABLE  orders Add 
recieveTime [datetime] default getdate(),
 [OutTime] [datetime] default getdate()

update orders set [recieveTime]=orderdate , [OutTime]=OrderDate
 

CREATE TABLE [dbo].[CardsCategorys](
	[CardsCategoryid] [int] identity(1,1) ,
	[CardsCategoryname] [nvarchar](255) default'',
	[PointsPerUnit] [float] default 0,
	[notes] [nvarchar](255) default'',
	[i] [bit] default 'false'
) 

CREATE TABLE [dbo].[LoyalityCards](
	[LoyalityCardid] [int] identity(1,1) ,
	[LoyalityCardNo] [nvarchar](255) default'',
	[CardsCategoryid] [int] default 0,
	[CustID] [int] default 0,
	[AddingDate] [date] default getdate()
) 

alter table Delivery_customers add [Cardid] [int]default 0

ALTER TABLE  orders Add 
[Cardid] [int] default 0,
[newPoints] [float] default 0,
[usedPoints] [float] default 0,
[DiscountForPoints] [float] default 0,
[bank2id] [int] default 0,
[bank2debit] [float] default 0

update orders set [Cardid]=0 , [newPoints]=0,usedPoints=0,DiscountForPoints=0,[bank2id]=0,
bank2debit=0