Changeset 17815 for trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

Timestamp:

May 27, 2008, 11:59:53 AM (18 years ago)

Author:

jhoblitt

Message:

add neb-admin util

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (3 diffs)

trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.51 2008-05-22 04:10:01 jhoblitt Exp $
+# $Id: SQL.pm,v 1.52 2008-05-27 21:59:53 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -249 +249 @@
             ext_id,
             count(ins_id) as instances,
+            volume.name as volume_name,
             count(mountedvol.vol_id) as available_instances,
             count(mountedvol.vol_id) > 0 as recoverable,
@@ -255 +256 @@
         JOIN instance
             USING(so_id)
+        JOIN volume
+            USING(vol_id)
         LEFT JOIN storage_object_xattr
             ON storage_object.so_id = storage_object_xattr.so_id