Changeset 321

Timestamp:

04/05/06 12:20:09 (19 years ago)

Author:

Kris Deugau

Message:

/trunk

Update SQL tabledefs and "default" alloctypes with current alloctype list

File:

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

trunk/cgi-bin/ipdb.psql

@@ -109 +109 @@
 );
 
-COPY "alloctypes" FROM stdin;
+--
+-- Name: alloctypes; Type: TABLE DATA; Schema: public; Owner: ipdb
+--
+
+COPY alloctypes ("type", listname, dispname, listorder, def_custid) FROM stdin;
+cn      Customer netblock       Customer netblock       0       
+si      Static IP - Server pool Server pool IP  20      
+ci      Static IP - Cable       Static cable IP 21      
+di      Static IP - DSL Static DSL IP   22      
+mi      Static IP - Dialup      Static dialup IP        23      
+wi      Static IP - Wireless    Static wireless IP      24      
+sd      Static Pool - Servers   Server pool     40      6750400
 cd      Static Pool - Cable     Cable pool      41      CBL-BUS
 dp      Static Pool - DSL       DSL pool        42      DSL-BUS
 mp      Static Pool - Dialup    Static dialup pool      43      DIAL-BUS
 wp      Static Pool - Wireless  Static wireless pool    44      WL-BUS
-mm      Master block    Master block    999     6750400
-in      Internal netblock       Internal netblock       990     6750400
-sd      Static Pool - Servers   Server pool     40      6750400
-cn      Customer netblock       Customer netblock       0       
-ci      Static IP - Cable       Static cable IP 21      
-di      Static IP - DSL Static DSL IP   22      
-mi      Static IP - Dialup      Static dialup IP        23      
-wi      Static IP - Wireless    Static wireless IP      24      
-si      Static IP - Server pool Server pool IP  20      6750400
-wc      Reserve for WAN blocks  WAN IP blocks   200     6750400
 en      End-use netblock        End-use netblock        100     6750400
 me      Dialup netblock Dialup netblock 101     DIAL-RES
@@ -129 +130 @@
 ce      Dynamic cable block     Dynamic cable block     103     CBL-RES
 we      Dynamic WiFi block      Dynamic WiFi block      104     WL-RES
+ve      Dynamic VoIP block      Dynamic VoIP block      105     DYN-VOIP
+li      Static IP - LAN/POP     Static LAN/POP IP       190     6750400
+ai      Static IP - Managment   Static management IP    192     6750400
+ad      Static Pool - Managment Management pool 196     6750400
+ld      Static Pool - LAN/POP   LAN pool        195     6750400
+wc      Reserve for CORE/WAN blocks     CORE/WAN blocks 200     6750400
+pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 201     6750400
+ac      Reserve for ATM ATM blocks      202     6750400
+wr      CORE/WAN block  CORE/WAN block  220     6750400
+pr      Dynamic-route DSL netblock      Dynamic-route DSL       221     
+ar      ATM block       ATM block       222     
 rm      Routing Routed netblock 500     6750400
-pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 201     6750400
-pr      Dynamic-route DSL netblock      Dynamic-route DSL       221     
-wr      WAN block       WAN block       220     6750400
+in      Internal netblock       Internal netblock       990     6750400
+mm      Master block    Master block    999     6750400
 \.