[dbo].[definitions]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	73
Created	11:07:11 AM Wednesday, March 07, 2007
Last Modified	11:12:43 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key $defin_u000041cd00000000: productid\id$	id	nvarchar(20)	40
	content	image	max
	name	nvarchar(50)	100
	shortname	nvarchar(20)	40
	modified	bigint	8
	description	nvarchar(200)	400
	version	nvarchar(6)	12	('1.0')
$Cluster Primary Key $defin_u000041cd00000000: productid\id$	productid	binary(16)	16
	lastcheckin	bigint	8	((0))

	Name	Columns	Unique
$Cluster Primary Key $defin_u000041cd00000000: productid\id$	$defin_u000041cd00000000	productid, id

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].[definitions]
(
[id] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[content] [image] NOT NULL,
[name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[shortname] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[modified] [bigint] NOT 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__definitio__versi__5AC46587] DEFAULT ('1.0'),
[productid] [binary] (16) NOT NULL,
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__definitio__lastc__743BB575] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[definitions] ADD CONSTRAINT [$defin_u000041cd00000000] PRIMARY KEY CLUSTERED ([productid], [id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[definitions] TO [aionadmin_group]
GRANT SELECT ON  [dbo].[definitions] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[definitions] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[definitions] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[definitions] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[definitions] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[definitions] TO [usmgroup]
GRANT INSERT ON  [dbo].[definitions] TO [usmgroup]
GRANT DELETE ON  [dbo].[definitions] TO [usmgroup]
GRANT UPDATE ON  [dbo].[definitions] TO [usmgroup]
GRANT SELECT ON  [dbo].[definitions] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[definitions] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[definitions] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[definitions] TO [workflow_admin_group]
GRANT SELECT ON  [dbo].[definitions] TO [workflow_ro_group]
GO