use [Enterprise Manager]
--  
-- Script to Update dbo.AP Invoices in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AP Invoices Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2043154324_8_1] ON [dbo].[AP Invoices] ([Void Flag], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2043154324_8_1_9] ON [dbo].[AP Invoices] ([Void Flag], [ID], [Non-Purchase Flag])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2043154324_8_9] ON [dbo].[AP Invoices] ([Void Flag], [Non-Purchase Flag])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2043154324_9_1] ON [dbo].[AP Invoices] ([Non-Purchase Flag], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AP Invoices Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AP Invoices Table'
END
GO


--  
-- Script to Update dbo.AP Invoices Item Charges in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AP Invoices Item Charges Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2075154438_2_1] ON [dbo].[AP Invoices Item Charges] ([Ordered ID], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2075154438_2_6] ON [dbo].[AP Invoices Item Charges] ([Ordered ID], [Unit Cost])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2075154438_3_1_2] ON [dbo].[AP Invoices Item Charges] ([AP Invoices ID], [ID], [Ordered ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2075154438_3_2] ON [dbo].[AP Invoices Item Charges] ([AP Invoices ID], [Ordered ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2075154438_5_2_3] ON [dbo].[AP Invoices Item Charges] ([Qty Invoiced], [Ordered ID], [AP Invoices ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_2075154438_6_3] ON [dbo].[AP Invoices Item Charges] ([Unit Cost], [AP Invoices ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AP Invoices Item Charges Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AP Invoices Item Charges Table'
END
GO


--  
-- Script to Update dbo.AR Recv Invoices in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.AR Recv Invoices Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_134291538_3_1] ON [dbo].[AR Recv Invoices] ([Job ID], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.AR Recv Invoices Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.AR Recv Invoices Table'
END
GO


--  
-- Script to Update dbo.Crash in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Crash Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   ALTER TABLE [dbo].[Crash]
      ADD [Last Search Refresh Title] [nvarchar] (255) NULL
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Crash Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Crash Table'
END
GO


--  
-- Script to Update dbo.EM Job Hardware in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Job Hardware Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_12_1_11_9_2] ON [dbo].[EM Job Hardware] ([CNC Flag], [ID], [Associated Material ID], [UOM ID], [Assembly ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_12_2_9] ON [dbo].[EM Job Hardware] ([CNC Flag], [Assembly ID], [UOM ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_9_11_1] ON [dbo].[EM Job Hardware] ([UOM ID], [Associated Material ID], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_9_11_2_1] ON [dbo].[EM Job Hardware] ([UOM ID], [Associated Material ID], [Assembly ID], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1321771766_9_12_1] ON [dbo].[EM Job Hardware] ([UOM ID], [CNC Flag], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Job Hardware Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Job Hardware Table'
END
GO


--  
-- Script to Update dbo.EM Job Rooms in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Job Rooms Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_615673241_2_1_6] ON [dbo].[EM Job Rooms] ([Job ID], [ID], [Room Number])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_615673241_2_6] ON [dbo].[EM Job Rooms] ([Job ID], [Room Number])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_615673241_4_1] ON [dbo].[EM Job Rooms] ([Job File ID], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_615673241_4_2_1_6] ON [dbo].[EM Job Rooms] ([Job File ID], [Job ID], [ID], [Room Number])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_615673241_6_4_2] ON [dbo].[EM Job Rooms] ([Room Number], [Job File ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Job Rooms Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Job Rooms Table'
END
GO


--  
-- Script to Update dbo.EM Job Sheet Goods in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Job Sheet Goods Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   ALTER TABLE [dbo].[EM Job Sheet Goods]
      ADD [Material Down Face RGB] [int] NULL
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   ALTER TABLE [dbo].[EM Job Sheet Goods]
      ADD [Material Up Face RGB] [int] NULL
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1673773020_10_15] ON [dbo].[EM Job Sheet Goods] ([Offcut ID], [SKU ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1673773020_10_7_15] ON [dbo].[EM Job Sheet Goods] ([Offcut ID], [Complete], [SKU ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1673773020_15_2_10] ON [dbo].[EM Job Sheet Goods] ([SKU ID], [Job Tasks ID], [Offcut ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1673773020_2_7] ON [dbo].[EM Job Sheet Goods] ([Job Tasks ID], [Complete])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Job Sheet Goods Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Job Sheet Goods Table'
END
GO


--  
-- Script to Update dbo.EM Job Tasks in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Job Tasks Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1753773305_1_15] ON [dbo].[EM Job Tasks] ([ID], [Routing])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Job Tasks Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Job Tasks Table'
END
GO


--  
-- Script to Update dbo.EM Task Parts in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.EM Task Parts Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_816721962_14_3] ON [dbo].[EM Task Parts] ([Rerun], [Job Assemblies ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_816721962_2_12] ON [dbo].[EM Task Parts] ([Job Tasks ID], [Damaged])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_816721962_2_14] ON [dbo].[EM Task Parts] ([Job Tasks ID], [Rerun])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_816721962_3_1] ON [dbo].[EM Task Parts] ([Job Assemblies ID], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_816721962_3_2] ON [dbo].[EM Task Parts] ([Job Assemblies ID], [Job Tasks ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.EM Task Parts Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.EM Task Parts Table'
END
GO


--  
-- Script to Update dbo.Goods Receipt Items in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Goods Receipt Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1159675179_1_2_3] ON [dbo].[Goods Receipt Items] ([ID], [Goods Receipt ID], [Ordered ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1159675179_1_3] ON [dbo].[Goods Receipt Items] ([ID], [Ordered ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1159675179_3_2] ON [dbo].[Goods Receipt Items] ([Ordered ID], [Goods Receipt ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Goods Receipt Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Goods Receipt Items Table'
END
GO


--  
-- Script to Update dbo.Goods Receipts in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Goods Receipts Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1175675236_4_1] ON [dbo].[Goods Receipts] ([Void], [ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Goods Receipts Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Goods Receipts Table'
END
GO


--  
-- Script to Update dbo.Jobs in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Jobs Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_11_25_26] ON [dbo].[Jobs] ([Project Manager ID], [Engineer ID], [Management ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_11_28] ON [dbo].[Jobs] ([Project Manager ID], [Current Status ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_11_4] ON [dbo].[Jobs] ([Project Manager ID], [Inactive])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_15_16] ON [dbo].[Jobs] ([Job Type], [Entered in Accounting])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_15_1_26_25_11_4] ON [dbo].[Jobs] ([Job Type], [Job ID], [Management ID], [Engineer ID], [Project Manager ID], [Inactive])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_15_1_4_26_25] ON [dbo].[Jobs] ([Job Type], [Job ID], [Inactive], [Management ID], [Engineer ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_15_26_25_11] ON [dbo].[Jobs] ([Job Type], [Management ID], [Engineer ID], [Project Manager ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_16_1_4] ON [dbo].[Jobs] ([Entered in Accounting], [Job ID], [Inactive])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_16_28_4_11_25_26] ON [dbo].[Jobs] ([Entered in Accounting], [Current Status ID], [Inactive], [Project Manager ID], [Engineer ID], [Management ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_16_4_15] ON [dbo].[Jobs] ([Entered in Accounting], [Inactive], [Job Type])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_1_26_25_11_15_4_16_28] ON [dbo].[Jobs] ([Job ID], [Management ID], [Engineer ID], [Project Manager ID], [Job Type], [Inactive], [Entered in Accounting], [Current Status ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_1_4_15_11_25] ON [dbo].[Jobs] ([Job ID], [Inactive], [Job Type], [Project Manager ID], [Engineer ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_1_4_16_15_11_25] ON [dbo].[Jobs] ([Job ID], [Inactive], [Entered in Accounting], [Job Type], [Project Manager ID], [Engineer ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_25_26_1] ON [dbo].[Jobs] ([Engineer ID], [Management ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_25_28_4] ON [dbo].[Jobs] ([Engineer ID], [Current Status ID], [Inactive])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_25_4_11_26_15] ON [dbo].[Jobs] ([Engineer ID], [Inactive], [Project Manager ID], [Management ID], [Job Type])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_28_15_4_16_11_25_26] ON [dbo].[Jobs] ([Current Status ID], [Job Type], [Inactive], [Entered in Accounting], [Project Manager ID], [Engineer ID], [Management ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_28_1_4_16_15_11_25] ON [dbo].[Jobs] ([Current Status ID], [Job ID], [Inactive], [Entered in Accounting], [Job Type], [Project Manager ID], [Engineer ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_4_1] ON [dbo].[Jobs] ([Inactive], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_4_16_15_25_26] ON [dbo].[Jobs] ([Inactive], [Entered in Accounting], [Job Type], [Engineer ID], [Management ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_205243786_4_28_11_25_26_15_1] ON [dbo].[Jobs] ([Inactive], [Current Status ID], [Project Manager ID], [Engineer ID], [Management ID], [Job Type], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Jobs Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Jobs Table'
END
GO


--  
-- Script to Update dbo.Purchase Order Item Allocations in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Purchase Order Item Allocations Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_998294616_2_4] ON [dbo].[Purchase Order Item Allocations] ([PO Item ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_998294616_3_1_4] ON [dbo].[Purchase Order Item Allocations] ([Qty Allocated], [Allocation ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Purchase Order Item Allocations Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Purchase Order Item Allocations Table'
END
GO


--  
-- Script to Update dbo.Purchase Order Items in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Purchase Order Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1926297922_11_1_15_3_16] ON [dbo].[Purchase Order Items] ([PO ID], [ID], [SKU ID], [VENDOR CODE], [Vendor ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1926297922_1_16_15_11] ON [dbo].[Purchase Order Items] ([ID], [Vendor ID], [SKU ID], [PO ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1926297922_3_15] ON [dbo].[Purchase Order Items] ([VENDOR CODE], [SKU ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1926297922_3_1_15] ON [dbo].[Purchase Order Items] ([VENDOR CODE], [ID], [SKU ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Purchase Order Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Purchase Order Items Table'
END
GO


--  
-- Script to Update dbo.Purchase Orders in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Purchase Orders Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1495676376_6_2] ON [dbo].[Purchase Orders] ([User ID], [PO Number])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Purchase Orders Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Purchase Orders Table'
END
GO


--  
-- Script to Update dbo.Setting Definitions in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Setting Definitions Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   ALTER TABLE [dbo].[Setting Definitions]
      ADD [Create Default Flag] [bit] NULL
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Setting Definitions Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Setting Definitions Table'
END
GO


--  
-- Script to Update dbo.Setting Groups in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Setting Groups Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE TABLE [dbo].[tmp_Setting Groups] (
   [Setting Group ID] [int] NOT NULL,
   [Setting Group Name] [nvarchar] (50) NULL
)
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   INSERT INTO [dbo].[tmp_Setting Groups] ([Setting Group ID], [Setting Group Name])
   SELECT [Setting Group ID], [Setting Group Name]
   FROM [dbo].[Setting Groups]
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   DROP TABLE [dbo].[Setting Groups]
GO

sp_rename N'[dbo].[tmp_Setting Groups]', N'Setting Groups'

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Setting Groups Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Setting Groups Table'
END
GO


--  
-- Script to Update dbo.Shipment Items in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Shipment Items Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1607676775_1_3_8] ON [dbo].[Shipment Items] ([ID], [Location ID], [Location Table ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Shipment Items Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Shipment Items Table'
END
GO


--  
-- Script to Update dbo.Time Tracking: Activity Allocations in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Time Tracking: Activity Allocations Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_11_1_3] ON [dbo].[Time Tracking: Activity Allocations] ([Void Flag], [Allocation ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_11_3_2] ON [dbo].[Time Tracking: Activity Allocations] ([Void Flag], [Job ID], [Employee ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_11_4] ON [dbo].[Time Tracking: Activity Allocations] ([Void Flag], [Activity Date])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_1_3] ON [dbo].[Time Tracking: Activity Allocations] ([Allocation ID], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_2_11] ON [dbo].[Time Tracking: Activity Allocations] ([Employee ID], [Void Flag])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_2_4_11_3] ON [dbo].[Time Tracking: Activity Allocations] ([Employee ID], [Activity Date], [Void Flag], [Job ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_448720651_3_2_4] ON [dbo].[Time Tracking: Activity Allocations] ([Job ID], [Employee ID], [Activity Date])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Time Tracking: Activity Allocations Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Time Tracking: Activity Allocations Table'
END
GO


--  
-- Script to Update dbo.Timeclock Punches in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Timeclock Punches Table'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
   CREATE STATISTICS [_dta_stat_1847677630_3_2] ON [dbo].[Timeclock Punches] ([Effective Date], [User ID])
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Timeclock Punches Table Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Timeclock Punches Table'
END
GO


--  
-- Script to Update dbo.Home: Items Still On Request in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.Home: Items Still On Request View'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


exec('ALTER VIEW [dbo].[Home: Items Still On Request]
AS
SELECT DISTINCT 
                      [Requestor User ID] AS [Alert User ID], ''Requested'' AS [Alert Location], 0 AS [Alert Location ID], ''Items requested for 3 or more days.'' AS [Alert Text], 
                      ''0x0000ff'' AS [Alert FG Color], ''0xFFFFFF'' AS [Alert BG Color], - 2 AS [Alert User ID 2], - 2 AS [Alert User ID 3], - 2 AS [Alert User ID 4]
FROM         dbo.[PO Item Details]
WHERE     ([Requested Date] < GETDATE() - 3) AND (COALESCE ([PO ID], 0) = 0) AND (COALESCE (Suspended, 0) = 0)
')
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.Home: Items Still On Request View Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.Home: Items Still On Request View'
END
GO


--  
-- Script to Create dbo.view: Job - Current Status in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Creating dbo.view: Job - Current Status View'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


exec('CREATE VIEW [dbo].[view: Job - Current Status]
AS
SELECT DISTINCT [Job ID] AS [Status For Job ID],
                          (SELECT     TOP (1) [Job Status Text]
                            FROM          dbo.[Job Status Updates]
                            WHERE      ([Job ID] = Table1.[Job ID])
                            ORDER BY [Status Created DateTime] DESC) AS [Job Status Text]
FROM         dbo.[Job Status Updates] AS Table1
')
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.view: Job - Current Status View Added Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Add dbo.view: Job - Current Status View'
END
GO


--  
-- Script to Update dbo.view: Job Finance Report in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.view: Job Finance Report View'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


exec('ALTER VIEW [dbo].[view: Job Finance Report]
AS
SELECT     dbo.Jobs.[Job ID], dbo.Jobs.[Job Description], dbo.Jobs.[Paid Date], dbo.Jobs.Inactive, dbo.Jobs.[Customer ID], dbo.Jobs.[WIP Code], dbo.Jobs.[G/L Sales Account], 
                      dbo.Jobs.[Date Added], dbo.Jobs.[User ID], dbo.Jobs.[Project Manager ID], dbo.Jobs.Estimate, dbo.Jobs.[Job Type], dbo.Jobs.[Entered in Accounting], 
                      dbo.Jobs.[Accounting ID], dbo.Jobs.SSMA_TimeStamp, dbo.Jobs.[Parent Job ID], dbo.[AR Invoice Totals by Job].SumOfExtendedInvoices AS [Invoices Total], 
                      dbo.[AR Payment Totals by Job].SumOfExtendedPayments AS [Payments Total], dbo.[AR Contract Totals by Job].SumOfExtendedContracts AS [Contracts Total], 
                      dbo.[FINANCE Buyouts Totals By Job].[Buyouts Total], dbo.[FINANCE Buyouts Totals By Job].[Charges Total], dbo.[Time Tracking: By Job].[Hours Allocated], 
                      dbo.Jobs.[Tax Rate], dbo.Jobs.[Tax Exempt Flag], dbo.Jobs.[Estimate Bid Date], dbo.Jobs.[Related Job ID], dbo.Jobs.[Tax Authority], dbo.Jobs.[Engineer ID], 
                      dbo.Jobs.[Customer PO], dbo.Jobs.[Management ID], dbo.[view: Job Finance Report - Budget Values].[Budget Total Cost], 
                      dbo.[view: Job Finance Report - Budget Values].[Budget Total Hours], dbo.[view: Finance - Job Report - Pending Costs].[Pending Costs], 
                      dbo.[view: Job Finance Report - Pending Stock BOM Costs].[Pending Stock BOM Costs], 
                      dbo.[view: Job Finance Report - Pending Stock CNC Costs].[Pending Stock CNC Costs], dbo.[AR Invoice Totals by Job].[Invoices Total Tax], 
                      dbo.[AR Contract Totals by Job].[Contracts Total Tax], dbo.[AR Payment Totals by Job].[Tax Paid] AS [Payments Total Tax], 
                      dbo.[view: Job - Current Status].[Job Status Text]
FROM         dbo.Jobs LEFT OUTER JOIN
                      dbo.[view: Job - Current Status] ON dbo.Jobs.[Job ID] = dbo.[view: Job - Current Status].[Status For Job ID] LEFT OUTER JOIN
                      dbo.[view: Job Finance Report - Pending Stock CNC Costs] ON dbo.Jobs.[Job ID] = dbo.[view: Job Finance Report - Pending Stock CNC Costs].[Job ID] LEFT OUTER JOIN
                      dbo.[view: Job Finance Report - Pending Stock BOM Costs] ON 
                      dbo.Jobs.[Job ID] = dbo.[view: Job Finance Report - Pending Stock BOM Costs].[Job ID] LEFT OUTER JOIN
                      dbo.[view: Finance - Job Report - Pending Costs] ON dbo.Jobs.[Job ID] = dbo.[view: Finance - Job Report - Pending Costs].[Job ID] LEFT OUTER JOIN
                      dbo.[view: Job Finance Report - Budget Values] ON dbo.Jobs.[Job ID] = dbo.[view: Job Finance Report - Budget Values].[Job ID] LEFT OUTER JOIN
                      dbo.[Time Tracking: By Job] ON dbo.Jobs.[Job ID] = dbo.[Time Tracking: By Job].[Job ID] LEFT OUTER JOIN
                      dbo.[FINANCE Buyouts Totals By Job] ON dbo.Jobs.[Job ID] = dbo.[FINANCE Buyouts Totals By Job].[Job ID] LEFT OUTER JOIN
                      dbo.[AR Invoice Totals by Job] ON dbo.Jobs.[Job ID] = dbo.[AR Invoice Totals by Job].[Job ID] LEFT OUTER JOIN
                      dbo.[AR Payment Totals by Job] ON dbo.Jobs.[Job ID] = dbo.[AR Payment Totals by Job].[Job ID] LEFT OUTER JOIN
                      dbo.[AR Contract Totals by Job] ON dbo.Jobs.[Job ID] = dbo.[AR Contract Totals by Job].[Job ID]
')
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.view: Job Finance Report View Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.view: Job Finance Report View'
END
GO


--  
-- Script to Update dbo.view: Sheet Good Details in fwpsrv.Enterprise Manager 
-- Generated Wednesday, January 4, 2012, at 12:48 PM 
--  
-- Please backup fwpsrv.Enterprise Manager before executing this script
--  
-- ** Script Begin **
BEGIN TRANSACTION
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

PRINT 'Updating dbo.view: Sheet Good Details View'
GO

SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL ON
GO

SET NUMERIC_ROUNDABORT OFF
GO


exec('ALTER VIEW [dbo].[view: Sheet Good Details]
AS
SELECT     ID, [Job Tasks ID], [Code Stored Files ID], Thickness, Width, Length, Complete, [CW Material ID], [Offcut ID], [Date Added], [Machine ID], SSMA_TimeStamp, 
                      [Do Not Remove Comments Flag], [SKU ID], [From Inventory Flag], Source, [Source ID], [Material Name ID], [Material Up Face ID], [Material Down Face ID], 
                      [Up Face Description], [Down Face Description], [Stock Flag], (CASE WHEN [Up Face Description] IS NOT NULL AND [Down Face Description] IS NOT NULL 
                      THEN REPLACE(REPLACE([Display Name Temp], ''[Top Face]'', [UP Face Description]), ''[Bottom Face]'', [Down Face Description]) ELSE [Display Name Temp] END) 
                      AS [Display Name], [Material Name], [6th Face Code Stored Files ID], [Has Grain Flag], [Material Up Face RGB], [Material Down Face RGB]
FROM         (SELECT     TOP 100 PERCENT dbo.[EM Job Sheet Goods].ID, dbo.[EM Job Sheet Goods].[Job Tasks ID], dbo.[EM Job Sheet Goods].[Code Stored Files ID], 
                                              dbo.[EM Job Sheet Goods].Thickness, dbo.[EM Job Sheet Goods].Width, dbo.[EM Job Sheet Goods].Length, dbo.[EM Job Sheet Goods].Complete, 
                                              dbo.[EM Job Sheet Goods].[CW Material ID], dbo.[EM Job Sheet Goods].[Offcut ID], dbo.[EM Job Sheet Goods].[Date Added], 
                                              dbo.[EM Job Sheet Goods].[Machine ID], dbo.[EM Job Sheet Goods].SSMA_TimeStamp, dbo.[EM Job Sheet Goods].[Do Not Remove Comments Flag], 
                                              dbo.[EM Job Sheet Goods].[SKU ID], dbo.[EM Job Sheet Goods].[From Inventory Flag], dbo.[EM Job Sheet Goods].Source, 
                                              dbo.[EM Job Sheet Goods].[Source ID], dbo.[EM Job Sheet Goods].[Material Name ID], dbo.[EM Job Sheet Goods].[Material Up Face ID], 
                                              dbo.[EM Job Sheet Goods].[Material Down Face ID], dbo.[EM Job Sheet Goods].[Material Up Face RGB], 
                                              dbo.[EM Job Sheet Goods].[Material Down Face RGB],
                                                  (SELECT     [Face Description]
                                                    FROM          dbo.[EM Job Sheet Goods Face Descriptions]
                                                    WHERE      ([Face ID] = dbo.[EM Job Sheet Goods].[Material Up Face ID])) AS [Up Face Description],
                                                  (SELECT     [Face Description]
                                                    FROM          dbo.[EM Job Sheet Goods Face Descriptions] AS [EM Job Sheet Goods Face Descriptions_1]
                                                    WHERE      ([Face ID] = dbo.[EM Job Sheet Goods].[Material Down Face ID])) AS [Down Face Description], dbo.FWPSTOCK.[Stock Flag], 
                                              (CASE WHEN [Force Use Material Name] = 1 THEN [Material Name] ELSE (CASE WHEN [Vendor Description] IS NOT NULL 
                                              THEN [Vendor Description] ELSE [Material Name] END) END) AS [Display Name Temp], dbo.FWPSTOCK.[Vendor Description], 
                                              dbo.[EM Job Sheet Goods].[Material Name], dbo.[EM Job Sheet Goods].[6th Face Code Stored Files ID], dbo.[EM Job Sheet Goods].[Has Grain Flag]
                       FROM          dbo.[EM Job Sheet Goods] LEFT OUTER JOIN
                                              dbo.FWPSTOCK ON dbo.[EM Job Sheet Goods].[SKU ID] = dbo.FWPSTOCK.[SKU ID]
                       ORDER BY dbo.[EM Job Sheet Goods].ID DESC) AS derivedtbl_1
')
GO

IF @@ERROR <> 0
   IF @@TRANCOUNT = 1 ROLLBACK TRANSACTION
GO

IF @@TRANCOUNT = 1
BEGIN
   PRINT 'dbo.view: Sheet Good Details View Updated Successfully'
   COMMIT TRANSACTION
END ELSE
BEGIN
   PRINT 'Failed To Update dbo.view: Sheet Good Details View'
END
GO