CREATE TABLE [dbo].[tng_property_definition]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[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,
[is_key] [tinyint] NOT NULL,
[required] [tinyint] NOT NULL,
[readonly] [tinyint] NULL,
[default_value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[instance_storage] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[storage_field] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[property_group] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_data] [int] NULL,
[override] [int] NULL,
[method_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.tng_tu_class_instance    Script Date: 12/1/2005 11:50:58 PM ******/

CREATE trigger tng_tu_class_instance on tng_property_definition 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         'U',   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_prop_instance    Script Date: 12/1/2005 11:50:59 PM ******/

CREATE trigger tng_tu_prop_instance on tng_property_definition 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_property_definition] ADD CONSTRAINT [PK__tng_property_def__68143F04] PRIMARY KEY CLUSTERED ([id], [class_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [x_tng_prop_def_class_id_name] ON [dbo].[tng_property_definition] ([class_id], [name]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [x_tng_prop_def_id] ON [dbo].[tng_property_definition] ([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tng_property_definition] ADD CONSTRAINT [FK__tng_prope__class__4B03CA61] FOREIGN KEY ([class_id]) REFERENCES [dbo].[tng_class] ([class_id])
GO
GRANT SELECT ON  [dbo].[tng_property_definition] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_property_definition] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_property_definition] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_property_definition] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_property_definition] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_property_definition] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_property_definition] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_property_definition] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_property_definition] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_property_definition] TO [wvuser]
GO