81 |
create table files ( |
create table files ( |
82 |
ID INTEGER NOT NULL PRIMARY KEY, |
ID INTEGER NOT NULL PRIMARY KEY, |
83 |
shareID INTEGER NOT NULL references shares(id), |
shareID INTEGER NOT NULL references shares(id), |
84 |
backupNum INTEGER NOT NULL references backups(id), |
backupNum INTEGER NOT NULL references backups(num), |
85 |
name VARCHAR(255) NOT NULL, |
name VARCHAR(255) NOT NULL, |
86 |
path VARCHAR(255) NOT NULL, |
path VARCHAR(255) NOT NULL, |
87 |
fullpath VARCHAR(255) NOT NULL, |
fullpath VARCHAR(255) NOT NULL, |
236 |
VALUES (?,?,?,?) |
VALUES (?,?,?,?) |
237 |
}); |
}); |
238 |
|
|
239 |
$sth->{insert_share}->execute($hostID,$share, $hostname . $share,undef); |
my $drop_down = $hostname . '/' . $share; |
240 |
|
$drop_down =~ s#//+#/#g; |
241 |
|
|
242 |
|
$sth->{insert_share}->execute($hostID,$share, $drop_down ,undef); |
243 |
return $dbh->func('last_insert_rowid'); |
return $dbh->func('last_insert_rowid'); |
244 |
} |
} |
245 |
|
|