forked from digedag/t3sportstats
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
195 lines (172 loc) · 6.22 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
#
# Table structure for table 'tx_cfcleague_group'
#
CREATE TABLE tx_t3sportstats_tags (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
target int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_cfcleague_competition (
tags int(11) DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_t3sportstats_tag_mm'
# uid_local used for tags
#
CREATE TABLE tx_t3sportstats_tags_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(50) DEFAULT '' 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_t3sportstats_players'
# Statistic data of player per match
#
CREATE TABLE tx_t3sportstats_players (
uid int(11) NOT NULL auto_increment,
crdate datetime DEFAULT NULL,
player int(11) DEFAULT '0' NOT NULL,
t3match int(11) DEFAULT '0' NOT NULL,
saison int(11) DEFAULT '0' NOT NULL,
competition int(11) DEFAULT '0' NOT NULL,
agegroup int(11) DEFAULT '0' NOT NULL,
team int(11) DEFAULT '0' NOT NULL,
club int(11) DEFAULT '0' NOT NULL,
ishome tinyint(4) DEFAULT '0' NOT NULL,
agegroupopp int(11) DEFAULT '0' NOT NULL,
clubopp int(11) DEFAULT '0' NOT NULL,
played tinyint(4) DEFAULT '0' NOT NULL,
cardyellow tinyint(4) DEFAULT '0' NOT NULL,
cardyr tinyint(4) DEFAULT '0' NOT NULL,
cardred tinyint(4) DEFAULT '0' NOT NULL,
playtime int(11) DEFAULT '0' NOT NULL,
goals int(11) DEFAULT '0' NOT NULL,
assists int(11) DEFAULT '0' NOT NULL,
goalshome int(11) DEFAULT '0' NOT NULL,
goalsaway int(11) DEFAULT '0' NOT NULL,
goalshead int(11) DEFAULT '0' NOT NULL,
goalsfreekick int(11) DEFAULT '0' NOT NULL,
goalspenalty int(11) DEFAULT '0' NOT NULL,
goalsjoker int(11) DEFAULT '0' NOT NULL,
goalsown int(11) DEFAULT '0' NOT NULL,
changein int(11) DEFAULT '0' NOT NULL,
changeout int(11) DEFAULT '0' NOT NULL,
win tinyint(4) DEFAULT '0' NOT NULL,
draw tinyint(4) DEFAULT '0' NOT NULL,
loose tinyint(4) DEFAULT '0' NOT NULL,
captain tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY playmatch (player,t3match)
);
#
# Table structure for table 'tx_t3sportstats_coachs'
# Statistic data of coach per match
#
CREATE TABLE tx_t3sportstats_coachs (
uid int(11) NOT NULL auto_increment,
crdate datetime DEFAULT NULL,
coach int(11) DEFAULT '0' NOT NULL,
t3match int(11) DEFAULT '0' NOT NULL,
saison int(11) DEFAULT '0' NOT NULL,
competition int(11) DEFAULT '0' NOT NULL,
agegroup int(11) DEFAULT '0' NOT NULL,
team int(11) DEFAULT '0' NOT NULL,
club int(11) DEFAULT '0' NOT NULL,
ishome tinyint(4) DEFAULT '0' NOT NULL,
agegroupopp int(11) DEFAULT '0' NOT NULL,
clubopp int(11) DEFAULT '0' NOT NULL,
played tinyint(4) DEFAULT '0' NOT NULL,
win tinyint(4) DEFAULT '0' NOT NULL,
draw tinyint(4) DEFAULT '0' NOT NULL,
loose tinyint(4) DEFAULT '0' NOT NULL,
goals int(11) DEFAULT '0' NOT NULL,
goalshome int(11) DEFAULT '0' NOT NULL,
goalsaway int(11) DEFAULT '0' NOT NULL,
goalsjoker int(11) DEFAULT '0' NOT NULL,
goalsagainst int(11) DEFAULT '0' NOT NULL,
goalshomeagainst int(11) DEFAULT '0' NOT NULL,
goalsawayagainst int(11) DEFAULT '0' NOT NULL,
cardyellow tinyint(4) DEFAULT '0' NOT NULL,
cardyr tinyint(4) DEFAULT '0' NOT NULL,
cardred tinyint(4) DEFAULT '0' NOT NULL,
changeout int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY idx_coachmatch (coach,t3match)
);
#
# Table structure for table 'tx_t3sportstats_referees'
# Statistic data of referee per match and club
#
CREATE TABLE tx_t3sportstats_referees (
uid int(11) NOT NULL auto_increment,
crdate datetime DEFAULT NULL,
referee int(11) DEFAULT '0' NOT NULL,
t3match int(11) DEFAULT '0' NOT NULL,
saison int(11) DEFAULT '0' NOT NULL,
competition int(11) DEFAULT '0' NOT NULL,
agegroup int(11) DEFAULT '0' NOT NULL,
team int(11) DEFAULT '0' NOT NULL,
club int(11) DEFAULT '0' NOT NULL,
ishome tinyint(4) DEFAULT '0' NOT NULL,
agegroupopp int(11) DEFAULT '0' NOT NULL,
clubopp int(11) DEFAULT '0' NOT NULL,
played tinyint(4) DEFAULT '0' NOT NULL,
mainref tinyint(4) DEFAULT '0' NOT NULL,
assist tinyint(4) DEFAULT '0' NOT NULL,
win tinyint(4) DEFAULT '0' NOT NULL,
draw tinyint(4) DEFAULT '0' NOT NULL,
loose tinyint(4) DEFAULT '0' NOT NULL,
goalspenalty int(11) DEFAULT '0' NOT NULL,
goalspenaltyown int(11) DEFAULT '0' NOT NULL,
goalspenaltyagainst int(11) DEFAULT '0' NOT NULL,
penalty int(11) DEFAULT '0' NOT NULL,
penaltyown int(11) DEFAULT '0' NOT NULL,
penaltyagainst int(11) DEFAULT '0' NOT NULL,
cardyellow tinyint(4) DEFAULT '0' NOT NULL,
cardyellowown tinyint(4) DEFAULT '0' NOT NULL,
cardyellowagainst tinyint(4) DEFAULT '0' NOT NULL,
cardyr tinyint(4) DEFAULT '0' NOT NULL,
cardyrown tinyint(4) DEFAULT '0' NOT NULL,
cardyragainst tinyint(4) DEFAULT '0' NOT NULL,
cardred tinyint(4) DEFAULT '0' NOT NULL,
cardredown tinyint(4) DEFAULT '0' NOT NULL,
cardredagainst tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY idx_refclubmatch (referee,club,t3match)
);
#
# Table structure for table 'tx_t3sportstats_players'
# Scope data for a match
#
#CREATE TABLE tx_t3sportstats_matchs (
# uid int(11) NOT NULL auto_increment,
# tstamp int(11) DEFAULT '0' NOT NULL,
# crdate int(11) DEFAULT '0' NOT NULL,
# t3match int(11) DEFAULT '0' NOT NULL,
# competition int(11) DEFAULT '0' NOT NULL,
# saison int(11) DEFAULT '0' NOT NULL,
# group int(11) DEFAULT '0' NOT NULL,
# round int(11) DEFAULT '0' NOT NULL,
# round_name varchar(100) DEFAULT '' NOT NULL,
# betgame int(11) DEFAULT '0' NOT NULL,
# status tinyint(4) DEFAULT '0' NOT NULL,
# teamquestions int(11) DEFAULT '0' NOT NULL,
# comment text NOT NULL,
# PRIMARY KEY (uid),
# KEY parent (pid)
#);