117 |
backupNum INTEGER NOT NULL, |
backupNum INTEGER NOT NULL, |
118 |
name VARCHAR(255) NOT NULL, |
name VARCHAR(255) NOT NULL, |
119 |
path VARCHAR(255) NOT NULL, |
path VARCHAR(255) NOT NULL, |
|
fullpath VARCHAR(255) NOT NULL, |
|
120 |
date integer NOT NULL, |
date integer NOT NULL, |
121 |
type INTEGER NOT NULL, |
type INTEGER NOT NULL, |
122 |
size INTEGER NOT NULL, |
size INTEGER NOT NULL, |
193 |
|
|
194 |
$sth->{insert_files} = $dbh->prepare(qq{ |
$sth->{insert_files} = $dbh->prepare(qq{ |
195 |
INSERT INTO files |
INSERT INTO files |
196 |
(shareID, backupNum, name, path, fullpath, date, type, size) |
(shareID, backupNum, name, path, date, type, size) |
197 |
VALUES (?,?,?,?,?,?,?,?) |
VALUES (?,?,?,?,?,?,?) |
198 |
}); |
}); |
199 |
|
|
200 |
sub fmt_time { |
sub fmt_time { |
367 |
$backupNum, |
$backupNum, |
368 |
$path_key, |
$path_key, |
369 |
$filesInBackup->{$path_key}->{'relPath'}, |
$filesInBackup->{$path_key}->{'relPath'}, |
|
$filesInBackup->{$path_key}->{'fullPath'}, |
|
|
# $filesInBackup->{$path_key}->{'sharePathM'}, |
|
370 |
$filesInBackup->{$path_key}->{'mtime'}, |
$filesInBackup->{$path_key}->{'mtime'}, |
371 |
$filesInBackup->{$path_key}->{'type'}, |
$filesInBackup->{$path_key}->{'type'}, |
372 |
$filesInBackup->{$path_key}->{'size'} |
$filesInBackup->{$path_key}->{'size'} |