[dbo].[EventSourceStatus]

(local) > catalystdb > Tables > dbo.EventSourceStatus

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	1:22:13 AM Thursday, September 10, 2009
Last Modified	1:22:13 AM Thursday, September 10, 2009

Columns

Name	Data Type	Max Length (Bytes)
source	varchar(255)	255
inRecoveryMode	bit	1
lastEventSeqNo	bigint	8
lastEventTime	varchar(255)	255
transactionContextId	varchar(255)	255

Indexes

	Name	Columns	Unique
	PK__EventSourceStatu__7D439ABD	source

SQL Script

CREATE TABLE [dbo].[EventSourceStatus]
(
[source] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[inRecoveryMode] [bit] NULL,
[lastEventSeqNo] [bigint] NULL,
[lastEventTime] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transactionContextId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSourceStatus] ADD CONSTRAINT [PK__EventSourceStatu__7D439ABD] PRIMARY KEY CLUSTERED ([source]) ON [PRIMARY]
GO

Uses