[cohesion].[QLSCHEDULER

[cohesion].[QLSCHEDULER_STATE]

(local) > cohesion > Tables > cohesion.QLSCHEDULER_STATE

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:18:10 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Columns

Name	Data Type	Max Length (Bytes)
INSTANCE_NAME	varchar(90)	90
LAST_CHECKIN_TIME	bigint	8
CHECKIN_INTERVAL	bigint	8
RECOVERER	varchar(90)	90

Indexes

	Name	Columns	Unique
	PK__QLSCHEDULER_STAT__51300E55	INSTANCE_NAME

SQL Script

CREATE TABLE [cohesion].[QLSCHEDULER_STATE]
(
[INSTANCE_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LAST_CHECKIN_TIME] [bigint] NULL,
[CHECKIN_INTERVAL] [bigint] NULL,
[RECOVERER] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[QLSCHEDULER_STATE] ADD CONSTRAINT [PK__QLSCHEDULER_STAT__51300E55] PRIMARY KEY CLUSTERED ([INSTANCE_NAME]) ON [PRIMARY]
GO

Uses

cohesion