| 1 | --
|
|---|
| 2 | -- PostgreSQL database dump
|
|---|
| 3 | --
|
|---|
| 4 |
|
|---|
| 5 | -- Dumped from database version 9.6.24
|
|---|
| 6 | -- Dumped by pg_dump version 9.6.24
|
|---|
| 7 |
|
|---|
| 8 | SET statement_timeout = 0;
|
|---|
| 9 | SET lock_timeout = 0;
|
|---|
| 10 | SET idle_in_transaction_session_timeout = 0;
|
|---|
| 11 | SET client_encoding = 'UTF8';
|
|---|
| 12 | SET standard_conforming_strings = on;
|
|---|
| 13 | SELECT pg_catalog.set_config('search_path', '', false);
|
|---|
| 14 | SET check_function_bodies = false;
|
|---|
| 15 | SET xmloption = content;
|
|---|
| 16 | SET client_min_messages = warning;
|
|---|
| 17 | SET row_security = off;
|
|---|
| 18 |
|
|---|
| 19 | --
|
|---|
| 20 | -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
|
|---|
| 21 | --
|
|---|
| 22 |
|
|---|
| 23 | CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
|
|---|
| 24 |
|
|---|
| 25 |
|
|---|
| 26 | --
|
|---|
| 27 | -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
|
|---|
| 28 | --
|
|---|
| 29 |
|
|---|
| 30 | COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
|
|---|
| 31 |
|
|---|
| 32 |
|
|---|
| 33 | --
|
|---|
| 34 | -- Name: inetlazy(text); Type: FUNCTION; Schema: public; Owner: dnstest
|
|---|
| 35 | --
|
|---|
| 36 |
|
|---|
| 37 | CREATE FUNCTION public.inetlazy(rdata text) RETURNS inet
|
|---|
| 38 | LANGUAGE plpgsql
|
|---|
| 39 | AS $$
|
|---|
| 40 | BEGIN
|
|---|
| 41 | RETURN CAST(rdata AS inet);
|
|---|
| 42 | EXCEPTION
|
|---|
| 43 | WHEN OTHERS THEN
|
|---|
| 44 | RETURN CAST('0.0.0.0/0' AS inet);
|
|---|
| 45 | END;
|
|---|
| 46 | $$;
|
|---|
| 47 |
|
|---|
| 48 |
|
|---|
| 49 | ALTER FUNCTION public.inetlazy(rdata text) OWNER TO dnstest;
|
|---|
| 50 |
|
|---|
| 51 | SET default_tablespace = '';
|
|---|
| 52 |
|
|---|
| 53 | SET default_with_oids = false;
|
|---|
| 54 |
|
|---|
| 55 | --
|
|---|
| 56 | -- Name: default_records; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 57 | --
|
|---|
| 58 |
|
|---|
| 59 | CREATE TABLE public.default_records (
|
|---|
| 60 | record_id integer NOT NULL,
|
|---|
| 61 | group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 62 | host text DEFAULT ''::text NOT NULL,
|
|---|
| 63 | type integer DEFAULT 1 NOT NULL,
|
|---|
| 64 | val text DEFAULT ''::text NOT NULL,
|
|---|
| 65 | distance integer DEFAULT 0 NOT NULL,
|
|---|
| 66 | weight integer DEFAULT 0 NOT NULL,
|
|---|
| 67 | port integer DEFAULT 0 NOT NULL,
|
|---|
| 68 | ttl integer DEFAULT 86400 NOT NULL,
|
|---|
| 69 | description text
|
|---|
| 70 | );
|
|---|
| 71 |
|
|---|
| 72 |
|
|---|
| 73 | ALTER TABLE public.default_records OWNER TO dnstest;
|
|---|
| 74 |
|
|---|
| 75 | --
|
|---|
| 76 | -- Name: default_records_record_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 77 | --
|
|---|
| 78 |
|
|---|
| 79 | CREATE SEQUENCE public.default_records_record_id_seq
|
|---|
| 80 | START WITH 1
|
|---|
| 81 | INCREMENT BY 1
|
|---|
| 82 | NO MINVALUE
|
|---|
| 83 | NO MAXVALUE
|
|---|
| 84 | CACHE 1;
|
|---|
| 85 |
|
|---|
| 86 |
|
|---|
| 87 | ALTER TABLE public.default_records_record_id_seq OWNER TO dnstest;
|
|---|
| 88 |
|
|---|
| 89 | --
|
|---|
| 90 | -- Name: default_records_record_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 91 | --
|
|---|
| 92 |
|
|---|
| 93 | ALTER SEQUENCE public.default_records_record_id_seq OWNED BY public.default_records.record_id;
|
|---|
| 94 |
|
|---|
| 95 |
|
|---|
| 96 | --
|
|---|
| 97 | -- Name: default_rev_records; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 98 | --
|
|---|
| 99 |
|
|---|
| 100 | CREATE TABLE public.default_rev_records (
|
|---|
| 101 | record_id integer NOT NULL,
|
|---|
| 102 | group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 103 | host text DEFAULT ''::text NOT NULL,
|
|---|
| 104 | type integer DEFAULT 1 NOT NULL,
|
|---|
| 105 | val text DEFAULT ''::text NOT NULL,
|
|---|
| 106 | ttl integer DEFAULT 86400 NOT NULL,
|
|---|
| 107 | description text
|
|---|
| 108 | );
|
|---|
| 109 |
|
|---|
| 110 |
|
|---|
| 111 | ALTER TABLE public.default_rev_records OWNER TO dnstest;
|
|---|
| 112 |
|
|---|
| 113 | --
|
|---|
| 114 | -- Name: default_rev_records_record_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 115 | --
|
|---|
| 116 |
|
|---|
| 117 | CREATE SEQUENCE public.default_rev_records_record_id_seq
|
|---|
| 118 | START WITH 1
|
|---|
| 119 | INCREMENT BY 1
|
|---|
| 120 | NO MINVALUE
|
|---|
| 121 | NO MAXVALUE
|
|---|
| 122 | CACHE 1;
|
|---|
| 123 |
|
|---|
| 124 |
|
|---|
| 125 | ALTER TABLE public.default_rev_records_record_id_seq OWNER TO dnstest;
|
|---|
| 126 |
|
|---|
| 127 | --
|
|---|
| 128 | -- Name: default_rev_records_record_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 129 | --
|
|---|
| 130 |
|
|---|
| 131 | ALTER SEQUENCE public.default_rev_records_record_id_seq OWNED BY public.default_rev_records.record_id;
|
|---|
| 132 |
|
|---|
| 133 |
|
|---|
| 134 | --
|
|---|
| 135 | -- Name: domains; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 136 | --
|
|---|
| 137 |
|
|---|
| 138 | CREATE TABLE public.domains (
|
|---|
| 139 | domain_id integer NOT NULL,
|
|---|
| 140 | domain character varying(80) NOT NULL,
|
|---|
| 141 | group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 142 | description character varying(255) DEFAULT ''::character varying NOT NULL,
|
|---|
| 143 | status integer DEFAULT 1 NOT NULL,
|
|---|
| 144 | zserial integer,
|
|---|
| 145 | sertype character(1) DEFAULT 'D'::bpchar,
|
|---|
| 146 | changed boolean DEFAULT true NOT NULL,
|
|---|
| 147 | default_location character varying(4) DEFAULT ''::character varying NOT NULL
|
|---|
| 148 | );
|
|---|
| 149 |
|
|---|
| 150 |
|
|---|
| 151 | ALTER TABLE public.domains OWNER TO dnstest;
|
|---|
| 152 |
|
|---|
| 153 | --
|
|---|
| 154 | -- Name: domains_domain_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 155 | --
|
|---|
| 156 |
|
|---|
| 157 | CREATE SEQUENCE public.domains_domain_id_seq
|
|---|
| 158 | START WITH 1
|
|---|
| 159 | INCREMENT BY 1
|
|---|
| 160 | NO MINVALUE
|
|---|
| 161 | NO MAXVALUE
|
|---|
| 162 | CACHE 1;
|
|---|
| 163 |
|
|---|
| 164 |
|
|---|
| 165 | ALTER TABLE public.domains_domain_id_seq OWNER TO dnstest;
|
|---|
| 166 |
|
|---|
| 167 | --
|
|---|
| 168 | -- Name: domains_domain_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 169 | --
|
|---|
| 170 |
|
|---|
| 171 | ALTER SEQUENCE public.domains_domain_id_seq OWNED BY public.domains.domain_id;
|
|---|
| 172 |
|
|---|
| 173 |
|
|---|
| 174 | --
|
|---|
| 175 | -- Name: groups; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 176 | --
|
|---|
| 177 |
|
|---|
| 178 | CREATE TABLE public.groups (
|
|---|
| 179 | group_id integer NOT NULL,
|
|---|
| 180 | parent_group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 181 | group_name character varying(255) DEFAULT ''::character varying NOT NULL,
|
|---|
| 182 | permission_id integer DEFAULT 1 NOT NULL,
|
|---|
| 183 | inherit_perm boolean DEFAULT true NOT NULL
|
|---|
| 184 | );
|
|---|
| 185 |
|
|---|
| 186 |
|
|---|
| 187 | ALTER TABLE public.groups OWNER TO dnstest;
|
|---|
| 188 |
|
|---|
| 189 | --
|
|---|
| 190 | -- Name: groups_group_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 191 | --
|
|---|
| 192 |
|
|---|
| 193 | CREATE SEQUENCE public.groups_group_id_seq
|
|---|
| 194 | START WITH 1
|
|---|
| 195 | INCREMENT BY 1
|
|---|
| 196 | NO MINVALUE
|
|---|
| 197 | NO MAXVALUE
|
|---|
| 198 | CACHE 1;
|
|---|
| 199 |
|
|---|
| 200 |
|
|---|
| 201 | ALTER TABLE public.groups_group_id_seq OWNER TO dnstest;
|
|---|
| 202 |
|
|---|
| 203 | --
|
|---|
| 204 | -- Name: groups_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 205 | --
|
|---|
| 206 |
|
|---|
| 207 | ALTER SEQUENCE public.groups_group_id_seq OWNED BY public.groups.group_id;
|
|---|
| 208 |
|
|---|
| 209 |
|
|---|
| 210 | --
|
|---|
| 211 | -- Name: locations; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 212 | --
|
|---|
| 213 |
|
|---|
| 214 | CREATE TABLE public.locations (
|
|---|
| 215 | location character varying(4) NOT NULL,
|
|---|
| 216 | loc_id integer NOT NULL,
|
|---|
| 217 | group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 218 | iplist text DEFAULT ''::text NOT NULL,
|
|---|
| 219 | description character varying(40) DEFAULT ''::character varying NOT NULL,
|
|---|
| 220 | comments text DEFAULT ''::text NOT NULL
|
|---|
| 221 | );
|
|---|
| 222 |
|
|---|
| 223 |
|
|---|
| 224 | ALTER TABLE public.locations OWNER TO dnstest;
|
|---|
| 225 |
|
|---|
| 226 | --
|
|---|
| 227 | -- Name: locations_loc_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 228 | --
|
|---|
| 229 |
|
|---|
| 230 | CREATE SEQUENCE public.locations_loc_id_seq
|
|---|
| 231 | START WITH 1
|
|---|
| 232 | INCREMENT BY 1
|
|---|
| 233 | NO MINVALUE
|
|---|
| 234 | NO MAXVALUE
|
|---|
| 235 | CACHE 1;
|
|---|
| 236 |
|
|---|
| 237 |
|
|---|
| 238 | ALTER TABLE public.locations_loc_id_seq OWNER TO dnstest;
|
|---|
| 239 |
|
|---|
| 240 | --
|
|---|
| 241 | -- Name: locations_loc_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 242 | --
|
|---|
| 243 |
|
|---|
| 244 | ALTER SEQUENCE public.locations_loc_id_seq OWNED BY public.locations.loc_id;
|
|---|
| 245 |
|
|---|
| 246 |
|
|---|
| 247 | --
|
|---|
| 248 | -- Name: log; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 249 | --
|
|---|
| 250 |
|
|---|
| 251 | CREATE TABLE public.log (
|
|---|
| 252 | log_id integer NOT NULL,
|
|---|
| 253 | domain_id integer,
|
|---|
| 254 | user_id integer,
|
|---|
| 255 | group_id integer,
|
|---|
| 256 | email character varying(60),
|
|---|
| 257 | name character varying(60),
|
|---|
| 258 | entry text,
|
|---|
| 259 | stamp timestamp with time zone DEFAULT now(),
|
|---|
| 260 | rdns_id integer,
|
|---|
| 261 | logparent integer DEFAULT 0 NOT NULL
|
|---|
| 262 | );
|
|---|
| 263 |
|
|---|
| 264 |
|
|---|
| 265 | ALTER TABLE public.log OWNER TO dnstest;
|
|---|
| 266 |
|
|---|
| 267 | --
|
|---|
| 268 | -- Name: log_log_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 269 | --
|
|---|
| 270 |
|
|---|
| 271 | CREATE SEQUENCE public.log_log_id_seq
|
|---|
| 272 | START WITH 1
|
|---|
| 273 | INCREMENT BY 1
|
|---|
| 274 | NO MINVALUE
|
|---|
| 275 | NO MAXVALUE
|
|---|
| 276 | CACHE 1;
|
|---|
| 277 |
|
|---|
| 278 |
|
|---|
| 279 | ALTER TABLE public.log_log_id_seq OWNER TO dnstest;
|
|---|
| 280 |
|
|---|
| 281 | --
|
|---|
| 282 | -- Name: log_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 283 | --
|
|---|
| 284 |
|
|---|
| 285 | ALTER SEQUENCE public.log_log_id_seq OWNED BY public.log.log_id;
|
|---|
| 286 |
|
|---|
| 287 |
|
|---|
| 288 | --
|
|---|
| 289 | -- Name: misc; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 290 | --
|
|---|
| 291 |
|
|---|
| 292 | CREATE TABLE public.misc (
|
|---|
| 293 | misc_id integer NOT NULL,
|
|---|
| 294 | key text DEFAULT ''::text NOT NULL,
|
|---|
| 295 | value text DEFAULT ''::text NOT NULL
|
|---|
| 296 | );
|
|---|
| 297 |
|
|---|
| 298 |
|
|---|
| 299 | ALTER TABLE public.misc OWNER TO dnstest;
|
|---|
| 300 |
|
|---|
| 301 | --
|
|---|
| 302 | -- Name: misc_misc_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 303 | --
|
|---|
| 304 |
|
|---|
| 305 | CREATE SEQUENCE public.misc_misc_id_seq
|
|---|
| 306 | START WITH 1
|
|---|
| 307 | INCREMENT BY 1
|
|---|
| 308 | NO MINVALUE
|
|---|
| 309 | NO MAXVALUE
|
|---|
| 310 | CACHE 1;
|
|---|
| 311 |
|
|---|
| 312 |
|
|---|
| 313 | ALTER TABLE public.misc_misc_id_seq OWNER TO dnstest;
|
|---|
| 314 |
|
|---|
| 315 | --
|
|---|
| 316 | -- Name: misc_misc_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 317 | --
|
|---|
| 318 |
|
|---|
| 319 | ALTER SEQUENCE public.misc_misc_id_seq OWNED BY public.misc.misc_id;
|
|---|
| 320 |
|
|---|
| 321 |
|
|---|
| 322 | --
|
|---|
| 323 | -- Name: permissions; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 324 | --
|
|---|
| 325 |
|
|---|
| 326 | CREATE TABLE public.permissions (
|
|---|
| 327 | permission_id integer NOT NULL,
|
|---|
| 328 | admin boolean DEFAULT false NOT NULL,
|
|---|
| 329 | self_edit boolean DEFAULT false NOT NULL,
|
|---|
| 330 | group_create boolean DEFAULT false NOT NULL,
|
|---|
| 331 | group_edit boolean DEFAULT false NOT NULL,
|
|---|
| 332 | group_delete boolean DEFAULT false NOT NULL,
|
|---|
| 333 | user_create boolean DEFAULT false NOT NULL,
|
|---|
| 334 | user_edit boolean DEFAULT false NOT NULL,
|
|---|
| 335 | user_delete boolean DEFAULT false NOT NULL,
|
|---|
| 336 | domain_create boolean DEFAULT false NOT NULL,
|
|---|
| 337 | domain_edit boolean DEFAULT false NOT NULL,
|
|---|
| 338 | domain_delete boolean DEFAULT false NOT NULL,
|
|---|
| 339 | record_create boolean DEFAULT false NOT NULL,
|
|---|
| 340 | record_edit boolean DEFAULT false NOT NULL,
|
|---|
| 341 | record_delete boolean DEFAULT false NOT NULL,
|
|---|
| 342 | user_id integer,
|
|---|
| 343 | group_id integer,
|
|---|
| 344 | record_locchg boolean DEFAULT false NOT NULL,
|
|---|
| 345 | location_create boolean DEFAULT false NOT NULL,
|
|---|
| 346 | location_edit boolean DEFAULT false NOT NULL,
|
|---|
| 347 | location_delete boolean DEFAULT false NOT NULL,
|
|---|
| 348 | location_view boolean DEFAULT false NOT NULL
|
|---|
| 349 | );
|
|---|
| 350 |
|
|---|
| 351 |
|
|---|
| 352 | ALTER TABLE public.permissions OWNER TO dnstest;
|
|---|
| 353 |
|
|---|
| 354 | --
|
|---|
| 355 | -- Name: permissions_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 356 | --
|
|---|
| 357 |
|
|---|
| 358 | CREATE SEQUENCE public.permissions_permission_id_seq
|
|---|
| 359 | START WITH 1
|
|---|
| 360 | INCREMENT BY 1
|
|---|
| 361 | NO MINVALUE
|
|---|
| 362 | NO MAXVALUE
|
|---|
| 363 | CACHE 1;
|
|---|
| 364 |
|
|---|
| 365 |
|
|---|
| 366 | ALTER TABLE public.permissions_permission_id_seq OWNER TO dnstest;
|
|---|
| 367 |
|
|---|
| 368 | --
|
|---|
| 369 | -- Name: permissions_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 370 | --
|
|---|
| 371 |
|
|---|
| 372 | ALTER SEQUENCE public.permissions_permission_id_seq OWNED BY public.permissions.permission_id;
|
|---|
| 373 |
|
|---|
| 374 |
|
|---|
| 375 | --
|
|---|
| 376 | -- Name: records; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 377 | --
|
|---|
| 378 |
|
|---|
| 379 | CREATE TABLE public.records (
|
|---|
| 380 | domain_id integer DEFAULT 0 NOT NULL,
|
|---|
| 381 | record_id integer NOT NULL,
|
|---|
| 382 | host text DEFAULT ''::text NOT NULL,
|
|---|
| 383 | type integer DEFAULT 1 NOT NULL,
|
|---|
| 384 | val text DEFAULT ''::text NOT NULL,
|
|---|
| 385 | distance integer DEFAULT 0 NOT NULL,
|
|---|
| 386 | weight integer DEFAULT 0 NOT NULL,
|
|---|
| 387 | port integer DEFAULT 0 NOT NULL,
|
|---|
| 388 | ttl integer DEFAULT 7200 NOT NULL,
|
|---|
| 389 | description text,
|
|---|
| 390 | rdns_id integer DEFAULT 0 NOT NULL,
|
|---|
| 391 | location character varying(4) DEFAULT ''::character varying NOT NULL,
|
|---|
| 392 | stamp timestamp with time zone DEFAULT '1969-12-31 19:00:00-05'::timestamp with time zone NOT NULL,
|
|---|
| 393 | expires boolean DEFAULT false NOT NULL,
|
|---|
| 394 | stampactive boolean DEFAULT false NOT NULL,
|
|---|
| 395 | auxdata text
|
|---|
| 396 | );
|
|---|
| 397 |
|
|---|
| 398 |
|
|---|
| 399 | ALTER TABLE public.records OWNER TO dnstest;
|
|---|
| 400 |
|
|---|
| 401 | --
|
|---|
| 402 | -- Name: records_record_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 403 | --
|
|---|
| 404 |
|
|---|
| 405 | CREATE SEQUENCE public.records_record_id_seq
|
|---|
| 406 | START WITH 1
|
|---|
| 407 | INCREMENT BY 1
|
|---|
| 408 | NO MINVALUE
|
|---|
| 409 | NO MAXVALUE
|
|---|
| 410 | CACHE 1;
|
|---|
| 411 |
|
|---|
| 412 |
|
|---|
| 413 | ALTER TABLE public.records_record_id_seq OWNER TO dnstest;
|
|---|
| 414 |
|
|---|
| 415 | --
|
|---|
| 416 | -- Name: records_record_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 417 | --
|
|---|
| 418 |
|
|---|
| 419 | ALTER SEQUENCE public.records_record_id_seq OWNED BY public.records.record_id;
|
|---|
| 420 |
|
|---|
| 421 |
|
|---|
| 422 | --
|
|---|
| 423 | -- Name: rectypes; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 424 | --
|
|---|
| 425 |
|
|---|
| 426 | CREATE TABLE public.rectypes (
|
|---|
| 427 | val integer NOT NULL,
|
|---|
| 428 | name character varying(20) NOT NULL,
|
|---|
| 429 | stdflag integer DEFAULT 1 NOT NULL,
|
|---|
| 430 | listorder integer DEFAULT 255 NOT NULL,
|
|---|
| 431 | alphaorder integer DEFAULT 32768 NOT NULL
|
|---|
| 432 | );
|
|---|
| 433 |
|
|---|
| 434 |
|
|---|
| 435 | ALTER TABLE public.rectypes OWNER TO dnstest;
|
|---|
| 436 |
|
|---|
| 437 | --
|
|---|
| 438 | -- Name: refresh_zones; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 439 | --
|
|---|
| 440 |
|
|---|
| 441 | CREATE TABLE public.refresh_zones (
|
|---|
| 442 | zone text NOT NULL,
|
|---|
| 443 | view text DEFAULT ''::text NOT NULL,
|
|---|
| 444 | export_stamp integer DEFAULT date_part('epoch'::text, now()),
|
|---|
| 445 | reftype text DEFAULT 'update'::text
|
|---|
| 446 | );
|
|---|
| 447 |
|
|---|
| 448 |
|
|---|
| 449 | ALTER TABLE public.refresh_zones OWNER TO dnstest;
|
|---|
| 450 |
|
|---|
| 451 | --
|
|---|
| 452 | -- Name: revzones; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 453 | --
|
|---|
| 454 |
|
|---|
| 455 | CREATE TABLE public.revzones (
|
|---|
| 456 | rdns_id integer NOT NULL,
|
|---|
| 457 | revnet cidr NOT NULL,
|
|---|
| 458 | group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 459 | description character varying(255) DEFAULT ''::character varying NOT NULL,
|
|---|
| 460 | status integer DEFAULT 1 NOT NULL,
|
|---|
| 461 | zserial integer,
|
|---|
| 462 | sertype character(1) DEFAULT 'D'::bpchar,
|
|---|
| 463 | changed boolean DEFAULT true NOT NULL,
|
|---|
| 464 | default_location character varying(4) DEFAULT ''::character varying NOT NULL
|
|---|
| 465 | );
|
|---|
| 466 |
|
|---|
| 467 |
|
|---|
| 468 | ALTER TABLE public.revzones OWNER TO dnstest;
|
|---|
| 469 |
|
|---|
| 470 | --
|
|---|
| 471 | -- Name: revzones_rdns_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 472 | --
|
|---|
| 473 |
|
|---|
| 474 | CREATE SEQUENCE public.revzones_rdns_id_seq
|
|---|
| 475 | START WITH 1
|
|---|
| 476 | INCREMENT BY 1
|
|---|
| 477 | NO MINVALUE
|
|---|
| 478 | NO MAXVALUE
|
|---|
| 479 | CACHE 1;
|
|---|
| 480 |
|
|---|
| 481 |
|
|---|
| 482 | ALTER TABLE public.revzones_rdns_id_seq OWNER TO dnstest;
|
|---|
| 483 |
|
|---|
| 484 | --
|
|---|
| 485 | -- Name: revzones_rdns_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 486 | --
|
|---|
| 487 |
|
|---|
| 488 | ALTER SEQUENCE public.revzones_rdns_id_seq OWNED BY public.revzones.rdns_id;
|
|---|
| 489 |
|
|---|
| 490 |
|
|---|
| 491 | --
|
|---|
| 492 | -- Name: users; Type: TABLE; Schema: public; Owner: dnstest
|
|---|
| 493 | --
|
|---|
| 494 |
|
|---|
| 495 | CREATE TABLE public.users (
|
|---|
| 496 | user_id integer NOT NULL,
|
|---|
| 497 | group_id integer DEFAULT 1 NOT NULL,
|
|---|
| 498 | username character varying(60) NOT NULL,
|
|---|
| 499 | password character varying(34) NOT NULL,
|
|---|
| 500 | firstname character varying(60),
|
|---|
| 501 | lastname character varying(60),
|
|---|
| 502 | phone character varying(15),
|
|---|
| 503 | type character(1) DEFAULT 'S'::bpchar NOT NULL,
|
|---|
| 504 | status integer DEFAULT 1 NOT NULL,
|
|---|
| 505 | permission_id integer DEFAULT 1 NOT NULL,
|
|---|
| 506 | inherit_perm boolean DEFAULT true NOT NULL
|
|---|
| 507 | );
|
|---|
| 508 |
|
|---|
| 509 |
|
|---|
| 510 | ALTER TABLE public.users OWNER TO dnstest;
|
|---|
| 511 |
|
|---|
| 512 | --
|
|---|
| 513 | -- Name: users_user_id_seq; Type: SEQUENCE; Schema: public; Owner: dnstest
|
|---|
| 514 | --
|
|---|
| 515 |
|
|---|
| 516 | CREATE SEQUENCE public.users_user_id_seq
|
|---|
| 517 | START WITH 1
|
|---|
| 518 | INCREMENT BY 1
|
|---|
| 519 | NO MINVALUE
|
|---|
| 520 | NO MAXVALUE
|
|---|
| 521 | CACHE 1;
|
|---|
| 522 |
|
|---|
| 523 |
|
|---|
| 524 | ALTER TABLE public.users_user_id_seq OWNER TO dnstest;
|
|---|
| 525 |
|
|---|
| 526 | --
|
|---|
| 527 | -- Name: users_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: dnstest
|
|---|
| 528 | --
|
|---|
| 529 |
|
|---|
| 530 | ALTER SEQUENCE public.users_user_id_seq OWNED BY public.users.user_id;
|
|---|
| 531 |
|
|---|
| 532 |
|
|---|
| 533 | --
|
|---|
| 534 | -- Name: default_records record_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 535 | --
|
|---|
| 536 |
|
|---|
| 537 | ALTER TABLE ONLY public.default_records ALTER COLUMN record_id SET DEFAULT nextval('public.default_records_record_id_seq'::regclass);
|
|---|
| 538 |
|
|---|
| 539 |
|
|---|
| 540 | --
|
|---|
| 541 | -- Name: default_rev_records record_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 542 | --
|
|---|
| 543 |
|
|---|
| 544 | ALTER TABLE ONLY public.default_rev_records ALTER COLUMN record_id SET DEFAULT nextval('public.default_rev_records_record_id_seq'::regclass);
|
|---|
| 545 |
|
|---|
| 546 |
|
|---|
| 547 | --
|
|---|
| 548 | -- Name: domains domain_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 549 | --
|
|---|
| 550 |
|
|---|
| 551 | ALTER TABLE ONLY public.domains ALTER COLUMN domain_id SET DEFAULT nextval('public.domains_domain_id_seq'::regclass);
|
|---|
| 552 |
|
|---|
| 553 |
|
|---|
| 554 | --
|
|---|
| 555 | -- Name: groups group_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 556 | --
|
|---|
| 557 |
|
|---|
| 558 | ALTER TABLE ONLY public.groups ALTER COLUMN group_id SET DEFAULT nextval('public.groups_group_id_seq'::regclass);
|
|---|
| 559 |
|
|---|
| 560 |
|
|---|
| 561 | --
|
|---|
| 562 | -- Name: locations loc_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 563 | --
|
|---|
| 564 |
|
|---|
| 565 | ALTER TABLE ONLY public.locations ALTER COLUMN loc_id SET DEFAULT nextval('public.locations_loc_id_seq'::regclass);
|
|---|
| 566 |
|
|---|
| 567 |
|
|---|
| 568 | --
|
|---|
| 569 | -- Name: log log_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 570 | --
|
|---|
| 571 |
|
|---|
| 572 | ALTER TABLE ONLY public.log ALTER COLUMN log_id SET DEFAULT nextval('public.log_log_id_seq'::regclass);
|
|---|
| 573 |
|
|---|
| 574 |
|
|---|
| 575 | --
|
|---|
| 576 | -- Name: misc misc_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 577 | --
|
|---|
| 578 |
|
|---|
| 579 | ALTER TABLE ONLY public.misc ALTER COLUMN misc_id SET DEFAULT nextval('public.misc_misc_id_seq'::regclass);
|
|---|
| 580 |
|
|---|
| 581 |
|
|---|
| 582 | --
|
|---|
| 583 | -- Name: permissions permission_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 584 | --
|
|---|
| 585 |
|
|---|
| 586 | ALTER TABLE ONLY public.permissions ALTER COLUMN permission_id SET DEFAULT nextval('public.permissions_permission_id_seq'::regclass);
|
|---|
| 587 |
|
|---|
| 588 |
|
|---|
| 589 | --
|
|---|
| 590 | -- Name: records record_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 591 | --
|
|---|
| 592 |
|
|---|
| 593 | ALTER TABLE ONLY public.records ALTER COLUMN record_id SET DEFAULT nextval('public.records_record_id_seq'::regclass);
|
|---|
| 594 |
|
|---|
| 595 |
|
|---|
| 596 | --
|
|---|
| 597 | -- Name: revzones rdns_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 598 | --
|
|---|
| 599 |
|
|---|
| 600 | ALTER TABLE ONLY public.revzones ALTER COLUMN rdns_id SET DEFAULT nextval('public.revzones_rdns_id_seq'::regclass);
|
|---|
| 601 |
|
|---|
| 602 |
|
|---|
| 603 | --
|
|---|
| 604 | -- Name: users user_id; Type: DEFAULT; Schema: public; Owner: dnstest
|
|---|
| 605 | --
|
|---|
| 606 |
|
|---|
| 607 | ALTER TABLE ONLY public.users ALTER COLUMN user_id SET DEFAULT nextval('public.users_user_id_seq'::regclass);
|
|---|
| 608 |
|
|---|
| 609 |
|
|---|
| 610 | --
|
|---|
| 611 | -- Data for Name: default_records; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 612 | --
|
|---|
| 613 |
|
|---|
| 614 | COPY public.default_records (record_id, group_id, host, type, val, distance, weight, port, ttl, description) FROM stdin;
|
|---|
| 615 | 1 1 ns1.example.com:hostmaster.DOMAIN 6 10800:3600:604800:5400 0 0 0 86400 \N
|
|---|
| 616 | 2 1 DOMAIN 2 ns2.example.com 0 0 0 7200 \N
|
|---|
| 617 | 3 1 DOMAIN 2 ns1.example.com 0 0 0 7200 \N
|
|---|
| 618 | 4 1 DOMAIN 1 10.0.0.4 0 0 0 7200 \N
|
|---|
| 619 | 5 1 DOMAIN 15 mx1.example.com 10 0 0 7200 \N
|
|---|
| 620 | 6 1 www.DOMAIN 5 DOMAIN 0 0 0 10800 \N
|
|---|
| 621 | 7 1 DOMAIN 16 "v=spf1 a mx -all" 0 0 0 10800 \N
|
|---|
| 622 | \.
|
|---|
| 623 |
|
|---|
| 624 |
|
|---|
| 625 | --
|
|---|
| 626 | -- Name: default_records_record_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 627 | --
|
|---|
| 628 |
|
|---|
| 629 | SELECT pg_catalog.setval('public.default_records_record_id_seq', 8, true);
|
|---|
| 630 |
|
|---|
| 631 |
|
|---|
| 632 | --
|
|---|
| 633 | -- Data for Name: default_rev_records; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 634 | --
|
|---|
| 635 |
|
|---|
| 636 | COPY public.default_rev_records (record_id, group_id, host, type, val, ttl, description) FROM stdin;
|
|---|
| 637 | 1 1 hostmaster.ADMINDOMAIN:ns1.ADMINDOMAIN 6 3600:900:1048576:2560 3600
|
|---|
| 638 | 2 1 unused-%r.ADMINDOMAIN 65283 ZONE 3600
|
|---|
| 639 | 3 1 ns2.example.com 2 ZONE 7200 \N
|
|---|
| 640 | 4 1 ns1.example.com 2 ZONE 7200 \N
|
|---|
| 641 | \.
|
|---|
| 642 |
|
|---|
| 643 |
|
|---|
| 644 | --
|
|---|
| 645 | -- Name: default_rev_records_record_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 646 | --
|
|---|
| 647 |
|
|---|
| 648 | SELECT pg_catalog.setval('public.default_rev_records_record_id_seq', 4, true);
|
|---|
| 649 |
|
|---|
| 650 |
|
|---|
| 651 | --
|
|---|
| 652 | -- Data for Name: domains; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 653 | --
|
|---|
| 654 |
|
|---|
| 655 | COPY public.domains (domain_id, domain, group_id, description, status, zserial, sertype, changed, default_location) FROM stdin;
|
|---|
| 656 | 1 example.com 1 1 2025123002 D f
|
|---|
| 657 | 2 example.org 1 1 2025121800 D f ac
|
|---|
| 658 | 3 example.net 1 1 2025121800 D f ab
|
|---|
| 659 | 4 expiry1.test 1 1 2026011400 D t
|
|---|
| 660 | \.
|
|---|
| 661 |
|
|---|
| 662 |
|
|---|
| 663 | --
|
|---|
| 664 | -- Name: domains_domain_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 665 | --
|
|---|
| 666 |
|
|---|
| 667 | SELECT pg_catalog.setval('public.domains_domain_id_seq', 4, true);
|
|---|
| 668 |
|
|---|
| 669 |
|
|---|
| 670 | --
|
|---|
| 671 | -- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 672 | --
|
|---|
| 673 |
|
|---|
| 674 | COPY public.groups (group_id, parent_group_id, group_name, permission_id, inherit_perm) FROM stdin;
|
|---|
| 675 | 1 1 default 1 t
|
|---|
| 676 | \.
|
|---|
| 677 |
|
|---|
| 678 |
|
|---|
| 679 | --
|
|---|
| 680 | -- Name: groups_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 681 | --
|
|---|
| 682 |
|
|---|
| 683 | SELECT pg_catalog.setval('public.groups_group_id_seq', 1, true);
|
|---|
| 684 |
|
|---|
| 685 |
|
|---|
| 686 | --
|
|---|
| 687 | -- Data for Name: locations; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 688 | --
|
|---|
| 689 |
|
|---|
| 690 | COPY public.locations (location, loc_id, group_id, iplist, description, comments) FROM stdin;
|
|---|
| 691 | aa 1 1 Default
|
|---|
| 692 | ab 2 1 192.168.2.0/24 LAN 1
|
|---|
| 693 | ac 3 1 172.16.16.0/24 Fred
|
|---|
| 694 | \.
|
|---|
| 695 |
|
|---|
| 696 |
|
|---|
| 697 | --
|
|---|
| 698 | -- Name: locations_loc_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 699 | --
|
|---|
| 700 |
|
|---|
| 701 | SELECT pg_catalog.setval('public.locations_loc_id_seq', 3, true);
|
|---|
| 702 |
|
|---|
| 703 |
|
|---|
| 704 | --
|
|---|
| 705 | -- Data for Name: log; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 706 | --
|
|---|
| 707 |
|
|---|
| 708 | COPY public.log (log_id, domain_id, user_id, group_id, email, name, entry, stamp, rdns_id, logparent) FROM stdin;
|
|---|
| 709 | 1 1 1 1 admin Initial User Added active domain example.com 2025-12-17 12:24:46.11906-05 0 0
|
|---|
| 710 | 2 1 1 1 admin Initial User [new example.com] Added SOA record [contact ns1.example.com] [master hostmaster.example.com] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 711 | 3 1 1 1 admin Initial User [new example.com] Added record 'example.com NS ns2.example.com', TTL 7200 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 712 | 4 1 1 1 admin Initial User [new example.com] Added record 'example.com NS ns1.example.com', TTL 7200 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 713 | 5 1 1 1 admin Initial User [new example.com] Added record 'example.com A 10.0.0.4', TTL 7200 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 714 | 6 1 1 1 admin Initial User [new example.com] Added record 'example.com MX [distance 10] mx1.example.com', TTL 7200 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 715 | 7 1 1 1 admin Initial User [new example.com] Added record 'www.example.com CNAME example.com', TTL 10800 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 716 | 8 1 1 1 admin Initial User [new example.com] Added record 'example.com TXT "v=spf1 a mx -all"', TTL 10800 2025-12-17 12:24:46.11906-05 0 1
|
|---|
| 717 | 9 0 1 \N admin Initial User Added location (Default, '') 2025-12-17 12:25:11.191152-05 0 0
|
|---|
| 718 | 10 0 1 \N admin Initial User Added location (LAN 1, '192.168.2.0/24') 2025-12-17 12:25:33.836951-05 0 0
|
|---|
| 719 | 11 0 1 \N admin Initial User Added location (Fred, '172.16.16.0/24') 2025-12-17 12:25:51.949666-05 0 0
|
|---|
| 720 | 12 2 1 1 admin Initial User Added active domain example.org 2025-12-17 12:26:19.324182-05 0 0
|
|---|
| 721 | 13 2 1 1 admin Initial User [new example.org] Added SOA record [contact ns1.example.com] [master hostmaster.example.org] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 722 | 14 2 1 1 admin Initial User [new example.org] Added record 'example.org NS ns2.example.com', TTL 7200 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 723 | 15 2 1 1 admin Initial User [new example.org] Added record 'example.org NS ns1.example.com', TTL 7200 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 724 | 16 2 1 1 admin Initial User [new example.org] Added record 'example.org A 10.0.0.4', TTL 7200 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 725 | 17 2 1 1 admin Initial User [new example.org] Added record 'example.org MX [distance 10] mx1.example.com', TTL 7200 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 726 | 18 2 1 1 admin Initial User [new example.org] Added record 'www.example.org CNAME example.org', TTL 10800 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 727 | 19 2 1 1 admin Initial User [new example.org] Added record 'example.org TXT "v=spf1 a mx -all"', TTL 10800 2025-12-17 12:26:19.324182-05 0 12
|
|---|
| 728 | 20 3 1 1 admin Initial User Added active domain example.net 2025-12-17 12:26:35.195757-05 0 0
|
|---|
| 729 | 21 3 1 1 admin Initial User [new example.net] Added SOA record [contact ns1.example.com] [master hostmaster.example.net] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 730 | 22 3 1 1 admin Initial User [new example.net] Added record 'example.net NS ns2.example.com', TTL 7200 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 731 | 23 3 1 1 admin Initial User [new example.net] Added record 'example.net NS ns1.example.com', TTL 7200 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 732 | 24 3 1 1 admin Initial User [new example.net] Added record 'example.net A 10.0.0.4', TTL 7200 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 733 | 25 3 1 1 admin Initial User [new example.net] Added record 'example.net MX [distance 10] mx1.example.com', TTL 7200 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 734 | 26 3 1 1 admin Initial User [new example.net] Added record 'www.example.net CNAME example.net', TTL 10800 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 735 | 27 3 1 1 admin Initial User [new example.net] Added record 'example.net TXT "v=spf1 a mx -all"', TTL 10800 2025-12-17 12:26:35.195757-05 0 20
|
|---|
| 736 | 28 4 1 1 admin Initial User Added active domain expiry1.test 2025-12-17 12:26:47.718202-05 0 0
|
|---|
| 737 | 29 4 1 1 admin Initial User [new expiry1.test] Added SOA record [contact ns1.example.com] [master hostmaster.expiry1.test] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 738 | 30 4 1 1 admin Initial User [new expiry1.test] Added record 'expiry1.test NS ns2.example.com', TTL 7200 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 739 | 31 4 1 1 admin Initial User [new expiry1.test] Added record 'expiry1.test NS ns1.example.com', TTL 7200 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 740 | 32 4 1 1 admin Initial User [new expiry1.test] Added record 'expiry1.test A 10.0.0.4', TTL 7200 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 741 | 33 4 1 1 admin Initial User [new expiry1.test] Added record 'expiry1.test MX [distance 10] mx1.example.com', TTL 7200 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 742 | 34 4 1 1 admin Initial User [new expiry1.test] Added record 'www.expiry1.test CNAME expiry1.test', TTL 10800 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 743 | 35 4 1 1 admin Initial User [new expiry1.test] Added record 'expiry1.test TXT "v=spf1 a mx -all"', TTL 10800 2025-12-17 12:26:47.718202-05 0 28
|
|---|
| 744 | 36 0 1 1 admin Initial User Added active reverse zone 192.168.2.0/24 2025-12-17 12:27:28.623209-05 1 0
|
|---|
| 745 | 37 0 1 1 admin Initial User [new 192.168.2.0/24] Added SOA record [contact hostmaster.example.com] [master ns1.example.com] [refresh 3600] [retry 900] [expire 1048576] [minttl 2560], TTL 3600 2025-12-17 12:27:28.623209-05 1 0
|
|---|
| 746 | 38 0 1 1 admin Initial User [new 192.168.2.0/24] Added record 'ns2.example.com NS 192.168.2.0/24', TTL 7200 2025-12-17 12:27:28.623209-05 1 0
|
|---|
| 747 | 39 0 1 1 admin Initial User [new 192.168.2.0/24] Added record 'ns1.example.com NS 192.168.2.0/24', TTL 7200 2025-12-17 12:27:28.623209-05 1 0
|
|---|
| 748 | 40 1 1 1 admin Initial User [new 192.168.2.0/24] Added record 'lan-%ip.example.com A+PTR template 192.168.2.0/24', TTL 2560 from pattern 2025-12-17 12:27:28.623209-05 1 0
|
|---|
| 749 | 41 1 1 1 admin Initial User Added record 'mx1.example.com A 192.168.2.42', TTL 900 2025-12-17 16:43:46.2434-05 0 0
|
|---|
| 750 | 42 0 1 1 admin Initial User Added record '192.168.2.13 CNAME 13-29.arpa.example.net', TTL 2560 2025-12-18 11:06:54.803316-05 1 0
|
|---|
| 751 | 43 2 1 1 admin Initial User Added record '192.168.2.8/29 A+PTR template %r.example.org', TTL 2560 2025-12-18 11:07:33.593748-05 1 0
|
|---|
| 752 | 44 2 1 1 admin Initial User Added record '192.168.2.14 A+PTR floop.example.org', TTL 2560 2025-12-18 11:20:12.736034-05 1 0
|
|---|
| 753 | 45 1 1 1 admin Initial User Added record 'mail.example.com CNAME mx1.example.com', TTL 5400 2025-12-18 13:29:49.375721-05 0 0
|
|---|
| 754 | 46 1 1 1 admin Initial User Added record 'mx1.example.com TXT v=spf1 ip4:192.168.2.42', TTL 5400 2025-12-18 13:43:31.999061-05 0 0
|
|---|
| 755 | 47 1 1 1 admin Initial User Added record 'smtp.example.com A 192.168.2.11', TTL 5400 2025-12-18 18:09:00.580415-05 0 0
|
|---|
| 756 | 48 1 1 1 admin Initial User Added record 'webthing.example.com CNAME example.com', TTL 5400 2025-12-22 17:18:16.478475-05 0 0
|
|---|
| 757 | 49 1 1 1 admin Initial User Added record 'stuff.example.com CNAME example.com', TTL 5400 2025-12-22 17:22:23.125145-05 0 0
|
|---|
| 758 | 50 0 1 1 admin Initial User Added record '192.168.2.14 TXT we are text', TTL 2560 2025-12-22 18:17:14.386997-05 1 0
|
|---|
| 759 | 51 0 1 1 admin Initial User Added record '192.168.2.15 TXT some other text', TTL 2560 2025-12-22 18:19:51.428323-05 1 0
|
|---|
| 760 | 52 0 1 1 admin Initial User Added record '192.168.2.16 CNAME 16.16-29.2.168.192.in-addr.arpa', TTL 2560 2025-12-23 11:29:50.084066-05 1 0
|
|---|
| 761 | 53 0 1 1 admin Initial User Added record '192.168.2.17 TXT imma blocker!', TTL 2560 2025-12-23 13:06:20.492137-05 1 0
|
|---|
| 762 | 55 0 1 1 admin Initial User Added record '192.168.2.18 CNAME 18-2.arpa.example.com', TTL 2560 2026-01-07 16:37:03.094557-05 1 0
|
|---|
| 763 | 56 4 1 1 admin Initial User Added record 'expired1.expiry1.test A 192.168.2.23', TTL 5400, expires at 2025-12-24 18:30 2026-01-07 17:55:46.022401-05 0 0
|
|---|
| 764 | 57 4 1 1 admin Initial User Added record 'expired2.expiry1.test TXT imma expire soon', TTL 5400, expires at 2026-01-10 07:00 2026-01-07 17:57:07.015962-05 0 0
|
|---|
| 765 | 58 4 1 1 admin Initial User Added record 'active-after1.expiry1.test TXT not active yet', TTL 5400, valid after 2026-01-11 11:30 2026-01-07 18:12:57.491476-05 0 0
|
|---|
| 766 | 59 4 1 1 admin Initial User Added record 'active-after2.expiry1.test TXT I'm done waiting', TTL 5400, expires at 2025-12-31 14:00 2026-01-14 18:02:13.876839-05 0 0
|
|---|
| 767 | \.
|
|---|
| 768 |
|
|---|
| 769 |
|
|---|
| 770 | --
|
|---|
| 771 | -- Name: log_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 772 | --
|
|---|
| 773 |
|
|---|
| 774 | SELECT pg_catalog.setval('public.log_log_id_seq', 59, true);
|
|---|
| 775 |
|
|---|
| 776 |
|
|---|
| 777 | --
|
|---|
| 778 | -- Data for Name: misc; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 779 | --
|
|---|
| 780 |
|
|---|
| 781 | COPY public.misc (misc_id, key, value) FROM stdin;
|
|---|
| 782 | 1 dbversion 1.4.2
|
|---|
| 783 | \.
|
|---|
| 784 |
|
|---|
| 785 |
|
|---|
| 786 | --
|
|---|
| 787 | -- Name: misc_misc_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 788 | --
|
|---|
| 789 |
|
|---|
| 790 | SELECT pg_catalog.setval('public.misc_misc_id_seq', 1, true);
|
|---|
| 791 |
|
|---|
| 792 |
|
|---|
| 793 | --
|
|---|
| 794 | -- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 795 | --
|
|---|
| 796 |
|
|---|
| 797 | COPY public.permissions (permission_id, admin, self_edit, group_create, group_edit, group_delete, user_create, user_edit, user_delete, domain_create, domain_edit, domain_delete, record_create, record_edit, record_delete, user_id, group_id, record_locchg, location_create, location_edit, location_delete, location_view) FROM stdin;
|
|---|
| 798 | 1 f f f f f f f f t t t t t t \N 1 f f f f f
|
|---|
| 799 | 2 t f f f f f f f f f f f f f 1 \N f f f f f
|
|---|
| 800 | \.
|
|---|
| 801 |
|
|---|
| 802 |
|
|---|
| 803 | --
|
|---|
| 804 | -- Name: permissions_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 805 | --
|
|---|
| 806 |
|
|---|
| 807 | SELECT pg_catalog.setval('public.permissions_permission_id_seq', 2, true);
|
|---|
| 808 |
|
|---|
| 809 |
|
|---|
| 810 | --
|
|---|
| 811 | -- Data for Name: records; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 812 | --
|
|---|
| 813 |
|
|---|
| 814 | COPY public.records (domain_id, record_id, host, type, val, distance, weight, port, ttl, description, rdns_id, location, stamp, expires, stampactive, auxdata) FROM stdin;
|
|---|
| 815 | 1 1 ns1.example.com:hostmaster.example.com 6 10800:3600:604800:5400 0 0 0 86400 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 816 | 1 2 example.com 2 ns2.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 817 | 1 3 example.com 2 ns1.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 818 | 1 4 example.com 1 10.0.0.4 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 819 | 1 5 example.com 15 mx1.example.com 10 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 820 | 1 6 www.example.com 5 example.com 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 821 | 1 7 example.com 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 822 | 2 8 ns1.example.com:hostmaster.example.org 6 10800:3600:604800:5400 0 0 0 86400 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 823 | 2 9 example.org 2 ns2.example.com 0 0 0 7200 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 824 | 2 10 example.org 2 ns1.example.com 0 0 0 7200 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 825 | 2 11 example.org 1 10.0.0.4 0 0 0 7200 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 826 | 2 12 example.org 15 mx1.example.com 10 0 0 7200 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 827 | 2 13 www.example.org 5 example.org 0 0 0 10800 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 828 | 2 14 example.org 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 ac 1969-12-31 19:00:00-05 f f \N
|
|---|
| 829 | 3 15 ns1.example.com:hostmaster.example.net 6 10800:3600:604800:5400 0 0 0 86400 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 830 | 3 16 example.net 2 ns2.example.com 0 0 0 7200 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 831 | 3 17 example.net 2 ns1.example.com 0 0 0 7200 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 832 | 3 18 example.net 1 10.0.0.4 0 0 0 7200 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 833 | 3 19 example.net 15 mx1.example.com 10 0 0 7200 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 834 | 3 20 www.example.net 5 example.net 0 0 0 10800 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 835 | 3 21 example.net 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 ab 1969-12-31 19:00:00-05 f f \N
|
|---|
| 836 | 4 22 ns1.example.com:hostmaster.expiry1.test 6 10800:3600:604800:5400 0 0 0 86400 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 837 | 4 23 expiry1.test 2 ns2.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 838 | 4 24 expiry1.test 2 ns1.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 839 | 4 25 expiry1.test 1 10.0.0.4 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 840 | 4 26 expiry1.test 15 mx1.example.com 10 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 841 | 4 27 www.expiry1.test 5 expiry1.test 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 842 | 4 28 expiry1.test 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 843 | 0 29 hostmaster.example.com:ns1.example.com 6 3600:900:1048576:2560 0 0 0 3600 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 844 | 0 30 ns2.example.com 2 192.168.2.0/24 0 0 0 7200 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 845 | 0 31 ns1.example.com 2 192.168.2.0/24 0 0 0 7200 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 846 | 1 32 lan-%ip.example.com 65283 192.168.2.0/24 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 847 | 1 33 mx1.example.com 1 192.168.2.42 0 0 0 900 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 848 | 0 34 13-29.arpa.example.net 5 192.168.2.13 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 849 | 2 35 %r.example.org 65283 192.168.2.8/29 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 850 | 2 36 floop.example.org 65280 192.168.2.14 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 851 | 1 37 mail.example.com 5 mx1.example.com 0 0 0 900 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 852 | 1 38 mx1.example.com 16 v=spf1 ip4:192.168.2.42 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 853 | 1 39 smtp.example.com 1 192.168.2.11 0 0 0 900 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 854 | 1 40 webthing.example.com 5 example.com 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 855 | 1 41 stuff.example.com 5 example.com 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N
|
|---|
| 856 | 0 42 we are text 16 192.168.2.14 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 857 | 0 43 some other text 16 192.168.2.15 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 858 | 0 44 16.16-29.2.168.192.in-addr.arpa 5 192.168.2.16 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 859 | 0 45 imma blocker! 16 192.168.2.17 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 860 | 0 46 18-2.arpa.example.com 5 192.168.2.18 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N
|
|---|
| 861 | 4 47 expired1.expiry1.test 1 192.168.2.23 0 0 0 5400 \N 0 2025-12-24 18:30:00-05 t t \N
|
|---|
| 862 | 4 48 expired2.expiry1.test 16 imma expire soon 0 0 0 5400 \N 0 2026-01-10 07:00:00-05 t t \N
|
|---|
| 863 | 4 49 active-after1.expiry1.test 16 not active yet 0 0 0 5400 \N 0 2026-01-11 11:30:00-05 f t \N
|
|---|
| 864 | 4 50 active-after2.expiry1.test 16 I'm done waiting 0 0 0 5400 \N 0 2025-12-31 14:00:00-05 f t \N
|
|---|
| 865 | \.
|
|---|
| 866 |
|
|---|
| 867 |
|
|---|
| 868 | --
|
|---|
| 869 | -- Name: records_record_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 870 | --
|
|---|
| 871 |
|
|---|
| 872 | SELECT pg_catalog.setval('public.records_record_id_seq', 50, true);
|
|---|
| 873 |
|
|---|
| 874 |
|
|---|
| 875 | --
|
|---|
| 876 | -- Data for Name: rectypes; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 877 | --
|
|---|
| 878 |
|
|---|
| 879 | COPY public.rectypes (val, name, stdflag, listorder, alphaorder) FROM stdin;
|
|---|
| 880 | 1 A 1 1 1
|
|---|
| 881 | 2 NS 2 10 37
|
|---|
| 882 | 3 MD 5 255 29
|
|---|
| 883 | 4 MF 5 255 30
|
|---|
| 884 | 5 CNAME 2 12 9
|
|---|
| 885 | 6 SOA 0 0 53
|
|---|
| 886 | 7 MB 5 255 28
|
|---|
| 887 | 8 MG 5 255 31
|
|---|
| 888 | 9 MR 5 255 33
|
|---|
| 889 | 10 NULL 5 255 43
|
|---|
| 890 | 11 WKS 5 255 64
|
|---|
| 891 | 12 PTR 3 5 46
|
|---|
| 892 | 13 HINFO 5 255 18
|
|---|
| 893 | 14 MINFO 5 255 32
|
|---|
| 894 | 15 MX 1 11 34
|
|---|
| 895 | 16 TXT 2 13 60
|
|---|
| 896 | 17 RP 4 255 48
|
|---|
| 897 | 18 AFSDB 5 255 4
|
|---|
| 898 | 19 X25 5 255 65
|
|---|
| 899 | 20 ISDN 5 255 21
|
|---|
| 900 | 21 RT 5 255 50
|
|---|
| 901 | 22 NSAP 5 255 38
|
|---|
| 902 | 23 NSAP-PTR 5 255 39
|
|---|
| 903 | 24 SIG 5 255 51
|
|---|
| 904 | 25 KEY 5 255 23
|
|---|
| 905 | 26 PX 5 255 47
|
|---|
| 906 | 27 GPOS 5 255 17
|
|---|
| 907 | 28 AAAA 1 3 3
|
|---|
| 908 | 29 LOC 5 255 25
|
|---|
| 909 | 30 NXT 5 255 44
|
|---|
| 910 | 31 EID 5 255 15
|
|---|
| 911 | 32 NIMLOC 5 255 36
|
|---|
| 912 | 33 SRV 1 14 55
|
|---|
| 913 | 34 ATMA 5 255 6
|
|---|
| 914 | 35 NAPTR 5 255 35
|
|---|
| 915 | 36 KX 5 255 24
|
|---|
| 916 | 37 CERT 5 255 8
|
|---|
| 917 | 38 A6 5 3 2
|
|---|
| 918 | 39 DNAME 5 255 12
|
|---|
| 919 | 40 SINK 5 255 52
|
|---|
| 920 | 41 OPT 5 255 45
|
|---|
| 921 | 42 APL 5 255 5
|
|---|
| 922 | 43 DS 5 255 14
|
|---|
| 923 | 44 SSHFP 5 255 56
|
|---|
| 924 | 45 IPSECKEY 5 255 20
|
|---|
| 925 | 46 RRSIG 5 255 49
|
|---|
| 926 | 47 NSEC 5 255 40
|
|---|
| 927 | 48 DNSKEY 5 255 13
|
|---|
| 928 | 49 DHCID 5 255 10
|
|---|
| 929 | 50 NSEC3 5 255 41
|
|---|
| 930 | 51 NSEC3PARAM 5 255 42
|
|---|
| 931 | 52 TLSA 5 255 255
|
|---|
| 932 | 53 SMIMEA 5 255 255
|
|---|
| 933 | 55 HIP 5 255 19
|
|---|
| 934 | 56 NINFO 5 255 255
|
|---|
| 935 | 57 RKEY 5 255 255
|
|---|
| 936 | 58 TALINK 5 255 255
|
|---|
| 937 | 59 CDS 5 255 255
|
|---|
| 938 | 60 CDNSKEY 5 255 255
|
|---|
| 939 | 61 OPENPGPKEY 5 255 255
|
|---|
| 940 | 62 CSYNC 5 255 255
|
|---|
| 941 | 63 ZONEMD 255 255 255
|
|---|
| 942 | 64 SVCB 255 255 255
|
|---|
| 943 | 65 HTTPS 255 255 255
|
|---|
| 944 | 99 SPF 5 255 54
|
|---|
| 945 | 100 UINFO 5 255 62
|
|---|
| 946 | 101 UID 5 255 61
|
|---|
| 947 | 102 GID 5 255 16
|
|---|
| 948 | 103 UNSPEC 5 255 63
|
|---|
| 949 | 104 NID 5 255 255
|
|---|
| 950 | 105 L32 5 255 255
|
|---|
| 951 | 106 L64 5 255 255
|
|---|
| 952 | 107 LP 5 255 255
|
|---|
| 953 | 108 EUI48 5 255 255
|
|---|
| 954 | 109 EUI64 5 255 255
|
|---|
| 955 | 249 TKEY 5 255 58
|
|---|
| 956 | 250 TSIG 5 255 59
|
|---|
| 957 | 251 IXFR 5 255 22
|
|---|
| 958 | 252 AXFR 5 255 7
|
|---|
| 959 | 253 MAILB 5 255 27
|
|---|
| 960 | 254 MAILA 5 255 26
|
|---|
| 961 | 255 * 5 255 255
|
|---|
| 962 | 256 URI 5 255 255
|
|---|
| 963 | 258 AVC 5 255 255
|
|---|
| 964 | 259 DOA 255 255 255
|
|---|
| 965 | 260 AMTRELAY 255 255 255
|
|---|
| 966 | 32768 TA 5 255 57
|
|---|
| 967 | 32769 DLV 5 255 11
|
|---|
| 968 | 65280 A+PTR 2 2 2
|
|---|
| 969 | 65281 AAAA+PTR 2 4 4
|
|---|
| 970 | 65282 PTR template 3 6 2
|
|---|
| 971 | 65283 A+PTR template 2 7 2
|
|---|
| 972 | 65284 AAAA+PTR template 2 8 2
|
|---|
| 973 | 65285 Delegation 2 9 2
|
|---|
| 974 | 65300 ALIAS 2 16 255
|
|---|
| 975 | 257 CAA 1 17 255
|
|---|
| 976 | \.
|
|---|
| 977 |
|
|---|
| 978 |
|
|---|
| 979 | --
|
|---|
| 980 | -- Data for Name: refresh_zones; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 981 | --
|
|---|
| 982 |
|
|---|
| 983 | COPY public.refresh_zones (zone, view, export_stamp, reftype) FROM stdin;
|
|---|
| 984 | example.com 1765992286 add
|
|---|
| 985 | example.org ac 1765992379 add
|
|---|
| 986 | example.net ab 1765992395 add
|
|---|
| 987 | expiry1.test 1765992408 add
|
|---|
| 988 | 2.168.192.in-addr.arpa 1765992449 add
|
|---|
| 989 | \.
|
|---|
| 990 |
|
|---|
| 991 |
|
|---|
| 992 | --
|
|---|
| 993 | -- Data for Name: revzones; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 994 | --
|
|---|
| 995 |
|
|---|
| 996 | COPY public.revzones (rdns_id, revnet, group_id, description, status, zserial, sertype, changed, default_location) FROM stdin;
|
|---|
| 997 | 1 192.168.2.0/24 1 1 2026010700 D t
|
|---|
| 998 | \.
|
|---|
| 999 |
|
|---|
| 1000 |
|
|---|
| 1001 | --
|
|---|
| 1002 | -- Name: revzones_rdns_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 1003 | --
|
|---|
| 1004 |
|
|---|
| 1005 | SELECT pg_catalog.setval('public.revzones_rdns_id_seq', 1, true);
|
|---|
| 1006 |
|
|---|
| 1007 |
|
|---|
| 1008 | --
|
|---|
| 1009 | -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: dnstest
|
|---|
| 1010 | --
|
|---|
| 1011 |
|
|---|
| 1012 | COPY public.users (user_id, group_id, username, password, firstname, lastname, phone, type, status, permission_id, inherit_perm) FROM stdin;
|
|---|
| 1013 | 1 1 admin $1$PfEBUv9d$wV2/UG4gmKk08DLmdE8/d. Initial User \N S 1 2 f
|
|---|
| 1014 | \.
|
|---|
| 1015 |
|
|---|
| 1016 |
|
|---|
| 1017 | --
|
|---|
| 1018 | -- Name: users_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: dnstest
|
|---|
| 1019 | --
|
|---|
| 1020 |
|
|---|
| 1021 | SELECT pg_catalog.setval('public.users_user_id_seq', 1, true);
|
|---|
| 1022 |
|
|---|
| 1023 |
|
|---|
| 1024 | --
|
|---|
| 1025 | -- Name: default_records default_records_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1026 | --
|
|---|
| 1027 |
|
|---|
| 1028 | ALTER TABLE ONLY public.default_records
|
|---|
| 1029 | ADD CONSTRAINT default_records_pkey PRIMARY KEY (record_id);
|
|---|
| 1030 |
|
|---|
| 1031 |
|
|---|
| 1032 | --
|
|---|
| 1033 | -- Name: domains domains_domain_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1034 | --
|
|---|
| 1035 |
|
|---|
| 1036 | ALTER TABLE ONLY public.domains
|
|---|
| 1037 | ADD CONSTRAINT domains_domain_id_key UNIQUE (domain_id);
|
|---|
| 1038 |
|
|---|
| 1039 |
|
|---|
| 1040 | --
|
|---|
| 1041 | -- Name: domains domains_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1042 | --
|
|---|
| 1043 |
|
|---|
| 1044 | ALTER TABLE ONLY public.domains
|
|---|
| 1045 | ADD CONSTRAINT domains_pkey PRIMARY KEY (domain, default_location);
|
|---|
| 1046 |
|
|---|
| 1047 |
|
|---|
| 1048 | --
|
|---|
| 1049 | -- Name: groups groups_group_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1050 | --
|
|---|
| 1051 |
|
|---|
| 1052 | ALTER TABLE ONLY public.groups
|
|---|
| 1053 | ADD CONSTRAINT groups_group_id_key UNIQUE (group_id);
|
|---|
| 1054 |
|
|---|
| 1055 |
|
|---|
| 1056 | --
|
|---|
| 1057 | -- Name: locations locations_loc_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1058 | --
|
|---|
| 1059 |
|
|---|
| 1060 | ALTER TABLE ONLY public.locations
|
|---|
| 1061 | ADD CONSTRAINT locations_loc_id_key UNIQUE (loc_id);
|
|---|
| 1062 |
|
|---|
| 1063 |
|
|---|
| 1064 | --
|
|---|
| 1065 | -- Name: locations locations_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1066 | --
|
|---|
| 1067 |
|
|---|
| 1068 | ALTER TABLE ONLY public.locations
|
|---|
| 1069 | ADD CONSTRAINT locations_pkey PRIMARY KEY (location);
|
|---|
| 1070 |
|
|---|
| 1071 |
|
|---|
| 1072 | --
|
|---|
| 1073 | -- Name: permissions permissions_group_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1074 | --
|
|---|
| 1075 |
|
|---|
| 1076 | ALTER TABLE ONLY public.permissions
|
|---|
| 1077 | ADD CONSTRAINT permissions_group_id_key UNIQUE (group_id);
|
|---|
| 1078 |
|
|---|
| 1079 |
|
|---|
| 1080 | --
|
|---|
| 1081 | -- Name: permissions permissions_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1082 | --
|
|---|
| 1083 |
|
|---|
| 1084 | ALTER TABLE ONLY public.permissions
|
|---|
| 1085 | ADD CONSTRAINT permissions_permission_id_key UNIQUE (permission_id);
|
|---|
| 1086 |
|
|---|
| 1087 |
|
|---|
| 1088 | --
|
|---|
| 1089 | -- Name: permissions permissions_user_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1090 | --
|
|---|
| 1091 |
|
|---|
| 1092 | ALTER TABLE ONLY public.permissions
|
|---|
| 1093 | ADD CONSTRAINT permissions_user_id_key UNIQUE (user_id);
|
|---|
| 1094 |
|
|---|
| 1095 |
|
|---|
| 1096 | --
|
|---|
| 1097 | -- Name: records records_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1098 | --
|
|---|
| 1099 |
|
|---|
| 1100 | ALTER TABLE ONLY public.records
|
|---|
| 1101 | ADD CONSTRAINT records_pkey PRIMARY KEY (record_id);
|
|---|
| 1102 |
|
|---|
| 1103 |
|
|---|
| 1104 | --
|
|---|
| 1105 | -- Name: rectypes rectypes_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1106 | --
|
|---|
| 1107 |
|
|---|
| 1108 | ALTER TABLE ONLY public.rectypes
|
|---|
| 1109 | ADD CONSTRAINT rectypes_pkey PRIMARY KEY (val, name);
|
|---|
| 1110 |
|
|---|
| 1111 |
|
|---|
| 1112 | --
|
|---|
| 1113 | -- Name: refresh_zones refresh_zones_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1114 | --
|
|---|
| 1115 |
|
|---|
| 1116 | ALTER TABLE ONLY public.refresh_zones
|
|---|
| 1117 | ADD CONSTRAINT refresh_zones_pkey PRIMARY KEY (zone, view);
|
|---|
| 1118 |
|
|---|
| 1119 |
|
|---|
| 1120 | --
|
|---|
| 1121 | -- Name: revzones revzones_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1122 | --
|
|---|
| 1123 |
|
|---|
| 1124 | ALTER TABLE ONLY public.revzones
|
|---|
| 1125 | ADD CONSTRAINT revzones_pkey PRIMARY KEY (revnet, default_location);
|
|---|
| 1126 |
|
|---|
| 1127 |
|
|---|
| 1128 | --
|
|---|
| 1129 | -- Name: revzones revzones_rdns_id_key; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1130 | --
|
|---|
| 1131 |
|
|---|
| 1132 | ALTER TABLE ONLY public.revzones
|
|---|
| 1133 | ADD CONSTRAINT revzones_rdns_id_key UNIQUE (rdns_id);
|
|---|
| 1134 |
|
|---|
| 1135 |
|
|---|
| 1136 | --
|
|---|
| 1137 | -- Name: users uidu; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1138 | --
|
|---|
| 1139 |
|
|---|
| 1140 | ALTER TABLE ONLY public.users
|
|---|
| 1141 | ADD CONSTRAINT uidu UNIQUE (user_id);
|
|---|
| 1142 |
|
|---|
| 1143 |
|
|---|
| 1144 | --
|
|---|
| 1145 | -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1146 | --
|
|---|
| 1147 |
|
|---|
| 1148 | ALTER TABLE ONLY public.users
|
|---|
| 1149 | ADD CONSTRAINT users_pkey PRIMARY KEY (username);
|
|---|
| 1150 |
|
|---|
| 1151 |
|
|---|
| 1152 | --
|
|---|
| 1153 | -- Name: dom_status_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1154 | --
|
|---|
| 1155 |
|
|---|
| 1156 | CREATE INDEX dom_status_index ON public.domains USING btree (status);
|
|---|
| 1157 |
|
|---|
| 1158 |
|
|---|
| 1159 | --
|
|---|
| 1160 | -- Name: log_domain_id_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1161 | --
|
|---|
| 1162 |
|
|---|
| 1163 | CREATE INDEX log_domain_id_index ON public.log USING btree (domain_id);
|
|---|
| 1164 |
|
|---|
| 1165 |
|
|---|
| 1166 | --
|
|---|
| 1167 | -- Name: log_group_id_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1168 | --
|
|---|
| 1169 |
|
|---|
| 1170 | CREATE INDEX log_group_id_index ON public.log USING btree (group_id);
|
|---|
| 1171 |
|
|---|
| 1172 |
|
|---|
| 1173 | --
|
|---|
| 1174 | -- Name: log_rdns_id_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1175 | --
|
|---|
| 1176 |
|
|---|
| 1177 | CREATE INDEX log_rdns_id_index ON public.log USING btree (rdns_id);
|
|---|
| 1178 |
|
|---|
| 1179 |
|
|---|
| 1180 | --
|
|---|
| 1181 | -- Name: log_user_id_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1182 | --
|
|---|
| 1183 |
|
|---|
| 1184 | CREATE INDEX log_user_id_index ON public.log USING btree (user_id);
|
|---|
| 1185 |
|
|---|
| 1186 |
|
|---|
| 1187 | --
|
|---|
| 1188 | -- Name: rec_domain_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1189 | --
|
|---|
| 1190 |
|
|---|
| 1191 | CREATE INDEX rec_domain_index ON public.records USING btree (domain_id);
|
|---|
| 1192 |
|
|---|
| 1193 |
|
|---|
| 1194 | --
|
|---|
| 1195 | -- Name: rec_revzone_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1196 | --
|
|---|
| 1197 |
|
|---|
| 1198 | CREATE INDEX rec_revzone_index ON public.records USING btree (rdns_id);
|
|---|
| 1199 |
|
|---|
| 1200 |
|
|---|
| 1201 | --
|
|---|
| 1202 | -- Name: rec_types_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1203 | --
|
|---|
| 1204 |
|
|---|
| 1205 | CREATE INDEX rec_types_index ON public.records USING btree (type);
|
|---|
| 1206 |
|
|---|
| 1207 |
|
|---|
| 1208 | --
|
|---|
| 1209 | -- Name: rev_status_index; Type: INDEX; Schema: public; Owner: dnstest
|
|---|
| 1210 | --
|
|---|
| 1211 |
|
|---|
| 1212 | CREATE INDEX rev_status_index ON public.revzones USING btree (status);
|
|---|
| 1213 |
|
|---|
| 1214 |
|
|---|
| 1215 | --
|
|---|
| 1216 | -- Name: domains $1; Type: FK CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1217 | --
|
|---|
| 1218 |
|
|---|
| 1219 | ALTER TABLE ONLY public.domains
|
|---|
| 1220 | ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES public.groups(group_id);
|
|---|
| 1221 |
|
|---|
| 1222 |
|
|---|
| 1223 | --
|
|---|
| 1224 | -- Name: default_records $1; Type: FK CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1225 | --
|
|---|
| 1226 |
|
|---|
| 1227 | ALTER TABLE ONLY public.default_records
|
|---|
| 1228 | ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES public.groups(group_id);
|
|---|
| 1229 |
|
|---|
| 1230 |
|
|---|
| 1231 | --
|
|---|
| 1232 | -- Name: users $1; Type: FK CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1233 | --
|
|---|
| 1234 |
|
|---|
| 1235 | ALTER TABLE ONLY public.users
|
|---|
| 1236 | ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES public.groups(group_id);
|
|---|
| 1237 |
|
|---|
| 1238 |
|
|---|
| 1239 | --
|
|---|
| 1240 | -- Name: revzones $1; Type: FK CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1241 | --
|
|---|
| 1242 |
|
|---|
| 1243 | ALTER TABLE ONLY public.revzones
|
|---|
| 1244 | ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES public.groups(group_id);
|
|---|
| 1245 |
|
|---|
| 1246 |
|
|---|
| 1247 | --
|
|---|
| 1248 | -- Name: groups group_parent; Type: FK CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1249 | --
|
|---|
| 1250 |
|
|---|
| 1251 | ALTER TABLE ONLY public.groups
|
|---|
| 1252 | ADD CONSTRAINT group_parent FOREIGN KEY (parent_group_id) REFERENCES public.groups(group_id);
|
|---|
| 1253 |
|
|---|
| 1254 |
|
|---|
| 1255 | --
|
|---|
| 1256 | -- Name: locations locations_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: dnstest
|
|---|
| 1257 | --
|
|---|
| 1258 |
|
|---|
| 1259 | ALTER TABLE ONLY public.locations
|
|---|
| 1260 | ADD CONSTRAINT locations_group_id_fkey FOREIGN KEY (group_id) REFERENCES public.groups(group_id);
|
|---|
| 1261 |
|
|---|
| 1262 |
|
|---|
| 1263 | --
|
|---|
| 1264 | -- PostgreSQL database dump complete
|
|---|
| 1265 | --
|
|---|
| 1266 |
|
|---|
![[ DNS Administrator ]](/fx/dnsadmin-logo.png){kind=logo}
