diff options
Diffstat (limited to 'scripts/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); |