Crayfish schema

gistfile1.txt

CREATE TABLE IF NOT EXISTS {{ crayfish_db_name }}.Gemini (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    uuid VARCHAR(36) NOT NULL UNIQUE,
    drupal VARCHAR(2048) NOT NULL,
    drupal_sha512 VARCHAR(128) NOT NULL UNIQUE,
    fedora VARCHAR(2048) NOT NULL,
    fedora_sha512 VARCHAR(128)  NOT NULL UNIQUE,
    UNIQUE KEY (drupal_sha512, fedora_sha512)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;