Changeset 342

Timestamp:

08/10/06 11:28:58 (18 years ago)

Author:

Kris Deugau

Message:

/trunk

Commit updates to initial SQL setup made "forever" ago.

File:

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

branches/stable/cgi-bin/ipdb.psql

@@ +1 @@
+DROP DATABASE ipdb;
+
+CREATE USER ipdb WITH PASSWORD 'ipdbpwd';
+
 CREATE DATABASE ipdb;
+
+UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename='ipdb')
+        WHERE datname='ipdb';
 
 \connect ipdb ipdb
@@ -64 +71 @@
         "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,
@@ -72 +79 @@
         "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(),
@@ -83 +90 @@
 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 '',
@@ -93 +100 @@
         "modifystamp" timestamp DEFAULT now(),
         "privdata" text DEFAULT '' NOT NULL,
-        "newcustid" character varying(16) DEFAULT '',
+        "custid" character varying(16) DEFAULT '',
         swip character(1) DEFAULT 'n'
 );
@@ -111 +118 @@
         "listorder" integer DEFAULT 0,
         "def_custid" character varying(16) DEFAULT '',
-        "arin_netname" character varying(20) DEFAILT 'ISP'
+        "arin_netname" character varying(20) DEFAULT 'ISP'
 );
 
@@ -189 +196 @@
 );
 
+-- Default password is admin
+INSERT INTO users VALUES ('admin','luef5C4XumqIs','bacdsA');
+
 CREATE TABLE "dns" (
         "ip" inet NOT NULL PRIMARY KEY,