[64370] trunk/base/src/cregistry/sql.c

[jmr at macports.org]

Revision: 64370
          http://trac.macports.org/changeset/64370
Author:   jmr at macports.org
Date:     2010-03-03 19:03:37 -0800 (Wed, 03 Mar 2010)
Log Message:
-----------
sql syntax error

Modified Paths:
--------------
    trunk/base/src/cregistry/sql.c

Modified: trunk/base/src/cregistry/sql.c
===================================================================
--- trunk/base/src/cregistry/sql.c	2010-03-04 02:54:11 UTC (rev 64369)
+++ trunk/base/src/cregistry/sql.c	2010-03-04 03:03:37 UTC (rev 64370)
@@ -299,14 +299,14 @@
         /* file map */
         "CREATE TABLE registry.files (id INTEGER, path TEXT, actual_path TEXT, "
             "active INT, mtime DATETIME, md5sum TEXT, editable INT, "
-            "FOREIGN KEY(id) REFERENCES registry.ports(id))",
+            "FOREIGN KEY(id) REFERENCES ports(id))",
         "CREATE INDEX registry.file_port ON files (id)",
         "CREATE INDEX registry.file_path ON files(path)",
         "CREATE INDEX registry.file_actual ON files(actual_path)",
 
         /* dependency map */
         "CREATE TABLE registry.dependencies (id INTEGER, name TEXT, variants TEXT, "
-        "FOREIGN KEY(id) REFERENCES registry.ports(id))",
+        "FOREIGN KEY(id) REFERENCES ports(id))",
         "CREATE INDEX registry.dep_name ON dependencies (name)",
 
         "COMMIT",
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-changes/attachments/20100303/0f5e37a7/attachment.html>