Dre4m Shell
Server IP : 85.214.239.14  /  Your IP : 18.118.10.75
Web Server : Apache/2.4.62 (Debian)
System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64
User : www-data ( 33)
PHP Version : 7.4.18
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
MySQL : OFF  |  cURL : OFF  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : OFF
Directory :  /proc/2/root/proc/3/root/var/lib/postgresql/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME SHELL ]     

Current File : /proc/2/root/proc/3/root/var/lib/postgresql/all_databases_backup.sql
--
-- PostgreSQL database cluster dump
--

SET default_transaction_read_only = off;

SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;

--
-- Roles
--

CREATE ROLE amavis;
ALTER ROLE amavis WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md5495ae7c40a47370f8d7d8a1dc1c9f000';
CREATE ROLE modoboa;
ALTER ROLE modoboa WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md5022c78120da31009aeb161caa5f1d6eb';
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;
CREATE ROLE spamassassin;
ALTER ROLE spamassassin WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'md513940cfac1811cdb278ace29e6d984b3';






--
-- Database creation
--

CREATE DATABASE amavis WITH TEMPLATE = template0 OWNER = amavis;
GRANT ALL ON DATABASE amavis TO modoboa;
CREATE DATABASE modoboa WITH TEMPLATE = template0 OWNER = modoboa;
CREATE DATABASE spamassassin WITH TEMPLATE = template0 OWNER = spamassassin;
REVOKE CONNECT,TEMPORARY ON DATABASE template1 FROM PUBLIC;
GRANT CONNECT ON DATABASE template1 TO PUBLIC;


\connect amavis

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.24
-- Dumped by pg_dump version 9.6.24

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: maddr; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.maddr (
    id integer NOT NULL,
    partition_tag integer DEFAULT 0,
    email bytea NOT NULL,
    domain character varying(255) NOT NULL
);


ALTER TABLE public.maddr OWNER TO amavis;

--
-- Name: maddr_id_seq; Type: SEQUENCE; Schema: public; Owner: amavis
--

CREATE SEQUENCE public.maddr_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.maddr_id_seq OWNER TO amavis;

--
-- Name: maddr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amavis
--

ALTER SEQUENCE public.maddr_id_seq OWNED BY public.maddr.id;


--
-- Name: mailaddr; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.mailaddr (
    id integer NOT NULL,
    priority integer DEFAULT 9 NOT NULL,
    email bytea NOT NULL
);


ALTER TABLE public.mailaddr OWNER TO amavis;

--
-- Name: mailaddr_id_seq; Type: SEQUENCE; Schema: public; Owner: amavis
--

CREATE SEQUENCE public.mailaddr_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.mailaddr_id_seq OWNER TO amavis;

--
-- Name: mailaddr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amavis
--

ALTER SEQUENCE public.mailaddr_id_seq OWNED BY public.mailaddr.id;


--
-- Name: msgrcpt; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.msgrcpt (
    partition_tag integer DEFAULT 0 NOT NULL,
    mail_id bytea NOT NULL,
    rseqnum integer DEFAULT 0 NOT NULL,
    rid integer NOT NULL,
    is_local character(1) DEFAULT ' '::bpchar NOT NULL,
    content character(1) DEFAULT ' '::bpchar NOT NULL,
    ds character(1) NOT NULL,
    rs character(1) NOT NULL,
    bl character(1) DEFAULT ' '::bpchar,
    wl character(1) DEFAULT ' '::bpchar,
    bspam_level real,
    smtp_resp character varying(255) DEFAULT ''::character varying
);


ALTER TABLE public.msgrcpt OWNER TO amavis;

--
-- Name: msgs; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.msgs (
    partition_tag integer DEFAULT 0 NOT NULL,
    mail_id bytea NOT NULL,
    secret_id bytea DEFAULT '\x'::bytea,
    am_id character varying(20) NOT NULL,
    time_num integer NOT NULL,
    time_iso timestamp with time zone NOT NULL,
    sid integer NOT NULL,
    policy character varying(255) DEFAULT ''::character varying,
    client_addr character varying(255) DEFAULT ''::character varying,
    size integer NOT NULL,
    originating character(1) DEFAULT ' '::bpchar NOT NULL,
    content character(1),
    quar_type character(1),
    quar_loc character varying(255) DEFAULT ''::character varying,
    dsn_sent character(1),
    spam_level real,
    message_id character varying(255) DEFAULT ''::character varying,
    from_addr character varying(255) DEFAULT ''::character varying,
    subject character varying(255) DEFAULT ''::character varying,
    host character varying(255) NOT NULL,
    CONSTRAINT msgs_sid_check CHECK ((sid >= 0)),
    CONSTRAINT msgs_size_check CHECK ((size >= 0)),
    CONSTRAINT msgs_time_num_check CHECK ((time_num >= 0))
);


ALTER TABLE public.msgs OWNER TO amavis;

--
-- Name: policy; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.policy (
    id integer NOT NULL,
    policy_name character varying(32),
    virus_lover character(1) DEFAULT NULL::bpchar,
    spam_lover character(1) DEFAULT NULL::bpchar,
    unchecked_lover character(1) DEFAULT NULL::bpchar,
    banned_files_lover character(1) DEFAULT NULL::bpchar,
    bad_header_lover character(1) DEFAULT NULL::bpchar,
    bypass_virus_checks character(1) DEFAULT NULL::bpchar,
    bypass_spam_checks character(1) DEFAULT NULL::bpchar,
    bypass_banned_checks character(1) DEFAULT NULL::bpchar,
    bypass_header_checks character(1) DEFAULT NULL::bpchar,
    virus_quarantine_to character varying(64) DEFAULT NULL::character varying,
    spam_quarantine_to character varying(64) DEFAULT NULL::character varying,
    banned_quarantine_to character varying(64) DEFAULT NULL::character varying,
    unchecked_quarantine_to character varying(64) DEFAULT NULL::character varying,
    bad_header_quarantine_to character varying(64) DEFAULT NULL::character varying,
    clean_quarantine_to character varying(64) DEFAULT NULL::character varying,
    archive_quarantine_to character varying(64) DEFAULT NULL::character varying,
    spam_tag_level real,
    spam_tag2_level real,
    spam_tag3_level real,
    spam_kill_level real,
    spam_dsn_cutoff_level real,
    spam_quarantine_cutoff_level real,
    addr_extension_virus character varying(64) DEFAULT NULL::character varying,
    addr_extension_spam character varying(64) DEFAULT NULL::character varying,
    addr_extension_banned character varying(64) DEFAULT NULL::character varying,
    addr_extension_bad_header character varying(64) DEFAULT NULL::character varying,
    warnvirusrecip character(1) DEFAULT NULL::bpchar,
    warnbannedrecip character(1) DEFAULT NULL::bpchar,
    warnbadhrecip character(1) DEFAULT NULL::bpchar,
    newvirus_admin character varying(64) DEFAULT NULL::character varying,
    virus_admin character varying(64) DEFAULT NULL::character varying,
    banned_admin character varying(64) DEFAULT NULL::character varying,
    bad_header_admin character varying(64) DEFAULT NULL::character varying,
    spam_admin character varying(64) DEFAULT NULL::character varying,
    spam_subject_tag character varying(64) DEFAULT NULL::character varying,
    spam_subject_tag2 character varying(64) DEFAULT NULL::character varying,
    spam_subject_tag3 character varying(64) DEFAULT NULL::character varying,
    message_size_limit integer,
    banned_rulenames character varying(64) DEFAULT NULL::character varying,
    disclaimer_options character varying(64) DEFAULT NULL::character varying,
    forward_method character varying(64) DEFAULT NULL::character varying,
    sa_userconf character varying(64) DEFAULT NULL::character varying,
    sa_username character varying(64) DEFAULT NULL::character varying
);


ALTER TABLE public.policy OWNER TO amavis;

--
-- Name: policy_id_seq; Type: SEQUENCE; Schema: public; Owner: amavis
--

CREATE SEQUENCE public.policy_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.policy_id_seq OWNER TO amavis;

--
-- Name: policy_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: amavis
--

ALTER SEQUENCE public.policy_id_seq OWNED BY public.policy.id;


--
-- Name: quarantine; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.quarantine (
    partition_tag integer DEFAULT 0 NOT NULL,
    mail_id bytea NOT NULL,
    chunk_ind integer NOT NULL,
    mail_text bytea NOT NULL,
    CONSTRAINT quarantine_chunk_ind_check CHECK ((chunk_ind >= 0))
);


ALTER TABLE public.quarantine OWNER TO amavis;

--
-- Name: users; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.users (
    id integer NOT NULL,
    priority integer DEFAULT 7 NOT NULL,
    policy_id integer DEFAULT 1 NOT NULL,
    email bytea NOT NULL,
    fullname character varying(255) DEFAULT NULL::character varying,
    CONSTRAINT users_policy_id_check CHECK ((policy_id >= 0))
);


ALTER TABLE public.users OWNER TO amavis;

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

CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO amavis;

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

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: wblist; Type: TABLE; Schema: public; Owner: amavis
--

CREATE TABLE public.wblist (
    rid integer NOT NULL,
    sid integer NOT NULL,
    wb character varying(10) NOT NULL,
    CONSTRAINT wblist_rid_check CHECK ((rid >= 0)),
    CONSTRAINT wblist_sid_check CHECK ((sid >= 0))
);


ALTER TABLE public.wblist OWNER TO amavis;

--
-- Name: maddr id; Type: DEFAULT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.maddr ALTER COLUMN id SET DEFAULT nextval('public.maddr_id_seq'::regclass);


--
-- Name: mailaddr id; Type: DEFAULT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.mailaddr ALTER COLUMN id SET DEFAULT nextval('public.mailaddr_id_seq'::regclass);


--
-- Name: policy id; Type: DEFAULT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.policy ALTER COLUMN id SET DEFAULT nextval('public.policy_id_seq'::regclass);


--
-- Name: users id; Type: DEFAULT; Schema: public; Owner: amavis
--

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


--
-- Data for Name: maddr; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.maddr (id, partition_tag, email, domain) FROM stdin;
\.


--
-- Name: maddr_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amavis
--

SELECT pg_catalog.setval('public.maddr_id_seq', 1, false);


--
-- Data for Name: mailaddr; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.mailaddr (id, priority, email) FROM stdin;
\.


--
-- Name: mailaddr_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amavis
--

SELECT pg_catalog.setval('public.mailaddr_id_seq', 1, false);


--
-- Data for Name: msgrcpt; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.msgrcpt (partition_tag, mail_id, rseqnum, rid, is_local, content, ds, rs, bl, wl, bspam_level, smtp_resp) FROM stdin;
\.


--
-- Data for Name: msgs; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.msgs (partition_tag, mail_id, secret_id, am_id, time_num, time_iso, sid, policy, client_addr, size, originating, content, quar_type, quar_loc, dsn_sent, spam_level, message_id, from_addr, subject, host) FROM stdin;
\.


--
-- Data for Name: policy; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.policy (id, policy_name, virus_lover, spam_lover, unchecked_lover, banned_files_lover, bad_header_lover, bypass_virus_checks, bypass_spam_checks, bypass_banned_checks, bypass_header_checks, virus_quarantine_to, spam_quarantine_to, banned_quarantine_to, unchecked_quarantine_to, bad_header_quarantine_to, clean_quarantine_to, archive_quarantine_to, spam_tag_level, spam_tag2_level, spam_tag3_level, spam_kill_level, spam_dsn_cutoff_level, spam_quarantine_cutoff_level, addr_extension_virus, addr_extension_spam, addr_extension_banned, addr_extension_bad_header, warnvirusrecip, warnbannedrecip, warnbadhrecip, newvirus_admin, virus_admin, banned_admin, bad_header_admin, spam_admin, spam_subject_tag, spam_subject_tag2, spam_subject_tag3, message_size_limit, banned_rulenames, disclaimer_options, forward_method, sa_userconf, sa_username) FROM stdin;
\.


--
-- Name: policy_id_seq; Type: SEQUENCE SET; Schema: public; Owner: amavis
--

SELECT pg_catalog.setval('public.policy_id_seq', 1, false);


--
-- Data for Name: quarantine; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.quarantine (partition_tag, mail_id, chunk_ind, mail_text) FROM stdin;
\.


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

COPY public.users (id, priority, policy_id, email, fullname) FROM stdin;
\.


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

SELECT pg_catalog.setval('public.users_id_seq', 1, false);


--
-- Data for Name: wblist; Type: TABLE DATA; Schema: public; Owner: amavis
--

COPY public.wblist (rid, sid, wb) FROM stdin;
\.


--
-- Name: maddr maddr_pkey; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.maddr
    ADD CONSTRAINT maddr_pkey PRIMARY KEY (id);


--
-- Name: mailaddr mailaddr_email_key; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.mailaddr
    ADD CONSTRAINT mailaddr_email_key UNIQUE (email);


--
-- Name: mailaddr mailaddr_pkey; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.mailaddr
    ADD CONSTRAINT mailaddr_pkey PRIMARY KEY (id);


--
-- Name: msgrcpt msgrcpt_partition_mail_rseq; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.msgrcpt
    ADD CONSTRAINT msgrcpt_partition_mail_rseq PRIMARY KEY (partition_tag, mail_id, rseqnum);


--
-- Name: msgs msgs_partition_mail; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.msgs
    ADD CONSTRAINT msgs_partition_mail PRIMARY KEY (partition_tag, mail_id);


--
-- Name: maddr part_email; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.maddr
    ADD CONSTRAINT part_email UNIQUE (partition_tag, email);


--
-- Name: policy policy_pkey; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.policy
    ADD CONSTRAINT policy_pkey PRIMARY KEY (id);


--
-- Name: quarantine quarantine_pkey; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.quarantine
    ADD CONSTRAINT quarantine_pkey PRIMARY KEY (partition_tag, mail_id, chunk_ind);


--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: amavis
--

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


--
-- Name: wblist wblist_pkey; Type: CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.wblist
    ADD CONSTRAINT wblist_pkey PRIMARY KEY (rid, sid);


--
-- Name: msgrcpt_idx_mail_id; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgrcpt_idx_mail_id ON public.msgrcpt USING btree (mail_id);


--
-- Name: msgrcpt_idx_rid; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgrcpt_idx_rid ON public.msgrcpt USING btree (rid);


--
-- Name: msgrcpt_idx_rs; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgrcpt_idx_rs ON public.msgrcpt USING btree (rs);


