CREATE TABLE [dbo].[CMS_InfoObjects5]
(
[ObjectID] [numeric] (12, 0) NOT NULL,
[ParentID] [numeric] (12, 0) NOT NULL,
[TypeID] [numeric] (12, 0) NOT NULL,
[OwnerID] [numeric] (12, 0) NOT NULL,
[LastModifyTime] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ObjFlags] [numeric] (12, 0) NOT NULL,
[UserFlags] [numeric] (12, 0) NULL,
[ScheduleStatus] [numeric] (12, 0) NULL,
[NextRunTime] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Aliases] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CRC] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Properties] [image] NOT NULL,
[SI_GUID] [varbinary] (56) NULL,
[SI_CUID] [varbinary] (56) NULL,
[SI_RUID] [varbinary] (56) NULL,
[SI_INSTANCE_OBJECT] [numeric] (12, 0) NULL,
[SI_PLUGIN_OBJECT] [numeric] (12, 0) NULL,
[SI_TABLE] [numeric] (12, 0) NULL,
[SI_HIDDEN_OBJECT] [numeric] (12, 0) NULL,
[SI_NAMEDUSER] [numeric] (12, 0) NULL,
[SI_RECURRING] [numeric] (12, 0) NULL,
[SI_RUNNABLE_OBJECT] [numeric] (12, 0) NULL,
[SI_TYPEID_MACHINE] [numeric] (12, 0) NULL,
[SI_KEYWORD] [varbinary] (255) NULL,
[SI_KEYWORDIsTruncated] [numeric] (12, 0) NULL,
[LOV_KEY] [varbinary] (18) NULL,
[ObjName] [varbinary] (255) NULL,
[ObjNameIsTruncated] [numeric] (12, 0) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_InfoObjects5_4] ON [dbo].[CMS_InfoObjects5] ([LastModifyTime]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [LOV_KEY_index5] ON [dbo].[CMS_InfoObjects5] ([LOV_KEY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_InfoObjects5_5] ON [dbo].[CMS_InfoObjects5] ([NextRunTime]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [CMS_InfoObjects5_0] ON [dbo].[CMS_InfoObjects5] ([ObjectID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ObjName_index5] ON [dbo].[CMS_InfoObjects5] ([ObjName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ObjNameIsTruncated_index5] ON [dbo].[CMS_InfoObjects5] ([ObjNameIsTruncated]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_InfoObjects5_2] ON [dbo].[CMS_InfoObjects5] ([OwnerID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_InfoObjects5_1] ON [dbo].[CMS_InfoObjects5] ([ParentID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_InfoObjects5_7] ON [dbo].[CMS_InfoObjects5] ([ScheduleStatus]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [SI_CUID_index5] ON [dbo].[CMS_InfoObjects5] ([SI_CUID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [SI_GUID_index5] ON [dbo].[CMS_InfoObjects5] ([SI_GUID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_HIDDEN_OBJECT_index5] ON [dbo].[CMS_InfoObjects5] ([SI_HIDDEN_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_INSTANCE_OBJECT_index5] ON [dbo].[CMS_InfoObjects5] ([SI_INSTANCE_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_KEYWORD_index5] ON [dbo].[CMS_InfoObjects5] ([SI_KEYWORD]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_KEYWORDIsTruncated_index5] ON [dbo].[CMS_InfoObjects5] ([SI_KEYWORDIsTruncated]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_NAMEDUSER_index5] ON [dbo].[CMS_InfoObjects5] ([SI_NAMEDUSER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_PLUGIN_OBJECT_index5] ON [dbo].[CMS_InfoObjects5] ([SI_PLUGIN_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_RECURRING_index5] ON [dbo].[CMS_InfoObjects5] ([SI_RECURRING]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_RUID_index5] ON [dbo].[CMS_InfoObjects5] ([SI_RUID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_RUNNABLE_OBJECT_index5] ON [dbo].[CMS_InfoObjects5] ([SI_RUNNABLE_OBJECT]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_TABLE_index5] ON [dbo].[CMS_InfoObjects5] ([SI_TABLE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SI_TYPEID_MACHINE_index5] ON [dbo].[CMS_InfoObjects5] ([SI_TYPEID_MACHINE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_InfoObjects5_3] ON [dbo].[CMS_InfoObjects5] ([TypeID]) ON [PRIMARY]
GO