-
Notifications
You must be signed in to change notification settings - Fork 3
/
ext_tables.sql
executable file
·286 lines (272 loc) · 11.4 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
#
# Table structure for table 'tx_realty_objects'
#
CREATE TABLE tx_realty_objects (
uid int(11) unsigned 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,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
object_number varchar(255) DEFAULT '' NOT NULL,
object_type int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
emphasized tinyint(3) DEFAULT '0' NOT NULL,
street varchar(255) DEFAULT '' NOT NULL,
zip varchar(16) DEFAULT '' NOT NULL,
city int(11) DEFAULT '0' NOT NULL,
district int(11) DEFAULT '0' NOT NULL,
country int(11) DEFAULT '0' NOT NULL,
show_address tinyint(1) DEFAULT '0' NOT NULL,
has_coordinates tinyint(1) DEFAULT '0' NOT NULL,
coordinates_problem tinyint(1) DEFAULT '0' NOT NULL,
longitude decimal(9,6) DEFAULT '0.000000' NOT NULL,
latitude decimal(9,6) DEFAULT '0.000000' NOT NULL,
distance_to_the_sea int(11) unsigned DEFAULT '0' NOT NULL,
sea_view tinyint(1) DEFAULT '0' NOT NULL,
number_of_rooms decimal(5,2) DEFAULT '0.00' NOT NULL,
living_area varchar(64) DEFAULT '' NOT NULL,
total_area varchar(64) DEFAULT '' NOT NULL,
estate_size varchar(64) DEFAULT '' NOT NULL,
rent_excluding_bills varchar(64) DEFAULT '' NOT NULL,
rent_with_heating_costs decimal(10,2) DEFAULT '0.00' NOT NULL,
extra_charges varchar(64) DEFAULT '' NOT NULL,
heating_included tinyint(3) DEFAULT '0' NOT NULL,
deposit varchar(64) DEFAULT '' NOT NULL,
provision varchar(64) DEFAULT '' NOT NULL,
usable_from varchar(64) DEFAULT '' NOT NULL,
buying_price varchar(64) DEFAULT '' NOT NULL,
hoa_fee varchar(64) DEFAULT '' NOT NULL,
year_rent varchar(64) DEFAULT '' NOT NULL,
rental_income_target decimal(10,2) DEFAULT '0.00' NOT NULL,
status tinyint(3) DEFAULT '0' NOT NULL,
apartment_type int(11) DEFAULT '0' NOT NULL,
house_type int(11) DEFAULT '0' NOT NULL,
floor int(11) DEFAULT '0' NOT NULL,
floors int(11) DEFAULT '0' NOT NULL,
bedrooms decimal(5,2) DEFAULT '0.00' NOT NULL,
bathrooms decimal(5,2) DEFAULT '0.00' NOT NULL,
heating_type varchar(64) DEFAULT '' NOT NULL,
has_air_conditioning tinyint(3) DEFAULT '0' NOT NULL,
garage_type int(11) DEFAULT '0' NOT NULL,
garage_rent varchar(64) DEFAULT '' NOT NULL,
garage_price varchar(64) DEFAULT '' NOT NULL,
pets int(11) DEFAULT '0' NOT NULL,
construction_year int(11) DEFAULT '0' NOT NULL,
old_or_new_building tinyint(3) DEFAULT '0' NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
balcony tinyint(3) DEFAULT '0' NOT NULL,
garden tinyint(3) DEFAULT '0' NOT NULL,
elevator tinyint(3) DEFAULT '0' NOT NULL,
barrier_free tinyint(1) unsigned DEFAULT '0' NOT NULL,
wheelchair_accessible tinyint(1) unsigned DEFAULT '0' NOT NULL,
ramp tinyint(1) unsigned DEFAULT '0' NOT NULL,
lifting_platform tinyint(1) unsigned DEFAULT '0' NOT NULL,
suitable_for_the_elderly tinyint(1) unsigned DEFAULT '0' NOT NULL,
assisted_living tinyint(1) unsigned DEFAULT '0' NOT NULL,
fitted_kitchen tinyint(3) DEFAULT '0' NOT NULL,
has_pool tinyint(3) DEFAULT '0' NOT NULL,
has_community_pool tinyint(3) DEFAULT '0' NOT NULL,
teaser varchar(1023) DEFAULT '' NOT NULL,
description varchar(2047) DEFAULT '' NOT NULL,
equipment varchar(4095) DEFAULT '' NOT NULL,
layout varchar(255) DEFAULT '' NOT NULL,
location varchar(4095) DEFAULT '' NOT NULL,
misc varchar(1023) DEFAULT '' NOT NULL,
details_page tinytext,
attachments int(11) unsigned DEFAULT '0' NOT NULL,
employer varchar(255) DEFAULT '' NOT NULL,
openimmo_anid varchar(63) DEFAULT '' NOT NULL,
openimmo_obid varchar(63) DEFAULT '' NOT NULL,
utilization varchar(1023) DEFAULT '' NOT NULL,
contact_data_source tinyint(1) DEFAULT '0' NOT NULL,
contact_person varchar(64) DEFAULT '' NOT NULL,
contact_person_first_name varchar(64) DEFAULT '' NOT NULL,
contact_person_salutation varchar(64) DEFAULT '' NOT NULL,
contact_email varchar(255) DEFAULT '' NOT NULL,
phone_switchboard varchar(64) DEFAULT '' NOT NULL,
phone_direct_extension varchar(64) DEFAULT '' NOT NULL,
owner int(11) unsigned DEFAULT '0' NOT NULL,
language varchar(32) DEFAULT '' NOT NULL,
currency varchar(32) DEFAULT '' NOT NULL,
advertised_date int(11) DEFAULT '0' NOT NULL,
rent_per_square_meter decimal(8,2) DEFAULT '0.00' NOT NULL,
shop_area decimal(8,2) DEFAULT '0.00' NOT NULL,
sales_area decimal(8,2) DEFAULT '0.00' NOT NULL,
total_usable_area decimal(8,2) DEFAULT '0.00' NOT NULL,
storage_area decimal(8,2) DEFAULT '0.00' NOT NULL,
office_space decimal(8,2) DEFAULT '0.00' NOT NULL,
other_area decimal(8,2) DEFAULT '0.00' NOT NULL,
window_bank decimal(8,2) DEFAULT '0.00' NOT NULL,
site_occupancy_index decimal(5,2) DEFAULT '0.00' NOT NULL,
floor_space_index decimal(5,2) DEFAULT '0.00' NOT NULL,
parking_spaces int(11) unsigned DEFAULT '0' NOT NULL,
furnishing_category tinyint(3) DEFAULT '0' NOT NULL,
flooring varchar(255) DEFAULT '' NOT NULL,
energy_certificate_type int(1) unsigned DEFAULT '0' NOT NULL,
energy_certificate_valid_until varchar(32) DEFAULT '' NOT NULL,
energy_consumption_characteristic varchar(255) DEFAULT '' NOT NULL,
with_hot_water int(1) unsigned DEFAULT '0' NOT NULL,
ultimate_energy_demand varchar(32) DEFAULT '' NOT NULL,
primary_energy_carrier varchar(32) DEFAULT '' NOT NULL,
electric_power_consumption_characteristic varchar(255) DEFAULT '' NOT NULL,
heat_energy_consumption_characteristic varchar(255) DEFAULT '' NOT NULL,
value_category varchar(32) DEFAULT '' NOT NULL,
year_of_construction varchar(32) DEFAULT '' NOT NULL,
energy_certificate_issue_date int(11) DEFAULT '0' NOT NULL,
energy_certificate_year int(1) unsigned DEFAULT '0' NOT NULL,
building_type int(1) unsigned DEFAULT '0' NOT NULL,
energy_certificate_text varchar(1024) DEFAULT '' NOT NULL,
heat_energy_requirement_value varchar(32) DEFAULT '' NOT NULL,
heat_energy_requirement_class varchar(32) DEFAULT '' NOT NULL,
total_energy_efficiency_value varchar(32) DEFAULT '' NOT NULL,
total_energy_efficiency_class varchar(32) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record),
KEY owner (owner),
KEY city (city),
KEY district (district)
);
#
# Table structure for table 'tx_realty_apartment_types'
#
CREATE TABLE tx_realty_apartment_types (
uid int(11) unsigned 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'tx_realty_house_types'
#
CREATE TABLE tx_realty_house_types (
uid int(11) unsigned 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'tx_realty_car_places'
#
CREATE TABLE tx_realty_car_places (
uid int(11) unsigned 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'tx_realty_pets'
#
CREATE TABLE tx_realty_pets (
uid int(11) unsigned 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'tx_realty_cities'
#
CREATE TABLE tx_realty_cities (
uid int(11) unsigned 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
districts int(11) DEFAULT '0' NOT NULL,
save_folder int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record)
);
#
# Table structure for table 'tx_realty_districts'
#
CREATE TABLE tx_realty_districts (
uid int(11) unsigned 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob,
deleted tinyint(4) DEFAULT '0' NOT NULL,
is_dummy_record tinyint(1) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
city int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY dummy (is_dummy_record),
KEY city (city)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_realty_openimmo_anid varchar(64) DEFAULT '' NOT NULL,
tx_realty_maximum_objects tinyint(4) DEFAULT '0' NOT NULL
);