1 files changed, 30 insertions, 1 deletions

diff --git a/notes/projects/radius/sql/ippool-demo.sql b/notes/projects/radius/sql/ippool-demo.sql
index 57352d8..d0a992b 100644
--- a/notes/projects/radius/sql/ippool-demo.sql
+++ b/notes/projects/radius/sql/ippool-demo.sql
@@ -89,12 +89,18 @@ SELECT              netblock_add
                     ( netAddress    := '209.193.4.128/25',
                       poolName      := 'Reserved',
                       netBusyout    := TRUE,
-                      addIpEntries  := FALSE
+                      addIpEntries  := TRUE
                     );
 
 
 -- create example explicit IP reservations
 SELECT              ip_assign
+                    ( assignIp      := '209.193.4.3/32',
+                      assignNas     := 'br1.sol',
+                      assignUser    := 'busy1@example.net',
+                      assignForce   := TRUE
+                    );
+SELECT              ip_assign
                     ( assignIp      := '209.193.4.8/32',
                       assignNas     := 'br1.sol',
                       assignUser    := 'jdoe8@example.net'
@@ -126,6 +132,29 @@ SELECT              ip_assign
                     );
 
 
+-- auto-assign IP reservations
+SELECT              ip_autoassign
+                    ( assignUser    := 'autoassign1@example.net',
+                      assignNas     := 'br1.sol',
+                      assignPool    := 'dhcp'
+                    );
+SELECT              ip_autoassign
+                    ( assignUser    := 'autoassign2@example.net',
+                      assignNas     := 'br1.sol',
+                      assignPool    := 'dhcp'
+                    );
+SELECT              ip_autoassign
+                    ( assignUser    := 'autoassign3@example.net',
+                      assignNas     := 'br1.sol',
+                      assignPool    := 'dhcp'
+                    );
+SELECT              ip_autoassign
+                    ( assignUser    := 'autoassign4@example.net',
+                      assignNas     := 'br1.sol',
+                      assignPool    := 'dhcp'
+                    );
+
+
 -- add missing IP addresses to netblock
 -- SELECT              ip_add_network( ipNetwork := '209.112.192.0/19' );
 -- SELECT              ip_add_network( ipNetwork := '209.112.128.0/18' );