Changeset 544 for branches/stable/dns.sql
- Timestamp:
- 12/10/13 17:15:56 (10 years ago)
- Location:
- branches/stable
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/stable
-
branches/stable/dns.sql
r215 r544 41 41 \. 42 42 43 CREATE TABLE default_rev_records ( 44 record_id serial NOT NULL, 45 group_id integer DEFAULT 1 NOT NULL, 46 host text DEFAULT '' NOT NULL, 47 "type" integer DEFAULT 1 NOT NULL, 48 val text DEFAULT '' NOT NULL, 49 ttl integer DEFAULT 86400 NOT NULL, 50 description text 51 ); 52 53 COPY default_rev_records (record_id, group_id, host, "type", val, ttl, description) FROM stdin; 54 1 1 hostmaster.ADMINDOMAIN:ns1.ADMINDOMAIN 6 3600:900:1048576:2560 3600 55 2 1 unused-%r.ADMINDOMAIN 65283 ZONE 3600 56 \. 57 43 58 CREATE TABLE domains ( 44 59 domain_id serial NOT NULL, 45 60 "domain" character varying(80) NOT NULL, 61 group_id integer DEFAULT 1 NOT NULL, 62 description character varying(255) DEFAULT ''::character varying NOT NULL, 63 status integer DEFAULT 1 NOT NULL, 64 zserial integer, 65 sertype character(1) DEFAULT 'D'::bpchar 66 ); 67 68 CREATE TABLE revzones ( 69 rdns_id serial NOT NULL, 70 revnet cidr NOT NULL, 46 71 group_id integer DEFAULT 1 NOT NULL, 47 72 description character varying(255) DEFAULT ''::character varying NOT NULL, … … 69 94 log_id serial NOT NULL, 70 95 domain_id integer, 96 rdns_id integer, 71 97 user_id integer, 72 98 group_id integer, … … 103 129 \. 104 130 105 -- fixme: need to handle looooong records (eg, SPF)131 -- rdns_id defaults to 0 since many records will not have an associated rDNS entry. 106 132 CREATE TABLE records ( 107 domain_id integer NOT NULL, 133 domain_id integer NOT NULL DEFAULT 0, 134 rdns_id integer NOT NULL DEFAULT 0, 108 135 record_id serial NOT NULL, 109 136 host text DEFAULT '' NOT NULL, … … 119 146 CREATE TABLE rectypes ( 120 147 val integer NOT NULL, 121 name character varying( 12) NOT NULL,148 name character varying(20) NOT NULL, 122 149 stdflag integer DEFAULT 1 NOT NULL, 123 150 listorder integer DEFAULT 255 NOT NULL, … … 129 156 COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin; 130 157 1 A 1 1 1 131 2 NS 1 2 37 132 3 MD 2 255 29 133 4 MF 2 255 30 134 5 CNAME 1 6 9 135 6 SOA 0 8 53 136 7 MB 3 255 28 137 8 MG 3 255 31 138 9 MR 3 255 33 139 10 NULL 3 255 43 140 11 WKS 3 255 64 141 12 PTR 2 4 46 142 13 HINFO 3 255 18 143 14 MINFO 3 255 32 144 15 MX 1 3 34 145 16 TXT 1 5 60 146 17 RP 2 255 48 147 18 AFSDB 3 255 4 148 19 X25 3 255 65 149 20 ISDN 3 255 21 150 21 RT 3 255 50 151 22 NSAP 3 255 38 152 23 NSAP-PTR 3 255 39 153 24 SIG 3 255 51 154 25 KEY 3 255 23 155 26 PX 3 255 47 156 27 GPOS 3 255 17 157 28 AAAA 1 2 3 158 29 LOC 3 255 25 159 30 NXT 3 255 44 160 31 EID 3 255 15 161 32 NIMLOC 3 255 36 162 33 SRV 1 7 55 163 34 ATMA 3 255 6 164 35 NAPTR 3 255 35 165 36 KX 3 255 24 166 37 CERT 3 255 8 167 38 A6 3 3 2 168 39 DNAME 3 255 12 169 40 SINK 3 255 52 170 41 OPT 3 255 45 171 42 APL 3 255 5 172 43 DS 3 255 14 173 44 SSHFP 3 255 56 174 45 IPSECKEY 3 255 20 175 46 RRSIG 3 255 49 176 47 NSEC 3 255 40 177 48 DNSKEY 3 255 13 178 49 DHCID 3 255 10 179 50 NSEC3 3 255 41 180 51 NSEC3PARAM 3 255 42 181 55 HIP 3 255 19 182 99 SPF 3 255 54 183 100 UINFO 3 255 62 184 101 UID 3 255 61 185 102 GID 3 255 16 186 103 UNSPEC 3 255 63 187 249 TKEY 3 255 58 188 250 TSIG 3 255 59 189 251 IXFR 3 255 22 190 252 AXFR 3 255 7 191 253 MAILB 3 255 27 192 254 MAILA 3 255 26 193 32768 TA 3 255 57 194 32769 DLV 3 255 11 158 2 NS 1 5 37 159 3 MD 5 255 29 160 4 MF 5 255 30 161 5 CNAME 1 7 9 162 6 SOA 0 0 53 163 7 MB 5 255 28 164 8 MG 5 255 31 165 9 MR 5 255 33 166 10 NULL 5 255 43 167 11 WKS 5 255 64 168 12 PTR 3 10 46 169 13 HINFO 5 255 18 170 14 MINFO 5 255 32 171 15 MX 1 6 34 172 16 TXT 1 8 60 173 17 RP 4 255 48 174 18 AFSDB 5 255 4 175 19 X25 5 255 65 176 20 ISDN 5 255 21 177 21 RT 5 255 50 178 22 NSAP 5 255 38 179 23 NSAP-PTR 5 255 39 180 24 SIG 5 255 51 181 25 KEY 5 255 23 182 26 PX 5 255 47 183 27 GPOS 5 255 17 184 28 AAAA 1 3 3 185 29 LOC 5 255 25 186 30 NXT 5 255 44 187 31 EID 5 255 15 188 32 NIMLOC 5 255 36 189 33 SRV 1 9 55 190 34 ATMA 5 255 6 191 35 NAPTR 5 255 35 192 36 KX 5 255 24 193 37 CERT 5 255 8 194 38 A6 5 3 2 195 39 DNAME 5 255 12 196 40 SINK 5 255 52 197 41 OPT 5 255 45 198 42 APL 5 255 5 199 43 DS 5 255 14 200 44 SSHFP 5 255 56 201 45 IPSECKEY 5 255 20 202 46 RRSIG 5 255 49 203 47 NSEC 5 255 40 204 48 DNSKEY 5 255 13 205 49 DHCID 5 255 10 206 50 NSEC3 5 255 41 207 51 NSEC3PARAM 5 255 42 208 55 HIP 5 255 19 209 99 SPF 5 255 54 210 100 UINFO 5 255 62 211 101 UID 5 255 61 212 102 GID 5 255 16 213 103 UNSPEC 5 255 63 214 249 TKEY 5 255 58 215 250 TSIG 5 255 59 216 251 IXFR 5 255 22 217 252 AXFR 5 255 7 218 253 MAILB 5 255 27 219 254 MAILA 5 255 26 220 32768 TA 5 255 57 221 32769 DLV 5 255 11 222 \. 223 224 -- Custom types (ab)using the "Private use" range from 65280 to 65534 225 COPY rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin; 226 65280 A+PTR 2 2 2 227 65281 AAAA+PTR 2 4 4 228 65282 PTR template 3 11 2 229 65283 A+PTR template 3 12 2 230 65284 AAAA+PTR template 3 13 2 195 231 \. 196 232 … … 254 290 ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id); 255 291 256 ALTER TABLE ONLY records257 ADD CONSTRAINT "$1" FOREIGN KEY (domain_id) REFERENCES domains(domain_id);258 259 292 ALTER TABLE ONLY users 260 293 ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id); … … 264 297 265 298 -- set starting sequence numbers, since we've inserted data before they're active 266 SELECT pg_catalog.setval('misc_misc_id_seq', 1, true); 267 SELECT pg_catalog.setval('default_records_record_id_seq', 8, true); 299 SELECT pg_catalog.setval('misc_misc_id_seq', 2, false); 300 SELECT pg_catalog.setval('default_records_record_id_seq', 8, false); 301 SELECT pg_catalog.setval('default_rev_records_record_id_seq', 3, false); 268 302 SELECT pg_catalog.setval('domains_domain_id_seq', 1, false); 269 SELECT pg_catalog.setval('groups_group_id_seq', 1, true);270 SELECT pg_catalog.setval('permissions_permission_id_seq', 2, true);303 SELECT pg_catalog.setval('groups_group_id_seq', 2, false); 304 SELECT pg_catalog.setval('permissions_permission_id_seq', 3, false); 271 305 SELECT pg_catalog.setval('records_record_id_seq', 1, false); 272 306 SELECT pg_catalog.setval('users_user_id_seq', 2, false);
Note:
See TracChangeset
for help on using the changeset viewer.