CREATE TABLE [dbo].[ncmodcfg]
(
[domainid] [int] NOT NULL,
[moid] [int] NOT NULL,
[moname] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[mocont] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mocmd] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[moos] [int] NULL,
[motype] [int] NOT NULL,
[mocreate] [int] NULL,
[momodify] [int] NULL,
[mosdate] [int] NULL,
[mostime] [int] NULL,
[moedate] [int] NULL,
[moetime] [int] NULL,
[mofreq] [int] NULL,
[mosched] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[moinst] [int] NULL,
[moonceat] [int] NULL,
[mooncenr] [int] NULL,
[moflag] [int] NULL,
[jdmodid] [int] NULL,
[modepend] [int] NULL,
[moquest] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[moqforce] [int] NULL,
[moqfdate] [int] NULL,
[mologoff] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[moremove] [int] NULL,
[modepfil] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[modevice] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[moserv] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[modiscon] [int] NULL,
[mopartnr] [int] NULL,
[revnr] [int] NULL,
[userid] [int] NULL,
[checksum] [int] NULL,
[auto_server_version] [int] NULL CONSTRAINT [DF__ncmodcfg__auto_s__60F24029] DEFAULT ((0)),
[auto_rep_version] [timestamp] NULL,
[job_category] [int] NULL,
[module_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
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Trigger dbo.ncmodcfg_update    Script Date: 12/1/2005 11:50:48 PM ******/



/*
************************************
* after update(DOMAINID,MOID,MOTYPE,MONAME,MOCONT,MOCMD,MOOS,MOCREATE,
* MOMODIFY,MOSDATE,MOEDATE,MOETIME,MOFREQ,MOSCHED,MOINST,MOSTIME,MOONCEAT,
* MOONCENR,MOFLAG,JDMODID,MODEPEND,MOQUEST,MOQFORCE,MOQFDATE,MOLOGOFF,
* MOREMOVE,MODEPFIL,MODEVICE,MOSERV,MODISCON,MOPARTNR,REVNR,USERID,CHECKSUM)
*/

CREATE trigger ncmodcfg_update
     on ncmodcfg
    after update
    
as
if UPDATE(DOMAINID) or UPDATE(MOID) or UPDATE(MOTYPE) or UPDATE(MONAME) or UPDATE(MOCONT) or UPDATE(MOCMD) or UPDATE(MOOS) or UPDATE(MOCREATE) or UPDATE(MOMODIFY) or UPDATE(MOSDATE) or UPDATE(
        MOEDATE) or UPDATE(MOETIME) or UPDATE(MOFREQ) or UPDATE(MOSCHED) or UPDATE(MOINST) or UPDATE(MOSTIME) or UPDATE(MOONCEAT) or UPDATE(MOONCENR) or UPDATE(MOFLAG) or UPDATE(JDMODID) or UPDATE(
        MODEPEND) or UPDATE(MOQUEST) or UPDATE(MOQFORCE) or UPDATE(MOQFDATE) or UPDATE(MOLOGOFF) or UPDATE(MOREMOVE) or UPDATE(MODEPFIL) or UPDATE(MODEVICE) or UPDATE(MOSERV) or UPDATE(
        MODISCON) or UPDATE(MOPARTNR) or UPDATE(REVNR) or UPDATE(USERID) or UPDATE(CHECKSUM)
begin
    declare @domainid int,@moid int ;
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT domainid,moid
            FROM inserted
            
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @domainid,@moid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ncmodcfg_server_version @domainid,@moid
        FETCH NEXT FROM trans_Cursor INTO @domainid,@moid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
      
end
GO
/****** Object:  Trigger dbo.rule_d_so_del_module    Script Date: 12/1/2005 11:50:52 PM ******/


/*
*********************************************
trigger for deleteing a  module object
*/
CREATE trigger rule_d_so_del_module
     on ncmodcfg
     after delete
as
begin
    declare @ddis_hw_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select module_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_module    Script Date: 12/1/2005 11:51:47 PM ******/



/*
*********************************************
trigger for creating  module object
*/
CREATE trigger rule_i_so_new_module
     on ncmodcfg
     after insert
as
begin
    declare @_obj_uuid binary(16);
    declare @_uri nvarchar(255);
    declare @_motype integer;


    select @_obj_uuid = (select module_uuid from inserted);
    select @_uri = (select creation_user from inserted);
    select @_motype = (select motype from inserted);


    execute  proc_i_so_new_module @_obj_uuid, @_uri, @_motype;
    
end;
GO
ALTER TABLE [dbo].[ncmodcfg] ADD CONSTRAINT [XPKncmodcfg] PRIMARY KEY CLUSTERED ([domainid], [moid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ncmodcfg_idx_01] ON [dbo].[ncmodcfg] ([module_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ncmodcfg] TO [ams_group]
GRANT SELECT ON  [dbo].[ncmodcfg] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ncmodcfg] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ncmodcfg] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ncmodcfg] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ncmodcfg] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ncmodcfg] TO [upmuser_group]
GO