From 4c2030a4f5e490d9b1dd681bae3311daba8ff63b Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Thu, 3 Aug 2017 11:13:15 +0200
Subject: [PATCH] initial schema for data import from rtl_433 json

---
 Makefile   | 2 ++
 create.sql | 9 +++++++++
 2 files changed, 11 insertions(+)
 create mode 100644 Makefile
 create mode 100644 create.sql

diff --git a/Makefile b/Makefile
new file mode 100644
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
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)
+);
+
+	
-- 
2.20.1