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

Timestamp:

Oct 9, 2008, 11:30:10 AM (18 years ago)

Author:

jhoblitt

Message:

drop instance.sha1sum and instance.assigned_vol_id

File:

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

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.69 2008-10-09 20:37:41 jhoblitt Exp $
+# $Id: SQL.pm,v 1.70 2008-10-09 21:30:10 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -174 +174 @@
             storage_object.so_id,
             uri,
-            assigned_vol_id,
             available
         FROM storage_object
@@ -187 +186 @@
         SELECT
             storage_object.so_id,
-            uri,
-            assigned_vol_id
+            uri
         FROM storage_object
         JOIN instance
@@ -434 +432 @@
     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,