forked from in2code-de/luxletter
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
108 lines (86 loc) · 3.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
CREATE TABLE fe_groups (
luxletter_receiver tinyint(4) unsigned DEFAULT '0' NOT NULL
);
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,
description text NOT NULL,
datetime int(11) DEFAULT '0' NOT NULL,
subject varchar(255) DEFAULT '' NOT NULL,
receiver int(11) DEFAULT '0' NOT NULL,
origin varchar(255) DEFAULT '' NOT NULL,
bodytext mediumtext NOT NULL,
disabled tinyint(4) 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)
);
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,
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)
);
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 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 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)
);