CREATE TABLE [dbo].[nonavail]
(
[server_addr] [int] NULL,
[probe_addr] [int] NULL,
[ifindex] [int] NULL,
[start_down_time] [datetime] NULL,
[end_down_time] [datetime] NULL,
[state] [tinyint] NULL,
[sessionnumber] [int] NULL,
[time_period] [int] NULL,
[rsrctype] [tinyint] NULL,
[rsrcotherindex] [int] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_nonavail] ON [dbo].[nonavail] ([probe_addr], [ifindex], [rsrcotherindex]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[nonavail] TO [uniadmin]
GRANT INSERT ON [dbo].[nonavail] TO [uniadmin]
GRANT DELETE ON [dbo].[nonavail] TO [uniadmin]
GRANT UPDATE ON [dbo].[nonavail] TO [uniadmin]
GRANT SELECT ON [dbo].[nonavail] TO [uniuser]
GO
[dbo].[nonavail]
