CREATE TABLE [dbo].[gla_hours]
(
[obj_id] [int] NOT NULL,
[timestamp] [int] NOT NULL,
[num_val] [float] NULL,
[text_val] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Trigger dbo.TI_GLA_HOURS    Script Date: 12/1/2005 11:51:10 PM ******/


/****************************************************************************************/
/*  Change Control                                                                      */
/*                                                                                      */
/*  Change Date Changes By  Version                                                     */
/*  =========== ==========  =======                                                     */
/*  16-sep-2005 hopst01     Star 14391939 Unicenter DAS triggers                         */
/*                                                                                      */
/****************************************************************************************/

CREATE TRIGGER TI_GLA_HOURS ON GLA_HOURS AFTER INSERT
AS
declare @numrows INTEGER
select @numrows = count(*)
   from GLA_OBJECTS
   where obj_id = gla_objects.obj_id
IF @numrows = 0
BEGIN
   RAISERROR ('Cannot INSERT gla_hours because gla_objects does not exist.', 16, 1)
END


GO

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

CREATE TRIGGER TU_GLA_HOURS ON GLA_HOURS AFTER UPDATE
AS
declare @numrows INTEGER
select @numrows = count(*)
   from GLA_OBJECTS
   where obj_id = gla_objects.obj_id
IF @numrows = 0
BEGIN
   RAISERROR ('Cannot INSERT gla_hours because gla_objects does not exist.', 16, 1)
END


GO
ALTER TABLE [dbo].[gla_hours] ADD CONSTRAINT [$gla_h_u000019b900000000] PRIMARY KEY CLUSTERED ([obj_id], [timestamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif57_gla_hours] ON [dbo].[gla_hours] ([obj_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[gla_hours] ADD CONSTRAINT [$gla_h_r000019c700000000] FOREIGN KEY ([obj_id]) REFERENCES [dbo].[gla_objects] ([obj_id])
GO