CREATE TABLE media
(
	studentid		INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
	firstname		VARCHAR(20) NOT NULL,
	lastname		VARCHAR(30) NOT NULL,
	birthdate		DATE NOT NULL,	
	phone			VARCHAR(16),
	email			VARCHAR(50)
);


INSERT INTO media (firstname, lastname, birthdate, phone, email)
VALUES
	('Kalle','Anka','1955-10-17','+358 50 123 4321', 'kalle.anka@student.vaasa.fi'),
	('Pelle','Bus','1992-08-21','+358 44 123 7234', 'pelle.bus@student.vaasa.fi'),
	('Casimir','Medie','2000-10-10','+358 44 123 1234', 'casimir.medie@student.vaasa.fi'),	
	('Nils','Nilsson','1982-08-16','+358 50 123 3004', 'nils.nilsson@student.vaasa.fi');