CREATE TABLE [dbo].[bckdef]
(
[domainid] [int] NOT NULL,
[bckid] [int] NOT NULL,
[dbname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[filename] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[version] [int] NULL,
[bckflag] [int] NULL,
[editor] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[revnr] [int] NULL,
[auto_server_version] [int] NULL CONSTRAINT [DF__bckdef__auto_ser__20ACD28B] DEFAULT ((0)),
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.bckdef_update    Script Date: 12/1/2005 11:50:47 PM ******/

/*
************************************
* after update(BCKID,DOMAINID,DBNAME,FILENAME,VERSION,BCKFLAG,EDITOR,REVNR)
*/
CREATE trigger bckdef_update
   on bckdef
   after update
  

as
if UPDATE(BCKID) or UPDATE(DOMAINID) or UPDATE(DBNAME) or UPDATE(FILENAME) or UPDATE(VERSION) or UPDATE(BCKFLAG) or UPDATE(EDITOR) or UPDATE(REVNR)
begin
    declare @domainid int,@bckid int ;
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT domainid,bckid
            FROM inserted
            
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @domainid,@bckid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute bckdef_server_version @domainid,@bckid
        FETCH NEXT FROM trans_Cursor INTO @domainid,@bckid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
      
end
GO
ALTER TABLE [dbo].[bckdef] ADD CONSTRAINT [XPKbckdef] PRIMARY KEY CLUSTERED ([bckid], [domainid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [bckdef_sk1] ON [dbo].[bckdef] ([dbname]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[bckdef] TO [ams_group]
GRANT SELECT ON  [dbo].[bckdef] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[bckdef] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[bckdef] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[bckdef] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[bckdef] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[bckdef] TO [upmuser_group]
GO