mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-08 06:51:43 -04:00
12 lines
256 B
SQL
12 lines
256 B
SQL
-- Up
|
|
|
|
ALTER TABLE audit_log ADD COLUMN aboutUserId TEXT NULL DEFAULT NULL;
|
|
|
|
UPDATE audit_log
|
|
SET aboutUserId = json_extract(payload, '$.userId')
|
|
WHERE payload like '%userId%';
|
|
|
|
CREATE INDEX "audit_log_aboutUserId" ON "audit_log" ("aboutUserId");
|
|
|
|
-- Down
|