<pre style='margin:0'>
Umesh Singla (umeshksingla) pushed a commit to branch gsoc17-migrate
in repository macports-base.

</pre>
<p><a href="https://github.com/macports/macports-base/commit/94f9eccc82bef1ecef32d298139a29a7a919a25f">https://github.com/macports/macports-base/commit/94f9eccc82bef1ecef32d298139a29a7a919a25f</a></p>
<pre style="white-space: pre; background: #F8F8F8"><span style='display:block; white-space:pre;color:#808000;'>commit 94f9eccc82bef1ecef32d298139a29a7a919a25f
</span>Author: Umesh Singla <umeshksingla@macports.org>
AuthorDate: Sun Aug 6 04:08:28 2017 +0530

<span style='display:block; white-space:pre;color:#404040;'>    Remove infrequently used sql indices
</span>---
 src/cregistry/sql.c | 11 -----------
 1 file changed, 11 deletions(-)

<span style='display:block; white-space:pre;color:#808080;'>diff --git a/src/cregistry/sql.c b/src/cregistry/sql.c
</span><span style='display:block; white-space:pre;color:#808080;'>index cfd029f..76c788d 100644
</span><span style='display:block; white-space:pre;background:#e0e0ff;'>--- a/src/cregistry/sql.c
</span><span style='display:block; white-space:pre;background:#e0e0ff;'>+++ b/src/cregistry/sql.c
</span><span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -199,7 +199,6 @@ int create_tables(sqlite3* db, reg_error* errPtr) {
</span>             ", created_at DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL"
             ", note TEXT"
             ")",
<span style='display:block; white-space:pre;background:#ffe0e0;'>-        "CREATE INDEX registry.snapshot ON snapshots(id)",
</span> 
         /* snapshot ports table */
         /* a complete copy of all the installed ports for a snapshot */
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -212,8 +211,6 @@ int create_tables(sqlite3* db, reg_error* errPtr) {
</span>             ", FOREIGN KEY(snapshots_id) REFERENCES snapshots(id)"
             " ON DELETE CASCADE"
             ")",
<span style='display:block; white-space:pre;background:#ffe0e0;'>-        "CREATE INDEX registry.snapshot_port ON snapshot_ports"
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>-            "(id, port_name)",
</span> 
         /* snapshot port variants table */
         /* all variants (+, -) of the ports in a snapshot */
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -225,7 +222,6 @@ int create_tables(sqlite3* db, reg_error* errPtr) {
</span>             ", FOREIGN KEY(snapshot_ports_id) REFERENCES snapshot_ports(id)"
             " ON DELETE CASCADE"
             ")",
<span style='display:block; white-space:pre;background:#ffe0e0;'>-        "CREATE INDEX registry.snapshot_port_variant ON snapshot_port_variants(id)",
</span> 
         "COMMIT",
         NULL
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -639,8 +635,6 @@ int update_db(sqlite3* db, reg_error* errPtr) {
</span>                     ", note TEXT"
                     ")",
 
<span style='display:block; white-space:pre;background:#ffe0e0;'>-                "CREATE INDEX registry.snapshot ON snapshots(id)",
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>-
</span>                 /* snapshot ports table */
                 "CREATE TABLE registry.snapshot_ports ("
                       "id INTEGER PRIMARY KEY"
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -652,9 +646,6 @@ int update_db(sqlite3* db, reg_error* errPtr) {
</span>                     " ON DELETE CASCADE"
                     ")",
 
<span style='display:block; white-space:pre;background:#ffe0e0;'>-                "CREATE INDEX registry.snapshot_port ON snapshot_ports"
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>-                    "(id, port_name)",
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>-
</span>                 /* snapshot port variants table */
                 "CREATE TABLE registry.snapshot_port_variants ("
                       "id INTEGER PRIMARY KEY"
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -665,8 +656,6 @@ int update_db(sqlite3* db, reg_error* errPtr) {
</span>                     " ON DELETE CASCADE"
                     ")",
 
<span style='display:block; white-space:pre;background:#ffe0e0;'>-                "CREATE INDEX registry.snapshot_port_variant ON snapshot_port_variants(id)",
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>-
</span>                 /* Update version and commit */
                 "UPDATE registry.metadata SET value = '1.203' WHERE key = 'version'",
                 "COMMIT",
</pre><pre style='margin:0'>

</pre>