SET FOREIGN_KEY_CHECKS=0; SET UNIQUE_CHECKS=0; SET NAMES LATIN2;

--
-- Host: localhost    Database: nf
-- ------------------------------------------------------


--
-- Table structure for table `grafik`
--


CREATE TABLE `grafik` (
  `projekt` varchar(64) default NULL,
  `pracownik1` varchar(128) default NULL,
  `czas1` varchar(16) default NULL,
  `pracownik2` varchar(128) default NULL,
  `czas2` varchar(16) default NULL,
  `pracownik3` varchar(128) default NULL,
  `czas3` varchar(16) default NULL,
  `kierownik` varchar(64) default NULL,
  `telefon` varchar(16) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin2;

--
-- Dumping data for table `grafik`
--

INSERT INTO `grafik` VALUES ('Strona internetowa','Jan Kowalski','9:00-12:00','Andrzej Wąsaty','10:00-14:00',NULL,NULL,'Miś Coralgol','1234'),('Baza danych','Jola Nowak','8:00-13:00','Michał Borowik','10:00-12:00','Wesoła Anna','11:30-15:00','Katarzyna Bocian','2345'),('Procedury ISO','Monika Pogodna','9:00-12:00','Zuzanna Nieśmiała','10:30-13:30',NULL,NULL,'Monika Pogodna','5674'),('Dokumentacja','Zenon Swobodny','10:00-12:00','Ola Zając','11:00-13:00','Marek Jurek','12:00-14:00','Miś Coralgol','1234'),('Prototyp maszyny','Andrzej Wąsaty','14:00-15:00','Wesoła Anna','8:00-11:30',NULL,NULL,'Zosia Samosia','7890');



CREATE TABLE `r` (
  a int,
  b int,
  c int
) ENGINE=InnoDB DEFAULT CHARSET=latin2;

insert into r values(1, 5, 3);
insert into r values(2, 4, 5);
insert into r values(8, 3, 5);
insert into r values(9, 3, 3);
insert into r values(1, 6, 5);
insert into r values(5, 4, 3);
insert into r values(2, 7, 5);


CREATE TABLE `s` (
  b int,
  d int,
  e int
) ENGINE=InnoDB DEFAULT CHARSET=latin2;

insert into s values(3, 2, 2);
insert into s values(4, 7, 4);
insert into s values(5, 7, 8);
insert into s values(6, 2, 3);
        
                

