drop database iot_db;
create database iot_db;

use iot_db;
drop table users;
create table users(
 username varchar(255) primary key,
 passwd varchar(255) not null,
 email varchar(255) unique);
 
drop table devices; 
 create table devices(
 clientid varchar(255) primary key, 
 devicename varchar(255) default null, 
 ownername varchar(255) default null,
 alert bool
 );
  
drop table history_log;
create table history_log(
logid int primary key auto_increment,
clientid varchar(255) ,
logtimestamp timestamp unique, 
info varchar(255),
lat double, 
ing double, 
devicevalue int, 
alert int,
FOREIGN KEY (clientid) references devices(clientid)
 );