initial schema for data import from rtl_433 json

diff --git a/Makefile b/Makefile
new file mode 100644 (file)
index 0000000..f5eeea4
--- /dev/null
+++ b/Makefile
@@ -0,0 +1,2 @@
+create:
+       psql rot13 < create.sql

diff --git a/create.sql b/create.sql
new file mode 100644 (file)
index 0000000..3f34253
--- /dev/null
+++ b/create.sql
@@ -0,0 +1,9 @@
+create table rtl433 (
+       time timestamp without time zone,
+       model text,
+       id integer not null,
+       json jsonb,
+       primary key(time,id)
+);
+
+