CREATE TABLE [dbo].[frs_svp]
(
[svpid] [int] NULL,
[address] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[retry] [int] NULL,
[ntype] [int] NULL,
[stats] [int] NULL,
[state] [int] NULL,
[benabled] [int] NULL,
[ndpi] [int] NULL,
[nppi] [int] NULL,
[strcopycommand] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strhostname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strusername] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strpassword] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strfilepath] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strtraphostaddress] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strcommunityname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[strcommunitynamewrite] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[frs_svp] ADD CONSTRAINT [XPKfrs_svp] PRIMARY KEY CLUSTERED ([address]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[frs_svp] TO [uniadmin]
GRANT INSERT ON  [dbo].[frs_svp] TO [uniadmin]
GRANT DELETE ON  [dbo].[frs_svp] TO [uniadmin]
GRANT UPDATE ON  [dbo].[frs_svp] TO [uniadmin]
GRANT SELECT ON  [dbo].[frs_svp] TO [uniuser]
GO