Changeset 20023

Timestamp:

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

Author:

jhoblitt

Message:

drop instance.sha1sum and instance.assigned_vol_id

Location:

trunk/Nebulous-Server

Files:

• Changes (modified) (1 diff)
• lib/Nebulous/Server/SQL.pm (modified) (4 diffs)

trunk/Nebulous-Server/Changes

@@ -22 +22 @@
     - change getmountedvol() to use a view of the volume table to avoid table
       level locks being set by a cursor
+    - drop instance.sha1sum and instance.assigned_vol_id
 
 0.15 Thu Sep 11 13:00:59 HST 2008

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,