cause there is no GUI for the administration of the database, i've set up it manally in the command line (terminal on osx).

CREATE TABLE events (
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(50),
description TEXT,
startTime TIME,
startDate DATE,
endTime TIME,
endDate DATE,
linkage TINYTEXT,
institution SMALLINT UNSIGNED,
prize DECIMAL(3,2),
active CHAR(1),
PRIMARY KEY(id));

CREATE TABLE institution (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
logo BLOB,
linkage TINYTEXT,
description TEXT,
telephone TINYTEXT,
cellphone TINYTEXT,
email TINYTEXT,
PRIMARY KEY(id));