CREATE TABLE tbl_sessies ( id_sessie INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, starttijd DATETIME, eindtijd DATETIME, distance FLOAT, max_speed FLOAT, average_speed FLOAT, id_rider INT(11) NOT NULL, inGebruik INT(11), CONSTRAINT tbl_sessies_tbl_rider_id_rider_fk FOREIGN KEY (id_rider) REFERENCES tbl_rider (id_rider) ); CREATE UNIQUE INDEX tbl_sessies_id_sessie_uindex ON tbl_sessies (id_sessie); CREATE INDEX tbl_sessies_tbl_rider_id_rider_fk ON tbl_sessies (id_rider); CREATE TABLE tbl_deelsessie ( id_deelsessie INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, time TIME DEFAULT '00:00:01', distance DOUBLE, speed DOUBLE, id_sessie INT(11), CONSTRAINT tbl_deelsessie_tbl_sessies_id_sessie_fk FOREIGN KEY (id_sessie) REFERENCES tbl_sessies (id_sessie) ); CREATE UNIQUE INDEX tbl_deelsessie_id_deelsessie_uindex ON tbl_deelsessie (id_deelsessie); CREATE INDEX tbl_deelsessie_tbl_sessies_id_sessie_fk ON tbl_deelsessie (id_sessie); CREATE TABLE tbl_rider ( id_rider INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, voornaam VARCHAR(45), naam VARCHAR(45), leeftijd VARCHAR(3), experience INT(1) ); CREATE UNIQUE INDEX tbl_rider_id_rider_uindex ON tbl_rider (id_rider);