aboutsummaryrefslogtreecommitdiff
path: root/createDB.sql
diff options
context:
space:
mode:
Diffstat (limited to 'createDB.sql')
-rw-r--r--createDB.sql9
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);