forked from georgringer/t3monitoring
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
174 lines (145 loc) · 5.56 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
#
# 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,
basic_auth_username varchar(255) DEFAULT '' NOT NULL,
basic_auth_password 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,
disk_free_space bigint(20) unsigned DEFAULT '0' NOT NULL,
disk_total_space bigint(20) unsigned DEFAULT '0' 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,
core int(11) unsigned DEFAULT '0',
sla int(11) unsigned DEFAULT '0',
tag 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,
major_version int(11) unsigned DEFAULT '0' NOT NULL,
minor_version int(11) 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_domain_model_tag'
#
CREATE TABLE tx_t3monitoring_domain_model_tag (
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_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,
is_loaded tinyint(4) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);