1 files changed, 7 insertions, 0 deletions
diff --git a/tools/mmd/create b/tools/mmd/create
index ebabe66..d13f1c7 100644
--- a/tools/mmd/create
+++ b/tools/mmd/create
@@ -48,6 +48,13 @@ CREATE TABLE report (
     FOREIGN KEY (location_id) REFERENCES location (id)
 );
 
+DROP TABLE IF EXISTS ssps;
+CREATE TABLE ssps (
+    timestamp INTEGER PRIMARY KEY NOT NULL,
+    longitude REAL,
+    latitude REAL
+);
+
 --
 -- EOF
 --