Index: /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
===================================================================
--- /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 13225)
+++ /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 13226)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.37 2007-05-04 01:05:51 jhoblitt Exp $
+# $Id: SQL.pm,v 1.38 2007-05-04 03:09:16 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -330,5 +330,5 @@
     so_id BIGINT NOT NULL,
     vol_id INT NOT NULL,
-    uri VARCHAR(255) NOT NULL,
+    uri VARCHAR(255) NOT NULL UNIQUE,
     sha1sum CHAR(40) ASCII,
     assigned_vol_id INT,
@@ -337,4 +337,5 @@
     PRIMARY KEY(ins_id),
     KEY(so_id),
+    KEY(vol_id),
     KEY(uri(64))
 ) ENGINE=innodb;
@@ -410,5 +411,8 @@
         path VARCHAR(255) NOT NULL,
         allocate BOOLEAN DEFAULT FALSE,
-        available BOOLEAN DEFAULT FALSE
+        available BOOLEAN DEFAULT FALSE,
+        KEY(vol_id),
+        KEY(allocate),
+        KEY(available)
     ) ENGINE=MEMORY;
 
Index: /trunk/Nebulous/lib/Nebulous/Server/SQL.pm
===================================================================
--- /trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 13225)
+++ /trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 13226)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.37 2007-05-04 01:05:51 jhoblitt Exp $
+# $Id: SQL.pm,v 1.38 2007-05-04 03:09:16 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -330,5 +330,5 @@
     so_id BIGINT NOT NULL,
     vol_id INT NOT NULL,
-    uri VARCHAR(255) NOT NULL,
+    uri VARCHAR(255) NOT NULL UNIQUE,
     sha1sum CHAR(40) ASCII,
     assigned_vol_id INT,
@@ -337,4 +337,5 @@
     PRIMARY KEY(ins_id),
     KEY(so_id),
+    KEY(vol_id),
     KEY(uri(64))
 ) ENGINE=innodb;
@@ -410,5 +411,8 @@
         path VARCHAR(255) NOT NULL,
         allocate BOOLEAN DEFAULT FALSE,
-        available BOOLEAN DEFAULT FALSE
+        available BOOLEAN DEFAULT FALSE,
+        KEY(vol_id),
+        KEY(allocate),
+        KEY(available)
     ) ENGINE=MEMORY;