CREATE TABLE [dbo].[tng_class]
(
[class_id] [int] NOT NULL IDENTITY(0, 1),
[name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[super_class_id] [int] NOT NULL,
[super_class_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[virtual_class] [tinyint] NOT NULL,
[map_visible] [tinyint] NOT NULL,
[vr_visible] [tinyint] NOT NULL,
[system_class] [tinyint] NOT NULL,
[hidden_class] [tinyint] NOT NULL,
[instance_storage] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.tng_td_class    Script Date: 12/1/2005 11:50:40 PM ******/

CREATE trigger tng_td_class on tng_class FOR DELETE AS
set nocount on

if not exists (select * from deleted )
    return

  insert into tng_change_history ( operation, class_name, object_id1, portnum1,  portnum2,    timestamp,user_name )
                         select         'D',   name,  0,         0,         0, getdate(),HOST_NAME()
                         from deleted
  
  return
GO
/****** Object:  Trigger dbo.tng_ti_class    Script Date: 12/1/2005 11:50:42 PM ******/


/* Insert trigger when a class is created*/


CREATE trigger tng_ti_class on tng_class 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         'I',   name,  0,         0,         0, getdate(),HOST_NAME()
                         from inserted


  return
GO
ALTER TABLE [dbo].[tng_class] ADD CONSTRAINT [PK__tng_class__0C86A9A4] PRIMARY KEY CLUSTERED ([class_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [x_tng_name] ON [dbo].[tng_class] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_class] TO [dscadmin]
GRANT SELECT ON  [dbo].[tng_class] TO [dscuser]
GRANT SELECT ON  [dbo].[tng_class] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_class] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_class] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_class] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_class] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_class] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_class] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_class] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_class] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_class] TO [wvuser]
GO