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

Timestamp:

04/07/06 13:36:54 (18 years ago)

Author:

Kris Deugau

Message:

/trunk

Update SQL tabledefs with defaults on the customers table

(province/country/tech handle)

First iteration of cust data handling for rWHOIS - allow display

of existing data, entry of complete fresh new data.

File:

• trunk/cgi-bin/ipdb.psql (modified) (1 diff)

trunk/cgi-bin/ipdb.psql

@@ -4 +4 @@
 
 CREATE TABLE "customers" (
-        "custid" character varying(16) DEFAULT '' NOT NULL,
-        "name" character varying(64),
-        "street" character varying(25),
-        "street2" character varying(25),
-        "city" character varying(30),
-        "province" character(2),
-        "country" character(2),
-        "pocode" character varying(7),
-        "phone" character varying(15),
-        "tech_handle" character varying(50),
-        "abuse_handle" character varying(50),
-        "admin_handle" character varying(50),
-        "def_rdns" character varying(40),
-        "special" text,
-        Constraint "customers_pkey" Primary Key ("custid")
+        "custid" character varying(16) DEFAULT '' NOT NULL PRIMARY KEY
+        "name" character varying(64) DEFAULT '',
+        "street" character varying(25) DEFAULT '',
+        "street2" character varying(25) DEFAULT '',
+        "city" character varying(30) DEFAULT '',
+        "province" character(2) DEFAULT 'ON',
+        "country" character(2) DEFAULT 'CA',
+        "pocode" character varying(7) DEFAULT '',
+        "phone" character varying(15) DEFAULT '',
+        "tech_handle" character varying(50) DEFAULT 'VH25-ORG-ARIN',
+        "abuse_handle" character varying(50) DEFAULT '',
+        "admin_handle" character varying(50) DEFAULT '',
+        "def_rdns" character varying(40) DEFAULT '',
+        "special" text DEFAULT ''
 );