[dbo].[configurationhighresult]
CREATE TABLE [dbo].[configurationhighresult]
(
[hwuuid] [char] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[predicted hwprocspeed] [float] NOT NULL,
[predicted hwmem] [float] NOT NULL,
[predicted fssize] [float] NOT NULL,
[zscore hwprocspeed] [float] NOT NULL,
[zscore hwmem] [float] NOT NULL,
[zscore fssize] [float] NOT NULL,
[zscore sum] [float] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[configurationhighresult] ADD CONSTRAINT [PK__configurationhig__6DD76BC5] PRIMARY KEY CLUSTERED ([hwuuid]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[configurationhighresult] TO [aiadmin]
GRANT INSERT ON [dbo].[configurationhighresult] TO [aiadmin]
GRANT DELETE ON [dbo].[configurationhighresult] TO [aiadmin]
GRANT UPDATE ON [dbo].[configurationhighresult] TO [aiadmin]
GRANT SELECT ON [dbo].[configurationhighresult] TO [aipublic]
GO
