CREATE TABLE [dbo].[bgp4peerentrymessage]
(
[server_addr] [int] NOT NULL,
[probe_addr] [int] NOT NULL,
[bgpidentifier] [int] NOT NULL,
[bgppeeridentifier] [int] NOT NULL,
[intervaldatetime] [datetime] NOT NULL,
[intervalduration] [int] NOT NULL,
[bgppeerstate] [int] NOT NULL,
[bgppeeradminstatus] [int] NOT NULL,
[bgppeerinupdates] [int] NOT NULL,
[bgppeeroutupdates] [int] NOT NULL,
[bgppeerintotalmessages] [int] NOT NULL,
[bgppeerouttotalmessages] [int] NOT NULL,
[bgppeerlasterror] [int] NOT NULL,
[bgppeerfsmestablishedtrans] [int] NOT NULL,
[bgppeerfsmestablishedtime] [int] NOT NULL,
[bgppeerholdtime] [int] NOT NULL,
[bgppeerkeepalive] [int] NOT NULL,
[bgppeerinupdateelapsedtime] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_bgp4peerentrymessage] ON [dbo].[bgp4peerentrymessage] ([bgpidentifier], [bgppeeridentifier]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[bgp4peerentrymessage] TO [uniadmin]
GRANT INSERT ON  [dbo].[bgp4peerentrymessage] TO [uniadmin]
GRANT DELETE ON  [dbo].[bgp4peerentrymessage] TO [uniadmin]
GRANT UPDATE ON  [dbo].[bgp4peerentrymessage] TO [uniadmin]
GRANT SELECT ON  [dbo].[bgp4peerentrymessage] TO [uniuser]
GO