Index: trunk/Nebulous/lib/Nebulous/Server/SQL.pm
===================================================================
--- trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 16244)
+++ trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 16259)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.44 2008-01-26 02:04:46 jhoblitt Exp $
+# $Id: SQL.pm,v 1.45 2008-01-28 19:48:08 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -325,22 +325,4 @@
 ###
 
-CREATE TABLE instance (
-    ins_id BIGINT NOT NULL AUTO_INCREMENT,
-    so_id BIGINT NOT NULL,
-    FOREIGN KEY(so_id) REFERENCES storage_object(so_id),
-    vol_id INT NOT NULL,
-    uri VARCHAR(255) NOT NULL UNIQUE,
-    sha1sum CHAR(40) ASCII,
-    assigned_vol_id INT,
-    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-    mtime TIMESTAMP,
-    PRIMARY KEY(ins_id),
-    KEY(so_id),
-    KEY(vol_id),
-    KEY(uri(64))
-) ENGINE=innodb;
-
-###
-
 CREATE TABLE lock_record (
     so_id BIGINT NOT NULL,
@@ -365,4 +347,23 @@
     KEY(allocate),
     KEY(available)
+) ENGINE=innodb;
+
+###
+
+CREATE TABLE instance (
+    ins_id BIGINT NOT NULL AUTO_INCREMENT,
+    so_id BIGINT NOT NULL,
+    FOREIGN KEY(so_id) REFERENCES storage_object(so_id),
+    vol_id INT NOT NULL,
+    FOREIGN KEY(vol_id) REFERENCES volume(vol_id),
+    uri VARCHAR(255) NOT NULL UNIQUE,
+    sha1sum CHAR(40) ASCII,
+    assigned_vol_id INT,
+    epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    mtime TIMESTAMP,
+    PRIMARY KEY(ins_id),
+    KEY(so_id),
+    KEY(vol_id),
+    KEY(uri(64))
 ) ENGINE=innodb;