Changeset 4933

Timestamp:

Aug 31, 2005, 11:00:12 AM (21 years ago)

Author:

jhoblitt

Message:

add index for volume.name

Location:

trunk

Files:

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

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.8 2005-08-31 00:34:41 jhoblitt Exp $
+# $Id: SQL.pm,v 1.9 2005-08-31 21:00:12 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -181 +181 @@
     name VARCHAR(255) UNIQUE BINARY NOT NULL,
     uri VARCHAR(255) BINARY NOT NULL,
-    key(vol_id)
+    PRIMARY KEY(vol_id),
+    KEY(name(16))
 ) ENGINE=innodb;
 

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.8 2005-08-31 00:34:41 jhoblitt Exp $
+# $Id: SQL.pm,v 1.9 2005-08-31 21:00:12 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -181 +181 @@
     name VARCHAR(255) UNIQUE BINARY NOT NULL,
     uri VARCHAR(255) BINARY NOT NULL,
-    key(vol_id)
+    PRIMARY KEY(vol_id),
+    KEY(name(16))
 ) ENGINE=innodb;