anchor.diff:  
   CREATE TABLE Filename
   (
  -    FilenameId        serial    not null,
  -    Name        text    not null,
  +    FilenameId	      serial	  not null,
  +    Name	      text	  not null,
       primary key (FilenameId)
   );
   
  
positive.code: 
  CREATE TABLE Job
  (
      JobId       serial    not null,
      Job         text    not null,
      Name        text    not null,
      Type        char(1)   not null,
      Level       char(1)   not null,
      ClientId        integer   default 0,
      JobStatus       char(1)   not null,
      SchedTime       timestamp   without time zone,
      StartTime       timestamp   without time zone,
      EndTime       timestamp   without time zone,
      RealEndTime       timestamp   without time zone,
      JobTDate        bigint    default 0,
      VolSessionId      integer   default 0,
      volSessionTime    integer   default 0,
      JobFiles        integer   default 0,
      JobBytes        bigint    default 0,
      ReadBytes       bigint    default 0,
      JobErrors       integer   default 0,
      JobMissingFiles   integer   default 0,
      PoolId        integer   default 0,
      FilesetId       integer   default 0,
      PriorJobid        integer   default 0,
      PurgedFiles       smallint    default 0,
      HasBase       smallint    default 0,
      HasCache        smallint    default 0,
      Reviewed        smallint    default 0,
      Comment       text,
      primary key (jobid)
  );
  
  CREATE INDEX job_name_idx on job (name);
  
  -- Create a table like Job for long term statistics
  CREATE TABLE JobHisto (LIKE Job);
  CREATE INDEX jobhisto_idx ON JobHisto ( StartTime );
  
  
  CREATE TABLE Location (
     LocationId       serial    not null,
     Location       text    not null,
     Cost         integer   default 0,
     Enabled        smallint,
     primary key (LocationId)
  );
  
  
  CREATE TABLE fileset
  (
      filesetid       serial    not null,
      fileset       text    not null,
      md5         text    not null,
      createtime        timestamp without time zone not null,
      primary key (filesetid)
  );
  
  
negative.code: 
  CREATE TABLE Path
  (
      PathId	      serial	  not null,
      Path	      text	  not null,
      primary key (PathId)
  );
  
  