From da8b2f14d8daffdaad319b5500ada7baba4d5359 Mon Sep 17 00:00:00 2001 From: "David M. Syzdek" Date: Thu, 9 May 2019 10:38:58 -0800 Subject: adjusting whitespace. --- notes/projects/radius/sql/ippool-demo.sql | 8 +++++++- notes/projects/radius/sql/ippool-schema.sql | 4 ++-- 2 files changed, 9 insertions(+), 3 deletions(-) diff --git a/notes/projects/radius/sql/ippool-demo.sql b/notes/projects/radius/sql/ippool-demo.sql index 20659e3..1ad6f22 100644 --- a/notes/projects/radius/sql/ippool-demo.sql +++ b/notes/projects/radius/sql/ippool-demo.sql @@ -82,7 +82,13 @@ UPDATE ip SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ), username = 'jdoe1@acsalaska.net', acctSession = 'qqasasdqweasdasdqqas' - WHERE address = '209.193.4.9/32'; + WHERE address = '209.193.4.9/32'; +UPDATE ip + SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ), + username = 'jdoe1@acsalaska.net', + acctSession = 'qqasasdqweasdasdqqas' + WHERE address = '209.193.4.9/32'; + SELECT ip_add_network( ipNetwork := '209.112.192.0/19' ); SELECT ip_add_network( ipNetwork := '209.112.128.0/18' ); diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql index f3e41b2..ee12658 100644 --- a/notes/projects/radius/sql/ippool-schema.sql +++ b/notes/projects/radius/sql/ippool-schema.sql @@ -400,7 +400,7 @@ BEGIN regionId ) VALUES ( lower(nasName), - nasRegionId + nasRegionId ) RETURNING id INTO returnId; @@ -422,7 +422,7 @@ $$; * regionName := 'Soldotna', * netActive := FALSE, * netDesc := 'Lab IP Pool', - * addIpEntries := TRUE + * addIpEntries := TRUE * ); * * netAddress -- cgit v1.2.3