-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathext_tables.sql
205 lines (182 loc) · 6.02 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
#
# Table structure for table 'tx_jobfair_domain_model_job'
#
CREATE TABLE tx_jobfair_domain_model_job (
job_title varchar(255) DEFAULT '' NOT NULL,
slug varchar(2048),
job_image varchar(255) DEFAULT '' NOT NULL,
employer varchar(255) DEFAULT '' NOT NULL,
employer_description text NOT NULL,
location varchar(255) DEFAULT '' NOT NULL,
short_job_description text NOT NULL,
job_description text NOT NULL,
experience varchar(255) DEFAULT '' NOT NULL,
job_requirements text NOT NULL,
job_benefits text NOT NULL,
apply_information text NOT NULL,
salary varchar(255) DEFAULT '' NOT NULL,
job_type int(11) DEFAULT '0' NOT NULL,
contract_type int(11) DEFAULT '0' NOT NULL,
region int(11) unsigned DEFAULT '0' NOT NULL,
contact int(11) unsigned DEFAULT '0',
sector int(11) unsigned DEFAULT '0' NOT NULL,
category int(11) unsigned DEFAULT '0' NOT NULL,
discipline int(11) unsigned DEFAULT '0' NOT NULL,
education int(11) unsigned DEFAULT '0' NOT NULL,
feuser int(11) unsigned DEFAULT '0' NOT NULL,
application int(11) unsigned DEFAULT '0' NOT NULL,
internal_notes text,
);
#
# Table structure for table 'tx_jobfair_domain_model_contact'
#
CREATE TABLE tx_jobfair_domain_model_contact (
name varchar(255) DEFAULT '' NOT NULL,
address text NOT NULL,
phone varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
www varchar(255) DEFAULT '' NOT NULL,
contact_image varchar(255) DEFAULT '' NOT NULL,
name_cc varchar(255) DEFAULT '' NOT NULL,
email_cc varchar(255) DEFAULT '' NOT NULL,
name_bcc varchar(255) DEFAULT '' NOT NULL,
email_bcc varchar(255) DEFAULT '' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_jobfair_domain_model_region'
#
CREATE TABLE tx_jobfair_domain_model_region (
name varchar(255) DEFAULT '' NOT NULL,
jobs int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_jobfair_domain_model_sector'
#
CREATE TABLE tx_jobfair_domain_model_sector (
name varchar(255) DEFAULT '' NOT NULL,
jobs int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_jobfair_domain_model_category'
#
CREATE TABLE tx_jobfair_domain_model_category (
name varchar(255) DEFAULT '' NOT NULL,
jobs int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_jobfair_domain_model_discipline'
#
CREATE TABLE tx_jobfair_domain_model_discipline (
name varchar(255) DEFAULT '' NOT NULL,
jobs int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_jobfair_domain_model_education'
#
CREATE TABLE tx_jobfair_domain_model_education (
name varchar(255) DEFAULT '' NOT NULL,
jobs int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_jobfair_domain_model_application'
#
CREATE TABLE tx_jobfair_domain_model_application (
title varchar(255) DEFAULT '' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
message text NOT NULL,
attachment varchar(255) DEFAULT '' NOT NULL,
jobs int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
jobs int(11) unsigned DEFAULT '0' NOT NULL,
tx_extbase_type varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_jobfair_job_region_mm'
#
CREATE TABLE tx_jobfair_job_region_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jobfair_job_sector_mm'
#
CREATE TABLE tx_jobfair_job_sector_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jobfair_job_category_mm'
#
CREATE TABLE tx_jobfair_job_category_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jobfair_job_discipline_mm'
#
CREATE TABLE tx_jobfair_job_discipline_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jobfair_job_education_mm'
#
CREATE TABLE tx_jobfair_job_education_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jobfair_job_user_mm'
#
CREATE TABLE tx_jobfair_job_user_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tx_jobfair_job_application_mm'
#
CREATE TABLE tx_jobfair_job_application_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,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);