[dbo].[eccm_actionlog]

Property	Value
Row Count	0
Created	11:07:14 AM Wednesday, March 07, 2007
Last Modified	11:09:08 AM Wednesday, March 07, 2007

Property

Value

Row Count

Created

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

Last Modified

11:09:08 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	key1	int	4
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	key2	int	4
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	chrono1	int	4
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	chrono2	int	4
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	log_type	smallint	2
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	seq	smallint	2
	log_text	binary(1900)	1900

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

key1

int

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

key2

int

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

chrono1

int

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

chrono2

int

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

log_type

smallint

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

seq

smallint

log_text

binary(1900)

1900

	Name	Columns	Unique
$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$	XPKeccm_actionlog	key1, key2, chrono1, chrono2, log_type, seq

Name

Columns

Unique

$Cluster Primary Key XPKeccm_actionlog: key1\key2\chrono1\chrono2\log_type\seq$

XPKeccm_actionlog

key1, key2, chrono1, chrono2, log_type, seq

Type	Action	Owning Principal
Grant	Delete	cmew_admin
Grant	Insert	cmew_admin
Grant	Select	cmew_admin
Grant	Update	cmew_admin
Grant	Select	cmew_rdr

Type

Action

Owning Principal

Grant

Delete

cmew_admin

Grant

Insert

cmew_admin

Grant

Select

cmew_admin

Grant

Update

cmew_admin

Grant

Select

cmew_rdr

SQL Script

CREATE TABLE [dbo].[eccm_actionlog]
(
[key1] [int] NOT NULL,
[key2] [int] NOT NULL,
[chrono1] [int] NOT NULL,
[chrono2] [int] NOT NULL,
[log_type] [smallint] NOT NULL,
[seq] [smallint] NOT NULL,
[log_text] [binary] (1900) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[eccm_actionlog] ADD CONSTRAINT [XPKeccm_actionlog] PRIMARY KEY CLUSTERED ([key1], [key2], [chrono1], [chrono2], [log_type], [seq]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[eccm_actionlog] TO [cmew_admin]
GRANT INSERT ON  [dbo].[eccm_actionlog] TO [cmew_admin]
GRANT DELETE ON  [dbo].[eccm_actionlog] TO [cmew_admin]
GRANT UPDATE ON  [dbo].[eccm_actionlog] TO [cmew_admin]
GRANT SELECT ON  [dbo].[eccm_actionlog] TO [cmew_rdr]
GO