CREATE TABLE [dbo].[itemsnetprice](
	[itemcode] [int] default 0,
	[branchid] [int] default 0,
	[netprice] [float] default 0
)

insert into itemsnetprice select itemcode,1,netprice from items

ALTER TABLE  items DROP CONSTRAINT  DF__items__netprice__44CA3770

ALTER TABLE  items DROP CONSTRAINT  DF__items__netprice__3493CFA7

ALTER TABLE  items DROP CONSTRAINT  DF__items__netprice__367C1819

ALTER TABLE  items DROP CONSTRAINT  DF__items__netprice__56E8E7AB

ALTER TABLE  items DROP CONSTRAINT  DF__items__netprice__57DD0BE4

alter table items drop column netprice


ALTER TABLE  banksmoves Add [balance] [float] default 0
ALTER TABLE  expensing Add [item_ExpireCode] [float] default 0
ALTER TABLE  items Add [departid] [int] default 0
ALTER TABLE  orders Add [bill_order_NoTxt] [int] default 0

update orders set [bill_order_NoTxt]=0 
 update expensing set [item_ExpireCode]=0
 update items set [departid]=0
update banksmoves set [balance]=0
insert into [dbo].[processes] values('جرد مخزون',33)
insert into [dbo].[processes] values('جرد رصيد خزينة',34)
insert into ordertypes values (0,'مرتجعات نقدية')

insert into permissions values (19,	'Market_Promotions','تعديل بيانات العروض والخصومات',23)