CREATE TABLE programs (
  id serial,
  name varchar(254),
  url varchar(254),
  PRIMARY KEY(id)
);


CREATE TABLE patch_versions (
  id serial,
  patch_id int,
  comment text,
  version int,
  PRIMARY KEY(id)
);


CREATE TABLE patches (
  id serial,
  program_id int,
  title varchar(254) NOT NULL DEFAULT '',
  applied_since_version varchar(20),
  description text NOT NULL,
  created_at timestamptz,
  created_by varchar(20),
  updated_at timestamptz,
  updated_by varchar(20),
  PRIMARY KEY(id)
);
ALTER TABLE patch_versions ADD FOREIGN KEY (patch_id) REFERENCES patches (id);
ALTER TABLE patches ADD FOREIGN KEY (program_id) REFERENCES programs (id);