--
-- Name: msgs_idx_mess_id; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgs_idx_mess_id ON public.msgs USING btree (message_id);


--
-- Name: msgs_idx_sid; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgs_idx_sid ON public.msgs USING btree (sid);


--
-- Name: msgs_idx_time_iso; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgs_idx_time_iso ON public.msgs USING btree (time_iso);


--
-- Name: msgs_idx_time_num; Type: INDEX; Schema: public; Owner: amavis
--

CREATE INDEX msgs_idx_time_num ON public.msgs USING btree (time_num);


--
-- Name: users users_policy_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_policy_id_fkey FOREIGN KEY (policy_id) REFERENCES public.policy(id);


--
-- Name: wblist wblist_rid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.wblist
    ADD CONSTRAINT wblist_rid_fkey FOREIGN KEY (rid) REFERENCES public.users(id);


--
-- Name: wblist wblist_sid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: amavis
--

ALTER TABLE ONLY public.wblist
    ADD CONSTRAINT wblist_sid_fkey FOREIGN KEY (sid) REFERENCES public.mailaddr(id);


--
-- PostgreSQL database dump complete
--

\connect modoboa

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.24
-- Dumped by pg_dump version 9.6.24

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: admin_alias; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_alias (
    id integer NOT NULL,
    address character varying(254) NOT NULL,
    enabled boolean NOT NULL,
    internal boolean NOT NULL,
    domain_id integer,
    description text NOT NULL,
    expire_at timestamp with time zone,
    creation timestamp with time zone NOT NULL,
    last_modification timestamp with time zone NOT NULL
);


ALTER TABLE public.admin_alias OWNER TO modoboa;

--
-- Name: admin_alias_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_alias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_alias_id_seq OWNER TO modoboa;

--
-- Name: admin_alias_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_alias_id_seq OWNED BY public.admin_alias.id;


--
-- Name: admin_dnsblresult; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_dnsblresult (
    id integer NOT NULL,
    provider character varying(254) NOT NULL,
    status character varying(45) NOT NULL,
    domain_id integer NOT NULL,
    mx_id integer NOT NULL
);


ALTER TABLE public.admin_dnsblresult OWNER TO modoboa;

--
-- Name: admin_dnsblresult_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_dnsblresult_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_dnsblresult_id_seq OWNER TO modoboa;

--
-- Name: admin_dnsblresult_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_dnsblresult_id_seq OWNED BY public.admin_dnsblresult.id;


--
-- Name: admin_domain; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_domain (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    default_mailbox_quota integer NOT NULL,
    enabled boolean NOT NULL,
    type character varying(20) NOT NULL,
    creation timestamp with time zone NOT NULL,
    last_modification timestamp with time zone NOT NULL,
    enable_dns_checks boolean NOT NULL,
    quota integer NOT NULL,
    transport_id integer,
    dkim_key_length integer,
    dkim_key_selector character varying(30) NOT NULL,
    dkim_private_key_path character varying(254) NOT NULL,
    dkim_public_key text NOT NULL,
    enable_dkim boolean NOT NULL,
    CONSTRAINT admin_domain_default_mailbox_quota_06dd964e_check CHECK ((default_mailbox_quota >= 0)),
    CONSTRAINT admin_domain_dkim_key_length_check CHECK ((dkim_key_length >= 0)),
    CONSTRAINT admin_domain_quota_check CHECK ((quota >= 0))
);


ALTER TABLE public.admin_domain OWNER TO modoboa;

--
-- Name: admin_domain_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_domain_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_domain_id_seq OWNER TO modoboa;

--
-- Name: admin_domain_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_domain_id_seq OWNED BY public.admin_domain.id;


--
-- Name: admin_domainalias; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_domainalias (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    enabled boolean NOT NULL,
    target_id integer NOT NULL,
    creation timestamp with time zone NOT NULL,
    last_modification timestamp with time zone NOT NULL
);


ALTER TABLE public.admin_domainalias OWNER TO modoboa;

--
-- Name: admin_domainalias_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_domainalias_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_domainalias_id_seq OWNER TO modoboa;

--
-- Name: admin_domainalias_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_domainalias_id_seq OWNED BY public.admin_domainalias.id;


--
-- Name: admin_mailbox; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_mailbox (
    id integer NOT NULL,
    address character varying(252) NOT NULL,
    quota integer NOT NULL,
    use_domain_quota boolean NOT NULL,
    domain_id integer NOT NULL,
    user_id integer NOT NULL,
    creation timestamp with time zone NOT NULL,
    last_modification timestamp with time zone NOT NULL,
    CONSTRAINT admin_mailbox_quota_check CHECK ((quota >= 0))
);


ALTER TABLE public.admin_mailbox OWNER TO modoboa;

--
-- Name: admin_mailbox_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_mailbox_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_mailbox_id_seq OWNER TO modoboa;

--
-- Name: admin_mailbox_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_mailbox_id_seq OWNED BY public.admin_mailbox.id;


--
-- Name: admin_mailboxoperation; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_mailboxoperation (
    id integer NOT NULL,
    type character varying(20) NOT NULL,
    argument text NOT NULL,
    mailbox_id integer
);


ALTER TABLE public.admin_mailboxoperation OWNER TO modoboa;

--
-- Name: admin_mailboxoperation_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_mailboxoperation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_mailboxoperation_id_seq OWNER TO modoboa;

--
-- Name: admin_mailboxoperation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_mailboxoperation_id_seq OWNED BY public.admin_mailboxoperation.id;


--
-- Name: admin_mxrecord; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_mxrecord (
    id integer NOT NULL,
    name character varying(254) NOT NULL,
    address inet NOT NULL,
    managed boolean NOT NULL,
    updated timestamp with time zone NOT NULL,
    domain_id integer NOT NULL
);


ALTER TABLE public.admin_mxrecord OWNER TO modoboa;

--
-- Name: admin_mxrecord_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_mxrecord_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_mxrecord_id_seq OWNER TO modoboa;

--
-- Name: admin_mxrecord_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_mxrecord_id_seq OWNED BY public.admin_mxrecord.id;


--
-- Name: admin_quota; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_quota (
    username character varying(254) NOT NULL,
    bytes bigint NOT NULL,
    messages integer NOT NULL
);


ALTER TABLE public.admin_quota OWNER TO modoboa;

--
-- Name: admin_senderaddress; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.admin_senderaddress (
    id integer NOT NULL,
    address character varying(254) NOT NULL,
    mailbox_id integer NOT NULL
);


ALTER TABLE public.admin_senderaddress OWNER TO modoboa;

--
-- Name: admin_senderaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.admin_senderaddress_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_senderaddress_id_seq OWNER TO modoboa;

--
-- Name: admin_senderaddress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.admin_senderaddress_id_seq OWNED BY public.admin_senderaddress.id;


--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO modoboa;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_id_seq OWNER TO modoboa;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO modoboa;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_permissions_id_seq OWNER TO modoboa;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.auth_group_permissions_id_seq OWNED BY public.auth_group_permissions.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO modoboa;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_permission_id_seq OWNER TO modoboa;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id;


