[dbo].[ujo_audit

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:13:12 AM Wednesday, March 07, 2007

Last Modified

11:13:12 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Key audit_msg_PUC: audit_info_num\seq_no$	audit_info_num	int	4
$Cluster Key audit_msg_PUC: audit_info_num\seq_no$	seq_no	int	4
	attribute	varchar(30)	30
	value	varchar(4096)	4096
	is_edit	varchar(1)	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Key audit_msg_PUC: audit_info_num\seq_no$

audit_info_num

int

$Cluster Key audit_msg_PUC: audit_info_num\seq_no$

seq_no

int

attribute

varchar(30)

value

varchar(4096)

4096

is_edit

varchar(1)

	Name	Columns	Unique
$Cluster Key audit_msg_PUC: audit_info_num\seq_no$	audit_msg_PUC	audit_info_num, seq_no

Name

Columns

Unique

$Cluster Key audit_msg_PUC: audit_info_num\seq_no$

audit_msg_PUC

audit_info_num, seq_no

Type	Action	Owning Principal
Grant	Delete	ujoadmin
Grant	Insert	ujoadmin
Grant	Select	ujoadmin
Grant	Update	ujoadmin

Type

Action

Owning Principal

Grant

Delete

ujoadmin

Grant

Insert

ujoadmin

Grant

Select

ujoadmin

Grant

Update

ujoadmin

SQL Script

CREATE TABLE [dbo].[ujo_audit_msg]
(
[audit_info_num] [int] NOT NULL,
[seq_no] [int] NOT NULL,
[attribute] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[value] [varchar] (4096) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[is_edit] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [audit_msg_PUC] ON [dbo].[ujo_audit_msg] ([audit_info_num], [seq_no]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_audit_msg] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_audit_msg] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_audit_msg] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_audit_msg] TO [ujoadmin]
GO