20120825005823_group_update.rb 959 B

12345678910111213141516171819202122
  1. class GroupUpdate < ActiveRecord::Migration
  2. def up
  3. # t.references :signature, :null => true
  4. add_column :groups, :signature_id, :integer, :null => true
  5. add_column :groups, :assignment_timeout, :integer, :null => true
  6. add_column :groups, :follow_up_possible, :string, :limit => 100, :default => 'yes', :null => true
  7. add_column :groups, :follow_up_assignment, :boolean, :default => 1
  8. create_table :signatures do |t|
  9. t.column :name, :string, :limit => 100, :null => false
  10. t.column :body, :string, :limit => 5000, :null => true
  11. t.column :active, :boolean, :null => false, :default => true
  12. t.column :note, :string, :limit => 250, :null => true
  13. t.column :created_by_id, :integer, :null => false
  14. t.timestamps
  15. end
  16. add_index :signatures, [:name], :unique => true
  17. end
  18. def down
  19. end
  20. end