v1

1 files changed, 0 insertions, 51 deletions

diff --git a/create-db.rb b/create-db.rb
deleted file mode 100755
index 2866b7b..0000000
--- a/create-db.rb
+++ /dev/null
@@ -1,51 +0,0 @@
-#!/usr/bin/env ruby
-
-require 'sqlite3'
-
-db = SQLite3::Database.new("weather.db")
-
-db.execute <<-SQL
-          create table rain(
-           id INTEGER PRIMARY KEY,
-           timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
-           device_type TEXT,
-           device_id TEXT,
-           battery INTEGER,
-           rssi INTEGER,
-           rain_rate FLOAT,
-           rain_total FLOAT
-         );
-        SQL
-db.execute <<-SQL
-          create table wind(
-           id INTEGER PRIMARY KEY,
-           timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
-           device_type TEXT,
-           device_id TEXT,
-           battery INTEGER,
-           rssi INTEGER,
-           chill FLOAT,
-           temperature FLOAT,
-           average_speed FLOAT,
-           direction INTEGER,
-           gust FLOAT
-         );
-        SQL
-db.execute <<-SQL
-          create table temp(
-           id INTEGER PRIMARY KEY,
-           timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
-           device_type TEXT,
-           device_id TEXT,
-           battery INTEGER,
-           rssi INTEGER,
-           humidity FLOAT,
-           humidity_status TEXT,
-           humidity_status_numeric INTEGER,
-           temperature FLOAT,
-           forecast TEXT,
-           forecast_numeric INTEGER
-         );
-        SQL
-
-db.close