-my $st_get_discs = $DB->prepare("SELECT disc, path FROM dvd_disc
- WHERE set_id = ? AND ? <= disc AND disc < ?
- ORDER BY disc");
-my $st_add_disc = $DB->prepare("INSERT INTO dvd_disc (set_id, disc, path)
- VALUES (?, ?, ?)");
-my $st_update_disc = $DB->prepare("UPDATE dvd_disc SET path = ?
- WHERE set_id = ? AND disc = ?");
-my $st_delete_disc_range = $DB->prepare("DELETE FROM dvd_disc
- WHERE set_id = ? AND
- ? <= disc AND disc < ?");
-my $st_delete_discs = $DB->prepare("DELETE FROM dvd_disc WHERE set_id = ?");
+my $st_get_discs = $DB->prepare
+ ("SELECT disc, path, box FROM dvd_disc
+ WHERE set_id = ? AND ? <= disc AND disc < ?
+ ORDER BY disc");
+my $st_add_disc = $DB->prepare
+ ("INSERT INTO dvd_disc (set_id, disc, path, box) VALUES (?, ?, ?, ?)");
+my $st_update_disc = $DB->prepare
+ ("UPDATE dvd_disc SET path = ?, box = ? WHERE set_id = ? AND disc = ?");
+my $st_delete_disc_range = $DB->prepare
+ ("DELETE FROM dvd_disc WHERE set_id = ? AND ? <= disc AND disc < ?");
+my $st_delete_discs = $DB->prepare
+ ("DELETE FROM dvd_disc WHERE set_id = ?");