Changeset 34764 for trunk/Nebulous-Server

Timestamp:

Dec 4, 2012, 10:09:03 AM (14 years ago)

Author:

Serge CHASTEL

Message:

last_modified field added to volume table

Location:

trunk/Nebulous-Server

Files:

• bin/neb-host (modified) (1 diff)
• lib/Nebulous/Server/SQL.pm (modified) (2 diffs)

trunk/Nebulous-Server/bin/neb-host

@@ -141 +141 @@
 $dbh->commit;
 
-my $format  = "%-15s %-15s %-7s %-8s %-9s %-5s %s\n";
-my @columns = qw(host name mounted allocate available xattr note);
+my $format  = "%-15s %-15s %-7s %-8s %-9s %-5s %15s %s\n";
+my @columns = qw(host name mounted allocate available xattr last_modified note);
 printf($format, @columns);
 

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

@@ -389 +389 @@
             mountedvol.vol_id IS NOT NULL as mounted,
             v.cab_id,
+            v.last_modified,
             v.note
         FROM volume AS v
@@ -694 +695 @@
     cab_id INT,
     note VARCHAR(255),
+    last_modified TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, # SC: Added by Haydn with ALTER TABLE(?) on 2012-12-03
     PRIMARY KEY(vol_id),
     UNIQUE KEY(name),