CREATE TABLE [dbo].[ai_oldef_prop]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[office] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hwname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hwmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwdom] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwsource] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwproctype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwbiosmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwtype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwprocspeed] [int] NULL,
[hwproccount] [int] NULL,
[hwprocmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwsn] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmem] [int] NULL,
[fssize] [float] NULL,
[fsfree] [float] NULL,
[osname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[oslanguage] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ossp] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ospub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[instdate] [datetime] NOT NULL,
[lscandate] [datetime] NOT NULL,
[userid] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[region] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[orgnm] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwuse] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user1] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user2] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user3] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[user4] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_oldef_prop] ADD CONSTRAINT [PK_ai_oldef_prop] PRIMARY KEY NONCLUSTERED ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_hwdom] ON [dbo].[ai_oldef_prop] ([hwdom]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_hwmodel] ON [dbo].[ai_oldef_prop] ([hwmodel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_hwprocmodel] ON [dbo].[ai_oldef_prop] ([hwprocmodel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_hwproctype] ON [dbo].[ai_oldef_prop] ([hwproctype]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_hwsource] ON [dbo].[ai_oldef_prop] ([hwsource]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_hwuse] ON [dbo].[ai_oldef_prop] ([hwuse]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_ai_oldef_prop_hwuuid] ON [dbo].[ai_oldef_prop] ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_office] ON [dbo].[ai_oldef_prop] ([office]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_orgnm] ON [dbo].[ai_oldef_prop] ([orgnm]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_region] ON [dbo].[ai_oldef_prop] ([region]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ai_oldef_prop_userid] ON [dbo].[ai_oldef_prop] ([userid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_oldef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_oldef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_oldef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_oldef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_oldef_prop] TO [aipublic]
GO