Revision 7e3f8fb5
Added by Telmo X almost 12 years ago
- ID 7e3f8fb5796cfad05d92909cecf0d04816d688c1
| db/migrate/20090915030726_change_report_field_type_to_text.rb | ||
|---|---|---|
|
class ChangeReportFieldTypeToText < ActiveRecord::Migration
|
||
|
def self.up
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute "ALTER TABLE reports MODIFY log text;"
|
||
|
end
|
||
|
end
|
||
|
|
||
|
def self.down
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
change_column :reports, :log, :text, :limit => 50.kilobytes, :null => false
|
||
|
end
|
||
|
end
|
||
| db/migrate/20100115021803_change_mysql_reports_column.rb | ||
|---|---|---|
|
class ChangeMysqlReportsColumn < ActiveRecord::Migration
|
||
|
def self.up
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute "ALTER TABLE reports MODIFY log mediumtext;"
|
||
|
end
|
||
|
end
|
||
|
|
||
|
def self.down
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute "ALTER TABLE reports MODIFY log text;"
|
||
|
end
|
||
|
end
|
||
| db/migrate/20100325142616_update_fact_names_and_values_to_bin.rb | ||
|---|---|---|
|
class UpdateFactNamesAndValuesToBin < ActiveRecord::Migration
|
||
|
def self.up
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute %{ALTER TABLE fact_names MODIFY name varchar(255) COLLATE utf8_bin NOT NULL}
|
||
|
execute %{ALTER TABLE fact_values MODIFY value varchar(255) COLLATE utf8_bin NOT NULL}
|
||
|
end
|
||
|
end
|
||
|
|
||
|
def self.down
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute %{ALTER TABLE fact_names MODIFY name varchar(255)}
|
||
|
execute %{ALTER TABLE fact_values MODIFY value varchar(255)}
|
||
|
end
|
||
| db/migrate/20101018120548_create_messages.rb | ||
|---|---|---|
|
create_table :messages do |t|
|
||
|
t.text :value
|
||
|
end
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute "ALTER TABLE messages ENGINE = MYISAM"
|
||
|
execute "ALTER TABLE messages ADD FULLTEXT (value)"
|
||
|
else
|
||
| db/migrate/20101018120603_create_sources.rb | ||
|---|---|---|
|
create_table :sources do |t|
|
||
|
t.text :value
|
||
|
end
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute "ALTER TABLE sources ENGINE = MYISAM"
|
||
|
execute "ALTER TABLE sources ADD FULLTEXT (value)"
|
||
|
else
|
||
| db/migrate/20110321070954_revert_face_names_and_values_to_text_records.rb | ||
|---|---|---|
|
class RevertFaceNamesAndValuesToTextRecords < ActiveRecord::Migration
|
||
|
def self.up
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute "ALTER TABLE fact_values MODIFY value text COLLATE utf8_bin NOT NULL;"
|
||
|
end
|
||
|
end
|
||
|
|
||
|
def self.down
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
||
|
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql" or ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql2"
|
||
|
execute %{ALTER TABLE fact_values MODIFY value varchar(255) COLLATE utf8_bin NOT NULL}
|
||
|
end
|
||
|
end
|
||
Also available in: Unified diff
Fixed migrations for mysql2