Changeset 34 for trunk/cgi-bin


Ignore:
Timestamp:
10/28/04 12:31:12 (20 years ago)
Author:
Kris Deugau
Message:

/trunk

Updated Postgres schema dump

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/cgi-bin/ipdb.psql

    r4 r34  
    55
    66--
    7 -- TOC Entry ID 9 (OID 16556)
     7-- TOC Entry ID 18 (OID 16559)
    88--
    99-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
     
    1313
    1414--
    15 -- TOC Entry ID 10 (OID 16557)
     15-- TOC Entry ID 19 (OID 16560)
    1616--
    1717-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
     
    2323
    2424--
    25 -- TOC Entry ID 2 (OID 25848)
     25-- TOC Entry ID 2 (OID 16561)
    2626--
    2727-- Name: allocations Type: TABLE Owner: ipdb
     
    4040
    4141--
    42 -- TOC Entry ID 3 (OID 25854)
     42-- TOC Entry ID 3 (OID 16561)
     43--
     44-- Name: allocations Type: ACL Owner:
     45--
     46
     47REVOKE ALL on "allocations" from PUBLIC;
     48GRANT ALL on "allocations" to "ipdb";
     49GRANT ALL on "allocations" to "kdeugau";
     50
     51--
     52-- TOC Entry ID 4 (OID 16567)
    4353--
    4454-- Name: customers Type: TABLE Owner: ipdb
     
    6171
    6272--
    63 -- TOC Entry ID 4 (OID 25860)
     73-- TOC Entry ID 5 (OID 16567)
     74--
     75-- Name: customers Type: ACL Owner:
     76--
     77
     78REVOKE ALL on "customers" from PUBLIC;
     79GRANT ALL on "customers" to "ipdb";
     80GRANT ALL on "customers" to "kdeugau";
     81
     82--
     83-- TOC Entry ID 6 (OID 16573)
    6484--
    6585-- Name: freeblocks Type: TABLE Owner: ipdb
     
    7696
    7797--
    78 -- TOC Entry ID 5 (OID 25866)
     98-- TOC Entry ID 7 (OID 16573)
     99--
     100-- Name: freeblocks Type: ACL Owner:
     101--
     102
     103REVOKE ALL on "freeblocks" from PUBLIC;
     104GRANT ALL on "freeblocks" to "ipdb";
     105GRANT ALL on "freeblocks" to "kdeugau";
     106
     107--
     108-- TOC Entry ID 8 (OID 16585)
     109--
     110-- Name: masterblocks Type: TABLE Owner: ipdb
     111--
     112
     113CREATE TABLE "masterblocks" (
     114        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
     115        Constraint "masterblocks_pkey" Primary Key ("cidr")
     116);
     117
     118--
     119-- TOC Entry ID 9 (OID 16585)
     120--
     121-- Name: masterblocks Type: ACL Owner:
     122--
     123
     124REVOKE ALL on "masterblocks" from PUBLIC;
     125GRANT ALL on "masterblocks" to "ipdb";
     126GRANT ALL on "masterblocks" to "kdeugau";
     127
     128--
     129-- TOC Entry ID 10 (OID 16588)
     130--
     131-- Name: routed Type: TABLE Owner: ipdb
     132--
     133
     134CREATE TABLE "routed" (
     135        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
     136        "maskbits" integer DEFAULT 128,
     137        "city" character varying(30) DEFAULT '',
     138        Constraint "routed_pkey" Primary Key ("cidr")
     139);
     140
     141--
     142-- TOC Entry ID 11 (OID 16588)
     143--
     144-- Name: routed Type: ACL Owner:
     145--
     146
     147REVOKE ALL on "routed" from PUBLIC;
     148GRANT ALL on "routed" to "ipdb";
     149GRANT ALL on "routed" to "kdeugau";
     150
     151--
     152-- TOC Entry ID 12 (OID 16594)
     153--
     154-- Name: temp Type: TABLE Owner: ipdb
     155--
     156
     157CREATE TABLE "temp" (
     158        "ofs" integer
     159);
     160
     161--
     162-- TOC Entry ID 13 (OID 16594)
     163--
     164-- Name: temp Type: ACL Owner:
     165--
     166
     167REVOKE ALL on "temp" from PUBLIC;
     168GRANT ALL on "temp" to "ipdb";
     169GRANT ALL on "temp" to "kdeugau";
     170
     171--
     172-- TOC Entry ID 14 (OID 16598)
     173--
     174-- Name: searchme Type: VIEW Owner: ipdb
     175--
     176
     177CREATE VIEW "searchme" as SELECT allocations.cidr, allocations.custid, allocations."type", allocations.city, allocations.description FROM allocations UNION SELECT poolips.ip, poolips.custid, poolips.ptype, poolips.city, poolips.description FROM poolips;
     178
     179--
     180-- TOC Entry ID 15 (OID 16598)
     181--
     182-- Name: searchme Type: ACL Owner:
     183--
     184
     185REVOKE ALL on "searchme" from PUBLIC;
     186GRANT ALL on "searchme" to "ipdb";
     187GRANT ALL on "searchme" to "kdeugau";
     188
     189--
     190-- TOC Entry ID 16 (OID 19130)
     191--
     192-- Name: temp2 Type: TABLE Owner: ipdb
     193--
     194
     195CREATE TABLE "temp2" (
     196        "pool" cidr,
     197        "ip" cidr,
     198        "custid" character varying(16),
     199        "city" character varying(30),
     200        "ptype" character(1),
     201        "available" character(1),
     202        "notes" text,
     203        "description" character varying(64)
     204);
     205
     206--
     207-- TOC Entry ID 17 (OID 20316)
    79208--
    80209-- Name: poolips Type: TABLE Owner: ipdb
     
    89218        "available" character(1) DEFAULT 'y',
    90219        "notes" text,
    91         CHECK ((((ptype = 'c'::bpchar) OR (ptype = 'd'::bpchar)) OR (ptype = 's'::bpchar))),
     220        "description" character varying(64) DEFAULT '',
    92221        CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))),
    93222        Constraint "poolips_pkey" Primary Key ("ip")
    94223);
    95224
    96 --
    97 -- TOC Entry ID 6 (OID 25872)
    98 --
    99 -- Name: masterblocks Type: TABLE Owner: ipdb
    100 --
    101 
    102 CREATE TABLE "masterblocks" (
    103         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
    104         Constraint "masterblocks_pkey" Primary Key ("cidr")
    105 );
    106 
    107 --
    108 -- TOC Entry ID 7 (OID 25875)
    109 --
    110 -- Name: routed Type: TABLE Owner: ipdb
    111 --
    112 
    113 CREATE TABLE "routed" (
    114         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
    115         "maskbits" integer DEFAULT 128,
    116         "city" character varying(30) DEFAULT '',
    117         Constraint "routed_pkey" Primary Key ("cidr")
    118 );
    119 
    120 --
    121 -- TOC Entry ID 8 (OID 31131)
    122 --
    123 -- Name: temp Type: TABLE Owner: ipdb
    124 --
    125 
    126 CREATE TABLE "temp" (
    127         "ofs" integer
    128 );
    129 
Note: See TracChangeset for help on using the changeset viewer.