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

Timestamp:

11/30/04 15:42:30 (19 years ago)

Author:

Kris Deugau

Message:

/trunk

Port updates and bugfixes from /branches/stable r87:91 back
into devel tree

File:

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

trunk/cgi-bin/ipdb.psql

@@ -5 +5 @@
 
 --
--- TOC Entry ID 18 (OID 16556)
+-- TOC Entry ID 22 (OID 16556)
 --
 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
@@ -13 +13 @@
 
 --
--- TOC Entry ID 19 (OID 16557)
+-- TOC Entry ID 23 (OID 16557)
 --
 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner: 
@@ -217 +217 @@
 GRANT ALL on "allocations" to "ipdb";
 
+--
+-- TOC Entry ID 18 (OID 92809)
+--
+-- Name: alloctypes Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "alloctypes" (
+        "type" character(2) DEFAULT '' NOT NULL,
+        "listname" character varying(40) DEFAULT '',
+        "dispname" character varying(40) DEFAULT '',
+        "listorder" integer DEFAULT 0,
+        Constraint "alloctypes_pkey" Primary Key ("type")
+);
+
+--
+-- TOC Entry ID 19 (OID 92809)
+--
+-- Name: alloctypes Type: ACL Owner: 
+--
+
+REVOKE ALL on "alloctypes" from PUBLIC;
+GRANT ALL on "alloctypes" to "kdeugau";
+GRANT ALL on "alloctypes" to "ipdb";
+
+--
+-- TOC Entry ID 20 (OID 93964)
+--
+-- Name: cities Type: TABLE Owner: ipdb
+--
+
+CREATE TABLE "cities" (
+        "city" character varying(30) DEFAULT '' NOT NULL,
+        "routing" character(1) DEFAULT 'n' NOT NULL,
+        Constraint "cities_pkey" Primary Key ("city")
+);
+
+--
+-- TOC Entry ID 21 (OID 93964)
+--
+-- Name: cities Type: ACL Owner: 
+--
+
+REVOKE ALL on "cities" from PUBLIC;
+GRANT ALL on "cities" to "kdeugau";
+GRANT ALL on "cities" to "ipdb";
+