|
Lines 78-86
Link Here
|
| 78 |
); |
78 |
); |
| 79 |
|
79 |
|
| 80 |
$self->{releases_select} = |
80 |
$self->{releases_select} = |
| 81 |
$self->{dbh}->prepare("select * from ${prefix}releases where fileid = ? and release = ?"); |
81 |
$self->{dbh}->prepare("select * from ${prefix}releases where fileid = ? and `release` = ?"); |
| 82 |
$self->{releases_insert} = |
82 |
$self->{releases_insert} = |
| 83 |
$self->{dbh}->prepare("insert into ${prefix}releases (fileid, release) values (?, ?)"); |
83 |
$self->{dbh}->prepare("insert into ${prefix}releases (fileid, `release`) values (?, ?)"); |
| 84 |
|
84 |
|
| 85 |
$self->{status_get} = |
85 |
$self->{status_get} = |
| 86 |
$self->{dbh}->prepare("select status from ${prefix}status where fileid = ?"); |
86 |
$self->{dbh}->prepare("select status from ${prefix}status where fileid = ?"); |
|
Lines 127-133
Link Here
|
| 127 |
. "where s.fileid = r.fileid " |
127 |
. "where s.fileid = r.fileid " |
| 128 |
. "and r.release = ?"); |
128 |
. "and r.release = ?"); |
| 129 |
$self->{delete_releases} = |
129 |
$self->{delete_releases} = |
| 130 |
$self->{dbh}->prepare("delete from ${prefix}releases " . "where release = ?"); |
130 |
$self->{dbh}->prepare("delete from ${prefix}releases " . "where `release` = ?"); |
| 131 |
$self->{delete_files} = |
131 |
$self->{delete_files} = |
| 132 |
$self->{dbh}->prepare("delete from ${prefix}files " |
132 |
$self->{dbh}->prepare("delete from ${prefix}files " |
| 133 |
. "using ${prefix}files f, ${prefix}releases r " |
133 |
. "using ${prefix}files f, ${prefix}releases r " |
