CREATE TABLE Contact (
	IdContact int NOT NULL,
	Name varchar(100) NOT NULL,
    Surname varchar(200)NOT NULL,
    PhoneNo int NOT NULL,
    Email varchar (200),
    PRIMARY KEY (IdContact)
);

CREATE TABLE Meeting(
	IdMeeting int NOT NULL,
    TimeMeeting time NOT NULL,
    DateMeeting date NOT NULL,
    IdContact int NOT NULL,
    IdPlace int NOT NULL,
    PRIMARY KEY (IdMeeting),
    FOREIGN KEY (IdContact) REFERENCES Contact(IdContact),
    FOREIGN KEY (IdPlace) REFERENCES Place(IdPlace)
);
DROP TABLE Meeting;

ALTER TABLE Meeting
MODIFY IdMeeting int NOT NULL auto_increment;


CREATE TABLE Place(
	IdPlace int NOT NULL,
    Name varchar(100),
    Adress varchar(100),
    PRIMARY KEY (IdPlace)
);

INSERT INTO Place(IdPlace,Name,Adress)
VALUES(1,"Kawiarnia u Jakuba", "Zlota 55");
INSERT INTO Place(IdPlace,Name,Adress)
VALUES(2,"Kawiarnia u Kasi", "Zlota 15");
INSERT INTO Place(IdPlace,Name,Adress)
VALUES(3,"Kawiarnia u Dominika", "Zlota 35");
INSERT INTO Place(IdPlace,Name,Adress)
VALUES(4,"EdRed", "Zlota 52");

INSERT INTO Contact (IdContact, Name, Surname, PhoneNo, Email)
VALUES(1,"Jakub","Gostkowski",123123123,"gostkowskijakub@xo.pl");

INSERT INTO Contact (IdContact, Name, Surname, PhoneNo, Email)
VALUES(2,"Dominik","Ciborowski",75412541,"Dominooo@xo.pl");

INSERT INTO Contact (IdContact, Name, Surname, PhoneNo, Email)
VALUES(3,"Kasia","Mucha",987546,"Kasiaaaa@xo.pl");

select * from Contact;
select * from place;

INSERT INTO Meeting(TimeMeeting,DateMeeting,IdContact,IdPlace)
VALUES('10:00:12','2017-06-28',1,1);
INSERT INTO Meeting(TimeMeeting,DateMeeting,IdContact,IdPlace)
VALUES('10:00:12','2017-06-28',2,3);
INSERT INTO Meeting(TimeMeeting,DateMeeting,IdContact,IdPlace)
VALUES('10:00:12','2017-06-28',3,3);

SELECT * FROM Meeting;

SELECT * FROM Meeting
INNER JOIN Contact ON Meeting.IdMeeting=contact.IdContact;

SELECT * FROM Meeting
LEFT JOIN Place ON Meeting.IdMeeting=place.IdPlace
WHERE IdContact = 1;