#!/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