CREATE TABLE [dbo].[tng_class_ext]
(
[class_id] [int] NOT NULL,
[name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[datatype] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[length] [int] NOT NULL,
[property_group] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[string] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.tng_ti_class_prop    Script Date: 12/1/2005 11:50:57 PM ******/


CREATE trigger tng_ti_class_prop on tng_class_ext FOR INSERT AS
set nocount on
declare @timestamp datetime
  if not exists (select * from inserted )
    return
  insert into tng_change_history ( operation, class_name, object_id1, portnum1,  portnum2,    timestamp,user_name )
                         select         'C',   b.name,  0,         0,         0, getdate(),HOST_NAME()
                         from inserted a, tng_class b
                            where a.class_id = b.class_id
GO
/****** Object:  Trigger dbo.tng_tu_class_prop    Script Date: 12/1/2005 11:50:58 PM ******/


CREATE trigger tng_tu_class_prop on tng_class_ext FOR UPDATE AS
set nocount on
declare @timestamp datetime
  if not exists (select * from deleted )
    return
  insert into tng_change_history ( operation, class_name, object_id1, portnum1,  portnum2,    timestamp,user_name )
                         select         'U',   b.name,  0,         0,         0, getdate(),HOST_NAME()
                         from inserted a, tng_class b
                            where a.class_id = b.class_id
GO
ALTER TABLE [dbo].[tng_class_ext] ADD CONSTRAINT [PK__tng_class_ext__3FF13F11] PRIMARY KEY CLUSTERED ([class_id], [name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tng_class_ext] ADD CONSTRAINT [FK__tng_class__class__4A0FA628] FOREIGN KEY ([class_id]) REFERENCES [dbo].[tng_class] ([class_id])
GO
GRANT SELECT ON  [dbo].[tng_class_ext] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[tng_class_ext] TO [dscadmin]
GRANT SELECT ON  [dbo].[tng_class_ext] TO [dscuser]
GRANT SELECT ON  [dbo].[tng_class_ext] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_class_ext] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_class_ext] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_class_ext] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_class_ext] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_class_ext] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_class_ext] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_class_ext] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_class_ext] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_class_ext] TO [wvuser]
GO