-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathext_tables.sql
More file actions
130 lines (95 loc) · 2.88 KB
/
ext_tables.sql
File metadata and controls
130 lines (95 loc) · 2.88 KB
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
#
# Table structure for table 'tx_teammanager_domain_model_club'
#
CREATE TABLE tx_teammanager_domain_model_club (
club_name varchar(255) DEFAULT '' NOT NULL,
about text,
found_date date DEFAULT NULL,
staff int(11) unsigned DEFAULT '0' NOT NULL,
teams int(11) unsigned DEFAULT '0' NOT NULL,
address int(11) unsigned DEFAULT '0',
);
#
# Table structure for table 'tx_teammanager_domain_model_team'
#
CREATE TABLE tx_teammanager_domain_model_team (
club int(11) unsigned DEFAULT '0' NOT NULL,
team_name varchar(255) DEFAULT '' NOT NULL,
team_info text,
players int(11) unsigned DEFAULT '0' NOT NULL,
activities int(11) unsigned DEFAULT '0' NOT NULL,
level int(11) unsigned DEFAULT '0',
stuff int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
club int(11) unsigned DEFAULT '0' NOT NULL,
team int(11) unsigned DEFAULT '0' NOT NULL,
roles int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_teammanager_domain_model_activity'
#
CREATE TABLE tx_teammanager_domain_model_activity (
activity_title varchar(255) DEFAULT '' NOT NULL,
meettime datetime DEFAULT NULL,
activity_goal text,
address int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_teammanager_domain_model_address'
#
CREATE TABLE tx_teammanager_domain_model_address (
activity int(11) unsigned DEFAULT '0' NOT NULL,
street varchar(255) DEFAULT '' NOT NULL,
zip varchar(255) DEFAULT '' NOT NULL,
town varchar(255) DEFAULT '' NOT NULL,
p_o_box varchar(255) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tx_teammanager_domain_model_level'
#
CREATE TABLE tx_teammanager_domain_model_level (
title varchar(255) DEFAULT '' NOT NULL,
info varchar(255) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tx_teammanager_domain_model_role'
#
CREATE TABLE tx_teammanager_domain_model_role (
staff int(11) unsigned DEFAULT '0' NOT NULL,
role_title varchar(255) DEFAULT '' NOT NULL,
description text,
);
#
# Table structure for table 'tx_teammanager_domain_model_team'
#
CREATE TABLE tx_teammanager_domain_model_team (
club int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_teammanager_team_activity_mm'
#
CREATE TABLE tx_teammanager_team_activity_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)
);
#
# Table structure for table 'tx_teammanager_domain_model_role'
#
CREATE TABLE tx_teammanager_domain_model_role (
staff int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_teammanager_domain_model_address'
#
CREATE TABLE tx_teammanager_domain_model_address (
activity int(11) unsigned DEFAULT '0' NOT NULL,
);