train-tracker/init.sql

9 lines
190 B
MySQL
Raw Permalink Normal View History

2024-09-28 13:00:29 +02:00
CREATE TABLE IF NOT EXISTS trips (
id VARCHAR(36) PRIMARY KEY,
latitude DOUBLE,
longitude DOUBLE,
timestamp DATETIME,
train_name VARCHAR(50),
fahrt_nr VARCHAR(20)
);