把它交给别人：上线、观察、备份与恢复

{
  "操作": "source.backup(backup)；两个不同文件",
  "数据版本": "schema-v1",
  "备份点内容": [
    {
      "id": 1,
      "owner_id": "alice",
      "title": "晚餐菜单",
      "body": "番茄炒蛋",
      "version": 1
    },
    {
      "id": 2,
      "owner_id": "alice",
      "title": "周末清单",
      "body": "买两本书",
      "version": 1
    }
  ],
  "备份内容": [
    {
      "id": 1,
      "owner_id": "alice",
      "title": "晚餐菜单",
      "body": "番茄炒蛋",
      "version": 1
    },
    {
      "id": 2,
      "owner_id": "alice",
      "title": "周末清单",
      "body": "买两本书",
      "version": 1
    }
  ]
}

{
  "当前源库": [
    {
      "id": 1,
      "owner_id": "alice",
      "title": "晚餐菜单",
      "body": "番茄炒蛋",
      "version": 1
    },
    {
      "id": 2,
      "owner_id": "alice",
      "title": "周末清单",
      "body": "买两本书",
      "version": 1
    },
    {
      "id": 3,
      "owner_id": "alice",
      "title": "备份之后新增",
      "body": "这条尚未进入备份",
      "version": 1
    }
  ],
  "备份仍为": [
    {
      "id": 1,
      "owner_id": "alice",
      "title": "晚餐菜单",
      "body": "番茄炒蛋",
      "version": 1
    },
    {
      "id": 2,
      "owner_id": "alice",
      "title": "周末清单",
      "body": "买两本书",
      "version": 1
    }
  ]
}

{
  "当前源库": [],
  "说明": "数据库删除已提交；换HTML或应用代码版本不会自动把这些行写回来。"
}

{
  "操作": "backup.backup(restored-new-copy)",
  "目标": "新文件；没有覆盖源库",
  "恢复后内容": [
    {
      "id": 1,
      "owner_id": "alice",
      "title": "晚餐菜单",
      "body": "番茄炒蛋",
      "version": 1
    },
    {
      "id": 2,
      "owner_id": "alice",
      "title": "周末清单",
      "body": "买两本书",
      "version": 1
    }
  ],
  "条数": 2,
  "完整性检查": "ok",
  "业务读取": {
    "status": 200,
    "body": {
      "requestId": "req-001",
      "note": {
        "id": 1,
        "owner_id": "alice",
        "title": "晚餐菜单",
        "body": "番茄炒蛋",
        "version": 1
      }
    }
  },
  "源库仍为": [],
  "未恢复": "T1新增的编号3；没有比T0更新的备份或日志",
  "边界": "T0–T3是实验步骤名，不是测得的恢复耗时。未执行云灾备切流、断电、真实登录或性能测试。"
}

下载底部实验包，运行 python3 evidence_lab.py。脚本在临时目录创建、检查和清理数据库；不会打开你的笔记库。运行结果只支持这些用例，不证明生产安全、并发压力、真实断电或云灾备。

记录对应源码 SHA-256：e7aecd720f9614777ee3d5c70996c518a381157d17f4988736b9061b7706481d。

CREATE TABLE users(id TEXT PRIMARY KEY);
CREATE TABLE notes(id INTEGER PRIMARY KEY, owner_id TEXT NOT NULL REFERENCES users(id),
 title TEXT NOT NULL CHECK(length(trim(title)) BETWEEN 1 AND 80),
 body TEXT NOT NULL DEFAULT '', version INTEGER NOT NULL DEFAULT 1 CHECK(version > 0));
CREATE TABLE tags(id INTEGER PRIMARY KEY, owner_id TEXT NOT NULL REFERENCES users(id),
 name TEXT NOT NULL, UNIQUE(owner_id,name));
CREATE TABLE note_tags(note_id INTEGER NOT NULL REFERENCES notes(id) ON DELETE CASCADE,
 tag_id INTEGER NOT NULL REFERENCES tags(id), PRIMARY KEY(note_id,tag_id));
CREATE TABLE shares(note_id INTEGER NOT NULL REFERENCES notes(id) ON DELETE CASCADE,
 reader_id TEXT NOT NULL REFERENCES users(id), PRIMARY KEY(note_id,reader_id));
INSERT INTO users VALUES ('alice'),('bob'),('eve');
INSERT INTO tags VALUES (1,'alice','学习'),(2,'bob','私有标签');