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

Timestamp:

04/06/06 15:47:21 (18 years ago)

Author:

Kris Deugau

Message:

/trunk

Refactor rWHOIS export for easier rWHOIS data access.
Update SQL tabledefs (customers table, alloctypes table) and

predefined alloctypes list with database changes.

Add rWHOIS configuration files and notes

File:

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

trunk/cgi-bin/ipdb.psql

@@ -10 +10 @@
         "city" character varying(30),
         "province" character(2),
+        "country" character(2),
         "pocode" character varying(7),
         "phone" character varying(15),
-        "abuse" character varying(50),
+        "tech_handle" character varying(50),
+        "abuse_handle" character varying(50),
+        "admin_handle" character varying(50),
         "def_rdns" character varying(40),
-        "description" text,
+        "special" text,
         Constraint "customers_pkey" Primary Key ("custid")
 );
@@ -23 +26 @@
 CREATE TABLE "masterblocks" (
         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
-        "ctime" timestamp DEFAULT now()
+        "ctime" timestamp DEFAULT now(),
+        "mtime" timestamp DEFAULT now()
 );
 
@@ -106 +110 @@
         "dispname" character varying(40) DEFAULT '',
         "listorder" integer DEFAULT 0,
-        "def_custid" character varying(16) DEFAULT ''
+        "def_custid" character varying(16) DEFAULT '',
+        "arin_netname" character varying(20) DEFAILT 'ISP'
 );
 
@@ -113 +118 @@
 --
 
-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
-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
-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
-in      Internal netblock       Internal netblock       990     6750400
-mm      Master block    Master block    999     6750400
+COPY "alloctypes" FROM stdin;
+cn      Customer netblock       Customer netblock       0               ISPCUST
+si      Static IP - Server pool Server pool IP  20      6750400 ISP
+ci      Static IP - Cable       Static cable IP 21              ISP
+di      Static IP - DSL Static DSL IP   22              ISP
+mi      Static IP - Dialup      Static dialup IP        23              ISP
+wi      Static IP - Wireless    Static wireless IP      24              ISP
+sd      Static Pool - Servers   Server pool     40      6750400 ISP
+cd      Static Pool - Cable     Cable pool      41      CBL-BUS ISP-STATIC-CABLE
+dp      Static Pool - DSL       DSL pool        42      DSL-BUS ISP-STATIC-DSL
+mp      Static Pool - Dialup    Static dialup pool      43      DIAL-BUS        ISP-STATIC-DIAL
+wp      Static Pool - Wireless  Static wireless pool    44      WL-BUS  ISP-STATIC-WIFI
+en      End-use netblock        End-use netblock        100     6750400 ISP
+me      Dialup netblock Dialup netblock 101     DIAL-RES        ISP-DIAL
+de      Dynamic DSL block       Dynamic DSL block       102     DSL-RES ISP-DSL
+ce      Dynamic cable block     Dynamic cable block     103     CBL-RES ISP-CABLE
+we      Dynamic WiFi block      Dynamic WiFi block      104     WL-RES  ISP-WIFI
+ve      Dynamic VoIP block      Dynamic VoIP block      105     DYN-VOIP        ISP
+li      Static IP - LAN/POP     Static LAN/POP IP       190     6750400 ISP
+ld      Static Pool - LAN/POP   LAN pool        191     6750400 ISP
+wc      Reserve for CORE/WAN blocks     CORE/WAN blocks 200     6750400 ISP
+pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 201     6750400 ISP-STATIC-DSL
+ac      Reserve for ATM ATM blocks      202     6750400 ISP
+wr      CORE/WAN block  CORE/WAN block  220     6750400 ISP
+pr      Dynamic-route DSL netblock      Dynamic-route DSL       221             ISP
+ar      ATM block       ATM block       222             ISP
+rm      Routing Routed netblock 500     6750400 ISP
+in      Internal netblock       Internal netblock       990     6750400 ISP
+mm      Master block    Master block    999     6750400 ISP
 \.