Index: trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
===================================================================
--- trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 20030)
+++ trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 20089)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.71 2008-10-09 23:27:44 jhoblitt Exp $
+# $Id: SQL.pm,v 1.72 2008-10-13 20:06:22 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -276,4 +276,10 @@
         WHERE name = ?
     },
+    get_volumes => qq{
+        SELECT v.vol_id, v.name, v.host, v.path, v.allocate, v.available, v.xattr, mountedvol.vol_id as mounted
+        FROM volume as v
+        LEFT JOIN mountedvol
+            USING(vol_id)
+    },
     find_objects => qq{
         SELECT *