CREATE TABLE jobs(
  id UUID NOT NULL PRIMARY KEY DEFAULT gen_random_uuid(),
  repo UUID NOT NULL REFERENCES repositories(id),
  started TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
  ended TIMESTAMP WITH TIME ZONE,
  status INTEGER
);

UPDATE permissions SET perm = perm | 0x100;

GRANT ALL PRIVILEGES ON jobs TO pijul;