-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathext_tables.sql
465 lines (412 loc) · 14.3 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
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
#
# Table structure for table 'tx_cfcleague_group'
#
CREATE TABLE tx_cfcleague_group (
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,
starttime int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
shortname varchar(55) DEFAULT '' NOT NULL,
logo int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_saison'
#
CREATE TABLE tx_cfcleague_saison (
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,
name varchar(255) DEFAULT '' NOT NULL,
halftime int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_competition'
#
CREATE TABLE tx_cfcleague_competition (
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,
tournament tinyint(4) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
short_name varchar(150) DEFAULT '' NOT NULL,
internal_name varchar(255) DEFAULT '' NOT NULL,
agegroup varchar(50) DEFAULT '' NOT NULL,
saison int(11) DEFAULT '0' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
obligation tinyint(4) DEFAULT '1' NOT NULL,
teams text,
point_system int(11) DEFAULT '0' NOT NULL,
match_keys text,
table_marks text,
logo int(11) DEFAULT '0' NOT NULL,
sports varchar(50) DEFAULT '' NOT NULL,
tablestrategy varchar(50) DEFAULT '' NOT NULL,
match_parts tinyint(4) DEFAULT '0' NOT NULL,
addparts tinyint(4) DEFAULT '0' NOT NULL,
parent int(11) DEFAULT '0' NOT NULL,
extid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_competition_penalty'
# Vergabe von Strafen für Teams eines Wettbewerbs
# Es können Punkte und Tore vergeben werden
# Es kann eine feste Platzierung festgelegt werden (Entzug der Lizenz)
#
CREATE TABLE tx_cfcleague_competition_penalty (
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,
competition int(11) DEFAULT '0' NOT NULL,
team int(11) DEFAULT '0' NOT NULL,
game int(11) DEFAULT '0' NOT NULL,
comment text,
matches int(11) DEFAULT '0' NOT NULL,
wins int(11) DEFAULT '0' NOT NULL,
draws int(11) DEFAULT '0' NOT NULL,
loses int(11) DEFAULT '0' NOT NULL,
goals_pos int(11) DEFAULT '0' NOT NULL,
goals_neg int(11) DEFAULT '0' NOT NULL,
points_pos int(11) DEFAULT '0' NOT NULL,
points_neg int(11) DEFAULT '0' NOT NULL,
static_position int(11) DEFAULT '0' NOT NULL,
correction tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_club'
#
CREATE TABLE tx_cfcleague_club (
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,
name varchar(150) DEFAULT '' NOT NULL,
short_name varchar(100) DEFAULT '' NOT NULL,
logo int(11) DEFAULT '0' NOT NULL,
address int(11) DEFAULT '0' NOT NULL,
favorite tinyint(4) DEFAULT '0' NOT NULL,
www varchar(200) DEFAULT '' NOT NULL,
email varchar(200) DEFAULT '' NOT NULL,
street varchar(200) DEFAULT '' NOT NULL,
zip varchar(10) DEFAULT '' NOT NULL,
city varchar(200) DEFAULT '' NOT NULL,
lng tinytext,
lat tinytext,
country int(11) DEFAULT '0' NOT NULL,
countrycode varchar(20) DEFAULT '' NOT NULL,
shortinfo text,
info text,
info2 text,
stadiums int(11) DEFAULT '0' NOT NULL,
established date DEFAULT NULL,
yearestablished int(11) DEFAULT '0' NOT NULL,
colors varchar(100) DEFAULT '' NOT NULL,
members int(11) DEFAULT '0' NOT NULL,
extid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_teams'
#
CREATE TABLE tx_cfcleague_teams (
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,
dummy tinyint(4) DEFAULT '0' NOT NULL,
club int(11) DEFAULT '0' NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
short_name varchar(100) DEFAULT '' NOT NULL,
tlc varchar(3) DEFAULT '' NOT NULL,
agegroup int(11) DEFAULT '0' NOT NULL,
coaches text,
players text,
supporters text,
logo int(11) DEFAULT '0' NOT NULL,
t3logo int(11) DEFAULT '0' NOT NULL,
t3images int(11) DEFAULT '0' NOT NULL,
comment text,
players_comment text,
coaches_comment text,
supporters_comment text,
link_report tinyint(4) DEFAULT '0' NOT NULL,
extid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_games'
#
CREATE TABLE tx_cfcleague_games (
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,
match_no varchar(5) DEFAULT '' NOT NULL,
home int(11) DEFAULT '0' NOT NULL,
guest int(11) DEFAULT '0' NOT NULL,
sets varchar(254) DEFAULT '' NOT NULL,
competition int(11) DEFAULT '0' NOT NULL,
round int(11) DEFAULT '0' NOT NULL,
round_name varchar(100) DEFAULT '' NOT NULL,
addinfo varchar(254) DEFAULT '' NOT NULL,
stadium varchar(200) DEFAULT '' NOT NULL,
arena int(11) DEFAULT '0' NOT NULL,
status int(11) DEFAULT '0' NOT NULL,
referee int(11) DEFAULT '0' NOT NULL,
assists text,
videoreferee int(11) DEFAULT '0' NOT NULL,
videoassists int(11) DEFAULT '0' NOT NULL,
coach_home int(11) DEFAULT '0' NOT NULL,
coach_guest int(11) DEFAULT '0' NOT NULL,
players_home text,
players_guest text,
substitutes_home text,
substitutes_guest text,
system_home varchar(100) DEFAULT '' NOT NULL,
system_guest varchar(100) DEFAULT '' NOT NULL,
players_home_stat text,
players_guest_stat text,
substitutes_home_stat text,
substitutes_guest_stat text,
scorer_home_stat text,
scorer_guest_stat text,
goals_home_1 int(11) DEFAULT '0' NOT NULL,
goals_guest_1 int(11) DEFAULT '0' NOT NULL,
goals_home_2 int(11) DEFAULT '0' NOT NULL,
goals_guest_2 int(11) DEFAULT '0' NOT NULL,
goals_home_3 int(11) DEFAULT '0' NOT NULL,
goals_guest_3 int(11) DEFAULT '0' NOT NULL,
goals_home_4 int(11) DEFAULT '0' NOT NULL,
goals_guest_4 int(11) DEFAULT '0' NOT NULL,
score_home int(11) DEFAULT '0' NOT NULL,
score_guest int(11) DEFAULT '0' NOT NULL,
date int(11) DEFAULT '0' NOT NULL,
link_report tinyint(4) DEFAULT '0' NOT NULL,
link_ticker tinyint(4) DEFAULT '0' NOT NULL,
game_report_author varchar(100) DEFAULT '' NOT NULL,
game_report text,
liveticker_author varchar(100) DEFAULT '' NOT NULL,
visitors int(11) DEFAULT '0' NOT NULL,
dam_media int(11) DEFAULT '0' NOT NULL,
dam_media2 int(11) DEFAULT '0' NOT NULL,
t3images int(11) DEFAULT '0' NOT NULL,
is_extratime tinyint(3) DEFAULT '0' NOT NULL,
goals_home_et int(11) DEFAULT '0' NOT NULL,
goals_guest_et int(11) DEFAULT '0' NOT NULL,
is_penalty tinyint(3) DEFAULT '0' NOT NULL,
goals_home_ap int(11) DEFAULT '0' NOT NULL,
goals_guest_ap int(11) DEFAULT '0' NOT NULL,
extid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_profiles'
#
CREATE TABLE tx_cfcleague_profiles (
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,
gdpr tinyint(4) DEFAULT '0' NOT NULL,
gender tinyint(4) DEFAULT '0' NOT NULL,
stage_name varchar(70) DEFAULT '' NOT NULL,
first_name varchar(50) DEFAULT '' NOT NULL,
last_name varchar(70) DEFAULT '' NOT NULL,
link_report tinyint(4) DEFAULT '0' NOT NULL,
t3images int(11) DEFAULT '0' NOT NULL,
birthday int(11) DEFAULT '0' NOT NULL,
dayofdeath int(11) DEFAULT '0' NOT NULL,
died tinyint(4) DEFAULT '0' NOT NULL,
home_town varchar(150) DEFAULT '' NOT NULL,
native_town varchar(150) DEFAULT '' NOT NULL,
nationality varchar(100) DEFAULT '' NOT NULL,
height int(11) DEFAULT '0' NOT NULL,
weight int(11) DEFAULT '0' NOT NULL,
position varchar(150) DEFAULT '' NOT NULL,
duration_of_contract int(11) DEFAULT '0' NOT NULL,
start_of_contract varchar(150) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
nickname varchar(150) DEFAULT '' NOT NULL,
summary text,
description text,
types varchar(150) DEFAULT '' NOT NULL,
extid varchar(255) DEFAULT '' NOT NULL,
relitems int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_profiletypes_mm'
# uid_local used for profiletype
#
CREATE TABLE tx_cfcleague_profiletypes_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_cfcleague_profiletypes_mm'
# uid_local used for fixture
#
CREATE TABLE tx_cfcleague_profiles_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,
fieldname 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_cfcleague_saison'
#
CREATE TABLE tx_cfcleague_match_notes (
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,
second tinyint(4) DEFAULT '0' NOT NULL,
minute int(11) DEFAULT '0' NOT NULL,
extra_time tinyint(4) DEFAULT '0' NOT NULL,
game int(11) DEFAULT '0' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
player_home int(11) DEFAULT '0' NOT NULL,
player_guest int(11) DEFAULT '0' NOT NULL,
comment text,
PRIMARY KEY (uid),
KEY parent (pid),
KEY idx_game (game)
);
CREATE TABLE tx_cfcleague_team_notes (
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,
team int(11) DEFAULT '0' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
mediatype int(11) DEFAULT '0' NOT NULL,
player int(11) DEFAULT '0' NOT NULL,
comment text,
media int(11) DEFAULT '0' NOT NULL,
number int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY idx_team (team)
);
CREATE TABLE tx_cfcleague_note_types (
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,
label varchar(50) DEFAULT '' NOT NULL,
marker varchar(20) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_stadiums'
#
CREATE TABLE tx_cfcleague_stadiums (
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,
deleted tinyint(4) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
altname varchar(255) DEFAULT '' NOT NULL,
capacity int(11) DEFAULT '0' NOT NULL,
description text,
description2 text,
street varchar(255) DEFAULT '' NOT NULL,
city varchar(255) DEFAULT '' NOT NULL,
zip varchar(150) DEFAULT '' NOT NULL,
country int(11) DEFAULT '0' NOT NULL,
countrycode varchar(20) DEFAULT '' NOT NULL,
lng tinytext,
lat tinytext,
logo int(11) DEFAULT '0' NOT NULL,
pictures int(11) DEFAULT '0' NOT NULL,
clubs int(11) DEFAULT '0' NOT NULL,
address int(11) DEFAULT '0' NOT NULL,
extid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_cfcleague_stadiums_mm'
# uid_local used for stadium
#
CREATE TABLE tx_cfcleague_stadiums_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)
);