CREATE TABLE [dbo].[usd_cont]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[overallstatus] [int] NOT NULL,
[sendid] [binary] (16) NOT NULL,
[containerpath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[distlistpath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[distlisttype] [int] NOT NULL,
[distdate] [int] NOT NULL,
[disttime] [int] NOT NULL,
[credate] [int] NOT NULL,
[cretime] [int] NOT NULL,
[ahdinfo] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[priority] [int] NOT NULL CONSTRAINT [DF__usd_cont__priori__0D917324] DEFAULT ((5))
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_i_del_so_usd_container    Script Date: 12/1/2005 11:50:54 PM ******/




/*
*********************************************
trigger for a USD container
*/
CREATE trigger rule_i_del_so_usd_container
     on usd_cont
     after delete
as
begin
    declare @ddis_hw_uuid binary(16);

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






/*
*********************************************************
*********************************************************
* Procedures and rules to manage USD container
*********************************************************
*********************************************************
*/


/*
*********************************************
trigger for inserting a new USD container
*/
CREATE trigger rule_i_new_so_usd_container
     on usd_cont
     after insert
as
begin
  declare @_obj_uuid binary(16);
  declare @_clsid integer;
  declare @_uri nvarchar(255);

      select @_obj_uuid = (select objectid from inserted);
      select @_clsid = 2008;
      select @_uri = (select creation_user from inserted);


    execute   proc_i_new_so_object @_obj_uuid, @_clsid, @_uri;
    
end;
GO
ALTER TABLE [dbo].[usd_cont] ADD CONSTRAINT [XPKusd_cont] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [usd_cont_name_unique] ON [dbo].[usd_cont] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_cont] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_cont] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_cont] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_cont] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_cont] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_cont] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_cont] TO [upmuser_group]
GO