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

Timestamp:

Sep 22, 2008, 11:22:52 AM (18 years ago)

Author:

jhoblitt

Message:

add so_id/name idxs to storage_object_xattr table

File:

• trunk/Nebulous-Server/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.63 2008-08-21 02:26:58 jhoblitt Exp $
+# $Id: SQL.pm,v 1.64 2008-09-22 21:22:52 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -392 +392 @@
     name VARCHAR(255),
     value BLOB,
-    PRIMARY KEY(so_id, name)
+    PRIMARY KEY(so_id, name),
+    KEY(so_id),
+    KEY(name(64))
 ) ENGINE=innodb DEFAULT CHARSET=latin1;