diff options
Diffstat (limited to 'createDB.sql')
-rw-r--r-- | createDB.sql | 9 |
1 files changed, 0 insertions, 9 deletions
diff --git a/createDB.sql b/createDB.sql deleted file mode 100644 index 4c4c4d4..0000000 --- a/createDB.sql +++ /dev/null @@ -1,9 +0,0 @@ -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); |