CREATE TABLE [dbo].[wsm_device_relationship]
(
[device_id_sidea] [binary] (16) NOT NULL,
[device_id_sideb] [binary] (16) NOT NULL,
[model_uuid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_device_relationship] ADD CONSTRAINT [XPKwsm_device_relationship] PRIMARY KEY CLUSTERED ([device_id_sidea], [device_id_sideb]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_device_relationship] ON [dbo].[wsm_device_relationship] ([device_id_sidea]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_device_relationship] ON [dbo].[wsm_device_relationship] ([device_id_sideb]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3wsm_device_relationship] ON [dbo].[wsm_device_relationship] ([model_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_device_relationship] ADD CONSTRAINT [$wsm_d_r00004a7e00000000] FOREIGN KEY ([device_id_sideb]) REFERENCES [dbo].[wsm_device] ([device_id])
GO
ALTER TABLE [dbo].[wsm_device_relationship] ADD CONSTRAINT [$wsm_d_r00004a8800000000] FOREIGN KEY ([device_id_sidea]) REFERENCES [dbo].[wsm_device] ([device_id])
GO
GRANT SELECT ON  [dbo].[wsm_device_relationship] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_device_relationship] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_device_relationship] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_device_relationship] TO [wsm_admin_group]
GRANT SELECT ON  [dbo].[wsm_device_relationship] TO [wsm_ro_group]
GO