-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdust_db_schema.txt
More file actions
63 lines (57 loc) · 9.21 KB
/
dust_db_schema.txt
File metadata and controls
63 lines (57 loc) · 9.21 KB
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
MariaDB [(none)]> use dust
Database changed
MariaDB [dust]> show tables;
+----------------+
| Tables_in_dust |
+----------------+
| airquality |
+----------------+
1 row in set (0.001 sec)
MariaDB [dust]> desc airquality;
+-------------+-----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------+------+-----+---------------------+-------+
| ts | timestamp | NO | | current_timestamp() | |
| temperature | float | YES | | NULL | |
| humidity | float | YES | | NULL | |
| u10 | float | YES | | NULL | |
| u25 | float | YES | | NULL | |
+-------------+-----------+------+-----+---------------------+-------+
5 rows in set (0.004 sec)
MariaDB [dust]> show create table airquality;
+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| airquality | CREATE TABLE `airquality` (
`ts` timestamp NOT NULL DEFAULT current_timestamp(),
`temperature` float DEFAULT NULL,
`humidity` float DEFAULT NULL,
`u10` float DEFAULT NULL,
`u25` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
MariaDB [dust]> show grants for 'grafana'@'localhost';
+----------------------------------------------------------------------------------------------------------------+
| Grants for grafana@localhost |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'grafana'@'localhost' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' |
| GRANT SELECT ON `dust`.* TO 'grafana'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------+
MariaDB [dust]> show grants for python@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for python@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'python'@'localhost' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' |
| GRANT SELECT, INSERT ON `dust`.* TO 'python'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)
MariaDB [dust]> select * from mysql.user;
+-----------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-------------+-----------------------+------------------+---------+--------------+--------------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | Delete_history_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | is_role | default_role | max_statement_time |
+-----------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-------------+-----------------------+------------------+---------+--------------+--------------------+
| localhost | root | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | unix_socket | | N | N | | 0.000000 |
| localhost | grafana | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | | N | N | | 0.000000 |
| localhost | python | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | | N | N | | 0.000000 |
+-----------+---------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+---------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-------------+-----------------------+------------------+---------+--------------+--------------------+
3 rows in set (0.002 sec)