CREATE TABLE [dbo].[nodes](
	[net_id] [int] NOT NULL,
	[node_id] [int] IDENTITY( 1 , 1 ) NOT NULL,
	[node_name] [varchar]( 255 ) NOT NULL,
	[node_type_id] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[node_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[node_name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[sdh_mux_settings](
	[node_id] [int] NOT NULL,
	[nsap] [varchar]( 42 ) NOT NULL,
	[ip_address] [varchar]( 23 ) NOT NULL,
UNIQUE NONCLUSTERED 
(
	[ip_address] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[nsap] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

-- FK
ALTER TABLE [dbo].[sdh_mux_settings]  WITH CHECK ADD  CONSTRAINT [FKsdh_mux_se43357] FOREIGN KEY([node_id])
REFERENCES [dbo].[nodes] ([node_id])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[sdh_mux_settings] CHECK CONSTRAINT [FKsdh_mux_se43357]