|
|
|
-
/postgresql/acs-mail-lite-create.sql
(+2 -33)
-
| |
39 |
39 |
constraint acs_mail_lite_bou_party_id_fk |
| |
40 |
40 |
references parties (party_id) |
| |
41 |
41 |
on delete cascade |
| |
42 |
42 |
constraint acs_mail_lite_bou_pk |
| |
43 |
43 |
primary key, |
| |
44 |
44 |
bounce_count integer default 1 |
| |
45 |
45 |
); |
| |
46 |
46 |
|
| |
47 |
47 |
|
| |
48 |
48 |
create table acs_mail_lite_bounce_notif ( |
| |
49 |
49 |
party_id integer |
| |
50 |
50 |
constraint acs_mail_li_bou_notif_us_id_fk |
| |
51 |
51 |
references parties (party_id) |
| |
52 |
52 |
on delete cascade |
| |
53 |
53 |
constraint acs_mail_lite_bounce_notif_pk |
| |
54 |
54 |
primary key, |
| |
55 |
55 |
notification_time timestamptz default current_timestamp, |
| |
56 |
56 |
notification_count integer default 0 |
| |
57 |
57 |
); |
| |
58 |
58 |
|
| |
59 |
|
|
| |
60 |
|
CREATE TABLE acs_mail_lite_complex_queue ( |
| |
61 |
|
id integer |
| |
62 |
|
constraint acs_mail_lite_complex_queue_pk |
| |
63 |
|
primary key, |
| |
64 |
|
creation_date text, |
| |
65 |
|
locking_server text, |
| |
66 |
|
to_party_ids text, |
| |
67 |
|
cc_party_ids text, |
| |
68 |
|
bcc_party_ids text, |
| |
69 |
|
to_group_ids text, |
| |
70 |
|
cc_group_ids text, |
| |
71 |
|
bcc_group_ids text, |
| |
72 |
|
to_addr text, |
| |
73 |
|
cc_addr text, |
| |
74 |
|
bcc_addr text, |
| |
75 |
|
from_addr text, |
| |
76 |
|
reply_to text, |
| |
77 |
|
subject text, |
| |
78 |
|
body text, |
| |
79 |
|
package_id integer, |
| |
80 |
|
files text, |
| |
81 |
|
file_ids text, |
| |
82 |
|
folder_ids text, |
| |
83 |
|
mime_type text, |
| |
84 |
|
object_id integer, |
| |
85 |
|
single_email_p boolean, |
| |
86 |
|
no_callback_p boolean, |
| |
87 |
|
extraheaders text, |
| |
88 |
|
alternative_part_p boolean, |
| |
89 |
|
use_sender_p boolean |
| |
90 |
|
); |
| |
|
59 |
\i complex-create.sql |
|