Changeset 257 for trunk

Timestamp:

05/31/05 17:04:07 (20 years ago)

Author:

Kris Deugau

Message:

/trunk

Update ipdb.psql tabledefs and default alloctypes

File:

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

trunk/cgi-bin/ipdb.psql

@@ -118 +118 @@
 
 CREATE TABLE "cities" (
-        "city" character varying(30) DEFAULT '' NOT NULL PRIMARY KEY,
+        "id" serial NOT NULL PRIMARY KEY,
+        "city" character varying(30) DEFAULT '' NOT NULL,
         "routing" character(1) DEFAULT 'n' NOT NULL
 );
@@ -125 +126 @@
 GRANT ALL on "cities" to "kdeugau";
 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" (
@@ -146 +136 @@
 );
 
---
--- 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;
@@ -178 +155 @@
 si      Static IP - Server pool Server pool IP  20      6750400
 wc      Reserve for WAN blocks  WAN IP blocks   200     6750400
-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
@@ -186 +161 @@
 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     
+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
 \.
 
@@ -214 +191 @@
         "acl" varchar(16) DEFAULT 'b'
 );
+
+CREATE TABLE "dns" (
+        "ip" inet NOT NULL PRIMARY KEY,
+        "hostname" character varying(128),
+        "auto" character(1) DEFAULT 'y'
+);