Cloudflare 免费搭建个人导航网站，0 成本不用服务器

1
-- 创建分组表
2
CREATE TABLE IF NOT EXISTS groups (
3
    id INTEGER PRIMARY KEY AUTOINCREMENT,
4
    name TEXT NOT NULL,
5
    order_num INTEGER NOT NULL,
6
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
7
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
8
);
9

10
-- 创建站点表
11
CREATE TABLE IF NOT EXISTS sites (
12
    id INTEGER PRIMARY KEY AUTOINCREMENT,
13
    group_id INTEGER NOT NULL,
14
    name TEXT NOT NULL,
15
    url TEXT NOT NULL,
16
    icon TEXT,
17
    description TEXT,
18
    notes TEXT,
19
    order_num INTEGER NOT NULL,
20
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
21
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
22
    FOREIGN KEY (group_id) REFERENCES groups(id) ON DELETE CASCADE
23
);
24

25
-- 创建配置表
26
CREATE TABLE IF NOT EXISTS configs (
27
    key TEXT PRIMARY KEY,
28
    value TEXT NOT NULL,
29
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
30
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
31
);
32

33
-- 初始化标志
34
INSERT INTO configs (key, value) VALUES ('DB_INITIALIZED', 'true');