Contents

class AddTitleToUsers < ActiveRecord::Migration[6.0]
  def up
    execute "ALTER TABLE users ADD title VARCHAR(250) AS (CONCAT(name, ' ', surname, ' (', email, ')'));"
    execute "ALTER TABLE users ADD fi VARCHAR(250) AS (CONCAT(name, ' ', surname));"
  end
  def down
    execute "ALTER TABLE users DROP fi;"
    execute "ALTER TABLE users DROP title;"
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
anoubis-1.0.12	db/migrate/20181018115737_add_title_to_users.rb
anoubis-1.0.11	db/migrate/20181018115737_add_title_to_users.rb
anoubis-1.0.10	db/migrate/20181018115737_add_title_to_users.rb
anoubis-1.0.8	db/migrate/20181018115737_add_title_to_users.rb
anoubis-1.0.7	db/migrate/20181018115737_add_title_to_users.rb
anoubis-1.0.1	db/migrate/20181018115737_add_title_to_users.rb
anoubis-1.0.0	db/migrate/20181018115737_add_title_to_users.rb