Changeset 189 for trunk/cgi-bin/ipdb.psql

Timestamp:

03/08/05 17:37:46 (19 years ago)

Author:

Kris Deugau

Message:

/trunk

Caught some buglets in the HairyPerl(TM) ('$1' vs "$1")
Corrected a potentially annoying SQL buglet relating to the

selection of which netblock an allocation is to be taken from;
under certain conditions it would pick a larger block to slice
up while there was still a perfectly usable block just the
right size waiting to be allocated.

Removed display of back-end alloctypes from success/failure notes
Corrected comments referring to alloctypes that have been altered
Updated IPDB "default" schema and alloctypes list with current

base information

File:

• trunk/cgi-bin/ipdb.psql (modified) (3 diffs)

trunk/cgi-bin/ipdb.psql

@@ -120 +120 @@
 GRANT ALL on "cities" to "ipdb";
 
+--
+-- Selected TOC Entries:
+--
+\connect - ipdb
+
+--
+-- TOC Entry ID 2 (OID 92809)
+--
+-- Name: alloctypes Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "alloctypes" (
+        "type" character(2) DEFAULT '' NOT NULL,
+        "listname" character varying(40) DEFAULT '',
+        "dispname" character varying(40) DEFAULT '',
+        "listorder" integer DEFAULT 0,
+        "def_custid" character varying(16) DEFAULT '',
+        Constraint "alloctypes_pkey" Primary Key ("type")
+);
+
+--
+-- TOC Entry ID 3 (OID 92809)
+--
+-- Name: alloctypes Type: ACL Owner: 
+--
+
+REVOKE ALL on "alloctypes" from PUBLIC;
+GRANT ALL on "alloctypes" to "kdeugau";
+GRANT ALL on "alloctypes" to "ipdb";
+
+--
+-- Data for TOC Entry ID 4 (OID 92809)
+--
+-- Name: alloctypes Type: TABLE DATA Owner: ipdb
+--
+
+
 COPY "alloctypes" FROM stdin;
 cd      Static Pool - Cable     Cable pool      41      CBL-BUS
@@ -125 +162 @@
 mp      Static Pool - Dialup    Static dialup pool      43      DIAL-BUS
 wp      Static Pool - Wireless  Static wireless pool    44      WL-BUS
-ce      Dynamic cable block     Dynamic cable block     103     CBL-RES
-de      Dynamic DSL block       Dynamic DSL block       102     DSL-RES
-me      Dialup netblock Dialup netblock 101     DIAL-RES
-we      Dynamic WiFi block      Dynamic WiFi block      104     WL-RES
 mm      Master block    Master block    999     6750400
-rm      Routing Routed netblock 500     6750400
 in      Internal netblock       Internal netblock       990     6750400
-en      End-use netblock        End-use netblock        100     6750400
 sd      Static Pool - Servers   Server pool     40      6750400
 cn      Customer netblock       Customer netblock       0       
@@ -143 +174 @@
 wr      Internal WAN block      Internal WAN block      201     6750400
 pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 202     6750400
+en      End-use netblock        End-use netblock        100     6750400
+me      Dialup netblock Dialup netblock 101     DIAL-RES
+de      Dynamic DSL block       Dynamic DSL block       102     DSL-RES
+ce      Dynamic cable block     Dynamic cable block     103     CBL-RES
+we      Dynamic WiFi block      Dynamic WiFi block      104     WL-RES
+rm      Routing Routed netblock 500     6750400
 pr      Dynamic-route DSL netblock      Dynamic-route DSL       203     
 \.