-- priklad vyuziti referenci (psql6-sqlite.sql) -- http://www.sallyx.org/sally/psql/psql6.php -- DROP TABLE IF EXISTS zamestnanci; DROP TABLE IF EXISTS oddeleni; CREATE TABLE oddeleni ( nazev VARCHAR(20), telefon VARCHAR(20), prim_klic INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ); CREATE TABLE zamestnanci ( jmeno VARCHAR(20), prijmeni VARCHAR(20), plat INTEGER CHECK (plat >= 0), oddeleni_id INTEGER REFERENCES oddeleni(prim_klic), rodne_cislo CHAR(10) NOT NULL PRIMARY KEY ); INSERT INTO oddeleni(nazev, telefon) VALUES ('Sekretariat','2 123 123 12'); INSERT INTO oddeleni(nazev, telefon) VALUES ('Pravni oddeleni','2 123 123 11'); INSERT INTO oddeleni(nazev, telefon) VALUES ('Pravni oddeleni','2 123 123 13'); INSERT INTO zamestnanci VALUES ('Lenka', 'Pavova',10000,1,'8001010601'); INSERT INTO zamestnanci VALUES ('Jana', 'Pavova',10000,1,'8001010602'); INSERT INTO zamestnanci VALUES ('Jana', 'Mala', 12000,1,'8001010603'); INSERT INTO zamestnanci VALUES ('Lenka', 'Pavova',15000,2,'8001010604'); INSERT INTO zamestnanci VALUES ('Tom', 'Jerry', 15000,2,'8001010605'); INSERT INTO zamestnanci VALUES ('Martin', 'Luter', 12000,2,'8001010606'); INSERT INTO zamestnanci VALUES ('Leopold','King', 13000,2,'8001010607'); INSERT INTO zamestnanci VALUES ('Tomas', 'Mann', 22000,3,'8001010608'); INSERT INTO zamestnanci VALUES ('Vasek', 'Trn', 16000,3,'8001010609'); INSERT INTO zamestnanci VALUES ('Stary', 'Osel', 9000,3,'8001010610');