Changeset 347

Timestamp:

10/06/06 12:18:44 (18 years ago)

Author:

Kris Deugau

Message:

/trunk

Replace ipdb.psql SQL tabledef/database prep with latest
version from /branches/stable r346.

File:

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

trunk/cgi-bin/ipdb.psql

@@ +1 @@
+DROP DATABASE ipdb;
+
+CREATE USER ipdb WITH PASSWORD 'ipdbpwd';
+
 CREATE DATABASE ipdb;
 
+-- Need to do this or our triggers don't work.  Why do we need to do this?
+CREATE FUNCTION "plpgsql_call_handler" () RETURNS language_handler AS '$libdir/plpgsql' LANGUAGE C;
+CREATE TRUSTED LANGUAGE "plpgsql" HANDLER "plpgsql_call_handler";
+
+UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename='ipdb')
+        WHERE datname='ipdb';
+
 \connect ipdb ipdb
 
 CREATE TABLE "customers" (
-        "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 ''
+        "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")
 );
 
@@ -63 +75 @@
         "pool" cidr DEFAULT '255.255.255.255/32' NOT NULL,
         "ip" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
-        "custid" character varying(16) DEFAULT '' NOT NULL,
+        "oldcustid" character varying(16) DEFAULT '' NOT NULL,
         "city" character varying(30) DEFAULT '' NOT NULL,
         "type" character(2) DEFAULT '' NOT NULL,
@@ -71 +83 @@
         "circuitid" character varying(128) DEFAULT '' NOT NULL,
         "privdata" text DEFAULT '' NOT NULL,
-        "newcustid" character varying(16) DEFAULT '',
+        "custid" character varying(16) DEFAULT '',
         "createstamp" timestamp DEFAULT now(),
         "modifystamp" timestamp DEFAULT now(),
@@ -82 +94 @@
 CREATE TABLE "allocations" (
         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
-        "custid" character varying(16) DEFAULT '',
+        "oldcustid" character varying(16) DEFAULT '',
         "type" character(2) DEFAULT '',
         "city" character varying(30) DEFAULT '',
@@ -92 +104 @@
         "modifystamp" timestamp DEFAULT now(),
         "privdata" text DEFAULT '' NOT NULL,
-        "newcustid" character varying(16) DEFAULT '',
+        "custid" character varying(16) DEFAULT '',
         swip character(1) DEFAULT 'n'
 );
@@ -110 +122 @@
         "listorder" integer DEFAULT 0,
         "def_custid" character varying(16) DEFAULT '',
-        "arin_netname" character varying(20) DEFAILT 'ISP'
+        "arin_netname" character varying(20) DEFAULT 'ISP'
 );
 
@@ -140 +152 @@
 pc      Reserve for dynamic-route DSL netblocks Dynamic-route netblocks 201     6750400 ISP-STATIC-DSL
 ac      Reserve for ATM ATM blocks      202     6750400 ISP
+fc      Reserve for fibre       Fibre blocks    203     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
+fr      Fibre   Fibre   223             ISP
 rm      Routing Routed netblock 500     6750400 ISP
 in      Internal netblock       Internal netblock       990     6750400 ISP
@@ -186 +200 @@
 );
 
+-- Default password is admin
+INSERT INTO users VALUES ('admin','luef5C4XumqIs','bacdsA');
+
 CREATE TABLE "dns" (
         "ip" inet NOT NULL PRIMARY KEY,