require 'rubygems'
require 'sequel/extensions/migration'

Class.new( Sequel::Migration ) do

    def up
        create_table :module_logs do
            primary_key :id
            foreign_key :command_log_id, :command_logs, :null => false
            String :module, :null => false
            String :event, :size => 20, :null => false
            String :logfile
            DateTime :started_at
            DateTime :finished_at
            Integer  :state, :default => 0, :null => false
        end
    end

    def down
        drop_table :module_events
    end

end