Changeset 59 for branches


Ignore:
Timestamp:
11/10/04 17:08:23 (20 years ago)
Author:
Kris Deugau
Message:

/branches/stable

Update IPDB schema dump from /trunk

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/stable/cgi-bin/ipdb.psql

    r4 r59  
    55
    66--
    7 -- TOC Entry ID 9 (OID 16556)
     7-- TOC Entry ID 18 (OID 16556)
    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 16557)
    1616--
    1717-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
     
    4040
    4141--
    42 -- TOC Entry ID 3 (OID 25854)
     42-- TOC Entry ID 3 (OID 25848)
     43--
     44-- Name: allocations Type: ACL Owner:
     45--
     46
     47REVOKE ALL on "allocations" from PUBLIC;
     48GRANT ALL on "allocations" to "kdeugau";
     49GRANT ALL on "allocations" to "ipdb";
     50
     51--
     52-- TOC Entry ID 4 (OID 25854)
    4353--
    4454-- Name: customers Type: TABLE Owner: ipdb
     
    6171
    6272--
    63 -- TOC Entry ID 4 (OID 25860)
    64 --
    65 -- Name: freeblocks Type: TABLE Owner: ipdb
    66 --
    67 
    68 CREATE TABLE "freeblocks" (
    69         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
    70         "maskbits" integer DEFAULT 128,
    71         "city" character varying(30) DEFAULT '',
    72         "routed" character(1) DEFAULT 'n',
    73         CHECK (((routed = 'y'::bpchar) OR (routed = 'n'::bpchar))),
    74         Constraint "freeblocks_pkey" Primary Key ("cidr")
    75 );
    76 
    77 --
    78 -- TOC Entry ID 5 (OID 25866)
     73-- TOC Entry ID 5 (OID 25854)
     74--
     75-- Name: customers Type: ACL Owner:
     76--
     77
     78REVOKE ALL on "customers" from PUBLIC;
     79GRANT ALL on "customers" to "kdeugau";
     80GRANT ALL on "customers" to "ipdb";
     81
     82--
     83-- TOC Entry ID 6 (OID 25866)
    7984--
    8085-- Name: poolips Type: TABLE Owner: ipdb
     
    8994        "available" character(1) DEFAULT 'y',
    9095        "notes" text,
    91         CHECK ((((ptype = 'c'::bpchar) OR (ptype = 'd'::bpchar)) OR (ptype = 's'::bpchar))),
     96        "description" character varying(64) DEFAULT '',
    9297        CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))),
    9398        Constraint "poolips_pkey" Primary Key ("ip")
     
    95100
    96101--
    97 -- TOC Entry ID 6 (OID 25872)
     102-- TOC Entry ID 7 (OID 25866)
     103--
     104-- Name: poolips Type: ACL Owner:
     105--
     106
     107REVOKE ALL on "poolips" from PUBLIC;
     108GRANT ALL on "poolips" to "kdeugau";
     109GRANT ALL on "poolips" to "ipdb";
     110
     111--
     112-- TOC Entry ID 8 (OID 25872)
    98113--
    99114-- Name: masterblocks Type: TABLE Owner: ipdb
     
    106121
    107122--
    108 -- TOC Entry ID 7 (OID 25875)
     123-- TOC Entry ID 9 (OID 25872)
     124--
     125-- Name: masterblocks Type: ACL Owner:
     126--
     127
     128REVOKE ALL on "masterblocks" from PUBLIC;
     129GRANT ALL on "masterblocks" to "kdeugau";
     130GRANT ALL on "masterblocks" to "ipdb";
     131
     132--
     133-- TOC Entry ID 10 (OID 25875)
    109134--
    110135-- Name: routed Type: TABLE Owner: ipdb
     
    119144
    120145--
    121 -- TOC Entry ID 8 (OID 31131)
     146-- TOC Entry ID 11 (OID 25875)
     147--
     148-- Name: routed Type: ACL Owner:
     149--
     150
     151REVOKE ALL on "routed" from PUBLIC;
     152GRANT ALL on "routed" to "kdeugau";
     153GRANT ALL on "routed" to "ipdb";
     154
     155--
     156-- TOC Entry ID 12 (OID 31131)
    122157--
    123158-- Name: temp Type: TABLE Owner: ipdb
     
    128163);
    129164
     165--
     166-- TOC Entry ID 13 (OID 31131)
     167--
     168-- Name: temp Type: ACL Owner:
     169--
     170
     171REVOKE ALL on "temp" from PUBLIC;
     172GRANT ALL on "temp" to "kdeugau";
     173GRANT ALL on "temp" to "ipdb";
     174
     175--
     176-- TOC Entry ID 14 (OID 73917)
     177--
     178-- Name: searchme Type: VIEW Owner: ipdb
     179--
     180
     181CREATE 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;
     182
     183--
     184-- TOC Entry ID 15 (OID 73917)
     185--
     186-- Name: searchme Type: ACL Owner:
     187--
     188
     189REVOKE ALL on "searchme" from PUBLIC;
     190GRANT ALL on "searchme" to "kdeugau";
     191GRANT ALL on "searchme" to "ipdb";
     192
     193--
     194-- TOC Entry ID 16 (OID 91065)
     195--
     196-- Name: freeblocks Type: TABLE Owner: ipdb
     197--
     198
     199CREATE TABLE "freeblocks" (
     200        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
     201        "maskbits" integer DEFAULT 128,
     202        "city" character varying(30) DEFAULT '',
     203        "routed" character(1) DEFAULT 'n',
     204        Constraint "freeblocks_pkey" Primary Key ("cidr")
     205);
     206
     207--
     208-- TOC Entry ID 17 (OID 91065)
     209--
     210-- Name: freeblocks Type: ACL Owner:
     211--
     212
     213REVOKE ALL on "freeblocks" from PUBLIC;
     214GRANT ALL on "freeblocks" to "kdeugau";
     215GRANT ALL on "freeblocks" to "ipdb";
     216
Note: See TracChangeset for help on using the changeset viewer.