-
Notifications
You must be signed in to change notification settings - Fork 27
/
Copy pathext_tables.sql
160 lines (130 loc) · 4.71 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
CREATE TABLE tx_luxletter_domain_model_newsletter (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
category int(11) DEFAULT '0' NOT NULL,
description text NOT NULL,
datetime int(11) DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
receivers varchar(255) DEFAULT '' NOT NULL,
configuration int(11) DEFAULT '0' NOT NULL,
layout varchar(255) DEFAULT '' NOT NULL,
origin varchar(255) DEFAULT '' NOT NULL,
bodytext mediumtext,
disabled tinyint(4) unsigned DEFAULT '0' NOT NULL,
language int(11) DEFAULT '0' NOT NULL,
queued tinyint(4) unsigned DEFAULT '1' 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),
KEY receivers (receivers),
KEY configuration (configuration)
);
CREATE TABLE tx_luxletter_domain_model_queue (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
newsletter int(11) DEFAULT '0' NOT NULL,
user int(11) DEFAULT '0' NOT NULL,
datetime int(11) DEFAULT '0' NOT NULL,
sent tinyint(4) unsigned DEFAULT '0' NOT NULL,
failures int(11) 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),
KEY newsletter (newsletter),
KEY user (user)
);
CREATE TABLE tx_luxletter_domain_model_log (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
newsletter int(11) DEFAULT '0' NOT NULL,
user int(11) DEFAULT '0' NOT NULL,
status tinyint(4) unsigned DEFAULT '0' NOT NULL,
properties 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,
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),
KEY newsletter (newsletter),
KEY user (user)
);
CREATE TABLE tx_luxletter_domain_model_link (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
newsletter int(11) DEFAULT '0' NOT NULL,
user int(11) DEFAULT '0' NOT NULL,
hash varchar(255) DEFAULT '' NOT NULL,
target text 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,
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),
KEY hash (hash(8)),
KEY newsletter (newsletter),
KEY user (user)
);
CREATE TABLE tx_luxletter_domain_model_configuration (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
from_email varchar(255) DEFAULT '' NOT NULL,
from_name varchar(255) DEFAULT '' NOT NULL,
reply_email varchar(255) DEFAULT '' NOT NULL,
reply_name varchar(255) DEFAULT '' NOT NULL,
site varchar(255) DEFAULT '' 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,
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)
);
CREATE TABLE fe_users (
luxletter_language int(11) DEFAULT '0' NOT NULL,
);
CREATE TABLE fe_groups (
luxletter_receiver tinyint(4) unsigned DEFAULT '0' NOT NULL
);
CREATE TABLE pages (
luxletter_subject text,
);
CREATE TABLE sys_category (
luxletter_newsletter_category tinyint(4) unsigned DEFAULT '0' NOT NULL
);