1 files changed, 10 insertions, 0 deletions
diff --git a/trireme/db/migrations/2015-08-04_0_sm_by_day.cql b/trireme/db/migrations/2015-08-04_0_sm_by_day.cql
new file mode 100644
index 0000000..776cd23
--- /dev/null
+++ b/trireme/db/migrations/2015-08-04_0_sm_by_day.cql
@@ -0,0 +1,10 @@
+CREATE TABLE sm_by_day (
+    device text,
+    day text,
+    timestamp timestamp,
+    sensors list<frozen<tuple<int, int>>>,
+    PRIMARY KEY (
+        (device, day), 
+        timestamp
+    )
+);