diff options
| -rw-r--r-- | db/migrate/030_add_some_indices.rb | 23 | ||||
| -rw-r--r-- | db/migrate/036_add_public_body_tags.rb | 6 | ||||
| -rw-r--r-- | db/migrate/037_add_url_name.rb | 5 | ||||
| -rw-r--r-- | db/migrate/038_add_more_url_names.rb | 5 | ||||
| -rw-r--r-- | db/migrate/039_request_url_names.rb | 5 | ||||
| -rw-r--r-- | db/migrate/042_unique_user_urls.rb | 14 |
6 files changed, 43 insertions, 15 deletions
diff --git a/db/migrate/030_add_some_indices.rb b/db/migrate/030_add_some_indices.rb index 505dc0a57..066fc29cb 100644 --- a/db/migrate/030_add_some_indices.rb +++ b/db/migrate/030_add_some_indices.rb @@ -5,7 +5,10 @@ class AddSomeIndices < ActiveRecord::Migration end add_index :info_requests, :created_at - add_index :info_requests, :title # For checking duplicates at new request time + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + add_index :info_requests, :title # For checking duplicates at new request time + end if ActiveRecord::Base.connection.adapter_name == "PostgreSQL" execute "create index public_bodies_url_short_name_index on public_bodies(regexp_replace(replace(lower(short_name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))" @@ -13,9 +16,11 @@ class AddSomeIndices < ActiveRecord::Migration execute "create index users_url_name_index on users (regexp_replace(replace(lower(name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))" end - add_index :post_redirects, :email_token - add_index :post_redirects, :token - + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + add_index :post_redirects, :email_token + add_index :post_redirects, :token + end end def self.down @@ -24,7 +29,9 @@ class AddSomeIndices < ActiveRecord::Migration end remove_index :info_requests, :created_at - remove_index :info_requests, :title + if ActiveRecord::Base.connection.adapter_name != "MySQL" + remove_index :info_requests, :title + end if ActiveRecord::Base.connection.adapter_name == "PostgreSQL" execute 'drop index users_url_name_index' @@ -32,7 +39,9 @@ class AddSomeIndices < ActiveRecord::Migration execute 'drop index public_body_versions_url_short_name_index' end - remove_index :post_redirects, :email_token - remove_index :post_redirects, :token + if ActiveRecord::Base.connection.adapter_name != "MySQL" + remove_index :post_redirects, :email_token + remove_index :post_redirects, :token + end end end diff --git a/db/migrate/036_add_public_body_tags.rb b/db/migrate/036_add_public_body_tags.rb index c891f8fc3..9790f9c0b 100644 --- a/db/migrate/036_add_public_body_tags.rb +++ b/db/migrate/036_add_public_body_tags.rb @@ -9,7 +9,11 @@ class AddPublicBodyTags < ActiveRecord::Migration if ActiveRecord::Base.connection.adapter_name == "PostgreSQL" execute "ALTER TABLE public_body_tags ADD CONSTRAINT fk_public_body_tags_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)" end - add_index :public_body_tags, [:public_body_id, :name], :unique => true + + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + add_index :public_body_tags, [:public_body_id, :name], :unique => true + end end def self.down diff --git a/db/migrate/037_add_url_name.rb b/db/migrate/037_add_url_name.rb index 0a667e0d3..84aad9cc8 100644 --- a/db/migrate/037_add_url_name.rb +++ b/db/migrate/037_add_url_name.rb @@ -7,7 +7,10 @@ class AddUrlName < ActiveRecord::Migration public_body.update_url_name public_body.save! end - add_index :public_bodies, :url_name, :unique => true + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + add_index :public_bodies, :url_name, :unique => true + end change_column :public_bodies, :url_name, :text, :null => false end diff --git a/db/migrate/038_add_more_url_names.rb b/db/migrate/038_add_more_url_names.rb index d3dc2e669..9798f4b4b 100644 --- a/db/migrate/038_add_more_url_names.rb +++ b/db/migrate/038_add_more_url_names.rb @@ -6,7 +6,10 @@ class AddMoreUrlNames < ActiveRecord::Migration user.update_url_name user.save! end - add_index :users, :url_name + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + add_index :users, :url_name + end change_column :users, :url_name, :text, :null => false end diff --git a/db/migrate/039_request_url_names.rb b/db/migrate/039_request_url_names.rb index 0572cab7e..5227b887a 100644 --- a/db/migrate/039_request_url_names.rb +++ b/db/migrate/039_request_url_names.rb @@ -6,7 +6,10 @@ class RequestUrlNames < ActiveRecord::Migration info_request.update_url_title info_request.save! end - add_index :info_requests, :url_title, :unique => true + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + add_index :info_requests, :url_title, :unique => true + end change_column :info_requests, :url_title, :text, :null => false end diff --git a/db/migrate/042_unique_user_urls.rb b/db/migrate/042_unique_user_urls.rb index 1350d1580..45e4fd11d 100644 --- a/db/migrate/042_unique_user_urls.rb +++ b/db/migrate/042_unique_user_urls.rb @@ -5,13 +5,19 @@ class UniqueUserUrls < ActiveRecord::Migration user.update_url_name user.save! end - remove_index :users, :url_name - add_index :users, :url_name, :unique => true + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + remove_index :users, :url_name + add_index :users, :url_name, :unique => true + end end def self.down - remove_index :users, :url_name - add_index :users, :url_name, :unique => false + # MySQL cannot index text blobs like this + if ActiveRecord::Base.connection.adapter_name != "MySQL" + remove_index :users, :url_name + add_index :users, :url_name, :unique => false + end end end |