bS9kvTJQ

1#
2# @field    id
3# @field    name    A város neve
4#
5CREATE TABLE IF NOT EXISTS cities (
6    id INT(11) NOT NULL AUTO_INCREMENT,
7    name VARCHAR(255),
8    PRIMARY KEY (id)
9) ENGINE=INNODB;
10
11#
12# @field    id
13# @field    city_id             A város azonosítója
14# @field    type                A mért adat típusa
15# @field    result              A mért adat eredménye
16# @field    measurement_date    A mérés dátuma
17#
18CREATE TABLE IF NOT EXISTS weather (
19    id INT(11) NOT NULL AUTO_INCREMENT,
20    city_id INT(11),
21    type ENUM('temperature', 'wind', 'rainfall'),
22    result VARCHAR(255) NOT NULL,
23    measurement_date DATETIME NOT NULL,
24    PRIMARY KEY (id),
25    FOREIGN KEY (city_id) REFERENCES cities(id) ON DELETE CASCADE
26) ENGINE=INNODB;