sql/update_to_3_0_0.sql from ryandotsmith/queue_classic

sql/update_to_3_0_0.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

DO $$DECLARE r record;
BEGIN
  BEGIN
    ALTER TABLE queue_classic_jobs ADD COLUMN created_at timestamptz DEFAULT now();
  EXCEPTION
    WHEN duplicate_column THEN RAISE NOTICE 'column created_at already exists in queue_classic_jobs.';
  END;
END$$;

DO $$DECLARE r record;
BEGIN
  BEGIN
    ALTER TABLE queue_classic_jobs ADD COLUMN locked_by integer;
  EXCEPTION
    WHEN duplicate_column THEN RAISE NOTICE 'column locked_by already exists in queue_classic_jobs.';
  END;
END$$;