-
Notifications
You must be signed in to change notification settings - Fork 10
/
Copy pathext_tables.sql
152 lines (135 loc) · 5.84 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
#
# Table structure for table 'tx_jobapplications_domain_model_posting'
#
CREATE TABLE tx_jobapplications_domain_model_posting
(
title varchar(255) DEFAULT '' NOT NULL,
categories int(11) unsigned DEFAULT '0' NOT NULL,
date_posted date DEFAULT NULL,
career_level varchar(255) DEFAULT '' NOT NULL,
division varchar(255) DEFAULT '' NOT NULL,
employment_type varchar(255) DEFAULT '' NOT NULL,
terms_of_employment varchar(255) DEFAULT '' NOT NULL,
company_description text,
job_description text,
role_description text,
skill_requirements text,
benefits text,
base_salary varchar(255) DEFAULT '' NOT NULL,
valid_through date DEFAULT NULL,
required_documents text,
company_information text,
detail_view_image int(11) unsigned NOT NULL default '0',
list_view_image int(11) unsigned NOT NULL default '0',
locations int(11) unsigned DEFAULT '0' NOT NULL,
contact int(11) unsigned DEFAULT '0',
slug varchar(255) DEFAULT '' NOT NULL,
homeoffice int(1) DEFAULT '0' NOT NULL,
locationrequirements int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_jobapplications_domain_model_contact'
#
CREATE TABLE tx_jobapplications_domain_model_contact
(
first_name varchar(255) DEFAULT '' NOT NULL,
last_name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
phone varchar(255) DEFAULT '' NOT NULL,
division varchar(255) DEFAULT '' NOT NULL,
photo int(11) unsigned NOT NULL default '0',
be_user int(11) unsigned NOT NULL DEFAULT '0'
);
#
# Table structure for table 'tx_jobapplications_domain_model_location'
#
CREATE TABLE tx_jobapplications_domain_model_location
(
name varchar(255) DEFAULT '' NOT NULL,
address_street_and_number varchar(255) DEFAULT '' NOT NULL,
address_addition varchar(255) DEFAULT '' NOT NULL,
address_post_code varchar(255) DEFAULT '' NOT NULL,
address_city varchar(255) DEFAULT '' NOT NULL,
address_country varchar(255) DEFAULT '' NOT NULL,
latitude varchar(255) DEFAULT '' NOT NULL,
londitude varchar(255) DEFAULT '' NOT NULL,
categories int(11) unsigned DEFAULT '0' NOT NULL,
address_region varchar(255) DEFAULT '' NOT NULL
);
CREATE TABLE tx_jobapplications_postings_locations_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_jobapplications_domain_model_posting_homeoffice'
#
CREATE TABLE tx_jobapplications_domain_model_locationrequirement
(
type varchar(255) DEFAULT '' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL
);
CREATE TABLE tx_jobapplications_domain_model_locationrequirements_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_jobapplications_domain_model_application'
#
CREATE TABLE tx_jobapplications_domain_model_application
(
salutation varchar(10) DEFAULT '' NOT NULL,
first_name varchar(255) DEFAULT '' NOT NULL,
last_name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
phone varchar(255) DEFAULT '' NOT NULL,
address_street_and_number varchar(255) DEFAULT '' NOT NULL,
address_addition varchar(255) DEFAULT '' NOT NULL,
address_post_code int(11) DEFAULT '0' NOT NULL,
address_city varchar(255) DEFAULT '' NOT NULL,
address_country varchar(255) DEFAULT '' NOT NULL,
salary_expectation varchar(255) DEFAULT '' NOT NULL,
earliest_date_of_joining date DEFAULT NULL,
message text,
files int(11) unsigned DEFAULT '0' NOT NULL,
cv int(11) unsigned DEFAULT '0' NOT NULL,
cover_letter int(11) unsigned DEFAULT '0' NOT NULL,
testimonials int(11) unsigned DEFAULT '0' NOT NULL,
other_files int(11) unsigned DEFAULT '0' NOT NULL,
privacy_agreement smallint(5) unsigned DEFAULT '0' NOT NULL,
posting int(11) unsigned DEFAULT '0' NOT NULL,
archived smallint(5) unsigned DEFAULT '0' NOT NULL,
anonymized smallint(5) unsigned DEFAULT '0' NOT NULL,
status int(11) unsigned DEFAULT '1' NOT NULL
);
#
# Table structure for table 'tx_jobapplications_domain_model_status'
#
CREATE TABLE tx_jobapplications_domain_model_status
(
name varchar(255) DEFAULT '' NOT NULL,
is_end_status smallint(5) unsigned DEFAULT '0' NOT NULL,
is_new_status smallint(5) unsigned DEFAULT '0' NOT NULL,
followers int(11) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_jobapplications_domain_model_status_mm'
#
CREATE TABLE tx_jobapplications_domain_model_status_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)
);