config/activerecord_config: make primary key config portable

2 files changed, 18 insertions, 7 deletions

diff --git a/config/initializers/activerecord_config.rb b/config/initializers/activerecord_config.rb
new file mode 100644
index 0000000..0ebb675
--- /dev/null
+++ b/config/initializers/activerecord_config.rb
@@ -0,0 +1,18 @@
+begin
+  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"
+rescue LoadError
+end
+
+begin
+  require "active_record/connection_adapters/postgresql_adapter"
+
+  # PostgreSQL / change primary_key from INT to BIGINT
+  ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::NATIVE_DATABASE_TYPES[:primary_key] = "bigserial primary key"
+rescue LoadError
+end
+
+# MySQL / utf8mb4
+ActiveRecord::Base.connection.initialize_schema_migrations_table
diff --git a/config/initializers/ar_mysql.rb b/config/initializers/ar_mysql.rb
deleted file mode 100644
index 346e382..0000000
--- a/config/initializers/ar_mysql.rb
+++ /dev/null
@@ -1,7 +0,0 @@
-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