create table tree_results (
  path text not null,
  mode text not null,
  type text references node_types not null,
  size bigint not null,
  sha text not null,
  url text not null
);

comment on column tree_results.mode is '
  100644 file (blob), 100755 executable (blob), 040000 subdirectory (tree), 160000 submodule (commit)
';