15.04.17.sql 820 B

1234567891011121314151617
  1. # Add Issue dependency
  2. DROP TABLE IF EXISTS `issue_dependency`;
  3. CREATE TABLE `issue_dependency` (
  4. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  5. `issue_id` int(10) unsigned NOT NULL,
  6. `dependency_id` int(11) unsigned NOT NULL,
  7. `dependency_type` char(2) COLLATE utf8_unicode_ci NOT NULL,
  8. PRIMARY KEY (`id`),
  9. UNIQUE KEY `issue_id_dependency_id` (`issue_id`,`dependency_id`),
  10. KEY `dependency_id` (`dependency_id`),
  11. CONSTRAINT `issue_dependency_ibfk_2` FOREIGN KEY (`issue_id`) REFERENCES `issue` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  12. CONSTRAINT `issue_dependency_ibfk_3` FOREIGN KEY (`dependency_id`) REFERENCES `issue` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  13. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  14. # Update Version
  15. UPDATE `config` SET `value` = '15.04.17' WHERE `attribute` = 'version';