CREATE TABLE [dbo].[amepdef]
(
[domainid] [int] NOT NULL,
[epid] [int] NOT NULL,
[eptitle] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[eparea] [int] NULL,
[epevent] [int] NULL,
[epsev] [int] NULL,
[epstate] [int] NULL,
[epflags] [int] NULL,
[ephisday] [int] NULL,
[epid1] [int] NULL,
[epid2] [int] NULL,
[epid3] [int] NULL,
[epid4] [int] NULL,
[epjsup] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[epvfmt] [int] NULL,
[policy_uuid] [binary] (16) NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[epuuid1] [binary] (16) NULL,
[epuuid2] [binary] (16) NULL,
[epuuid3] [binary] (16) NULL,
[epuuid4] [binary] (16) NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_d_so_del_ebased_policy    Script Date: 12/1/2005 11:50:51 PM ******/


/*
*********************************************
trigger for deleteing a event based policy
*/
CREATE trigger rule_d_so_del_ebased_policy
on amepdef
after delete
as
begin
      declare @ddis_hw_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select policy_uuid from deleted

    OPEN mycur
    FETCH NEXT FROM mycur INTO @ddis_hw_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN

        execute   proc_d_so_removed_object @ddis_hw_uuid
        FETCH NEXT FROM mycur INTO @ddis_hw_uuid;

    END

    CLOSE mycur
    DEALLOCATE mycur

    
end;
GO
/****** Object:  Trigger dbo.rule_i_so_new_ebased_policy    Script Date: 12/1/2005 11:51:46 PM ******/

/*
*********************************************
trigger for creating event based policy
*/
CREATE trigger rule_i_so_new_ebased_policy
     on amepdef
     after insert
as
begin
  declare @_obj_uuid binary(16);
  declare @_clsid integer;
  declare @_uri nvarchar(255);
    
    
    select @_obj_uuid = (select policy_uuid  from inserted);
    select @_clsid = 3301;
    select @_uri = (select creation_user from inserted);
    

    execute  proc_i_new_so_object @_obj_uuid, @_clsid, @_uri;
    
end;
GO
ALTER TABLE [dbo].[amepdef] ADD CONSTRAINT [XPKamepdef] PRIMARY KEY CLUSTERED ([epid], [domainid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [amepdef_idx_01] ON [dbo].[amepdef] ([policy_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[amepdef] TO [ams_group]
GRANT SELECT ON  [dbo].[amepdef] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[amepdef] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[amepdef] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[amepdef] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[amepdef] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[amepdef] TO [upmuser_group]
GO