-- 本地开发 seed：1 provider + 1 个 status='up' 节点，供 GET /v1/nodes 返回。
-- 幂等：固定 uuid，重跑先删后插。endpoint/reality_* 为占位（档 2 不真连，档 3 再指真实数据面）。

DELETE FROM nodes     WHERE uuid = '11111111-1111-1111-1111-111111111111';
DELETE FROM providers WHERE name = 'dev-local';

INSERT INTO providers (name, api_kind, regions, pool, enabled)
VALUES ('dev-local', 'manual', '["HK"]', 'consumable', TRUE);

INSERT INTO nodes
  (uuid, region, name_zh, name_en, role, tier, endpoint, hy2_port,
   reality_pbk, reality_prk, reality_short_id, reality_sni, provider_id, status, weight)
VALUES (
  '11111111-1111-1111-1111-111111111111',
  'HK', '香港 · 测试', 'Hong Kong (dev)',
  'exit', 'free',
  '127.0.0.1:11443', 443,
  'devPlaceholderRealityPublicKey00000000000000', '', '6eb28f1a',
  'www.apple.com',
  (SELECT id FROM providers WHERE name = 'dev-local' LIMIT 1),
  'up', 100
);