gistfile1

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: audits; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE audits (
    id integer NOT NULL,
    auditable_id integer,
    auditable_type character varying(255),
    auditable_parent_id integer,
    auditable_parent_type character varying(255),
    user_id integer,
    user_type character varying(255),
    username character varying(255),
    action character varying(255),
    changes text,
    version integer DEFAULT 0,
    created_at timestamp without time zone
);


ALTER TABLE public.audits OWNER TO powerdns;

--
-- Name: audits_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE audits_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.audits_id_seq OWNER TO powerdns;

--
-- Name: audits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE audits_id_seq OWNED BY audits.id;


--
-- Name: audits_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('audits_id_seq', 1, false);


--
-- Name: auth_tokens; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE auth_tokens (
    id integer NOT NULL,
    domain_id integer,
    user_id integer,
    token character varying(255) NOT NULL,
    permissions text NOT NULL,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    expires_at timestamp without time zone NOT NULL
);


ALTER TABLE public.auth_tokens OWNER TO powerdns;

--
-- Name: auth_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE auth_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.auth_tokens_id_seq OWNER TO powerdns;

--
-- Name: auth_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE auth_tokens_id_seq OWNED BY auth_tokens.id;


--
-- Name: auth_tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('auth_tokens_id_seq', 1, false);


--
-- Name: domains; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE domains (
    id integer NOT NULL,
    name character varying(255),
    master character varying(255),
    last_check integer,
    type character varying(255) DEFAULT 'NATIVE'::character varying,
    notified_serial integer,
    account character varying(255),
    ttl integer DEFAULT 86400,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    user_id integer,
    notes text
);


ALTER TABLE public.domains OWNER TO powerdns;

--
-- Name: domains_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE domains_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.domains_id_seq OWNER TO powerdns;

--
-- Name: domains_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE domains_id_seq OWNED BY domains.id;


--
-- Name: domains_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('domains_id_seq', 11, true);


