wiki:ShmDocDatabaseSfdbIntegrity

Version 1 (modified by MarcusWalther, 15 years ago) (diff)

--

sfdb Table integrity

pathid INTEGER,
chktime DATETIME,
status TINYINT,
msg VARCHAR(255),
PRIMARY KEY(pathid) 

Description:

  • pathid: path ID as in 'pathtab'
  • chktime: time of last md5 check or creation time of checksum file
  • status: result of last check:
    0: no checksum file found, no check done yet;
    1: no error, md5 file came together with data;
    2: no error, md5 checksum created by sfdb cron job (integrity_check.csh);

    10: error on checksums

  • msg: error message or name of log file

back to documentation index