Zcvdfj1Q

1CREATE SCHEMA IF NOT EXISTS kdz17;
2DROP TABLE IF EXISTS kdz17.src_weather_facts;
3CREATE TABLE IF NOT EXISTS kdz17.src_weather_facts (
4      local_datetime varchar(25) NULL
5   ,  t_air_temperature numeric(3, 1) NULL
6   ,  p0_sea_lvl numeric(4, 1) NULL
7   ,  p_station_lvl numeric(4, 1) NULL
8   ,  u_humidity INT NULL
9   ,  dd_wind_direction varchar(100) NULL
10   ,  ff_wind_speed INT NULL
11   ,  ff10_max_gust_value INT NULL
12   ,  ww_present varchar(100) NULL
13   ,  ww_recent varchar(50) NULL
14   ,  c_total_clouds varchar(200) NULL
15   ,  vv_horizontal_visibility numeric(3, 1) NULL
16   ,  td_temperature_dewpoint numeric(3, 1) NULL
17   ,  loaded_ts TIMESTAMP NOT NULL DEFAULT NOW()
18);