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

Timestamp:

Jul 1, 2009, 5:33:12 PM (17 years ago)

Author:

jhoblitt

Message:

don't index a time field

File:

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

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

@@ -217 +217 @@
     copy_instances_to_deleted => qq{
         INSERT INTO deleted 
-        SELECT NULL, vol_id, uri
+        SELECT vol_id, uri, NULL
         FROM instance
         WHERE
@@ -678 +678 @@
 
 CREATE TABLE deleted (
+    vol_id INT NOT NULL,
+    FOREIGN KEY(vol_id) REFERENCES volume(vol_id),
+    uri VARCHAR(255) NOT NULL,
     timestamp TIMESTAMP,
-    vol_id INT NOT NULL,
-    uri VARCHAR(255) NOT NULL,
-    PRIMARY KEY(timestamp),
+    PRIMARY KEY(vol_id, uri),
     KEY(vol_id),
     KEY(uri)