"Fossies" - the Fresh Open Source Software Archive

Member "bareos-Release-20.0.3/core/src/cats/dml/0021_uar_last_full_no_pool" (14 Sep 2021, 320 Bytes) of package /linux/misc/bareos-Release-20.0.3.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 INSERT INTO temp1
    2 SELECT Job.JobId, JobTdate
    3   FROM Job, FileSet
    4  WHERE Job.ClientId    = %s
    5    AND Job.StartTime   < '%s'
    6    AND Level           = 'F'
    7    AND JobStatus IN ('T','W')
    8    AND Type            = 'B'
    9    AND Job.FileSetId   = FileSet.FileSetId
   10    AND FileSet.FileSet = '%s'
   11  ORDER BY Job.JobTDate DESC LIMIT 1