[dbo].[upm_baseline

Property	Value
Row Count	0
Created	11:08:11 AM Wednesday, March 07, 2007
Last Modified	6:12:02 PM Monday, May 04, 2009

Property

Value

Row Count

Created

11:08:11 AM Wednesday, March 07, 2007

Last Modified

6:12:02 PM Monday, May 04, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key XPKupm_baseline_group: baseline_uuid\group_uuid$	baseline_uuid	binary(16)	16
$Cluster Primary Key XPKupm_baseline_group: baseline_uuid\group_uuid$	group_uuid	binary(16)	16

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKupm_baseline_group: baseline_uuid\group_uuid$

baseline_uuid

binary(16)

$Cluster Primary Key XPKupm_baseline_group: baseline_uuid\group_uuid$

group_uuid

binary(16)

	Name	Columns	Unique
$Cluster Primary Key XPKupm_baseline_group: baseline_uuid\group_uuid$	XPKupm_baseline_group	baseline_uuid, group_uuid

Name

Columns

Unique

$Cluster Primary Key XPKupm_baseline_group: baseline_uuid\group_uuid$

XPKupm_baseline_group

baseline_uuid, group_uuid

Name	Columns
$upm_b_r0000065100000000	baseline_uuid->[dbo].[upm_baseline_sw].[baseline_uuid]

Name

Columns

$upm_b_r0000065100000000

baseline_uuid->[dbo].[upm_baseline_sw].[baseline_uuid]

Type	Action	Owning Principal
Grant	Delete	upmadmin_group
Grant	Insert	upmadmin_group
Grant	Delete	upmuser_group
Grant	Insert	upmuser_group
Grant	Select	upmadmin_group
Grant	Update	upmadmin_group
Grant	Select	upmuser_group
Grant	Update	upmuser_group

Type

Action

Owning Principal

Grant

Delete

upmadmin_group

Grant

Insert

upmadmin_group

Grant

Delete

upmuser_group

Grant

Insert

upmuser_group

Grant

Select

upmadmin_group

Grant

Update

upmadmin_group

Grant

Select

upmuser_group

Grant

Update

upmuser_group

SQL Script

CREATE TABLE [dbo].[upm_baseline_group]
(
[baseline_uuid] [binary] (16) NOT NULL,
[group_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_baseline_group] ADD CONSTRAINT [XPKupm_baseline_group] PRIMARY KEY CLUSTERED ([baseline_uuid], [group_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_baseline_group] ADD CONSTRAINT [$upm_b_r0000065100000000] FOREIGN KEY ([baseline_uuid]) REFERENCES [dbo].[upm_baseline_sw] ([baseline_uuid])
GO
GRANT SELECT ON  [dbo].[upm_baseline_group] TO [upmadmin_group]
GRANT INSERT ON  [dbo].[upm_baseline_group] TO [upmadmin_group]
GRANT DELETE ON  [dbo].[upm_baseline_group] TO [upmadmin_group]
GRANT UPDATE ON  [dbo].[upm_baseline_group] TO [upmadmin_group]
GRANT SELECT ON  [dbo].[upm_baseline_group] TO [upmuser_group]
GRANT INSERT ON  [dbo].[upm_baseline_group] TO [upmuser_group]
GRANT DELETE ON  [dbo].[upm_baseline_group] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[upm_baseline_group] TO [upmuser_group]
GO