CREATE TABLE [dbo].[branchs](
	[branchid] [int] identity(1,1),
	[branchname] [nvarchar](255) default '',
	[notes] [nvarchar](255) default '',
logo varbinary(max),
	[i] [bit] default 'false'
) 
	
	 
CREATE TABLE [dbo].[areas](
	[Areacode] [int] identity(1,1),
	[areaname] [nvarchar](255) default '',
	[branchid] [int] default 0,
	[deliveryCost] [float] default 0,
	[deliveryTimeM] [float] default 0,
	[i] [bit] default 'false'
)
 

CREATE TABLE [dbo].[Delivery_customers](
	[custid] [int]  identity(1,1),
	[custname] [nvarchar](255) default '',
	[tel1] [nvarchar](255) default '',
	[tel2] [nvarchar](255) default '',
	[tel3] [nvarchar](255) default '',
	[notes] [nvarchar](255) default '',
	[i] [bit]  default 'false'
	)
	
	
	CREATE TABLE [dbo].[Delivery_address](
	[addresscode] [int]  identity(1,1),
	[custid] [int]  default 0,
 	--[resturant] [nvarchar](255) default '',
	[area] [int] default 0,
	[address] [nvarchar](255) default '',
	[bulidno] [nvarchar](255) default '',
	[floor] [nvarchar](255) default '',
	[flat] [nvarchar](255) default '',
	[mark] [nvarchar](255) default '',
	[notes] [nvarchar](255) default ''
)	

 



 CREATE TABLE [dbo].[orderstatus](
	[statuscode] [int]  default 0,
	[statusname] [nvarchar](255) default '',
) 


CREATE TABLE [dbo].[cashierprinters](
	[printercode] [int] identity(0,1),
	[printername] [nvarchar](255) default '',
	[printerdevice] [nvarchar](255) default '',
 
)


 CREATE TABLE [dbo].[kitchens](
	[kitchenid] [int] identity(1,1),
	[kitchenname] [nvarchar](255) default '',
	[notes] [nvarchar](255) default '',
	[i] [bit] default 'false'
) 


 
  CREATE TABLE [dbo].[kitchensPrinters](
	[kitchenPrintercode] [int] identity(1,1),
	[Printercode] [int] default 0,
	[kitchenid] [int] default 0,
	[branchid] [int] default 0,
) 
 
 




  CREATE TABLE [dbo].[itemsavailablity](
	[itemsavailablecode] [int] identity(1,1),
	[itemcode] [int] default 0,
	[branchid] [int] default 0
) 

 

CREATE TABLE [dbo].[itemsavailablitylogs](
	[OrderDate] [datetime] default getdate(),
	[OrderTime] [datetime] default getdate(),
	[EmpID] [int] default 0,
	[stationid] [int] default 0,
	[notes] [nvarchar](255) default '',
		[itemsavailablecode] [int] identity(1,1),
	[itemcode] [int] default 0,
	[branchid] [int] default 0
)

 


  CREATE TABLE [dbo].[kitchenitems](
	[itemKitchencode] [int] identity(1,1),
	[itemcode] [int] default 0,
	[kitchenid] [int] default 0
) 

 CREATE TABLE [dbo].[CallCenterServices](
	[Serviceid] [int] identity(1,1),
	[Servicename] [nvarchar](255) default ''
) 

CREATE TABLE [dbo].[Servicesitems](
	[Serviceid] [int]  default 0,
	[serviceitemid] [int] identity(1,1),
	[serviceitem] [nvarchar](255)  default '',
	[i] [bit]  default 'false'
)

CREATE TABLE [dbo].[servicing](
	[recordno] [int] identity(1,1),
	[custID] [int]  default 0,
	[pDate] [datetime] default getdate(),
	[pTime] [datetime] default getdate(),
	--[edate] [datetime] default getdate(),
	[serviceitemid] [int]  default 0,
	[content] [nvarchar](1000)  default '',
	[EmpID] [int]  default 0,
	[stationid] [int]  default 0,
)





-- CREATE TABLE [dbo].[shiftschange](
--	[code] [int] identity(1,1),
--	[shiftid] [int] default 0,
--	[shiftname] [nvarchar](255) default '',
--	[changetime] [datetime] 
--) 

ALter table orders add [branchid] [int] default 0
ALter table orders add [deliveryaddressid] [int] default 0
ALter table orders add [orderstatus] [int] default 0
ALter table orders add [servicecost] [float] default 0
update orders set branchid=0
update orders set deliveryaddressid=0
update orders set orderstatus=0
update orders set servicecost=0

alter table orderdetail add [done] [bit] default 0


ALter table stations add [branchid] [int] default 0
ALter table stations add [printercode] [int] default 0
update stations set branchid=0
update stations set printercode=0

 

insert into [dbo].[CallCenterServices]  values ('مقترحات')
insert into [dbo].[CallCenterServices]  values ('شكاوى')
insert into [dbo].[CallCenterServices]  values ('ملاحظات')
--insert into [dbo].[CallCenterServices]  values ('استعلامات')

insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (1,'احجام وجبات')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (1,'نوع وجبات')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (1,'اضافات للوجبات')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (1,'اخرى')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (2,'وقت الديلفرى')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (2,'جودة الاوردر')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (2,'اخرى')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (3,'استعلام')
insert into [dbo].[Servicesitems] (Serviceid,serviceitem)  values (3,'اخرى')
 
 
 
 insert into orderstatus values(0,'')
insert into orderstatus values(1,'انتظار')
insert into orderstatus values(2,'تحت التحضير')
insert into orderstatus values(3,'جاهز')
insert into orderstatus values(4,'تحت التوصيل')
insert into orderstatus values(5,'تم التوصيل')
insert into orderstatus values(6,'تم إلغاء الطلب')
insert into orderstatus values(7,'محجوز')
insert into orderstatus values(8,'تحت التعديل')



insert into branchs (branchname) values ('الفرع الرئيسى')

insert into cashierprinters values('بدون طابعة','')

insert into kitchens (kitchenname) values('المطبخ الرئيسى')

insert into kitchensPrinters values(1,1,1)
 

	 

select * from servicing