CREATE TABLE [dbo].[offers](
	[OrderID] [int] identity(1,1),
	[OrderDate] [datetime] default getdate(),
	[OrderTime] [datetime] default getdate(),
	[billno] [int] default 0,
	[edate] [datetime] default getdate(),
	[customerid] [int] default 0,
	[EmpID] [int] default 0,
	[stationid] [int] default 0,
	[substracted] [float] default 0,
	[added] [float] default 0,
	[debit] [float] default 0,
	[notes] [nvarchar](255) default '',
	[checknote] [nvarchar](255) default '',
	[paymethod] [int] default 0,
	 mndobid int default 0
)



CREATE TABLE [dbo].[offerDetail](
	[orderid] [int] default 0,
	[compoundid] [int] default 0,
	[unitid] [int] default 0,
	[quantity] [float] default 0,
	[price] [float] default 0,
	[discount] [float] default 0,
	[netprice] [float] default 0,
	[expirecode] [int] default 0,
	[unitnetprice] [float] default 0
)


CREATE TABLE [dbo].[offersdatalogs](
	[orderid] [int] default 0,
	[OrderDate] [datetime] default getdate(),
	[OrderTime] [datetime] default getdate(),
	[EmpID] [int] default 0,
	[stationid] [int] default 0,
	[shiftsn] [int] default 0,
	[notes] [nvarchar](255) default ''
)



ALTER TABLE  orders Add [NotDelivered] [bit] default 'false'

ALTER TABLE  LoyalityCards Add [SpecialCard] [bit] default 'false'


update orders set [NotDelivered]='false'
update LoyalityCards set [SpecialCard]='false'

ALTER TABLE  items Add [VAT] [bit] default 'false', [VAT_Value]  [float] default 0
ALTER TABLE  orderdetail Add [VAT]  [float] default 0, [VAT_Value]  [float] default 0
ALTER TABLE  orders Add [Total_VAT]  [float] default 0 
ALTER TABLE  suppliersaccounts Add [Total_VAT]  [float] default 0 

ALTER TABLE  companyinfo Add [taxRecord]   [nvarchar](255) default ''

ALTER TABLE  purchases Add [VAT]  [float] default 0, [VAT_Value]  [float] default 0


update companyinfo set [taxRecord] =''
update items set [VAT]='false', VAT_Value=0
update orderdetail set [VAT]=0, VAT_Value=0
update orders set [Total_VAT]=0 
update suppliersaccounts  set [Total_VAT]=0 

update purchases set [VAT]=0, VAT_Value=0


create table [dbo].[MndobinTels] (
	[id] [int] identity(1,1) ,
	[Dealerid] [int] default 0,
	[tel] [nvarchar](255) default'',
) 

CREATE TABLE [dbo].[ItemsReportGroups](
	[Groupid] [int] identity(1,1) ,
	[Groupname] [nvarchar](255) default'',
	[notes] [nvarchar](255) default'',
	[i] [bit] default 'false'
) 

 CREATE TABLE [dbo].[ItemsGroups](
	[id] [int] identity(1,1) ,
	[itemcode] [int] default 0,
	[Groupid] [int] default 0
)


ALTER TABLE  mndobins Add   AddPrcnt [float] default 0, DisPrcnt  [float] default 0

update mndobins set AddPrcnt=0, DisPrcnt=0



ALTER TABLE  stations Add   AppVersion [nvarchar](255) default'', LastLoginDate [datetime] default getdate()
update stations set AppVersion ='', LastLoginDate='1/1/1'



alter table orders add [OrderGuid] [nvarchar](50)  default left(newid(),8)+right(newid(),2)

update orders set [OrderGuid]=left(newid(),8)+right(newid(),2)

alter table orders ADD CONSTRAINT OrderGuid_guid unique (OrderGuid);


-- haty only
alter table orders add [SentToGOV] [bit] default 'false'
update orders set [SentToGOV]=0

alter table orders add  PrevGUID [nvarchar](200) default''
update orders set  PrevGUID=''

alter table shiftslog add [SendStatus] [int] default 0
update shiftslog set  [SendStatus]=5 where closed=1
update shiftslog set  [SendStatus]=0 where closed=0
 --- NotSent=0, ReadyToSend = 1, Sent=2 , PartialSent=3,IssueToSend=4,outOfScope=5
---

alter table orders add [StationCloseID] [int] default 0, CloseDate [datetime] default getdate() 
update orders set [StationCloseID]=stationid, CloseDate=orderDate 

alter table shiftslog add [FinallyClosed] [bit] default 'false', Data [nvarchar](2000) default''
update shiftslog set  [FinallyClosed]=1 where closed=1
update shiftslog set  [FinallyClosed]=0 where closed=0
update shiftslog set  Data=''