Changeset 14167 for trunk/dbconfig/cam.md

Timestamp:

Jul 12, 2007, 12:27:12 PM (19 years ago)

Author:

jhoblitt

Message:

revise primary keys

File:

• trunk/dbconfig/cam.md (modified) (1 diff)

trunk/dbconfig/cam.md

@@ -1 +1 @@
 camRun METADATA
     cam_id      S64         0       # Primary Key AUTO_INCREMENT
-    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipRun(chip_id)
+    chip_id     S64         0       # Key INDEX(cam_id, chip_id) fkey(chip_id) ref chipRun(chip_id)
     state       STR         64      # key
     workdir     STR         255