-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
120 lines (102 loc) · 3.84 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
CREATE TABLE tx_newt_domain_model_method (
endpoint int(11) unsigned DEFAULT '0' NOT NULL,
type varchar(255) NOT NULL DEFAULT '',
beusergroups int(11) unsigned NOT NULL DEFAULT '0',
feusergroups int(11) unsigned NOT NULL DEFAULT '0'
);
CREATE TABLE tx_newt_method_backendgroups_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,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE tx_newt_method_frontendgroups_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,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE tx_newt_domain_model_endpoint (
name varchar(255) NOT NULL DEFAULT '',
description text NOT NULL DEFAULT '',
endpoint_class varchar(255) NOT NULL DEFAULT '',
options int(11) unsigned NOT NULL DEFAULT '0',
methods int(11) unsigned NOT NULL DEFAULT '0',
page_uid varchar(11) NOT NULL DEFAULT '',
);
CREATE TABLE tx_newt_domain_model_endpointoption (
endpoint int(11) unsigned DEFAULT '0' NOT NULL,
option_name varchar(255) NOT NULL DEFAULT '',
option_value text NOT NULL DEFAULT '',
);
CREATE TABLE tx_newt_domain_model_notification (
title varchar(255) NOT NULL DEFAULT '',
message text NOT NULL DEFAULT '',
send_datetime int(11) DEFAULT '0' NOT NULL,
result_datetime int(11) DEFAULT '0' NOT NULL,
result text NOT NULL DEFAULT '',
is_topic tinyint(4) unsigned DEFAULT '0' NOT NULL,
beusers int(11) unsigned NOT NULL DEFAULT '0',
feusers int(11) unsigned NOT NULL DEFAULT '0',
beusergroups int(11) unsigned NOT NULL DEFAULT '0',
feusergroups int(11) unsigned NOT NULL DEFAULT '0'
);
CREATE TABLE tx_newt_notification_beusers_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,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE tx_newt_notification_feusers_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,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE tx_newt_notification_backendgroups_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,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE tx_newt_notification_frontendgroups_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,
PRIMARY KEY (uid_local,uid_foreign),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
CREATE TABLE be_users (
tx_newt_token varchar(100) DEFAULT '' NOT NULL,
tx_newt_token_issued int(11) DEFAULT '0' NOT NULL
);
CREATE TABLE fe_users (
tx_newt_token varchar(100) DEFAULT '' NOT NULL,
tx_newt_token_issued int(11) DEFAULT '0' NOT NULL
);
CREATE TABLE tx_newt_log (
request_id varchar(13) DEFAULT '' NOT NULL,
time_micro double(16,4) NOT NULL default '0.0000',
component varchar(255) DEFAULT '' NOT NULL,
level tinyint(1) unsigned DEFAULT '0' NOT NULL,
message text,
data text,
KEY request (request_id)
);