· 8 years ago · Apr 14, 2018, 11:34 PM
1CREATE TABLE IF NOT EXISTS {{ crayfish_db_name }}.Gemini (
2 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3 uuid VARCHAR(36) NOT NULL UNIQUE,
4 drupal VARCHAR(2048) NOT NULL,
5 drupal_sha512 VARCHAR(128) NOT NULL UNIQUE,
6 fedora VARCHAR(2048) NOT NULL,
7 fedora_sha512 VARCHAR(128) NOT NULL UNIQUE,
8 UNIQUE KEY (drupal_sha512, fedora_sha512)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8;