37 lines
950 B
SQL
37 lines
950 B
SQL
|
-- +goose Up
|
||
|
|
-- +goose StatementBegin
|
||
|
|
ALTER TABLE public.autoscan_events
|
||
|
|
DROP CONSTRAINT IF EXISTS autoscan_events_status_check;
|
||
|
|
|
||
|
|
ALTER TABLE public.autoscan_events
|
||
|
|
ADD CONSTRAINT autoscan_events_status_check
|
||
|
|
CHECK (status = ANY (ARRAY[
|
||
|
|
'running'::text,
|
||
|
|
'success'::text,
|
||
|
|
'error'::text,
|
||
|
|
'unresolved'::text
|
||
|
|
]));
|
||
|
|
-- +goose StatementEnd
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- +goose StatementBegin
|
||
|
|
UPDATE public.autoscan_events
|
||
|
|
SET status = 'error',
|
||
|
|
error_message = CASE
|
||
|
|
WHEN error_message = '' THEN 'poll started but did not finish'
|
||
|
|
ELSE error_message
|
||
|
|
END
|
||
|
|
WHERE status = 'running';
|
||
|
|
|
||
|
|
ALTER TABLE public.autoscan_events
|
||
|
|
DROP CONSTRAINT IF EXISTS autoscan_events_status_check;
|
||
|
|
|
||
|
|
ALTER TABLE public.autoscan_events
|
||
|
|
ADD CONSTRAINT autoscan_events_status_check
|
||
|
|
CHECK (status = ANY (ARRAY[
|
||
|
|
'success'::text,
|
||
|
|
'error'::text,
|
||
|
|
'unresolved'::text
|
||
|
|
]));
|
||
|
|
-- +goose StatementEnd
|