--
--Following query will check for existentence of IX_Company_Fid and idx_schema_tablename_colname.
--if does not exist, it will create index on company_fid column in the table in name of idx_schema_tablename_colname
--
DECLARE @Database VARCHAR(2000)   
DECLARE @Table VARCHAR(2000)  
DECLARE @cmd VARCHAR(max)  

DECLARE DatabaseCursor CURSOR FOR  
SELECT name FROM sys.databases   
WHERE name = '##db##'  AND is_read_only<>1 AND state<>6
ORDER BY 1  

OPEN DatabaseCursor  

FETCH NEXT FROM DatabaseCursor INTO @Database  
WHILE @@FETCH_STATUS = 0  
BEGIN  
select @Database  
SET @cmd = '
USE '+@Database+'

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_paymaster''))
     AND name = ''idx_com_salpay_dismonth''
)
CREATE NONCLUSTERED INDEX idx_com_salpay_dismonth
ON [dbo].[tbl_paymaster] ([company_fid],[salarypayment_fid],[displaymonth_fid])
INCLUDE ([paymaster_pid],[monthmaster_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_employee''))
     AND name = ''idx_company_fid_Freeze''
)
CREATE NONCLUSTERED INDEX idx_company_fid_Freeze
ON [dbo].[tbl_employee] ([company_fid])
INCLUDE ([employee_pid],[freeze])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_loandistribution''))
     AND name = ''idx_comp_emp''
)
CREATE NONCLUSTERED INDEX idx_comp_emp
ON [dbo].[tbl_loandistribution] ([company_fid],[employee_fid])



IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_salaryheadsfrequency''))
     AND name = ''idx_monthvalpartno''
)
CREATE NONCLUSTERED INDEX idx_monthvalpartno
ON [dbo].[tbl_salaryheadsfrequency] ([monthvalpartno])
INCLUDE ([company_fid],[salaryheadsfrequency_pid],[ctdetails_fid],[frequencyapplicable])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendanceledger''))
     AND name = ''idx_emp_temp''
)
CREATE NONCLUSTERED INDEX idx_emp_temp
ON [dbo].[tbl_attendanceledger] ([employee_fid],[temp])
INCLUDE ([paymaster_fid],[attendancecategory_fid],[attendancetype_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_employee''))
     AND name = ''idx_compid_doe''
)
CREATE NONCLUSTERED INDEX idx_compid_doe
ON [dbo].[tbl_employee] ([company_fid],[dateofexit])
INCLUDE ([employee_pid],[employeecode],[fname],[mname],[lname],[branch_fid],[department_fid],[grade_fid],[designation_fid],[unit_fid],[division_fid],[project_fid],[employeecategory_fid],[costcategory_fid],[ct_fid],[enableemployeeautoincrement],[employeeautoincrementdate],[enableemployeeautoincrementmonth])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ctdetails''))
     AND name = ''idx_ct_fid''
)
CREATE NONCLUSTERED INDEX idx_ct_fid
ON [dbo].[tbl_ctdetails] ([ct_fid])
INCLUDE ([salaryhead_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_employee''))
     AND name = ''idx_compid''
)
CREATE NONCLUSTERED INDEX idx_compid
ON [dbo].[tbl_employee] ([company_fid])
INCLUDE ([employee_pid],[employeecode],[fname],[mname],[lname],[pfno],[freeze])



--Additional Checking of MonthStartDate
IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_month''))
     AND name = ''idx_compid''
)
IF EXISTS (
   SELECT 1
   FROM syscolumns
   WHERE id = (SELECT OBJECT_ID(''tbl_month''))
     AND name = ''monthstartdate''
)
CREATE NONCLUSTERED INDEX idx_compid
ON [dbo].[tbl_month] ([company_fid])
INCLUDE ([month_pid],[monthval],[monthvalyear],[monthvalmonthpartno],[monthvalname],[monthstartdate],[monthenddate],[monthdays],[locked],[tdsyear_fid],[defaultmonthweeklyoff],[defaultmonthholiday],[MaxSalaryPF],[MaxSalaryPension],[MaxSalaryEDLI],[EPFRateEmployee],[EPFRateEmployer],[EPSRateEmployer],[PFAdminRate],[EDLIRate],[EDLIAdminRate],[PFInterestRate],[MAXSalaryESIC],[ESICRateEmployee],[ESICRateEmployer],[AvailableInSelfService])


