[dbo].[UM_PERMISSIONS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	2783
Created	1:08:00 AM Thursday, September 10, 2009
Last Modified	1:08:00 AM Thursday, September 10, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

2783

Created

1:08:00 AM Thursday, September 10, 2009

Last Modified

1:08:00 AM Thursday, September 10, 2009

	Name	Data Type	Max Length (Bytes)	Identity
	ID	int	4	1 - 1
$Indexes INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION: RESOURCE_ID\ACTION$	RESOURCE_ID	varchar(255)	255
$Indexes INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION: RESOURCE_ID\ACTION$	ACTION	varchar(255)	255

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Cluster Primary Key PK__UM_PERMISSIONS__0AD2A005: ID

int

1 - 1

$Indexes INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION: RESOURCE_ID\ACTION$

RESOURCE_ID

varchar(255)

255

$Indexes INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION: RESOURCE_ID\ACTION$

ACTION

varchar(255)

255

	Name	Columns	Unique
	PK__UM_PERMISSIONS__0AD2A005	ID
	INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION	RESOURCE_ID, ACTION

Name

Columns

Unique

PK__UM_PERMISSIONS__0AD2A005

INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION

RESOURCE_ID, ACTION

SQL Script

CREATE TABLE [dbo].[UM_PERMISSIONS]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[RESOURCE_ID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ACTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UM_PERMISSIONS] ADD CONSTRAINT [PK__UM_PERMISSIONS__0AD2A005] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [INDEX_UM_PERMISSIONS_RESOURCE_ID_ACTION] ON [dbo].[UM_PERMISSIONS] ([RESOURCE_ID], [ACTION]) ON [PRIMARY]
GO