-- // Tour Tabelle

create table tour
(
	tourname varchar not null,
	dauer decimal,
	mapjson varchar,
	start varchar,
	ziel varchar,
	strecke decimal
);

create unique index tour_tourname_uindex
	on tour (tourname);

alter table tour add constraint tour_pk primary key (tourname);

-- // Log Table

create table log(tourname varchar constraint log_tour_tourname_fk references tour,id varchar,bemerkung varchar,datum date,strecke decimal,avg decimal,hightmeter decimal,pause decimal,gegangen decimal,dauer decimal, rating varchar);