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

     1  -- +goose Up
     2  ALTER TABLE events
     3      ALTER event_type TYPE TEXT,
     4      ALTER status TYPE TEXT,
     5      ALTER "status" SET DEFAULT 'new';
     6  ALTER TABLE Event_Logs ALTER COLUMN log_type TYPE TEXT;
     7  
     8  ALTER TABLE events RENAME COLUMN event_type TO type;
     9  
    10  -- +goose Down
    11  ALTER TABLE events
    12      ALTER type TYPE event_type USING type::event_type,
    13      ALTER status TYPE event_status USING status::event_status,
    14      ALTER "status" SET DEFAULT 'new';
    15  ALTER TABLE Event_Logs ALTER COLUMN log_type TYPE log_type USING log_type::log_type;
    16  
    17  ALTER TABLE events RENAME COLUMN type TO event_type;