--Additional Checking of MonthStartDate
IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_month''))
     AND name = ''idx_comid_monthvalpartno''
)
IF EXISTS (
   SELECT 1
   FROM syscolumns
   WHERE id = (SELECT OBJECT_ID(''tbl_month''))
     AND name = ''monthstartdate''
)
CREATE NONCLUSTERED INDEX idx_comid_monthvalpartno
ON [dbo].[tbl_month] ([company_fid],[monthvalmonthpartno])
INCLUDE ([month_pid],[monthval],[monthvalyear],[monthvalname],[monthstartdate],[monthenddate],[monthdays],[locked],[tdsyear_fid],[defaultmonthweeklyoff],[defaultmonthholiday],[MaxSalaryPF],[MaxSalaryPension],[MaxSalaryEDLI],[EPFRateEmployee],[EPFRateEmployer],[EPSRateEmployer],[PFAdminRate],[EDLIRate],[EDLIAdminRate],[PFInterestRate],[MAXSalaryESIC],[ESICRateEmployee],[ESICRateEmployer],[AvailableInSelfService])



IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_user''))
     AND name = ''idx_emp''
)
CREATE NONCLUSTERED INDEX idx_emp
ON [dbo].[tbl_user] ([employee_fid])
INCLUDE ([userrole_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_salarydisbursementdetails''))
     AND name = ''idx_disburseguid''
)
CREATE NONCLUSTERED INDEX idx_disburseguid
ON [dbo].[tbl_salarydisbursementdetails] ([disburseguid])
INCLUDE ([paydetails_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_salaryheads''))
     AND name = ''idx_comp_headtype''
)
CREATE NONCLUSTERED INDEX idx_comp_headtype
ON [dbo].[tbl_salaryheads] ([company_fid],[headtype_fid])
INCLUDE ([salaryhead_pid],[salaryheadcode],[salaryheadname],[headnature_fid],[headtreatment_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_tdsdeclaration''))
     AND name = ''m_idx_employee_fid''
)
CREATE NONCLUSTERED INDEX m_idx_employee_fid
ON [dbo].[tbl_wf_tdsdeclaration] ([employee_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_tdsdeclarationmovement''))
     AND name = ''m_idx_receiver_action_subaction''
)
CREATE NONCLUSTERED INDEX m_idx_receiver_action_subaction
ON [dbo].[tbl_wf_tdsdeclarationmovement] ([reciever_user_fid],[action],[subaction])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendanceroster''))
     AND name = ''m_idx_employee_attendancetype_addendancedate''
)
CREATE NONCLUSTERED INDEX m_idx_employee_attendancetype_addendancedate
ON [dbo].[tbl_attendanceroster] ([employee_fid],[attendancetype_fid],[attendance_date_from])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_monthmaster''))
     AND name = ''m_idx_month_branch_division''
)
CREATE NONCLUSTERED INDEX m_idx_month_branch_division
ON [dbo].[tbl_monthmaster] ([month_fid],[branch_fid],[division_fid])
INCLUDE ([employee_fid],[ForFNF])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_la''))
     AND name = ''m_idx_createdby_employee''
)
CREATE NONCLUSTERED INDEX m_idx_createdby_employee
ON [dbo].[tbl_wf_la] ([createdbyuser_fid],[employee_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendance''))
     AND name = ''m_idx_employee_attendancedate''
)
CREATE NONCLUSTERED INDEX m_idx_employee_attendancedate
ON [dbo].[tbl_attendance] ([employee_fid],[attendance_date_from])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_month''))
     AND name = ''idx_comid_monthval''
)
CREATE NONCLUSTERED INDEX [idx_comid_monthval] ON [dbo].[tbl_month]
(
	[company_fid] ASC,
	[monthval] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_devicecommand''))
     AND name = ''idx_createdon''
)
CREATE NONCLUSTERED INDEX [idx_createdon] ON [dbo].[tbl_ta_devicecommand]
(
	[createdon] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_devicecommand''))
     AND name = ''idx_currentstatus''
)
CREATE NONCLUSTERED INDEX [idx_currentstatus] ON [dbo].[tbl_ta_devicecommand]
(
	[currentstatus] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_devicecommand''))
     AND name = ''idx_serialnumber''
)
CREATE NONCLUSTERED INDEX [idx_serialnumber] ON [dbo].[tbl_ta_devicecommand]
(
	[serialnumber] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_employeebiometricdata''))
     AND name = ''idx_employeedevicecode''
)
CREATE NONCLUSTERED INDEX [idx_employeedevicecode] ON [dbo].[tbl_ta_employeebiometricdata]
(
	[employeedevicecode] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_employeebiometric''))
     AND name = ''idx_employeedevicecode''
)
CREATE NONCLUSTERED INDEX [idx_employeedevicecode] ON [dbo].[tbl_ta_employeebiometric]
(
	[employeedevicecode] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_employee''))
     AND name = ''ix_employeedevicecode''
)
CREATE NONCLUSTERED INDEX [ix_employeedevicecode] ON [dbo].[tbl_employee]
(
	[EmployeeDeviceCode] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_hardware''))
     AND name = ''idx_serialnumber''
)
CREATE NONCLUSTERED INDEX [idx_serialnumber] ON [dbo].[tbl_ta_hardware]
(
	[serialnumber] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_devicecommand''))
     AND name = ''idx_devicecommandpid''
)
CREATE NONCLUSTERED INDEX [idx_devicecommandpid] ON [dbo].[tbl_ta_devicecommand]
(
	[devicecommand_pid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_usernotifications''))
     AND name = ''idx_user_fid''
)
CREATE NONCLUSTERED INDEX idx_user_fid
ON [dbo].[tbl_usernotifications] ([user_fid])
INCLUDE ([md5hash],[deleted])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_usercustomisation''))
     AND name = ''idx_user_fid''
)
CREATE NONCLUSTERED INDEX idx_user_fid
ON [dbo].[tbl_usercustomisation] ([user_fid])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendancetimerecord''))
     AND name = ''idx_compid_empid_attdate''
)
CREATE NONCLUSTERED INDEX idx_compid_empid_attdate
ON [dbo].[tbl_attendancetimerecord] ([company_fid],[employee_fid],[attendance_date])
INCLUDE ([intime],[outtime])



IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_lamovement''))
     AND name = ''idx_rece_act_subact''
)
CREATE NONCLUSTERED INDEX idx_rece_act_subact
ON [dbo].[tbl_wf_lamovement] ([reciever_user_fid],[action],[subaction])
INCLUDE ([LAmovement_pid],[LA_fid],[LEVEL],[movementdate],[LAremarks])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_reimbursement''))
     AND name = ''idx_emp_iscancel''
)
CREATE NONCLUSTERED INDEX idx_emp_iscancel
ON [dbo].[tbl_wf_reimbursement] ([employee_fid],[iscancel])



IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_reimbursementmovement''))
     AND name = ''idx_rec_act_subact''
)
CREATE NONCLUSTERED INDEX idx_rec_act_subact
ON [dbo].[tbl_wf_reimbursementmovement] ([reciever_user_fid],[action],[subaction])
INCLUDE ([Reimbursementmovement_pid],[Reimbursement_fid],[LEVEL],[movementdate],[SanctionedAmount],[Reimbursementremarks])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendancetimerecord_temp''))
     AND name = ''idx_createddate''
)
CREATE NONCLUSTERED INDEX [idx_createddate] ON [dbo].[tbl_attendancetimerecord_temp]
(
	[created_date] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_monthmaster''))
     AND name = ''idx_company_fid_mmPid_m_pid_emp_pid''
)
CREATE NONCLUSTERED INDEX idx_company_fid_mmPid_m_pid_emp_pid
ON [dbo].[tbl_monthmaster] ([company_fid])
INCLUDE ([monthmaster_pid],[month_fid],[employee_fid])

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_monthmaster''))
     AND name = ''idx_comp_id_monthfid''
)
CREATE NONCLUSTERED INDEX idx_comp_id_monthfid
ON [dbo].[tbl_monthmaster] ([company_fid],[month_fid])
INCLUDE ([monthmaster_pid],[employee_fid])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_user''))
     AND name = ''idx_tbl_user_loginusername''
)
CREATE NONCLUSTERED INDEX idx_tbl_user_loginusername
ON [dbo].[tbl_user] ([loginusername])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_transferpromotion''))
     AND name = ''idx_dateoftransferpromotion''
)
CREATE NONCLUSTERED INDEX idx_dateoftransferpromotion
ON [dbo].[tbl_transferpromotion] ([dateoftransferpromotion])


