Changeset 507 for branches/stable/cgi-bin/ipdb.psql

Timestamp:

11/15/11 18:08:14 (12 years ago)

Author:

Kris Deugau

Message:

/branches/stable

Make the fixed web path at least configurable in one place rather
than completely hardcoded across many files.
Update initial database tabledef SQL
Bump version

File:

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

branches/stable/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
+-- Initial table setup for IP Database
 
 CREATE TABLE "customers" (
@@ -32 +19 @@
 );
 
-REVOKE ALL on "customers" from PUBLIC;
-GRANT ALL on "customers" to "ipdb";
-
 CREATE TABLE "masterblocks" (
         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
@@ -41 +25 @@
         "rwhois" character(1) DEFAULT 'n' NOT NULL
 );
-
-REVOKE ALL on "masterblocks" from PUBLIC;
-GRANT ALL on "masterblocks" to "ipdb";
 
 CREATE TABLE "routed" (
@@ -52 +33 @@
 );
 
-REVOKE ALL on "routed" from PUBLIC;
-GRANT ALL on "routed" to "ipdb";
-GRANT SELECT on "routed" to "ipdb";
-
 CREATE TABLE "temp" (
         "ofs" integer
 );
-
-REVOKE ALL on "temp" from PUBLIC;
-GRANT ALL on "temp" to "ipdb";
 
 CREATE TABLE "freeblocks" (
@@ -69 +43 @@
         "routed" character(1) DEFAULT 'n'
 );
-
-REVOKE ALL on "freeblocks" from PUBLIC;
-GRANT ALL on "freeblocks" to "ipdb";
 
 CREATE TABLE "poolips" (
@@ -90 +61 @@
 );
 
-REVOKE ALL on "poolips" from PUBLIC;
-GRANT ALL on "poolips" to "ipdb";
-
 CREATE TABLE "allocations" (
         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL PRIMARY KEY,
@@ -109 +77 @@
 );
 
-REVOKE ALL on "allocations" from PUBLIC;
-GRANT ALL on "allocations" to "ipdb";
-
 CREATE VIEW "searchme" as SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, allocations.description, allocations.notes, allocations.oldcustid, allocations.circuitid FROM allocations UNION SELECT poolips.ip, poolips.custid, poolips.type, poolips.city, poolips.description, poolips.notes, poolips.oldcustid, poolips.circuitid FROM poolips;
-
-REVOKE ALL on "searchme" from PUBLIC;
-GRANT ALL on "searchme" to "ipdb";
 
 CREATE TABLE "alloctypes" (
@@ -167 +129 @@
 \.
 
-REVOKE ALL on "alloctypes" from PUBLIC;
-GRANT ALL on "alloctypes" to "ipdb";
-
 CREATE TABLE "cities" (
         "id" serial NOT NULL PRIMARY KEY,
@@ -175 +134 @@
         "routing" character(1) DEFAULT 'n' NOT NULL
 );
-
-REVOKE ALL on "cities" from PUBLIC;
-GRANT ALL on "cities" to "ipdb";
 
 --