20 lines
524 B
SQL
20 lines
524 B
SQL
// 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); |