CREATE TABLE [dbo].[m2ipstats]
(
[server_addr] [int] NULL,
[probe_addr] [int] NULL,
[intervaldatetime] [datetime] NULL,
[intervalduration] [int] NULL,
[ipforwarding] [int] NULL,
[ipdefaultttl] [int] NULL,
[ipinreceives] [float] NULL,
[ipinhdrerrors] [float] NULL,
[ipinaddrerrors] [float] NULL,
[ipforwdatagrams] [float] NULL,
[ipinunknownprotos] [float] NULL,
[ipindiscards] [float] NULL,
[ipindelivers] [float] NULL,
[ipoutrequests] [float] NULL,
[ipoutdiscards] [float] NULL,
[ipoutnoroutes] [float] NULL,
[ipreasmtimeout] [float] NULL,
[ipreasmreqds] [float] NULL,
[ipreasmoks] [float] NULL,
[ipreasmfails] [float] NULL,
[ipfragoks] [float] NULL,
[ipfragfails] [float] NULL,
[ipfragcreates] [float] NULL,
[iproutingdiscards] [float] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [m2ipstatstime] ON [dbo].[m2ipstats] ([intervaldatetime]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_m2ipstats] ON [dbo].[m2ipstats] ([probe_addr], [intervaldatetime]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[m2ipstats] TO [uniadmin]
GRANT INSERT ON  [dbo].[m2ipstats] TO [uniadmin]
GRANT DELETE ON  [dbo].[m2ipstats] TO [uniadmin]
GRANT UPDATE ON  [dbo].[m2ipstats] TO [uniadmin]
GRANT SELECT ON  [dbo].[m2ipstats] TO [uniuser]
GO