mirror of
https://github.com/wahyd4/heygo.git
synced 2026-08-09 05:15:52 +10:00
11 lines
349 B
SQL
11 lines
349 B
SQL
CREATE TABLE link_change_logs (
|
|
id TEXT PRIMARY KEY,
|
|
link_id TEXT NOT NULL REFERENCES links(id) ON DELETE CASCADE,
|
|
change_type TEXT NOT NULL,
|
|
old_value TEXT,
|
|
new_value TEXT,
|
|
changed_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ', 'now'))
|
|
);
|
|
|
|
CREATE INDEX link_change_logs_link_idx ON link_change_logs(link_id, changed_at DESC);
|