1 files changed, 53 insertions, 0 deletions

diff --git a/notes/projects/radius/sql/README.ippool.md b/notes/projects/radius/sql/README.ippool.md
new file mode 100644
index 0000000..871889a
--- /dev/null
+++ b/notes/projects/radius/sql/README.ippool.md
@@ -0,0 +1,53 @@
+
+IP Engineering RADIUS IP Pool Database
+======================================
+
+Objectives
+----------
+
+   * Psuedo static IP addresses
+   * Per NAS Preference for geographic regions
+   * Ability to deavtivate/busy out specific netblocks
+
+Files
+----
+
+   * README.ippool.md     - This file
+   * ippool-database.sql  - Creates database
+   * ippool-schema.sql    - Creates database schema (tables, indexes, etc)
+   * ippool-functions.sql - Creates end-user/end-application functions
+   * ippool-demo.sql      - Loads demo data
+   * ippool-queries.sql   - Common or useful queries
+   * radius-roles.sql     - Common database roles for RADIUS
+
+
+Initializing New Database
+-------------------------
+
+ * Create base database roles for RADIUS, not not already created:
+
+      psql -h raddbtest.prv.acsalaska.net -f radius-roles.sql
+
+ * Create database and load schema:
+
+      psql -h raddbtest.prv.acsalaska.net -f ippool-database.sql
+      psql -h raddbtest.prv.acsalaska.net -f ippool-schema.sql    radius_ippool
+      psql -h raddbtest.prv.acsalaska.net -f ippool-functions.sql radius_ippool
+
+ * Create RADIUS pools using `pool_add()`.
+ * Create RADIUS regions using `region_add()`.
+ * Create RADIUS NAS clients using `nas_add()`.
+ * Create network blocks using `netblock_add()`.
+ * Add IP addresses with `ip_add_network()` if `netblock_add()` was not called
+   with `addIpEntries := TRUE`.
+
+For examples of using the above functions, please read `ippool-demo.sql`.
+
+
+Network Block Management
+------------------------
+
+
+
+IP Address Assignments
+----------------------