mirror of
https://github.com/LowderPlay/cheburcheck.git
synced 2026-10-05 21:28:28 +03:00
10 lines
275 B
SQL
10 lines
275 B
SQL
ALTER TABLE probe_reports
|
|
RENAME COLUMN verdict TO verdicts;
|
|
|
|
ALTER TABLE probe_reports
|
|
ALTER COLUMN verdicts TYPE VARCHAR(32)[]
|
|
USING ARRAY[verdicts];
|
|
|
|
UPDATE probe_reports
|
|
SET result = (result - 'verdict') || jsonb_build_object('verdicts', to_jsonb(verdicts));
|