CREATE TABLE [dbo].[asmo_rpt]
(
[msg_id] [int] NOT NULL,
[platform_id] [int] NOT NULL,
[event_id] [int] NOT NULL,
[date_time] [datetime] NOT NULL,
[object_id] [int] NOT NULL,
[config_file] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__asmo_rpt__config__1758727B] DEFAULT (NULL),
[old_state_id] [int] NOT NULL,
[new_state_id] [int] NULL CONSTRAINT [DF__asmo_rpt__new_st__184C96B4] DEFAULT (NULL),
[old_value] [float] NULL CONSTRAINT [DF__asmo_rpt__old_va__1940BAED] DEFAULT ((0)),
[new_value] [float] NULL CONSTRAINT [DF__asmo_rpt__new_va__1A34DF26] DEFAULT ((0)),
[source_location] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[target_location] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__asmo_rpt__target__1B29035F] DEFAULT (NULL)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asmo_rpt] ADD CONSTRAINT [XPKasmo_rpt] PRIMARY KEY CLUSTERED ([msg_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asmo_rpt] ADD CONSTRAINT [eventfk] FOREIGN KEY ([event_id]) REFERENCES [dbo].[asmo_event] ([event_id])
GO
ALTER TABLE [dbo].[asmo_rpt] ADD CONSTRAINT [newstatefk] FOREIGN KEY ([new_state_id]) REFERENCES [dbo].[asmo_state] ([state_id])
GO
ALTER TABLE [dbo].[asmo_rpt] ADD CONSTRAINT [objectfk] FOREIGN KEY ([object_id]) REFERENCES [dbo].[asmo_object] ([object_id])
GO
ALTER TABLE [dbo].[asmo_rpt] ADD CONSTRAINT [oldstatefk] FOREIGN KEY ([old_state_id]) REFERENCES [dbo].[asmo_state] ([state_id])
GO
ALTER TABLE [dbo].[asmo_rpt] ADD CONSTRAINT [platformfk] FOREIGN KEY ([platform_id]) REFERENCES [dbo].[asmo_platform] ([platform_id])
GO
GRANT SELECT ON  [dbo].[asmo_rpt] TO [asmoadmin]
GRANT INSERT ON  [dbo].[asmo_rpt] TO [asmoadmin]
GRANT DELETE ON  [dbo].[asmo_rpt] TO [asmoadmin]
GRANT UPDATE ON  [dbo].[asmo_rpt] TO [asmoadmin]
GRANT SELECT ON  [dbo].[asmo_rpt] TO [asmouser]
GO