-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathext_tables.sql
199 lines (160 loc) · 7.42 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
#
# Table structure for table 'tx_fourallportal_domain_model_server'
#
CREATE TABLE tx_fourallportal_domain_model_server
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
domain varchar(255) DEFAULT '' NOT NULL,
customer_name varchar(255) DEFAULT '' NOT NULL,
username varchar(255) DEFAULT '' NOT NULL,
password varchar(255) DEFAULT '' NOT NULL,
active smallint(5) unsigned DEFAULT '0' NOT NULL,
modules int(11) unsigned DEFAULT '0' NOT NULL,
dimension_mappings 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 smallint(5) unsigned DEFAULT '0' NOT NULL,
hidden smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_fourallportal_domain_model_module'
#
CREATE TABLE tx_fourallportal_domain_model_module
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
server int(11) unsigned DEFAULT '0' NOT NULL,
shell_path varchar(255) DEFAULT '' NOT NULL,
connector_name varchar(255) DEFAULT '' NOT NULL,
module_name varchar(255) DEFAULT '' NOT NULL,
mapping_class varchar(255) DEFAULT '' NOT NULL,
enable_dynamic_model int(4) unsigned DEFAULT '1' NOT NULL,
contains_dimensions smallint(5) unsigned DEFAULT '1' NOT NULL,
config_hash varchar(255) DEFAULT '' NOT NULL,
last_event_id int(11) DEFAULT '0' NOT NULL,
last_received_event_id int(11) DEFAULT '0' NOT NULL,
storage_pid int(11) DEFAULT '0' NOT NULL,
fal_storage int(11) DEFAULT '0' NOT NULL,
usage_flag varchar(32) DEFAULT '' NOT NULL,
test_object_uuid 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,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_fourallportal_domain_model_complextype'
#
CREATE TABLE tx_fourallportal_domain_model_complextype
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
field_name varchar(255) DEFAULT '' NOT NULL,
table_name varchar(255) DEFAULT '' NOT NULL,
parent_uid int(11) DEFAULT '0' NOT NULL,
type varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
label_max varchar(255) DEFAULT '' NOT NULL,
normalized_value varchar(255) DEFAULT '' NOT NULL,
actual_value varchar(255) DEFAULT '' NOT NULL,
normalized_value_max varchar(255) DEFAULT '' NOT NULL,
actual_value_max varchar(255) DEFAULT '' NOT NULL,
cast_type varchar(16) 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 smallint(5) unsigned DEFAULT '0' NOT NULL,
sys_language_uid INT(11) DEFAULT '0' NOT NULL,
l10n_state TEXT DEFAULT NULL,
l10n_parent INT(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY field_name (field_name),
KEY table_name (table_name),
KEY name (name),
KEY sys_language_uid (sys_language_uid),
KEY l10n_parent (l10n_parent)
);
#
# Table structure for table 'tx_fourallportal_domain_model_event'
#
CREATE TABLE tx_fourallportal_domain_model_event
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
event_id int(11) DEFAULT '0' NOT NULL,
event_type varchar(255) DEFAULT '' NOT NULL,
status varchar(255) DEFAULT '' NOT NULL,
skip_until int(11) DEFAULT '0' NOT NULL,
next_retry int(11) DEFAULT '0' NOT NULL,
retries int(11) DEFAULT '0' NOT NULL,
object_id varchar(255) DEFAULT '' NOT NULL,
module int(11) unsigned DEFAULT '0',
processing smallint(5) unsigned DEFAULT '0' NOT NULL,
url text,
headers text,
response longtext,
payload text,
message 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 smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY event_type (event_type),
KEY object_id (object_id),
KEY status (status),
KEY module (module),
KEY next_retry (next_retry)
);
#
# Table structure for table 'sys_file'
#
CREATE TABLE sys_file
(
remote_id varchar(255) DEFAULT '' NOT NULL,
KEY remote_id (remote_id)
);
#
# Table structure for table 'tx_fourallportal_domain_model_dimension_mapping'
#
CREATE TABLE tx_fourallportal_domain_model_dimensionmapping
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
server int(11) unsigned DEFAULT '0' NOT NULL,
dimensions int(11) unsigned DEFAULT '0' NOT NULL,
language varchar(255) DEFAULT '' NOT NULL,
metric_or_imperial varchar(10) DEFAULT 'Metric' NOT NULL,
active smallint(5) 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,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_fourallportal_domain_model_dimension'
#
CREATE TABLE tx_fourallportal_domain_model_dimension
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
dimension_mapping int(11) unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
value 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,
PRIMARY KEY (uid),
KEY parent (pid)
);