forked from georgringer/t3monitoring
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathext_tables.sql
More file actions
195 lines (159 loc) · 6.1 KB
/
ext_tables.sql
File metadata and controls
195 lines (159 loc) · 6.1 KB
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
#
# Table structure for table 'tx_t3monitoring_domain_model_backend_user'
#
CREATE TABLE tx_t3monitoring_domain_model_backend_user (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
user_name varchar(255) DEFAULT '' NOT NULL,
real_name varchar(255) DEFAULT '' NOT NULL,
email_address varchar(255) DEFAULT '' NOT NULL,
description text NOT NULL,
last_login 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,
PRIMARY KEY (uid),
KEY parent (pid),
);
#
# Table structure for table 'tx_t3monitoring_domain_model_client'
#
CREATE TABLE tx_t3monitoring_domain_model_client (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
domain varchar(255) DEFAULT '' NOT NULL,
secret varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
php_version varchar(255) DEFAULT '' NOT NULL,
mysql_version varchar(255) DEFAULT '' NOT NULL,
insecure_core tinyint(1) unsigned DEFAULT '0' NOT NULL,
outdated_core tinyint(1) unsigned DEFAULT '0' NOT NULL,
insecure_extensions int(11) DEFAULT '0' NOT NULL,
outdated_extensions int(11) DEFAULT '0' NOT NULL,
error_message varchar(255) DEFAULT '' NOT NULL,
extra_info text NOT NULL,
extra_warning text NOT NULL,
extra_danger text NOT NULL,
last_successful_import int(11) DEFAULT '0' NOT NULL,
extensions int(11) unsigned DEFAULT '0' NOT NULL,
backend_users int(11) unsigned DEFAULT '0' NOT NULL,
core int(11) unsigned DEFAULT '0',
sla int(11) unsigned DEFAULT '0',
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,
PRIMARY KEY (uid),
KEY parent (pid),
);
#
# Table structure for table 'tx_t3monitoring_domain_model_extension'
#
CREATE TABLE tx_t3monitoring_domain_model_extension (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
version varchar(255) DEFAULT '' NOT NULL,
insecure tinyint(1) unsigned DEFAULT '0' NOT NULL,
next_secure_version varchar(255) DEFAULT '' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description text NOT NULL,
last_updated datetime DEFAULT NULL,
author_name varchar(255) DEFAULT '' NOT NULL,
update_comment varchar(255) DEFAULT '' NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
category int(11) DEFAULT '0' NOT NULL,
version_integer int(11) DEFAULT '0' NOT NULL,
is_used tinyint(1) unsigned DEFAULT '0' NOT NULL,
is_official tinyint(1) unsigned DEFAULT '0' NOT NULL,
is_modified tinyint(1) unsigned DEFAULT '0' NOT NULL,
is_latest tinyint(1) unsigned DEFAULT '0' NOT NULL,
last_bugfix_release varchar(255) DEFAULT '' NOT NULL,
last_minor_release varchar(255) DEFAULT '' NOT NULL,
last_major_release varchar(255) DEFAULT '' NOT NULL,
serialized_dependencies 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,
PRIMARY KEY (uid),
KEY parent (pid),
KEY major (name,major_version),
);
#
# Table structure for table 'tx_t3monitoring_domain_model_core'
#
CREATE TABLE tx_t3monitoring_domain_model_core (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
version varchar(255) DEFAULT '' NOT NULL,
insecure tinyint(1) unsigned DEFAULT '0' NOT NULL,
next_secure_version varchar(255) DEFAULT '' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
release_date datetime DEFAULT NULL,
latest varchar(255) DEFAULT '' NOT NULL,
stable varchar(255) DEFAULT '' NOT NULL,
is_stable tinyint(1) unsigned DEFAULT '0' NOT NULL,
is_active tinyint(1) unsigned DEFAULT '0' NOT NULL,
is_latest tinyint(1) unsigned DEFAULT '0' NOT NULL,
version_integer int(11) DEFAULT '0' NOT NULL,
is_used tinyint(1) unsigned DEFAULT '0' NOT NULL,
is_official tinyint(1) 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,
PRIMARY KEY (uid),
KEY parent (pid),
);
#
# Table structure for table 'tx_t3monitoring_domain_model_sla'
#
CREATE TABLE tx_t3monitoring_domain_model_sla (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description 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,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
);
#
# Table structure for table 'tx_t3monitoring_client_backend_user_mm'
#
CREATE TABLE tx_t3monitoring_client_backend_user_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_t3monitoring_client_extension_mm'
#
CREATE TABLE tx_t3monitoring_client_extension_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
## EXTENSION BUILDER DEFAULTS END TOKEN - Everything BEFORE this line is overwritten with the defaults of the extension builder
CREATE TABLE tx_t3monitoring_client_extension_mm (
is_loaded tinyint(4) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
);
CREATE TABLE tx_t3monitoring_domain_model_extension (
major_version int(11) unsigned DEFAULT '0' NOT NULL,
minor_version int(11) unsigned DEFAULT '0' NOT NULL,
);