Changeset 24386

Timestamp:

Jun 12, 2009, 1:27:33 PM (17 years ago)

Author:

jhoblitt

Message:

don't allow duplicate dirname entries in the directory table

File:

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

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

@@ -455 +455 @@
     FOREIGN KEY(parent_id) REFERENCES directory(dir_id),
     PRIMARY KEY(dir_id),
-    KEY(parent_id)
+    KEY(parent_id),
+    KEY(dirname),
+    UNIQUE(dirname, parent_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;