CREATE TABLE [dbo].[ca_directory_details]
(
[directory_uuid] [binary] (16) NOT NULL,
[directory_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[server_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[port_number] [int] NULL,
[binding] [int] NULL,
[user_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[password] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[base_dn] [nvarchar] (1023) COLLATE SQL_Latin1_General_CP1_CS_AS 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,
[version_number] [int] NULL CONSTRAINT [DF__ca_direct__versi__0C70CFB4] DEFAULT ((0)),
[directory_type] [int] NULL,
[dir_authorities] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dir_user_search_filter] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dir_hardware_search_filter] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dir_macros] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.r_del_directory_details    Script Date: 12/1/2005 11:51:05 PM ******/

/*
***********************************************
trigger on delete on ca_directory_details
*/
CREATE trigger r_del_directory_details
    on ca_directory_details
    after delete
as
    declare @old_directory_uuid as binary(16);
begin

    DECLARE mycur CURSOR
        FOR select directory_uuid from deleted

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

        execute  p_integrity_d_directory_details @old_directory_uuid ;
        FETCH NEXT FROM mycur INTO @old_directory_uuid;

    END

    CLOSE mycur
    DEALLOCATE mycur

end
GO
ALTER TABLE [dbo].[ca_directory_details] ADD CONSTRAINT [XPKca_directory_details] PRIMARY KEY CLUSTERED ([directory_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_directory_details] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_directory_details] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_directory_details] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_directory_details] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_directory_details] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_directory_details] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_directory_details] TO [upmuser_group]
GO