CREATE TABLE tempMeasures (
		measureid int not null CHECK measureid>=0,
		sensorid varchar(10) not null,
		locationid varchar(6) not null,
		temperature varchar(5) not null,
		primary key (measureid));