CREATE TABLE [dbo].[asset_group]
(
[asset_group_id] [binary] (16) NOT NULL,
[name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[is_default] [tinyint] NULL,
[protection_level_id] [binary] (16) NOT NULL,
[partial_host_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[beginning_ip_address] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ending_ip_address] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[unit_id] [binary] (16) NULL,
[is_allowed_to_use_auto_inv] [tinyint] NULL,
[configuration_standard_set_id] [binary] (16) NULL,
[config_standard_set_id] [binary] (16) NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_group] ADD CONSTRAINT [XPKasset_group] PRIMARY KEY CLUSTERED ([asset_group_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2asset_group] ON [dbo].[asset_group] ([config_standard_set_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1asset_group] ON [dbo].[asset_group] ([protection_level_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_group] ADD CONSTRAINT [$asset_r00001c8900000000] FOREIGN KEY ([config_standard_set_id]) REFERENCES [dbo].[configuration_standard_set] ([config_standard_set_id])
GO
ALTER TABLE [dbo].[asset_group] ADD CONSTRAINT [$asset_r00001c9200000000] FOREIGN KEY ([protection_level_id]) REFERENCES [dbo].[protection_level] ([protection_level_id])
GO