| -- +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(), |
| 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; |
