16.02.04.1.sql 422 B

123456789101112
  1. # Add issue_backlog table
  2. CREATE TABLE `issue_backlog`(
  3. `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  4. `user_id` INT UNSIGNED NOT NULL,
  5. `issues` BLOB NOT NULL,
  6. PRIMARY KEY (`id`),
  7. CONSTRAINT `issue_backlog_user_id` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON UPDATE CASCADE ON DELETE CASCADE
  8. ) ENGINE=INNODB CHARSET=utf8;
  9. # Update version
  10. UPDATE `config` SET `value` = '16.02.04.1' WHERE `attribute` = 'version';