CREATE TABLE [dbo].[frs_packet_line]
(
[l_net_name] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[l_node_name] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[l_node_id] [int] NULL,
[l_shelf] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[l_line] [int] NOT NULL,
[l_slot] [int] NOT NULL,
[l_port] [int] NOT NULL,
[l_vtrk] [int] NOT NULL,
[card_type] [int] NULL,
[interface] [int] NULL,
[line_load] [int] NULL,
[r_network_id] [int] NULL,
[r_network_name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[r_node_id] [int] NULL,
[r_line] [int] NULL,
[r_slot] [int] NULL,
[r_port] [int] NULL,
[r_vtrk] [int] NULL,
[alarm_state] [int] NULL,
[active] [int] NULL,
[status] [int] NULL,
[stat_reserve] [int] NULL,
[b_bq_depth] [int] NULL,
[b_bq_efcn] [int] NULL,
[clp_h_thresh] [int] NULL,
[clp_l_thresh] [int] NULL,
[stats] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[frs_packet_line] ADD CONSTRAINT [XPKfrs_packet_line] PRIMARY KEY CLUSTERED ([l_net_name], [l_node_name], [l_line], [l_slot], [l_port], [l_vtrk]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[frs_packet_line] TO [uniadmin]
GRANT INSERT ON  [dbo].[frs_packet_line] TO [uniadmin]
GRANT DELETE ON  [dbo].[frs_packet_line] TO [uniadmin]
GRANT UPDATE ON  [dbo].[frs_packet_line] TO [uniadmin]
GRANT SELECT ON  [dbo].[frs_packet_line] TO [uniuser]
GO