CREATE TABLE [dbo].[nctpldef]
(
[domainid] [int] NOT NULL,
[tpid] [int] NOT NULL,
[tpname] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tpfname] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tpver] [int] NULL,
[tpuserid] [int] NULL,
[tpdesc] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auto_server_version] [int] NULL CONSTRAINT [DF__nctpldef__auto_s__6B6FCE9C] DEFAULT ('0'),
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Trigger dbo.nctpldef_update    Script Date: 12/1/2005 11:50:49 PM ******/




/*
**************************************
* after update(TPID,DOMAINID,TPNAME,TPFNAME,TPVER,TPUSERID,TPDESC)
*
*/
CREATE trigger nctpldef_update
    on nctpldef
    after update
    
as
if UPDATE(TPID) or UPDATE(DOMAINID) or UPDATE(TPNAME) or UPDATE(TPFNAME) or UPDATE(TPVER) or UPDATE(TPUSERID) or UPDATE(TPDESC)
begin
    declare @domainid int,@tpid int ;
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT domainid,tpid
            FROM inserted
            
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @domainid,@tpid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute nctpldef_server_version @domainid,@tpid
        FETCH NEXT FROM trans_Cursor INTO @domainid,@tpid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
      
end
GO
ALTER TABLE [dbo].[nctpldef] ADD CONSTRAINT [XPKnctpldef] PRIMARY KEY CLUSTERED ([tpid], [domainid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[nctpldef] TO [ams_group]
GRANT SELECT ON  [dbo].[nctpldef] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[nctpldef] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[nctpldef] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[nctpldef] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[nctpldef] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[nctpldef] TO [upmuser_group]
GO