aboutsummaryrefslogtreecommitdiff
path: root/trireme/db
diff options
context:
space:
mode:
Diffstat (limited to 'trireme/db')
-rw-r--r--trireme/db/migrations/2015-08-04_0_sm_by_day.cql10
-rw-r--r--trireme/db/migrations/2015-08-04_1_raw_record.cql9
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
+ )
+);