CREATE TABLE [dbo].[gla_sdamaps]
(
[agent_id] [int] NOT NULL,
[scan_index] [int] NOT NULL,
[scan_name] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[scan_display_name] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[group_display_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[scan_type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[run_status] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[force_collect] [int] NOT NULL,
[request_collect] [int] NOT NULL,
[collector] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[integer_to_collect] [int] NOT NULL CONSTRAINT [DF__gla_sdama__integ__6F556E19] DEFAULT ((0)),
[last_collect] [int] NULL
) ON [PRIMARY]
GO

/****** Object:  Trigger dbo.TD_GLA_SDAMAPS    Script Date: 12/1/2005 11:51:07 PM ******/

CREATE TRIGGER TD_GLA_SDAMAPS ON GLA_SDAMAPS AFTER DELETE
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 DELETE gla_sdamaps because gla_objects exists.', 16, 1)
END


GO

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


CREATE TRIGGER TI_GLA_SDAMAPS ON GLA_SDAMAPS AFTER INSERT
AS
declare @numrows INTEGER
select @numrows = count(*)
   from GLA_AGENTS
   where agent_id = gla_agents.agent_id;
IF @numrows = 0
BEGIN
   RAISERROR ('Cannot INSERT gla_sdamaps because gla_agents does not exist.', 16, 1)
END


GO
ALTER TABLE [dbo].[gla_sdamaps] ADD CONSTRAINT [$gla_s_u000019c100000000] PRIMARY KEY CLUSTERED ([scan_index], [agent_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif49gla_sdamaps] ON [dbo].[gla_sdamaps] ([agent_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[gla_sdamaps] ADD CONSTRAINT [$gla_s_r000019db00000000] FOREIGN KEY ([agent_id]) REFERENCES [dbo].[gla_agents] ([agent_id])
GO