Checkpointing changes

1 files changed, 2 insertions, 8 deletions

diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql
index 3730051..9a92ef8 100644
--- a/notes/projects/radius/sql/ippool-schema.sql
+++ b/notes/projects/radius/sql/ippool-schema.sql
@@ -157,7 +157,7 @@ CREATE TABLE IF NOT EXISTS netblock
    network          CIDR            NOT NULL UNIQUE,
    poolId           INTEGER         NOT NULL,
    regionId         INTEGER,
-   active           BOOLEAN         NOT NULL DEFAULT TRUE,
+   assignable       BOOLEAN         NOT NULL DEFAULT TRUE,
    description      VARCHAR(256),
    PRIMARY KEY      ( id ),
    FOREIGN KEY      ( poolId )
@@ -173,7 +173,7 @@ CREATE INDEX
                     ( id,
                       poolId,
                       network,
-                      active
+                      assignable
                     );
 
 
@@ -192,9 +192,6 @@ CREATE INDEX
  *  username
  *  : username currently assigned or last assigned address
  *
- *  acctSession
- *  : RADIUS accounting session currently holding address
- *
  *  nasId
  *  : reference to RADIUS NAS client currently holding address
  */
@@ -205,7 +202,6 @@ CREATE TABLE IF NOT EXISTS ip
    modified         timestamp       WITH TIME ZONE NOT NULL
                                     DEFAULT TIMESTAMP 'epoch',
    username         VARCHAR(64),
-   acctSession      VARCHAR(32),
    nasId            INTEGER,
    PRIMARY KEY      ( address ),
    FOREIGN KEY      ( nasId )
@@ -222,7 +218,6 @@ CREATE INDEX
                       netblockId,
                       modified,
                       username,
-                      acctSession,
                       nasId
                     );
 
@@ -264,7 +259,6 @@ BEGIN
 
    -- forces initial values
    NEW.username     := NULL;
-   NEW.acctSession  := NULL;
    NEW.nasId        := NULL;
    NEW.modified     := TIMESTAMP 'epoch';