Changeset 13226

Timestamp:

May 3, 2007, 5:09:16 PM (19 years ago)

Author:

jhoblitt

Message:

add some additional keys

Location:

trunk

Files:

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

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.37 2007-05-04 01:05:51 jhoblitt Exp $
+# $Id: SQL.pm,v 1.38 2007-05-04 03:09:16 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -330 +330 @@
     so_id BIGINT NOT NULL,
     vol_id INT NOT NULL,
-    uri VARCHAR(255) NOT NULL,
+    uri VARCHAR(255) NOT NULL UNIQUE,
     sha1sum CHAR(40) ASCII,
     assigned_vol_id INT,
@@ -337 +337 @@
     PRIMARY KEY(ins_id),
     KEY(so_id),
+    KEY(vol_id),
     KEY(uri(64))
 ) ENGINE=innodb;
@@ -410 +411 @@
         path VARCHAR(255) NOT NULL,
         allocate BOOLEAN DEFAULT FALSE,
-        available BOOLEAN DEFAULT FALSE
+        available BOOLEAN DEFAULT FALSE,
+        KEY(vol_id),
+        KEY(allocate),
+        KEY(available)
     ) ENGINE=MEMORY;
 

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

@@ -1 +1 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.37 2007-05-04 01:05:51 jhoblitt Exp $
+# $Id: SQL.pm,v 1.38 2007-05-04 03:09:16 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -330 +330 @@
     so_id BIGINT NOT NULL,
     vol_id INT NOT NULL,
-    uri VARCHAR(255) NOT NULL,
+    uri VARCHAR(255) NOT NULL UNIQUE,
     sha1sum CHAR(40) ASCII,
     assigned_vol_id INT,
@@ -337 +337 @@
     PRIMARY KEY(ins_id),
     KEY(so_id),
+    KEY(vol_id),
     KEY(uri(64))
 ) ENGINE=innodb;
@@ -410 +411 @@
         path VARCHAR(255) NOT NULL,
         allocate BOOLEAN DEFAULT FALSE,
-        available BOOLEAN DEFAULT FALSE
+        available BOOLEAN DEFAULT FALSE,
+        KEY(vol_id),
+        KEY(allocate),
+        KEY(available)
     ) ENGINE=MEMORY;