create table contents (
  type text references contents_types not null,
  encoding text references encodings not null,
  size bigint not null,
  name text not null,
  path text not null,
  content text,
  sha text not null,
  url text not null,
  git_url text not null,
  html_url text not null,
  download_url text not null
);

comment on column contents.content is '
  If file, then present
';