blob: 2b0581ccf9cd94c050498e62bad61ef9d1957133 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
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 null,
primary key (id)
);
|