--
-- TOC Entry ID 7 (OID 45985)
--
-- Name: lubi Type: TABLE Owner: ricanyov
--

CREATE TABLE "lubi" (
	"ochmelka" character varying(20),
	"pivo" character varying(20)
);

--
-- TOC Entry ID 8 (OID 45996)
--
-- Name: capuju Type: TABLE Owner: ricanyov
--

CREATE TABLE "capuju" (
	"krcma" character varying(20),
	"pivo" character varying(20)
);

--
-- TOC Entry ID 9 (OID 46023)
--
-- Name: vypil Type: TABLE Owner: ricanyov
--

CREATE TABLE "vypil" (
	"idn" integer,
	"pivo" character varying(20),
	"mnozstvo" integer
);

--
-- TOC Entry ID 10 (OID 46044)
--
-- Name: navstivil Type: TABLE Owner: ricanyov
--

CREATE TABLE "navstivil" (
	"idn" integer,
	"ochmelka" character varying(20),
	"krcma" character varying(20),
	"den" date,
	"cas_od" integer,
	"cas_do" integer
);

--
-- Data for TOC Entry ID 18 (OID 45985)
--
-- Name: lubi Type: TABLE DATA Owner: ricanyov
--


INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Fero Mrkvicka','Samson');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Jozo Kapusta','Topvar');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Jozo Kapusta','Kelt');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Janko Hrasko','Saris');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Janko Hrasko','Samson');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Juro Kalerab','Topvar');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Peter Karfiol','Topvar');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Peter Karfiol','Kelt');
INSERT INTO "lubi" ("ochmelka","pivo") VALUES ('Dano Mrkva','Saris');
--
-- Data for TOC Entry ID 19 (OID 45996)
--
-- Name: capuju Type: TABLE DATA Owner: ricanyov
--


INSERT INTO "capuju" ("krcma","pivo") VALUES ('U troch volov','Kelt');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('U troch volov','Staropramen');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('U troch volov','Saris');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('U troch volov','Topvar');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('U Eda','Topvar');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('U Eda','Samson');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('Kockac','Samson');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('Kockac','Topvar');
INSERT INTO "capuju" ("krcma","pivo") VALUES ('Kockac','Kelt');
--
-- Data for TOC Entry ID 20 (OID 46023)
--
-- Name: vypil Type: TABLE DATA Owner: ricanyov
--


INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (10,'Topvar',1);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (20,'Topvar',2);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (30,'Kelt',1);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (30,'Staropramen',2);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (40,'Samson',4);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (50,'Topvar',2);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (60,'Topvar',5);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (70,'Topvar',4);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (70,'Saris',2);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (80,'Kelt',3);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (90,'Kelt',4);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (100,'Topvar',5);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (110,'Samson',3);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (120,'Kelt',3);
INSERT INTO "vypil" ("idn","pivo","mnozstvo") VALUES (130,'Topvar',1);
--
-- Data for TOC Entry ID 21 (OID 46044)
--
-- Name: navstivil Type: TABLE DATA Owner: ricanyov
--


INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (10,'Dano Mrkva','Kockac','2002-12-03',10,15);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (20,'Juro Kalerab','U troch volov','2002-12-03',10,11);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (30,'Fero Mrkvicka','U troch volov','2002-12-02',11,17);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (40,'Peter Karfiol','Kockac','2002-12-04',17,18);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (50,'Peter Karfiol','U Eda','2002-12-04',11,15);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (60,'Jozo Kapusta','U troch volov','2002-12-02',16,21);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (70,'Peter Karfiol','Kockac','2002-12-03',17,18);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (80,'Janko Hrasko','U troch volov','2002-12-02',23,24);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (90,'Jozo Kapusta','Kockac','2002-12-02',20,21);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (100,'Peter Karfiol','U troch volov','2002-12-02',15,18);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (110,'Janko Hrasko','U Eda','2002-12-04',14,16);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (120,'Jozo Kapusta','Kockac','2002-12-02',11,12);
INSERT INTO "navstivil" ("idn","ochmelka","krcma","den","cas_od","cas_do") VALUES (130,'Dano Mrkva','U Eda','2002-12-02',11,24);