Changeset 12568

Timestamp:

Mar 23, 2007, 12:16:50 PM (19 years ago)

Author:

jhoblitt

Message:

fix foreign key syntax

Location:

trunk

Files:

• dbconfig/cam.md (modified) (2 diffs)
• ippdb/src/ippdb.c (modified) (2 diffs)

trunk/dbconfig/cam.md

@@ -3 +3 @@
 camPendingExp METADATA
     cam_id      S64         0       # Primary Key AUTO_INCREMENT
-    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp.chip_id)
+    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
     workdir     STR         255 
     label       STR         64      # key
@@ -14 +14 @@
 # the camPendingExp row gets deleted so we can not put a fkey on cam_id
     cam_id      S64         0       # Primary Key
-    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp.chip_id)
+    chip_id     S64         0       # Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)
     workdir     STR         255 
     label       STR         64      # key

trunk/ippdb/src/ippdb.c

@@ -7190 +7190 @@
         return false;
     }
-    if (!psMetadataAdd(md, PS_LIST_TAIL, "chip_id", PS_DATA_S64, "Primary Key fkey(chip_id) ref chipProcessedExp.chip_id)", 0)) {
+    if (!psMetadataAdd(md, PS_LIST_TAIL, "chip_id", PS_DATA_S64, "Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)", 0)) {
         psError(PS_ERR_UNKNOWN, false, "failed to add item chip_id");
         psFree(md);
@@ -7607 +7607 @@
         return false;
     }
-    if (!psMetadataAdd(md, PS_LIST_TAIL, "chip_id", PS_DATA_S64, "Primary Key fkey(chip_id) ref chipProcessedExp.chip_id)", 0)) {
+    if (!psMetadataAdd(md, PS_LIST_TAIL, "chip_id", PS_DATA_S64, "Primary Key fkey(chip_id) ref chipProcessedExp(chip_id)", 0)) {
         psError(PS_ERR_UNKNOWN, false, "failed to add item chip_id");
         psFree(md);