Changeset 57


Ignore:
Timestamp:
11/10/04 16:54:02 (20 years ago)
Author:
Kris Deugau
Message:

/trunk

Updated schema dump for IPDB

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/cgi-bin/ipdb.psql

    r34 r57  
    55
    66--
    7 -- TOC Entry ID 18 (OID 16559)
     7-- TOC Entry ID 18 (OID 16556)
    88--
    99-- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
    … …  
    1313
    1414--
    15 -- TOC Entry ID 19 (OID 16560)
     15-- TOC Entry ID 19 (OID 16557)
    1616--
    1717-- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
    … …  
    2323
    2424--
    25 -- TOC Entry ID 2 (OID 16561)
     25-- TOC Entry ID 2 (OID 25848)
    2626--
    2727-- Name: allocations Type: TABLE Owner: ipdb
    … …  
    4040
    4141--
    42 -- TOC Entry ID 3 (OID 16561)
     42-- TOC Entry ID 3 (OID 25848)
    4343--
    4444-- Name: allocations Type: ACL Owner:
    … …  
    4646
    4747REVOKE ALL on "allocations" from PUBLIC;
     48GRANT ALL on "allocations" to "kdeugau";
    4849GRANT ALL on "allocations" to "ipdb";
    49 GRANT ALL on "allocations" to "kdeugau";
    50 
    51 --
    52 -- TOC Entry ID 4 (OID 16567)
     50
     51--
     52-- TOC Entry ID 4 (OID 25854)
    5353--
    5454-- Name: customers Type: TABLE Owner: ipdb
    … …  
    7171
    7272--
    73 -- TOC Entry ID 5 (OID 16567)
     73-- TOC Entry ID 5 (OID 25854)
    7474--
    7575-- Name: customers Type: ACL Owner:
    … …  
    7777
    7878REVOKE ALL on "customers" from PUBLIC;
     79GRANT ALL on "customers" to "kdeugau";
    7980GRANT ALL on "customers" to "ipdb";
    80 GRANT ALL on "customers" to "kdeugau";
    81 
    82 --
    83 -- TOC Entry ID 6 (OID 16573)
    84 --
    85 -- Name: freeblocks Type: TABLE Owner: ipdb
    86 --
    87 
    88 CREATE TABLE "freeblocks" (
    89         "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
    90         "maskbits" integer DEFAULT 128,
    91         "city" character varying(30) DEFAULT '',
    92         "routed" character(1) DEFAULT 'n',
    93         CHECK (((routed = 'y'::bpchar) OR (routed = 'n'::bpchar))),
    94         Constraint "freeblocks_pkey" Primary Key ("cidr")
    95 );
    96 
    97 --
    98 -- TOC Entry ID 7 (OID 16573)
    99 --
    100 -- Name: freeblocks Type: ACL Owner:
    101 --
    102 
    103 REVOKE ALL on "freeblocks" from PUBLIC;
    104 GRANT ALL on "freeblocks" to "ipdb";
    105 GRANT ALL on "freeblocks" to "kdeugau";
    106 
    107 --
    108 -- TOC Entry ID 8 (OID 16585)
    109 --
    110 -- Name: masterblocks Type: TABLE Owner: ipdb
    111 --
    112 
    113 CREATE 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 
    124 REVOKE ALL on "masterblocks" from PUBLIC;
    125 GRANT ALL on "masterblocks" to "ipdb";
    126 GRANT ALL on "masterblocks" to "kdeugau";
    127 
    128 --
    129 -- TOC Entry ID 10 (OID 16588)
    130 --
    131 -- Name: routed Type: TABLE Owner: ipdb
    132 --
    133 
    134 CREATE 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 
    147 REVOKE ALL on "routed" from PUBLIC;
    148 GRANT ALL on "routed" to "ipdb";
    149 GRANT ALL on "routed" to "kdeugau";
    150 
    151 --
    152 -- TOC Entry ID 12 (OID 16594)
    153 --
    154 -- Name: temp Type: TABLE Owner: ipdb
    155 --
    156 
    157 CREATE TABLE "temp" (
    158         "ofs" integer
    159 );
    160 
    161 --
    162 -- TOC Entry ID 13 (OID 16594)
    163 --
    164 -- Name: temp Type: ACL Owner:
    165 --
    166 
    167 REVOKE ALL on "temp" from PUBLIC;
    168 GRANT ALL on "temp" to "ipdb";
    169 GRANT ALL on "temp" to "kdeugau";
    170 
    171 --
    172 -- TOC Entry ID 14 (OID 16598)
    173 --
    174 -- Name: searchme Type: VIEW Owner: ipdb
    175 --
    176 
    177 CREATE 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 
    185 REVOKE ALL on "searchme" from PUBLIC;
    186 GRANT ALL on "searchme" to "ipdb";
    187 GRANT ALL on "searchme" to "kdeugau";
    188 
    189 --
    190 -- TOC Entry ID 16 (OID 19130)
    191 --
    192 -- Name: temp2 Type: TABLE Owner: ipdb
    193 --
    194 
    195 CREATE 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)
     81
     82--
     83-- TOC Entry ID 6 (OID 25866)
    20884--
    20985-- Name: poolips Type: TABLE Owner: ipdb
    … …  
    22399);
    224100
     101--
     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)
     113--
     114-- Name: masterblocks Type: TABLE Owner: ipdb
     115--
     116
     117CREATE TABLE "masterblocks" (
     118        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
     119        Constraint "masterblocks_pkey" Primary Key ("cidr")
     120);
     121
     122--
     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)
     134--
     135-- Name: routed Type: TABLE Owner: ipdb
     136--
     137
     138CREATE TABLE "routed" (
     139        "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL,
     140        "maskbits" integer DEFAULT 128,
     141        "city" character varying(30) DEFAULT '',
     142        Constraint "routed_pkey" Primary Key ("cidr")
     143);
     144
     145--
     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)
     157--
     158-- Name: temp Type: TABLE Owner: ipdb
     159--
     160
     161CREATE TABLE "temp" (
     162        "ofs" integer
     163);
     164
     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.