From 1422e5893b7e8563431507a2058967082ec4f4cb Mon Sep 17 00:00:00 2001 From: diogo464 Date: Tue, 1 Oct 2024 15:55:43 +0100 Subject: init --- schema.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 schema.sql (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql new file mode 100644 index 0000000..0045372 --- /dev/null +++ b/schema.sql @@ -0,0 +1,18 @@ +CREATE TABLE IF NOT EXISTS location ( + timestamp REAL NOT NULL, + latitude REAL NOT NULL, + longitude REAL NOT NULL, + accuracy REAL NOT NULL, + heading REAL NOT NULL +); + +CREATE TABLE IF NOT EXISTS shape ( + id INTEGER NOT NULL, + kind VARCHAR NOT NULL +); + +CREATE TABLE IF NOT EXISTS shape_point ( + shape INTEGER NOT NULL, + latitude REAL NOT NULL, + longitude REAL NOT NULL +); -- cgit