Hopefully this is the last version of our database structure:

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,
location TEXT,
category SMALLINT UNSIGNED,
prize DECIMAL(3,2),
active CHAR(1),
PRIMARY KEY(id));

CREATE TABLE institutions (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
logo VARCHAR(50),
linkage TINYTEXT,
description TEXT,
telephone TINYTEXT,
cellphone TINYTEXT,
street TINYTEXT,
zip INT(10),
city VARCHAR(50),
email TINYTEXT,
PRIMARY KEY(id));

CREATE TABLE categories (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50),
icon VARCHAR(50),
description TEXT,
PRIMARY KEY(id));

I at the moment asked Markus from the Information Service to install a GUI (phpMyAdmin) for the database administration. He sees no problem. :-)