--
-- Name: macro_steps; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE macro_steps (
    id integer NOT NULL,
    macro_id integer,
    action character varying(255),
    record_type character varying(255),
    name character varying(255),
    content character varying(255),
    ttl integer,
    prio integer,
    "position" integer NOT NULL,
    active boolean DEFAULT true,
    note character varying(255),
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.macro_steps OWNER TO powerdns;

--
-- Name: macro_steps_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE macro_steps_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.macro_steps_id_seq OWNER TO powerdns;

--
-- Name: macro_steps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE macro_steps_id_seq OWNED BY macro_steps.id;


--
-- Name: macro_steps_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('macro_steps_id_seq', 1, false);


--
-- Name: macros; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE macros (
    id integer NOT NULL,
    name character varying(255),
    description character varying(255),
    user_id integer,
    active boolean DEFAULT false,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.macros OWNER TO powerdns;

--
-- Name: macros_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE macros_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.macros_id_seq OWNER TO powerdns;

--
-- Name: macros_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE macros_id_seq OWNED BY macros.id;


--
-- Name: macros_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('macros_id_seq', 1, false);


--
-- Name: record_templates; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE record_templates (
    id integer NOT NULL,
    zone_template_id integer,
    name character varying(255),
    record_type character varying(255) NOT NULL,
    content character varying(255) NOT NULL,
    ttl integer NOT NULL,
    prio integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.record_templates OWNER TO powerdns;

--
-- Name: record_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE record_templates_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.record_templates_id_seq OWNER TO powerdns;

--
-- Name: record_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE record_templates_id_seq OWNED BY record_templates.id;


--
-- Name: record_templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('record_templates_id_seq', 8, true);


--
-- Name: records; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE records (
    id integer NOT NULL,
    domain_id integer NOT NULL,
    name character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    content character varying(255) NOT NULL,
    ttl integer NOT NULL,
    prio integer,
    change_date integer DEFAULT (date_part('epoch'::text, now()))::integer NOT NULL,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.records OWNER TO powerdns;

--
-- Name: records_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE records_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.records_id_seq OWNER TO powerdns;

--
-- Name: records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE records_id_seq OWNED BY records.id;


--
-- Name: records_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('records_id_seq', 71, true);


--
-- Name: roles; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE roles (
    id integer NOT NULL,
    name character varying(255)
);


ALTER TABLE public.roles OWNER TO powerdns;

--
-- Name: roles_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE roles_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.roles_id_seq OWNER TO powerdns;

--
-- Name: roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE roles_id_seq OWNED BY roles.id;


--
-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('roles_id_seq', 3, true);


--
-- Name: roles_users; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE roles_users (
    role_id integer,
    user_id integer
);


ALTER TABLE public.roles_users OWNER TO powerdns;

--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE schema_migrations (
    version character varying(255) NOT NULL
);


ALTER TABLE public.schema_migrations OWNER TO powerdns;

--
-- Name: users; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE users (
    id integer NOT NULL,
    login character varying(255),
    email character varying(255),
    crypted_password character varying(40),
    salt character varying(40),
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    remember_token character varying(255),
    remember_token_expires_at timestamp without time zone,
    activation_code character varying(40),
    activated_at timestamp without time zone,
    state character varying(255) DEFAULT 'passive'::character varying,
    deleted_at timestamp without time zone
);


ALTER TABLE public.users OWNER TO powerdns;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE users_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO powerdns;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE users_id_seq OWNED BY users.id;


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('users_id_seq', 2, true);


--
-- Name: zone_templates; Type: TABLE; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE TABLE zone_templates (
    id integer NOT NULL,
    name character varying(255),
    ttl integer DEFAULT 86400,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    user_id integer
);


ALTER TABLE public.zone_templates OWNER TO powerdns;

--
-- Name: zone_templates_id_seq; Type: SEQUENCE; Schema: public; Owner: powerdns
--

CREATE SEQUENCE zone_templates_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.zone_templates_id_seq OWNER TO powerdns;

--
-- Name: zone_templates_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: powerdns
--

ALTER SEQUENCE zone_templates_id_seq OWNED BY zone_templates.id;


--
-- Name: zone_templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: powerdns
--

SELECT pg_catalog.setval('zone_templates_id_seq', 1, true);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE audits ALTER COLUMN id SET DEFAULT nextval('audits_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE auth_tokens ALTER COLUMN id SET DEFAULT nextval('auth_tokens_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE domains ALTER COLUMN id SET DEFAULT nextval('domains_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE macro_steps ALTER COLUMN id SET DEFAULT nextval('macro_steps_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE macros ALTER COLUMN id SET DEFAULT nextval('macros_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE record_templates ALTER COLUMN id SET DEFAULT nextval('record_templates_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE records ALTER COLUMN id SET DEFAULT nextval('records_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE roles ALTER COLUMN id SET DEFAULT nextval('roles_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: powerdns
--

ALTER TABLE zone_templates ALTER COLUMN id SET DEFAULT nextval('zone_templates_id_seq'::regclass);


--
-- Data for Name: audits; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY audits (id, auditable_id, auditable_type, auditable_parent_id, auditable_parent_type, user_id, user_type, username, action, changes, version, created_at) FROM stdin;
\.


--
-- Data for Name: auth_tokens; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY auth_tokens (id, domain_id, user_id, token, permissions, created_at, updated_at, expires_at) FROM stdin;
\.


--
-- Data for Name: domains; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY domains (id, name, master, last_check, type, notified_serial, account, ttl, created_at, updated_at, user_id, notes) FROM stdin;
1	example.com	\N	\N	NATIVE	\N	\N	86400	2010-04-20 11:49:10.782958	2010-04-20 11:49:10.782958	\N	\N
7	displayboy.com	\N	\N	NATIVE	\N	\N	86400	\N	\N	\N	\N
11	sexgoesmobile.com	\N	\N	NATIVE	\N	\N	86400	\N	\N	\N	\N
\.


--
-- Data for Name: macro_steps; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY macro_steps (id, macro_id, action, record_type, name, content, ttl, prio, "position", active, note, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: macros; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY macros (id, name, description, user_id, active, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: record_templates; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY record_templates (id, zone_template_id, name, record_type, content, ttl, prio, created_at, updated_at) FROM stdin;
1	1	\N	SOA	ns1.%ZONE% east-coast@example.com 0 10800 7200 604800 10800	86400	\N	2010-04-20 11:49:11.163956	2010-04-20 11:49:11.163956
2	1	\N	NS	ns1.%ZONE%	86400	\N	2010-04-20 11:49:11.193729	2010-04-20 11:49:11.193729
3	1	\N	NS	ns2.%ZONE%	86400	\N	2010-04-20 11:49:11.217193	2010-04-20 11:49:11.217193
4	1	ns1	A	10.0.0.1	86400	\N	2010-04-20 11:49:11.23816	2010-04-20 11:49:11.23816
5	1	ns2	A	10.0.0.2	86400	\N	2010-04-20 11:49:11.25904	2010-04-20 11:49:11.25904
6	1	\N	A	10.0.0.3	86400	\N	2010-04-20 11:49:11.282543	2010-04-20 11:49:11.282543
7	1	mail	A	10.0.0.4	86400	\N	2010-04-20 11:49:11.391005	2010-04-20 11:49:11.391005
8	1	\N	MX	mail	86400	10	2010-04-20 11:49:11.416306	2010-04-20 11:49:11.416306
\.


--
-- Data for Name: records; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY records (id, domain_id, name, type, content, ttl, prio, change_date, created_at, updated_at) FROM stdin;
2	1	@.example.com	NS	ns1.example.com.	86400	\N	1271764150	2010-04-20 11:49:10.860105	2010-04-20 11:49:10.860105
3	1	@.example.com	NS	ns2.example.com.	86400	\N	1271764150	2010-04-20 11:49:10.893802	2010-04-20 11:49:10.893802
4	1	ns1.example.com	A	10.0.0.1	86400	\N	1271764150	2010-04-20 11:49:10.933472	2010-04-20 11:49:10.933472
5	1	ns2.example.com	A	10.0.0.2	86400	\N	1271764150	2010-04-20 11:49:10.966075	2010-04-20 11:49:10.966075
6	1	@.example.com	A	10.0.0.3	86400	\N	1271764150	2010-04-20 11:49:10.993101	2010-04-20 11:49:10.993101
7	1	@.example.com	MX	mail	86400	10	1271764151	2010-04-20 11:49:11.033515	2010-04-20 11:49:11.033515
8	1	mail.example.com	A	10.0.0.4	86400	\N	1271764151	2010-04-20 11:49:11.065663	2010-04-20 11:49:11.065663
1	1	example.com	SOA	ns1.example.com admin@example.com 2010042007 10800 7200 604800 10800	86400	\N	1271764151	2010-04-20 11:49:10.825025	2010-04-20 11:49:11.079112
53	7	displayboy.com	SOA	ns1.displayboy.com hostmaster.displayboy.com 1247948124 10800 1800 1209600 43200	3600	0	1271767049	\N	\N
54	7	displayboy.com	AAAA	2a01:198:200:4d9::2	3600	0	1271767049	\N	\N
55	7	displayboy.com	A	87.230.56.58	3600	0	1271767049	\N	\N
56	7	displayboy.com	MX	quimby.displayboy.com	3600	10	1271767049	\N	\N
57	7	displayboy.com	NS	ns1.displayboy.com	3600	0	1271767049	\N	\N
58	7	displayboy.com	NS	ns2.displayboy.com	3600	0	1271767049	\N	\N
59	7	displayboy.com	TXT	"v=spf1 mx ip4:62.206.130.229/32 ?all"	3600	0	1271767049	\N	\N
60	11	sexgoesmobile.com	SOA	ns1.displayboy.com hostmaster.displayboy.com 1268320361 10800 1800 1209600 43200	3600	0	1271767077	\N	\N
61	11	sexgoesmobile.com	A	87.230.56.58	3600	0	1271767077	\N	\N
62	11	sexgoesmobile.com	MX	quimby.displayboy.com	3600	10	1271767077	\N	\N
63	11	sexgoesmobile.com	NS	ns1.displayboy.com	3600	0	1271767077	\N	\N
64	11	sexgoesmobile.com	NS	ns2.displayboy.com	3600	0	1271767077	\N	\N
65	11	sexgoesmobile.com	TXT	"v=spf1 mx ip4:62.206.130.229/32 ?all"	3600	0	1271767077	\N	\N
66	11	www.sexgoesmobile.com	CNAME	marge.displayboy.com	3600	0	1271767077	\N	\N
67	11	sql.sexgoesmobile.com	A	87.230.83.22	3600	0	1271767077	\N	\N
68	11	beta.sexgoesmobile.com	CNAME	marge.displayboy.com	3600	0	1271767077	\N	\N
69	11	dev.sexgoesmobile.com	CNAME	marge.displayboy.com	3600	0	1271767077	\N	\N
70	11	devel.sexgoesmobile.com	CNAME	marge.displayboy.com	3600	0	1271767077	\N	\N
71	11	stage.sexgoesmobile.com	CNAME	marge.displayboy.com	3600	0	1271767077	\N	\N
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY roles (id, name) FROM stdin;
1	admin
2	owner
3	auth_token
\.


--
-- Data for Name: roles_users; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY roles_users (role_id, user_id) FROM stdin;
1	1
3	2
\.


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY schema_migrations (version) FROM stdin;
1
2
3
4
5
6
7
8
9
10
20081228121040
20090505124622
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY users (id, login, email, crypted_password, salt, created_at, updated_at, remember_token, remember_token_expires_at, activation_code, activated_at, state, deleted_at) FROM stdin;
1	admin	admin@example.com	a51783e6b58d3c25489496d8623ae99c17d0961e	00ca4202bfc97edc60f13b051a06071cfbff2d5d	2010-04-20 11:49:11.622413	2010-04-20 11:49:11.622413	\N	\N	\N	\N	active	\N
2	token	tokens@example.com	39f4785c1abf7fbba8bb13dd606758426305bed6	095ffb6950eb360ed2edc33f0d07d99dee5da25c	2010-04-20 11:49:12.068791	2010-04-20 11:49:12.068791	\N	\N	\N	\N	active	\N
\.


--
-- Data for Name: zone_templates; Type: TABLE DATA; Schema: public; Owner: powerdns
--

COPY zone_templates (id, name, ttl, created_at, updated_at, user_id) FROM stdin;
1	East Coast Data Center	86400	2010-04-20 11:49:11.111022	2010-04-20 11:49:11.111022	\N
\.


--
-- Name: audits_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY audits
    ADD CONSTRAINT audits_pkey PRIMARY KEY (id);


--
-- Name: auth_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY auth_tokens
    ADD CONSTRAINT auth_tokens_pkey PRIMARY KEY (id);


--
-- Name: domains_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY domains
    ADD CONSTRAINT domains_pkey PRIMARY KEY (id);


--
-- Name: macro_steps_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY macro_steps
    ADD CONSTRAINT macro_steps_pkey PRIMARY KEY (id);


--
-- Name: macros_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY macros
    ADD CONSTRAINT macros_pkey PRIMARY KEY (id);


--
-- Name: record_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY record_templates
    ADD CONSTRAINT record_templates_pkey PRIMARY KEY (id);


--
-- Name: records_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY records
    ADD CONSTRAINT records_pkey PRIMARY KEY (id);


--
-- Name: roles_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: zone_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: powerdns; Tablespace: 
--

ALTER TABLE ONLY zone_templates
    ADD CONSTRAINT zone_templates_pkey PRIMARY KEY (id);


--
-- Name: auditable_index; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX auditable_index ON audits USING btree (auditable_id, auditable_type);


--
-- Name: auditable_parent_index; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX auditable_parent_index ON audits USING btree (auditable_parent_id, auditable_parent_type);


--
-- Name: index_audits_on_created_at; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_audits_on_created_at ON audits USING btree (created_at);


--
-- Name: index_domains_on_name; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_domains_on_name ON domains USING btree (name);


--
-- Name: index_records_on_domain_id; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_records_on_domain_id ON records USING btree (domain_id);


--
-- Name: index_records_on_name; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_records_on_name ON records USING btree (name);


--
-- Name: index_records_on_name_and_type; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_records_on_name_and_type ON records USING btree (name, type);


--
-- Name: index_roles_users_on_role_id; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_roles_users_on_role_id ON roles_users USING btree (role_id);


--
-- Name: index_roles_users_on_user_id; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX index_roles_users_on_user_id ON roles_users USING btree (user_id);


--
-- Name: name_index; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE UNIQUE INDEX name_index ON domains USING btree (name);


--
-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);


--
-- Name: user_index; Type: INDEX; Schema: public; Owner: powerdns; Tablespace: 
--

CREATE INDEX user_index ON audits USING btree (user_id, user_type);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--