--
-- Name: authtoken_token; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.authtoken_token (
    key character varying(40) NOT NULL,
    created timestamp with time zone NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.authtoken_token OWNER TO modoboa;

--
-- Name: core_extensionupdatehistory; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_extensionupdatehistory (
    id integer NOT NULL,
    extension character varying(100) NOT NULL,
    version character varying(30) NOT NULL
);


ALTER TABLE public.core_extensionupdatehistory OWNER TO modoboa;

--
-- Name: core_extensionupdatehistory_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_extensionupdatehistory_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_extensionupdatehistory_id_seq OWNER TO modoboa;

--
-- Name: core_extensionupdatehistory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_extensionupdatehistory_id_seq OWNED BY public.core_extensionupdatehistory.id;


--
-- Name: core_localconfig; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_localconfig (
    id integer NOT NULL,
    api_pk integer,
    api_versions text NOT NULL,
    site_id integer NOT NULL,
    _parameters text NOT NULL,
    need_dovecot_update boolean NOT NULL,
    CONSTRAINT core_localconfig_api_pk_check CHECK ((api_pk >= 0))
);


ALTER TABLE public.core_localconfig OWNER TO modoboa;

--
-- Name: core_localconfig_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_localconfig_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_localconfig_id_seq OWNER TO modoboa;

--
-- Name: core_localconfig_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_localconfig_id_seq OWNED BY public.core_localconfig.id;


--
-- Name: core_log; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_log (
    id integer NOT NULL,
    date_created timestamp with time zone NOT NULL,
    message text NOT NULL,
    level character varying(15) NOT NULL,
    logger character varying(30) NOT NULL
);


ALTER TABLE public.core_log OWNER TO modoboa;

--
-- Name: core_log_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_log_id_seq OWNER TO modoboa;

--
-- Name: core_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_log_id_seq OWNED BY public.core_log.id;


--
-- Name: core_objectaccess; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_objectaccess (
    id integer NOT NULL,
    object_id integer NOT NULL,
    is_owner boolean NOT NULL,
    content_type_id integer NOT NULL,
    user_id integer NOT NULL,
    CONSTRAINT core_objectaccess_object_id_check CHECK ((object_id >= 0))
);


ALTER TABLE public.core_objectaccess OWNER TO modoboa;

--
-- Name: core_objectaccess_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_objectaccess_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_objectaccess_id_seq OWNER TO modoboa;

--
-- Name: core_objectaccess_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_objectaccess_id_seq OWNED BY public.core_objectaccess.id;


--
-- Name: core_user; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_user (
    id integer NOT NULL,
    is_superuser boolean NOT NULL,
    username character varying(254) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(150) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    is_local boolean NOT NULL,
    password character varying(256) NOT NULL,
    last_login timestamp with time zone,
    master_user boolean NOT NULL,
    language character varying(10) NOT NULL,
    phone_number character varying(128),
    secondary_email character varying(254),
    _parameters text NOT NULL
);


ALTER TABLE public.core_user OWNER TO modoboa;

--
-- Name: core_user_groups; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.core_user_groups OWNER TO modoboa;

--
-- Name: core_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_user_groups_id_seq OWNER TO modoboa;

--
-- Name: core_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_user_groups_id_seq OWNED BY public.core_user_groups.id;


--
-- Name: core_user_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_user_id_seq OWNER TO modoboa;

--
-- Name: core_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_user_id_seq OWNED BY public.core_user.id;


--
-- Name: core_user_user_permissions; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.core_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.core_user_user_permissions OWNER TO modoboa;

--
-- Name: core_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.core_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.core_user_user_permissions_id_seq OWNER TO modoboa;

--
-- Name: core_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.core_user_user_permissions_id_seq OWNED BY public.core_user_user_permissions.id;


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO modoboa;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_content_type_id_seq OWNER TO modoboa;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.django_content_type_id_seq OWNED BY public.django_content_type.id;


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.django_migrations (
    id integer NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO modoboa;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_migrations_id_seq OWNER TO modoboa;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.django_migrations_id_seq OWNED BY public.django_migrations.id;


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO modoboa;

--
-- Name: django_site; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.django_site (
    id integer NOT NULL,
    domain character varying(100) NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.django_site OWNER TO modoboa;

--
-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.django_site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_site_id_seq OWNER TO modoboa;

--
-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.django_site_id_seq OWNED BY public.django_site.id;


--
-- Name: dnstools_dnsrecord; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.dnstools_dnsrecord (
    id integer NOT NULL,
    type character varying(15) NOT NULL,
    value text NOT NULL,
    is_valid boolean NOT NULL,
    error character varying(50),
    updated timestamp with time zone NOT NULL,
    domain_id integer NOT NULL
);


ALTER TABLE public.dnstools_dnsrecord OWNER TO modoboa;

--
-- Name: dnstools_dnsrecord_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.dnstools_dnsrecord_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dnstools_dnsrecord_id_seq OWNER TO modoboa;

--
-- Name: dnstools_dnsrecord_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.dnstools_dnsrecord_id_seq OWNED BY public.dnstools_dnsrecord.id;


--
-- Name: limits_domainobjectlimit; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.limits_domainobjectlimit (
    id integer NOT NULL,
    name character varying(254) NOT NULL,
    max_value integer NOT NULL,
    domain_id integer NOT NULL
);


ALTER TABLE public.limits_domainobjectlimit OWNER TO modoboa;

--
-- Name: limits_domainobjectlimit_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.limits_domainobjectlimit_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.limits_domainobjectlimit_id_seq OWNER TO modoboa;

--
-- Name: limits_domainobjectlimit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.limits_domainobjectlimit_id_seq OWNED BY public.limits_domainobjectlimit.id;


--
-- Name: limits_userobjectlimit; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.limits_userobjectlimit (
    id integer NOT NULL,
    name character varying(254) NOT NULL,
    max_value integer NOT NULL,
    content_type_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.limits_userobjectlimit OWNER TO modoboa;

--
-- Name: limits_userobjectlimit_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.limits_userobjectlimit_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.limits_userobjectlimit_id_seq OWNER TO modoboa;

--
-- Name: limits_userobjectlimit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.limits_userobjectlimit_id_seq OWNED BY public.limits_userobjectlimit.id;


--
-- Name: modoboa_admin_aliasrecipient; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_admin_aliasrecipient (
    id integer NOT NULL,
    address character varying(254) NOT NULL,
    alias_id integer NOT NULL,
    r_alias_id integer,
    r_mailbox_id integer
);


ALTER TABLE public.modoboa_admin_aliasrecipient OWNER TO modoboa;

--
-- Name: modoboa_admin_aliasrecipient_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_admin_aliasrecipient_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_admin_aliasrecipient_id_seq OWNER TO modoboa;

--
-- Name: modoboa_admin_aliasrecipient_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_admin_aliasrecipient_id_seq OWNED BY public.modoboa_admin_aliasrecipient.id;


--
-- Name: modoboa_contacts_addressbook; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_contacts_addressbook (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    sync_token text NOT NULL,
    last_sync timestamp with time zone,
    user_id integer NOT NULL,
    _path text NOT NULL
);


ALTER TABLE public.modoboa_contacts_addressbook OWNER TO modoboa;

--
-- Name: modoboa_contacts_addressbook_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_contacts_addressbook_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_contacts_addressbook_id_seq OWNER TO modoboa;

--
-- Name: modoboa_contacts_addressbook_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_contacts_addressbook_id_seq OWNED BY public.modoboa_contacts_addressbook.id;


--
-- Name: modoboa_contacts_category; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_contacts_category (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.modoboa_contacts_category OWNER TO modoboa;

--
-- Name: modoboa_contacts_category_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_contacts_category_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_contacts_category_id_seq OWNER TO modoboa;

--
-- Name: modoboa_contacts_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_contacts_category_id_seq OWNED BY public.modoboa_contacts_category.id;


--
-- Name: modoboa_contacts_contact; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_contacts_contact (
    id integer NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    display_name character varying(60) NOT NULL,
    birth_date date,
    company character varying(100) NOT NULL,
    "position" character varying(200) NOT NULL,
    address character varying(200) NOT NULL,
    zipcode character varying(15) NOT NULL,
    city character varying(100) NOT NULL,
    country character varying(100) NOT NULL,
    state character varying(100) NOT NULL,
    note text NOT NULL,
    uid character varying(100),
    etag text NOT NULL,
    addressbook_id integer NOT NULL
);


ALTER TABLE public.modoboa_contacts_contact OWNER TO modoboa;

--
-- Name: modoboa_contacts_contact_categories; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_contacts_contact_categories (
    id integer NOT NULL,
    contact_id integer NOT NULL,
    category_id integer NOT NULL
);


ALTER TABLE public.modoboa_contacts_contact_categories OWNER TO modoboa;

--
-- Name: modoboa_contacts_contact_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_contacts_contact_categories_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_contacts_contact_categories_id_seq OWNER TO modoboa;

--
-- Name: modoboa_contacts_contact_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_contacts_contact_categories_id_seq OWNED BY public.modoboa_contacts_contact_categories.id;


--
-- Name: modoboa_contacts_contact_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_contacts_contact_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_contacts_contact_id_seq OWNER TO modoboa;

--
-- Name: modoboa_contacts_contact_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_contacts_contact_id_seq OWNED BY public.modoboa_contacts_contact.id;


--
-- Name: modoboa_contacts_emailaddress; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_contacts_emailaddress (
    id integer NOT NULL,
    address character varying(254) NOT NULL,
    type character varying(20) NOT NULL,
    contact_id integer NOT NULL
);


ALTER TABLE public.modoboa_contacts_emailaddress OWNER TO modoboa;

--
-- Name: modoboa_contacts_emailaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_contacts_emailaddress_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_contacts_emailaddress_id_seq OWNER TO modoboa;

--
-- Name: modoboa_contacts_emailaddress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_contacts_emailaddress_id_seq OWNED BY public.modoboa_contacts_emailaddress.id;


--
-- Name: modoboa_contacts_phonenumber; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.modoboa_contacts_phonenumber (
    id integer NOT NULL,
    number character varying(40) NOT NULL,
    type character varying(20) NOT NULL,
    contact_id integer NOT NULL
);


ALTER TABLE public.modoboa_contacts_phonenumber OWNER TO modoboa;

--
-- Name: modoboa_contacts_phonenumber_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.modoboa_contacts_phonenumber_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.modoboa_contacts_phonenumber_id_seq OWNER TO modoboa;

--
-- Name: modoboa_contacts_phonenumber_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.modoboa_contacts_phonenumber_id_seq OWNED BY public.modoboa_contacts_phonenumber.id;


--
-- Name: postfix_autoreply_arhistoric; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.postfix_autoreply_arhistoric (
    id integer NOT NULL,
    last_sent timestamp with time zone NOT NULL,
    sender character varying(254) NOT NULL,
    armessage_id integer NOT NULL
);


ALTER TABLE public.postfix_autoreply_arhistoric OWNER TO modoboa;

--
-- Name: postfix_autoreply_arhistoric_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.postfix_autoreply_arhistoric_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.postfix_autoreply_arhistoric_id_seq OWNER TO modoboa;

--
-- Name: postfix_autoreply_arhistoric_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.postfix_autoreply_arhistoric_id_seq OWNED BY public.postfix_autoreply_arhistoric.id;


--
-- Name: postfix_autoreply_armessage; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.postfix_autoreply_armessage (
    id integer NOT NULL,
    subject character varying(255) NOT NULL,
    content text NOT NULL,
    enabled boolean NOT NULL,
    fromdate timestamp with time zone NOT NULL,
    untildate timestamp with time zone,
    mbox_id integer NOT NULL
);


ALTER TABLE public.postfix_autoreply_armessage OWNER TO modoboa;

--
-- Name: postfix_autoreply_armessage_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.postfix_autoreply_armessage_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.postfix_autoreply_armessage_id_seq OWNER TO modoboa;

--
-- Name: postfix_autoreply_armessage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.postfix_autoreply_armessage_id_seq OWNED BY public.postfix_autoreply_armessage.id;


--
-- Name: radicale_accessrule; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.radicale_accessrule (
    id integer NOT NULL,
    read boolean NOT NULL,
    write boolean NOT NULL,
    last_update timestamp with time zone NOT NULL,
    calendar_id integer NOT NULL,
    mailbox_id integer NOT NULL
);


ALTER TABLE public.radicale_accessrule OWNER TO modoboa;

--
-- Name: radicale_accessrule_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.radicale_accessrule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.radicale_accessrule_id_seq OWNER TO modoboa;

--
-- Name: radicale_accessrule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.radicale_accessrule_id_seq OWNED BY public.radicale_accessrule.id;


--
-- Name: radicale_sharedcalendar; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.radicale_sharedcalendar (
    id integer NOT NULL,
    name character varying(200) NOT NULL,
    domain_id integer NOT NULL,
    color character varying(7) NOT NULL,
    _path text NOT NULL,
    access_token character varying(50) NOT NULL
);


ALTER TABLE public.radicale_sharedcalendar OWNER TO modoboa;

--
-- Name: radicale_sharedcalendar_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.radicale_sharedcalendar_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.radicale_sharedcalendar_id_seq OWNER TO modoboa;

--
-- Name: radicale_sharedcalendar_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.radicale_sharedcalendar_id_seq OWNED BY public.radicale_sharedcalendar.id;


--
-- Name: radicale_usercalendar; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.radicale_usercalendar (
    id integer NOT NULL,
    name character varying(200) NOT NULL,
    mailbox_id integer NOT NULL,
    color character varying(7) NOT NULL,
    _path text NOT NULL,
    access_token character varying(50) NOT NULL
);


ALTER TABLE public.radicale_usercalendar OWNER TO modoboa;

--
-- Name: radicale_usercalendar_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.radicale_usercalendar_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.radicale_usercalendar_id_seq OWNER TO modoboa;

--
-- Name: radicale_usercalendar_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.radicale_usercalendar_id_seq OWNED BY public.radicale_usercalendar.id;


--
-- Name: relaydomains_recipientaccess; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.relaydomains_recipientaccess (
    id integer NOT NULL,
    pattern character varying(254) NOT NULL,
    action character varying(40) NOT NULL
);


ALTER TABLE public.relaydomains_recipientaccess OWNER TO modoboa;

--
-- Name: relaydomains_recipientaccess_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.relaydomains_recipientaccess_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.relaydomains_recipientaccess_id_seq OWNER TO modoboa;

--
-- Name: relaydomains_recipientaccess_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.relaydomains_recipientaccess_id_seq OWNED BY public.relaydomains_recipientaccess.id;


--
-- Name: reversion_revision; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.reversion_revision (
    id integer NOT NULL,
    date_created timestamp with time zone NOT NULL,
    comment text NOT NULL,
    user_id integer
);


ALTER TABLE public.reversion_revision OWNER TO modoboa;

--
-- Name: reversion_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.reversion_revision_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.reversion_revision_id_seq OWNER TO modoboa;

--
-- Name: reversion_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.reversion_revision_id_seq OWNED BY public.reversion_revision.id;


--
-- Name: reversion_version; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.reversion_version (
    id integer NOT NULL,
    object_id character varying(191) NOT NULL,
    format character varying(255) NOT NULL,
    serialized_data text NOT NULL,
    object_repr text NOT NULL,
    content_type_id integer NOT NULL,
    revision_id integer NOT NULL,
    db character varying(191) NOT NULL
);


ALTER TABLE public.reversion_version OWNER TO modoboa;

--
-- Name: reversion_version_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.reversion_version_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.reversion_version_id_seq OWNER TO modoboa;

--
-- Name: reversion_version_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.reversion_version_id_seq OWNED BY public.reversion_version.id;


--
-- Name: transport_transport; Type: TABLE; Schema: public; Owner: modoboa
--

CREATE TABLE public.transport_transport (
    id integer NOT NULL,
    pattern character varying(253) NOT NULL,
    service character varying(30) NOT NULL,
    next_hop character varying(100) NOT NULL,
    _settings text NOT NULL
);


ALTER TABLE public.transport_transport OWNER TO modoboa;

--
-- Name: transport_transport_id_seq; Type: SEQUENCE; Schema: public; Owner: modoboa
--

CREATE SEQUENCE public.transport_transport_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.transport_transport_id_seq OWNER TO modoboa;

--
-- Name: transport_transport_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: modoboa
--

ALTER SEQUENCE public.transport_transport_id_seq OWNED BY public.transport_transport.id;


--
-- Name: admin_alias id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_alias ALTER COLUMN id SET DEFAULT nextval('public.admin_alias_id_seq'::regclass);


--
-- Name: admin_dnsblresult id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_dnsblresult ALTER COLUMN id SET DEFAULT nextval('public.admin_dnsblresult_id_seq'::regclass);


--
-- Name: admin_domain id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domain ALTER COLUMN id SET DEFAULT nextval('public.admin_domain_id_seq'::regclass);


--
-- Name: admin_domainalias id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domainalias ALTER COLUMN id SET DEFAULT nextval('public.admin_domainalias_id_seq'::regclass);


--
-- Name: admin_mailbox id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailbox ALTER COLUMN id SET DEFAULT nextval('public.admin_mailbox_id_seq'::regclass);


--
-- Name: admin_mailboxoperation id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailboxoperation ALTER COLUMN id SET DEFAULT nextval('public.admin_mailboxoperation_id_seq'::regclass);


--
-- Name: admin_mxrecord id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mxrecord ALTER COLUMN id SET DEFAULT nextval('public.admin_mxrecord_id_seq'::regclass);


--
-- Name: admin_senderaddress id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_senderaddress ALTER COLUMN id SET DEFAULT nextval('public.admin_senderaddress_id_seq'::regclass);


--
-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group ALTER COLUMN id SET DEFAULT nextval('public.auth_group_id_seq'::regclass);


--
-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_group_permissions_id_seq'::regclass);


--
-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_permission ALTER COLUMN id SET DEFAULT nextval('public.auth_permission_id_seq'::regclass);


--
-- Name: core_extensionupdatehistory id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_extensionupdatehistory ALTER COLUMN id SET DEFAULT nextval('public.core_extensionupdatehistory_id_seq'::regclass);


--
-- Name: core_localconfig id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_localconfig ALTER COLUMN id SET DEFAULT nextval('public.core_localconfig_id_seq'::regclass);


--
-- Name: core_log id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_log ALTER COLUMN id SET DEFAULT nextval('public.core_log_id_seq'::regclass);


--
-- Name: core_objectaccess id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_objectaccess ALTER COLUMN id SET DEFAULT nextval('public.core_objectaccess_id_seq'::regclass);


--
-- Name: core_user id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user ALTER COLUMN id SET DEFAULT nextval('public.core_user_id_seq'::regclass);


--
-- Name: core_user_groups id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_groups ALTER COLUMN id SET DEFAULT nextval('public.core_user_groups_id_seq'::regclass);


--
-- Name: core_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('public.core_user_user_permissions_id_seq'::regclass);


--
-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_content_type ALTER COLUMN id SET DEFAULT nextval('public.django_content_type_id_seq'::regclass);


--
-- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_migrations ALTER COLUMN id SET DEFAULT nextval('public.django_migrations_id_seq'::regclass);


--
-- Name: django_site id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_site ALTER COLUMN id SET DEFAULT nextval('public.django_site_id_seq'::regclass);


--
-- Name: dnstools_dnsrecord id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.dnstools_dnsrecord ALTER COLUMN id SET DEFAULT nextval('public.dnstools_dnsrecord_id_seq'::regclass);


--
-- Name: limits_domainobjectlimit id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_domainobjectlimit ALTER COLUMN id SET DEFAULT nextval('public.limits_domainobjectlimit_id_seq'::regclass);


--
-- Name: limits_userobjectlimit id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_userobjectlimit ALTER COLUMN id SET DEFAULT nextval('public.limits_userobjectlimit_id_seq'::regclass);


--
-- Name: modoboa_admin_aliasrecipient id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient ALTER COLUMN id SET DEFAULT nextval('public.modoboa_admin_aliasrecipient_id_seq'::regclass);


--
-- Name: modoboa_contacts_addressbook id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_addressbook ALTER COLUMN id SET DEFAULT nextval('public.modoboa_contacts_addressbook_id_seq'::regclass);


--
-- Name: modoboa_contacts_category id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_category ALTER COLUMN id SET DEFAULT nextval('public.modoboa_contacts_category_id_seq'::regclass);


--
-- Name: modoboa_contacts_contact id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact ALTER COLUMN id SET DEFAULT nextval('public.modoboa_contacts_contact_id_seq'::regclass);


--
-- Name: modoboa_contacts_contact_categories id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact_categories ALTER COLUMN id SET DEFAULT nextval('public.modoboa_contacts_contact_categories_id_seq'::regclass);


--
-- Name: modoboa_contacts_emailaddress id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_emailaddress ALTER COLUMN id SET DEFAULT nextval('public.modoboa_contacts_emailaddress_id_seq'::regclass);


--
-- Name: modoboa_contacts_phonenumber id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_phonenumber ALTER COLUMN id SET DEFAULT nextval('public.modoboa_contacts_phonenumber_id_seq'::regclass);


--
-- Name: postfix_autoreply_arhistoric id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_arhistoric ALTER COLUMN id SET DEFAULT nextval('public.postfix_autoreply_arhistoric_id_seq'::regclass);


--
-- Name: postfix_autoreply_armessage id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_armessage ALTER COLUMN id SET DEFAULT nextval('public.postfix_autoreply_armessage_id_seq'::regclass);


--
-- Name: radicale_accessrule id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_accessrule ALTER COLUMN id SET DEFAULT nextval('public.radicale_accessrule_id_seq'::regclass);


--
-- Name: radicale_sharedcalendar id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_sharedcalendar ALTER COLUMN id SET DEFAULT nextval('public.radicale_sharedcalendar_id_seq'::regclass);


--
-- Name: radicale_usercalendar id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_usercalendar ALTER COLUMN id SET DEFAULT nextval('public.radicale_usercalendar_id_seq'::regclass);


--
-- Name: relaydomains_recipientaccess id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.relaydomains_recipientaccess ALTER COLUMN id SET DEFAULT nextval('public.relaydomains_recipientaccess_id_seq'::regclass);


--
-- Name: reversion_revision id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_revision ALTER COLUMN id SET DEFAULT nextval('public.reversion_revision_id_seq'::regclass);


--
-- Name: reversion_version id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_version ALTER COLUMN id SET DEFAULT nextval('public.reversion_version_id_seq'::regclass);


--
-- Name: transport_transport id; Type: DEFAULT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.transport_transport ALTER COLUMN id SET DEFAULT nextval('public.transport_transport_id_seq'::regclass);


--
-- Data for Name: admin_alias; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_alias (id, address, enabled, internal, domain_id, description, expire_at, creation, last_modification) FROM stdin;
\.


--
-- Name: admin_alias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_alias_id_seq', 1, false);


--
-- Data for Name: admin_dnsblresult; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_dnsblresult (id, provider, status, domain_id, mx_id) FROM stdin;
\.


--
-- Name: admin_dnsblresult_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_dnsblresult_id_seq', 1, false);


--
-- Data for Name: admin_domain; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_domain (id, name, default_mailbox_quota, enabled, type, creation, last_modification, enable_dns_checks, quota, transport_id, dkim_key_length, dkim_key_selector, dkim_private_key_path, dkim_public_key, enable_dkim) FROM stdin;
\.


--
-- Name: admin_domain_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_domain_id_seq', 1, false);


--
-- Data for Name: admin_domainalias; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_domainalias (id, name, enabled, target_id, creation, last_modification) FROM stdin;
\.


--
-- Name: admin_domainalias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_domainalias_id_seq', 1, false);


--
-- Data for Name: admin_mailbox; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_mailbox (id, address, quota, use_domain_quota, domain_id, user_id, creation, last_modification) FROM stdin;
\.


--
-- Name: admin_mailbox_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_mailbox_id_seq', 1, false);


--
-- Data for Name: admin_mailboxoperation; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_mailboxoperation (id, type, argument, mailbox_id) FROM stdin;
\.


--
-- Name: admin_mailboxoperation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_mailboxoperation_id_seq', 1, false);


--
-- Data for Name: admin_mxrecord; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_mxrecord (id, name, address, managed, updated, domain_id) FROM stdin;
\.


--
-- Name: admin_mxrecord_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_mxrecord_id_seq', 1, false);


--
-- Data for Name: admin_quota; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_quota (username, bytes, messages) FROM stdin;
\.


--
-- Data for Name: admin_senderaddress; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.admin_senderaddress (id, address, mailbox_id) FROM stdin;
\.


--
-- Name: admin_senderaddress_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.admin_senderaddress_id_seq', 1, false);


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.auth_group (id, name) FROM stdin;
1	DomainAdmins
2	Resellers
3	SimpleUsers
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 3, true);


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
1	1	41
2	1	42
3	1	43
4	1	60
5	1	81
6	1	82
7	1	83
8	1	84
9	1	77
10	1	78
11	1	79
12	1	80
13	1	65
14	1	66
15	1	67
16	1	181
17	1	182
18	1	183
19	1	177
20	1	178
21	1	179
22	2	41
23	2	42
24	2	43
25	2	81
26	2	82
27	2	83
28	2	84
29	2	77
30	2	78
31	2	79
32	2	80
33	2	65
34	2	66
35	2	67
36	2	57
37	2	58
38	2	59
39	2	60
40	2	89
41	2	90
42	2	91
43	2	181
44	2	182
45	2	183
46	2	177
47	2	178
48	2	179
49	3	181
50	3	182
51	3	183
\.


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 51, true);


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add permission	2	add_permission
2	Can change permission	2	change_permission
3	Can delete permission	2	delete_permission
4	Can view permission	2	view_permission
5	Can add group	1	add_group
6	Can change group	1	change_group
7	Can delete group	1	delete_group
8	Can view group	1	view_group
9	Can add content type	3	add_contenttype
10	Can change content type	3	change_contenttype
11	Can delete content type	3	delete_contenttype
12	Can view content type	3	view_contenttype
13	Can add session	4	add_session
14	Can change session	4	change_session
15	Can delete session	4	delete_session
16	Can view session	4	view_session
17	Can add site	5	add_site
18	Can change site	5	change_site
19	Can delete site	5	delete_site
20	Can view site	5	view_site
21	Can add version	6	add_version
22	Can change version	6	change_version
23	Can delete version	6	delete_version
24	Can view version	6	view_version
25	Can add revision	7	add_revision
26	Can change revision	7	change_revision
27	Can delete revision	7	delete_revision
28	Can view revision	7	view_revision
29	Can add Token	8	add_token
30	Can change Token	8	change_token
31	Can delete Token	8	delete_token
32	Can view Token	8	view_token
33	Can add object access	9	add_objectaccess
34	Can change object access	9	change_objectaccess
35	Can delete object access	9	delete_objectaccess
36	Can view object access	9	view_objectaccess
37	Can add log	12	add_log
38	Can change log	12	change_log
39	Can delete log	12	delete_log
40	Can view log	12	view_log
41	Can add user	11	add_user
42	Can change user	11	change_user
43	Can delete user	11	delete_user
44	Can view user	11	view_user
45	Can add extension update history	10	add_extensionupdatehistory
46	Can change extension update history	10	change_extensionupdatehistory
47	Can delete extension update history	10	delete_extensionupdatehistory
48	Can view extension update history	10	view_extensionupdatehistory
49	Can add local config	13	add_localconfig
50	Can change local config	13	change_localconfig
51	Can delete local config	13	delete_localconfig
52	Can view local config	13	view_localconfig
53	Can add alias recipient	18	add_aliasrecipient
54	Can change alias recipient	18	change_aliasrecipient
55	Can delete alias recipient	18	delete_aliasrecipient
56	Can view alias recipient	18	view_aliasrecipient
57	Can add domain	20	add_domain
58	Can change domain	20	change_domain
59	Can delete domain	20	delete_domain
60	Can view domain	20	view_domain
61	Can add mailbox operation	21	add_mailboxoperation
62	Can change mailbox operation	21	change_mailboxoperation
63	Can delete mailbox operation	21	delete_mailboxoperation
64	Can view mailbox operation	21	view_mailboxoperation
65	Can add sender address	15	add_senderaddress
66	Can change sender address	15	change_senderaddress
67	Can delete sender address	15	delete_senderaddress
68	Can view sender address	15	view_senderaddress
69	Can add dnsbl result	22	add_dnsblresult
70	Can change dnsbl result	22	change_dnsblresult
71	Can delete dnsbl result	22	delete_dnsblresult
72	Can view dnsbl result	22	view_dnsblresult
73	Can add mx record	23	add_mxrecord
74	Can change mx record	23	change_mxrecord
75	Can delete mx record	23	delete_mxrecord
76	Can view mx record	23	view_mxrecord
77	Can add alias	19	add_alias
78	Can change alias	19	change_alias
79	Can delete alias	19	delete_alias
80	Can view alias	19	view_alias
81	Can add mailbox	16	add_mailbox
82	Can change mailbox	16	change_mailbox
83	Can delete mailbox	16	delete_mailbox
84	Can view mailbox	16	view_mailbox
85	Can add quota	17	add_quota
86	Can change quota	17	change_quota
87	Can delete quota	17	delete_quota
88	Can view quota	17	view_quota
89	Can add domain alias	14	add_domainalias
90	Can change domain alias	14	change_domainalias
91	Can delete domain alias	14	delete_domainalias
92	Can view domain alias	14	view_domainalias
93	Can add transport	24	add_transport
94	Can change transport	24	change_transport
95	Can delete transport	24	delete_transport
96	Can view transport	24	view_transport
97	Can add recipient access	25	add_recipientaccess
98	Can change recipient access	25	change_recipientaccess
99	Can delete recipient access	25	delete_recipientaccess
100	Can view recipient access	25	view_recipientaccess
101	Can add user object limit	26	add_userobjectlimit
102	Can change user object limit	26	change_userobjectlimit
103	Can delete user object limit	26	delete_userobjectlimit
104	Can view user object limit	26	view_userobjectlimit
105	Can add domain object limit	27	add_domainobjectlimit
106	Can change domain object limit	27	change_domainobjectlimit
107	Can delete domain object limit	27	delete_domainobjectlimit
108	Can view domain object limit	27	view_domainobjectlimit
109	Can add dns record	28	add_dnsrecord
110	Can change dns record	28	change_dnsrecord
111	Can delete dns record	28	delete_dnsrecord
112	Can view dns record	28	view_dnsrecord
113	Can add users	34	add_users
114	Can change users	34	change_users
115	Can delete users	34	delete_users
116	Can view users	34	view_users
117	Can add wblist	33	add_wblist
118	Can change wblist	33	change_wblist
119	Can delete wblist	33	delete_wblist
120	Can view wblist	33	view_wblist
121	Can add policy	29	add_policy
122	Can change policy	29	change_policy
123	Can delete policy	29	delete_policy
124	Can view policy	29	view_policy
125	Can add msgrcpt	30	add_msgrcpt
126	Can change msgrcpt	30	change_msgrcpt
127	Can delete msgrcpt	30	delete_msgrcpt
128	Can view msgrcpt	30	view_msgrcpt
129	Can add maddr	32	add_maddr
130	Can change maddr	32	change_maddr
131	Can delete maddr	32	delete_maddr
132	Can view maddr	32	view_maddr
133	Can add msgs	35	add_msgs
134	Can change msgs	35	change_msgs
135	Can delete msgs	35	delete_msgs
136	Can view msgs	35	view_msgs
137	Can add mailaddr	36	add_mailaddr
138	Can change mailaddr	36	change_mailaddr
139	Can delete mailaddr	36	delete_mailaddr
140	Can view mailaddr	36	view_mailaddr
141	Can add quarantine	31	add_quarantine
142	Can change quarantine	31	change_quarantine
143	Can delete quarantine	31	delete_quarantine
144	Can view quarantine	31	view_quarantine
145	Can add a rhistoric	37	add_arhistoric
146	Can change a rhistoric	37	change_arhistoric
147	Can delete a rhistoric	37	delete_arhistoric
148	Can view a rhistoric	37	view_arhistoric
149	Can add a rmessage	38	add_armessage
150	Can change a rmessage	38	change_armessage
151	Can delete a rmessage	38	delete_armessage
152	Can view a rmessage	38	view_armessage
153	Can add contact	40	add_contact
154	Can change contact	40	change_contact
155	Can delete contact	40	delete_contact
156	Can view contact	40	view_contact
157	Can add address book	39	add_addressbook
158	Can change address book	39	change_addressbook
159	Can delete address book	39	delete_addressbook
160	Can view address book	39	view_addressbook
161	Can add email address	41	add_emailaddress
162	Can change email address	41	change_emailaddress
163	Can delete email address	41	delete_emailaddress
164	Can view email address	41	view_emailaddress
165	Can add category	42	add_category
166	Can change category	42	change_category
167	Can delete category	42	delete_category
168	Can view category	42	view_category
169	Can add phone number	43	add_phonenumber
170	Can change phone number	43	change_phonenumber
171	Can delete phone number	43	delete_phonenumber
172	Can view phone number	43	view_phonenumber
173	Can add access rule	44	add_accessrule
174	Can change access rule	44	change_accessrule
175	Can delete access rule	44	delete_accessrule
176	Can view access rule	44	view_accessrule
177	Can add shared calendar	46	add_sharedcalendar
178	Can change shared calendar	46	change_sharedcalendar
179	Can delete shared calendar	46	delete_sharedcalendar
180	Can view shared calendar	46	view_sharedcalendar
181	Can add user calendar	45	add_usercalendar
182	Can change user calendar	45	change_usercalendar
183	Can delete user calendar	45	delete_usercalendar
184	Can view user calendar	45	view_usercalendar
\.


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 184, true);


--
-- Data for Name: authtoken_token; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.authtoken_token (key, created, user_id) FROM stdin;
\.


--
-- Data for Name: core_extensionupdatehistory; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_extensionupdatehistory (id, extension, version) FROM stdin;
\.


--
-- Name: core_extensionupdatehistory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_extensionupdatehistory_id_seq', 1, false);


--
-- Data for Name: core_localconfig; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_localconfig (id, api_pk, api_versions, site_id, _parameters, need_dovecot_update) FROM stdin;
1	\N	""	1	{"admin": {"handle_mailboxes": true, "account_auto_removal": true, "dkim_keys_storage_dir": "/var/lib/dkim"}, "modoboa_amavis": {"am_pdp_mode": "inet"}, "modoboa_pdfcredentials": {"storage_dir": "/srv/modoboa/pdfcredentials"}, "modoboa_radicale": {"rights_file_path": "/etc/radicale/rights", "server_location": "https://mail.fictionalmaps.com/radicale/"}, "modoboa_stats": {"logfile": "/var/log/mail.log", "rrd_rootdir": "/srv/modoboa/rrdfiles"}}	f
\.


--
-- Name: core_localconfig_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_localconfig_id_seq', 1, true);


--
-- Data for Name: core_log; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_log (id, date_created, message, level, logger) FROM stdin;
\.


--
-- Name: core_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_log_id_seq', 1, false);


--
-- Data for Name: core_objectaccess; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_objectaccess (id, object_id, is_owner, content_type_id, user_id) FROM stdin;
1	1	t	11	1
\.


--
-- Name: core_objectaccess_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_objectaccess_id_seq', 1, true);


--
-- Data for Name: core_user; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_user (id, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined, is_local, password, last_login, master_user, language, phone_number, secondary_email, _parameters) FROM stdin;
1	t	admin				f	t	2020-05-19 11:37:00.225676+02	t	{SHA512-CRYPT}$6$rounds=70000$ktyn0dYdwo5ZR5Li$ucL4XwON.6epFxivxk63pPq2AhE2t77Z1aKcmCescBmSAFhoe0O/1aJ1/OfC5cvcf2ZZU/.oU0uT7znU37U8r0	\N	f	en	\N	\N	{}
\.


--
-- Data for Name: core_user_groups; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Name: core_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_user_groups_id_seq', 1, false);


--
-- Name: core_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_user_id_seq', 1, true);


--
-- Data for Name: core_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.core_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Name: core_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.core_user_user_permissions_id_seq', 1, false);


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	auth	group
2	auth	permission
3	contenttypes	contenttype
4	sessions	session
5	sites	site
6	reversion	version
7	reversion	revision
8	authtoken	token
9	core	objectaccess
10	core	extensionupdatehistory
11	core	user
12	core	log
13	core	localconfig
14	admin	domainalias
15	admin	senderaddress
16	admin	mailbox
17	admin	quota
18	admin	aliasrecipient
19	admin	alias
20	admin	domain
21	admin	mailboxoperation
22	admin	dnsblresult
23	admin	mxrecord
24	transport	transport
25	relaydomains	recipientaccess
26	limits	userobjectlimit
27	limits	domainobjectlimit
28	dnstools	dnsrecord
29	modoboa_amavis	policy
30	modoboa_amavis	msgrcpt
31	modoboa_amavis	quarantine
32	modoboa_amavis	maddr
33	modoboa_amavis	wblist
34	modoboa_amavis	users
35	modoboa_amavis	msgs
36	modoboa_amavis	mailaddr
37	modoboa_postfix_autoreply	arhistoric
38	modoboa_postfix_autoreply	armessage
39	modoboa_contacts	addressbook
40	modoboa_contacts	contact
41	modoboa_contacts	emailaddress
42	modoboa_contacts	category
43	modoboa_contacts	phonenumber
44	modoboa_radicale	accessrule
45	modoboa_radicale	usercalendar
46	modoboa_radicale	sharedcalendar
\.


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 46, true);


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	transport	0001_initial	2020-05-19 11:36:56.220892+02
2	contenttypes	0001_initial	2020-05-19 11:36:56.230335+02
3	contenttypes	0002_remove_content_type_name	2020-05-19 11:36:56.240019+02
4	auth	0001_initial	2020-05-19 11:36:56.2585+02
5	core	0001_initial	2020-05-19 11:36:56.30053+02
6	admin	0001_initial	2020-05-19 11:36:56.433484+02
7	admin	0002_migrate_from_modoboa_admin	2020-05-19 11:36:56.466461+02
8	relaydomains	0001_initial	2020-05-19 11:36:56.497264+02
9	relaydomains	0002_migrate_from_modoboa_admin_relaydomains	2020-05-19 11:36:56.501989+02
10	relaydomains	0003_auto_20170116_1508	2020-05-19 11:36:56.516994+02
11	relaydomains	0004_auto_20161105_1424	2020-05-19 11:36:56.549099+02
12	relaydomains	0005_auto_20161105_1426	2020-05-19 11:36:56.569911+02
13	admin	0003_auto_20151118_1215	2020-05-19 11:36:56.579125+02
14	admin	0004_auto_20160914_0907	2020-05-19 11:36:56.662898+02
15	admin	0005_auto_20161026_1003	2020-05-19 11:36:56.683917+02
16	admin	0006_auto_20161104_1900	2020-05-19 11:36:56.776972+02
17	admin	0007_auto_20161104_1915	2020-05-19 11:36:56.928084+02
18	admin	0008_domain_enable_dns_checks	2020-05-19 11:36:56.937164+02
19	admin	0009_auto_20170215_0948	2020-05-19 11:36:56.949882+02
20	admin	0010_auto_20170215_1328	2020-05-19 11:36:56.976421+02
21	admin	0011_domain_transport	2020-05-19 11:36:56.98984+02
22	admin	0012_auto_20180112_1658	2020-05-19 11:36:57.036304+02
23	admin	0013_auto_20180124_2311	2020-05-19 11:36:57.058927+02
24	admin	0014_auto_20181017_1628	2020-05-19 11:36:57.068051+02
25	admin	0015_rename_view_permissions	2020-05-19 11:36:57.088871+02
26	auth	0002_alter_permission_name_max_length	2020-05-19 11:36:57.096904+02
27	auth	0003_alter_user_email_max_length	2020-05-19 11:36:57.104944+02
28	auth	0004_alter_user_username_opts	2020-05-19 11:36:57.112998+02
29	auth	0005_alter_user_last_login_null	2020-05-19 11:36:57.120769+02
30	auth	0006_require_contenttypes_0002	2020-05-19 11:36:57.122025+02
31	auth	0007_alter_validators_add_error_messages	2020-05-19 11:36:57.130578+02
32	auth	0008_alter_user_username_max_length	2020-05-19 11:36:57.139824+02
33	auth	0009_alter_user_last_name_max_length	2020-05-19 11:36:57.147698+02
34	auth	0010_alter_group_name_max_length	2020-05-19 11:36:57.155748+02
35	auth	0011_update_proxy_permissions	2020-05-19 11:36:57.173255+02
36	authtoken	0001_initial	2020-05-19 11:36:57.181947+02
37	authtoken	0002_auto_20160226_1747	2020-05-19 11:36:57.214607+02
38	lib	0001_initial	2020-05-19 11:36:57.228258+02
39	lib	0002_rename_parameters	2020-05-19 11:36:57.260819+02
40	lib	0003_rename_parameters	2020-05-19 11:36:57.283444+02
41	core	0002_delete_extension	2020-05-19 11:36:57.286607+02
42	core	0003_user_master_user	2020-05-19 11:36:57.298221+02
43	core	0004_auto_20150728_1228	2020-05-19 11:36:57.347276+02
44	core	0005_user_language	2020-05-19 11:36:57.359052+02
45	lib	0004_auto_20151114_1409	2020-05-19 11:36:57.381192+02
46	lib	0005_auto_20160416_1449	2020-05-19 11:36:57.400635+02
47	sites	0001_initial	2020-05-19 11:36:57.40516+02
48	sites	0002_alter_domain_unique	2020-05-19 11:36:57.409815+02
49	core	0006_auto_20151114_1518	2020-05-19 11:36:57.427278+02
50	core	0007_auto_20151116_1349	2020-05-19 11:36:57.46101+02
51	core	0008_localconfig	2020-05-19 11:36:57.467423+02
52	core	0009_auto_20161026_1003	2020-05-19 11:36:57.492638+02
53	core	0010_auto_20161026_1011	2020-05-19 11:36:57.603561+02
54	core	0011_auto_20161104_2217	2020-05-19 11:36:57.616528+02
55	core	0012_auto_20170215_1034	2020-05-19 11:36:57.638903+02
56	core	0013_auto_20170707_1058	2020-05-19 11:36:57.662559+02
57	core	0014_auto_20171010_1746	2020-05-19 11:36:57.684171+02
58	core	0015_auto_20180112_1642	2020-05-19 11:36:57.692915+02
59	core	0016_auto_20180713_1014	2020-05-19 11:36:57.701306+02
60	core	0017_auto_20190705_1045	2020-05-19 11:36:57.713716+02
61	core	0018_auto_20200104_1714	2020-05-19 11:36:57.722732+02
62	core	0019_auto_20200121_1659	2020-05-19 11:36:57.730093+02
63	core	0020_auto_20200421_0851	2020-05-19 11:36:57.73914+02
64	core	0021_localconfig_need_dovecot_update	2020-05-19 11:36:57.745471+02
65	dnstools	0001_initial	2020-05-19 11:36:57.761719+02
66	lib	0006_auto_20161104_2206	2020-05-19 11:36:57.7799+02
67	limits	0001_initial	2020-05-19 11:36:57.818897+02
68	limits	0002_auto_20151114_1518	2020-05-19 11:36:57.819844+02
69	limits	0003_auto_20160413_1046	2020-05-19 11:36:57.82074+02
70	limits	0004_auto_20160413_1312	2020-05-19 11:36:57.821681+02
71	limits	0005_auto_20160415_1654	2020-05-19 11:36:57.848224+02
72	limits	0006_auto_20170216_1112	2020-05-19 11:36:57.87231+02
73	modoboa_amavis	0001_initial	2020-05-19 11:36:57.896581+02
74	modoboa_contacts	0001_initial	2020-05-19 11:36:57.959768+02
75	modoboa_contacts	0002_auto_20180124_2311	2020-05-19 11:36:57.985903+02
76	modoboa_contacts	0003_auto_20181005_1415	2020-05-19 11:36:58.040142+02
77	modoboa_contacts	0004_auto_20181005_1415	2020-05-19 11:36:58.076982+02
78	modoboa_contacts	0005_auto_20181005_1445	2020-05-19 11:36:58.110695+02
79	transport	0002_auto_20180928_1520	2020-05-19 11:36:58.118841+02
80	modoboa_postfix_autoreply	0001_initial	2020-05-19 11:36:58.172744+02
81	modoboa_postfix_autoreply	0002_auto_20150728_1236	2020-05-19 11:36:58.180082+02
82	modoboa_postfix_autoreply	0003_move_aliases	2020-05-19 11:36:58.216249+02
83	modoboa_postfix_autoreply	0004_delete_alias	2020-05-19 11:36:58.219887+02
84	modoboa_postfix_autoreply	0005_auto_20151202_1623	2020-05-19 11:36:58.327531+02
85	modoboa_postfix_autoreply	0006_auto_20160329_1501	2020-05-19 11:36:58.33489+02
86	modoboa_postfix_autoreply	0007_auto_20180928_1423	2020-05-19 11:36:58.369667+02
87	modoboa_postfix_autoreply	0008_delete_transport	2020-05-19 11:36:58.373494+02
88	modoboa_radicale	0001_initial	2020-05-19 11:36:58.464423+02
89	modoboa_radicale	0002_auto_20170831_1721	2020-05-19 11:36:58.487104+02
90	modoboa_radicale	0003_auto_20180324_1834	2020-05-19 11:36:58.546248+02
91	modoboa_radicale	0004_auto_20200220_1816	2020-05-19 11:36:58.603562+02
92	modoboa_radicale	0005_auto_20200220_1819	2020-05-19 11:36:58.619061+02
93	relaydomains	0006_auto_20170215_0948	2020-05-19 11:36:58.62804+02
94	relaydomains	0007_recipientaccess	2020-05-19 11:36:58.63343+02
95	relaydomains	0008_auto_20171123_1653	2020-05-19 11:36:58.67278+02
96	relaydomains	0009_auto_20171124_1508	2020-05-19 11:36:58.701004+02
97	reversion	0001_squashed_0004_auto_20160611_1202	2020-05-19 11:36:58.738668+02
98	sessions	0001_initial	2020-05-19 11:36:58.747744+02
99	limits	0001_squashed_0004_auto_20160413_1312	2020-05-19 11:36:58.750858+02
\.


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 99, true);


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
\.


