go/src/v.io/x/playground/migrations/001-create-tables.sql

-- +migrate Up

CREATE TABLE bundle_data (
	hash BINARY(32) NOT NULL PRIMARY KEY,
	json MEDIUMTEXT NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE TABLE bundle_link (
	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
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

-- +migrate Down

DROP TABLE bundle_link;
DROP TABLE bundle_data;