31 lines
879 B
SQL
31 lines
879 B
SQL
-- Migration number: 0001
|
|
-- Baseline: 与现有生产库一致。IF NOT EXISTS 保证在已有 D1 上执行为 no-op。
|
|
-- 新库从零建也能跑。
|
|
|
|
CREATE TABLE IF NOT EXISTS raw_mails (
|
|
id INTEGER PRIMARY KEY,
|
|
message_id TEXT UNIQUE,
|
|
from_addr TEXT,
|
|
to_addr TEXT,
|
|
subject TEXT,
|
|
raw TEXT,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
processed INTEGER DEFAULT 0
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS code_mails (
|
|
id INTEGER PRIMARY KEY,
|
|
message_id TEXT UNIQUE,
|
|
from_addr TEXT,
|
|
from_org TEXT,
|
|
to_addr TEXT,
|
|
topic TEXT,
|
|
code TEXT,
|
|
expires_at DATETIME,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
FOREIGN KEY (message_id) REFERENCES raw_mails(message_id)
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_raw_message_id ON raw_mails (message_id);
|
|
CREATE INDEX IF NOT EXISTS idx_code_message_id ON code_mails (message_id);
|