--
-- Data for Name: django_site; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.django_site (id, domain, name) FROM stdin;
1	mail.fictionalmaps.com	mail.fictionalmaps.com
\.


--
-- Name: django_site_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.django_site_id_seq', 1, true);


--
-- Data for Name: dnstools_dnsrecord; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.dnstools_dnsrecord (id, type, value, is_valid, error, updated, domain_id) FROM stdin;
\.


--
-- Name: dnstools_dnsrecord_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.dnstools_dnsrecord_id_seq', 1, false);


--
-- Data for Name: limits_domainobjectlimit; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.limits_domainobjectlimit (id, name, max_value, domain_id) FROM stdin;
\.


--
-- Name: limits_domainobjectlimit_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.limits_domainobjectlimit_id_seq', 1, false);


--
-- Data for Name: limits_userobjectlimit; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.limits_userobjectlimit (id, name, max_value, content_type_id, user_id) FROM stdin;
1	domains	0	20	1
2	domain_aliases	0	14	1
3	mailboxes	0	16	1
4	mailbox_aliases	0	19	1
5	domain_admins	0	11	1
6	quota	0	20	1
\.


--
-- Name: limits_userobjectlimit_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.limits_userobjectlimit_id_seq', 6, true);


--
-- Data for Name: modoboa_admin_aliasrecipient; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_admin_aliasrecipient (id, address, alias_id, r_alias_id, r_mailbox_id) FROM stdin;
\.


