[dbo].[autodelegation]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	10:24:08 AM Sunday, December 05, 2010
Last Modified	10:24:08 AM Sunday, December 05, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

10:24:08 AM Sunday, December 05, 2010

Last Modified

10:24:08 AM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)	Default
$Primary Key PK__autodelegation__262B4420: DELEGATEDBY\productid$ $Indexes autodelegation_ind1: productid\DELEGATEDBY$	DELEGATEDBY	nvarchar(50)	100
$Indexes autodelegation_ind2: productid\DELEGATEDTO$	DELEGATEDTO	nvarchar(50)	100
$Primary Key PK__autodelegation__262B4420: DELEGATEDBY\productid$ $Indexes autodelegation_ind1: productid\DELEGATEDBY$ $Indexes autodelegation_ind2: productid\DELEGATEDTO$	productid	binary(16)	16
	lastcheckin	bigint	8	('0')

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Primary Key PK__autodelegation__262B4420: DELEGATEDBY\productid$ $Indexes autodelegation_ind1: productid\DELEGATEDBY$

DELEGATEDBY

nvarchar(50)

100

$Indexes autodelegation_ind2: productid\DELEGATEDTO$

DELEGATEDTO

nvarchar(50)

100

$Primary Key PK__autodelegation__262B4420: DELEGATEDBY\productid$ $Indexes autodelegation_ind1: productid\DELEGATEDBY$ $Indexes autodelegation_ind2: productid\DELEGATEDTO$

productid

binary(16)

lastcheckin

bigint

('0')

	Name	Columns
$Primary Key PK__autodelegation__262B4420: DELEGATEDBY\productid$	PK__autodelegation__262B4420	DELEGATEDBY, productid
	autodelegation_ind1	productid, DELEGATEDBY
	autodelegation_ind2	productid, DELEGATEDTO

Name

Columns

Unique

$Primary Key PK__autodelegation__262B4420: DELEGATEDBY\productid$

PK__autodelegation__262B4420

DELEGATEDBY, productid

autodelegation_ind1

productid, DELEGATEDBY

autodelegation_ind2

productid, DELEGATEDTO

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

Type

Action

Owning Principal

Grant

Delete

workflow_admin_group

Grant

Insert

workflow_admin_group

Grant

Select

workflow_admin_group

Grant

Update

workflow_admin_group

SQL Script

CREATE TABLE [dbo].[autodelegation]
(
[DELEGATEDBY] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[DELEGATEDTO] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[productid] [binary] (16) NOT NULL,
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__autodeleg__lastc__25371FE7] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[autodelegation] ADD CONSTRAINT [PK__autodelegation__262B4420] PRIMARY KEY NONCLUSTERED ([DELEGATEDBY], [productid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [autodelegation_ind1] ON [dbo].[autodelegation] ([productid], [DELEGATEDBY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [autodelegation_ind2] ON [dbo].[autodelegation] ([productid], [DELEGATEDTO]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[autodelegation] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[autodelegation] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[autodelegation] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[autodelegation] TO [workflow_admin_group]
GO