修改哪吒数据库 更改服务器、报警、服务顺序

安装sqlite3 （用于打开sqlite数据库）

apt install sqlite3

打开哪吒数据库

sqlite3 /opt/nezha/dashboard/data/sqlite.db

列出表

.tables

修改服务器排序

打开服务器文件

SELECT * FROM servers;

修改id

UPDATE servers SET id =要修改成的id WHERE id =修改的id;

删除id

DELETE FROM servers WHERE id =要删除的id;

更新id列 让后续id减少1

UPDATE servers
SET id = id - 1
WHERE id > 中间断的id;

重置顺序

DELETE FROM sqlite_sequence WHERE name = 'servers';

保存并退出

.exit

修改报警排序

打开报警文件

SELECT * FROM alert_rules;

修改报警id

UPDATE alert_rules SET id =要修改成的id WHERE id =修改的id;

删除报警

DELETE FROM alert_rules WHERE id =要删除的id;

重置顺序

DELETE FROM sqlite_sequence WHERE name = 'alert_rules';

修改服务（网络延迟ip）

打开服务文件

SELECT * FROM services;

修改服务id

UPDATE services SET id =要修改成的id WHERE id =修改的id;

删除网络延迟id

DELETE FROM services WHERE id =要删除的id;

重置顺序

DELETE FROM sqlite_sequence WHERE name = 'services';

修改服务器分组

打开服务器分组文件

SELECT * FROM server_group_servers;

修改报警id

UPDATE server_group_servers SET id =要修改成的id WHERE id =修改的id;

删除计划报警id

DELETE FROM server_group_server WHERE id =要删除的id;

重置顺序

DELETE FROM sqlite_sequence WHERE name = 'server_group_servers';

清空网络延迟监控

DELETE FROM service_histories;

修改报警通知里面的双向流量使用多少

字节转换网站：https://tooltt.com/byte-convert/

查找服务器id的流量报警

SELECT * FROM transfers WHERE server_id =服务器id;

清空服务器id的流量

UPDATE transfers
SET "in" = 0, "out" = 0
WHERE server_id =服务器id;

清空字段的流量

UPDATE transfers
SET "in" = 0, "out" = 0
WHERE id =字段;

修改下载流量

UPDATE transfers
SET out =要修改的流量字节
WHERE id =字段;

修改上传流量

UPDATE transfers
SET "in" =要修改的流量字节
WHERE id =字段;

重置顺序

DELETE FROM sqlite_sequence WHERE name = 'transfers';

重置服务器id流量为0

UPDATE transfers SET "in" = 0, out = 0 WHERE server_id =服务器id;

修改计划任务

打开计划任务文件

SELECT * FROM crons;

修改计划任务id

UPDATE crons SET id =要修改成的id WHERE id =修改的id;

删除计划任务id

DELETE FROM crons WHERE id =要删除的id;

重置顺序

DELETE FROM sqlite_sequence WHERE name = 'crons';