aboutsummaryrefslogtreecommitdiff
path: root/trireme/db/migrations
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2015-08-07 17:39:23 +0200
committerTrygve Laugstøl <trygvis@inamo.no>2015-08-07 17:39:23 +0200
commitd2caf82ad16f8d31db6afdd69383ba1c04e02c32 (patch)
treef50b6625b91cee915631a5841330d812e6321882 /trireme/db/migrations
parent981ba5c5f30549dbd233fab1e52bb774fd3eebe1 (diff)
downloadmqtt-cassandra-bridge-d2caf82ad16f8d31db6afdd69383ba1c04e02c32.tar.gz
mqtt-cassandra-bridge-d2caf82ad16f8d31db6afdd69383ba1c04e02c32.tar.bz2
mqtt-cassandra-bridge-d2caf82ad16f8d31db6afdd69383ba1c04e02c32.tar.xz
mqtt-cassandra-bridge-d2caf82ad16f8d31db6afdd69383ba1c04e02c32.zip
o More explicit bind functions, it is useful because Cassandra is touchy with its types.
o Saving the topic and message id in the raw record table. o Dropping the mosquittopp, it is not very useful.
Diffstat (limited to 'trireme/db/migrations')
-rw-r--r--trireme/db/migrations/2015-08-04_2_more_details_to_raw.cql8
1 files changed, 8 insertions, 0 deletions
diff --git a/trireme/db/migrations/2015-08-04_2_more_details_to_raw.cql b/trireme/db/migrations/2015-08-04_2_more_details_to_raw.cql
new file mode 100644
index 0000000..3076add
--- /dev/null
+++ b/trireme/db/migrations/2015-08-04_2_more_details_to_raw.cql
@@ -0,0 +1,8 @@
+ALTER TABLE raw_record
+ADD mid bigint;
+
+ALTER TABLE raw_record
+ADD topic TEXT;
+
+ALTER TABLE raw_record
+ADD qos int;