Changeset 23627

Timestamp:

Mar 31, 2009, 10:31:15 AM (17 years ago)

Author:

jhoblitt

Message:

drop indexes from instance.uri column

File:

• trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm (modified) (1 diff)

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

@@ -470 +470 @@
     vol_id INT NOT NULL,
     FOREIGN KEY(vol_id) REFERENCES volume(vol_id),
-    uri VARCHAR(255) NOT NULL UNIQUE,
+    uri VARCHAR(255) NOT NULL,
     epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     mtime TIMESTAMP,
     PRIMARY KEY(ins_id),
     KEY(so_id),
-    KEY(vol_id),
-    KEY(uri(64))
+    KEY(vol_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;