Tables [dbo].[wfschema]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count16
Created11:07:45 AM Wednesday, March 07, 2007
Last Modified11:12:43 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key $wfsch_u000041f100000000: productid\namenamenvarchar(50)100
No
schemainfoimagemax
No
Cluster Primary Key $wfsch_u000041f100000000: productid\nameproductidbinary(16)16
No
lastcheckinbigint8
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key $wfsch_u000041f100000000: productid\name$wfsch_u000041f100000000productid, name
Yes
Permissions
TypeActionOwning Principal
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantDeleteusmgroup
GrantInsertusmgroup
GrantDeleteworkflow_admin_group
GrantInsertworkflow_admin_group
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
GrantSelectusmgroup
GrantUpdateusmgroup
GrantSelectworkflow_admin_group
GrantUpdateworkflow_admin_group
GrantSelectworkflow_ro_group
SQL Script
CREATE TABLE [dbo].[wfschema]
(
[name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[schemainfo] [image] NOT NULL,
[productid] [binary] (16) NOT NULL,
[lastcheckin] [bigint] NOT NULL CONSTRAINT [DF__wfschema__lastch__0195B093] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[wfschema] ADD CONSTRAINT [$wfsch_u000041f100000000] PRIMARY KEY CLUSTERED ([productid], [name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wfschema] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[wfschema] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[wfschema] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[wfschema] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[wfschema] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[wfschema] TO [usmgroup]
GRANT INSERT ON  [dbo].[wfschema] TO [usmgroup]
GRANT DELETE ON  [dbo].[wfschema] TO [usmgroup]
GRANT UPDATE ON  [dbo].[wfschema] TO [usmgroup]
GRANT SELECT ON  [dbo].[wfschema] TO [workflow_admin_group]
GRANT INSERT ON  [dbo].[wfschema] TO [workflow_admin_group]
GRANT DELETE ON  [dbo].[wfschema] TO [workflow_admin_group]
GRANT UPDATE ON  [dbo].[wfschema] TO [workflow_admin_group]
GRANT SELECT ON  [dbo].[wfschema] TO [workflow_ro_group]
GO
Uses