-
-
Notifications
You must be signed in to change notification settings - Fork 55
/
ext_tables.sql
201 lines (185 loc) · 6.53 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
#
# Table structure for table 'tx_sfeventmgt_domain_model_event'
#
CREATE TABLE tx_sfeventmgt_domain_model_event (
title varchar(255) DEFAULT '' NOT NULL,
teaser text,
description text,
program text,
custom_text text,
rowDescription text,
startdate int(11) DEFAULT '0' NOT NULL,
enddate int(11) DEFAULT '0' NOT NULL,
max_participants int(11) DEFAULT '0' NOT NULL,
max_registrations_per_user int(11) DEFAULT '1' NOT NULL,
price double(11,2) DEFAULT '0.00' NOT NULL,
currency varchar(255) DEFAULT '' NOT NULL,
enable_payment tinyint(4) unsigned DEFAULT '0' NOT NULL,
restrict_payment_methods tinyint(4) unsigned DEFAULT '0' NOT NULL,
selected_payment_methods text,
category int(11) unsigned DEFAULT '0' NOT NULL,
registration int(11) unsigned DEFAULT '0' NOT NULL,
registration_waitlist int(11) unsigned DEFAULT '0' NOT NULL,
registration_fields int(11) unsigned DEFAULT '0' NOT NULL,
price_options int(11) unsigned DEFAULT '0' NOT NULL,
image varchar(255) DEFAULT '' NOT NULL,
files int(11) DEFAULT '0' NOT NULL,
related int(11) DEFAULT '0' NOT NULL,
additional_image varchar(255) DEFAULT '' NOT NULL,
location int(11) unsigned DEFAULT '0' NOT NULL,
room varchar(255) DEFAULT '' NOT NULL,
enable_registration tinyint(4) unsigned DEFAULT '0' NOT NULL,
enable_waitlist tinyint(4) unsigned DEFAULT '0' NOT NULL,
enable_waitlist_moveup tinyint(4) unsigned DEFAULT '0' NOT NULL,
registration_startdate int(11) DEFAULT '0' NOT NULL,
registration_deadline int(11) DEFAULT '0' NOT NULL,
allow_registration_until_enddate tinyint(4) unsigned DEFAULT '0' NOT NULL,
link varchar(2048) DEFAULT '' NULL,
top_event tinyint(4) unsigned DEFAULT '0' NOT NULL,
organisator int(11) unsigned DEFAULT '0' NOT NULL,
speaker int(11) unsigned DEFAULT '0' NOT NULL,
notify_admin tinyint(4) unsigned DEFAULT '1' NOT NULL,
notify_organisator tinyint(4) unsigned DEFAULT '0' NOT NULL,
enable_cancel tinyint(4) unsigned DEFAULT '0' NOT NULL,
cancel_deadline int(11) DEFAULT '0' NOT NULL,
enable_autoconfirm tinyint(4) unsigned DEFAULT '0' NOT NULL,
unique_email_check tinyint(4) unsigned DEFAULT '0' NOT NULL,
meta_keywords text,
meta_description text,
alternative_title tinytext,
slug text
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_organisator'
#
CREATE TABLE tx_sfeventmgt_domain_model_organisator (
name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
email_signature text,
phone varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL,
image varchar(255) DEFAULT '' NOT NULL,
slug text
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_customnotificationlog'
#
CREATE TABLE tx_sfeventmgt_domain_model_customnotificationlog (
event int(11) unsigned DEFAULT '0' NOT NULL,
details text,
emails_sent int(11) DEFAULT '0' NOT NULL,
message text,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
KEY event (event)
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_location'
#
CREATE TABLE tx_sfeventmgt_domain_model_location (
title varchar(255) DEFAULT '' NOT NULL,
address varchar(255) DEFAULT '' NOT NULL,
zip varchar(32) DEFAULT '' NOT NULL,
city varchar(255) DEFAULT '' NOT NULL,
country varchar(255) DEFAULT '' NOT NULL,
description text,
link tinytext,
longitude decimal(9,6) DEFAULT '0.000000' NOT NULL,
latitude decimal(9,6) DEFAULT '0.000000' NOT NULL,
slug text
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_registration'
#
CREATE TABLE tx_sfeventmgt_domain_model_registration (
event int(11) unsigned DEFAULT '0' NOT NULL,
main_registration int(11) unsigned DEFAULT '0' NOT NULL,
language varchar(32) DEFAULT '' NOT NULL,
firstname varchar(255) DEFAULT '' NOT NULL,
lastname varchar(255) DEFAULT '' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
company varchar(255) DEFAULT '' NOT NULL,
address varchar(255) DEFAULT '' NOT NULL,
zip varchar(32) DEFAULT '' NOT NULL,
city varchar(255) DEFAULT '' NOT NULL,
country varchar(255) DEFAULT '' NOT NULL,
phone varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
ignore_notifications tinyint(4) unsigned DEFAULT '0' NOT NULL,
gender varchar(1) DEFAULT '' NOT NULL,
accepttc tinyint(1) unsigned DEFAULT '0' NOT NULL,
confirmed tinyint(1) unsigned DEFAULT '0' NOT NULL,
notes mediumtext,
date_of_birth int(11),
confirmation_until int(11) unsigned DEFAULT '0' NOT NULL,
registration_date int(11),
amount_of_registrations int(11) DEFAULT '1' NOT NULL,
recaptcha varchar(255) DEFAULT '' NOT NULL,
fe_user int(11) DEFAULT '0' NOT NULL,
paid tinyint(1) unsigned DEFAULT '0' NOT NULL,
paymentmethod varchar(255) DEFAULT '' NOT NULL,
payment_reference varchar(255) DEFAULT '' NOT NULL,
waitlist tinyint(1) unsigned DEFAULT '0' NOT NULL,
field_values int(11) unsigned DEFAULT '0' NOT NULL,
price double(11,2) DEFAULT '0.00' NOT NULL,
price_option int(11) unsigned DEFAULT '0' NOT NULL,
KEY event (event, waitlist)
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_priceoption'
#
CREATE TABLE tx_sfeventmgt_domain_model_priceoption (
title varchar(255) DEFAULT '' NOT NULL,
description text,
price double(11,2) DEFAULT '0.00' NOT NULL,
valid_until int(11) DEFAULT '0' NOT NULL,
event int(11) unsigned DEFAULT '0' NOT NULL,
KEY event (event)
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_speaker'
#
CREATE TABLE tx_sfeventmgt_domain_model_speaker (
name varchar(255) DEFAULT '' NOT NULL,
job_title varchar(255) DEFAULT '' NOT NULL,
description text,
image int(11) unsigned DEFAULT '0' NOT NULL,
slug text
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_registration_field'
#
CREATE TABLE tx_sfeventmgt_domain_model_registration_field (
title varchar(255) DEFAULT '' NOT NULL,
type varchar(255) DEFAULT '' NOT NULL,
required tinyint(4) unsigned DEFAULT '0' NOT NULL,
placeholder text,
default_value text,
settings text,
text text,
datepickermode tinyint(3) DEFAULT '0' NOT NULL,
feuser_value varchar(255) DEFAULT '' NOT NULL,
event int(11) unsigned DEFAULT '0' NOT NULL,
KEY event (event)
);
#
# Table structure for table 'tx_sfeventmgt_domain_model_registration_fieldvalue'
#
CREATE TABLE tx_sfeventmgt_domain_model_registration_fieldvalue (
value text,
value_type int(11) unsigned DEFAULT '0' NOT NULL,
field int(11) unsigned DEFAULT '0' NOT NULL,
registration int(11) unsigned DEFAULT '0' NOT NULL,
KEY registration (registration)
);
#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category (
slug text
);
#
# Table structure for table 'sys_file_reference'
#
CREATE TABLE sys_file_reference (
show_in_views tinyint(4) DEFAULT '0' NOT NULL
);