diff options
| author | Loek Le Blansch <32883851+lonkaars@users.noreply.github.com> | 2022-10-30 13:01:37 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-10-30 13:01:37 +0100 |
| commit | 762a3b76d9b3351a93d8156598a79eaec4c0ef90 (patch) | |
| tree | e3814f1e180c28e52d3abf9cdb095c31213fd361 | |
| parent | 06eb7a6b4bf6169da2b68330adf9eeb64f081bbd (diff) | |
| parent | 5bc4d10fc02cc71828a4a3602520a00b1ca08b8e (diff) | |
Merge pull request #8 from UnavailableDev/qt-settings
Fix for db-init.sql
| -rw-r--r-- | scripts/db-init.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/scripts/db-init.sql b/scripts/db-init.sql index 2b0581c..050f51f 100644 --- a/scripts/db-init.sql +++ b/scripts/db-init.sql @@ -6,6 +6,7 @@ create table if not exists `WSdb`.`tblMain` ( temperature decimal(5,2) null, humidity decimal(5,2) null, pressure decimal(5,2) null, - time datetime null, + time datetime default CURRENT_TIMESTAMP(), primary key (id) ); +INSERT INTO `WSdb`.`tblMain` (`ID`) VALUES (0); |