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

Timestamp:

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

Author:

Serge CHASTEL

Message:

last_modified field added to volume table

File:

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

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),