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

[jmr at macports.org]

Revision: 64367
          http://trac.macports.org/changeset/64367
Author:   jmr at macports.org
Date:     2010-03-03 18:26:57 -0800 (Wed, 03 Mar 2010)
Log Message:
-----------
db column metadata, new columns for planned features

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

Modified: trunk/base/src/cregistry/sql.c
===================================================================
--- trunk/base/src/cregistry/sql.c	2010-03-04 01:54:18 UTC (rev 64366)
+++ trunk/base/src/cregistry/sql.c	2010-03-04 02:26:57 UTC (rev 64367)
@@ -281,10 +281,12 @@
 
         /* ports table */
         "CREATE TABLE registry.ports ("
-            "id INTEGER PRIMARY KEY AUTOINCREMENT,"
-            "name COLLATE NOCASE, portfile, url, location, epoch, version COLLATE VERSION, "
-            "revision COLLATE VERSION, variants, default_variants, state, "
-            "date, installtype, "
+            "id INTEGER PRIMARY KEY AUTOINCREMENT, "
+            "name TEXT COLLATE NOCASE, portfile CLOB, url TEXT, "
+            "location TEXT, epoch INTEGER, version TEXT COLLATE VERSION, "
+            "revision INTEGER, variants TEXT, default_variants TEXT, "
+            "state TEXT, date DATETIME, installtype TEXT, archs TEXT, "
+            "requested INT, "
             "UNIQUE (name, epoch, version, revision, variants), "
             "UNIQUE (url, epoch, version, revision, variants)"
             ")",
@@ -295,14 +297,16 @@
         "CREATE INDEX registry.port_state ON ports (state)",
 
         /* file map */
-        "CREATE TABLE registry.files (id, path, actual_path, active, mtime, "
-            "md5sum, editable)",
+        "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))",
         "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, name)",
+        "CREATE TABLE registry.dependencies (id INTEGER, name TEXT, variants TEXT, "
+        "FOREIGN KEY(id) REFERENCES registry.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/b3e164ac/attachment.html>