select * from orders order by orderid desc

alter table sections add branchid int default 0
update sections set branchid=0

 
CREATE TABLE [dbo].[notificationslogs](
	[notifyid] [int] identity(1,1),
	[Orderid] [int] default 0,
	[eTime] [datetime] default getdate(),
	[EmpID] [int] default 0,
	[stationid] [int] default 0,
	[notes] [nvarchar](255) default '',
	[printern] [nvarchar](255) default '',
	[notified] [bit] default 0,
	[printed] [bit] default 0,
	[branchid] [bit] default 0
)

select * from notificationslogs 

ALter table orders add [checknote] [nvarchar](255) default ''

update orders set [checknote]=''

CREATE TABLE [dbo].[settings](
	 
	[branchid] [int] default 0,
	[property] [varchar](255) default '',
	[setting] [varchar](255) default '',
	 
) 

drop table sets
drop table generalsets

