blob: 4c4c4d4f795841a60061743e006a9657f8f2f37b (
plain)
1
2
3
4
5
6
7
8
9
|
CREATE SCHEMA `WSdb`;
CREATE TABLE `DAB1Pract1`.`tblMain` (
`ID` INT GENERATED ALWAYS AS (),
`temperature` DECIMAL(5,2) NULL,
`humidity` DECIMAL(5,2) NULL,
`pressure` DECIMAL(5,2) NULL,
`time` DATETIME NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) VISIBLE);
|