CREATE TABLE [dbo].[wsm_model]
(
[model_uuid] [binary] (16) NOT NULL,
[parent_model_uuid] [binary] (16) NULL,
[model_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[nsm_class_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[model_version] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[device_type_id] [int] NULL,
[parent_class] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[is_abstract] [int] NULL,
[updatewv] [int] NOT NULL CONSTRAINT [DF__wsm_model__updat__69485A5F] DEFAULT ((1)),
[description] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manufacturer_uuid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_model] ADD CONSTRAINT [xpkwsm_supported_model] PRIMARY KEY CLUSTERED ([model_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_supported_model] ON [dbo].[wsm_model] ([device_type_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3wsm_model] ON [dbo].[wsm_model] ([manufacturer_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xwsm_model_key] ON [dbo].[wsm_model] ([model_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_model] ON [dbo].[wsm_model] ([parent_model_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_model] ADD CONSTRAINT [r_12] FOREIGN KEY ([device_type_id]) REFERENCES [dbo].[wsm_device_type] ([id])
GO
ALTER TABLE [dbo].[wsm_model] ADD CONSTRAINT [r_1506] FOREIGN KEY ([parent_model_uuid]) REFERENCES [dbo].[wsm_model] ([model_uuid])
GO
ALTER TABLE [dbo].[wsm_model] ADD CONSTRAINT [r_1508] FOREIGN KEY ([manufacturer_uuid]) REFERENCES [dbo].[ca_company] ([company_uuid])
GO
GRANT SELECT ON  [dbo].[wsm_model] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_model] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_model] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_model] TO [wsm_admin_group]
GRANT SELECT ON  [dbo].[wsm_model] TO [wsm_ro_group]
GO