CREATE TABLE [dbo].[ai_osdef_prop]
(
[osuuid] [uniqueidentifier] NOT NULL,
[ospub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_osdef___ospub__08E1CCA0] DEFAULT (' '),
[osname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[osver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_osdef___osver__09D5F0D9] DEFAULT (' '),
[osbuild] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_osdef___osbui__0ACA1512] DEFAULT (' '),
[ossp] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_osdef_p__ossp__0BBE394B] DEFAULT (' '),
[oslanguage] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_osdef___oslan__0CB25D84] DEFAULT (' '),
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[lactdate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_osdef_prop] ADD CONSTRAINT [ai_osdef_prop_pk] PRIMARY KEY CLUSTERED ([osuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_prop_ak4] ON [dbo].[ai_osdef_prop] ([osbuild]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_prop_ak6] ON [dbo].[ai_osdef_prop] ([oslanguage]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_prop_ak2] ON [dbo].[ai_osdef_prop] ([osname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_prop_ak1] ON [dbo].[ai_osdef_prop] ([ospub]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_prop_ak5] ON [dbo].[ai_osdef_prop] ([ossp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_osdef_prop_ak3] ON [dbo].[ai_osdef_prop] ([osver]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_osdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_osdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_osdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_osdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_osdef_prop] TO [aipublic]
GO