-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathext_tables.sql
50 lines (48 loc) · 1.97 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
#
# Table structure for table 'tx_weather2_domain_model_currentweather'
#
CREATE TABLE tx_weather2_domain_model_currentweather
(
name varchar(255) DEFAULT '' NOT NULL,
measure_timestamp int(11) DEFAULT '0' NOT NULL,
temperature_c double(4,2) DEFAULT '0.0' NOT NULL,
pressure_hpa double(4,2) DEFAULT '0' NOT NULL,
humidity_percentage int(11) unsigned DEFAULT '0' NOT NULL,
min_temp_c double(4,2) DEFAULT '0.0' NOT NULL,
max_temp_c double(4,2) DEFAULT '0.0' NOT NULL,
wind_speed_m_p_s double(4,2) DEFAULT '0.0' NOT NULL,
wind_direction_deg int(11) DEFAULT '0' NOT NULL,
pop_percentage int(11) unsigned DEFAULT '0' NOT NULL,
rain_volume double (4,2) DEFAULT '0.0' NOT NULL,
snow_volume double(4,2) DEFAULT '0.0' NOT NULL,
clouds_percentage int(11) unsigned DEFAULT '0' NOT NULL,
serialized_array text DEFAULT '' NOT NULL,
icon varchar(30) DEFAULT '' NOT NULL,
condition_code int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_weather2_domain_model_weatheralert'
#
CREATE TABLE tx_weather2_domain_model_weatheralert
(
dwd_warn_cell int(11) NOT NULL,
level int(11) DEFAULT '0' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
instruction text DEFAULT '' NOT NULL,
start_date int(11) unsigned DEFAULT '0' NOT NULL,
end_date int(11) unsigned DEFAULT '0' NOT NULL,
comparison_hash varchar(32) DEFAULT '' NOT NULL,
preliminary_information tinyint(4) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_weather2_domain_model_dwdwarncell'
#
CREATE TABLE tx_weather2_domain_model_dwdwarncell
(
warn_cell_id varchar(30) DEFAULT '' NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
short_name varchar(30) DEFAULT '' NOT NULL,
sign varchar(10) DEFAULT '' NOT NULL
);