--
-- Name: modoboa_admin_aliasrecipient_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_admin_aliasrecipient_id_seq', 1, false);


--
-- Data for Name: modoboa_contacts_addressbook; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_contacts_addressbook (id, name, sync_token, last_sync, user_id, _path) FROM stdin;
\.


--
-- Name: modoboa_contacts_addressbook_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_contacts_addressbook_id_seq', 1, false);


--
-- Data for Name: modoboa_contacts_category; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_contacts_category (id, name, user_id) FROM stdin;
\.


--
-- Name: modoboa_contacts_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_contacts_category_id_seq', 1, false);


--
-- Data for Name: modoboa_contacts_contact; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_contacts_contact (id, first_name, last_name, display_name, birth_date, company, "position", address, zipcode, city, country, state, note, uid, etag, addressbook_id) FROM stdin;
\.


--
-- Data for Name: modoboa_contacts_contact_categories; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_contacts_contact_categories (id, contact_id, category_id) FROM stdin;
\.


--
-- Name: modoboa_contacts_contact_categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_contacts_contact_categories_id_seq', 1, false);


--
-- Name: modoboa_contacts_contact_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_contacts_contact_id_seq', 1, false);


--
-- Data for Name: modoboa_contacts_emailaddress; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_contacts_emailaddress (id, address, type, contact_id) FROM stdin;
\.


--
-- Name: modoboa_contacts_emailaddress_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_contacts_emailaddress_id_seq', 1, false);


--
-- Data for Name: modoboa_contacts_phonenumber; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.modoboa_contacts_phonenumber (id, number, type, contact_id) FROM stdin;
\.


--
-- Name: modoboa_contacts_phonenumber_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.modoboa_contacts_phonenumber_id_seq', 1, false);


--
-- Data for Name: postfix_autoreply_arhistoric; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.postfix_autoreply_arhistoric (id, last_sent, sender, armessage_id) FROM stdin;
\.


--
-- Name: postfix_autoreply_arhistoric_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.postfix_autoreply_arhistoric_id_seq', 1, false);


--
-- Data for Name: postfix_autoreply_armessage; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.postfix_autoreply_armessage (id, subject, content, enabled, fromdate, untildate, mbox_id) FROM stdin;
\.


--
-- Name: postfix_autoreply_armessage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.postfix_autoreply_armessage_id_seq', 1, false);


--
-- Data for Name: radicale_accessrule; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.radicale_accessrule (id, read, write, last_update, calendar_id, mailbox_id) FROM stdin;
\.


--
-- Name: radicale_accessrule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.radicale_accessrule_id_seq', 1, false);


--
-- Data for Name: radicale_sharedcalendar; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.radicale_sharedcalendar (id, name, domain_id, color, _path, access_token) FROM stdin;
\.


