Changeset 316

Timestamp:

03/31/06 15:42:00 (19 years ago)

Author:

Kris Deugau

Message:

/trunk

Update SQL tabledef source file

File:

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

trunk/cgi-bin/ipdb.psql

@@ -19 +19 @@
 
 REVOKE ALL on "customers" from PUBLIC;
-GRANT ALL on "customers" to "kdeugau";
 GRANT ALL on "customers" to "ipdb";
 
@@ -28 +27 @@
 
 REVOKE ALL on "masterblocks" from PUBLIC;
-GRANT ALL on "masterblocks" to "kdeugau";
 GRANT ALL on "masterblocks" to "ipdb";
 
@@ -39 +37 @@
 
 REVOKE ALL on "routed" from PUBLIC;
-GRANT ALL on "routed" to "kdeugau";
 GRANT ALL on "routed" to "ipdb";
+GRANT SELECT on "routed" to "ipdb";
 
 CREATE TABLE "temp" (
@@ -47 +45 @@
 
 REVOKE ALL on "temp" from PUBLIC;
-GRANT ALL on "temp" to "kdeugau";
 GRANT ALL on "temp" to "ipdb";
 
@@ -58 +55 @@
 
 REVOKE ALL on "freeblocks" from PUBLIC;
-GRANT ALL on "freeblocks" to "kdeugau";
 GRANT ALL on "freeblocks" to "ipdb";
 
@@ -72 +68 @@
         "circuitid" character varying(128) DEFAULT '' NOT NULL,
         "privdata" text DEFAULT '' NOT NULL,
-        "newcustid" integer,
+        "newcustid" character varying(16) DEFAULT '',
         "createstamp" timestamp DEFAULT now(),
         "modifystamp" timestamp DEFAULT now(),
@@ -79 +75 @@
 
 REVOKE ALL on "poolips" from PUBLIC;
-GRANT ALL on "poolips" to "kdeugau";
 GRANT ALL on "poolips" to "ipdb";
 
@@ -94 +89 @@
         "modifystamp" timestamp DEFAULT now(),
         "privdata" text DEFAULT '' NOT NULL,
-        "newcustid" integer
+        "newcustid" character varying(16) DEFAULT '',
+        swip character(1) DEFAULT 'n'
 );
 
 REVOKE ALL on "allocations" from PUBLIC;
-GRANT ALL on "allocations" to "kdeugau";
 GRANT ALL on "allocations" to "ipdb";
 
@@ -104 +99 @@
 
 REVOKE ALL on "searchme" from PUBLIC;
-GRANT ALL on "searchme" to "kdeugau";
 GRANT ALL on "searchme" to "ipdb";
 
@@ -114 +108 @@
         "def_custid" character varying(16) DEFAULT ''
 );
-
-REVOKE ALL on "alloctypes" from PUBLIC;
-GRANT ALL on "alloctypes" to "kdeugau";
-GRANT ALL on "alloctypes" to "ipdb";
-
-CREATE TABLE "cities" (
-        "id" serial NOT NULL PRIMARY KEY,
-        "city" character varying(30) DEFAULT '' NOT NULL,
-        "routing" character(1) DEFAULT 'n' NOT NULL
-);
-
-REVOKE ALL on "cities" from PUBLIC;
-GRANT ALL on "cities" to "kdeugau";
-GRANT ALL on "cities" to "ipdb";
-
-CREATE TABLE "alloctypes" (
-        "type" character(2) DEFAULT '' NOT NULL,
-        "listname" character varying(40) DEFAULT '',
-        "dispname" character varying(40) DEFAULT '',
-        "listorder" integer DEFAULT 0,
-        "def_custid" character varying(16) DEFAULT '',
-        Constraint "alloctypes_pkey" Primary Key ("type")
-);
-
-REVOKE ALL on "alloctypes" from PUBLIC;
-GRANT ALL on "alloctypes" to "kdeugau";
-GRANT ALL on "alloctypes" to "ipdb";
 
 COPY "alloctypes" FROM stdin;
@@ -167 +134 @@
 wr      WAN block       WAN block       220     6750400
 \.
+
+REVOKE ALL on "alloctypes" from PUBLIC;
+GRANT ALL on "alloctypes" to "ipdb";
+
+CREATE TABLE "cities" (
+        "id" serial NOT NULL PRIMARY KEY,
+        "city" character varying(30) DEFAULT '' NOT NULL,
+        "routing" character(1) DEFAULT 'n' NOT NULL
+);
+
+REVOKE ALL on "cities" from PUBLIC;
+GRANT ALL on "cities" to "ipdb";
 
 --