INSERT INTO osoba VALUES (8,'08-APR-80','Oto','Valek',8004080216,NULL);
UPDATE osoba SET rodne_c=8004080217;

UPDATE ubytovani SET obyvan_mistnost_cislo=202 WHERE ubytovan_osoba_cislo=4;
UPDATE ubytovani SET obyvan_mistnost_cislo=302 WHERE ubytovan_osoba_cislo=6;
UPDATE pokoj SET kapacita=10 WHERE mistnost_cislo=201;
UPDATE pokoj SET kapacita=2 WHERE mistnost_cislo=302;

UPDATE procedura SET doba='29-MAY-03' WHERE cislo=12;
UPDATE procedura SET doba='29-MAY-03' WHERE cislo=1;
UPDATE konani SET realizuje_mistnost_cislo=103 WHERE konana_cislo=12;
UPDATE konani SET realizuje_mistnost_cislo=103 WHERE konana_cislo=1;

INSERT INTO provedeni_p VALUES (13,5);
INSERT INTO provedeni_p VALUES (12,7);

INSERT INTO konani VALUES (5,101);
INSERT INTO konani VALUES (8,102);

UPDATE ubytovani SET obyvan_mistnost_cislo=301 WHERE ubytovan_osoba_cislo=3;
UPDATE ubytovani SET obyvan_mistnost_cislo=301 WHERE ubytovan_osoba_cislo=1;
UPDATE host SET pohlavi=1 WHERE osoba_cislo=6;
UPDATE host SET pohlavi=0 WHERE osoba_cislo=4;
UPDATE host SET pohlavi=1 WHERE osoba_cislo=1;
