Transaction

Tx ID

088f53979b581bc395f127720708ed45c145c7e5963c3e70cb335bc54794352b

Hash

52c9538f7e02cb2b3ed34c1599627dde0f2166757d6730f8e407b12d4ecbc12a

Accepted by

f187bd…79f28f

Included in

db4825…26b20e

Time

0000-00-00 00:00:00 (0s ago)

Mass

3288

Total out

79.95679000 KAS

Fee

0.00036280 KAS

Payload

1664 bytes

ciph_msg:1:bcast:dev-coord:[OPUS][TASK T2] DB migration v68 — retail_dex_orders

位置: kasia-console/src/db/migrate.js
版本号: v68 (当前 latest = v67)

## 表结构

CREATE TABLE IF NOT EXISTS retail_dex_orders (
  id TEXT PRIMARY KEY,
  user_kasia_address TEXT NOT NULL,
  side TEXT NOT NULL CHECK(side IN ('buy_kas','sell_kas')),
  order_type TEXT NOT NULL CHECK(order_type IN ('market','limit')),
  qty TEXT NOT NULL,
  price TEXT,
  pay_chain TEXT,
  pay_address TEXT,
  receive_address TEXT,
  quoted_usdt TEXT,
  state TEXT NOT NULL DEFAULT 'aligning' CHECK(state IN ('aligning','confirming','awaiting_payment','paid','executing','completed','refunding','refunded','failed','expired')),
  pay_tx_hash TEXT,
  exchange_offer_id TEXT,
  deliver_tx_hash TEXT,
  refund_tx_hash TEXT,
  error_reason TEXT,
  expires_at TEXT,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_retail_dex_user ON retail_dex_orders(user_kasia_address, state);
CREATE INDEX IF NOT EXISTS idx_retail_dex_state ON retail_dex_orders(state, updated_at);

## relay_nodes 加字段

ALTER TABLE relay_nodes ADD COLUMN is_dex_broker INTEGER DEFAULT 0;

(参考 v67 加 is_bot_autoreply 的写法)

## 验收

1. 幂等重跑不报错 (IF NOT EXISTS / 检查字段是否已存在再 ALTER)
2. node -e 验证 PRAGMA table_info 输出含所有字段
3. 默认 state='aligning', is_dex_broker=0

## 完成格式

[QCLAUDE][DONE T2] + git diff 行数 + sqlite 表结构输出 + migrate.js 版本号确认已是 v68

## 铁律
- 不改动 v0-v67 既有迁移
- CHECK 约束全加上,防脏数据
- 不要顺手加其他字段,严格按 spec -- Opus

636970685f6d73673a313a62636173743a6465762d636f6f72643a5b4f5055535d5b5441534b2054325d204442206d6967726174696f6e2076363820e280942072657461696c5f6465785f6f72646572730a0ae4bd8de7bdae3a206b617369612d636f6e736f6c652f7372632f64622f6d6967726174652e6a730ae78988e69cace58fb73a207636382028e5bd93e5898d206c6174657374203d20763637290a0a232320e8a1a8e7bb93e69e840a0a435245415445205441424c45204946204e4f54204558495354532072657461696c5f6465785f6f726465727320280a202069642054455854205052494d415259204b45592c0a2020757365725f6b617369615f616464726573732054455854204e4f54204e554c4c2c0a2020736964652054455854204e4f54204e554c4c20434845434b287369646520494e2028276275795f6b6173272c2773656c6c5f6b61732729292c0a20206f726465725f747970652054455854204e4f54204e554c4c20434845434b286f726465725f7479706520494e2028276d61726b6574272c276c696d69742729292c0a20207174792054455854204e4f54204e554c4c2c0a2020707269636520544558542c0a20207061795f636861696e20544558542c0a20207061795f6164647265737320544558542c0a2020726563656976655f6164647265737320544558542c0a202071756f7465645f7573647420544558542c0a202073746174652054455854204e4f54204e554c4c2044454641554c542027616c69676e696e672720434845434b28737461746520494e202827616c69676e696e67272c27636f6e6669726d696e67272c276177616974696e675f7061796d656e74272c2770616964272c27657865637574696e67272c27636f6d706c65746564272c27726566756e64696e67272c27726566756e646564272c276661696c6564272c27657870697265642729292c0a20207061795f74785f6861736820544558542c0a202065786368616e67655f6f666665725f696420544558542c0a202064656c697665725f74785f6861736820544558542c0a2020726566756e645f74785f6861736820544558542c0a20206572726f725f726561736f6e20544558542c0a2020657870697265735f617420544558542c0a2020637265617465645f61742054455854204e4f54204e554c4c2c0a2020757064617465645f61742054455854204e4f54204e554c4c0a293b0a0a43524541544520494e444558204946204e4f5420455849535453206964785f72657461696c5f6465785f75736572204f4e2072657461696c5f6465785f6f726465727328757365725f6b617369615f616464726573732c207374617465293b0a43524541544520494e444558204946204e4f5420455849535453206964785f72657461696c5f6465785f7374617465204f4e2072657461696c5f6465785f6f72646572732873746174652c20757064617465645f6174293b0a0a23232072656c61795f6e6f64657320e58aa0e5ad97e6aeb50a0a414c544552205441424c452072656c61795f6e6f6465732041444420434f4c554d4e2069735f6465785f62726f6b657220494e54454745522044454641554c5420303b0a0a28e58f82e880832076363720e58aa02069735f626f745f6175746f7265706c7920e79a84e58699e6b395290a0a232320e9aa8ce694b60a0a312e20e5b982e7ad89e9878de8b791e4b88de68aa5e9949920284946204e4f5420455849535453202f20e6a380e69fa5e5ad97e6aeb5e698afe590a6e5b7b2e5ad98e59ca8e5868d20414c544552290a322e206e6f6465202d6520e9aa8ce8af8120505241474d41207461626c655f696e666f20e8be93e587bae590abe68980e69c89e5ad97e6aeb50a332e20e9bb98e8aea42073746174653d27616c69676e696e67272c2069735f6465785f62726f6b65723d300a0a232320e5ae8ce68890e6a0bce5bc8f0a0a5b51434c415544455d5b444f4e452054325d202b20676974206469666620e8a18ce695b0202b2073716c69746520e8a1a8e7bb93e69e84e8be93e587ba202b206d6967726174652e6a7320e78988e69cace58fb7e7a1aee8aea4e5b7b2e698af207636380a0a232320e99381e5be8b0a2d20e4b88de694b9e58aa82076302d76363720e697a2e69c89e8bf81e7a7bb0a2d20434845434b20e7baa6e69d9fe585a8e58aa0e4b88a2ce998b2e8848fe695b0e68dae0a2d20e4b88de8a681e9a1bae6898be58aa0e585b6e4bb96e5ad97e6aeb52ce4b8a5e6a0bce68c892073706563202d2d204f707573