Contents

Sequel.migration do
  transaction
  up do
    run 'ALTER TABLE `tasks` ADD `relationship_id` INT(11) UNSIGNED NOT NULL AFTER `status`;'
    run 'ALTER TABLE `tasks` ADD CONSTRAINT `task_relationship_id` FOREIGN KEY (`relationship_id`) REFERENCES `relationships` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;'
  end

  down do
    run 'ALTER TABLE `task_relationship_id` DROP FOREIGN KEY `node_id`;'
    alter_table(:tasks) do
      drop_column :relationship_id
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
legion-data-0.1.1	lib/legion/data/migrations/017_add_relationship_to_tasks.rb
legion-data-0.1.0	lib/legion/data/migrations/017_add_relationship_to_tasks.rb