CREATE TABLE [dbo].[tng_field_definition]
(
[field_id] [int] NULL CONSTRAINT [DF__tng_field__field__5D0CA0AC] DEFAULT ((0)),
[field_type] [int] NULL CONSTRAINT [DF__tng_field__field__5E00C4E5] DEFAULT ((0)),
[field_flags] [int] NULL CONSTRAINT [DF__tng_field__field__5EF4E91E] DEFAULT ((0)),
[name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field___name__5FE90D57] DEFAULT (''),
[data_length] [int] NULL CONSTRAINT [DF__tng_field__data___60DD3190] DEFAULT ((0)),
[instance_storage] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field__insta__61D155C9] DEFAULT (''),
[storage_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__tng_field__stora__62C57A02] DEFAULT (''),
[last_int] [int] NULL CONSTRAINT [DF__tng_field__last___63B99E3B] DEFAULT ((0)),
[last_char] [int] NULL CONSTRAINT [DF__tng_field__last___64ADC274] DEFAULT ((0))
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_tng_field_definition] ON [dbo].[tng_field_definition] ([field_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_field_definition] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_field_definition] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_field_definition] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_field_definition] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_field_definition] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_field_definition] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_field_definition] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_field_definition] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_field_definition] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_field_definition] TO [wvuser]
GO