blob: 050f51f83d1b2908204aae720642cc99b08b045f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
drop schema if exists `WSdb`;
create schema if not exists `WSdb`;
drop table if exists `WSdb`.`tblMain`;
create table if not exists `WSdb`.`tblMain` (
id int unsigned not null auto_increment,
temperature decimal(5,2) null,
humidity decimal(5,2) null,
pressure decimal(5,2) null,
time datetime default CURRENT_TIMESTAMP(),
primary key (id)
);
INSERT INTO `WSdb`.`tblMain` (`ID`) VALUES (0);
|