CREATE TABLE [dbo].[am_external_device]
(
[device_uuid] [binary] (16) NOT NULL,
[domain_uuid] [binary] (16) NOT NULL,
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ipaddress] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[macaddress] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[auto_rep_version] [timestamp] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__am_extern__versi__0A9D95DB] DEFAULT ((0)),
[creation_date] [int] NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.r_d_so_removed_external_device    Script Date: 12/1/2005 11:50:49 PM ******/

    



/*
*********************************************************
*********************************************************
* Procedures and rules to manage OLS for external devices
*********************************************************
*********************************************************
*/



/*
*********************************************
trigger for deleting a external device object
*/
CREATE trigger r_d_so_removed_external_device
       on am_external_device
       after delete
as
begin
    declare @ddis_hw_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select device_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.r_i_so_new_external_device    Script Date: 12/1/2005 11:51:22 PM ******/

/*
*********************************************
trigger for creating a external device object
*/
CREATE trigger r_i_so_new_external_device
on am_external_device
after insert
as
begin
  declare @_obj_uuid binary(16);
  declare @_clsid integer;
  declare @_uri nvarchar(255);
    
    select @_obj_uuid = (select device_uuid from inserted);
    select @_clsid = 1012;
    select @_uri = (select creation_user from inserted);
    
    execute  proc_i_new_so_object @_obj_uuid, @_clsid, @_uri;
    
end;
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_am_external_device] ON [dbo].[am_external_device] ([device_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[am_external_device] TO [ams_group]
GRANT SELECT ON  [dbo].[am_external_device] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[am_external_device] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[am_external_device] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[am_external_device] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[am_external_device] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[am_external_device] TO [upmuser_group]
GO