USE [ccrsdb]
GO

/****** Object:  Table [pit].[PIT_LAST_REPORT_END]    Script Date: 10/3/2018 4:30:39 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [pit].[PIT_LAST_REPORT_END](
	[single_record_1] [int] NOT NULL,
	[last_report_timestamp] [datetime2](0) NOT NULL,
	[status] [varchar](25) NULL,
	[update_timestamp] [datetime2](0) NULL,
	[update_user] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[single_record_1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [pit].[PIT_LAST_REPORT_END]  WITH CHECK ADD  CONSTRAINT [CK_PIT_LAST_REPORT_END_Locked] CHECK  (([single_record_1]=(1)))
GO

ALTER TABLE [pit].[PIT_LAST_REPORT_END] CHECK CONSTRAINT [CK_PIT_LAST_REPORT_END_Locked]
GO

