CREATE table temperature (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Fahrenheit  decimal(6,2) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table humidity (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Humidity integer(4) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table pressure (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Pressure decimal(8,4) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table solar (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Solar integer(6) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table lightning (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Lightning integer(12) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table rain (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Rain integer(12) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table wind (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Wind integer(12) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

CREATE table activity (
  dtKey int(11) NOT NULL auto_increment,
  time timestamp NOT NULL,
  Location varchar(17) NOT NULL,
  Activity integer(12) NOT NULL,
  PRIMARY KEY (dtKey),
  KEY serial_key (Location),
  KEY time_key (time)
);

