[dbo].[CMSADMINRESOURCEBACKBONEDATA]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:13:48 AM Wednesday, March 07, 2007
Last Modified	11:13:52 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
	UECHECKEDOUT	int	4
	UECHECKEDOUTTIME	datetime	8
$Cluster Primary Key UE107d798c7e5: UEDBID\UEPORINSTANCEID$	UEDBID	int	4
	UEMODTIME	datetime	8
	UENUMEMPTYREQUIRED	int	4
$Cluster Primary Key UE107d798c7e5: UEDBID\UEPORINSTANCEID$ $Indexes UE107d798c7e6: UECCITEMID\UEPORINSTANCEID$	UEPORINSTANCEID	nvarchar(255)	510
	UEPUBSTAGE	int	4
	UEPUBTIME	datetime	8
	UEACTIVATION	datetime	8
	UECCITEMFIELDNAME	varchar(255)	255
$Indexes UE107d798c7e6: UECCITEMID\UEPORINSTANCEID$	UECCITEMID	int	4
	UECCITEMTABLENAME	varchar(255)	255
	UEEXPIRATION	datetime	8
	UEEXPSTATUS	int	4
	UELASTEXPNOTIFICAT	datetime	8
	UEOWNER	nvarchar(255)	510
	UEPARENTPATH	nvarchar(255)	510
	UERESOURCENAME	nvarchar(255)	510
	UERESOURCENAMEUP	nvarchar(255)	510
	UERESOURCETITLE	nvarchar(255)	510
	UERESOURCETITLEUP	nvarchar(255)	510

	Name	Columns
$Cluster Primary Key UE107d798c7e5: UEDBID\UEPORINSTANCEID$	UE107d798c7e5	UEDBID, UEPORINSTANCEID
	UE107d798c7e6	UECCITEMID, UEPORINSTANCEID
	IDX_CMSBBNAMEUP	UERESOURCENAMEUP
	idx_cmsbbparentpath	UEPARENTPATH
	IDX_CMSBBTITLEUP	UERESOURCETITLEUP

Type	Action	Owning Principal
Grant	Delete	portaldba_group
Grant	Insert	portaldba_group
Grant	Select	portaldba_group
Grant	Update	portaldba_group

SQL Script

CREATE TABLE [dbo].[CMSADMINRESOURCEBACKBONEDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPORINSTANCEID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEACTIVATION] [datetime] NULL,
[UECCITEMFIELDNAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UECCITEMID] [int] NULL,
[UECCITEMTABLENAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEEXPIRATION] [datetime] NULL,
[UEEXPSTATUS] [int] NULL,
[UELASTEXPNOTIFICAT] [datetime] NULL,
[UEOWNER] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEPARENTPATH] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UERESOURCENAME] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UERESOURCENAMEUP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UERESOURCETITLE] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UERESOURCETITLEUP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMSADMINRESOURCEBACKBONEDATA] ADD CONSTRAINT [UE107d798c7e5] PRIMARY KEY CLUSTERED ([UEDBID], [UEPORINSTANCEID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMSADMINRESOURCEBACKBONEDATA] ADD CONSTRAINT [UE107d798c7e6] UNIQUE NONCLUSTERED ([UECCITEMID], [UEPORINSTANCEID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [idx_cmsbbparentpath] ON [dbo].[CMSADMINRESOURCEBACKBONEDATA] ([UEPARENTPATH]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX_CMSBBNAMEUP] ON [dbo].[CMSADMINRESOURCEBACKBONEDATA] ([UERESOURCENAMEUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IDX_CMSBBTITLEUP] ON [dbo].[CMSADMINRESOURCEBACKBONEDATA] ([UERESOURCETITLEUP]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[CMSADMINRESOURCEBACKBONEDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[CMSADMINRESOURCEBACKBONEDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[CMSADMINRESOURCEBACKBONEDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[CMSADMINRESOURCEBACKBONEDATA] TO [portaldba_group]
GO