create table files (
  name text not null,
  dir text,
  contents text not null,
  flags 
);
comment on table files is '
  Represents a source file
';

comment on column files.name is '
  The recommended name for the file.
';
comment on column files.dir is '
  The recommended directory path for the file where appropriate.
';
comment on column files.contents is '
  The actual source code.
';