github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/018_update_events.sql (about)

     1  -- +goose Up
     2  ALTER TABLE events RENAME COLUMN task TO payload;
     3  ALTER TABLE events ALTER COLUMN deadline TYPE interval USING deadline::interval;
     4  ALTER TABLE events ADD COLUMN retry_count INT NOT NULL DEFAULT 0;
     5  
     6  -- +goose Down
     7  ALTER TABLE events RENAME COLUMN payload TO task;
     8  ALTER TABLE events ALTER COLUMN deadline TYPE TEXT;
     9  ALTER TABLE events DROP COLUMN retry_count;