Class: AddFieldsToQueryservers

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/six-updater-web/db/migrate/20100404150547_add_fields_to_queryservers.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



29
30
31
32
33
34
 
# File 'lib/six-updater-web/db/migrate/20100404150547_add_fields_to_queryservers.rb', line 29

def self.down
  [:mod, :players, :signatures, :numplayers, :gamestate, :language, :ping, :difficulty, :gamever, :gametype, :gamemode, :mission, :mapname, :country, :platform, :sv_battleye, :verifysignatures, :password, :dedicated, :favorite].each do |c|
    remove_column :queryservers, c
  end
  add_column :queryservers, :content, :text, :limit => 1024*1024
end

.up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'lib/six-updater-web/db/migrate/20100404150547_add_fields_to_queryservers.rb', line 2

def self.up
  remove_column :queryservers, :content
  add_column :queryservers, :mod, :text, :limit => 1024*1024
  add_column :queryservers, :players, :text, :limit => 1024*1024
  add_column :queryservers, :signatures, :text, :limit => 1024*1024

  add_column :queryservers, :numplayers, :integer, :default => 0
  add_column :queryservers, :gamestate, :integer
  add_column :queryservers, :language, :integer
  add_column :queryservers, :ping, :integer
  add_column :queryservers, :difficulty, :integer

  add_column :queryservers, :gamever, :string
  add_column :queryservers, :gametype, :string
  add_column :queryservers, :gamemode, :string
  add_column :queryservers, :mission, :string
  add_column :queryservers, :mapname, :string
  add_column :queryservers, :country, :string
  add_column :queryservers, :platform, :string

  add_column :queryservers, :sv_battleye, :boolean
  add_column :queryservers, :verifysignatures, :boolean
  add_column :queryservers, :password, :boolean
  add_column :queryservers, :dedicated, :boolean
  add_column :queryservers, :favorite, :boolean
end