Index: trunk/dbconfig/magic.md
===================================================================
--- trunk/dbconfig/magic.md	(revision 14483)
+++ trunk/dbconfig/magic.md	(revision 14597)
@@ -1,3 +1,3 @@
-# $Id: magic.md,v 1.3 2007-08-14 04:04:30 jhoblitt Exp $
+# $Id: magic.md,v 1.4 2007-08-22 02:25:06 jhoblitt Exp $
 
 magicRun METADATA
@@ -13,22 +13,23 @@
 magicInputSkyfile METADATA
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
-    diff_id     S64         0       # Primary Key fkey(diff_id) ref diffRun(diff_id)
-    node        S32         0       # AUTO_INCREMENT
+    diff_id     S64         0       # Key fkey(diff_id) ref diffRun(diff_id)
+    node        S32         0       # AUTO_INCREMENT INDEX(magic_id, node)
 END
 
 magicTree METADATA
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
-    node        STR         64 
-    dep         STR         64
+    node        STR         64      # Primary Key fkey(magic_id, node) ref magicInputSkyfile(magic_id, node)
+    dep         STR         64      # fkey(magic_id, dep) ref magicInputSkyfile(magic_id, node)
+
 END
 
 magicNodeResult METADATA
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
-    node        STR         64 
+    node        STR         64      # Primary Key fkey(magic_id, node) ref magicInputSkyfile(magic_id, node)
     uri         STR         255
 END
 
 magicMask METADATA
-    magic_id    S64         0       # Primary Key AUTO_INCREMENT
+    magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
     uri         STR         255
 END