BestReads/init.sql at main · saraayy/BestReads · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
DELETE FROM classes;

INSERT INTO classes (title, value) VALUES ('Genre', 'fiktio');
INSERT INTO classes (title, value) VALUES ('Genre', 'elämäkerta');
INSERT INTO classes (title, value) VALUES ('Genre', 'tiedekirjallisuus');
INSERT INTO classes (title, value) VALUES ('Genre', 'fantasia');
INSERT INTO classes (title, value) VALUES ('Genre', 'scifi');
INSERT INTO classes (title, value) VALUES ('Genre', 'romantiikka');
INSERT INTO classes (title, value) VALUES ('Genre', 'rikos');
INSERT INTO classes (title, value) VALUES ('Genre', 'kauhu');


INSERT INTO classes (title, value) VALUES ('Tähdet', '1');
INSERT INTO classes (title, value) VALUES ('Tähdet', '2');
INSERT INTO classes (title, value) VALUES ('Tähdet', '3');
INSERT INTO classes (title, value) VALUES ('Tähdet', '4');
INSERT INTO classes (title, value) VALUES ('Tähdet', '5');