CREATE TABLE [dbo].[usd_target]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL CONSTRAINT [DF__usd_targe__versi__595C0B59] DEFAULT ((1)),
[managementtype] [int] NOT NULL CONSTRAINT [DF__usd_targe__manag__5A502F92] DEFAULT ((1)),
[state] [int] NOT NULL CONSTRAINT [DF__usd_targe__state__5B4453CB] DEFAULT ((0)),
[calendar] [nvarchar] (33) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__usd_targe__calen__5C387804] DEFAULT (' '),
[download_method] [int] NOT NULL CONSTRAINT [DF__usd_targe__downl__5D2C9C3D] DEFAULT ((0)),
[locks] [int] NOT NULL CONSTRAINT [DF__usd_targe__locks__5E20C076] DEFAULT ((0))
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.usd_trg_d_target_ag_comp    Script Date: 12/1/2005 11:50:47 PM ******/
CREATE trigger usd_trg_d_target_ag_comp
on usd_target
for delete as
begin
    /* Delete agent components */
    delete from ca_agent_component
    from deleted d
    where object_uuid = d.objectid
    and (agent_comp_id = 40 or agent_comp_id = 46)
end
GO
CREATE  trigger usd_trg_u_usd_target_status
on usd_target
for update as
begin
    if update(locks)
    begin
        /* Remove some bits that we do not want */
        update ca_agent set derived_status_sd = vts.object_status
        from inserted, usd_v_target_status vts
        where ca_agent.object_uuid = inserted.objectid
        and inserted.objectid = vts.object_uuid
    end
end
GO
ALTER TABLE [dbo].[usd_target] ADD CONSTRAINT [XPKusd_target] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_target] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_target] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_target] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_target] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_target] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_target] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_target] TO [upmuser_group]
GO