[dbo].[wf_locks]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	4
Created	11:07:45 AM Wednesday, March 07, 2007
Last Modified	6:56:18 PM Sunday, April 12, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

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

Last Modified

6:56:18 PM Sunday, April 12, 2009

	Name	Data Type	Max Length (Bytes)	Default
$Primary Key pk_wf_locks: id\productid$ $Indexes locks_ind1: id\productid$	id	nvarchar(32)	64
	inuse	nvarchar(32)	64	(' ')
$Primary Key pk_wf_locks: id\productid$ $Indexes locks_ind1: id\productid$	productid	binary(16)	16
	lastcheckin	bigint	8	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Primary Key pk_wf_locks: id\productid$ $Indexes locks_ind1: id\productid$

nvarchar(32)

inuse

nvarchar(32)

(' ')

$Primary Key pk_wf_locks: id\productid$ $Indexes locks_ind1: id\productid$

productid

binary(16)

lastcheckin

bigint

((0))

	Name	Columns	Unique
$Primary Key pk_wf_locks: id\productid$	pk_wf_locks	id, productid
	locks_ind1	id, productid

Name

Columns

Unique

$Primary Key pk_wf_locks: id\productid$

pk_wf_locks

id, productid

locks_ind1

id, productid

Type	Action	Owning Principal
Grant	Delete	workflow_admin_group
Grant	Insert	workflow_admin_group
Grant	Select	workflow_admin_group
Grant	Update	workflow_admin_group
Grant	Select	workflow_ro_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

Grant

Select

workflow_ro_group

SQL Script

CREATE TABLE [dbo].[wf_locks]
(
[id] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[inuse] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__wf_locks__inuse__7212AA8A] DEFAULT (' '),
[productid] [binary] (16) NOT NULL,
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__wf_locks__lastch__0B1F1ACD] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wf_locks] ADD CONSTRAINT [pk_wf_locks] PRIMARY KEY NONCLUSTERED ([id], [productid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [locks_ind1] ON [dbo].[wf_locks] ([id], [productid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wf_locks] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[wf_locks] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[wf_locks] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[wf_locks] TO [workflow_admin_group]
GRANT SELECT ON  [dbo].[wf_locks] TO [workflow_ro_group]
GO