forked from fabarea/messenger
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
127 lines (106 loc) · 3.93 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
#
# Table structure for table 'tx_messenger_domain_model_messagetemplate'
#
CREATE TABLE tx_messenger_domain_model_messagetemplate (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
source_page int(11) DEFAULT '0' NOT NULL,
source_file varchar(255) DEFAULT '' NOT NULL,
qualifier varchar(255) DEFAULT '' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
body longtext,
template_engine varchar(20) DEFAULT '' NOT NULL,
message_layout 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,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_messenger_domain_model_messagelayout'
#
CREATE TABLE tx_messenger_domain_model_messagelayout (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
qualifier varchar(255) DEFAULT '' NOT NULL,
content text,
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,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_messenger_domain_model_sentmessage'
#
CREATE TABLE tx_messenger_domain_model_sentmessage (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
uuid varchar(36) DEFAULT '' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
sender varchar(255) DEFAULT '' NOT NULL,
recipient varchar(255) DEFAULT '' NOT NULL,
recipient_cc varchar(255) DEFAULT '' NOT NULL,
recipient_bcc varchar(255) DEFAULT '' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
body longtext,
attachment text,
context varchar(255) DEFAULT '' NOT NULL,
mailing_name varchar(255) DEFAULT '' NOT NULL,
message_template int(11) unsigned DEFAULT '0' NOT NULL,
message_layout int(11) unsigned DEFAULT '0' NOT NULL,
scheduled_distribution_time int(11) unsigned DEFAULT '0' NOT NULL,
ip varchar(255) DEFAULT '' NOT NULL,
sent_time int(11) unsigned DEFAULT '0' NOT NULL,
was_opened int(11) unsigned DEFAULT '0' NOT NULL,
redirect_email_from varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY uuid (uuid)
);
#
# Table structure for table 'tx_messenger_domain_model_queue'
#
CREATE TABLE tx_messenger_domain_model_queue (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
uuid varchar(36) DEFAULT '' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
sender varchar(255) DEFAULT '' NOT NULL,
recipient varchar(255) DEFAULT '' NOT NULL,
recipient_cc varchar(255) DEFAULT '' NOT NULL,
recipient_bcc varchar(255) DEFAULT '' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
body longtext,
attachment text,
context varchar(255) DEFAULT '' NOT NULL,
mailing_name varchar(255) DEFAULT '' NOT NULL,
message_template int(11) unsigned DEFAULT '0' NOT NULL,
message_layout int(11) unsigned DEFAULT '0' NOT NULL,
scheduled_distribution_time int(11) unsigned DEFAULT '0' NOT NULL,
ip varchar(255) DEFAULT '' NOT NULL,
error_count int(11) unsigned DEFAULT '0' NOT NULL,
message_serialized text,
redirect_email_from varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY uuid (uuid)
);