1 files changed, 9 insertions, 9 deletions

diff --git a/notes/projects/radius/sql/ippool-demo.sql b/notes/projects/radius/sql/ippool-demo.sql
index 3875eed..e6eb48a 100644
--- a/notes/projects/radius/sql/ippool-demo.sql
+++ b/notes/projects/radius/sql/ippool-demo.sql
@@ -12,16 +12,16 @@ SET ROLE radius;
 
 
 -- create example pools
-SELECT pool_add( poolName := 'DHCP' );
-SELECT pool_add( poolName := 'PPPoE' );
-SELECT pool_add( poolName := 'reserved' );
+INSERT INTO pool ( name ) VALUES ( 'DHCP' );
+INSERT INTO pool ( name ) VALUES ( 'PPPoE' );
+INSERT INTO pool ( name ) VALUES ( 'reserved' );
 
 
 -- create example regions
-SELECT region_add( regionName := 'Anchorage' );
-SELECT region_add( regionName := 'Soldotna' );
-SELECT region_add( regionName := 'Fairbanks' );
-SELECT region_add( regionName := 'No where' );
+INSERT INTO region ( name ) VALUES ( 'Anchorage' );
+INSERT INTO region ( name ) VALUES ( 'Soldotna' );
+INSERT INTO region ( name ) VALUES ( 'Fairbanks' );
+INSERT INTO region ( name ) VALUES ( 'No where' );
 
 
 -- create example NAS clients
@@ -118,8 +118,8 @@ SELECT              ip_assign
 
 
 -- 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' );
+-- SELECT              ip_add_network( ipNetwork := '209.112.192.0/19' );
+-- SELECT              ip_add_network( ipNetwork := '209.112.128.0/18' );
 
 
 /* end of sql */