alter table stocks add [branchid] [int] default 0


alter table banks add [branchid] [int] default 0



alter table [transfer]  add [instockid] [int] default 0,
	[outstockid] [int] default 0,[Recieved] [bit] default 'false'



alter table [transfereDetail] add 	[price] [float] default 0,
	[netprice] [float] default 0



CREATE TABLE [dbo].[transferdatalogs](
	[Processno] [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 ''
)
 


CREATE TABLE [dbo].[taswyadatalogs](
	[Processno] [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 ''
)




CREATE TABLE [dbo].[banksmoveslogs](
	[Processno] [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 ''
)


CREATE TABLE [dbo].[Expensesdatalogs](
	[Processno] [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 ''
)


CREATE TABLE [dbo].[Incomingsdatalogs](
	[Processno] [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 ''
)

CREATE TABLE [dbo].[bankTransferdatalogs](
	[Processno] [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 [bankstransfers]  add [Recieved] [bit] default 'false'


CREATE UNIQUE INDEX compoundid_index 
ON compoundsdata (compoundid)

CREATE   INDEX itemcode_index 
ON compoundsdata (itemcode)



update banks set branchid=1 
update bankstransfers set Recieved=1
update stocks set branchid=1 
========================================================================================================
  CREATE   INDEX edate_index 
ON orders (edate)
====================================================
create proc ReBuildSearchIndexes as 
DECLARE @TableName VARCHAR(255)
DECLARE @sql NVARCHAR(500)
DECLARE @fillfactor INT
SET @fillfactor = 80
DECLARE TableCursor CURSOR FOR
SELECT OBJECT_SCHEMA_NAME([object_id])+'.['+name+']' AS TableName
FROM sys.tables
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'
EXEC (@sql)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
GO


================================================ end of 4.5.1

CREATE TABLE [dbo].[rentorders](
[OrderID] [int]  default 0,
[fileid] [int] default 0,
[Payed_date] [datetime] default getdate(),
[Payed_Enddate] [datetime] default getdate(),
[subscriptions] [float] default 0,
[change] [bit]  default 'false',
[pre_balance] [bit]  default 'false',	
  [additionalCopyCost] [float] default 0,	 
[lastCopiesCount] [int] default 0,
[CurrentCopiesCount]  [int] default 0,
[allowedCopies] [int] default 0,
[itemOrderID] [int] default 0
)
 

CREATE TABLE [dbo].[Machinesfiles]
(
	[fileID] [int] identity(1,1),
	[custid][int] default 0,
	[fileNO][int] default 0,
	[filename] [nvarchar](255) default '',
	[fileCode] [nvarchar](255) default '',
	[Renting] [bit] default 'false',
	[notes] [nvarchar](255) default '',
	[startDate] [datetime] default getdate(),
	[peroid] [int] default 0,
	[cost] [float] default 0,
	[inculdeFixing] [bit] default 'false',
	[allowedCopies][int] default 0,
        [additionalCopyCost] [float] default 0,
        [lastCopiesCount][int] default 0,
	[lastPayDate] [datetime] default getdate(),
	[itemOrderID] [int] default 0,
 	[closed] [bit] default 'false',
	[maintenanceRequired] [bit] default 'false'
 )
 
CREATE TABLE [dbo].[Machinesfilesdatalog]
(
	[sequenceid] [int] identity(1,1),
	[fileID] [int]default 0,
	[custid][int] default 0,
	[fileNO][int] default 0,
	[filename] [nvarchar](255) default '',
	[fileCode] [nvarchar](255) default '',
	[Renting] [bit] default 'false',
	[notes] [nvarchar](255) default '',
	[startDate] [datetime] default getdate(),
	[peroid] [int] default 0,
	[cost] [float] default 0,
	[inculdeFixing] [bit] default 'false',
	[allowedCopies][int] default 0,
        [additionalCopyCost] [float] default 0,
        [lastCopiesCount][int] default 0,
	[lastPayDate] [datetime] default getdate(),
[itemOrderID] [int] default 0,
[insertDatetime] [datetime] default getdate()
 
 	 )



 CREATE TABLE [dbo].[mndobins](
	[mndobid] [int] identity(0,1),
	[mndobName] [nvarchar](255) default '',
	[notes] [nvarchar](255) default '',
	[i] [bit] default 'false'
) 

insert into mndobins(mndobName) values('عميل المؤسسة')

CREATE TABLE [dbo].[SurveyItems](
	[SurveyItemCode] [int] identity(1,1),
	[SurveyItemName] [nvarchar](255) default '',
	[SurveyMenuID] [int] default 0,

	[i] [bit] default 'false'
)

CREATE TABLE [dbo].[surveying](
	[SurveyID] [int] identity(1,1),
[SurveyItemCode] [int] default 0,
	[SurveyMenuID] [int] default 0,
[notes] [nvarchar](255) default '',
	[surveyDate] [datetime] default getdate(),
 [custid][int] default 0,
 [brnachid][int] default 0,
 [areacode][int] default 0,
	[EmpID] [int] default 0,
	[stationid] [int] default 0
)

insert into [dbo].[processes] values('صرف آلة للايجار',27)
insert into [dbo].[processes] values('تسديد إيجار آلة',28)
insert into [dbo].[processes] values('استعادة آلة مؤجرة',29)
insert into [dbo].[processes] values('طلب صيانة آلة',30)
insert into [dbo].[processes] values('صيانة آلة',31)
insert into [dbo].[processes] values('غلق ملف آلة',32)

================================================================

alter table users add [i] [bit] default 'false' 

update users set [i] = 'false' 
==========================================================4.5.2

alter table items add [Synthesis_item] [bit] default 'false'
 update items set [Synthesis_item]=0

============================================================4.5.3

 
 

CREATE TABLE [dbo].[jards](
	[Processno] [int] identity(1,1),
	[OrderDate] [datetime] default getdate(),
	[OrderTime] [datetime] default getdate(),
	[edate] [datetime] default 0,
	[taswyano] [int] default 0,
	[EmpID] [int] default 0,
	[stationid] [int] default 0,
	[shiftsn] [int] default 0,
	[jardsum] [float] default 0,
	 [FullJard] [bit] default 'false',
	[notes] [nvarchar](255) default ''
)

CREATE TABLE [dbo].[jardDetail](
	[Processno] [int] default 0,
	[stockid] [int] default 0,
	[itemcode] [int] default 0,
	[unitid] [int] default 0,
	[quantity] [float] default 0,
	[price] [float] default 0,
	[expirecode] [int] default 0,
	[netprice] [float] default 0
)


CREATE TABLE [dbo].[jard_datalogs](
	[Processno] [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 branchs add [SaleBillFooter] [nvarchar]( max)

=============================================================
alter table  [Machinesfiles] add [fileCode] [nvarchar](255) default ''
alter table [Machinesfilesdatalog]  add [fileCode] [nvarchar](255) default ''