playground: Add label to foreign key constraint.
Also cleanup redundant sql driver imports (imported by dbutil).
Change-Id: I3f0c7f68104f54ef05b9cda22e7e356ef62947fd
diff --git a/go/src/v.io/x/playground/compilerd/storage/db.go b/go/src/v.io/x/playground/compilerd/storage/db.go
index 9214252..099cac5 100644
--- a/go/src/v.io/x/playground/compilerd/storage/db.go
+++ b/go/src/v.io/x/playground/compilerd/storage/db.go
@@ -7,7 +7,6 @@
import (
"fmt"
- _ "github.com/go-sql-driver/mysql"
"github.com/jmoiron/sqlx"
"v.io/x/lib/dbutil"
diff --git a/go/src/v.io/x/playground/compilerd/storage/migration_test.go b/go/src/v.io/x/playground/compilerd/storage/migration_test.go
index 3c0d7cd..8ae0cdf 100644
--- a/go/src/v.io/x/playground/compilerd/storage/migration_test.go
+++ b/go/src/v.io/x/playground/compilerd/storage/migration_test.go
@@ -13,7 +13,6 @@
"fmt"
"testing"
- _ "github.com/go-sql-driver/mysql"
"github.com/rubenv/sql-migrate"
"v.io/x/lib/dbutil"
diff --git a/go/src/v.io/x/playground/compilerd/storage/model.go b/go/src/v.io/x/playground/compilerd/storage/model.go
index 084f44b..7e70bab 100644
--- a/go/src/v.io/x/playground/compilerd/storage/model.go
+++ b/go/src/v.io/x/playground/compilerd/storage/model.go
@@ -35,7 +35,6 @@
"fmt"
"time"
- _ "github.com/go-sql-driver/mysql"
"github.com/jmoiron/sqlx"
"v.io/x/playground/lib/hash"
diff --git a/go/src/v.io/x/playground/compilerd/storage/model_test.go b/go/src/v.io/x/playground/compilerd/storage/model_test.go
index a35196c..4b0cb4f 100644
--- a/go/src/v.io/x/playground/compilerd/storage/model_test.go
+++ b/go/src/v.io/x/playground/compilerd/storage/model_test.go
@@ -14,7 +14,6 @@
"fmt"
"testing"
- _ "github.com/go-sql-driver/mysql"
"github.com/rubenv/sql-migrate"
"v.io/x/lib/dbutil"
diff --git a/go/src/v.io/x/playground/migrations/001-create-tables.sql b/go/src/v.io/x/playground/migrations/001-create-tables.sql
index 8e6626b..122688d 100644
--- a/go/src/v.io/x/playground/migrations/001-create-tables.sql
+++ b/go/src/v.io/x/playground/migrations/001-create-tables.sql
@@ -9,10 +9,11 @@
id CHAR(64) CHARACTER SET ascii NOT NULL PRIMARY KEY,
hash BINARY(32),
created_at TIMESTAMP NOT NULL DEFAULT now(),
- FOREIGN KEY (hash) REFERENCES bundle_data(hash) ON DELETE SET NULL
+ CONSTRAINT hash_link_to_data FOREIGN KEY (hash) REFERENCES bundle_data(hash) ON DELETE SET NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-- +migrate Down
DROP TABLE bundle_link;
+
DROP TABLE bundle_data;
