DO $$
BEGIN ALTER TABLE {SCHEMA_NAME}.postjobs ADD COLUMN is_sticky BOOLEAN NOT NULL DEFAULT FALSE; EXCEPTION WHEN duplicate_column THEN RAISE DEBUG 'column {SCHEMA_NAME}.postjobs.is_sticky already exists'; END;
$$;
DO $$
BEGIN ALTER TABLE {SCHEMA_NAME}.postjobs ADD COLUMN sticky_host_id UUID REFERENCES {SCHEMA_NAME}.hosts; EXCEPTION WHEN duplicate_column THEN RAISE DEBUG 'column {SCHEMA_NAME}.postjobs.sticky_host_id already exists'; END;
$$;
DO $$
BEGIN ALTER TABLE {SCHEMA_NAME}.postjobs ADD COLUMN is_greedy BOOLEAN NOT NULL DEFAULT FALSE; EXCEPTION WHEN duplicate_column THEN RAISE DEBUG 'column {SCHEMA_NAME}.postjobs.is_greedy already exists'; END;
$$;