-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
92 lines (77 loc) · 3.36 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
#
# Table structure for table 'tx_ffpinodeupdates_domain_model_node'
#
CREATE TABLE tx_ffpinodeupdates_domain_model_node
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
node_id varchar(255) DEFAULT '' NOT NULL,
node_name VARCHAR(255) DEFAULT '' NOT NULL,
role VARCHAR(255) DEFAULT '' NOT NULL,
online tinyint(1) unsigned DEFAULT '0' NOT NULL,
last_change int(11) DEFAULT '0' NOT NULL,
domain VARCHAR(255) DEFAULT '' NOT NULL,
hardware_model VARCHAR(255) DEFAULT '' NOT NULL,
first_seen int(11) DEFAULT '0' NOT NULL,
last_seen 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,
PRIMARY KEY (uid),
KEY parent (pid),
KEY nodeId (node_id)
);
#
# Table structure for table 'tx_ffpinodeupdates_domain_model_abo'
#
CREATE TABLE tx_ffpinodeupdates_domain_model_abo
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
confirmed tinyint(1) unsigned DEFAULT '0' NOT NULL,
last_notification int(11) DEFAULT '0' NOT NULL,
secret varchar(255) DEFAULT '' NOT NULL,
node 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,
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)
);
#
# Table structure for table 'tx_ffpinodeupdates_domain_model_abo'
#
CREATE TABLE tx_ffpinodeupdates_domain_model_gateway
(
node int(11) unsigned DEFAULT '0',
http_adress varchar(255) DEFAULT '' NOT NULL,
ping float unsigned default NULL,
open_vpn int(1) DEFAULT '0',
network_interface int(1) DEFAULT '0',
firewall int(1) DEFAULT '0',
exit_vpn int(1) DEFAULT '0',
last_health_check int(11) DEFAULT '0' NOT NULL,
last_health_change int(11) DEFAULT '0' NOT NULL
);
CREATE TABLE tx_ffpinodeupdates_domain_model_freifunkapifile
(
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
json_template text DEFAULT '' NOT NULL,
activeNodes int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);