CREATE TABLE [dbo].[C2ORuntimeObjects]
(
[LogXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compressedState] [tinyint] NULL CONSTRAINT [DF__C2ORuntim__compr__0CBAE877] DEFAULT ((0)),
[SecurityContextID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RootID] [int] NULL,
[Instance] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NodeName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ROID] [int] NOT NULL IDENTITY(1, 1),
[ModifiedDate] [datetime] NULL,
[EditState] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseOID] [int] NULL,
[AgentName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreationDate] [datetime] NULL,
[ModifiedStartTime] [datetime] NULL,
[EditedBy] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentID] [int] NULL,
[OperationName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Started] [datetime] NULL,
[DocumentType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compressedLog] [tinyint] NULL CONSTRAINT [DF__C2ORuntim__compr__0DAF0CB0] DEFAULT ((0)),
[Ended] [datetime] NULL,
[Caller] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SecurityContextGrp] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallerNode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RunState] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActualStartTime] [datetime] NULL,
[ServiceId] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VersionNo] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscriminatorType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2ORuntimeObjects] ADD CONSTRAINT [PK_C2ORuntimeObjects_ROID] PRIMARY KEY CLUSTERED ([ROID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [BaseOIDidx] ON [dbo].[C2ORuntimeObjects] ([BaseOID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [PROIDidx] ON [dbo].[C2ORuntimeObjects] ([ParentID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [RROIDidx] ON [dbo].[C2ORuntimeObjects] ([RootID]) ON [PRIMARY]
GO