-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.sql
32 lines (28 loc) · 1.38 KB
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
/*
__________________________________________________________________________
| |
| MY WHEATHER STATION - DATABASE |
| |
| Author : M. JALES, P. GARREAU |
| Status : Under Development |
| Last Modification : 18/09/2022 |
| Project : EMBEDDED LINUX PROJECT |
| |
|__________________________________________________________________________|
*/
/* ----------------------------------------------------------------------------
INIT
---------------------------------------------------------------------------- */
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
`id` INT(10) unsigned PRIMARY KEY NOT NULL AUTO_INCREMENT,
`date_` DATETIME NOT NULL,
`temperature` DOUBLE(2,2) NOT NULL,
`humidity` DOUBLE(2,2) NOT NULL,
`pressure` DOUBLE(4,2) NOT NULL
);
-- LOCK TABLES `data` WRITE;
-- ALTER TABLE `data` DISABLE KEYS;
-- INSERT INTO `data` VALUES ;
-- ALTER TABLE `data` ENABLE KEYS;
-- UNLOCK TABLES;