Unstructured key-value storage for MySQL

collection.sql

CREATE TABLE IF NOT EXISTS `collection` (
    `id`          BIGINT UNSIGNED      NOT NULL     AUTO_INCREMENT,
    `uuid`        BINARY(16)           NOT NULL,
    `value`       MEDIUMBLOB           NOT NULL,
    `version`     BIGINT UNSIGNED      NOT NULL     DEFAULT 1 COMMENT 'optimistic updates',
    `format`      ENUM ('R', 'J', 'M') NOT NULL     DEFAULT 'J' COMMENT 'R: raw, J: json, M: msgpack',
    `compression` ENUM ('N', 'Z')      NOT NULL     DEFAULT 'N' COMMENT 'N: none, Z: gzip',
    `deleted_at`  DATETIME             NULL         DEFAULT NULL,
    `created_at`  DATETIME             NOT NULL     DEFAULT CURRENT_TIMESTAMP,
    `updated_at`  DATETIME                          DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY (`uuid`),
    INDEX (`updated_at`)
)
    ENGINE = InnoDB
    ROW_FORMAT = DYNAMIC
    DEFAULT CHARACTER SET utf8
    DEFAULT COLLATE utf8_unicode_ci;

DELIMITER //

CREATE TRIGGER `collection_insert_uuid`
    BEFORE INSERT
    ON `collection`
    FOR EACH ROW
    BEGIN
        IF NEW.`uuid` IS NULL
        THEN
            SET @uuid := cast(UUID() AS BINARY(36));
            SET NEW.`uuid` =
            unhex(concat(substr(@uuid, 15, 4), substr(@uuid, 10, 4),
                         substr(@uuid, 1, 8), substr(@uuid, 20, 4),
                         substr(@uuid, 25)));
        END IF;
    END;
//

DELIMITER ;