<pre style='margin:0'>
Clemens Lang (neverpanic) pushed a commit to branch gsoc17-migrate
in repository macports-base.
</pre>
<p><a href="https://github.com/macports/macports-base/commit/de907a9db7d4feca923b69297abf57822f656401">https://github.com/macports/macports-base/commit/de907a9db7d4feca923b69297abf57822f656401</a></p>
<pre style="white-space: pre; background: #F8F8F8"><span style='display:block; white-space:pre;color:#808000;'>commit de907a9db7d4feca923b69297abf57822f656401
</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 b33e351..7681b11 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;'>@@ -200,7 +200,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;'>@@ -213,8 +212,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;'>@@ -226,7 +223,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;'>@@ -667,8 +663,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;'>@@ -680,9 +674,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;'>@@ -693,8 +684,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.204' WHERE key = 'version'",
"COMMIT",
</pre><pre style='margin:0'>
</pre>