forked from kartolo/direct_mail
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
executable file
·237 lines (222 loc) · 8.24 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
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
#
# Table structure for table 'cache_sys_dmail_stat'
#
CREATE TABLE cache_sys_dmail_stat (
mid int(11) DEFAULT '0' NOT NULL,
rid varchar(11) DEFAULT '0' NOT NULL,
rtbl char(1) DEFAULT '' NOT NULL,
pings tinyint(3) unsigned DEFAULT '0' NOT NULL,
plain_links tinyint(3) unsigned DEFAULT '0' NOT NULL,
html_links tinyint(3) unsigned DEFAULT '0' NOT NULL,
links tinyint(3) unsigned DEFAULT '0' NOT NULL,
recieved_html tinyint(3) unsigned DEFAULT '0' NOT NULL,
recieved_plain tinyint(3) unsigned DEFAULT '0' NOT NULL,
size int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
pings_first int(11) DEFAULT '0' NOT NULL,
pings_last int(11) DEFAULT '0' NOT NULL,
html_links_first int(11) DEFAULT '0' NOT NULL,
html_links_last int(11) DEFAULT '0' NOT NULL,
plain_links_first int(11) DEFAULT '0' NOT NULL,
plain_links_last int(11) DEFAULT '0' NOT NULL,
links_first int(11) DEFAULT '0' NOT NULL,
links_last int(11) DEFAULT '0' NOT NULL,
response_first int(11) DEFAULT '0' NOT NULL,
response_last int(11) DEFAULT '0' NOT NULL,
response tinyint(3) unsigned DEFAULT '0' NOT NULL,
time_firstping int(11) DEFAULT '0' NOT NULL,
time_lastping int(11) DEFAULT '0' NOT NULL,
time_first_link int(11) DEFAULT '0' NOT NULL,
time_last_link int(11) DEFAULT '0' NOT NULL,
firstlink tinyint(4) DEFAULT '0' NOT NULL,
firstlink_time int(11) DEFAULT '0' NOT NULL,
secondlink tinyint(4) DEFAULT '0' NOT NULL,
secondlink_time int(11) DEFAULT '0' NOT NULL,
thirdlink tinyint(4) DEFAULT '0' NOT NULL,
thirdlink_time int(11) DEFAULT '0' NOT NULL,
returned tinyint(4) DEFAULT '0' NOT NULL,
KEY `mid` (mid)
);
#
# Table structure for table 'sys_dmail'
#
CREATE TABLE sys_dmail (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
type tinyint(4) unsigned DEFAULT '0' NOT NULL,
page int(11) unsigned DEFAULT '0' NOT NULL,
attachment tinyblob,
subject varchar(120) DEFAULT '' NOT NULL,
from_email varchar(80) DEFAULT '' NOT NULL,
from_name varchar(80) DEFAULT '' NOT NULL,
replyto_email varchar(80) DEFAULT '' NOT NULL,
replyto_name varchar(80) DEFAULT '' NOT NULL,
organisation varchar(80) DEFAULT '' NOT NULL,
priority tinyint(4) unsigned DEFAULT '0' NOT NULL,
encoding varchar(80) DEFAULT 'quoted-printable' NOT NULL,
charset varchar(20) DEFAULT 'iso-8859-1' NOT NULL,
sendOptions tinyint(4) unsigned DEFAULT '0' NOT NULL,
includeMedia tinyint(4) unsigned DEFAULT '0' NOT NULL,
flowedFormat tinyint(4) unsigned DEFAULT '0' NOT NULL,
HTMLParams varchar(80) DEFAULT '' NOT NULL,
plainParams varchar(80) DEFAULT '' NOT NULL,
issent tinyint(4) unsigned DEFAULT '0' NOT NULL,
renderedsize int(11) unsigned DEFAULT '0' NOT NULL,
mailContent mediumblob,
scheduled int(10) unsigned DEFAULT '0' NOT NULL,
query_info mediumblob,
scheduled_begin int(10) unsigned DEFAULT '0' NOT NULL,
scheduled_end int(10) unsigned DEFAULT '0' NOT NULL,
return_path varchar(80) DEFAULT '' NOT NULL,
use_rdct tinyint(4) unsigned DEFAULT '0' NOT NULL,
long_link_rdct_url varchar(2048) DEFAULT '' NOT NULL,
long_link_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
authcode_fieldList varchar(80) DEFAULT '' NOT NULL,
recipientGroups varchar(80) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Table structure for table 'sys_dmail_group'
#
CREATE TABLE sys_dmail_group (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
type tinyint(4) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
description text NOT NULL,
query blob,
queryLimit varchar(255) DEFAULT '' NOT NULL,
queryLimitDisabled tinyint(4) unsigned DEFAULT '1' NOT NULL,
static_list int(11) DEFAULT '0' NOT NULL,
list mediumblob,
csv tinyint(4) DEFAULT '0' NOT NULL,
pages tinyblob,
whichtables tinyint(4) DEFAULT '0' NOT NULL,
recursive tinyint(4) DEFAULT '0' NOT NULL,
mail_groups tinyblob,
select_categories int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'sys_dmail_group_mm'
#
CREATE TABLE sys_dmail_group_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'sys_dmail_maillog'
#
CREATE TABLE sys_dmail_maillog (
uid int(11) unsigned NOT NULL auto_increment,
mid int(11) unsigned DEFAULT '0' NOT NULL,
rid varchar(40) DEFAULT '0' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
rtbl char(1) DEFAULT '' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
url blob NULL,
size int(11) unsigned DEFAULT '0' NOT NULL,
parsetime int(11) unsigned DEFAULT '0' NOT NULL,
response_type tinyint(4) DEFAULT '0' NOT NULL,
html_sent tinyint(4) DEFAULT '0' NOT NULL,
url_id tinyint(4) DEFAULT '0' NOT NULL,
return_content mediumblob NULL,
return_code smallint(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY rid (rid,rtbl,mid,response_type,uid),
KEY `mid` (mid,response_type,rtbl,rid)
);
#
# Table structure for table 'sys_dmail_category'
#
CREATE TABLE sys_dmail_category (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
category tinytext NOT NULL,
old_cat_number char(2) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'sys_dmail_group_category_mm'
#
#
CREATE TABLE sys_dmail_group_category_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'sys_dmail_feuser_category_mm'
#
#
CREATE TABLE sys_dmail_feuser_category_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'sys_dmail_ttaddress_category_mm'
#
#
CREATE TABLE sys_dmail_ttaddress_category_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'sys_dmail_ttcontent_category_mm'
#
#
CREATE TABLE sys_dmail_ttcontent_category_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
# THESE create statements will NOT work if this file is piped into MySQL.
# Rather they will be detected by the Typo3 Install Tool and through that
# you should upgrade the tables to content these fields.
CREATE TABLE fe_users (
module_sys_dmail_newsletter tinyint(3) unsigned DEFAULT '0' NOT NULL,
module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
module_sys_dmail_html tinyint(3) unsigned DEFAULT '0' NOT NULL
);
CREATE TABLE tt_address (
module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
module_sys_dmail_html tinyint(3) unsigned DEFAULT '0' NOT NULL,
);
CREATE TABLE tt_content (
module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
);