Changeset 175

Timestamp:

03/01/05 11:49:46 (20 years ago)

Author:

Kris Deugau

Message:

/trunk

Updated SQL table definitions - pg_dump format

File:

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

trunk/cgi-bin/ipdb.psql

@@ -123 +123 @@
 --
 
-CREATE VIEW "searchme" as SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, allocations.description FROM allocations UNION SELECT poolips.ip, poolips.custid, poolips.ptype, poolips.city, poolips.description FROM poolips;
+CREATE VIEW "searchme" as SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, allocations.description FROM allocations UNION SELECT poolips.ip, poolips.custid, poolips.type, poolips.city, poolips.description FROM poolips;
 
 --
@@ -169 +169 @@
         "ip" cidr DEFAULT '255.255.255.255/32' NOT NULL,
         "custid" character varying(16) DEFAULT '' NOT NULL,
-        "city" character varying(30) DEFAULT '',
-        "ptype" character(1) DEFAULT 'c' NOT NULL,
-        "available" character(1) DEFAULT 'y',
-        "notes" text DEFAULT '',
-        "description" character varying(64) DEFAULT '',
-        "circuitid" character varying(128) DEFAULT '',
+        "city" character varying(30) DEFAULT '' NOT NULL,
+        "type" character(2) DEFAULT '' NOT NULL,
+        "available" character(1) DEFAULT 'y' NOT NULL,
+        "notes" text DEFAULT '' NOT NULL,
+        "description" character varying(64) DEFAULT '' NOT NULL,
+        "circuitid" character varying(128) DEFAULT '' NOT NULL,
+        "newcustid" integer,
         CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))),
         Constraint "poolips_pkey" Primary Key ("ip")
@@ -204 +205 @@
         "maskbits" integer DEFAULT 128,
         "circuitid" character varying(128) DEFAULT '',
+        "newcustid" integer,
         Constraint "allocations_pkey" Primary Key ("cidr")
 );
@@ -228 +230 @@
         "dispname" character varying(40) DEFAULT '',
         "listorder" integer DEFAULT 0,
+        "def_custid" character varying(16) DEFAULT '',
         Constraint "alloctypes_pkey" Primary Key ("type")
 );