Sha256: 9dfa4c2ece9d5cf132a657b5c123730611b6ee2274a4156bf6a54b5de689e05b

Contents?: true

Size: 365 Bytes

Versions: 7

Compression:

Stored size: 365 Bytes

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