强迫症福音：如何完美重置x-ui面板节点ID，实现从1开始连续排列#

1
x-ui stop

1
cp /etc/x-ui/x-ui.db /root/x-ui.db.backup-$(date +"%Y%m%d%H%M%S")

1
sqlite3 /etc/x-ui/x-ui.db <<'EOF'
2
-- 创建一个与 inbounds 结构相同的新表，但不包含自增ID的主键特性
3
CREATE TABLE inbounds_new (
4
    id INTEGER,
5
    user_id INTEGER NOT NULL,
6
    up INTEGER NOT NULL,
7
    down INTEGER NOT NULL,
8
    total INTEGER NOT NULL,
9
    remark TEXT NOT NULL,
10
    enable INTEGER NOT NULL,
11
    expiry_time INTEGER NOT NULL,
12
    listen TEXT NOT NULL,
13
    port INTEGER NOT NULL,
14
    protocol TEXT NOT NULL,
15
    settings TEXT NOT NULL,
16
    stream_settings TEXT NOT NULL,
17
    tag TEXT NOT NULL,
18
    sniffing TEXT NOT NULL
19
);
20

21
-- 将旧表的数据（除了ID）插入到新表中，ID会自动从1开始生成
22
INSERT INTO inbounds_new (user_id, up, down, total, remark, enable, expiry_time, listen, port, protocol, settings, stream_settings, tag, sniffing)
23
SELECT user_id, up, down, total, remark, enable, expiry_time, listen, port, protocol, settings, stream_settings, tag, sniffing FROM inbounds ORDER BY id;
24

25
-- 删除旧的 inbounds 表
26
DROP TABLE inbounds;
27

28
-- 将新表重命名为 inbounds，并重建主键
29
CREATE TABLE inbounds (
30
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
31
    user_id INTEGER NOT NULL,
32
    up INTEGER NOT NULL,
33
    down INTEGER NOT NULL,
34
    total INTEGER NOT NULL,
35
    remark TEXT NOT NULL,
36
    enable INTEGER NOT NULL,
37
    expiry_time INTEGER NOT NULL,
38
    listen TEXT NOT NULL,
39
    port INTEGER NOT NULL,
40
    protocol TEXT NOT NULL,
41
    settings TEXT NOT NULL,
42
    stream_settings TEXT NOT NULL,
43
    tag TEXT NOT NULL,
44
    sniffing TEXT NOT NULL
45
);
46
INSERT INTO inbounds (id, user_id, up, down, total, remark, enable, expiry_time, listen, port, protocol, settings, stream_settings, tag, sniffing)
47
SELECT id, user_id, up, down, total, remark, enable, expiry_time, listen, port, protocol, settings, stream_settings, tag, sniffing FROM inbounds_new ORDER BY id;
48
DROP TABLE inbounds_new;
49

50
-- 清空与旧ID关联的流量统计数据，因为ID已经改变，旧的统计数据已无意义
51
DELETE FROM inbound_client_traffics;
52
VACUUM;
53
.quit
54
EOF

1
x-ui start