3fBp3j0B

1CREATE DATABASE IF NOT EXISTS savukelaskuri;
2USE savukelaskuri;
3
4DROP TABLE IF EXISTS savuke;
5CREATE TABLE savuke (
6	id int NOT NULL AUTO_INCREMENT,
7	tuotemerkki varchar(256),
8	savukemaara int NOT NULL,
9	hinta DECIMAL(5,2) NOT NULL,
10	PRIMARY KEY (id)
11);
12
13INSERT INTO savuke (tuotemerkki, savukemaara, hinta) VALUES (
14	"LM Sininen", 20, 7.1
15);
16
17DROP TABLE IF EXISTS kulutus;
18CREATE TABLE kulutus (
19	id int NOT NULL AUTO_INCREMENT,
20	pvm datetime NOT NULL,
21	kulutus int NOT NULL,
22	PRIMARY KEY (id)
23);
24
25INSERT INTO kulutus (pvm, kulutus) VALUES 
26("2019-01-14 16:46:00", 9),
27("2019-01-15 21:18:00", 8);