<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/4c3ae02113e0e3fb50adc23abe181f9a0ab684d8">https://github.com/macports/macports-base/commit/4c3ae02113e0e3fb50adc23abe181f9a0ab684d8</a></p>
<pre style="white-space: pre; background: #F8F8F8"><span style='display:block; white-space:pre;color:#808000;'>commit 4c3ae02113e0e3fb50adc23abe181f9a0ab684d8
</span>Author: Umesh Singla <umeshksingla@macports.org>
AuthorDate: Mon Jun 26 11:37:26 2017 +0530
<span style='display:block; white-space:pre;color:#404040;'> Bug fix: sql
</span>---
src/cregistry/sql.c | 20 ++++++++++++--------
1 file changed, 12 insertions(+), 8 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 5959387..d1b89e6 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;'>@@ -211,8 +211,9 @@ int create_tables(sqlite3* db, reg_error* errPtr) {
</span> ", snapshots_id INTEGER"
", port_name TEXT COLLATE NOCASE"
", requested INTEGER"
<span style='display:block; white-space:pre;background:#ffe0e0;'>- ", FOREIGN KEY(snapshots_id) REFERENCES snapshots(id))"
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>- " ON DELETE CASCADE",
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ", FOREIGN KEY(snapshots_id) REFERENCES snapshots(id)"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ " ON DELETE CASCADE"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ")",
</span> "CREATE INDEX registry.snapshot_port ON snapshot_ports"
"(id, port_name)",
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -223,8 +224,9 @@ int create_tables(sqlite3* db, reg_error* errPtr) {
</span> ", snapshot_ports_id INTEGER"
", variant_name TEXT COLLATE NOCASE"
", variant_sign TEXT"
<span style='display:block; white-space:pre;background:#ffe0e0;'>- ", FOREIGN KEY(snapshot_ports_id) REFERENCES snapshot_ports(id))"
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>- " ON DELETE CASCADE",
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ", FOREIGN KEY(snapshot_ports_id) REFERENCES snapshot_ports(id)"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ " ON DELETE CASCADE"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ")",
</span> "CREATE INDEX registry.snapshot_port_variant ON snapshot_port_variants(id)",
"COMMIT",
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -759,8 +761,9 @@ int update_db(sqlite3* db, reg_error* errPtr) {
</span> ", snapshots_id INTEGER"
", port_name TEXT COLLATE NOCASE"
", requested INTEGER"
<span style='display:block; white-space:pre;background:#ffe0e0;'>- ", FOREIGN KEY(snapshots_id) REFERENCES snapshots(id))"
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>- " ON DELETE CASCADE",
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ", FOREIGN KEY(snapshots_id) REFERENCES snapshots(id)"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ " ON DELETE CASCADE"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ")",
</span>
"CREATE INDEX registry.snapshot_port ON snapshot_ports"
"(id, port_name)",
<span style='display:block; white-space:pre;background:#e0e0e0;'>@@ -771,8 +774,9 @@ int update_db(sqlite3* db, reg_error* errPtr) {
</span> ", snapshot_ports_id INTEGER"
", variant_name TEXT COLLATE NOCASE"
", variant_sign TEXT"
<span style='display:block; white-space:pre;background:#ffe0e0;'>- ", FOREIGN KEY(snapshot_ports_id) REFERENCES snapshot_ports(id))"
</span><span style='display:block; white-space:pre;background:#ffe0e0;'>- " ON DELETE CASCADE",
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ", FOREIGN KEY(snapshot_ports_id) REFERENCES snapshot_ports(id)"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ " ON DELETE CASCADE"
</span><span style='display:block; white-space:pre;background:#e0ffe0;'>+ ")",
</span>
"CREATE INDEX registry.snapshot_port_variant ON snapshot_port_variants(id)",
</pre><pre style='margin:0'>
</pre>