From 1422e5893b7e8563431507a2058967082ec4f4cb Mon Sep 17 00:00:00 2001
From: diogo464 <diogo464@protonmail.com>
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 