--
-- Name: radicale_sharedcalendar_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.radicale_sharedcalendar_id_seq', 1, false);


--
-- Data for Name: radicale_usercalendar; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.radicale_usercalendar (id, name, mailbox_id, color, _path, access_token) FROM stdin;
\.


--
-- Name: radicale_usercalendar_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.radicale_usercalendar_id_seq', 1, false);


--
-- Data for Name: relaydomains_recipientaccess; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.relaydomains_recipientaccess (id, pattern, action) FROM stdin;
\.


--
-- Name: relaydomains_recipientaccess_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.relaydomains_recipientaccess_id_seq', 1, false);


--
-- Data for Name: reversion_revision; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.reversion_revision (id, date_created, comment, user_id) FROM stdin;
\.


--
-- Name: reversion_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.reversion_revision_id_seq', 1, false);


--
-- Data for Name: reversion_version; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.reversion_version (id, object_id, format, serialized_data, object_repr, content_type_id, revision_id, db) FROM stdin;
\.


--
-- Name: reversion_version_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.reversion_version_id_seq', 1, false);


--
-- Data for Name: transport_transport; Type: TABLE DATA; Schema: public; Owner: modoboa
--

COPY public.transport_transport (id, pattern, service, next_hop, _settings) FROM stdin;
\.


--
-- Name: transport_transport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: modoboa
--

SELECT pg_catalog.setval('public.transport_transport_id_seq', 1, false);


--
-- Name: admin_alias admin_alias_address_internal_701cee88_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_alias
    ADD CONSTRAINT admin_alias_address_internal_701cee88_uniq UNIQUE (address, internal);


--
-- Name: admin_alias admin_alias_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_alias
    ADD CONSTRAINT admin_alias_pkey PRIMARY KEY (id);


--
-- Name: admin_dnsblresult admin_dnsblresult_domain_id_provider_mx_id_9710ce0d_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_dnsblresult
    ADD CONSTRAINT admin_dnsblresult_domain_id_provider_mx_id_9710ce0d_uniq UNIQUE (domain_id, provider, mx_id);


--
-- Name: admin_dnsblresult admin_dnsblresult_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_dnsblresult
    ADD CONSTRAINT admin_dnsblresult_pkey PRIMARY KEY (id);


--
-- Name: admin_domain admin_domain_name_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domain
    ADD CONSTRAINT admin_domain_name_key UNIQUE (name);


--
-- Name: admin_domain admin_domain_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domain
    ADD CONSTRAINT admin_domain_pkey PRIMARY KEY (id);


--
-- Name: admin_domain admin_domain_transport_id_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domain
    ADD CONSTRAINT admin_domain_transport_id_key UNIQUE (transport_id);


--
-- Name: admin_domainalias admin_domainalias_name_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domainalias
    ADD CONSTRAINT admin_domainalias_name_key UNIQUE (name);


--
-- Name: admin_domainalias admin_domainalias_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domainalias
    ADD CONSTRAINT admin_domainalias_pkey PRIMARY KEY (id);


--
-- Name: admin_mailbox admin_mailbox_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailbox
    ADD CONSTRAINT admin_mailbox_pkey PRIMARY KEY (id);


--
-- Name: admin_mailbox admin_mailbox_user_id_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailbox
    ADD CONSTRAINT admin_mailbox_user_id_key UNIQUE (user_id);


--
-- Name: admin_mailboxoperation admin_mailboxoperation_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailboxoperation
    ADD CONSTRAINT admin_mailboxoperation_pkey PRIMARY KEY (id);


--
-- Name: admin_mxrecord admin_mxrecord_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mxrecord
    ADD CONSTRAINT admin_mxrecord_pkey PRIMARY KEY (id);


--
-- Name: admin_quota admin_quota_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_quota
    ADD CONSTRAINT admin_quota_pkey PRIMARY KEY (username);


--
-- Name: admin_senderaddress admin_senderaddress_address_mailbox_id_22a46694_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_senderaddress
    ADD CONSTRAINT admin_senderaddress_address_mailbox_id_22a46694_uniq UNIQUE (address, mailbox_id);


--
-- Name: admin_senderaddress admin_senderaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_senderaddress
    ADD CONSTRAINT admin_senderaddress_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: authtoken_token authtoken_token_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.authtoken_token
    ADD CONSTRAINT authtoken_token_pkey PRIMARY KEY (key);


--
-- Name: authtoken_token authtoken_token_user_id_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.authtoken_token
    ADD CONSTRAINT authtoken_token_user_id_key UNIQUE (user_id);


--
-- Name: core_extensionupdatehistory core_extensionupdatehistory_extension_version_eaaa12d1_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_extensionupdatehistory
    ADD CONSTRAINT core_extensionupdatehistory_extension_version_eaaa12d1_uniq UNIQUE (extension, version);


--
-- Name: core_extensionupdatehistory core_extensionupdatehistory_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_extensionupdatehistory
    ADD CONSTRAINT core_extensionupdatehistory_pkey PRIMARY KEY (id);


--
-- Name: core_localconfig core_localconfig_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_localconfig
    ADD CONSTRAINT core_localconfig_pkey PRIMARY KEY (id);


--
-- Name: core_log core_log_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_log
    ADD CONSTRAINT core_log_pkey PRIMARY KEY (id);


--
-- Name: core_objectaccess core_objectaccess_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_objectaccess
    ADD CONSTRAINT core_objectaccess_pkey PRIMARY KEY (id);


--
-- Name: core_objectaccess core_objectaccess_user_id_content_type_id__765857cb_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_objectaccess
    ADD CONSTRAINT core_objectaccess_user_id_content_type_id__765857cb_uniq UNIQUE (user_id, content_type_id, object_id);


--
-- Name: core_user_groups core_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_groups
    ADD CONSTRAINT core_user_groups_pkey PRIMARY KEY (id);


--
-- Name: core_user_groups core_user_groups_user_id_group_id_c82fcad1_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_groups
    ADD CONSTRAINT core_user_groups_user_id_group_id_c82fcad1_uniq UNIQUE (user_id, group_id);


--
-- Name: core_user core_user_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user
    ADD CONSTRAINT core_user_pkey PRIMARY KEY (id);


--
-- Name: core_user_user_permissions core_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_user_permissions
    ADD CONSTRAINT core_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: core_user_user_permissions core_user_user_permissions_user_id_permission_id_73ea0daa_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_user_permissions
    ADD CONSTRAINT core_user_user_permissions_user_id_permission_id_73ea0daa_uniq UNIQUE (user_id, permission_id);


--
-- Name: core_user core_user_username_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user
    ADD CONSTRAINT core_user_username_key UNIQUE (username);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: django_site django_site_domain_a2e37b91_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_site
    ADD CONSTRAINT django_site_domain_a2e37b91_uniq UNIQUE (domain);


--
-- Name: django_site django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.django_site
    ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);


--
-- Name: dnstools_dnsrecord dnstools_dnsrecord_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.dnstools_dnsrecord
    ADD CONSTRAINT dnstools_dnsrecord_pkey PRIMARY KEY (id);


--
-- Name: limits_domainobjectlimit limits_domainobjectlimit_domain_id_name_97ae94ed_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_domainobjectlimit
    ADD CONSTRAINT limits_domainobjectlimit_domain_id_name_97ae94ed_uniq UNIQUE (domain_id, name);


--
-- Name: limits_domainobjectlimit limits_domainobjectlimit_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_domainobjectlimit
    ADD CONSTRAINT limits_domainobjectlimit_pkey PRIMARY KEY (id);


--
-- Name: limits_userobjectlimit limits_userobjectlimit_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_userobjectlimit
    ADD CONSTRAINT limits_userobjectlimit_pkey PRIMARY KEY (id);


--
-- Name: limits_userobjectlimit limits_userobjectlimit_user_id_name_758b83b3_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_userobjectlimit
    ADD CONSTRAINT limits_userobjectlimit_user_id_name_758b83b3_uniq UNIQUE (user_id, name);


--
-- Name: modoboa_admin_aliasrecipient modoboa_admin_aliasrecip_alias_id_r_mailbox_id_c005be7e_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient
    ADD CONSTRAINT modoboa_admin_aliasrecip_alias_id_r_mailbox_id_c005be7e_uniq UNIQUE (alias_id, r_mailbox_id);


--
-- Name: modoboa_admin_aliasrecipient modoboa_admin_aliasrecipient_alias_id_r_alias_id_64af29a9_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient
    ADD CONSTRAINT modoboa_admin_aliasrecipient_alias_id_r_alias_id_64af29a9_uniq UNIQUE (alias_id, r_alias_id);


--
-- Name: modoboa_admin_aliasrecipient modoboa_admin_aliasrecipient_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient
    ADD CONSTRAINT modoboa_admin_aliasrecipient_pkey PRIMARY KEY (id);


--
-- Name: modoboa_contacts_addressbook modoboa_contacts_addressbook_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_addressbook
    ADD CONSTRAINT modoboa_contacts_addressbook_pkey PRIMARY KEY (id);


--
-- Name: modoboa_contacts_category modoboa_contacts_category_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_category
    ADD CONSTRAINT modoboa_contacts_category_pkey PRIMARY KEY (id);


--
-- Name: modoboa_contacts_contact_categories modoboa_contacts_contact_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact_categories
    ADD CONSTRAINT modoboa_contacts_contact_categories_pkey PRIMARY KEY (id);


--
-- Name: modoboa_contacts_contact_categories modoboa_contacts_contact_contact_id_category_id_1481bcf4_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact_categories
    ADD CONSTRAINT modoboa_contacts_contact_contact_id_category_id_1481bcf4_uniq UNIQUE (contact_id, category_id);


--
-- Name: modoboa_contacts_contact modoboa_contacts_contact_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact
    ADD CONSTRAINT modoboa_contacts_contact_pkey PRIMARY KEY (id);


--
-- Name: modoboa_contacts_contact modoboa_contacts_contact_uid_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact
    ADD CONSTRAINT modoboa_contacts_contact_uid_key UNIQUE (uid);


--
-- Name: modoboa_contacts_emailaddress modoboa_contacts_emailaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_emailaddress
    ADD CONSTRAINT modoboa_contacts_emailaddress_pkey PRIMARY KEY (id);


--
-- Name: modoboa_contacts_phonenumber modoboa_contacts_phonenumber_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_phonenumber
    ADD CONSTRAINT modoboa_contacts_phonenumber_pkey PRIMARY KEY (id);


--
-- Name: postfix_autoreply_arhistoric postfix_autoreply_arhistoric_armessage_id_sender_a83e7894_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_arhistoric
    ADD CONSTRAINT postfix_autoreply_arhistoric_armessage_id_sender_a83e7894_uniq UNIQUE (armessage_id, sender);


--
-- Name: postfix_autoreply_arhistoric postfix_autoreply_arhistoric_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_arhistoric
    ADD CONSTRAINT postfix_autoreply_arhistoric_pkey PRIMARY KEY (id);


--
-- Name: postfix_autoreply_armessage postfix_autoreply_armessage_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_armessage
    ADD CONSTRAINT postfix_autoreply_armessage_pkey PRIMARY KEY (id);


--
-- Name: radicale_accessrule radicale_accessrule_mailbox_id_calendar_id_d1e7eeef_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_accessrule
    ADD CONSTRAINT radicale_accessrule_mailbox_id_calendar_id_d1e7eeef_uniq UNIQUE (mailbox_id, calendar_id);


--
-- Name: radicale_accessrule radicale_accessrule_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_accessrule
    ADD CONSTRAINT radicale_accessrule_pkey PRIMARY KEY (id);


--
-- Name: radicale_sharedcalendar radicale_sharedcalendar_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_sharedcalendar
    ADD CONSTRAINT radicale_sharedcalendar_pkey PRIMARY KEY (id);


--
-- Name: radicale_usercalendar radicale_usercalendar_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_usercalendar
    ADD CONSTRAINT radicale_usercalendar_pkey PRIMARY KEY (id);


--
-- Name: relaydomains_recipientaccess relaydomains_recipientaccess_pattern_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.relaydomains_recipientaccess
    ADD CONSTRAINT relaydomains_recipientaccess_pattern_key UNIQUE (pattern);


--
-- Name: relaydomains_recipientaccess relaydomains_recipientaccess_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.relaydomains_recipientaccess
    ADD CONSTRAINT relaydomains_recipientaccess_pkey PRIMARY KEY (id);


--
-- Name: reversion_revision reversion_revision_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_revision
    ADD CONSTRAINT reversion_revision_pkey PRIMARY KEY (id);


--
-- Name: reversion_version reversion_version_db_content_type_id_objec_b2c54f65_uniq; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_version
    ADD CONSTRAINT reversion_version_db_content_type_id_objec_b2c54f65_uniq UNIQUE (db, content_type_id, object_id, revision_id);


--
-- Name: reversion_version reversion_version_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_version
    ADD CONSTRAINT reversion_version_pkey PRIMARY KEY (id);


--
-- Name: transport_transport transport_transport_pattern_key; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.transport_transport
    ADD CONSTRAINT transport_transport_pattern_key UNIQUE (pattern);


--
-- Name: transport_transport transport_transport_pkey; Type: CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.transport_transport
    ADD CONSTRAINT transport_transport_pkey PRIMARY KEY (id);


--
-- Name: admin_alias_domain_id_cf87ebf8; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_alias_domain_id_cf87ebf8 ON public.admin_alias USING btree (domain_id);


--
-- Name: admin_dnsblresult_domain_id_eaf09b4b; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_dnsblresult_domain_id_eaf09b4b ON public.admin_dnsblresult USING btree (domain_id);


--
-- Name: admin_dnsblresult_mx_id_6796d797; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_dnsblresult_mx_id_6796d797 ON public.admin_dnsblresult USING btree (mx_id);


--
-- Name: admin_dnsblresult_provider_3af1566c; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_dnsblresult_provider_3af1566c ON public.admin_dnsblresult USING btree (provider);


--
-- Name: admin_dnsblresult_provider_3af1566c_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_dnsblresult_provider_3af1566c_like ON public.admin_dnsblresult USING btree (provider varchar_pattern_ops);


--
-- Name: admin_dnsblresult_status_f5c95649; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_dnsblresult_status_f5c95649 ON public.admin_dnsblresult USING btree (status);


--
-- Name: admin_dnsblresult_status_f5c95649_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_dnsblresult_status_f5c95649_like ON public.admin_dnsblresult USING btree (status varchar_pattern_ops);


