init

1 files changed, 18 insertions, 0 deletions

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
+);