CREATE TABLE [dbo].[ciscostats]
(
[server_addr] [int] NULL,
[probe_addr] [int] NULL,
[intervaldatetime] [datetime] NULL,
[intervalduration] [int] NULL,
[freemem] [float] NULL,
[bufferelfree] [int] NULL,
[bufferelmax] [int] NULL,
[bufferelhit] [float] NULL,
[bufferelmiss] [float] NULL,
[bufferelcreate] [float] NULL,
[buffersmtotal] [int] NULL,
[buffersmhit] [float] NULL,
[buffersmmiss] [float] NULL,
[buffermdtotal] [int] NULL,
[buffermdhit] [float] NULL,
[buffermdmiss] [float] NULL,
[bufferbgtotal] [int] NULL,
[bufferbghit] [float] NULL,
[bufferbgmiss] [float] NULL,
[bufferlgtotal] [int] NULL,
[bufferlghit] [float] NULL,
[bufferlgmiss] [float] NULL,
[bufferfail] [float] NULL,
[buffernomem] [float] NULL,
[avgbusy1] [tinyint] NULL,
[avgbusy5] [tinyint] NULL,
[bufferhgtotal] [int] NULL,
[bufferhghit] [float] NULL,
[bufferhgmiss] [float] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ciscostatstime] ON [dbo].[ciscostats] ([intervaldatetime]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_ciscostats] ON [dbo].[ciscostats] ([probe_addr], [intervaldatetime]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ciscostats] TO [uniadmin]
GRANT INSERT ON  [dbo].[ciscostats] TO [uniadmin]
GRANT DELETE ON  [dbo].[ciscostats] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ciscostats] TO [uniadmin]
GRANT SELECT ON  [dbo].[ciscostats] TO [uniuser]
GO