mailfilter/schema.sql at master · mindbit/mailfilter · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
--
-- PostgreSQL database dump
--

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: smtp_transaction_recipients; Type: TABLE; Schema: public; Owner: mipanel; Tablespace:
--

CREATE TABLE smtp_transaction_recipients (
    smtp_transaction_recipient_id integer NOT NULL,
    smtp_transaction_id integer NOT NULL,
    recipient text
);


ALTER TABLE public.smtp_transaction_recipients OWNER TO mipanel;

--
-- Name: smtp_transaction_recipients_smtp_transaction_recipient_id_seq; Type: SEQUENCE; Schema: public; Owner: mipanel
--

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


ALTER TABLE public.smtp_transaction_recipients_smtp_transaction_recipient_id_seq OWNER TO mipanel;

--
-- Name: smtp_transaction_recipients_smtp_transaction_recipient_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mipanel
--

ALTER SEQUENCE smtp_transaction_recipients_smtp_transaction_recipient_id_seq OWNED BY smtp_transaction_recipients.smtp_transaction_recipient_id;


--
-- Name: smtp_transactions; Type: TABLE; Schema: public; Owner: mipanel; Tablespace:
--

CREATE TABLE smtp_transactions (
    smtp_transaction_id integer NOT NULL,
    remote_addr inet,
    remote_port integer,
    envelope_sender text,
    "time" timestamp without time zone,
    subject text,
    smtp_status_code integer,
    smtp_status_message text,
    module character varying(30),
    size integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.smtp_transactions OWNER TO mipanel;

--
-- Name: smtp_transactions_smtp_transaction_id_seq; Type: SEQUENCE; Schema: public; Owner: mipanel
--

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


ALTER TABLE public.smtp_transactions_smtp_transaction_id_seq OWNER TO mipanel;

--
-- Name: smtp_transactions_smtp_transaction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: mipanel
--

ALTER SEQUENCE smtp_transactions_smtp_transaction_id_seq OWNED BY smtp_transactions.smtp_transaction_id;


--
-- Name: smtp_transaction_recipient_id; Type: DEFAULT; Schema: public; Owner: mipanel
--

ALTER TABLE smtp_transaction_recipients ALTER COLUMN smtp_transaction_recipient_id SET DEFAULT nextval('smtp_transaction_recipients_smtp_transaction_recipient_id_seq'::regclass);


--
-- Name: smtp_transaction_id; Type: DEFAULT; Schema: public; Owner: mipanel
--

ALTER TABLE smtp_transactions ALTER COLUMN smtp_transaction_id SET DEFAULT nextval('smtp_transactions_smtp_transaction_id_seq'::regclass);


--
-- Name: smtp_transaction_recipients_pkey; Type: CONSTRAINT; Schema: public; Owner: mipanel; Tablespace:
--

ALTER TABLE ONLY smtp_transaction_recipients
    ADD CONSTRAINT smtp_transaction_recipients_pkey PRIMARY KEY (smtp_transaction_recipient_id);


--
-- Name: smtp_transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: mipanel; Tablespace:
--

ALTER TABLE ONLY smtp_transactions
    ADD CONSTRAINT smtp_transactions_pkey PRIMARY KEY (smtp_transaction_id);


--
-- Name: smtp_transaction_recipients_smtp_transaction_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: mipanel
--

ALTER TABLE ONLY smtp_transaction_recipients
    ADD CONSTRAINT smtp_transaction_recipients_smtp_transaction_id_fkey FOREIGN KEY (smtp_transaction_id) REFERENCES smtp_transactions(smtp_transaction_id);


--
-- PostgreSQL database dump complete
--