Changeset 24508

Timestamp:

Jun 19, 2009, 11:17:13 AM (17 years ago)

Author:

jhoblitt

Message:

update

File:

• trunk/Nebulous-Server/scripts/dirize.pl (modified) (2 diffs)

trunk/Nebulous-Server/scripts/dirize.pl

@@ -48 +48 @@
 # completely reset the directory table
 $db->do("DELETE FROM directory");
-$db->do("ALTER TABLE directiry AUTO_INCREMENT = 1");
+$db->do("ALTER TABLE directory AUTO_INCREMENT = 1");
+# make sure these duplicates can't happen again
+$db->do("alter table directory add unique key(dirname,parent_id)");
 # seed the root ('/') directory
-$db->do("INSERT INTO directory VALUES(1, '/', 1");
+$db->do("INSERT INTO directory VALUES(1, '/', 1)");
 
 my $i = 0;
@@ -66 +68 @@
     $db->commit;
     printf("### COMMIT ###\n");
-    $query->finish;
+    $work_query->finish;
     printf("dirized $i\n");
 }