-- -- PostgreSQL database dump -- SET client_encoding = 'UNICODE'; SET check_function_bodies = false; SET client_min_messages = warning; -- -- Name: hellmachine; Type: SCHEMA; Schema: -; Owner: mailsystem -- CREATE SCHEMA hellmachine; ALTER SCHEMA hellmachine OWNER TO mailsystem; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; SET search_path = hellmachine, pg_catalog; SET default_tablespace = ''; SET default_with_oids = true; -- -- Name: postfix_access; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_access ( id serial NOT NULL, source character varying(128) DEFAULT ''::character varying NOT NULL, "access" character varying(128) DEFAULT ''::character varying NOT NULL, "type" character varying(128) DEFAULT 'recipient'::character varying NOT NULL, CONSTRAINT type_enum CHECK ((((("type")::text = 'recipient'::text) OR (("type")::text = 'sender'::text)) OR (("type")::text = 'client'::text))) ); ALTER TABLE hellmachine.postfix_access OWNER TO mailsystem; -- -- Name: postfix_alias; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_alias ( id serial NOT NULL, alias character varying(128) DEFAULT ''::character varying NOT NULL, destination character varying(128) DEFAULT ''::character varying NOT NULL ); ALTER TABLE hellmachine.postfix_alias OWNER TO mailsystem; -- -- Name: postfix_email; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_email ( id serial NOT NULL, email character varying(128) DEFAULT ''::character varying ); ALTER TABLE hellmachine.postfix_email OWNER TO mailsystem; -- -- Name: postfix_transport; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_transport ( id serial NOT NULL, "domain" character varying(128) DEFAULT ''::character varying NOT NULL, destination character varying(128) DEFAULT 'local:'::character varying NOT NULL, CONSTRAINT destination_enum CHECK (((((destination)::text = 'local:'::text) OR ((destination)::text = 'virtual:'::text)) OR ((destination)::text = 'dovecot:'::text))) ); ALTER TABLE hellmachine.postfix_transport OWNER TO mailsystem; -- -- Name: postfix_trash; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_trash ( id serial NOT NULL, email character varying(128) DEFAULT ''::character varying NOT NULL, destination character varying(128) DEFAULT ''::character varying NOT NULL ); ALTER TABLE hellmachine.postfix_trash OWNER TO mailsystem; -- -- Name: postfix_users; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_users ( id serial NOT NULL, email character varying(128) DEFAULT ''::character varying NOT NULL, "password" character varying(128) DEFAULT ''::character varying NOT NULL, name character varying(255) DEFAULT ''::character varying NOT NULL, uid integer DEFAULT 5000 NOT NULL, gid integer DEFAULT 5000 NOT NULL, maildir character varying(255) DEFAULT ''::character varying NOT NULL, quota character varying(64), "access" boolean DEFAULT true NOT NULL, postfix boolean DEFAULT true NOT NULL, homedir character varying(255) DEFAULT ''::character varying NOT NULL, admin boolean DEFAULT false NOT NULL, domainadmin boolean DEFAULT false NOT NULL ); ALTER TABLE hellmachine.postfix_users OWNER TO mailsystem; -- -- Name: postfix_virtual; Type: TABLE; Schema: hellmachine; Owner: mailsystem; Tablespace: -- CREATE TABLE postfix_virtual ( id serial NOT NULL, email character varying(128) DEFAULT ''::character varying NOT NULL, destination character varying(128) NOT NULL ); ALTER TABLE hellmachine.postfix_virtual OWNER TO mailsystem; -- -- Name: postfix_access_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_access ADD CONSTRAINT postfix_access_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_access_pkey OWNER TO mailsystem; -- -- Name: postfix_alias_alias_key; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_alias ADD CONSTRAINT postfix_alias_alias_key UNIQUE (alias); ALTER INDEX hellmachine.postfix_alias_alias_key OWNER TO mailsystem; -- -- Name: postfix_alias_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_alias ADD CONSTRAINT postfix_alias_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_alias_pkey OWNER TO mailsystem; -- -- Name: postfix_email_email_key; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_email ADD CONSTRAINT postfix_email_email_key UNIQUE (email); ALTER INDEX hellmachine.postfix_email_email_key OWNER TO mailsystem; -- -- Name: postfix_email_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_email ADD CONSTRAINT postfix_email_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_email_pkey OWNER TO mailsystem; -- -- Name: postfix_transport_domain_key; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_transport ADD CONSTRAINT postfix_transport_domain_key UNIQUE ("domain"); ALTER INDEX hellmachine.postfix_transport_domain_key OWNER TO mailsystem; -- -- Name: postfix_transport_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_transport ADD CONSTRAINT postfix_transport_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_transport_pkey OWNER TO mailsystem; -- -- Name: postfix_trash_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_trash ADD CONSTRAINT postfix_trash_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_trash_pkey OWNER TO mailsystem; -- -- Name: postfix_users_email_key; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_users ADD CONSTRAINT postfix_users_email_key UNIQUE (email); ALTER INDEX hellmachine.postfix_users_email_key OWNER TO mailsystem; -- -- Name: postfix_users_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_users ADD CONSTRAINT postfix_users_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_users_pkey OWNER TO mailsystem; -- -- Name: postfix_virtual_email_key; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_virtual ADD CONSTRAINT postfix_virtual_email_key UNIQUE (email); ALTER INDEX hellmachine.postfix_virtual_email_key OWNER TO mailsystem; -- -- Name: postfix_virtual_pkey; Type: CONSTRAINT; Schema: hellmachine; Owner: mailsystem; Tablespace: -- ALTER TABLE ONLY postfix_virtual ADD CONSTRAINT postfix_virtual_pkey PRIMARY KEY (id); ALTER INDEX hellmachine.postfix_virtual_pkey OWNER TO mailsystem; -- -- Name: hellmachine; Type: ACL; Schema: -; Owner: mailsystem -- REVOKE ALL ON SCHEMA hellmachine FROM PUBLIC; REVOKE ALL ON SCHEMA hellmachine FROM mailsystem; GRANT ALL ON SCHEMA hellmachine TO mailsystem; GRANT USAGE ON SCHEMA hellmachine TO dovecot; GRANT USAGE ON SCHEMA hellmachine TO postfix; -- -- 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; -- -- Name: postfix_access; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_access FROM PUBLIC; REVOKE ALL ON TABLE postfix_access FROM mailsystem; GRANT ALL ON TABLE postfix_access TO mailsystem; GRANT SELECT ON TABLE postfix_access TO postfix; -- -- Name: postfix_alias; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_alias FROM PUBLIC; REVOKE ALL ON TABLE postfix_alias FROM mailsystem; GRANT ALL ON TABLE postfix_alias TO mailsystem; GRANT SELECT ON TABLE postfix_alias TO postfix; -- -- Name: postfix_email; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_email FROM PUBLIC; REVOKE ALL ON TABLE postfix_email FROM mailsystem; GRANT ALL ON TABLE postfix_email TO mailsystem; GRANT SELECT ON TABLE postfix_email TO postfix; -- -- Name: postfix_transport; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_transport FROM PUBLIC; REVOKE ALL ON TABLE postfix_transport FROM mailsystem; GRANT ALL ON TABLE postfix_transport TO mailsystem; GRANT SELECT ON TABLE postfix_transport TO postfix; -- -- Name: postfix_trash; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_trash FROM PUBLIC; REVOKE ALL ON TABLE postfix_trash FROM mailsystem; GRANT ALL ON TABLE postfix_trash TO mailsystem; GRANT SELECT ON TABLE postfix_trash TO postfix; -- -- Name: postfix_users; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_users FROM PUBLIC; REVOKE ALL ON TABLE postfix_users FROM mailsystem; GRANT ALL ON TABLE postfix_users TO mailsystem; GRANT SELECT ON TABLE postfix_users TO dovecot; GRANT SELECT ON TABLE postfix_users TO postfix; -- -- Name: postfix_virtual; Type: ACL; Schema: hellmachine; Owner: mailsystem -- REVOKE ALL ON TABLE postfix_virtual FROM PUBLIC; REVOKE ALL ON TABLE postfix_virtual FROM mailsystem; GRANT ALL ON TABLE postfix_virtual TO mailsystem; GRANT SELECT ON TABLE postfix_virtual TO postfix; -- -- PostgreSQL database dump complete --