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

[jmr at macports.org]

Revision: 64335
          http://trac.macports.org/changeset/64335
Author:   jmr at macports.org
Date:     2010-03-02 13:43:37 -0800 (Tue, 02 Mar 2010)
Log Message:
-----------
define name column in registry2 db as case insensitive

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

Modified: trunk/base/src/cregistry/sql.c
===================================================================
--- trunk/base/src/cregistry/sql.c	2010-03-02 20:54:07 UTC (rev 64334)
+++ trunk/base/src/cregistry/sql.c	2010-03-02 21:43:37 UTC (rev 64335)
@@ -282,7 +282,7 @@
         /* ports table */
         "CREATE TABLE registry.ports ("
             "id INTEGER PRIMARY KEY AUTOINCREMENT,"
-            "name, portfile, url, location, epoch, version COLLATE VERSION, "
+            "name COLLATE NOCASE, portfile, url, location, epoch, version COLLATE VERSION, "
             "revision COLLATE VERSION, variants, default_variants, state, "
             "date, installtype, "
             "UNIQUE (name, epoch, version, revision, variants), "
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-changes/attachments/20100302/030616bd/attachment.html>