14 lines
426 B
PL/PgSQL
14 lines
426 B
PL/PgSQL
BEGIN;
|
|
|
|
ALTER TABLE media_segment
|
|
ADD COLUMN local_delete_status varchar(16)
|
|
CHECK (local_delete_status IN ('DELETED', 'FAILED')),
|
|
ADD COLUMN local_delete_reported_at timestamptz,
|
|
ADD COLUMN local_delete_error_code varchar(80);
|
|
|
|
CREATE INDEX media_segment_local_delete_pending_idx
|
|
ON media_segment (device_id, local_delete_after)
|
|
WHERE status = 'VERIFIED' AND local_delete_status IS NULL;
|
|
|
|
COMMIT;
|