[dbo].[instances]

Property	Value
Row Count	3563
Created	11:07:17 AM Wednesday, March 07, 2007
Last Modified	1:49:36 PM Friday, December 14, 2007

	Name	Data Type	Collation	Max Length (Bytes)	Default
$Cluster Primary Key $insta_u000041d400000000: productid\id$	id	nvarchar(20)	SQL_Latin1_General_CP1_CS_AS	40
$Indexes instances_ind1: productid\definitionid$	definitionid	nvarchar(20)	SQL_Latin1_General_CP1_CS_AS	40
	content	image		max
	externals	image		max
	started	bigint		8
	completed	bigint		8
	status	int		4
	name	nvarchar(50)	SQL_Latin1_General_CP1_CS_AS	100
	description	nvarchar(200)	SQL_Latin1_General_CP1_CS_AS	400
	version	nvarchar(6)	SQL_Latin1_General_CP1_CS_AS	12	('1.0')
$Cluster Primary Key $insta_u000041d400000000: productid\id$ $Indexes instances_ind1: productid\definitionid$	productid	binary(16)		16
	reservedby	nvarchar(32)	SQL_Latin1_General_CP1_CS_AS	64
	reservedtime	bigint		8
	lastmodifiedby	nvarchar(32)	SQL_Latin1_General_CP1_CS_AS	64
	killcount	int		4	((0))
	lastcheckin	bigint		8	((0))
	snapshotid	nvarchar(20)	SQL_Latin1_General_CP1_CI_AS	40

	Name	Columns	Unique
$Cluster Primary Key $insta_u000041d400000000: productid\id$	$insta_u000041d400000000	productid, id
	instances_ind1	productid, definitionid

Type	Action	Owning Principal
Grant	Delete	service_desk_admin_group
Grant	Insert	service_desk_admin_group
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Delete	workflow_admin_group
Grant	Insert	workflow_admin_group
Grant	Select	aionadmin_group
Grant	Select	service_desk_admin_group
Grant	Update	service_desk_admin_group
Grant	Select	service_desk_ro_group
Grant	Select	usmgroup
Grant	Update	usmgroup
Grant	Select	workflow_admin_group
Grant	Update	workflow_admin_group
Grant	Select	workflow_ro_group

SQL Script

CREATE TABLE [dbo].[instances]
(
[id] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[definitionid] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[content] [image] NULL,
[externals] [image] NULL,
[started] [bigint] NULL,
[completed] [bigint] NULL,
[status] [int] NULL,
[name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[version] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__instances__versi__1CB22475] DEFAULT ('1.0'),
[productid] [binary] (16) NOT NULL,
[reservedby] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[reservedtime] [bigint] NULL,
[lastmodifiedby] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[killcount] [int] NOT NULL CONSTRAINT [DF__instances__killc__1DA648AE] DEFAULT ((0)),
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__instances__lastc__7623FDE7] DEFAULT ((0)),
[snapshotid] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[instances] ADD CONSTRAINT [$insta_u000041d400000000] PRIMARY KEY CLUSTERED ([productid], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [instances_ind1] ON [dbo].[instances] ([productid], [definitionid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[instances] TO [aionadmin_group]
GRANT SELECT ON  [dbo].[instances] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[instances] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[instances] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[instances] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[instances] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[instances] TO [usmgroup]
GRANT INSERT ON  [dbo].[instances] TO [usmgroup]
GRANT DELETE ON  [dbo].[instances] TO [usmgroup]
GRANT UPDATE ON  [dbo].[instances] TO [usmgroup]
GRANT SELECT ON  [dbo].[instances] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[instances] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[instances] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[instances] TO [workflow_admin_group]
GRANT SELECT ON  [dbo].[instances] TO [workflow_ro_group]
GO