Server IP : 85.214.239.14 / Your IP : 3.148.115.43 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/3/task/3/cwd/proc/3/cwd/var/lib/postgresql/ |
Upload File : |
-- -- 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 --