Changeset 74 for trunk/cgi-bin/ipdb.psql
- Timestamp:
- 11/16/04 15:10:08 (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/cgi-bin/ipdb.psql
r57 r74 23 23 24 24 -- 25 -- TOC Entry ID 2 (OID 25848) 26 -- 27 -- Name: allocations Type: TABLE Owner: ipdb 28 -- 29 30 CREATE TABLE "allocations" ( 31 "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL, 32 "custid" character varying(16) DEFAULT '', 33 "type" character(2) DEFAULT '', 34 "city" character varying(30) DEFAULT '', 35 "description" character varying(64) DEFAULT '', 36 "notes" text, 37 "maskbits" integer DEFAULT 128, 38 Constraint "allocations_pkey" Primary Key ("cidr") 39 ); 40 41 -- 42 -- TOC Entry ID 3 (OID 25848) 43 -- 44 -- Name: allocations Type: ACL Owner: 45 -- 46 47 REVOKE ALL on "allocations" from PUBLIC; 48 GRANT ALL on "allocations" to "kdeugau"; 49 GRANT ALL on "allocations" to "ipdb"; 50 51 -- 52 -- TOC Entry ID 4 (OID 25854) 25 -- TOC Entry ID 2 (OID 25854) 53 26 -- 54 27 -- Name: customers Type: TABLE Owner: ipdb … … 71 44 72 45 -- 73 -- TOC Entry ID 5(OID 25854)46 -- TOC Entry ID 3 (OID 25854) 74 47 -- 75 48 -- Name: customers Type: ACL Owner: … … 81 54 82 55 -- 83 -- TOC Entry ID 6 (OID 25866) 56 -- TOC Entry ID 4 (OID 25872) 57 -- 58 -- Name: masterblocks Type: TABLE Owner: ipdb 59 -- 60 61 CREATE TABLE "masterblocks" ( 62 "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL, 63 Constraint "masterblocks_pkey" Primary Key ("cidr") 64 ); 65 66 -- 67 -- TOC Entry ID 5 (OID 25872) 68 -- 69 -- Name: masterblocks Type: ACL Owner: 70 -- 71 72 REVOKE ALL on "masterblocks" from PUBLIC; 73 GRANT ALL on "masterblocks" to "kdeugau"; 74 GRANT ALL on "masterblocks" to "ipdb"; 75 76 -- 77 -- TOC Entry ID 6 (OID 25875) 78 -- 79 -- Name: routed Type: TABLE Owner: ipdb 80 -- 81 82 CREATE TABLE "routed" ( 83 "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL, 84 "maskbits" integer DEFAULT 128, 85 "city" character varying(30) DEFAULT '', 86 Constraint "routed_pkey" Primary Key ("cidr") 87 ); 88 89 -- 90 -- TOC Entry ID 7 (OID 25875) 91 -- 92 -- Name: routed Type: ACL Owner: 93 -- 94 95 REVOKE ALL on "routed" from PUBLIC; 96 GRANT ALL on "routed" to "kdeugau"; 97 GRANT ALL on "routed" to "ipdb"; 98 99 -- 100 -- TOC Entry ID 8 (OID 31131) 101 -- 102 -- Name: temp Type: TABLE Owner: ipdb 103 -- 104 105 CREATE TABLE "temp" ( 106 "ofs" integer 107 ); 108 109 -- 110 -- TOC Entry ID 9 (OID 31131) 111 -- 112 -- Name: temp Type: ACL Owner: 113 -- 114 115 REVOKE ALL on "temp" from PUBLIC; 116 GRANT ALL on "temp" to "kdeugau"; 117 GRANT ALL on "temp" to "ipdb"; 118 119 -- 120 -- TOC Entry ID 10 (OID 73917) 121 -- 122 -- Name: searchme Type: VIEW Owner: ipdb 123 -- 124 125 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; 126 127 -- 128 -- TOC Entry ID 11 (OID 73917) 129 -- 130 -- Name: searchme Type: ACL Owner: 131 -- 132 133 REVOKE ALL on "searchme" from PUBLIC; 134 GRANT ALL on "searchme" to "kdeugau"; 135 GRANT ALL on "searchme" to "ipdb"; 136 137 -- 138 -- TOC Entry ID 12 (OID 91065) 139 -- 140 -- Name: freeblocks Type: TABLE Owner: ipdb 141 -- 142 143 CREATE TABLE "freeblocks" ( 144 "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL, 145 "maskbits" integer DEFAULT 128, 146 "city" character varying(30) DEFAULT '', 147 "routed" character(1) DEFAULT 'n', 148 Constraint "freeblocks_pkey" Primary Key ("cidr") 149 ); 150 151 -- 152 -- TOC Entry ID 13 (OID 91065) 153 -- 154 -- Name: freeblocks Type: ACL Owner: 155 -- 156 157 REVOKE ALL on "freeblocks" from PUBLIC; 158 GRANT ALL on "freeblocks" to "kdeugau"; 159 GRANT ALL on "freeblocks" to "ipdb"; 160 161 -- 162 -- TOC Entry ID 14 (OID 92444) 84 163 -- 85 164 -- Name: poolips Type: TABLE Owner: ipdb … … 93 172 "ptype" character(1) DEFAULT 'c' NOT NULL, 94 173 "available" character(1) DEFAULT 'y', 95 "notes" text ,174 "notes" text DEFAULT '', 96 175 "description" character varying(64) DEFAULT '', 176 "circuitid" character varying(128) DEFAULT '', 97 177 CHECK (((available = 'y'::bpchar) OR (available = 'n'::bpchar))), 98 178 Constraint "poolips_pkey" Primary Key ("ip") … … 100 180 101 181 -- 102 -- TOC Entry ID 7 (OID 25866)182 -- TOC Entry ID 15 (OID 92444) 103 183 -- 104 184 -- Name: poolips Type: ACL Owner: … … 110 190 111 191 -- 112 -- TOC Entry ID 8 (OID 25872) 113 -- 114 -- Name: masterblocks Type: TABLE Owner: ipdb 115 -- 116 117 CREATE 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 128 REVOKE ALL on "masterblocks" from PUBLIC; 129 GRANT ALL on "masterblocks" to "kdeugau"; 130 GRANT ALL on "masterblocks" to "ipdb"; 131 132 -- 133 -- TOC Entry ID 10 (OID 25875) 134 -- 135 -- Name: routed Type: TABLE Owner: ipdb 136 -- 137 138 CREATE TABLE "routed" ( 139 "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL, 192 -- TOC Entry ID 16 (OID 92725) 193 -- 194 -- Name: allocations Type: TABLE Owner: ipdb 195 -- 196 197 CREATE TABLE "allocations" ( 198 "cidr" cidr DEFAULT '255.255.255.255/32' NOT NULL, 199 "custid" character varying(16) DEFAULT '', 200 "type" character(2) DEFAULT '', 201 "city" character varying(30) DEFAULT '', 202 "description" character varying(64) DEFAULT '', 203 "notes" text DEFAULT '', 140 204 "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 151 REVOKE ALL on "routed" from PUBLIC; 152 GRANT ALL on "routed" to "kdeugau"; 153 GRANT ALL on "routed" to "ipdb"; 154 155 -- 156 -- TOC Entry ID 12 (OID 31131) 157 -- 158 -- Name: temp Type: TABLE Owner: ipdb 159 -- 160 161 CREATE TABLE "temp" ( 162 "ofs" integer 163 ); 164 165 -- 166 -- TOC Entry ID 13 (OID 31131) 167 -- 168 -- Name: temp Type: ACL Owner: 169 -- 170 171 REVOKE ALL on "temp" from PUBLIC; 172 GRANT ALL on "temp" to "kdeugau"; 173 GRANT ALL on "temp" to "ipdb"; 174 175 -- 176 -- TOC Entry ID 14 (OID 73917) 177 -- 178 -- Name: searchme Type: VIEW Owner: ipdb 179 -- 180 181 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; 182 183 -- 184 -- TOC Entry ID 15 (OID 73917) 185 -- 186 -- Name: searchme Type: ACL Owner: 187 -- 188 189 REVOKE ALL on "searchme" from PUBLIC; 190 GRANT ALL on "searchme" to "kdeugau"; 191 GRANT ALL on "searchme" to "ipdb"; 192 193 -- 194 -- TOC Entry ID 16 (OID 91065) 195 -- 196 -- Name: freeblocks Type: TABLE Owner: ipdb 197 -- 198 199 CREATE 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 213 REVOKE ALL on "freeblocks" from PUBLIC; 214 GRANT ALL on "freeblocks" to "kdeugau"; 215 GRANT ALL on "freeblocks" to "ipdb"; 216 205 "circuitid" character varying(128) DEFAULT '', 206 Constraint "allocations_pkey" Primary Key ("cidr") 207 ); 208 209 -- 210 -- TOC Entry ID 17 (OID 92725) 211 -- 212 -- Name: allocations Type: ACL Owner: 213 -- 214 215 REVOKE ALL on "allocations" from PUBLIC; 216 GRANT ALL on "allocations" to "kdeugau"; 217 GRANT ALL on "allocations" to "ipdb"; 218
Note:
See TracChangeset
for help on using the changeset viewer.