CREATE TABLE [dbo].[opra_act]
(
[opra_act_token] [int] NOT NULL,
[opra_act_seqno] [smallint] NOT NULL,
[opra_act_keyword] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_status] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_dest_node] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_workstn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_simul] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_color] [int] NOT NULL,
[opra_act_attrib] [int] NOT NULL,
[opra_act_cr_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_cr_dt] [int] NOT NULL,
[opra_act_cr_ti] [int] NOT NULL,
[opra_act_up_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_up_dt] [int] NOT NULL,
[opra_act_up_ti] [int] NOT NULL,
[opra_act_text] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_cond_op] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_cond_rc] [int] NOT NULL,
[opra_act_quiet] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_audit] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_run_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_run_pw] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_evaluate] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_category] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_severity] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[opra_act_source] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_opra_act] ON [dbo].[opra_act] ([opra_act_token], [opra_act_seqno]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[opra_act] TO [emadmin]
GRANT INSERT ON  [dbo].[opra_act] TO [emadmin]
GRANT DELETE ON  [dbo].[opra_act] TO [emadmin]
GRANT UPDATE ON  [dbo].[opra_act] TO [emadmin]
GRANT SELECT ON  [dbo].[opra_act] TO [emuser]
GRANT SELECT ON  [dbo].[opra_act] TO [uniadmin]
GRANT INSERT ON  [dbo].[opra_act] TO [uniadmin]
GRANT DELETE ON  [dbo].[opra_act] TO [uniadmin]
GRANT UPDATE ON  [dbo].[opra_act] TO [uniadmin]
GRANT SELECT ON  [dbo].[opra_act] TO [uniuser]
GO