Changeset 185 for branches/stable/cgi-bin/ipdb.psql

Timestamp:

03/01/05 16:31:04 (21 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Backport SQL/SQL-related bugfixes from /trunk r180 through 184

File:

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

branches/stable/cgi-bin/ipdb.psql

@@ -1 @@
-\connect - postgres
+CREATE DATABASE ipdb;
 
 \connect ipdb ipdb
@@ -49 +49 @@
 
 CREATE TABLE "freeblocks" (
-        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY
+        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
         "maskbits" integer DEFAULT 128,
         "city" character varying(30) DEFAULT '',
@@ -120 +120 @@
 GRANT ALL on "cities" to "ipdb";
 
+COPY "alloctypes" FROM stdin;
+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
+dc      Dynamic cable block     Dynamic cable block     103     CBL-RES
+dy      Dynamic DSL block       Dynamic DSL block       102     DSL-RES
+dn      Dialup netblock Dialup netblock 101     DIAL-RES
+dw      Dynamic WiFi block      Dynamic WiFi block      104     WL-RES
+mm      Master block    Master block    999     6750400
+rr      Routing Routed netblock 500     6750400
+in      Internal netblock       Internal netblock       990     6750400
+ee      End-use netblock        End-use netblock        100     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
+\.