Sequel.migration do
  transaction
  up do
    run 'ALTER TABLE `relationships` ADD CONSTRAINT `relationship_chain_id` FOREIGN KEY (`chain_id`) REFERENCES `chains` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;'
    run 'ALTER TABLE `relationships` ADD CONSTRAINT `relationship_trigger_id` FOREIGN KEY (`trigger_id`) REFERENCES `functions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;'
    run 'ALTER TABLE `relationships` ADD CONSTRAINT `relationship_action_id` FOREIGN KEY (`action_id`) REFERENCES `functions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;'
  end

  down do
    run 'ALTER TABLE `relationships` DROP FOREIGN KEY `relationship_action_id`;'
    run 'ALTER TABLE `relationships` DROP FOREIGN KEY `relationship_trigger_id`;'
    run 'ALTER TABLE `relationships` DROP FOREIGN KEY `relationship_chain_id`;'
  end
end