--
-- Name: admin_domain_name_224678fe_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_domain_name_224678fe_like ON public.admin_domain USING btree (name varchar_pattern_ops);


--
-- Name: admin_domainalias_name_c30b61bc_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_domainalias_name_c30b61bc_like ON public.admin_domainalias USING btree (name varchar_pattern_ops);


--
-- Name: admin_domainalias_target_id_99f9dbcd; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_domainalias_target_id_99f9dbcd ON public.admin_domainalias USING btree (target_id);


--
-- Name: admin_mailbox_domain_id_401a6f1e; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_mailbox_domain_id_401a6f1e ON public.admin_mailbox USING btree (domain_id);


--
-- Name: admin_mailboxoperation_mailbox_id_ddc8ec38; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_mailboxoperation_mailbox_id_ddc8ec38 ON public.admin_mailboxoperation USING btree (mailbox_id);


--
-- Name: admin_mxrecord_domain_id_b5400aa4; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_mxrecord_domain_id_b5400aa4 ON public.admin_mxrecord USING btree (domain_id);


--
-- Name: admin_quota_username_1f0323ea_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_quota_username_1f0323ea_like ON public.admin_quota USING btree (username varchar_pattern_ops);


--
-- Name: admin_senderaddress_mailbox_id_b8855f73; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX admin_senderaddress_mailbox_id_b8855f73 ON public.admin_senderaddress USING btree (mailbox_id);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: authtoken_token_key_10f0b77e_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX authtoken_token_key_10f0b77e_like ON public.authtoken_token USING btree (key varchar_pattern_ops);


--
-- Name: core_localconfig_site_id_cd052b22; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_localconfig_site_id_cd052b22 ON public.core_localconfig USING btree (site_id);


--
-- Name: core_objectaccess_content_type_id_0c2c42d5; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_objectaccess_content_type_id_0c2c42d5 ON public.core_objectaccess USING btree (content_type_id);


--
-- Name: core_objectaccess_user_id_91b2733d; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_objectaccess_user_id_91b2733d ON public.core_objectaccess USING btree (user_id);


--
-- Name: core_user_email_92a71487; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_email_92a71487 ON public.core_user USING btree (email);


--
-- Name: core_user_email_92a71487_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_email_92a71487_like ON public.core_user USING btree (email varchar_pattern_ops);


--
-- Name: core_user_email_is_active_b72a2c11_idx; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_email_is_active_b72a2c11_idx ON public.core_user USING btree (email, is_active);


--
-- Name: core_user_groups_group_id_fe8c697f; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_groups_group_id_fe8c697f ON public.core_user_groups USING btree (group_id);


--
-- Name: core_user_groups_user_id_70b4d9b8; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_groups_user_id_70b4d9b8 ON public.core_user_groups USING btree (user_id);


--
-- Name: core_user_is_active_dc1408da; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_is_active_dc1408da ON public.core_user USING btree (is_active);


--
-- Name: core_user_is_local_e2864715; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_is_local_e2864715 ON public.core_user USING btree (is_local);


--
-- Name: core_user_is_staff_c2ad76aa; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_is_staff_c2ad76aa ON public.core_user USING btree (is_staff);


--
-- Name: core_user_user_permissions_permission_id_35ccf601; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_user_permissions_permission_id_35ccf601 ON public.core_user_user_permissions USING btree (permission_id);


--
-- Name: core_user_user_permissions_user_id_085123d3; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_user_permissions_user_id_085123d3 ON public.core_user_user_permissions USING btree (user_id);


--
-- Name: core_user_username_36e4f7f7_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX core_user_username_36e4f7f7_like ON public.core_user USING btree (username varchar_pattern_ops);


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: django_site_domain_a2e37b91_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX django_site_domain_a2e37b91_like ON public.django_site USING btree (domain varchar_pattern_ops);


--
-- Name: dnstools_dnsrecord_domain_id_251b0a52; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX dnstools_dnsrecord_domain_id_251b0a52 ON public.dnstools_dnsrecord USING btree (domain_id);


--
-- Name: limits_domainobjectlimit_domain_id_1b89a238; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX limits_domainobjectlimit_domain_id_1b89a238 ON public.limits_domainobjectlimit USING btree (domain_id);


--
-- Name: limits_userobjectlimit_content_type_id_7e1a6180; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX limits_userobjectlimit_content_type_id_7e1a6180 ON public.limits_userobjectlimit USING btree (content_type_id);


--
-- Name: limits_userobjectlimit_user_id_f7747c74; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX limits_userobjectlimit_user_id_f7747c74 ON public.limits_userobjectlimit USING btree (user_id);


--
-- Name: modoboa_admin_aliasrecipient_alias_id_528b77e9; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_admin_aliasrecipient_alias_id_528b77e9 ON public.modoboa_admin_aliasrecipient USING btree (alias_id);


--
-- Name: modoboa_admin_aliasrecipient_r_alias_id_14a95128; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_admin_aliasrecipient_r_alias_id_14a95128 ON public.modoboa_admin_aliasrecipient USING btree (r_alias_id);


--
-- Name: modoboa_admin_aliasrecipient_r_mailbox_id_c5674874; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_admin_aliasrecipient_r_mailbox_id_c5674874 ON public.modoboa_admin_aliasrecipient USING btree (r_mailbox_id);


--
-- Name: modoboa_contacts_addressbook_user_id_e49a5a75; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_addressbook_user_id_e49a5a75 ON public.modoboa_contacts_addressbook USING btree (user_id);


--
-- Name: modoboa_contacts_category_user_id_4061c4f0; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_category_user_id_4061c4f0 ON public.modoboa_contacts_category USING btree (user_id);


--
-- Name: modoboa_contacts_contact_addressbook_id_31a7336e; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_contact_addressbook_id_31a7336e ON public.modoboa_contacts_contact USING btree (addressbook_id);


--
-- Name: modoboa_contacts_contact_categories_category_id_8462ba89; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_contact_categories_category_id_8462ba89 ON public.modoboa_contacts_contact_categories USING btree (category_id);


--
-- Name: modoboa_contacts_contact_categories_contact_id_ab5a1fb3; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_contact_categories_contact_id_ab5a1fb3 ON public.modoboa_contacts_contact_categories USING btree (contact_id);


--
-- Name: modoboa_contacts_contact_uid_7c454769_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_contact_uid_7c454769_like ON public.modoboa_contacts_contact USING btree (uid varchar_pattern_ops);


--
-- Name: modoboa_contacts_emailaddress_contact_id_3a831210; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_emailaddress_contact_id_3a831210 ON public.modoboa_contacts_emailaddress USING btree (contact_id);


--
-- Name: modoboa_contacts_phonenumber_contact_id_81b290e1; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX modoboa_contacts_phonenumber_contact_id_81b290e1 ON public.modoboa_contacts_phonenumber USING btree (contact_id);


--
-- Name: postfix_autoreply_arhistoric_armessage_id_40c6f1d5; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX postfix_autoreply_arhistoric_armessage_id_40c6f1d5 ON public.postfix_autoreply_arhistoric USING btree (armessage_id);


--
-- Name: postfix_autoreply_armessage_mbox_id_7e86ec4d; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX postfix_autoreply_armessage_mbox_id_7e86ec4d ON public.postfix_autoreply_armessage USING btree (mbox_id);


--
-- Name: radicale_accessrule_calendar_id_500429d5; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX radicale_accessrule_calendar_id_500429d5 ON public.radicale_accessrule USING btree (calendar_id);


--
-- Name: radicale_accessrule_mailbox_id_a790cfdf; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX radicale_accessrule_mailbox_id_a790cfdf ON public.radicale_accessrule USING btree (mailbox_id);


--
-- Name: radicale_sharedcalendar_domain_id_f9efd3d8; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX radicale_sharedcalendar_domain_id_f9efd3d8 ON public.radicale_sharedcalendar USING btree (domain_id);


--
-- Name: radicale_usercalendar_mailbox_id_dd6fcd37; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX radicale_usercalendar_mailbox_id_dd6fcd37 ON public.radicale_usercalendar USING btree (mailbox_id);


--
-- Name: relaydomains_recipientaccess_pattern_693333d5_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX relaydomains_recipientaccess_pattern_693333d5_like ON public.relaydomains_recipientaccess USING btree (pattern varchar_pattern_ops);


--
-- Name: reversion_revision_date_created_96f7c20c; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX reversion_revision_date_created_96f7c20c ON public.reversion_revision USING btree (date_created);


--
-- Name: reversion_revision_user_id_17095f45; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX reversion_revision_user_id_17095f45 ON public.reversion_revision USING btree (user_id);


--
-- Name: reversion_version_content_type_id_7d0ff25c; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX reversion_version_content_type_id_7d0ff25c ON public.reversion_version USING btree (content_type_id);


--
-- Name: reversion_version_revision_id_af9f6a9d; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX reversion_version_revision_id_af9f6a9d ON public.reversion_version USING btree (revision_id);


--
-- Name: transport_transport_pattern_462f5b20_like; Type: INDEX; Schema: public; Owner: modoboa
--

CREATE INDEX transport_transport_pattern_462f5b20_like ON public.transport_transport USING btree (pattern varchar_pattern_ops);


