From 981ba5c5f30549dbd233fab1e52bb774fd3eebe1 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Tue, 4 Aug 2015 23:24:46 +0200
Subject: o Adding Trireme setup to support migrating the Cassandra schema.

---
 trireme/db/migrations/2015-08-04_0_sm_by_day.cql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 trireme/db/migrations/2015-08-04_0_sm_by_day.cql

(limited to 'trireme/db/migrations/2015-08-04_0_sm_by_day.cql')

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
+    )
+);
-- 
cgit v1.2.3