aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/20231230_create.sql
diff options
context:
space:
mode:
authorMatthias P. Braendli <matthias.braendli@mpb.li>2024-01-07 22:22:51 +0100
committerMatthias P. Braendli <matthias.braendli@mpb.li>2024-01-07 22:22:51 +0100
commit241622ff7fd612eb521dec8829153851406c5884 (patch)
tree3d7b17caa99c7b08f01d94fad9cbdca249ff2612 /migrations/20231230_create.sql
parentb40299538a73d25d096d8f58f1468cd7f647a3f9 (diff)
downloadcats-radio-node-241622ff7fd612eb521dec8829153851406c5884.tar.gz
cats-radio-node-241622ff7fd612eb521dec8829153851406c5884.tar.bz2
cats-radio-node-241622ff7fd612eb521dec8829153851406c5884.zip
Store incoming frames in DB and show most recent 10 in dashboard
Diffstat (limited to 'migrations/20231230_create.sql')
-rw-r--r--migrations/20231230_create.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/migrations/20231230_create.sql b/migrations/20231230_create.sql
index 23d7282..261c18d 100644
--- a/migrations/20231230_create.sql
+++ b/migrations/20231230_create.sql
@@ -1,6 +1,6 @@
CREATE TABLE IF NOT EXISTS frames_received
(
id INTEGER NOT NULL PRIMARY KEY,
- recevied_at INTEGER,
- content VARCHAR
+ received_at INTEGER,
+ content BLOB
);