--
-- Name: admin_alias admin_alias_domain_id_cf87ebf8_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_alias
    ADD CONSTRAINT admin_alias_domain_id_cf87ebf8_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_dnsblresult admin_dnsblresult_domain_id_eaf09b4b_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_dnsblresult
    ADD CONSTRAINT admin_dnsblresult_domain_id_eaf09b4b_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_dnsblresult admin_dnsblresult_mx_id_6796d797_fk_admin_mxrecord_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_dnsblresult
    ADD CONSTRAINT admin_dnsblresult_mx_id_6796d797_fk_admin_mxrecord_id FOREIGN KEY (mx_id) REFERENCES public.admin_mxrecord(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_domain admin_domain_transport_id_7e20103c_fk_transport_transport_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domain
    ADD CONSTRAINT admin_domain_transport_id_7e20103c_fk_transport_transport_id FOREIGN KEY (transport_id) REFERENCES public.transport_transport(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_domainalias admin_domainalias_target_id_99f9dbcd_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_domainalias
    ADD CONSTRAINT admin_domainalias_target_id_99f9dbcd_fk_admin_domain_id FOREIGN KEY (target_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_mailbox admin_mailbox_domain_id_401a6f1e_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailbox
    ADD CONSTRAINT admin_mailbox_domain_id_401a6f1e_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_mailbox admin_mailbox_user_id_c063b06b_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailbox
    ADD CONSTRAINT admin_mailbox_user_id_c063b06b_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_mailboxoperation admin_mailboxoperation_mailbox_id_ddc8ec38_fk_admin_mailbox_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mailboxoperation
    ADD CONSTRAINT admin_mailboxoperation_mailbox_id_ddc8ec38_fk_admin_mailbox_id FOREIGN KEY (mailbox_id) REFERENCES public.admin_mailbox(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_mxrecord admin_mxrecord_domain_id_b5400aa4_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_mxrecord
    ADD CONSTRAINT admin_mxrecord_domain_id_b5400aa4_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admin_senderaddress admin_senderaddress_mailbox_id_b8855f73_fk_admin_mailbox_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.admin_senderaddress
    ADD CONSTRAINT admin_senderaddress_mailbox_id_b8855f73_fk_admin_mailbox_id FOREIGN KEY (mailbox_id) REFERENCES public.admin_mailbox(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: authtoken_token authtoken_token_user_id_35299eff_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.authtoken_token
    ADD CONSTRAINT authtoken_token_user_id_35299eff_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_localconfig core_localconfig_site_id_cd052b22_fk_django_site_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_localconfig
    ADD CONSTRAINT core_localconfig_site_id_cd052b22_fk_django_site_id FOREIGN KEY (site_id) REFERENCES public.django_site(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_objectaccess core_objectaccess_content_type_id_0c2c42d5_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_objectaccess
    ADD CONSTRAINT core_objectaccess_content_type_id_0c2c42d5_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_objectaccess core_objectaccess_user_id_91b2733d_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_objectaccess
    ADD CONSTRAINT core_objectaccess_user_id_91b2733d_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_user_groups core_user_groups_group_id_fe8c697f_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_groups
    ADD CONSTRAINT core_user_groups_group_id_fe8c697f_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_user_groups core_user_groups_user_id_70b4d9b8_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_groups
    ADD CONSTRAINT core_user_groups_user_id_70b4d9b8_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_user_user_permissions core_user_user_permi_permission_id_35ccf601_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_user_permissions
    ADD CONSTRAINT core_user_user_permi_permission_id_35ccf601_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: core_user_user_permissions core_user_user_permissions_user_id_085123d3_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.core_user_user_permissions
    ADD CONSTRAINT core_user_user_permissions_user_id_085123d3_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dnstools_dnsrecord dnstools_dnsrecord_domain_id_251b0a52_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.dnstools_dnsrecord
    ADD CONSTRAINT dnstools_dnsrecord_domain_id_251b0a52_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: limits_domainobjectlimit limits_domainobjectlimit_domain_id_1b89a238_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_domainobjectlimit
    ADD CONSTRAINT limits_domainobjectlimit_domain_id_1b89a238_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: limits_userobjectlimit limits_userobjectlim_content_type_id_7e1a6180_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_userobjectlimit
    ADD CONSTRAINT limits_userobjectlim_content_type_id_7e1a6180_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: limits_userobjectlimit limits_userobjectlimit_user_id_f7747c74_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.limits_userobjectlimit
    ADD CONSTRAINT limits_userobjectlimit_user_id_f7747c74_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_admin_aliasrecipient modoboa_admin_aliasr_alias_id_528b77e9_fk_admin_ali; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient
    ADD CONSTRAINT modoboa_admin_aliasr_alias_id_528b77e9_fk_admin_ali FOREIGN KEY (alias_id) REFERENCES public.admin_alias(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_admin_aliasrecipient modoboa_admin_aliasr_r_alias_id_14a95128_fk_admin_ali; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient
    ADD CONSTRAINT modoboa_admin_aliasr_r_alias_id_14a95128_fk_admin_ali FOREIGN KEY (r_alias_id) REFERENCES public.admin_alias(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_admin_aliasrecipient modoboa_admin_aliasr_r_mailbox_id_c5674874_fk_admin_mai; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_admin_aliasrecipient
    ADD CONSTRAINT modoboa_admin_aliasr_r_mailbox_id_c5674874_fk_admin_mai FOREIGN KEY (r_mailbox_id) REFERENCES public.admin_mailbox(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_addressbook modoboa_contacts_addressbook_user_id_e49a5a75_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_addressbook
    ADD CONSTRAINT modoboa_contacts_addressbook_user_id_e49a5a75_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_category modoboa_contacts_category_user_id_4061c4f0_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_category
    ADD CONSTRAINT modoboa_contacts_category_user_id_4061c4f0_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_contact modoboa_contacts_con_addressbook_id_31a7336e_fk_modoboa_c; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact
    ADD CONSTRAINT modoboa_contacts_con_addressbook_id_31a7336e_fk_modoboa_c FOREIGN KEY (addressbook_id) REFERENCES public.modoboa_contacts_addressbook(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_contact_categories modoboa_contacts_con_category_id_8462ba89_fk_modoboa_c; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact_categories
    ADD CONSTRAINT modoboa_contacts_con_category_id_8462ba89_fk_modoboa_c FOREIGN KEY (category_id) REFERENCES public.modoboa_contacts_category(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_contact_categories modoboa_contacts_con_contact_id_ab5a1fb3_fk_modoboa_c; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_contact_categories
    ADD CONSTRAINT modoboa_contacts_con_contact_id_ab5a1fb3_fk_modoboa_c FOREIGN KEY (contact_id) REFERENCES public.modoboa_contacts_contact(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_emailaddress modoboa_contacts_ema_contact_id_3a831210_fk_modoboa_c; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_emailaddress
    ADD CONSTRAINT modoboa_contacts_ema_contact_id_3a831210_fk_modoboa_c FOREIGN KEY (contact_id) REFERENCES public.modoboa_contacts_contact(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: modoboa_contacts_phonenumber modoboa_contacts_pho_contact_id_81b290e1_fk_modoboa_c; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.modoboa_contacts_phonenumber
    ADD CONSTRAINT modoboa_contacts_pho_contact_id_81b290e1_fk_modoboa_c FOREIGN KEY (contact_id) REFERENCES public.modoboa_contacts_contact(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: postfix_autoreply_arhistoric postfix_autoreply_ar_armessage_id_40c6f1d5_fk_postfix_a; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_arhistoric
    ADD CONSTRAINT postfix_autoreply_ar_armessage_id_40c6f1d5_fk_postfix_a FOREIGN KEY (armessage_id) REFERENCES public.postfix_autoreply_armessage(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: postfix_autoreply_armessage postfix_autoreply_ar_mbox_id_7e86ec4d_fk_admin_mai; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.postfix_autoreply_armessage
    ADD CONSTRAINT postfix_autoreply_ar_mbox_id_7e86ec4d_fk_admin_mai FOREIGN KEY (mbox_id) REFERENCES public.admin_mailbox(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: radicale_accessrule radicale_accessrule_calendar_id_500429d5_fk_radicale_; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_accessrule
    ADD CONSTRAINT radicale_accessrule_calendar_id_500429d5_fk_radicale_ FOREIGN KEY (calendar_id) REFERENCES public.radicale_usercalendar(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: radicale_accessrule radicale_accessrule_mailbox_id_a790cfdf_fk_admin_mailbox_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_accessrule
    ADD CONSTRAINT radicale_accessrule_mailbox_id_a790cfdf_fk_admin_mailbox_id FOREIGN KEY (mailbox_id) REFERENCES public.admin_mailbox(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: radicale_sharedcalendar radicale_sharedcalendar_domain_id_f9efd3d8_fk_admin_domain_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_sharedcalendar
    ADD CONSTRAINT radicale_sharedcalendar_domain_id_f9efd3d8_fk_admin_domain_id FOREIGN KEY (domain_id) REFERENCES public.admin_domain(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: radicale_usercalendar radicale_usercalendar_mailbox_id_dd6fcd37_fk_admin_mailbox_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.radicale_usercalendar
    ADD CONSTRAINT radicale_usercalendar_mailbox_id_dd6fcd37_fk_admin_mailbox_id FOREIGN KEY (mailbox_id) REFERENCES public.admin_mailbox(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: reversion_revision reversion_revision_user_id_17095f45_fk_core_user_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_revision
    ADD CONSTRAINT reversion_revision_user_id_17095f45_fk_core_user_id FOREIGN KEY (user_id) REFERENCES public.core_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: reversion_version reversion_version_content_type_id_7d0ff25c_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_version
    ADD CONSTRAINT reversion_version_content_type_id_7d0ff25c_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: reversion_version reversion_version_revision_id_af9f6a9d_fk_reversion_revision_id; Type: FK CONSTRAINT; Schema: public; Owner: modoboa
--

ALTER TABLE ONLY public.reversion_version
    ADD CONSTRAINT reversion_version_revision_id_af9f6a9d_fk_reversion_revision_id FOREIGN KEY (revision_id) REFERENCES public.reversion_revision(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--

\connect postgres

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.24
-- Dumped by pg_dump version 9.6.24

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON DATABASE postgres IS 'default administrative connection database';


--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- PostgreSQL database dump complete
--

\connect spamassassin

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.24
-- Dumped by pg_dump version 9.6.24

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- Name: greatest_int(integer, integer); Type: FUNCTION; Schema: public; Owner: spamassassin
--

CREATE FUNCTION public.greatest_int(integer, integer) RETURNS integer
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT CASE WHEN $1 < $2 THEN $2 ELSE $1 END;$_$;


ALTER FUNCTION public.greatest_int(integer, integer) OWNER TO spamassassin;

--
-- Name: least_int(integer, integer); Type: FUNCTION; Schema: public; Owner: spamassassin
--

CREATE FUNCTION public.least_int(integer, integer) RETURNS integer
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT CASE WHEN $1 < $2 THEN $1 ELSE $2 END;$_$;


ALTER FUNCTION public.least_int(integer, integer) OWNER TO spamassassin;

--
-- Name: put_tokens(integer, bytea[], integer, integer, integer); Type: FUNCTION; Schema: public; Owner: spamassassin
--

CREATE FUNCTION public.put_tokens(integer, bytea[], integer, integer, integer) RETURNS void
    LANGUAGE plpgsql
    AS $_$ 
DECLARE
  inuserid      ALIAS FOR $1;
  intokenary    ALIAS FOR $2;
  inspam_count  ALIAS FOR $3;
  inham_count   ALIAS FOR $4;
  inatime       ALIAS FOR $5;
  _token BYTEA;
  new_tokens INTEGER := 0;
BEGIN
  for i in array_lower(intokenary, 1) .. array_upper(intokenary, 1)
  LOOP
    _token := intokenary[i];
    UPDATE bayes_token
       SET spam_count = greatest_int(spam_count + inspam_count, 0),
           ham_count = greatest_int(ham_count + inham_count, 0),
           atime = greatest_int(atime, inatime)
     WHERE id = inuserid 
       AND token = _token;
    IF NOT FOUND THEN 
      -- we do not insert negative counts, just return true
      IF NOT (inspam_count < 0 OR inham_count < 0) THEN
        INSERT INTO bayes_token (id, token, spam_count, ham_count, atime) 
        VALUES (inuserid, _token, inspam_count, inham_count, inatime); 
        IF FOUND THEN
          new_tokens := new_tokens + 1;
        END IF;
      END IF;
    END IF;
  END LOOP;

  IF new_tokens > 0 AND inatime > 0 THEN
    UPDATE bayes_vars
       SET token_count = token_count + new_tokens,
           newest_token_age = greatest_int(newest_token_age, inatime),
           oldest_token_age = least_int(oldest_token_age, inatime)
     WHERE id = inuserid;
  ELSIF new_tokens > 0 AND NOT inatime > 0 THEN
    UPDATE bayes_vars
       SET token_count = token_count + new_tokens
     WHERE id = inuserid;
  ELSIF NOT new_tokens > 0 AND inatime > 0 THEN
    UPDATE bayes_vars
       SET newest_token_age = greatest_int(newest_token_age, inatime),
           oldest_token_age = least_int(oldest_token_age, inatime)
     WHERE id = inuserid;
  END IF;
  RETURN;
END; 
$_$;


ALTER FUNCTION public.put_tokens(integer, bytea[], integer, integer, integer) OWNER TO spamassassin;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: bayes_expire; Type: TABLE; Schema: public; Owner: spamassassin
--

CREATE TABLE public.bayes_expire (
    id integer DEFAULT 0 NOT NULL,
    runtime integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.bayes_expire OWNER TO spamassassin;

--
-- Name: bayes_global_vars; Type: TABLE; Schema: public; Owner: spamassassin
--

CREATE TABLE public.bayes_global_vars (
    variable character varying(30) DEFAULT ''::character varying NOT NULL,
    value character varying(200) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.bayes_global_vars OWNER TO spamassassin;

--
-- Name: bayes_seen; Type: TABLE; Schema: public; Owner: spamassassin
--

CREATE TABLE public.bayes_seen (
    id integer DEFAULT 0 NOT NULL,
    msgid character varying(200) DEFAULT ''::character varying NOT NULL,
    flag character(1) DEFAULT ''::bpchar NOT NULL
);


ALTER TABLE public.bayes_seen OWNER TO spamassassin;

--
-- Name: bayes_token; Type: TABLE; Schema: public; Owner: spamassassin
--

CREATE TABLE public.bayes_token (
    id integer DEFAULT 0 NOT NULL,
    token bytea DEFAULT '\x'::bytea NOT NULL,
    spam_count integer DEFAULT 0 NOT NULL,
    ham_count integer DEFAULT 0 NOT NULL,
    atime integer DEFAULT 0 NOT NULL
)
WITH (fillfactor='95');


ALTER TABLE public.bayes_token OWNER TO spamassassin;

--
-- Name: bayes_vars; Type: TABLE; Schema: public; Owner: spamassassin
--

CREATE TABLE public.bayes_vars (
    id integer NOT NULL,
    username character varying(200) DEFAULT ''::character varying NOT NULL,
    spam_count integer DEFAULT 0 NOT NULL,
    ham_count integer DEFAULT 0 NOT NULL,
    token_count integer DEFAULT 0 NOT NULL,
    last_expire integer DEFAULT 0 NOT NULL,
    last_atime_delta integer DEFAULT 0 NOT NULL,
    last_expire_reduce integer DEFAULT 0 NOT NULL,
    oldest_token_age integer DEFAULT 2147483647 NOT NULL,
    newest_token_age integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.bayes_vars OWNER TO spamassassin;

--
-- Name: bayes_vars_id_seq; Type: SEQUENCE; Schema: public; Owner: spamassassin
--

CREATE SEQUENCE public.bayes_vars_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.bayes_vars_id_seq OWNER TO spamassassin;

--
-- Name: bayes_vars_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: spamassassin
--

ALTER SEQUENCE public.bayes_vars_id_seq OWNED BY public.bayes_vars.id;


--
-- Name: bayes_vars id; Type: DEFAULT; Schema: public; Owner: spamassassin
--

ALTER TABLE ONLY public.bayes_vars ALTER COLUMN id SET DEFAULT nextval('public.bayes_vars_id_seq'::regclass);


--
-- Data for Name: bayes_expire; Type: TABLE DATA; Schema: public; Owner: spamassassin
--

COPY public.bayes_expire (id, runtime) FROM stdin;
\.


--
-- Data for Name: bayes_global_vars; Type: TABLE DATA; Schema: public; Owner: spamassassin
--

COPY public.bayes_global_vars (variable, value) FROM stdin;
VERSION	3
\.


--
-- Data for Name: bayes_seen; Type: TABLE DATA; Schema: public; Owner: spamassassin
--

COPY public.bayes_seen (id, msgid, flag) FROM stdin;
\.


--
-- Data for Name: bayes_token; Type: TABLE DATA; Schema: public; Owner: spamassassin
--

COPY public.bayes_token (id, token, spam_count, ham_count, atime) FROM stdin;
\.


--
-- Data for Name: bayes_vars; Type: TABLE DATA; Schema: public; Owner: spamassassin
--

COPY public.bayes_vars (id, username, spam_count, ham_count, token_count, last_expire, last_atime_delta, last_expire_reduce, oldest_token_age, newest_token_age) FROM stdin;
1	amavis	0	0	0	1589930645	0	0	2147483647	0
\.


--
-- Name: bayes_vars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: spamassassin
--

SELECT pg_catalog.setval('public.bayes_vars_id_seq', 1, true);


--
-- Name: bayes_global_vars bayes_global_vars_pkey; Type: CONSTRAINT; Schema: public; Owner: spamassassin
--

ALTER TABLE ONLY public.bayes_global_vars
    ADD CONSTRAINT bayes_global_vars_pkey PRIMARY KEY (variable);


--
-- Name: bayes_seen bayes_seen_pkey; Type: CONSTRAINT; Schema: public; Owner: spamassassin
--

ALTER TABLE ONLY public.bayes_seen
    ADD CONSTRAINT bayes_seen_pkey PRIMARY KEY (id, msgid);


--
-- Name: bayes_token bayes_token_pkey; Type: CONSTRAINT; Schema: public; Owner: spamassassin
--

ALTER TABLE ONLY public.bayes_token
    ADD CONSTRAINT bayes_token_pkey PRIMARY KEY (id, token);


--
-- Name: bayes_vars bayes_vars_pkey; Type: CONSTRAINT; Schema: public; Owner: spamassassin
--

ALTER TABLE ONLY public.bayes_vars
    ADD CONSTRAINT bayes_vars_pkey PRIMARY KEY (id);


--
-- Name: bayes_expire_idx1; Type: INDEX; Schema: public; Owner: spamassassin
--

CREATE INDEX bayes_expire_idx1 ON public.bayes_expire USING btree (id);


--
-- Name: bayes_token_idx1; Type: INDEX; Schema: public; Owner: spamassassin
--

CREATE INDEX bayes_token_idx1 ON public.bayes_token USING btree (token);


--
-- Name: bayes_vars_idx1; Type: INDEX; Schema: public; Owner: spamassassin
--

CREATE UNIQUE INDEX bayes_vars_idx1 ON public.bayes_vars USING btree (username);


--
-- PostgreSQL database dump complete
--

\connect template1

SET default_transaction_read_only = off;

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.24
-- Dumped by pg_dump version 9.6.24

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: DATABASE template1; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON DATABASE template1 IS 'default template for new databases';


--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- PostgreSQL database dump complete
--

--
-- PostgreSQL database cluster dump complete
--


Anon7 - 2022
AnonSec Team