5d
来自Jack's Lab
(版本间的差异)
(→Update net type) |
(→Update net type) |
||
第12行: | 第12行: | ||
Enter ".help" for usage hints. | Enter ".help" for usage hints. | ||
sqlite> select * from t_base_define; | sqlite> select * from t_base_define; | ||
− | 1 | + | sqlite> .head on |
− | 2 | + | sqlite> .mode column |
− | 3 | + | sqlite> select * from t_base_define; |
− | 4 | + | f_id f_config_name f_config_value |
− | 5 | + | ---------- -------------- -------------- |
− | 6 | + | 1 primary_server 122.5.18.174 |
− | 7 | + | 2 primary_dns 219.146.0.130 |
− | 8 | + | 3 primary_port 9011 |
− | 9 | + | 4 second_server 219.146.0.130 |
− | 10 | + | 5 second_dns 219.146.0.130 |
− | 11 | + | 6 second_port 9027 |
− | 12 | + | 7 gateway_id 37060001 |
− | 13 | + | 8 net_type 0 |
− | 14 | + | 9 md5_key 863CA654 |
− | 15 | + | 10 aes_key d41d8cd98f00b2 |
− | 16 | + | 11 collect_mode 0 |
+ | 12 collect_cycle 1 | ||
+ | 13 report_mode 0 | ||
+ | 14 beat_cycle 2 | ||
+ | 15 svr_num 0001 | ||
+ | 16 appmd5 28a011de19210e | ||
sqlite> update t_base_define set f_config_value='1' where f_config_name='net_type'; | sqlite> update t_base_define set f_config_value='1' where f_config_name='net_type'; | ||
sqlite> | sqlite> | ||
sqlite> select * from t_base_define; | sqlite> select * from t_base_define; | ||
− | 1 | + | f_id f_config_name f_config_value |
− | 2 | + | ---------- -------------- -------------- |
− | 3 | + | 1 primary_server 122.5.18.174 |
− | 4 | + | 2 primary_dns 219.146.0.130 |
− | 5 | + | 3 primary_port 9011 |
− | 6 | + | 4 second_server 219.146.0.130 |
− | 7 | + | 5 second_dns 219.146.0.130 |
− | 8 | + | 6 second_port 9027 |
− | 9 | + | 7 gateway_id 37060001 |
− | 10 | + | 8 net_type 1 |
− | 11 | + | 9 md5_key 863CA654 |
− | 12 | + | 10 aes_key d41d8cd98f00b2 |
− | 13 | + | 11 collect_mode 0 |
− | 14 | + | 12 collect_cycle 1 |
− | 15 | + | 13 report_mode 0 |
− | 16 | + | 14 beat_cycle 2 |
+ | 15 svr_num 0001 | ||
+ | 16 appmd5 28a011de19210e | ||
</source> | </source> |
2017年1月5日 (四) 18:30的版本
Update net type
net_type 网络类型:
- 0 - GPRS
- 1 - RS485 等
[root@mcuzone root]#cd /app [root@mcuzone /app]#sqlite3 ./gatherdb.db SQLite version 3.10.0 2016-01-06 11:01:07 Enter ".help" for usage hints. sqlite> select * from t_base_define; sqlite> .head on sqlite> .mode column sqlite> select * from t_base_define; f_id f_config_name f_config_value ---------- -------------- -------------- 1 primary_server 122.5.18.174 2 primary_dns 219.146.0.130 3 primary_port 9011 4 second_server 219.146.0.130 5 second_dns 219.146.0.130 6 second_port 9027 7 gateway_id 37060001 8 net_type 0 9 md5_key 863CA654 10 aes_key d41d8cd98f00b2 11 collect_mode 0 12 collect_cycle 1 13 report_mode 0 14 beat_cycle 2 15 svr_num 0001 16 appmd5 28a011de19210e sqlite> update t_base_define set f_config_value='1' where f_config_name='net_type'; sqlite> sqlite> select * from t_base_define; f_id f_config_name f_config_value ---------- -------------- -------------- 1 primary_server 122.5.18.174 2 primary_dns 219.146.0.130 3 primary_port 9011 4 second_server 219.146.0.130 5 second_dns 219.146.0.130 6 second_port 9027 7 gateway_id 37060001 8 net_type 1 9 md5_key 863CA654 10 aes_key d41d8cd98f00b2 11 collect_mode 0 12 collect_cycle 1 13 report_mode 0 14 beat_cycle 2 15 svr_num 0001 16 appmd5 28a011de19210e