USE [islsupport]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[session_event_to_status](
	[status_code] [varchar](50) NOT NULL,
	[event_type_code] [varchar](50) NOT NULL,
	[new_status_code] [varchar](50) NULL,
	[warning] [bit] NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'CODE', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'GETCODE', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'INVALID', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'MESSAGE', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'NEWSESSION', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'RECONNECT', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'START', 'CANCELED', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'STOP', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('CANCELED', 'TERMINATED', 'CANCELED', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'CODE', 'NEW', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'GETCODE', 'NEW', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'INVALID', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'MESSAGE', 'EMPTY', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'NEWSESSION', 'NEW', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'RECONNECT', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'START', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'STOP', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('EMPTY', 'TERMINATED', 'FINISHED', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'CODE', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'GETCODE', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'INVALID', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'MESSAGE', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'NEWSESSION', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'RECONNECT', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'START', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'STOP', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('FINISHED', 'TERMINATED', 'FINISHED', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'CODE', 'NEW', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'GETCODE', 'NEW', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'INVALID', 'CANCELED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'MESSAGE', 'NEW', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'NEWSESSION', 'NEW', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'RECONNECT', 'RUNNING', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'START', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'STOP', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('NEW', 'TERMINATED', 'FINISHED', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'CODE', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'GETCODE', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'INVALID', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'MESSAGE', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'NEWSESSION', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'RECONNECT', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'START', 'RECONNECTED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'STOP', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RECONNECTED', 'TERMINATED', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'CODE', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'GETCODE', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'INVALID', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'MESSAGE', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'NEWSESSION', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'RECONNECT', 'RUNNING', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'START', 'RUNNING', 1)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'STOP', 'FINISHED', 0)
INSERT INTO [dbo].[session_event_to_status] VALUES ('RUNNING', 'TERMINATED', 'FINISHED', 1)
GO
SET ANSI_PADDING OFF