forked from Ecodev/newsletter
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·135 lines (112 loc) · 4.38 KB
/
ext_tables.sql
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
134
135
CREATE TABLE fe_users (
tx_newsletter_bounce int(11) DEFAULT '0' NOT NULL
);
CREATE TABLE be_users (
tx_newsletter_bounce int(11) DEFAULT '0' NOT NULL
);
CREATE TABLE tx_newsletter_domain_model_newsletter (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
planned_time int(11) unsigned DEFAULT '0' NOT NULL,
begin_time int(11) unsigned DEFAULT '0' NOT NULL,
end_time int(11) unsigned DEFAULT '0' NOT NULL,
recipient_list int(11) unsigned DEFAULT '0',
is_test tinyint(1) unsigned DEFAULT '0' NOT NULL,
repetition int(11) DEFAULT '0' NOT NULL,
sender_name varchar(255) DEFAULT '' NOT NULL,
sender_email varchar(255) DEFAULT '' NOT NULL,
plain_converter varchar(255) DEFAULT 'Tx_Newsletter_Domain_Model_PlainConverter_Builtin' NOT NULL,
attachments varchar(255) DEFAULT '' NOT NULL,
inject_open_spy tinyint(1) unsigned DEFAULT '0' NOT NULL,
inject_links_spy tinyint(1) unsigned DEFAULT '0' NOT NULL,
bounce_account int(11) unsigned DEFAULT '0',
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_newsletter_domain_model_bounceaccount (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
server varchar(255) DEFAULT '' NOT NULL,
protocol varchar(255) DEFAULT '' NOT NULL,
username varchar(255) DEFAULT '' NOT NULL,
password varchar(255) DEFAULT '' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_newsletter_domain_model_recipientlist (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
plain_only tinyint(1) unsigned DEFAULT '0' NOT NULL,
lang varchar(255) DEFAULT '' NOT NULL,
type varchar(255) DEFAULT '' NOT NULL,
be_users varchar(255) DEFAULT '' NOT NULL,
fe_groups varchar(255) DEFAULT '' NOT NULL,
fe_pages varchar(255) DEFAULT '' NOT NULL,
csv_url varchar(512) DEFAULT '' NOT NULL,
csv_separator varchar(1) DEFAULT ',' NOT NULL,
csv_fields varchar(255) DEFAULT '' NOT NULL,
csv_filename varchar(255) DEFAULT '' NOT NULL,
csv_values text NOT NULL,
sql_statement text NOT NULL,
sql_register_bounce text NOT NULL,
sql_register_open text NOT NULL,
sql_register_click text NOT NULL,
html_url varchar(512) DEFAULT '' NOT NULL,
html_fetch_type varchar(255) DEFAULT '' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_newsletter_domain_model_email (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
begin_time int(11) unsigned DEFAULT '0' NOT NULL,
end_time int(11) unsigned DEFAULT '0' NOT NULL,
open_time int(11) unsigned DEFAULT '0' NOT NULL,
bounce_time int(11) unsigned DEFAULT '0' NOT NULL,
recipient_address varchar(255) DEFAULT '' NOT NULL,
recipient_data text NOT NULL,
newsletter int(11) unsigned DEFAULT '0',
unsubscribed tinyint(1) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY newsletter (newsletter),
KEY newsletter_end_time (newsletter,end_time),
KEY newsletter_open_time (newsletter,open_time),
KEY newsletter_bounce_time (newsletter,bounce_time),
);
CREATE TABLE tx_newsletter_domain_model_link (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
url varchar(512) DEFAULT '' NOT NULL,
newsletter int(11) unsigned DEFAULT '0',
opened_count int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_newsletter_domain_model_linkopened (
uid int(11) NOT NULL auto_increment,
link int(11) unsigned DEFAULT '0',
email int(11) unsigned DEFAULT '0',
is_plain tinyint(1) unsigned DEFAULT '0' NOT NULL,
open_time int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY email_open_time (email,open_time)
);