diff options
author | rhenium <re4k@re4k.info> | 2013-06-08 15:51:52 +0900 |
---|---|---|
committer | rhenium <re4k@re4k.info> | 2013-06-08 15:51:52 +0900 |
commit | a65289978b369814d1066258b942a67a7af664ee (patch) | |
tree | 2e94054c77149e4b037ad383927d8ce885934a51 /config | |
parent | 4de8912eea9c89df22b4ed93ebd911b2dc1a9319 (diff) | |
download | aclog-a65289978b369814d1066258b942a67a7af664ee.tar.gz |
fix database config/utf8mb4
Diffstat (limited to 'config')
-rw-r--r-- | config/environment.rb | 3 | ||||
-rw-r--r-- | config/initializers/ar_innodb_row_format.rb | 16 | ||||
-rw-r--r-- | config/initializers/ar_mysql.rb | 9 |
3 files changed, 9 insertions, 19 deletions
diff --git a/config/environment.rb b/config/environment.rb index a5a567a..a7ed809 100644 --- a/config/environment.rb +++ b/config/environment.rb @@ -1,9 +1,6 @@ # Load the rails application. require File.expand_path('../application', __FILE__) -require 'active_record/connection_adapters/mysql2_adapter' -ActiveRecord::ConnectionAdapters::Mysql2Adapter::NATIVE_DATABASE_TYPES[:primary_key] = "BIGINT UNSIGNED DEFAULT NULL auto_increment PRIMARY KEY" - # Initialize the rails application. Aclog::Application.initialize! diff --git a/config/initializers/ar_innodb_row_format.rb b/config/initializers/ar_innodb_row_format.rb deleted file mode 100644 index f6b88e1..0000000 --- a/config/initializers/ar_innodb_row_format.rb +++ /dev/null @@ -1,16 +0,0 @@ -# http://qiita.com/items/101aaf8159cf1470d823 -ActiveSupport.on_load :active_record do - module ActiveRecord::ConnectionAdapters - - class AbstractMysqlAdapter - def create_table_with_innodb_row_format(table_name, options = {}) - table_options = options.reverse_merge(:options => 'ENGINE=InnoDB ROW_FORMAT=DYNAMIC') - create_table_without_innodb_row_format(table_name, table_options) do |td| - yield td if block_given? - end - end - alias_method_chain :create_table, :innodb_row_format - end - - end -end diff --git a/config/initializers/ar_mysql.rb b/config/initializers/ar_mysql.rb new file mode 100644 index 0000000..761e531 --- /dev/null +++ b/config/initializers/ar_mysql.rb @@ -0,0 +1,9 @@ +require 'active_record/connection_adapters/mysql2_adapter' + +# MySQL / change primary_key from INT to BIGINT +ActiveRecord::ConnectionAdapters::Mysql2Adapter::NATIVE_DATABASE_TYPES[:primary_key] = "BIGINT UNSIGNED DEFAULT NULL auto_increment PRIMARY KEY" + +# MySQL / utf8mb4 +ActiveRecord::Base.connection.initialize_schema_migrations_table + + |