anchor.diff:  
   CREATE TABLE jobmedia
   (
  -    jobmediaid        serial    not null,
  -    jobid       integer   not null,
  -    mediaid       integer   not null,
  -    firstindex        integer   default 0,
  -    lastindex       integer   default 0,
  -    startfile       integer   default 0,
  -    endfile       integer   default 0,
  -    startblock        bigint    default 0,
  -    endblock        bigint    default 0,
  -    volindex        integer   default 0,
  +    jobmediaid	      serial	  not null,
  +    jobid	      integer	  not null,
  +    mediaid	      integer	  not null,
  +    firstindex	      integer	  default 0,
  +    lastindex	      integer	  default 0,
  +    startfile	      integer	  default 0,
  +    endfile	      integer	  default 0,
  +    startblock	      bigint	  default 0,
  +    endblock	      bigint	  default 0,
  +    volindex	      integer	  default 0,
       primary key (jobmediaid)
   );
   
  
positive.code: 
  CREATE TABLE media
  (
      mediaid       serial    not null,
      volumename        text    not null,
      slot        integer   default 0,
      poolid        integer   default 0,
      mediatype       text    not null,
      mediatypeid       integer   default 0,
      labeltype       integer   default 0,
      firstwritten      timestamp   without time zone,
      lastwritten       timestamp   without time zone,
      labeldate       timestamp   without time zone,
      voljobs       integer   default 0,
      volfiles        integer   default 0,
      volblocks       integer   default 0,
      volmounts       integer   default 0,
      volbytes        bigint    default 0,
      volparts        integer   default 0,
      volerrors       integer   default 0,
      volwrites       integer   default 0,
      volcapacitybytes  bigint    default 0,
      volstatus       text    not null
    check (volstatus in ('Full','Archive','Append',
          'Recycle','Purged','Read-Only','Disabled',
          'Error','Busy','Used','Cleaning','Scratch')),
      enabled       smallint    default 1,
      recycle       smallint    default 0,
      ActionOnPurge     smallint    default 0,
      volretention      bigint    default 0,
      voluseduration    bigint    default 0,
      maxvoljobs        integer   default 0,
      maxvolfiles       integer   default 0,
      maxvolbytes       bigint    default 0,
      inchanger       smallint    default 0,
      StorageId       integer   default 0,
      DeviceId        integer   default 0,
      mediaaddressing   smallint    default 0,
      volreadtime       bigint    default 0,
      volwritetime      bigint    default 0,
      endfile       integer   default 0,
      endblock        bigint    default 0,
      LocationId        integer   default 0,
      recyclecount      integer   default 0,
      initialwrite      timestamp   without time zone,
      scratchpoolid     integer   default 0,
      recyclepoolid     integer   default 0,
      comment       text,
      primary key (mediaid)
  );
  
  create unique index media_volumename_id on media (volumename);
  
  
  CREATE TABLE MediaType (
     MediaTypeId SERIAL,
     MediaType TEXT NOT NULL,
  
negative.code:      CONSTRAINT pathhierarchy_pkey PRIMARY KEY (PathId)
  );
  
  CREATE INDEX pathhierarchy_ppathid 
  	  ON PathHierarchy (PPathId);
  
  CREATE TABLE PathVisibility
  (
  