CREATE TABLE [cohesion].[QFIRED_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].[QFIRED_TRIGGERS] ADD CONSTRAINT [PK__QFIRED_TRIGGERS__2A164134] PRIMARY KEY CLUSTERED ([ENTRY_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE4QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([INSTANCE_NAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE7QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([IS_STATEFUL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE3QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([IS_VOLATILE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE6QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([JOB_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE5QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([JOB_NAME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE8QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([REQUESTS_RECOVERY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([TRIGGER_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1QFIRED_TRIGGER] ON [cohesion].[QFIRED_TRIGGERS] ([TRIGGER_NAME]) ON [PRIMARY]
GO