CREATE TABLE [dbo].[gla_agents]
(
[agent_id] [int] NOT NULL,
[agent_type] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[agent_name] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[agent_version] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[rtserver] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO

/****** Object:  Trigger dbo.TD_GLA_AGENTS    Script Date: 12/1/2005 11:50:57 PM ******/

CREATE TRIGGER TD_GLA_AGENTS ON GLA_AGENTS AFTER DELETE
AS
declare @numrows INTEGER
select @numrows = count(*)
   from GLA_SDAMAPS
   where agent_id = gla_sdamaps.agent_id;
IF @numrows > 0
BEGIN
   RAISERROR ('Cannot DELETE gla_agents because gla_sdamaps exists.', 16, 1)
END


GO

/****** Object:  Trigger dbo.TU_GLA_AGENTS    Script Date: 12/1/2005 11:50:59 PM ******/

CREATE TRIGGER TU_GLA_AGENTS ON GLA_AGENTS AFTER UPDATE
AS
declare @numrows INTEGER
select @numrows = count(*)
   from GLA_SDAMAPS
   where agent_id = gla_sdamaps.agent_id;
IF @numrows > 0
BEGIN
   RAISERROR ('Cannot UPDATE gla_agents because gla_sdamaps exists.', 16, 1)
END


GO

/****** Object:  Trigger dbo.TU_GLA_SDAMAPS    Script Date: 12/1/2005 11:51:08 PM ******/


CREATE TRIGGER TU_GLA_SDAMAPS ON GLA_AGENTS AFTER UPDATE
AS
declare @numrows INTEGER
select @numrows = count(*)
   from GLA_OBJECTS
   where
        gla_objects.scan_index = scan_index and
        gla_objects.agent_id = agent_id
IF @numrows > 0
BEGIN
   RAISERROR ('Cannot UPDATE gla_sdamaps because gla_objects exists.', 16, 1)
END

select @numrows = count(*)
   from GLA_AGENTS
   where agent_id = gla_agents.agent_id
IF @numrows = 0
BEGIN
   RAISERROR ('Cannot UPDATE gla_sdamaps because gla_agents does not exist.', 16, 1)
END


GO
ALTER TABLE [dbo].[gla_agents] ADD CONSTRAINT [$gla_a_u000019c400000000] PRIMARY KEY CLUSTERED ([agent_id]) ON [PRIMARY]
GO