<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/fa01b9ad3d40ef27789f54f4744f47fd165fb417">https://github.com/macports/macports-base/commit/fa01b9ad3d40ef27789f54f4744f47fd165fb417</a></p>
<pre style="white-space: pre; background: #F8F8F8">The following commit(s) were added to refs/heads/gsoc17-migrate by this push:
<span style='display:block; white-space:pre;color:#404040;'>     new fa01b9a  Bug fix: sql
</span>fa01b9a is described below

<span style='display:block; white-space:pre;color:#808000;'>commit fa01b9ad3d40ef27789f54f4744f47fd165fb417
</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 1f0b9d4..aad6aa4 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;'>@@ -208,8 +208,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;'>@@ -220,8 +221,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;'>@@ -644,8 +646,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;'>@@ -656,8 +659,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>