--Additional Checking of MonthStartDate
IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_monthmaster''))
     AND name = ''idx_payrollcyledefinition_fid''
)
IF NOT EXISTS (
   SELECT 1
   FROM syscolumns
   WHERE id = (SELECT OBJECT_ID(''tbl_month''))
     AND name = ''monthstartdate''
)
CREATE NONCLUSTERED INDEX idx_payrollcyledefinition_fid
ON [dbo].[tbl_monthmaster] ([PayrollCycleDefinition_fid])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_paymaster''))
     AND name = ''idx_arrearsdetail_fid''
)
CREATE NONCLUSTERED INDEX idx_arrearsdetail_fid
ON [dbo].[tbl_paymaster] ([arrearsdetail_fid])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_paymaster''))
     AND name = ''idx_partofmonthlysalary''
)
CREATE NONCLUSTERED INDEX idx_partofmonthlysalary
ON [dbo].[tbl_paymaster] ([partofmonthlysalary])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_paymaster''))
     AND name = ''idx_considerpaydayforarrears''
)
CREATE NONCLUSTERED INDEX idx_considerpaydayforarrears
ON [dbo].[tbl_paymaster] ([considerpaydaysforarrears])



IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_user''))
     AND name = ''idx_companyid_userrole''
)
CREATE NONCLUSTERED INDEX idx_companyid_userrole
ON [dbo].[tbl_user] ([company_fid],[userrole_fid])
INCLUDE ([user_pid],[loginusername],[loginpassword],[employee_fid],[isuserdisabled])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_user''))
     AND name = ''idx_userrole_fid''
)
CREATE NONCLUSTERED INDEX idx_userrole_fid
ON [dbo].[tbl_user] ([userrole_fid])
INCLUDE ([user_pid],[company_fid],[loginusername],[loginpassword],[adusername],[activedirectory_fid],[isglobaluser])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_user''))
     AND name = ''idx_adusername''
)
CREATE NONCLUSTERED INDEX [idx_adusername] 
ON [dbo].[tbl_user] ([adusername] ASC)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_deviceoperations''))
     AND name = ''idx_deviceserialnumber''
)
CREATE NONCLUSTERED INDEX [idx_deviceserialnumber] ON [dbo].[tbl_ta_deviceoperations]
(
	[deviceserialnumber] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_udfstore''))
     AND name = ''idx_udf_fid_entity_fid''
)
CREATE NONCLUSTERED INDEX [idx_udf_fid_entity_fid] ON [dbo].[tbl_udfstore]
(
	[udf_fid] ASC,
	[entity_fid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_fnf''))
     AND name = ''idx_employee_fid''
)
CREATE NONCLUSTERED INDEX [idx_employee_fid] ON [dbo].[tbl_wf_fnf]
(
	[employee_fid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_la_document''))
     AND name = ''idx_la_fid''
)
CREATE NONCLUSTERED INDEX [idx_la_fid] ON [dbo].[tbl_wf_la_document]
(
	[la_fid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_la_document''))
     AND name = ''idx_employee_fid''
)
CREATE NONCLUSTERED INDEX [idx_employee_fid] ON [dbo].[tbl_wf_la_document]
(
	[employee_fid] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_la_document''))
     AND name = ''idx_approved''
)
CREATE NONCLUSTERED INDEX [idx_approved] ON [dbo].[tbl_wf_la_document]
(
	[approved] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_employeepersonalinfo_temp''))
     AND name = ''idx_wfstatus''
)
CREATE NONCLUSTERED INDEX idx_wfstatus
ON [dbo].[tbl_wf_employeepersonalinfo_temp] ([wfstatus])
INCLUDE ([company_fid],[employeepersonalinfotemp_pid],[employee_fid],[level],[finalaccept],[isCheckerMaker])


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_employee''))
     AND name = ''idx_companyid_nonactive''
)
CREATE NONCLUSTERED INDEX idx_companyid_nonactive
ON [dbo].[tbl_employee] ([company_fid],[employeenonactive])
INCLUDE ([employee_pid])





IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_pages''))
     AND name = ''idx_res_fid''
)
CREATE NONCLUSTERED INDEX [idx_res_fid] ON [dbo].[tbl_pages]
(
	[res_fid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_pages''))
     AND name = ''idx_moduleESS''
)
CREATE NONCLUSTERED INDEX [idx_moduleESS] ON [dbo].[tbl_pages]
(
	[moduleESS] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_pages''))
     AND name = ''idx_moduleEP''
)
CREATE NONCLUSTERED INDEX [idx_moduleEP] ON [dbo].[tbl_pages]
(
	[moduleEP] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_pages''))
     AND name = ''idx_moduleMSS''
)
CREATE NONCLUSTERED INDEX [idx_moduleMSS] ON [dbo].[tbl_pages]
(
	[moduleMSS] ASC
)



IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_pages''))
     AND name = ''idx_isnotapplicable''
)
CREATE NONCLUSTERED INDEX [idx_isnotapplicable] ON [dbo].[tbl_pages]
(
	[isnotapplicable] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_reimbursement''))
     AND name = ''idx_employee_fid''
)
CREATE NONCLUSTERED INDEX [idx_employee_fid] ON [dbo].[tbl_wf_reimbursement]
(
	[employee_fid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_wf_la''))
     AND name = ''idx_attendancetype_fid''
)
CREATE NONCLUSTERED INDEX [idx_attendancetype_fid] ON [dbo].[tbl_wf_la]
(
	[attendancetype_fid] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendanceledger''))
     AND name = ''idx_emp_temp_attendancecategory_ay''
)
CREATE NONCLUSTERED INDEX [idx_emp_temp_attendancecategory_ay] ON [dbo].[tbl_attendanceledger]
(
	[employee_fid] ASC,
	[attendanceyear_fid] ASC,
	[attendancecategory_fid] ASC,
	[temp] ASC
)





IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendanceledger''))
     AND name = ''idx_emp_temp_attendancetype_ay''
)
CREATE NONCLUSTERED INDEX [idx_emp_temp_attendancetype_ay] ON [dbo].[tbl_attendanceledger]
(
	[employee_fid] ASC,
	[attendanceyear_fid] ASC,
	[attendancetype_fid] ASC,
	[temp] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendanceledger''))
     AND name = ''idx_emp_temp_paymaster_attendancetype_ay''
)
CREATE NONCLUSTERED INDEX [idx_emp_temp_paymaster_attendancetype_ay] ON [dbo].[tbl_attendanceledger]
(
	[employee_fid] ASC,
	[attendanceyear_fid] ASC,
	[paymaster_fid] ASC,
	[attendancetype_fid] ASC,
	[temp] ASC
)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_timelog''))
     AND name = ''idx_emp_isprocess''
)
CREATE NONCLUSTERED INDEX idx_emp_isprocess ON [dbo].tbl_ta_timelog
(
	employee_fid, logtime_d
 
)
include (isprocessed)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_timelog''))
     AND name = ''idx_empdevicecode''
)
CREATE NONCLUSTERED INDEX idx_empdevicecode ON [dbo].tbl_ta_timelog
(
	employeedevicecode, logtime_d
 
)
include (employee_fid)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_ta_timelog''))
     AND name = ''idx_comp_logip_hid_time''
)
CREATE NONCLUSTERED INDEX [idx_comp_logip_hid_time] ON [dbo].[tbl_ta_timelog]

(
	
	[company_fid] ASC,
	
	[logtime_d] ASC,
	
	[log_hardware_fid] ASC,
	
	[logIP] ASC

)


IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendanceledger''))
     AND name = ''idx_emp_temp_attendancecategory_ay''
)
CREATE NONCLUSTERED INDEX [idx_emp_temp_attendancecategory_ay] ON [dbo].[tbl_attendanceledger]
(
	[employee_fid] ASC,
	[attendanceyear_fid] ASC,
	[attendancecategory_fid] ASC,
	[temp] ASC
)

IF NOT EXISTS (
   SELECT 1
   FROM sysindexes
   WHERE id = (SELECT OBJECT_ID(''tbl_attendance''))
     AND name = ''idx_attendance''
)

CREATE NONCLUSTERED INDEX [idx_attendance] ON [dbo].[tbl_attendance]
(
	[employee_fid] ASC,
	[displaymonth_fid] ASC
)
INCLUDE
 ( 	[attendance_date_from],
	[attendancetype_fid],
	[attendancevalue],
	[arrearstype],
	[ArrearsMode]
) 

'
   exec (@cmd)  
   FETCH NEXT FROM DatabaseCursor INTO @Database  
END  

CLOSE DatabaseCursor   
DEALLOCATE DatabaseCursor