2 files changed, 19 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
+    )
+);
diff --git a/trireme/db/migrations/2015-08-04_1_raw_record.cql b/trireme/db/migrations/2015-08-04_1_raw_record.cql
new file mode 100644
index 0000000..85c4ecb
--- /dev/null
+++ b/trireme/db/migrations/2015-08-04_1_raw_record.cql
@@ -0,0 +1,9 @@
+CREATE TABLE raw_record (
+    day text,
+    timestamp timestamp,
+    records list<frozen<tuple<text, text>>>,
+    PRIMARY KEY (
+        (day),
+        timestamp
+    )
+);