HS8b8PR3

1DROP DATABASE IF EXISTS ROP;
2
3CREATE DATABASE ROP CHARACTER SET=UTF8 COLLATE utf8_slovak_ci;
4USE ROP;
5
6CREATE TABLE ucitel
7(
8	IDucitel int NOT NULL AUTO_INCREMENT PRIMARY KEY,
9
10	Meno varchar(15) NOT NULL,
11	Priezvisko varchar(15) NOT NULL,
12
13	UcitelCip varchar(10) NOT NULL
14
15)engine = innodb;
16
17CREATE TABLE kluc
18(
19	IDkluc int NOT NULL AUTO_INCREMENT PRIMARY KEY,
20
21	CisloUcebne varchar(4) NOT NULL,
22	Obsadenost boolean,
23
24	KlucCip varchar(10) NOT NULL,
25
26)engine = innodb;
27
28
29
30INSERT INTO ucitel VALUES
31(0, "Jozef", "Gmiter", "F589D283"),
32(0, "Michal", "Copko", "BD50CF83");
33
34INSERT INTO kluc VALUES
35(0, "28a", 0, "01CACF83"),
36(0, "29", 0, "739BE073");