CREATE TABLE [dbo].[wsm_agent]
(
[agent_uuid] [binary] (16) NOT NULL,
[manager_uuid] [binary] (16) NOT NULL,
[agent_key] [varbinary] (1024) NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creation_date] [int] NOT NULL,
[last_update_date] [int] NOT NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[provision_status] [int] NOT NULL,
[version] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[current_user_uuid] [binary] (16) NOT NULL,
[device_id] [binary] (16) NOT NULL,
[locale_code] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_zone_code] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[agent_status_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [XPKwsm_agent] PRIMARY KEY CLUSTERED ([agent_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif6wsm_agent] ON [dbo].[wsm_agent] ([agent_status_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_agent] ON [dbo].[wsm_agent] ([current_user_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3wsm_agent] ON [dbo].[wsm_agent] ([device_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xwsm_agent] ON [dbo].[wsm_agent] ([device_id], [agent_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif4wsm_agent] ON [dbo].[wsm_agent] ([locale_code]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_agent] ON [dbo].[wsm_agent] ([manager_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif5wsm_agent] ON [dbo].[wsm_agent] ([time_zone_code]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [r_1464] FOREIGN KEY ([manager_uuid]) REFERENCES [dbo].[wsm_engine] ([manager_uuid])
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [r_1466] FOREIGN KEY ([current_user_uuid]) REFERENCES [dbo].[wsm_user] ([user_uuid])
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [r_1467] FOREIGN KEY ([device_id]) REFERENCES [dbo].[wsm_device] ([device_id])
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [r_1487] FOREIGN KEY ([locale_code]) REFERENCES [dbo].[ca_locale] ([locale_code])
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [r_1488] FOREIGN KEY ([time_zone_code]) REFERENCES [dbo].[ca_time_zone] ([time_zone_code])
GO
ALTER TABLE [dbo].[wsm_agent] ADD CONSTRAINT [r_1510] FOREIGN KEY ([agent_status_id]) REFERENCES [dbo].[wsm_status_definition] ([status_id])
GO
GRANT SELECT ON  [dbo].[wsm_agent] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_agent] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_agent] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_agent] TO [wsm_admin_group]
GRANT SELECT ON  [dbo].[wsm_agent] TO [wsm_ro_group]
GO