aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--notes/projects/radius/sql/ippool-demo.sql8
-rw-r--r--notes/projects/radius/sql/ippool-schema.sql4
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
82 SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ), 82 SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ),
83 username = 'jdoe1@acsalaska.net', 83 username = 'jdoe1@acsalaska.net',
84 acctSession = 'qqasasdqweasdasdqqas' 84 acctSession = 'qqasasdqweasdasdqqas'
85 WHERE address = '209.193.4.9/32'; 85 WHERE address = '209.193.4.9/32';
86UPDATE ip
87 SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ),
88 username = 'jdoe1@acsalaska.net',
89 acctSession = 'qqasasdqweasdasdqqas'
90 WHERE address = '209.193.4.9/32';
91
86 92
87SELECT ip_add_network( ipNetwork := '209.112.192.0/19' ); 93SELECT ip_add_network( ipNetwork := '209.112.192.0/19' );
88SELECT ip_add_network( ipNetwork := '209.112.128.0/18' ); 94SELECT 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
400 regionId 400 regionId
401 ) 401 )
402 VALUES ( lower(nasName), 402 VALUES ( lower(nasName),
403 nasRegionId 403 nasRegionId
404 ) 404 )
405 RETURNING id INTO returnId; 405 RETURNING id INTO returnId;
406 406
@@ -422,7 +422,7 @@ $$;
422 * regionName := 'Soldotna', 422 * regionName := 'Soldotna',
423 * netActive := FALSE, 423 * netActive := FALSE,
424 * netDesc := 'Lab IP Pool', 424 * netDesc := 'Lab IP Pool',
425 * addIpEntries := TRUE 425 * addIpEntries := TRUE
426 * ); 426 * );
427 * 427 *
428 * netAddress 428 * netAddress