CREATE TABLE [cohesion].[QLFIRED_TRIGGERS]
(
[ENTRY_ID] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TRIGGER_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TRIGGER_GROUP] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_VOLATILE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTANCE_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FIRED_TIME] [bigint] NOT NULL,
[TRIGGER_STATE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JOB_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JOB_GROUP] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IS_STATEFUL] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REQUESTS_RECOVERY] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[QLFIRED_TRIGGERS] ADD CONSTRAINT [PK__QLFIRED_TRIGGERS__46B27FE2] PRIMARY KEY CLUSTERED ([ENTRY_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE4QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([INSTANCE_NAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE7QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([IS_STATEFUL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE3QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([IS_VOLATILE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE6QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([JOB_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE5QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([JOB_NAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE8QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([REQUESTS_RECOVERY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([TRIGGER_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1QLFIRED_TRIGGER] ON [cohesion].[QLFIRED_TRIGGERS] ([TRIGGER_NAME]) ON [PRIMARY]
GO